tenant.py 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174
  1. """租户 CRUD(sys_tenant)"""
  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.config import settings
  9. from app.core.delete_guard import assert_row_deletable_by_creator
  10. from app.core.utils import generate_uuid
  11. from app.models.models import SysTenant
  12. def _row_to_dict(t: SysTenant) -> Dict[str, Any]:
  13. return {
  14. "id": t.id,
  15. "tenantNo": t.tenant_no,
  16. "tenantName": t.tenant_name,
  17. "contactName": t.contact_name or "",
  18. "contactPhone": t.contact_phone or "",
  19. "orderNum": t.order_num if t.order_num is not None else 0,
  20. "remark": t.remark or "",
  21. "createBy": t.create_by or "",
  22. "createTime": t.create_time.strftime("%Y-%m-%d %H:%M:%S") if t.create_time else "",
  23. "updateTime": t.update_time.strftime("%Y-%m-%d %H:%M:%S") if t.update_time else "",
  24. }
  25. def list_tenants(
  26. db: Session,
  27. *,
  28. page: int = 1,
  29. page_size: int = 10,
  30. keyword: Optional[str] = None,
  31. user_info=None,
  32. ) -> Tuple[List[Dict[str, Any]], int]:
  33. def _filtered():
  34. q0 = db.query(SysTenant).filter(SysTenant.del_flag == 0)
  35. kw = (keyword or "").strip()
  36. if kw:
  37. like = f"%{kw}%"
  38. q0 = q0.filter(or_(SysTenant.tenant_no.like(like), SysTenant.tenant_name.like(like)))
  39. if user_info:
  40. from app.core.data_scope import apply_data_scope
  41. q0 = apply_data_scope(q0, SysTenant, user_info, db)
  42. return q0
  43. total = _filtered().order_by(None).with_entities(func.count(SysTenant.id)).scalar() or 0
  44. page = max(1, page)
  45. page_size = min(max(1, page_size), 100)
  46. rows = (
  47. _filtered()
  48. .order_by(SysTenant.create_time.desc())
  49. .offset((page - 1) * page_size)
  50. .limit(page_size)
  51. .all()
  52. )
  53. return [_row_to_dict(x) for x in rows], int(total)
  54. def get_tenant(db: Session, tenant_id: str) -> Optional[SysTenant]:
  55. return (
  56. db.query(SysTenant)
  57. .filter(and_(SysTenant.id == tenant_id, SysTenant.del_flag == 0))
  58. .first()
  59. )
  60. def tenant_no_exists(db: Session, tenant_no: str, exclude_id: Optional[str] = None) -> bool:
  61. q = db.query(SysTenant).filter(and_(SysTenant.tenant_no == tenant_no.strip(), SysTenant.del_flag == 0))
  62. if exclude_id:
  63. q = q.filter(SysTenant.id != exclude_id)
  64. return q.first() is not None
  65. def create_tenant(
  66. db: Session,
  67. *,
  68. tenant_no: str,
  69. tenant_name: str,
  70. contact_name: Optional[str] = None,
  71. contact_phone: Optional[str] = None,
  72. order_num: Optional[int] = None,
  73. remark: Optional[str] = None,
  74. user_id: Optional[str] = None,
  75. ) -> SysTenant:
  76. tn = (tenant_no or "").strip()
  77. if not tn:
  78. raise ValueError("租户编号不能为空")
  79. if tenant_no_exists(db, tn):
  80. raise ValueError("租户编号已存在")
  81. obj = SysTenant(
  82. id=generate_uuid(),
  83. tenant_no=tn,
  84. tenant_name=(tenant_name or "").strip() or tn,
  85. contact_name=(contact_name or "").strip() or None,
  86. contact_phone=(contact_phone or "").strip() or None,
  87. order_num=order_num if order_num is not None else 0,
  88. remark=(remark or "").strip() or None,
  89. create_by=user_id,
  90. create_dept_id="",
  91. create_time=datetime.now(),
  92. update_by=user_id,
  93. update_time=datetime.now(),
  94. del_flag=0,
  95. )
  96. db.add(obj)
  97. db.commit()
  98. db.refresh(obj)
  99. return obj
  100. def update_tenant(
  101. db: Session,
  102. tenant_id: str,
  103. *,
  104. tenant_no: Optional[str] = None,
  105. tenant_name: Optional[str] = None,
  106. contact_name: Optional[str] = None,
  107. contact_phone: Optional[str] = None,
  108. order_num: Optional[int] = None,
  109. remark: Optional[str] = None,
  110. user_id: Optional[str] = None,
  111. ) -> SysTenant:
  112. obj = get_tenant(db, tenant_id)
  113. if not obj:
  114. raise ValueError("租户不存在")
  115. if tenant_no is not None:
  116. new_no = tenant_no.strip()
  117. if not new_no:
  118. raise ValueError("租户编号不能为空")
  119. if obj.tenant_no == settings.DEFAULT_TENANT_NO and new_no != settings.DEFAULT_TENANT_NO:
  120. raise ValueError("默认租户编号不可修改")
  121. if new_no != obj.tenant_no and tenant_no_exists(db, new_no, exclude_id=tenant_id):
  122. raise ValueError("租户编号已存在")
  123. obj.tenant_no = new_no
  124. if tenant_name is not None:
  125. obj.tenant_name = (tenant_name or "").strip() or obj.tenant_name
  126. if contact_name is not None:
  127. obj.contact_name = (contact_name or "").strip() or None
  128. if contact_phone is not None:
  129. obj.contact_phone = (contact_phone or "").strip() or None
  130. if order_num is not None:
  131. obj.order_num = order_num
  132. if remark is not None:
  133. obj.remark = (remark or "").strip() or None
  134. obj.update_by = user_id
  135. obj.update_time = datetime.now()
  136. db.add(obj)
  137. db.commit()
  138. db.refresh(obj)
  139. return obj
  140. def soft_delete_tenant(db: Session, tenant_id: str, *, user_info: dict = None) -> None:
  141. obj = get_tenant(db, tenant_id)
  142. if not obj:
  143. raise ValueError("租户不存在")
  144. if obj.tenant_no == settings.DEFAULT_TENANT_NO:
  145. raise ValueError("默认租户不可删除")
  146. assert_row_deletable_by_creator(obj, user_info)
  147. obj.del_flag = 1
  148. obj.update_time = datetime.now()
  149. db.add(obj)
  150. db.commit()
  151. def total_pages(total: int, page_size: int) -> int:
  152. if total <= 0:
  153. return 0
  154. return int(math.ceil(total / float(page_size)))