Spaces:
Sleeping
Sleeping
Download CollaborationService/organization.py from dellweb3/workos-office: direct link, hf CLI and curl.
- Browser
- Download file 4.89 kB
-
https://huggingface.co/spaces/dellweb3/workos-office/resolve/main/CollaborationService/organization.py
- Command line
-
hf download hf://spaces/dellweb3/workos-office/CollaborationService/organization.py
-
curl -L -o organization.py https://huggingface.co/spaces/dellweb3/workos-office/resolve/main/CollaborationService/organization.py
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','员工账号已停用。') | |
| 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']))) | |