dellweb3's picture
Work OS validated demo local-v0.8
99caad5 verified
Raw History Blame Contribute Delete
4.89 kB
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'])))