from sqlalchemy import select, delete, update from KnowledgeService.models import Base, KnowledgeBase, LibraryConfig from APIGateway.app.errors import GatewayError from .models import Employee, Group, Membership, GroupGrant,OrganizationAudit import uuid class Organization: mode='sql-persistent' def __init__(self,workspace): self.Session=workspace.Session import os if os.getenv('WORKOS_WORKSPACE_AUTO_SCHEMA','1')=='1':Base.metadata.create_all(workspace.engine) with self.Session.begin() as db: for uid,name in [('u-lin','林晓'),('u-zhou','周宁'),('u-admin','系统管理员')]: if not db.get(Employee,('demo-tenant',uid)):db.add(Employee(tenant='demo-tenant',user_id=uid,name=name,status='enabled')) def check(self,user): with self.Session() as db: row=db.get(Employee,(user['tenant_id'],user['user_id'])) if row and row.status!='enabled':raise GatewayError(403,'EMPLOYEE_DISABLED','员工账号已停用。') @staticmethod def admin(user): if 'admin' not in user.get('roles',[]):raise GatewayError(403,'ADMIN_REQUIRED','需要管理员权限。') def view(self,user,admin=False): if admin:self.admin(user) tenant=user['tenant_id'] with self.Session() as db: members=list(db.scalars(select(Membership).where(Membership.tenant==tenant))) groups=list(db.scalars(select(Group).where(Group.tenant==tenant))) grants=list(db.scalars(select(GroupGrant).where(GroupGrant.tenant==tenant))) visible={m.group_id for m in members if m.user_id==user['user_id']} return {'employees':[{'user_id':e.user_id,'name':e.name,'status':e.status,'group_ids':[m.group_id for m in members if m.user_id==e.user_id]} for e in db.scalars(select(Employee).where(Employee.tenant==tenant)) if admin or e.user_id==user['user_id']], 'groups':[{'group_id':g.id,'name':g.name,'description':g.description,'revision':g.revision,'members':[{'user_id':m.user_id,'role':m.role} for m in members if m.group_id==g.id],'base_ids':[x.base_id for x in grants if x.group_id==g.id]} for g in groups if admin or g.id in visible]} def save(self,user,data,gid=None): self.admin(user);tenant=user['tenant_id'];members=data.get('members',[]);bases=data.get('base_ids',[]) if len({m['user_id'] for m in members})!=len(members):raise GatewayError(422,'DUPLICATE_MEMBER','同一工作组内员工不能重复。') with self.Session.begin() as db: if any(db.get(Employee,(tenant,m['user_id'])) is None for m in members):raise GatewayError(404,'EMPLOYEE_NOT_FOUND','员工不存在。') for bid in bases: b=db.get(KnowledgeBase,(tenant,bid)) if not b or b.visibility!='shared':raise GatewayError(422,'INVALID_GROUP_GRANT','工作组仅可授权当前租户共享知识库。') old=db.get(Group,(tenant,gid)) if gid else None if gid and not old:raise GatewayError(404,'GROUP_NOT_FOUND','工作组不存在。') if old: revision=data.get('expected_revision') count=db.execute(update(Group).where(Group.tenant==tenant,Group.id==gid,Group.revision==revision).values(name=data['name'],description=data.get('description',''),revision=Group.revision+1)).rowcount if count!=1:raise GatewayError(409,'VERSION_CONFLICT','工作组已变化,请刷新。') db.execute(delete(Membership).where(Membership.tenant==tenant,Membership.group_id==gid));db.execute(delete(GroupGrant).where(GroupGrant.tenant==tenant,GroupGrant.group_id==gid)) else: gid='group-'+uuid.uuid4().hex[:20];db.add(Group(tenant=tenant,id=gid,name=data['name'],description=data.get('description',''),revision=1));db.flush() for m in members:db.add(Membership(tenant=tenant,group_id=gid,user_id=m['user_id'],role=m.get('role','member'))) for bid in set(bases):db.add(GroupGrant(tenant=tenant,group_id=gid,base_id=bid)) from datetime import datetime,timezone db.add(OrganizationAudit(id='orgaudit-'+uuid.uuid4().hex,tenant=tenant,actor=user['user_id'],group_id=gid,action='group.update' if old else 'group.create',detail={'members':members,'base_ids':bases},created_at=datetime.now(timezone.utc).isoformat())) return next(g for g in self.view(user,True)['groups'] if g['group_id']==gid) def allowed_bases(self,user): self.check(user) with self.Session() as db: return set(db.scalars(select(GroupGrant.base_id).join(Membership,(GroupGrant.tenant==Membership.tenant)&(GroupGrant.group_id==Membership.group_id)).where(Membership.tenant==user['tenant_id'],Membership.user_id==user['user_id'])))