admin.py 58 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716
  1. """运营端管理接口(租户、角色下拉等)"""
  2. import os
  3. import uuid
  4. from datetime import datetime
  5. from typing import Any, List, Optional
  6. from fastapi import APIRouter, Depends, HTTPException, Query, UploadFile, File, Form
  7. from pydantic import BaseModel, ConfigDict, Field
  8. from sqlalchemy import and_, or_
  9. from sqlalchemy.orm import Session
  10. from app.core.config import settings
  11. from app.core.data_scope import apply_data_scope, assert_row_in_data_scope
  12. from app.core.database import get_db
  13. from app.core.menu_guard import require_admin_or_super_admin, require_menu_code
  14. from app.core.response import success_response, error_response
  15. from app.core.attachment_biz import resolve_upload_folder
  16. from app.core.storage import storage
  17. from app.crud import tenant as tenant_svc
  18. from app.crud import dict_type as dict_type_svc
  19. from app.crud import dict_data as dict_data_svc
  20. from app.services import dict_ensure as dict_ensure_svc
  21. from app.crud import dept as dept_svc
  22. from app.crud import site as site_svc
  23. from app.crud import post as post_svc
  24. from app.crud import menu as menu_svc
  25. from app.crud import role as role_svc
  26. from app.crud import user as user_svc
  27. from app.crud import role as role_svc
  28. from app.crud import user as user_svc
  29. from app.crud import oss as oss_svc
  30. from app.models.models import SysDept, SysDictData, SysRole, SysUser, SysUserRole
  31. from app.schemas.menu_favorite import (
  32. MenuFavoriteCreateBody,
  33. MenuFavoriteDeleteBody,
  34. MenuFavoriteReorderBody,
  35. )
  36. from app.services.web_auth_roles import _map_role_name_to_web
  37. from app.utils.excel_export import (
  38. ExportColumn,
  39. ExportValidationError,
  40. export_rows_to_xlsx_response,
  41. filter_export_columns,
  42. )
  43. router = APIRouter(prefix="/web/admin", tags=["运营端管理"])
  44. # ---------------------------------------------------------------------------
  45. # 角色下拉(用户弹窗等)
  46. # ---------------------------------------------------------------------------
  47. @router.get("/roles")
  48. def list_roles_for_select(
  49. _user: dict = Depends(require_admin_or_super_admin),
  50. db: Session = Depends(get_db),
  51. ):
  52. """返回运营端角色下拉选项(label=库中角色名,value=Web 角色码)。"""
  53. rows: List[SysRole] = (
  54. db.query(SysRole)
  55. .filter(SysRole.del_flag == 0, SysRole.status == "1")
  56. .order_by(SysRole.create_time.desc())
  57. .all()
  58. )
  59. seen: set[str] = set()
  60. out: List[dict] = []
  61. for r in rows:
  62. name = (r.role_name or "").strip()
  63. if not name:
  64. continue
  65. code = _map_role_name_to_web(name)
  66. key = f"{code}:{name}"
  67. if key in seen:
  68. continue
  69. seen.add(key)
  70. out.append({"label": name, "value": code})
  71. if not out:
  72. out = [
  73. {"label": "超级管理员", "value": "super_admin"},
  74. {"label": "运营管理员", "value": "admin"},
  75. ]
  76. return success_response(out)
  77. @router.get("/users/options")
  78. def list_users_for_select(
  79. user: dict = Depends(require_admin_or_super_admin),
  80. db: Session = Depends(get_db),
  81. ):
  82. """返回用户下拉选项(label=昵称,value=用户ID,附带 nickName/userNo)。
  83. 供申请人/审批人等选择场景使用,返回本租户全部有效用户,
  84. 不做业务数据范围过滤(否则「仅本人」角色会按 create_by 滤空,连自己都选不到)。
  85. """
  86. tenant_no = _get_tenant_no(db, user)
  87. q = db.query(SysUser).filter(SysUser.del_flag == 0, SysUser.status == "1")
  88. q = q.filter(SysUser.tenant_no == tenant_no)
  89. rows = q.order_by(SysUser.create_time.desc()).all()
  90. out = [
  91. {
  92. "label": (r.nick_name or r.user_no or ""),
  93. "value": r.id,
  94. "nickName": r.nick_name or "",
  95. "userNo": r.user_no or "",
  96. }
  97. for r in rows
  98. ]
  99. return success_response(out)
  100. @router.get("/roles/options")
  101. def list_roles_for_designer(
  102. user: dict = Depends(require_admin_or_super_admin),
  103. db: Session = Depends(get_db),
  104. ):
  105. """返回角色下拉选项(label=角色名,value=角色ID UUID),供流程设计器审批人选择使用。
  106. 与 /roles 不同,此端点返回角色 UUID 作为 value(引擎解析审批人需要 UUID)。
  107. 角色为租户级主数据选项,不做 create_by 数据范围过滤。
  108. """
  109. tenant_no = _get_tenant_no(db, user)
  110. q = db.query(SysRole).filter(SysRole.del_flag == 0, SysRole.status == "1")
  111. q = q.filter(SysRole.tenant_no == tenant_no)
  112. rows = q.order_by(SysRole.create_time.desc()).all()
  113. out = [{"label": (r.role_name or "").strip(), "value": r.id} for r in rows if (r.role_name or "").strip()]
  114. return success_response(out)
  115. # ---------------------------------------------------------------------------
  116. # 租户管理
  117. # ---------------------------------------------------------------------------
  118. class TenantCreateBody(BaseModel):
  119. model_config = ConfigDict(populate_by_name=True)
  120. tenant_no: str = Field(..., alias="tenantNo")
  121. tenant_name: str = Field(..., alias="tenantName")
  122. contact_name: Optional[str] = Field(None, alias="contactName")
  123. contact_phone: Optional[str] = Field(None, alias="contactPhone")
  124. order_num: Optional[int] = Field(0, alias="orderNum")
  125. remark: Optional[str] = None
  126. class TenantUpdateBody(BaseModel):
  127. model_config = ConfigDict(populate_by_name=True)
  128. tenant_no: Optional[str] = Field(None, alias="tenantNo")
  129. tenant_name: Optional[str] = Field(None, alias="tenantName")
  130. contact_name: Optional[str] = Field(None, alias="contactName")
  131. contact_phone: Optional[str] = Field(None, alias="contactPhone")
  132. order_num: Optional[int] = Field(None, alias="orderNum")
  133. remark: Optional[str] = None
  134. @router.get("/tenants")
  135. def list_tenants(
  136. page: int = Query(1, ge=1),
  137. pageSize: int = Query(10, ge=1, le=500, alias="pageSize"),
  138. keyword: Optional[str] = None,
  139. _user: dict = Depends(require_admin_or_super_admin),
  140. db: Session = Depends(get_db),
  141. ):
  142. items, total = tenant_svc.list_tenants(db, page=page, page_size=pageSize, keyword=keyword, user_info=_user)
  143. total_pages = tenant_svc.total_pages(total, pageSize)
  144. return success_response(
  145. {
  146. "list": items,
  147. "total": total,
  148. "page": page,
  149. "pageSize": pageSize,
  150. "totalPages": total_pages,
  151. }
  152. )
  153. @router.post("/tenants")
  154. def create_tenant(
  155. body: TenantCreateBody,
  156. user: dict = Depends(require_admin_or_super_admin),
  157. db: Session = Depends(get_db),
  158. ):
  159. try:
  160. obj = tenant_svc.create_tenant(
  161. db,
  162. tenant_no=body.tenant_no,
  163. tenant_name=body.tenant_name,
  164. contact_name=body.contact_name,
  165. contact_phone=body.contact_phone,
  166. order_num=body.order_num,
  167. remark=body.remark,
  168. user_id=user.get("user_id"),
  169. )
  170. return success_response(tenant_svc._row_to_dict(obj), message="创建成功")
  171. except ValueError as e:
  172. return error_response(400, str(e))
  173. @router.put("/tenants/{tenant_id}")
  174. def update_tenant(
  175. tenant_id: str,
  176. body: TenantUpdateBody,
  177. user: dict = Depends(require_admin_or_super_admin),
  178. db: Session = Depends(get_db),
  179. ):
  180. try:
  181. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  182. obj = tenant_svc.update_tenant(
  183. db,
  184. tenant_id,
  185. tenant_no=payload.get("tenant_no"),
  186. tenant_name=payload.get("tenant_name"),
  187. contact_name=payload.get("contact_name"),
  188. contact_phone=payload.get("contact_phone"),
  189. order_num=payload.get("order_num"),
  190. remark=payload.get("remark"),
  191. user_id=user.get("user_id"),
  192. )
  193. return success_response(tenant_svc._row_to_dict(obj), message="更新成功")
  194. except ValueError as e:
  195. return error_response(400, str(e))
  196. @router.delete("/tenants/{tenant_id}")
  197. def delete_tenant(
  198. tenant_id: str,
  199. _user: dict = Depends(require_admin_or_super_admin),
  200. db: Session = Depends(get_db),
  201. ):
  202. try:
  203. tenant_svc.soft_delete_tenant(db, tenant_id, user_info=_user)
  204. return success_response(None, message="删除成功")
  205. except ValueError as e:
  206. return error_response(400, str(e))
  207. # ---------------------------------------------------------------------------
  208. # Helper: resolve tenant_no from user context
  209. # ---------------------------------------------------------------------------
  210. def _get_tenant_no(db: Session, user: dict) -> str:
  211. user_id = user.get("user_id")
  212. if not user_id:
  213. return "shanxia2.0"
  214. sys_user = db.query(SysUser).filter(SysUser.id == user_id).first()
  215. return (sys_user.tenant_no if sys_user else None) or "shanxia2.0"
  216. # ---------------------------------------------------------------------------
  217. # 用户管理
  218. # ---------------------------------------------------------------------------
  219. class UserCreateBody(BaseModel):
  220. model_config = ConfigDict(populate_by_name=True)
  221. user_no: str = Field(..., alias="userNo")
  222. nick_name: str = Field(..., alias="nickName")
  223. password: str = Field(..., alias="password")
  224. dept_id: Optional[str] = Field(None, alias="deptId")
  225. email: Optional[str] = Field("", alias="email")
  226. phone_no: Optional[str] = Field("", alias="phoneNo")
  227. sex: Optional[str] = Field("0", alias="sex")
  228. avatar: Optional[str] = Field(None, alias="avatar")
  229. status: Optional[str] = Field("1", alias="status")
  230. order_num: Optional[int] = Field(None, alias="orderNum")
  231. remark: Optional[str] = None
  232. role_ids: Optional[List[str]] = Field(None, alias="roleIds")
  233. post_ids: Optional[List[str]] = Field(None, alias="postIds")
  234. class UserUpdateBody(BaseModel):
  235. model_config = ConfigDict(populate_by_name=True)
  236. nick_name: Optional[str] = Field(None, alias="nickName")
  237. dept_id: Optional[str] = Field(None, alias="deptId")
  238. email: Optional[str] = Field(None, alias="email")
  239. phone_no: Optional[str] = Field(None, alias="phoneNo")
  240. sex: Optional[str] = Field(None, alias="sex")
  241. avatar: Optional[str] = Field(None, alias="avatar")
  242. status: Optional[str] = Field(None, alias="status")
  243. order_num: Optional[int] = Field(None, alias="orderNum")
  244. remark: Optional[str] = None
  245. role_ids: Optional[List[str]] = Field(None, alias="roleIds")
  246. post_ids: Optional[List[str]] = Field(None, alias="postIds")
  247. USER_EXPORT_COLUMNS = [
  248. ExportColumn(title="用户账号", field="userNo"),
  249. ExportColumn(title="用户名", field="nickName"),
  250. ExportColumn(title="所属组织", field="deptName"),
  251. ExportColumn(title="角色", field="roles"),
  252. ExportColumn(title="手机号", field="phoneNo"),
  253. ExportColumn(title="状态", field="status", dict_type="sys_status"),
  254. ExportColumn(title="创建时间", field="createTime"),
  255. ]
  256. class UserExportBody(BaseModel):
  257. model_config = ConfigDict(populate_by_name=True)
  258. keyword: Optional[str] = None
  259. dept_id: Optional[str] = Field(None, alias="deptId")
  260. status: Optional[str] = None
  261. ids: Optional[List[str]] = None
  262. columns: Optional[List[str]] = None
  263. @router.get("/users")
  264. def list_users(
  265. page: int = Query(1, ge=1),
  266. pageSize: int = Query(10, ge=1, le=500, alias="pageSize"),
  267. keyword: Optional[str] = None,
  268. deptId: Optional[str] = Query(None, alias="deptId"),
  269. status: Optional[str] = None,
  270. user: dict = Depends(require_menu_code("system:user:list")),
  271. db: Session = Depends(get_db),
  272. ):
  273. tenant_no = _get_tenant_no(db, user)
  274. query = db.query(SysUser).filter(
  275. SysUser.del_flag == 0,
  276. SysUser.tenant_no == tenant_no,
  277. )
  278. kw = (keyword or "").strip()
  279. if kw:
  280. like = f"%{kw}%"
  281. query = query.filter(
  282. or_(
  283. SysUser.user_no.like(like),
  284. SysUser.nick_name.like(like),
  285. SysUser.phone_no.like(like),
  286. )
  287. )
  288. if deptId:
  289. query = query.filter(SysUser.dept_id == deptId)
  290. if status:
  291. query = query.filter(SysUser.status == status)
  292. query = apply_data_scope(query, SysUser, user, db, tenant_no)
  293. total = query.count()
  294. items = query.order_by(SysUser.create_time.desc()).offset((page - 1) * pageSize).limit(pageSize).all()
  295. dept_ids = list({r.dept_id for r in items if r.dept_id})
  296. dept_map: dict[str, str] = {}
  297. if dept_ids:
  298. for d in db.query(SysDept).filter(SysDept.id.in_(dept_ids), SysDept.del_flag == 0).all():
  299. dept_map[d.id] = d.dept_name or ""
  300. result_list = [
  301. user_svc._row_to_dict(r, dept_name=dept_map.get(r.dept_id or "", "")) for r in items
  302. ]
  303. user_ids = [d["id"] for d in result_list if d.get("id")]
  304. role_map: dict[str, list[str]] = {uid: [] for uid in user_ids}
  305. if user_ids:
  306. for ur in (
  307. db.query(SysUserRole)
  308. .filter(
  309. SysUserRole.user_id.in_(user_ids),
  310. SysUserRole.del_flag == 0,
  311. )
  312. .all()
  313. ):
  314. role_map.setdefault(ur.user_id, []).append(ur.role_id)
  315. for d in result_list:
  316. d["roleIds"] = role_map.get(d["id"], [])
  317. tp = user_svc.total_pages(total, pageSize)
  318. return success_response({"list": result_list, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp})
  319. @router.post("/users/export")
  320. def export_users(
  321. body: UserExportBody,
  322. user: dict = Depends(require_menu_code("system:user:list")),
  323. db: Session = Depends(get_db),
  324. ):
  325. """导出用户列表(当前筛选全量,或 ids 已选)。"""
  326. try:
  327. tenant_no = _get_tenant_no(db, user)
  328. query = db.query(SysUser).filter(
  329. SysUser.del_flag == 0,
  330. SysUser.tenant_no == tenant_no,
  331. )
  332. kw = (body.keyword or "").strip()
  333. if kw:
  334. like = f"%{kw}%"
  335. query = query.filter(
  336. or_(
  337. SysUser.user_no.like(like),
  338. SysUser.nick_name.like(like),
  339. SysUser.phone_no.like(like),
  340. )
  341. )
  342. if body.dept_id:
  343. query = query.filter(SysUser.dept_id == body.dept_id)
  344. if body.status:
  345. query = query.filter(SysUser.status == body.status)
  346. if body.ids:
  347. query = query.filter(SysUser.id.in_(body.ids))
  348. query = apply_data_scope(query, SysUser, user, db, tenant_no)
  349. rows_orm = query.order_by(SysUser.create_time.desc()).all()
  350. dept_ids = list({r.dept_id for r in rows_orm if r.dept_id})
  351. dept_map: dict[str, str] = {}
  352. if dept_ids:
  353. for d in db.query(SysDept).filter(SysDept.id.in_(dept_ids), SysDept.del_flag == 0).all():
  354. dept_map[d.id] = d.dept_name or ""
  355. result_list = [
  356. user_svc._row_to_dict(r, dept_name=dept_map.get(r.dept_id or "", "")) for r in rows_orm
  357. ]
  358. user_ids = [d["id"] for d in result_list if d.get("id")]
  359. role_map: dict[str, list[str]] = {uid: [] for uid in user_ids}
  360. role_name_by_id: dict[str, str] = {}
  361. if user_ids:
  362. for ur in (
  363. db.query(SysUserRole)
  364. .filter(
  365. SysUserRole.user_id.in_(user_ids),
  366. SysUserRole.del_flag == 0,
  367. )
  368. .all()
  369. ):
  370. role_map.setdefault(ur.user_id, []).append(ur.role_id)
  371. role_ids = list({rid for ids in role_map.values() for rid in ids})
  372. if role_ids:
  373. for role in db.query(SysRole).filter(SysRole.id.in_(role_ids), SysRole.del_flag == 0).all():
  374. role_name_by_id[role.id] = role.role_name or role.id
  375. for d in result_list:
  376. names = [role_name_by_id.get(rid, rid) for rid in role_map.get(d["id"], [])]
  377. d["roles"] = "、".join(names)
  378. cols = filter_export_columns(USER_EXPORT_COLUMNS, body.columns)
  379. date_str = datetime.now().strftime("%Y%m%d")
  380. return export_rows_to_xlsx_response(
  381. db,
  382. tenant_no=tenant_no,
  383. sheet_title="用户列表",
  384. columns=cols,
  385. rows=result_list,
  386. filename_stem=f"用户列表_{date_str}",
  387. )
  388. except ExportValidationError as e:
  389. return error_response(400, str(e))
  390. except Exception as e:
  391. return error_response(500, str(e))
  392. @router.get("/users/{user_id}")
  393. def get_user_by_id(
  394. user_id: str,
  395. user: dict = Depends(require_menu_code("system:user:list")),
  396. db: Session = Depends(get_db),
  397. ):
  398. tenant_no = _get_tenant_no(db, user)
  399. row = user_svc.get_user(db, user_id)
  400. if not row:
  401. return error_response(404, "用户不存在")
  402. if row.tenant_no != tenant_no and user.get("role") != "super_admin":
  403. return error_response(403, "无权查看该用户")
  404. try:
  405. assert_row_in_data_scope(db, row, SysUser, user, tenant_no)
  406. except HTTPException:
  407. return error_response(403, "无权查看该用户")
  408. data = user_svc.get_user_with_relations(db, user_id)
  409. return success_response(data)
  410. @router.post("/users")
  411. def create_user(
  412. body: UserCreateBody,
  413. user: dict = Depends(require_admin_or_super_admin),
  414. db: Session = Depends(get_db),
  415. ):
  416. try:
  417. tenant_no = _get_tenant_no(db, user)
  418. if user_svc.user_no_exists(db, body.user_no, tenant_no):
  419. return error_response(400, "用户账号已存在")
  420. obj = user_svc.create_user(
  421. db,
  422. user_no=body.user_no,
  423. nick_name=body.nick_name,
  424. password=body.password,
  425. dept_id=body.dept_id,
  426. email=body.email,
  427. phone_no=body.phone_no,
  428. sex=body.sex,
  429. avatar=body.avatar,
  430. status=body.status,
  431. tenant_no=tenant_no,
  432. order_num=body.order_num,
  433. remark=body.remark,
  434. user_id=user.get("user_id"),
  435. role_ids=body.role_ids,
  436. post_ids=body.post_ids,
  437. )
  438. return success_response(user_svc._row_to_dict(obj), message="创建成功")
  439. except ValueError as e:
  440. return error_response(400, str(e))
  441. @router.put("/users/{user_id}")
  442. def update_user(
  443. user_id: str,
  444. body: UserUpdateBody,
  445. user: dict = Depends(require_admin_or_super_admin),
  446. db: Session = Depends(get_db),
  447. ):
  448. try:
  449. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  450. obj = user_svc.update_user(
  451. db,
  452. user_id,
  453. nick_name=payload.get("nick_name"),
  454. dept_id=payload.get("dept_id"),
  455. email=payload.get("email"),
  456. phone_no=payload.get("phone_no"),
  457. sex=payload.get("sex"),
  458. avatar=payload.get("avatar"),
  459. status=payload.get("status"),
  460. order_num=payload.get("order_num"),
  461. remark=payload.get("remark"),
  462. user_id_updater=user.get("user_id"),
  463. role_ids=payload.get("role_ids"),
  464. post_ids=payload.get("post_ids"),
  465. )
  466. return success_response(user_svc._row_to_dict(obj), message="更新成功")
  467. except ValueError as e:
  468. return error_response(400, str(e))
  469. @router.delete("/users/{user_id}")
  470. def delete_user(
  471. user_id: str,
  472. _user: dict = Depends(require_admin_or_super_admin),
  473. db: Session = Depends(get_db),
  474. ):
  475. try:
  476. user_svc.soft_delete_user(db, user_id, user_info=_user)
  477. return success_response(None, message="删除成功")
  478. except ValueError as e:
  479. return error_response(400, str(e))
  480. @router.post("/users/{user_id}/reset-password")
  481. def reset_user_password(
  482. user_id: str,
  483. _user: dict = Depends(require_admin_or_super_admin),
  484. db: Session = Depends(get_db),
  485. ):
  486. try:
  487. user_svc.reset_password(db, user_id, "111111")
  488. return success_response(None, message="密码已重置为 111111")
  489. except ValueError as e:
  490. return error_response(400, str(e))
  491. # ---------------------------------------------------------------------------
  492. # 字典类型管理
  493. # ---------------------------------------------------------------------------
  494. class DictTypeCreateBody(BaseModel):
  495. model_config = ConfigDict(populate_by_name=True)
  496. dict_name: str = Field(..., alias="dictName")
  497. dict_type: str = Field(..., alias="dictType")
  498. order_num: Optional[int] = Field(0, alias="orderNum")
  499. remark: Optional[str] = None
  500. class DictTypeUpdateBody(BaseModel):
  501. model_config = ConfigDict(populate_by_name=True)
  502. dict_name: Optional[str] = Field(None, alias="dictName")
  503. dict_type: Optional[str] = Field(None, alias="dictType")
  504. order_num: Optional[int] = Field(None, alias="orderNum")
  505. remark: Optional[str] = None
  506. @router.get("/dict-types")
  507. def list_dict_types(
  508. page: int = Query(1, ge=1),
  509. pageSize: int = Query(10, ge=1, le=500, alias="pageSize"),
  510. keyword: Optional[str] = None,
  511. user: dict = Depends(require_menu_code("system:dict:list")),
  512. db: Session = Depends(get_db),
  513. ):
  514. tenant_no = _get_tenant_no(db, user)
  515. items, total = dict_type_svc.list_dict_types(
  516. db, page=page, page_size=pageSize, keyword=keyword, tenant_no=tenant_no, user_info=user
  517. )
  518. tp = dict_type_svc.total_pages(total, pageSize)
  519. return success_response({"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp})
  520. @router.post("/dict-types")
  521. def create_dict_type(
  522. body: DictTypeCreateBody,
  523. user: dict = Depends(require_admin_or_super_admin),
  524. db: Session = Depends(get_db),
  525. ):
  526. try:
  527. tenant_no = _get_tenant_no(db, user)
  528. obj = dict_type_svc.create_dict_type(
  529. db,
  530. dict_name=body.dict_name,
  531. dict_type=body.dict_type,
  532. tenant_no=tenant_no,
  533. order_num=body.order_num,
  534. remark=body.remark,
  535. user_id=user.get("user_id"),
  536. )
  537. return success_response(dict_type_svc._row_to_dict(obj), message="创建成功")
  538. except ValueError as e:
  539. return error_response(400, str(e))
  540. @router.put("/dict-types/{dict_type_id}")
  541. def update_dict_type(
  542. dict_type_id: str,
  543. body: DictTypeUpdateBody,
  544. user: dict = Depends(require_admin_or_super_admin),
  545. db: Session = Depends(get_db),
  546. ):
  547. try:
  548. tenant_no = _get_tenant_no(db, user)
  549. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  550. obj = dict_type_svc.update_dict_type(
  551. db,
  552. dict_type_id,
  553. dict_name=payload.get("dict_name"),
  554. dict_type=payload.get("dict_type"),
  555. order_num=payload.get("order_num"),
  556. remark=payload.get("remark"),
  557. user_id=user.get("user_id"),
  558. tenant_no=tenant_no,
  559. )
  560. return success_response(dict_type_svc._row_to_dict(obj), message="更新成功")
  561. except ValueError as e:
  562. return error_response(400, str(e))
  563. @router.delete("/dict-types/{dict_type_id}")
  564. def delete_dict_type(
  565. dict_type_id: str,
  566. _user: dict = Depends(require_admin_or_super_admin),
  567. db: Session = Depends(get_db),
  568. ):
  569. try:
  570. dict_type_svc.soft_delete_dict_type(db, dict_type_id, user_info=_user)
  571. return success_response(None, message="删除成功")
  572. except ValueError as e:
  573. return error_response(400, str(e))
  574. # ---------------------------------------------------------------------------
  575. # 字典数据管理
  576. # ---------------------------------------------------------------------------
  577. class DictDataCreateBody(BaseModel):
  578. model_config = ConfigDict(populate_by_name=True)
  579. dict_label: str = Field(..., alias="dictLabel")
  580. dict_value: str = Field(..., alias="dictValue")
  581. dict_type: str = Field(..., alias="dictType")
  582. tag_type: Optional[str] = Field("", alias="tagType")
  583. order_num: Optional[int] = Field(0, alias="orderNum")
  584. remark: Optional[str] = None
  585. class DictDataUpdateBody(BaseModel):
  586. model_config = ConfigDict(populate_by_name=True)
  587. dict_label: Optional[str] = Field(None, alias="dictLabel")
  588. dict_value: Optional[str] = Field(None, alias="dictValue")
  589. tag_type: Optional[str] = Field(None, alias="tagType")
  590. order_num: Optional[int] = Field(None, alias="orderNum")
  591. remark: Optional[str] = None
  592. @router.get("/dict-data")
  593. def list_dict_data(
  594. page: int = Query(1, ge=1),
  595. pageSize: int = Query(10, ge=1, le=500, alias="pageSize"),
  596. dictType: Optional[str] = None,
  597. keyword: Optional[str] = None,
  598. user: dict = Depends(require_menu_code("system:dict:list")),
  599. db: Session = Depends(get_db),
  600. ):
  601. tenant_no = _get_tenant_no(db, user)
  602. items, total = dict_data_svc.list_dict_data(
  603. db, page=page, page_size=pageSize, dict_type_code=dictType, keyword=keyword, tenant_no=tenant_no, user_info=user
  604. )
  605. tp = dict_data_svc.total_pages(total, pageSize)
  606. return success_response({"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp})
  607. @router.post("/dict-data")
  608. def create_dict_data(
  609. body: DictDataCreateBody,
  610. user: dict = Depends(require_admin_or_super_admin),
  611. db: Session = Depends(get_db),
  612. ):
  613. try:
  614. tenant_no = _get_tenant_no(db, user)
  615. obj = dict_data_svc.create_dict_data(
  616. db,
  617. dict_label=body.dict_label,
  618. dict_value=body.dict_value,
  619. dict_type=body.dict_type,
  620. tag_type=body.tag_type,
  621. tenant_no=tenant_no,
  622. order_num=body.order_num,
  623. remark=body.remark,
  624. user_id=user.get("user_id"),
  625. )
  626. return success_response(dict_data_svc._row_to_dict(obj), message="创建成功")
  627. except ValueError as e:
  628. return error_response(400, str(e))
  629. @router.put("/dict-data/{data_id}")
  630. def update_dict_data(
  631. data_id: str,
  632. body: DictDataUpdateBody,
  633. user: dict = Depends(require_admin_or_super_admin),
  634. db: Session = Depends(get_db),
  635. ):
  636. try:
  637. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  638. obj = dict_data_svc.update_dict_data(
  639. db,
  640. data_id,
  641. dict_label=payload.get("dict_label"),
  642. dict_value=payload.get("dict_value"),
  643. tag_type=payload.get("tag_type"),
  644. order_num=payload.get("order_num"),
  645. remark=payload.get("remark"),
  646. user_id=user.get("user_id"),
  647. )
  648. return success_response(dict_data_svc._row_to_dict(obj), message="更新成功")
  649. except ValueError as e:
  650. return error_response(400, str(e))
  651. @router.delete("/dict-data/{data_id}")
  652. def delete_dict_data(
  653. data_id: str,
  654. _user: dict = Depends(require_admin_or_super_admin),
  655. db: Session = Depends(get_db),
  656. ):
  657. try:
  658. dict_data_svc.soft_delete_dict_data(db, data_id, user_info=_user)
  659. return success_response(None, message="删除成功")
  660. except ValueError as e:
  661. return error_response(400, str(e))
  662. @router.get("/dict-data/options")
  663. def dict_data_options(
  664. dictType: str = Query(..., alias="dictType"),
  665. user: dict = Depends(require_menu_code("system:dict:list")),
  666. db: Session = Depends(get_db),
  667. ):
  668. tenant_no = _get_tenant_no(db, user)
  669. # 字典选项为租户主数据,表单共用;不做数据范围过滤
  670. items = dict_data_svc.list_dict_data_options(
  671. db, dict_type_code=dictType, tenant_no=tenant_no, user_info=None
  672. )
  673. return success_response(items)
  674. @router.get("/dict-data/all")
  675. def dict_data_all(
  676. user: dict = Depends(require_admin_or_super_admin),
  677. db: Session = Depends(get_db),
  678. ):
  679. tenant_no = _get_tenant_no(db, user)
  680. q = db.query(SysDictData).filter(
  681. and_(SysDictData.tenant_no == tenant_no, SysDictData.del_flag == 0)
  682. )
  683. rows = q.order_by(SysDictData.order_num.asc()).all()
  684. grouped = {}
  685. for r in rows:
  686. key = r.dict_type
  687. if key not in grouped:
  688. grouped[key] = []
  689. grouped[key].append({
  690. "label": r.dict_label,
  691. "value": r.dict_value,
  692. "tagType": r.tag_type or ""
  693. })
  694. return success_response(grouped)
  695. class DictEnsureBody(BaseModel):
  696. model_config = ConfigDict(populate_by_name=True)
  697. dict_type: str = Field(..., alias="dictType")
  698. label: str
  699. preferred_value: Optional[str] = Field(None, alias="preferredValue")
  700. class DictEnsureRemoveBody(BaseModel):
  701. model_config = ConfigDict(populate_by_name=True)
  702. dict_type: str = Field(..., alias="dictType")
  703. value: str
  704. @router.post("/dict-data/ensure")
  705. def ensure_dict_data_api(
  706. body: DictEnsureBody,
  707. user: dict = Depends(require_admin_or_super_admin),
  708. db: Session = Depends(get_db),
  709. ):
  710. try:
  711. tenant_no = _get_tenant_no(db, user)
  712. data = dict_ensure_svc.ensure_dict_data(
  713. db,
  714. tenant_no=tenant_no,
  715. dict_type=body.dict_type,
  716. label=body.label,
  717. user_id=user.get("user_id") or user.get("id") or "",
  718. preferred_value=body.preferred_value,
  719. )
  720. db.commit()
  721. return success_response(data, message="已保存")
  722. except dict_ensure_svc.DictEnsureError as e:
  723. db.rollback()
  724. return error_response(400, str(e))
  725. @router.post("/dict-data/ensure-remove")
  726. def ensure_remove_dict_data_api(
  727. body: DictEnsureRemoveBody,
  728. user: dict = Depends(require_admin_or_super_admin),
  729. db: Session = Depends(get_db),
  730. ):
  731. try:
  732. tenant_no = _get_tenant_no(db, user)
  733. dict_ensure_svc.ensure_remove_dict_data(
  734. db,
  735. tenant_no=tenant_no,
  736. dict_type=body.dict_type,
  737. value=body.value,
  738. user_id=user.get("user_id") or user.get("id") or "",
  739. )
  740. db.commit()
  741. return success_response(None, message="已删除")
  742. except dict_ensure_svc.DictEnsureError as e:
  743. db.rollback()
  744. return error_response(400, str(e))
  745. # ---------------------------------------------------------------------------
  746. # 组织管理
  747. # ---------------------------------------------------------------------------
  748. class DeptCreateBody(BaseModel):
  749. model_config = ConfigDict(populate_by_name=True)
  750. parent_id: str = Field("0", alias="parentId")
  751. dept_name: str = Field(..., alias="deptName")
  752. dept_category_code: Optional[str] = Field(None, alias="deptCategoryCode")
  753. status: Optional[str] = Field("1")
  754. leader: Optional[str] = None
  755. leader_phone: Optional[str] = Field(None, alias="leaderPhone")
  756. order_num: Optional[int] = Field(0, alias="orderNum")
  757. remark: Optional[str] = None
  758. class DeptUpdateBody(BaseModel):
  759. model_config = ConfigDict(populate_by_name=True)
  760. dept_name: Optional[str] = Field(None, alias="deptName")
  761. dept_category_code: Optional[str] = Field(None, alias="deptCategoryCode")
  762. status: Optional[str] = None
  763. leader: Optional[str] = None
  764. leader_phone: Optional[str] = Field(None, alias="leaderPhone")
  765. order_num: Optional[int] = Field(None, alias="orderNum")
  766. remark: Optional[str] = None
  767. @router.get("/depts")
  768. def list_depts(
  769. keyword: Optional[str] = None,
  770. user: dict = Depends(require_menu_code("system:dept:list")),
  771. db: Session = Depends(get_db),
  772. ):
  773. tenant_no = _get_tenant_no(db, user)
  774. tree = dept_svc.list_depts_tree(db, keyword=keyword, tenant_no=tenant_no, user_info=user)
  775. return success_response(tree)
  776. @router.post("/depts")
  777. def create_dept(
  778. body: DeptCreateBody,
  779. user: dict = Depends(require_admin_or_super_admin),
  780. db: Session = Depends(get_db),
  781. ):
  782. try:
  783. tenant_no = _get_tenant_no(db, user)
  784. obj = dept_svc.create_dept(
  785. db,
  786. parent_id=body.parent_id,
  787. dept_name=body.dept_name,
  788. dept_category_code=body.dept_category_code,
  789. status=body.status,
  790. leader=body.leader,
  791. leader_phone=body.leader_phone,
  792. tenant_no=tenant_no,
  793. order_num=body.order_num,
  794. remark=body.remark,
  795. user_id=user.get("user_id"),
  796. )
  797. return success_response(dept_svc._row_to_dict(obj), message="创建成功")
  798. except ValueError as e:
  799. return error_response(400, str(e))
  800. @router.put("/depts/{dept_id}")
  801. def update_dept(
  802. dept_id: str,
  803. body: DeptUpdateBody,
  804. user: dict = Depends(require_admin_or_super_admin),
  805. db: Session = Depends(get_db),
  806. ):
  807. try:
  808. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  809. obj = dept_svc.update_dept(
  810. db,
  811. dept_id,
  812. dept_name=payload.get("dept_name"),
  813. dept_category_code=payload.get("dept_category_code"),
  814. status=payload.get("status"),
  815. leader=payload.get("leader"),
  816. leader_phone=payload.get("leader_phone"),
  817. order_num=payload.get("order_num"),
  818. remark=payload.get("remark"),
  819. user_id=user.get("user_id"),
  820. )
  821. return success_response(dept_svc._row_to_dict(obj), message="更新成功")
  822. except ValueError as e:
  823. return error_response(400, str(e))
  824. @router.delete("/depts/{dept_id}")
  825. def delete_dept(
  826. dept_id: str,
  827. _user: dict = Depends(require_admin_or_super_admin),
  828. db: Session = Depends(get_db),
  829. ):
  830. try:
  831. dept_svc.soft_delete_dept(db, dept_id, user_info=_user)
  832. return success_response(None, message="删除成功")
  833. except ValueError as e:
  834. return error_response(400, str(e))
  835. # ---------------------------------------------------------------------------
  836. # 站点管理
  837. # ---------------------------------------------------------------------------
  838. class SiteCreateBody(BaseModel):
  839. model_config = ConfigDict(populate_by_name=True)
  840. site_name: str = Field(..., alias="siteName")
  841. site_code: str = Field(..., alias="siteCode")
  842. site_type: Optional[str] = Field(None, alias="siteType")
  843. status: Optional[str] = Field("1")
  844. address: Optional[str] = None
  845. contact_name: Optional[str] = Field(None, alias="contactName")
  846. contact_phone: Optional[str] = Field(None, alias="contactPhone")
  847. business_scope: Optional[str] = Field(None, alias="businessScope")
  848. order_num: Optional[int] = Field(0, alias="orderNum")
  849. remark: Optional[str] = None
  850. class SiteUpdateBody(BaseModel):
  851. model_config = ConfigDict(populate_by_name=True)
  852. site_name: Optional[str] = Field(None, alias="siteName")
  853. site_code: Optional[str] = Field(None, alias="siteCode")
  854. site_type: Optional[str] = Field(None, alias="siteType")
  855. status: Optional[str] = None
  856. address: Optional[str] = None
  857. contact_name: Optional[str] = Field(None, alias="contactName")
  858. contact_phone: Optional[str] = Field(None, alias="contactPhone")
  859. business_scope: Optional[str] = Field(None, alias="businessScope")
  860. order_num: Optional[int] = Field(None, alias="orderNum")
  861. remark: Optional[str] = None
  862. @router.get("/sites")
  863. def list_sites(
  864. page: int = Query(1, ge=1),
  865. pageSize: int = Query(10, ge=1, le=500, alias="pageSize"),
  866. keyword: Optional[str] = None,
  867. user: dict = Depends(require_menu_code("system:site:list")),
  868. db: Session = Depends(get_db),
  869. ):
  870. tenant_no = _get_tenant_no(db, user)
  871. items, total = site_svc.list_sites(db, page=page, page_size=pageSize, keyword=keyword, tenant_no=tenant_no, user_info=user)
  872. tp = site_svc.total_pages(total, pageSize)
  873. return success_response({"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp})
  874. @router.post("/sites")
  875. def create_site(
  876. body: SiteCreateBody,
  877. user: dict = Depends(require_admin_or_super_admin),
  878. db: Session = Depends(get_db),
  879. ):
  880. try:
  881. tenant_no = _get_tenant_no(db, user)
  882. obj = site_svc.create_site(
  883. db,
  884. site_name=body.site_name,
  885. site_code=body.site_code,
  886. site_type=body.site_type,
  887. status=body.status,
  888. address=body.address,
  889. contact_name=body.contact_name,
  890. contact_phone=body.contact_phone,
  891. business_scope=body.business_scope,
  892. tenant_no=tenant_no,
  893. order_num=body.order_num,
  894. remark=body.remark,
  895. user_id=user.get("user_id"),
  896. )
  897. return success_response(site_svc._row_to_dict(obj), message="创建成功")
  898. except ValueError as e:
  899. return error_response(400, str(e))
  900. @router.put("/sites/{site_id}")
  901. def update_site(
  902. site_id: str,
  903. body: SiteUpdateBody,
  904. user: dict = Depends(require_admin_or_super_admin),
  905. db: Session = Depends(get_db),
  906. ):
  907. try:
  908. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  909. obj = site_svc.update_site(
  910. db,
  911. site_id,
  912. site_name=payload.get("site_name"),
  913. site_code=payload.get("site_code"),
  914. site_type=payload.get("site_type"),
  915. status=payload.get("status"),
  916. address=payload.get("address"),
  917. contact_name=payload.get("contact_name"),
  918. contact_phone=payload.get("contact_phone"),
  919. business_scope=payload.get("business_scope"),
  920. order_num=payload.get("order_num"),
  921. remark=payload.get("remark"),
  922. user_id=user.get("user_id"),
  923. )
  924. return success_response(site_svc._row_to_dict(obj), message="更新成功")
  925. except ValueError as e:
  926. return error_response(400, str(e))
  927. @router.delete("/sites/{site_id}")
  928. def delete_site(
  929. site_id: str,
  930. _user: dict = Depends(require_admin_or_super_admin),
  931. db: Session = Depends(get_db),
  932. ):
  933. try:
  934. site_svc.soft_delete_site(db, site_id, user_info=_user)
  935. return success_response(None, message="删除成功")
  936. except ValueError as e:
  937. return error_response(400, str(e))
  938. # ---------------------------------------------------------------------------
  939. # 职位管理
  940. # ---------------------------------------------------------------------------
  941. class PostCreateBody(BaseModel):
  942. model_config = ConfigDict(populate_by_name=True)
  943. post_name: str = Field(..., alias="postName")
  944. post_code: str = Field(..., alias="postCode")
  945. status: Optional[str] = Field("1")
  946. order_num: Optional[int] = Field(0, alias="orderNum")
  947. remark: Optional[str] = None
  948. class PostUpdateBody(BaseModel):
  949. model_config = ConfigDict(populate_by_name=True)
  950. post_name: Optional[str] = Field(None, alias="postName")
  951. post_code: Optional[str] = Field(None, alias="postCode")
  952. status: Optional[str] = None
  953. order_num: Optional[int] = Field(None, alias="orderNum")
  954. remark: Optional[str] = None
  955. @router.get("/posts")
  956. def list_posts(
  957. page: int = Query(1, ge=1),
  958. pageSize: int = Query(10, ge=1, le=500, alias="pageSize"),
  959. keyword: Optional[str] = None,
  960. user: dict = Depends(require_menu_code("system:post:list")),
  961. db: Session = Depends(get_db),
  962. ):
  963. tenant_no = _get_tenant_no(db, user)
  964. items, total = post_svc.list_posts(db, page=page, page_size=pageSize, keyword=keyword, tenant_no=tenant_no, user_info=user)
  965. tp = post_svc.total_pages(total, pageSize)
  966. return success_response({"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp})
  967. @router.post("/posts")
  968. def create_post(
  969. body: PostCreateBody,
  970. user: dict = Depends(require_admin_or_super_admin),
  971. db: Session = Depends(get_db),
  972. ):
  973. try:
  974. tenant_no = _get_tenant_no(db, user)
  975. obj = post_svc.create_post(
  976. db,
  977. post_name=body.post_name,
  978. post_code=body.post_code,
  979. status=body.status,
  980. tenant_no=tenant_no,
  981. order_num=body.order_num,
  982. remark=body.remark,
  983. user_id=user.get("user_id"),
  984. )
  985. return success_response(post_svc._row_to_dict(obj), message="创建成功")
  986. except ValueError as e:
  987. return error_response(400, str(e))
  988. @router.put("/posts/{post_id}")
  989. def update_post(
  990. post_id: str,
  991. body: PostUpdateBody,
  992. user: dict = Depends(require_admin_or_super_admin),
  993. db: Session = Depends(get_db),
  994. ):
  995. try:
  996. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  997. obj = post_svc.update_post(
  998. db,
  999. post_id,
  1000. post_name=payload.get("post_name"),
  1001. post_code=payload.get("post_code"),
  1002. status=payload.get("status"),
  1003. order_num=payload.get("order_num"),
  1004. remark=payload.get("remark"),
  1005. user_id=user.get("user_id"),
  1006. )
  1007. return success_response(post_svc._row_to_dict(obj), message="更新成功")
  1008. except ValueError as e:
  1009. return error_response(400, str(e))
  1010. @router.delete("/posts/{post_id}")
  1011. def delete_post(
  1012. post_id: str,
  1013. _user: dict = Depends(require_admin_or_super_admin),
  1014. db: Session = Depends(get_db),
  1015. ):
  1016. try:
  1017. post_svc.soft_delete_post(db, post_id, user_info=_user)
  1018. return success_response(None, message="删除成功")
  1019. except ValueError as e:
  1020. return error_response(400, str(e))
  1021. class PostUsersUpdateBody(BaseModel):
  1022. model_config = ConfigDict(populate_by_name=True)
  1023. user_ids: List[str] = Field(default_factory=list, alias="userIds")
  1024. @router.get("/posts/{post_id}/users")
  1025. def list_post_bound_users(
  1026. post_id: str,
  1027. user: dict = Depends(require_menu_code("system:post:list")),
  1028. db: Session = Depends(get_db),
  1029. ):
  1030. tenant_no = _get_tenant_no(db, user)
  1031. post = post_svc.get_post(db, post_id)
  1032. if not post or post.tenant_no != tenant_no:
  1033. return error_response(404, "职位不存在")
  1034. ids = user_svc.list_user_ids_bound_to_post(db, post_id, tenant_no)
  1035. return success_response({"userIds": ids})
  1036. @router.put("/posts/{post_id}/users")
  1037. def update_post_bound_users(
  1038. post_id: str,
  1039. body: PostUsersUpdateBody,
  1040. user: dict = Depends(require_admin_or_super_admin),
  1041. db: Session = Depends(get_db),
  1042. ):
  1043. tenant_no = _get_tenant_no(db, user)
  1044. post = post_svc.get_post(db, post_id)
  1045. if not post or post.tenant_no != tenant_no:
  1046. return error_response(404, "职位不存在")
  1047. try:
  1048. user_svc.sync_post_user_bindings(
  1049. db, post_id, tenant_no, body.user_ids, user.get("user_id")
  1050. )
  1051. return success_response(None, message="保存成功")
  1052. except ValueError as e:
  1053. return error_response(400, str(e))
  1054. # ---------------------------------------------------------------------------
  1055. # 菜单管理
  1056. # ---------------------------------------------------------------------------
  1057. class MenuCreateBody(BaseModel):
  1058. model_config = ConfigDict(populate_by_name=True)
  1059. menu_name: str = Field(..., alias="menuName")
  1060. parent_id: str = Field("0", alias="parentId")
  1061. menu_type: str = Field("M", alias="menuType")
  1062. path: Optional[str] = Field("", alias="path")
  1063. component: Optional[str] = Field(None, alias="component")
  1064. perms: Optional[str] = Field(None, alias="perms")
  1065. is_frame: Optional[int] = Field(1, alias="isFrame")
  1066. visible: Optional[str] = Field("1", alias="visible")
  1067. status: Optional[str] = Field("1", alias="status")
  1068. order_num: Optional[int] = Field(None, alias="orderNum")
  1069. remark: Optional[str] = None
  1070. class MenuUpdateBody(BaseModel):
  1071. model_config = ConfigDict(populate_by_name=True)
  1072. menu_name: Optional[str] = Field(None, alias="menuName")
  1073. parent_id: Optional[str] = Field(None, alias="parentId")
  1074. menu_type: Optional[str] = Field(None, alias="menuType")
  1075. path: Optional[str] = Field(None, alias="path")
  1076. component: Optional[str] = Field(None, alias="component")
  1077. perms: Optional[str] = Field(None, alias="perms")
  1078. is_frame: Optional[int] = Field(None, alias="isFrame")
  1079. visible: Optional[str] = Field(None, alias="visible")
  1080. status: Optional[str] = Field(None, alias="status")
  1081. order_num: Optional[int] = Field(None, alias="orderNum")
  1082. remark: Optional[str] = None
  1083. @router.get("/menus")
  1084. def list_menus(
  1085. keyword: Optional[str] = None,
  1086. user: dict = Depends(require_admin_or_super_admin),
  1087. db: Session = Depends(get_db),
  1088. ):
  1089. tenant_no = _get_tenant_no(db, user)
  1090. tree = menu_svc.list_menus_tree(db, keyword=keyword, tenant_no=tenant_no, user_info=user)
  1091. return success_response(tree)
  1092. @router.post("/menus")
  1093. def create_menu(
  1094. body: MenuCreateBody,
  1095. user: dict = Depends(require_admin_or_super_admin),
  1096. db: Session = Depends(get_db),
  1097. ):
  1098. try:
  1099. tenant_no = _get_tenant_no(db, user)
  1100. obj = menu_svc.create_menu(
  1101. db,
  1102. menu_name=body.menu_name,
  1103. parent_id=body.parent_id,
  1104. menu_type=body.menu_type,
  1105. path=body.path,
  1106. component=body.component,
  1107. perms=body.perms,
  1108. is_frame=body.is_frame,
  1109. visible=body.visible,
  1110. status=body.status,
  1111. tenant_no=tenant_no,
  1112. order_num=body.order_num,
  1113. remark=body.remark,
  1114. user_id=user.get("user_id"),
  1115. )
  1116. return success_response(menu_svc._row_to_dict(obj), message="创建成功")
  1117. except ValueError as e:
  1118. return error_response(400, str(e))
  1119. @router.put("/menus/{menu_id}")
  1120. def update_menu(
  1121. menu_id: str,
  1122. body: MenuUpdateBody,
  1123. user: dict = Depends(require_admin_or_super_admin),
  1124. db: Session = Depends(get_db),
  1125. ):
  1126. try:
  1127. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  1128. obj = menu_svc.update_menu(
  1129. db,
  1130. menu_id,
  1131. menu_name=payload.get("menu_name"),
  1132. parent_id=payload.get("parent_id"),
  1133. menu_type=payload.get("menu_type"),
  1134. path=payload.get("path"),
  1135. component=payload.get("component"),
  1136. perms=payload.get("perms"),
  1137. is_frame=payload.get("is_frame"),
  1138. visible=payload.get("visible"),
  1139. status=payload.get("status"),
  1140. order_num=payload.get("order_num"),
  1141. remark=payload.get("remark"),
  1142. user_id=user.get("user_id"),
  1143. )
  1144. return success_response(menu_svc._row_to_dict(obj), message="更新成功")
  1145. except ValueError as e:
  1146. return error_response(400, str(e))
  1147. @router.delete("/menus/{menu_id}")
  1148. def delete_menu(
  1149. menu_id: str,
  1150. _user: dict = Depends(require_admin_or_super_admin),
  1151. db: Session = Depends(get_db),
  1152. ):
  1153. try:
  1154. menu_svc.soft_delete_menu(db, menu_id, user_info=_user)
  1155. return success_response(None, message="删除成功")
  1156. except ValueError as e:
  1157. return error_response(400, str(e))
  1158. # ---------------------------------------------------------------------------
  1159. # 角色管理
  1160. # ---------------------------------------------------------------------------
  1161. class RoleCreateBody(BaseModel):
  1162. model_config = ConfigDict(populate_by_name=True)
  1163. role_name: str = Field(..., alias="roleName")
  1164. data_scope: Optional[str] = Field("4", alias="dataScope")
  1165. status: Optional[str] = Field("1", alias="status")
  1166. order_num: Optional[int] = Field(None, alias="orderNum")
  1167. remark: Optional[str] = None
  1168. class RoleUpdateBody(BaseModel):
  1169. model_config = ConfigDict(populate_by_name=True)
  1170. role_name: Optional[str] = Field(None, alias="roleName")
  1171. data_scope: Optional[str] = Field(None, alias="dataScope")
  1172. status: Optional[str] = Field(None, alias="status")
  1173. order_num: Optional[int] = Field(None, alias="orderNum")
  1174. remark: Optional[str] = None
  1175. class RoleMenuBody(BaseModel):
  1176. menu_ids: List[str] = Field(..., alias="menuIds")
  1177. class RoleDataScopeBody(BaseModel):
  1178. model_config = ConfigDict(populate_by_name=True)
  1179. data_scope: str = Field(..., alias="dataScope")
  1180. scope_details: Optional[List[dict]] = Field(None, alias="scopeDetails")
  1181. @router.get("/role-management")
  1182. def list_role_management(
  1183. page: int = Query(1, ge=1),
  1184. pageSize: int = Query(10, ge=1, le=500, alias="pageSize"),
  1185. keyword: Optional[str] = None,
  1186. user: dict = Depends(require_menu_code("system:role:list")),
  1187. db: Session = Depends(get_db),
  1188. ):
  1189. tenant_no = _get_tenant_no(db, user)
  1190. items, total = role_svc.list_roles(db, page=page, page_size=pageSize, keyword=keyword, tenant_no=tenant_no, user_info=user)
  1191. tp = role_svc.total_pages(total, pageSize)
  1192. return success_response({"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp})
  1193. @router.post("/role-management")
  1194. def create_role_management(
  1195. body: RoleCreateBody,
  1196. user: dict = Depends(require_admin_or_super_admin),
  1197. db: Session = Depends(get_db),
  1198. ):
  1199. try:
  1200. tenant_no = _get_tenant_no(db, user)
  1201. obj = role_svc.create_role(
  1202. db,
  1203. role_name=body.role_name,
  1204. data_scope=body.data_scope,
  1205. status=body.status,
  1206. tenant_no=tenant_no,
  1207. order_num=body.order_num,
  1208. remark=body.remark,
  1209. user_id=user.get("user_id"),
  1210. )
  1211. return success_response(role_svc._row_to_dict(obj), message="创建成功")
  1212. except ValueError as e:
  1213. return error_response(400, str(e))
  1214. @router.get("/role-management/{role_id}")
  1215. def get_role_management(
  1216. role_id: str,
  1217. user: dict = Depends(require_admin_or_super_admin),
  1218. db: Session = Depends(get_db),
  1219. ):
  1220. tenant_no = _get_tenant_no(db, user)
  1221. obj = role_svc.get_role(db, role_id)
  1222. if not obj or obj.tenant_no != tenant_no:
  1223. return error_response(404, "角色不存在")
  1224. try:
  1225. assert_row_in_data_scope(db, obj, SysRole, user, tenant_no)
  1226. except HTTPException:
  1227. return error_response(403, "无权查看该角色")
  1228. return success_response(role_svc._row_to_dict(obj))
  1229. @router.put("/role-management/{role_id}")
  1230. def update_role_management(
  1231. role_id: str,
  1232. body: RoleUpdateBody,
  1233. user: dict = Depends(require_admin_or_super_admin),
  1234. db: Session = Depends(get_db),
  1235. ):
  1236. try:
  1237. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  1238. obj = role_svc.update_role(
  1239. db,
  1240. role_id,
  1241. role_name=payload.get("role_name"),
  1242. data_scope=payload.get("data_scope"),
  1243. status=payload.get("status"),
  1244. order_num=payload.get("order_num"),
  1245. remark=payload.get("remark"),
  1246. user_id=user.get("user_id"),
  1247. )
  1248. return success_response(role_svc._row_to_dict(obj), message="更新成功")
  1249. except ValueError as e:
  1250. return error_response(400, str(e))
  1251. @router.delete("/role-management/{role_id}")
  1252. def delete_role_management(
  1253. role_id: str,
  1254. _user: dict = Depends(require_admin_or_super_admin),
  1255. db: Session = Depends(get_db),
  1256. ):
  1257. try:
  1258. role_svc.soft_delete_role(db, role_id, user_info=_user)
  1259. return success_response(None, message="删除成功")
  1260. except ValueError as e:
  1261. return error_response(400, str(e))
  1262. @router.get("/role-management/{role_id}/menus")
  1263. def get_role_menus(
  1264. role_id: str,
  1265. _user: dict = Depends(require_admin_or_super_admin),
  1266. db: Session = Depends(get_db),
  1267. ):
  1268. menu_ids = role_svc.get_role_menu_ids(db, role_id)
  1269. return success_response({"menuIds": menu_ids})
  1270. @router.put("/role-management/{role_id}/menus")
  1271. def update_role_menus(
  1272. role_id: str,
  1273. body: RoleMenuBody,
  1274. user: dict = Depends(require_admin_or_super_admin),
  1275. db: Session = Depends(get_db),
  1276. ):
  1277. try:
  1278. tenant_no = _get_tenant_no(db, user)
  1279. role_svc.update_role_menus(db, role_id, body.menu_ids, tenant_no, user_id=user.get("user_id"))
  1280. return success_response(None, message="更新成功")
  1281. except ValueError as e:
  1282. return error_response(400, str(e))
  1283. @router.get("/role-management/{role_id}/data-scope")
  1284. def get_role_data_scope(
  1285. role_id: str,
  1286. _user: dict = Depends(require_admin_or_super_admin),
  1287. db: Session = Depends(get_db),
  1288. ):
  1289. role = role_svc.get_role(db, role_id)
  1290. if not role:
  1291. return error_response(404, "角色不存在")
  1292. details = role_svc.get_role_data_scope(db, role_id)
  1293. return success_response({"dataScope": role.data_scope or "1", "scopeDetails": details})
  1294. @router.put("/role-management/{role_id}/data-scope")
  1295. def update_role_data_scope(
  1296. role_id: str,
  1297. body: RoleDataScopeBody,
  1298. user: dict = Depends(require_admin_or_super_admin),
  1299. db: Session = Depends(get_db),
  1300. ):
  1301. try:
  1302. tenant_no = _get_tenant_no(db, user)
  1303. role_svc.update_role_data_scope(
  1304. db,
  1305. role_id,
  1306. body.data_scope,
  1307. body.scope_details,
  1308. tenant_no=tenant_no,
  1309. user_id=user.get("user_id"),
  1310. )
  1311. return success_response(None, message="更新成功")
  1312. except ValueError as e:
  1313. return error_response(400, str(e))
  1314. # ---------------------------------------------------------------------------
  1315. # 附件上传
  1316. # ---------------------------------------------------------------------------
  1317. def _format_file_size(size_bytes: int) -> str:
  1318. if size_bytes < 1024:
  1319. return f"{size_bytes} B"
  1320. elif size_bytes < 1024 * 1024:
  1321. return f"{size_bytes / 1024:.1f} KB"
  1322. else:
  1323. return f"{size_bytes / (1024 * 1024):.1f} MB"
  1324. @router.post("/attachment/upload")
  1325. def upload_attachment(
  1326. file: UploadFile = File(...),
  1327. folder: Optional[str] = Form(""),
  1328. biz_type: Optional[str] = Form(None, alias="bizType"),
  1329. user: dict = Depends(require_admin_or_super_admin),
  1330. db: Session = Depends(get_db),
  1331. ):
  1332. if not file or not file.filename:
  1333. return error_response(400, "请选择文件")
  1334. try:
  1335. effective_folder = resolve_upload_folder(
  1336. folder=folder or "", biz_type=biz_type or ""
  1337. )
  1338. file_content = file.file.read()
  1339. full_url = storage.upload_file(file_content, file.filename, effective_folder)
  1340. base_url = settings.MINIO_BASE_URL.rstrip("/") if settings.MINIO_BASE_URL else ""
  1341. if base_url and full_url.startswith(base_url + "/"):
  1342. file_url = full_url[len(base_url) + 1:]
  1343. else:
  1344. file_url = full_url
  1345. file_size = len(file_content)
  1346. file_ext = os.path.splitext(file.filename)[1].lstrip(".") if file.filename else ""
  1347. file_type = file.content_type or ""
  1348. tenant_no = _get_tenant_no(db, user)
  1349. record = oss_svc.create_oss(
  1350. db,
  1351. tenant_no=tenant_no,
  1352. url=file_url,
  1353. original_name=file.filename,
  1354. file_suffix=file_ext,
  1355. file_size=file_size,
  1356. file_type=file_type,
  1357. biz_type=(biz_type or "").strip(),
  1358. user_id=user.get("user_id"),
  1359. ext1=effective_folder or None,
  1360. )
  1361. return success_response({
  1362. "id": record.id,
  1363. "fileName": record.original_name,
  1364. "fileUrl": record.url,
  1365. "fileSize": record.file_size,
  1366. "fileSizeDisplay": _format_file_size(record.file_size or 0),
  1367. "fileType": record.file_type,
  1368. "bizType": record.biz_type or "",
  1369. })
  1370. except Exception as e:
  1371. db.rollback()
  1372. return error_response(500, f"上传失败: {str(e)}")
  1373. class AttachmentDownloadUrlBody(BaseModel):
  1374. model_config = ConfigDict(populate_by_name=True)
  1375. file_url: str = Field(..., alias="fileUrl")
  1376. file_name: Optional[str] = Field(None, alias="fileName")
  1377. @router.post("/attachment/download-url")
  1378. def attachment_download_url(
  1379. body: AttachmentDownloadUrlBody,
  1380. user: dict = Depends(require_admin_or_super_admin),
  1381. db: Session = Depends(get_db),
  1382. ):
  1383. """返回带 Content-Disposition 的下载 URL,保证浏览器使用原始文件名。"""
  1384. file_url = (body.file_url or "").strip()
  1385. if not file_url:
  1386. return error_response(400, "文件地址不能为空")
  1387. tenant_no = _get_tenant_no(db, user)
  1388. file_url, att = oss_svc.resolve_storage_path(db, tenant_no, file_url)
  1389. if not att:
  1390. att = oss_svc.get_oss_by_url(db, tenant_no, file_url)
  1391. download_name = (body.file_name or "").strip()
  1392. if not download_name and att:
  1393. download_name = (att.original_name or "").strip()
  1394. if not download_name:
  1395. download_name = file_url.rsplit("/", 1)[-1] or "download"
  1396. try:
  1397. url = storage.presigned_download_url(file_url, download_name)
  1398. return success_response({"downloadUrl": url})
  1399. except Exception as e:
  1400. return error_response(500, f"获取下载链接失败: {str(e)}")
  1401. @router.post("/attachment/preview-url")
  1402. def attachment_preview_url(
  1403. body: AttachmentDownloadUrlBody,
  1404. user: dict = Depends(require_admin_or_super_admin),
  1405. db: Session = Depends(get_db),
  1406. ):
  1407. """返回用于浏览器内联预览的 URL(PDF iframe 等)。"""
  1408. file_url = (body.file_url or "").strip()
  1409. if not file_url:
  1410. return error_response(400, "文件地址不能为空")
  1411. tenant_no = _get_tenant_no(db, user)
  1412. file_url, _att = oss_svc.resolve_storage_path(db, tenant_no, file_url)
  1413. try:
  1414. url = storage.presigned_preview_url(file_url)
  1415. return success_response({"previewUrl": url})
  1416. except Exception as e:
  1417. return error_response(500, f"获取预览链接失败: {str(e)}")
  1418. # ---------------------------------------------------------------------------
  1419. # 用户菜单收藏
  1420. # ---------------------------------------------------------------------------
  1421. @router.get("/menu-favorites")
  1422. def list_menu_favorites(
  1423. user: dict = Depends(require_admin_or_super_admin),
  1424. db: Session = Depends(get_db),
  1425. ):
  1426. user_id = user.get("user_id")
  1427. if not user_id:
  1428. return error_response(401, "用户无效")
  1429. tenant_no = _get_tenant_no(db, user)
  1430. from app.crud import menu_favorite as fav_svc
  1431. return success_response(fav_svc.list_favorites(db, user_id=user_id, tenant_no=tenant_no))
  1432. @router.post("/menu-favorites")
  1433. def create_menu_favorite(
  1434. body: MenuFavoriteCreateBody,
  1435. user: dict = Depends(require_admin_or_super_admin),
  1436. db: Session = Depends(get_db),
  1437. ):
  1438. from app.crud import menu_favorite as fav_svc
  1439. user_id = user.get("user_id")
  1440. if not user_id:
  1441. return error_response(401, "用户无效")
  1442. tenant_no = _get_tenant_no(db, user)
  1443. try:
  1444. data = fav_svc.add_favorite(
  1445. db,
  1446. user_id=user_id,
  1447. tenant_no=tenant_no,
  1448. menu_path=body.path,
  1449. create_dept_id=str(user.get("dept_id") or ""),
  1450. )
  1451. return success_response(data)
  1452. except ValueError as e:
  1453. return error_response(400, str(e))
  1454. @router.put("/menu-favorites/order")
  1455. def reorder_menu_favorites(
  1456. body: MenuFavoriteReorderBody,
  1457. user: dict = Depends(require_admin_or_super_admin),
  1458. db: Session = Depends(get_db),
  1459. ):
  1460. from app.crud import menu_favorite as fav_svc
  1461. user_id = user.get("user_id")
  1462. if not user_id:
  1463. return error_response(401, "用户无效")
  1464. tenant_no = _get_tenant_no(db, user)
  1465. try:
  1466. data = fav_svc.reorder_favorites(
  1467. db, user_id=user_id, tenant_no=tenant_no, paths=body.paths or []
  1468. )
  1469. return success_response(data)
  1470. except ValueError as e:
  1471. return error_response(400, str(e))
  1472. @router.delete("/menu-favorites")
  1473. def delete_menu_favorite(
  1474. body: MenuFavoriteDeleteBody,
  1475. user: dict = Depends(require_admin_or_super_admin),
  1476. db: Session = Depends(get_db),
  1477. ):
  1478. from app.crud import menu_favorite as fav_svc
  1479. user_id = user.get("user_id")
  1480. if not user_id:
  1481. return error_response(401, "用户无效")
  1482. tenant_no = _get_tenant_no(db, user)
  1483. fav_svc.soft_delete_favorite(
  1484. db, user_id=user_id, tenant_no=tenant_no, menu_path=body.path
  1485. )
  1486. return success_response({"path": body.path})