role.py 9.4 KB

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