role.py 9.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291
  1. """角色 CRUD(sys_role / sys_role_menu / sys_role_data_scope_detail)"""
  2. from __future__ import annotations
  3. import math
  4. from datetime import datetime
  5. from typing import Any, Dict, List, Optional, Tuple
  6. from sqlalchemy import and_, func, or_
  7. from sqlalchemy.orm import Session
  8. from app.core.utils import generate_uuid
  9. from app.models.models import SysRole, SysRoleMenu, SysRoleDataScopeDetail
  10. # ---------------------------------------------------------------------------
  11. # helpers
  12. # ---------------------------------------------------------------------------
  13. def _row_to_dict(r: SysRole) -> Dict[str, Any]:
  14. return {
  15. "id": r.id,
  16. "roleName": r.role_name,
  17. "dataScope": r.data_scope or "1",
  18. "status": r.status or "1",
  19. "tenantNo": r.tenant_no or "",
  20. "orderNum": r.order_num if r.order_num is not None else 0,
  21. "remark": r.remark or "",
  22. "createTime": r.create_time.strftime("%Y-%m-%d %H:%M:%S") if r.create_time else "",
  23. "updateTime": r.update_time.strftime("%Y-%m-%d %H:%M:%S") if r.update_time else "",
  24. }
  25. def total_pages(total: int, page_size: int) -> int:
  26. if total <= 0:
  27. return 0
  28. return int(math.ceil(total / float(page_size)))
  29. # ---------------------------------------------------------------------------
  30. # list / get
  31. # ---------------------------------------------------------------------------
  32. def list_roles(
  33. db: Session,
  34. *,
  35. page: int = 1,
  36. page_size: int = 10,
  37. keyword: Optional[str] = None,
  38. tenant_no: Optional[str] = None,
  39. user_info=None,
  40. ) -> Tuple[List[Dict[str, Any]], int]:
  41. def _filtered():
  42. q0 = db.query(SysRole).filter(SysRole.del_flag == 0)
  43. if tenant_no:
  44. q0 = q0.filter(SysRole.tenant_no == tenant_no)
  45. kw = (keyword or "").strip()
  46. if kw:
  47. like = f"%{kw}%"
  48. q0 = q0.filter(SysRole.role_name.like(like))
  49. if user_info:
  50. from app.core.data_scope import apply_data_scope
  51. q0 = apply_data_scope(q0, SysRole, user_info, db, tenant_no)
  52. return q0
  53. total = _filtered().order_by(None).with_entities(func.count(SysRole.id)).scalar() or 0
  54. page = max(1, page)
  55. page_size = min(max(1, page_size), 100)
  56. rows = (
  57. _filtered()
  58. .order_by(SysRole.create_time.desc())
  59. .offset((page - 1) * page_size)
  60. .limit(page_size)
  61. .all()
  62. )
  63. return [_row_to_dict(x) for x in rows], int(total)
  64. def get_role(db: Session, role_id: str) -> Optional[SysRole]:
  65. return (
  66. db.query(SysRole)
  67. .filter(and_(SysRole.id == role_id, SysRole.del_flag == 0))
  68. .first()
  69. )
  70. def role_name_exists(db: Session, name: str, tenant_no: str, exclude_id: Optional[str] = None) -> bool:
  71. q = db.query(SysRole).filter(
  72. and_(SysRole.role_name == name.strip(), SysRole.tenant_no == tenant_no, SysRole.del_flag == 0)
  73. )
  74. if exclude_id:
  75. q = q.filter(SysRole.id != exclude_id)
  76. return q.first() is not None
  77. # ---------------------------------------------------------------------------
  78. # create / update / delete
  79. # ---------------------------------------------------------------------------
  80. def create_role(
  81. db: Session,
  82. *,
  83. role_name: str,
  84. data_scope: str = "4",
  85. status: str = "1",
  86. tenant_no: str = "zkxw",
  87. order_num: Optional[int] = None,
  88. remark: Optional[str] = None,
  89. user_id: Optional[str] = None,
  90. ) -> SysRole:
  91. rn = (role_name or "").strip()
  92. if not rn:
  93. raise ValueError("角色名称不能为空")
  94. if role_name_exists(db, rn, tenant_no):
  95. raise ValueError("角色名称已存在")
  96. obj = SysRole(
  97. id=generate_uuid(),
  98. role_name=rn,
  99. data_scope=data_scope,
  100. status=status,
  101. tenant_no=tenant_no,
  102. order_num=order_num if order_num is not None else 0,
  103. remark=(remark or "").strip() or None,
  104. create_by=user_id,
  105. create_dept_id="",
  106. create_time=datetime.now(),
  107. update_by=user_id,
  108. update_time=datetime.now(),
  109. del_flag=0,
  110. )
  111. db.add(obj)
  112. db.commit()
  113. db.refresh(obj)
  114. return obj
  115. def update_role(
  116. db: Session,
  117. role_id: str,
  118. *,
  119. role_name: Optional[str] = None,
  120. data_scope: Optional[str] = None,
  121. status: Optional[str] = None,
  122. order_num: Optional[int] = None,
  123. remark: Optional[str] = None,
  124. user_id: Optional[str] = None,
  125. ) -> SysRole:
  126. obj = get_role(db, role_id)
  127. if not obj:
  128. raise ValueError("角色不存在")
  129. if role_name is not None:
  130. rn = role_name.strip()
  131. if not rn:
  132. raise ValueError("角色名称不能为空")
  133. if rn != obj.role_name and role_name_exists(db, rn, obj.tenant_no, exclude_id=role_id):
  134. raise ValueError("角色名称已存在")
  135. obj.role_name = rn
  136. if data_scope is not None:
  137. obj.data_scope = data_scope
  138. if status is not None:
  139. obj.status = status
  140. if order_num is not None:
  141. obj.order_num = order_num
  142. if remark is not None:
  143. obj.remark = (remark or "").strip() or None
  144. obj.update_by = user_id
  145. obj.update_time = datetime.now()
  146. db.add(obj)
  147. db.commit()
  148. db.refresh(obj)
  149. return obj
  150. def soft_delete_role(db: Session, role_id: str) -> None:
  151. obj = get_role(db, role_id)
  152. if not obj:
  153. raise ValueError("角色不存在")
  154. obj.del_flag = 1
  155. obj.update_time = datetime.now()
  156. db.add(obj)
  157. # cascade soft-delete role_menu and role_data_scope_detail
  158. db.query(SysRoleMenu).filter(
  159. and_(SysRoleMenu.role_id == role_id, SysRoleMenu.del_flag == 0)
  160. ).update({"del_flag": 1, "update_time": datetime.now()})
  161. db.query(SysRoleDataScopeDetail).filter(
  162. and_(SysRoleDataScopeDetail.role_id == role_id, SysRoleDataScopeDetail.del_flag == 0)
  163. ).update({"del_flag": 1, "update_time": datetime.now()})
  164. db.commit()
  165. # ---------------------------------------------------------------------------
  166. # role-menu
  167. # ---------------------------------------------------------------------------
  168. def get_role_menu_ids(db: Session, role_id: str) -> List[str]:
  169. rows = (
  170. db.query(SysRoleMenu.menu_id)
  171. .filter(and_(SysRoleMenu.role_id == role_id, SysRoleMenu.del_flag == 0))
  172. .all()
  173. )
  174. return [r.menu_id for r in rows]
  175. def update_role_menus(
  176. db: Session,
  177. role_id: str,
  178. menu_ids: List[str],
  179. tenant_no: str,
  180. user_id: Optional[str] = None,
  181. ) -> None:
  182. # uk_role_menu 为 (role_id, menu_id, del_flag):先全量软删再插入会在再次保存时
  183. # 出现两条 (role_id, menu_id, del_flag=1),触发 1062。关联表采用整角色物理清理后重建。
  184. unique_ids = list(dict.fromkeys(menu_ids or []))
  185. db.query(SysRoleMenu).filter(SysRoleMenu.role_id == role_id).delete(synchronize_session=False)
  186. now = datetime.now()
  187. for mid in unique_ids:
  188. obj = SysRoleMenu(
  189. id=generate_uuid(),
  190. role_id=role_id,
  191. menu_id=mid,
  192. tenant_no=tenant_no,
  193. order_num=0,
  194. create_by=user_id,
  195. create_dept_id="",
  196. create_time=now,
  197. update_by=user_id,
  198. update_time=now,
  199. del_flag=0,
  200. )
  201. db.add(obj)
  202. db.commit()
  203. # ---------------------------------------------------------------------------
  204. # role data-scope
  205. # ---------------------------------------------------------------------------
  206. def get_role_data_scope(db: Session, role_id: str) -> List[Dict[str, str]]:
  207. rows = (
  208. db.query(SysRoleDataScopeDetail)
  209. .filter(and_(SysRoleDataScopeDetail.role_id == role_id, SysRoleDataScopeDetail.del_flag == 0))
  210. .all()
  211. )
  212. return [{"scopeType": r.scope_type, "scopeValue": r.scope_value} for r in rows]
  213. def update_role_data_scope(
  214. db: Session,
  215. role_id: str,
  216. data_scope: str,
  217. scope_details: Optional[List[Dict[str, str]]] = None,
  218. tenant_no: str = "zkxw",
  219. user_id: Optional[str] = None,
  220. ) -> None:
  221. obj = get_role(db, role_id)
  222. if not obj:
  223. raise ValueError("角色不存在")
  224. obj.data_scope = data_scope
  225. obj.update_by = user_id
  226. obj.update_time = datetime.now()
  227. db.add(obj)
  228. # soft-delete old scope details
  229. db.query(SysRoleDataScopeDetail).filter(
  230. and_(SysRoleDataScopeDetail.role_id == role_id, SysRoleDataScopeDetail.del_flag == 0)
  231. ).update({"del_flag": 1, "update_time": datetime.now()})
  232. # insert new scope details (only when custom data_scope == '5')
  233. if data_scope == "5" and scope_details:
  234. now = datetime.now()
  235. for detail in scope_details:
  236. sd = SysRoleDataScopeDetail(
  237. id=generate_uuid(),
  238. role_id=role_id,
  239. scope_type=detail.get("scopeType", "dept"),
  240. scope_value=detail.get("scopeValue", ""),
  241. tenant_no=tenant_no,
  242. order_num=0,
  243. create_by=user_id,
  244. create_dept_id="",
  245. create_time=now,
  246. update_by=user_id,
  247. update_time=now,
  248. del_flag=0,
  249. )
  250. db.add(sd)
  251. db.commit()