oa_approval.py 39 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215
  1. """OA 审批管理接口(钉钉交互)"""
  2. from datetime import datetime
  3. from typing import Any, Dict, List, Optional
  4. from fastapi import APIRouter, Depends, Query
  5. from pydantic import BaseModel, ConfigDict, Field
  6. from sqlalchemy.orm import Session
  7. from app.core.database import get_db
  8. from app.core.menu_guard import require_admin_or_super_admin
  9. from app.core.response import error_response, success_response
  10. from app.core.utils import parse_datetime
  11. from app.crud import oa_approval as oa_crud
  12. from app.crud import oa_instance_draft as oid_crud
  13. from app.crud import oa_receive_account as ora_crud
  14. from app.models.models import SysUser
  15. from app.services.oa_receive_account import normalize_account_fields
  16. router = APIRouter(prefix="/web/admin/oa-approval", tags=["OA审批"])
  17. def _get_tenant_no(db: Session, user: dict) -> str:
  18. tenant = (user.get("tenant_no") or "").strip()
  19. if tenant:
  20. return tenant
  21. uid = user.get("user_id")
  22. if uid:
  23. row = db.query(SysUser).filter(SysUser.id == uid, SysUser.del_flag == 0).first()
  24. if row and row.tenant_no:
  25. return row.tenant_no
  26. return "zkxw"
  27. # ---------------------------------------------------------------------------
  28. # 收款账户
  29. # ---------------------------------------------------------------------------
  30. class OaReceiveAccountBody(BaseModel):
  31. model_config = ConfigDict(populate_by_name=True)
  32. account_type: str = Field(..., alias="accountType")
  33. account_name: str = Field(..., alias="accountName")
  34. account_no: str = Field(..., alias="accountNo")
  35. bank_name: Optional[str] = Field(None, alias="bankName")
  36. bank_province: Optional[str] = Field(None, alias="bankProvince")
  37. bank_city: Optional[str] = Field(None, alias="bankCity")
  38. bank_branch: Optional[str] = Field(None, alias="bankBranch")
  39. order_num: Optional[int] = Field(None, alias="orderNum")
  40. remark: Optional[str] = None
  41. class OaReceiveAccountBatchDeleteBody(BaseModel):
  42. model_config = ConfigDict(populate_by_name=True)
  43. ids: List[str] = Field(default_factory=list)
  44. @router.get("/receive-accounts")
  45. async def list_receive_accounts(
  46. page: int = Query(1, ge=1),
  47. pageSize: int = Query(10, ge=1, le=100),
  48. keyword: Optional[str] = None,
  49. accountType: Optional[str] = None,
  50. user: dict = Depends(require_admin_or_super_admin),
  51. db: Session = Depends(get_db),
  52. ):
  53. tenant_no = _get_tenant_no(db, user)
  54. items, total = ora_crud.list_accounts(
  55. db,
  56. tenant_no=tenant_no,
  57. keyword=keyword,
  58. account_type=accountType,
  59. page=page,
  60. page_size=pageSize,
  61. )
  62. return success_response({"list": items, "total": total})
  63. @router.get("/receive-accounts/options")
  64. async def list_receive_account_options(
  65. user: dict = Depends(require_admin_or_super_admin),
  66. db: Session = Depends(get_db),
  67. ):
  68. tenant_no = _get_tenant_no(db, user)
  69. return success_response({"list": ora_crud.list_options(db, tenant_no=tenant_no)})
  70. @router.post("/receive-accounts/batch-delete")
  71. async def batch_delete_receive_accounts(
  72. body: OaReceiveAccountBatchDeleteBody,
  73. user: dict = Depends(require_admin_or_super_admin),
  74. db: Session = Depends(get_db),
  75. ):
  76. tenant_no = _get_tenant_no(db, user)
  77. count = ora_crud.soft_delete_accounts(
  78. db, body.ids, tenant_no=tenant_no, user_id=user.get("user_id")
  79. )
  80. return success_response({"deletedCount": count}, message="删除成功")
  81. @router.post("/receive-accounts")
  82. async def create_receive_account(
  83. body: OaReceiveAccountBody,
  84. user: dict = Depends(require_admin_or_super_admin),
  85. db: Session = Depends(get_db),
  86. ):
  87. ok, err, fields = normalize_account_fields(body.model_dump(by_alias=True))
  88. if not ok:
  89. return error_response(400, err or "参数无效")
  90. tenant_no = _get_tenant_no(db, user)
  91. obj = ora_crud.create_account(
  92. db,
  93. tenant_no=tenant_no,
  94. user_id=user.get("user_id"),
  95. dept_id=user.get("dept_id") or "",
  96. fields=fields,
  97. )
  98. return success_response(obj, message="创建成功")
  99. @router.get("/receive-accounts/{account_id}")
  100. async def get_receive_account(
  101. account_id: str,
  102. user: dict = Depends(require_admin_or_super_admin),
  103. db: Session = Depends(get_db),
  104. ):
  105. tenant_no = _get_tenant_no(db, user)
  106. obj = ora_crud.get_account(db, account_id, tenant_no)
  107. if not obj:
  108. return error_response(404, "收款账户不存在")
  109. return success_response(obj)
  110. @router.put("/receive-accounts/{account_id}")
  111. async def update_receive_account(
  112. account_id: str,
  113. body: OaReceiveAccountBody,
  114. user: dict = Depends(require_admin_or_super_admin),
  115. db: Session = Depends(get_db),
  116. ):
  117. ok, err, fields = normalize_account_fields(body.model_dump(by_alias=True))
  118. if not ok:
  119. return error_response(400, err or "参数无效")
  120. tenant_no = _get_tenant_no(db, user)
  121. obj = ora_crud.update_account(
  122. db,
  123. account_id,
  124. tenant_no=tenant_no,
  125. user_id=user.get("user_id"),
  126. fields=fields,
  127. )
  128. if not obj:
  129. return error_response(404, "收款账户不存在")
  130. return success_response(obj, message="更新成功")
  131. @router.delete("/receive-accounts/{account_id}")
  132. async def delete_receive_account(
  133. account_id: str,
  134. user: dict = Depends(require_admin_or_super_admin),
  135. db: Session = Depends(get_db),
  136. ):
  137. tenant_no = _get_tenant_no(db, user)
  138. if not ora_crud.soft_delete_account(
  139. db, account_id, tenant_no=tenant_no, user_id=user.get("user_id")
  140. ):
  141. return error_response(404, "收款账户不存在")
  142. return success_response(None, message="删除成功")
  143. # ---------------------------------------------------------------------------
  144. # 发起审批草稿箱(oa_instance_draft)
  145. # ---------------------------------------------------------------------------
  146. class OaInstanceDraftBody(BaseModel):
  147. model_config = ConfigDict(populate_by_name=True)
  148. app_id: str = Field(..., alias="appId")
  149. form_data: Optional[Dict[str, Any]] = Field(None, alias="formData")
  150. title: Optional[str] = None
  151. initiator_dept_id: Optional[str] = Field(None, alias="initiatorDeptId")
  152. initiator_select_by_node: Optional[Dict[str, List[str]]] = Field(
  153. None, alias="initiatorSelectByNode"
  154. )
  155. class OaInstanceDraftUpdateBody(BaseModel):
  156. model_config = ConfigDict(populate_by_name=True)
  157. form_data: Optional[Dict[str, Any]] = Field(None, alias="formData")
  158. title: Optional[str] = None
  159. initiator_dept_id: Optional[str] = Field(None, alias="initiatorDeptId")
  160. initiator_select_by_node: Optional[Dict[str, List[str]]] = Field(
  161. None, alias="initiatorSelectByNode"
  162. )
  163. class OaInstanceDraftBatchDeleteBody(BaseModel):
  164. model_config = ConfigDict(populate_by_name=True)
  165. ids: List[str] = Field(default_factory=list)
  166. class OaInstanceDraftSubmitBody(BaseModel):
  167. model_config = ConfigDict(populate_by_name=True)
  168. form_data: Optional[Dict[str, Any]] = Field(None, alias="formData")
  169. title: Optional[str] = None
  170. initiator_dept_id: Optional[str] = Field(None, alias="initiatorDeptId")
  171. initiator_select_by_node: Optional[Dict[str, List[str]]] = Field(
  172. None, alias="initiatorSelectByNode"
  173. )
  174. def _parse_draft_range_end(raw: Optional[str]) -> Optional[datetime]:
  175. """截止日期:仅日期时扩到当天 23:59:59。"""
  176. if not raw or not str(raw).strip():
  177. return None
  178. s = str(raw).strip()
  179. dt = parse_datetime(s)
  180. if dt is None and len(s) == 10:
  181. try:
  182. dt = datetime.strptime(s, "%Y-%m-%d")
  183. except ValueError:
  184. return None
  185. if dt is None:
  186. return None
  187. if len(s) <= 10:
  188. return dt.replace(hour=23, minute=59, second=59)
  189. return dt
  190. def _parse_draft_range_start(raw: Optional[str]) -> Optional[datetime]:
  191. if not raw or not str(raw).strip():
  192. return None
  193. s = str(raw).strip()
  194. dt = parse_datetime(s)
  195. if dt is None and len(s) == 10:
  196. try:
  197. return datetime.strptime(s, "%Y-%m-%d")
  198. except ValueError:
  199. return None
  200. return dt
  201. @router.get("/drafts/count")
  202. async def oa_instance_draft_count(
  203. user: dict = Depends(require_admin_or_super_admin),
  204. db: Session = Depends(get_db),
  205. ):
  206. tenant_no = _get_tenant_no(db, user)
  207. n = oid_crud.count_drafts(
  208. db,
  209. tenant_no=tenant_no,
  210. owner_user_id=user.get("user_id") or "",
  211. )
  212. return success_response({"count": int(n)})
  213. @router.get("/drafts")
  214. async def list_oa_instance_drafts(
  215. page: int = Query(1, ge=1),
  216. pageSize: int = Query(20, ge=1, le=100),
  217. keyword: Optional[str] = None,
  218. groupId: Optional[str] = None,
  219. updateTimeFrom: Optional[str] = None,
  220. updateTimeTo: Optional[str] = None,
  221. user: dict = Depends(require_admin_or_super_admin),
  222. db: Session = Depends(get_db),
  223. ):
  224. tenant_no = _get_tenant_no(db, user)
  225. items, total = oid_crud.list_drafts(
  226. db,
  227. tenant_no=tenant_no,
  228. owner_user_id=user.get("user_id") or "",
  229. keyword=keyword,
  230. group_id=groupId,
  231. update_time_from=_parse_draft_range_start(updateTimeFrom),
  232. update_time_to=_parse_draft_range_end(updateTimeTo),
  233. page=page,
  234. page_size=pageSize,
  235. )
  236. return success_response({"list": items, "total": total})
  237. @router.post("/drafts")
  238. async def create_oa_instance_draft(
  239. body: OaInstanceDraftBody,
  240. user: dict = Depends(require_admin_or_super_admin),
  241. db: Session = Depends(get_db),
  242. ):
  243. try:
  244. tenant_no = _get_tenant_no(db, user)
  245. data = oid_crud.create_draft(
  246. db,
  247. tenant_no=tenant_no,
  248. owner_user_id=user.get("user_id") or "",
  249. app_id=body.app_id,
  250. form_data=body.form_data,
  251. initiator_select_by_node=body.initiator_select_by_node,
  252. initiator_dept_id=body.initiator_dept_id,
  253. title=body.title,
  254. create_dept_id=user.get("dept_id") or "",
  255. )
  256. return success_response(data, message="已存入草稿箱")
  257. except ValueError as e:
  258. return error_response(400, str(e))
  259. @router.post("/drafts/batch-delete")
  260. async def batch_delete_oa_instance_drafts(
  261. body: OaInstanceDraftBatchDeleteBody,
  262. user: dict = Depends(require_admin_or_super_admin),
  263. db: Session = Depends(get_db),
  264. ):
  265. try:
  266. tenant_no = _get_tenant_no(db, user)
  267. n = oid_crud.batch_soft_delete_drafts(
  268. db,
  269. body.ids,
  270. tenant_no=tenant_no,
  271. owner_user_id=user.get("user_id") or "",
  272. )
  273. return success_response({"deleted": n}, message="删除成功")
  274. except oid_crud.DraftAccessError as e:
  275. return error_response(403, str(e))
  276. except ValueError as e:
  277. return error_response(400, str(e))
  278. @router.get("/drafts/{draft_id}")
  279. async def get_oa_instance_draft(
  280. draft_id: str,
  281. user: dict = Depends(require_admin_or_super_admin),
  282. db: Session = Depends(get_db),
  283. ):
  284. try:
  285. tenant_no = _get_tenant_no(db, user)
  286. data = oid_crud.get_draft_detail(
  287. db,
  288. draft_id,
  289. tenant_no=tenant_no,
  290. owner_user_id=user.get("user_id") or "",
  291. )
  292. return success_response(data)
  293. except oid_crud.DraftAccessError as e:
  294. return error_response(404, str(e))
  295. @router.put("/drafts/{draft_id}")
  296. async def update_oa_instance_draft(
  297. draft_id: str,
  298. body: OaInstanceDraftUpdateBody,
  299. user: dict = Depends(require_admin_or_super_admin),
  300. db: Session = Depends(get_db),
  301. ):
  302. try:
  303. tenant_no = _get_tenant_no(db, user)
  304. data = oid_crud.update_draft(
  305. db,
  306. draft_id,
  307. tenant_no=tenant_no,
  308. owner_user_id=user.get("user_id") or "",
  309. form_data=body.form_data,
  310. initiator_select_by_node=body.initiator_select_by_node,
  311. initiator_dept_id=body.initiator_dept_id,
  312. title=body.title,
  313. )
  314. return success_response(data, message="草稿已保存")
  315. except oid_crud.DraftAccessError as e:
  316. return error_response(404, str(e))
  317. except ValueError as e:
  318. return error_response(400, str(e))
  319. @router.delete("/drafts/{draft_id}")
  320. async def delete_oa_instance_draft(
  321. draft_id: str,
  322. user: dict = Depends(require_admin_or_super_admin),
  323. db: Session = Depends(get_db),
  324. ):
  325. try:
  326. tenant_no = _get_tenant_no(db, user)
  327. oid_crud.soft_delete_draft(
  328. db,
  329. draft_id,
  330. tenant_no=tenant_no,
  331. owner_user_id=user.get("user_id") or "",
  332. )
  333. return success_response(None, message="删除成功")
  334. except oid_crud.DraftAccessError as e:
  335. return error_response(404, str(e))
  336. @router.post("/drafts/{draft_id}/submit")
  337. async def submit_oa_instance_draft(
  338. draft_id: str,
  339. body: Optional[OaInstanceDraftSubmitBody] = None,
  340. user: dict = Depends(require_admin_or_super_admin),
  341. db: Session = Depends(get_db),
  342. ):
  343. from app.services.oa_engine import OaEngineError
  344. payload = body or OaInstanceDraftSubmitBody()
  345. try:
  346. tenant_no = _get_tenant_no(db, user)
  347. data = oid_crud.submit_draft(
  348. db,
  349. draft_id,
  350. tenant_no=tenant_no,
  351. owner_user_id=user.get("user_id") or "",
  352. form_data=payload.form_data,
  353. initiator_select_by_node=payload.initiator_select_by_node,
  354. initiator_dept_id=payload.initiator_dept_id,
  355. title=payload.title,
  356. )
  357. return success_response(data, message="发起成功")
  358. except oid_crud.DraftAccessError as e:
  359. return error_response(404, str(e))
  360. except OaEngineError as e:
  361. return error_response(400, str(e))
  362. except ValueError as e:
  363. return error_response(400, str(e))
  364. # ---------------------------------------------------------------------------
  365. # 分组
  366. # ---------------------------------------------------------------------------
  367. class OaGroupCreateBody(BaseModel):
  368. model_config = ConfigDict(populate_by_name=True)
  369. group_name: str = Field(..., alias="groupName")
  370. order_num: Optional[int] = Field(None, alias="orderNum")
  371. remark: Optional[str] = None
  372. class OaGroupUpdateBody(BaseModel):
  373. model_config = ConfigDict(populate_by_name=True)
  374. group_name: Optional[str] = Field(None, alias="groupName")
  375. order_num: Optional[int] = Field(None, alias="orderNum")
  376. remark: Optional[str] = None
  377. @router.get("/groups")
  378. async def list_oa_groups(
  379. user: dict = Depends(require_admin_or_super_admin),
  380. db: Session = Depends(get_db),
  381. ):
  382. tenant_no = _get_tenant_no(db, user)
  383. return success_response({"list": oa_crud.list_groups(db, tenant_no=tenant_no)})
  384. @router.post("/groups")
  385. async def create_oa_group(
  386. body: OaGroupCreateBody,
  387. user: dict = Depends(require_admin_or_super_admin),
  388. db: Session = Depends(get_db),
  389. ):
  390. try:
  391. tenant_no = _get_tenant_no(db, user)
  392. obj = oa_crud.create_group(
  393. db,
  394. tenant_no=tenant_no,
  395. group_name=body.group_name,
  396. order_num=body.order_num,
  397. remark=body.remark,
  398. user_id=user.get("user_id"),
  399. )
  400. return success_response(oa_crud._group_to_dict(obj), message="创建成功")
  401. except ValueError as e:
  402. return error_response(400, str(e))
  403. @router.put("/groups/{group_id}")
  404. async def update_oa_group(
  405. group_id: str,
  406. body: OaGroupUpdateBody,
  407. user: dict = Depends(require_admin_or_super_admin),
  408. db: Session = Depends(get_db),
  409. ):
  410. try:
  411. tenant_no = _get_tenant_no(db, user)
  412. payload = body.model_dump(exclude_unset=True, by_alias=False)
  413. obj = oa_crud.update_group(
  414. db,
  415. group_id,
  416. tenant_no=tenant_no,
  417. group_name=payload.get("group_name"),
  418. order_num=payload.get("order_num"),
  419. remark=payload.get("remark"),
  420. user_id=user.get("user_id"),
  421. )
  422. return success_response(oa_crud._group_to_dict(obj), message="更新成功")
  423. except ValueError as e:
  424. return error_response(400, str(e))
  425. @router.delete("/groups/{group_id}")
  426. async def delete_oa_group(
  427. group_id: str,
  428. user: dict = Depends(require_admin_or_super_admin),
  429. db: Session = Depends(get_db),
  430. ):
  431. try:
  432. tenant_no = _get_tenant_no(db, user)
  433. oa_crud.delete_group(db, group_id, tenant_no=tenant_no, user_id=user.get("user_id"))
  434. return success_response(None, message="删除成功")
  435. except ValueError as e:
  436. return error_response(400, str(e))
  437. # ---------------------------------------------------------------------------
  438. # 应用 / 草稿
  439. # ---------------------------------------------------------------------------
  440. class OaAppCreateBody(BaseModel):
  441. model_config = ConfigDict(populate_by_name=True)
  442. app_name: str = Field(..., alias="appName")
  443. group_id: Optional[str] = Field(None, alias="groupId")
  444. icon_url: Optional[str] = Field(None, alias="iconUrl")
  445. description: Optional[str] = None
  446. initiator_scope: Optional[str] = Field("all", alias="initiatorScope")
  447. initiator_user_ids: Optional[List[str]] = Field(None, alias="initiatorUserIds")
  448. admin_scope: Optional[str] = Field("all_oa_admin", alias="adminScope")
  449. admin_user_ids: Optional[List[str]] = Field(None, alias="adminUserIds")
  450. status: Optional[str] = "1"
  451. order_num: Optional[int] = Field(None, alias="orderNum")
  452. remark: Optional[str] = None
  453. class OaAppUpdateBody(BaseModel):
  454. model_config = ConfigDict(populate_by_name=True)
  455. app_name: Optional[str] = Field(None, alias="appName")
  456. group_id: Optional[str] = Field(None, alias="groupId")
  457. icon_url: Optional[str] = Field(None, alias="iconUrl")
  458. description: Optional[str] = None
  459. initiator_scope: Optional[str] = Field(None, alias="initiatorScope")
  460. initiator_user_ids: Optional[List[str]] = Field(None, alias="initiatorUserIds")
  461. admin_scope: Optional[str] = Field(None, alias="adminScope")
  462. admin_user_ids: Optional[List[str]] = Field(None, alias="adminUserIds")
  463. status: Optional[str] = None
  464. order_num: Optional[int] = Field(None, alias="orderNum")
  465. remark: Optional[str] = None
  466. class OaDraftSaveBody(BaseModel):
  467. model_config = ConfigDict(populate_by_name=True)
  468. basic: Optional[Dict[str, Any]] = None
  469. form_schema_json: Optional[Any] = Field(None, alias="formSchemaJson")
  470. flow_tree_json: Optional[Any] = Field(None, alias="flowTreeJson")
  471. advanced_settings_json: Optional[Any] = Field(None, alias="advancedSettingsJson")
  472. @router.get("/apps")
  473. async def list_oa_apps(
  474. groupId: Optional[str] = None,
  475. keyword: Optional[str] = None,
  476. status: Optional[str] = None,
  477. user: dict = Depends(require_admin_or_super_admin),
  478. db: Session = Depends(get_db),
  479. ):
  480. tenant_no = _get_tenant_no(db, user)
  481. items = oa_crud.list_apps(
  482. db, tenant_no=tenant_no, group_id=groupId, keyword=keyword, status=status
  483. )
  484. return success_response({"list": items})
  485. @router.post("/apps")
  486. async def create_oa_app(
  487. body: OaAppCreateBody,
  488. user: dict = Depends(require_admin_or_super_admin),
  489. db: Session = Depends(get_db),
  490. ):
  491. try:
  492. tenant_no = _get_tenant_no(db, user)
  493. obj = oa_crud.create_app(
  494. db,
  495. tenant_no=tenant_no,
  496. app_name=body.app_name,
  497. group_id=body.group_id,
  498. icon_url=body.icon_url,
  499. description=body.description,
  500. initiator_scope=body.initiator_scope or "all",
  501. initiator_user_ids=body.initiator_user_ids,
  502. admin_scope=body.admin_scope or "all_oa_admin",
  503. admin_user_ids=body.admin_user_ids,
  504. status=body.status or "1",
  505. order_num=body.order_num,
  506. remark=body.remark,
  507. user_id=user.get("user_id"),
  508. )
  509. group_name = ""
  510. if obj.group_id:
  511. g = oa_crud.get_group(db, obj.group_id, tenant_no)
  512. group_name = g.group_name if g else ""
  513. return success_response(
  514. oa_crud._app_to_dict(obj, group_name=group_name, has_draft=True),
  515. message="创建成功",
  516. )
  517. except ValueError as e:
  518. return error_response(400, str(e))
  519. @router.post("/apps/{app_id}/copy")
  520. async def copy_oa_app(
  521. app_id: str,
  522. user: dict = Depends(require_admin_or_super_admin),
  523. db: Session = Depends(get_db),
  524. ):
  525. try:
  526. tenant_no = _get_tenant_no(db, user)
  527. obj = oa_crud.copy_app(
  528. db, app_id, tenant_no=tenant_no, user_id=user.get("user_id")
  529. )
  530. group_name = ""
  531. if obj.group_id:
  532. g = oa_crud.get_group(db, obj.group_id, tenant_no)
  533. group_name = g.group_name if g else ""
  534. return success_response(
  535. oa_crud._app_to_dict(obj, group_name=group_name, has_draft=True),
  536. message="复制成功",
  537. )
  538. except ValueError as e:
  539. return error_response(400, str(e))
  540. @router.put("/apps/{app_id}")
  541. async def update_oa_app(
  542. app_id: str,
  543. body: OaAppUpdateBody,
  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 = body.model_dump(exclude_unset=True, by_alias=False)
  550. obj = oa_crud.update_app(db, app_id, tenant_no=tenant_no, user_id=user.get("user_id"), **payload)
  551. group_name = ""
  552. if obj.group_id:
  553. g = oa_crud.get_group(db, obj.group_id, tenant_no)
  554. group_name = g.group_name if g else ""
  555. return success_response(oa_crud._app_to_dict(obj, group_name=group_name), message="更新成功")
  556. except ValueError as e:
  557. return error_response(400, str(e))
  558. @router.delete("/apps/{app_id}")
  559. async def delete_oa_app(
  560. app_id: str,
  561. user: dict = Depends(require_admin_or_super_admin),
  562. db: Session = Depends(get_db),
  563. ):
  564. try:
  565. tenant_no = _get_tenant_no(db, user)
  566. oa_crud.delete_app(db, app_id, tenant_no=tenant_no, user_id=user.get("user_id"))
  567. return success_response(None, message="删除成功")
  568. except ValueError as e:
  569. return error_response(400, str(e))
  570. @router.get("/apps/{app_id}/draft")
  571. async def get_oa_app_draft(
  572. app_id: str,
  573. user: dict = Depends(require_admin_or_super_admin),
  574. db: Session = Depends(get_db),
  575. ):
  576. try:
  577. tenant_no = _get_tenant_no(db, user)
  578. data = oa_crud.get_or_create_draft(
  579. db, app_id, tenant_no=tenant_no, user_id=user.get("user_id")
  580. )
  581. return success_response(data)
  582. except ValueError as e:
  583. return error_response(400, str(e))
  584. @router.put("/apps/{app_id}/draft")
  585. async def save_oa_app_draft(
  586. app_id: str,
  587. body: OaDraftSaveBody,
  588. user: dict = Depends(require_admin_or_super_admin),
  589. db: Session = Depends(get_db),
  590. ):
  591. try:
  592. tenant_no = _get_tenant_no(db, user)
  593. data = oa_crud.save_draft(
  594. db,
  595. app_id,
  596. tenant_no=tenant_no,
  597. basic=body.basic,
  598. form_schema_json=body.form_schema_json,
  599. flow_tree_json=body.flow_tree_json,
  600. advanced_settings_json=body.advanced_settings_json,
  601. user_id=user.get("user_id"),
  602. )
  603. return success_response(data, message="草稿已保存")
  604. except ValueError as e:
  605. return error_response(400, str(e))
  606. @router.post("/apps/{app_id}/publish")
  607. async def publish_oa_app(
  608. app_id: str,
  609. user: dict = Depends(require_admin_or_super_admin),
  610. db: Session = Depends(get_db),
  611. ):
  612. from app.services.oa_publish import publish_app
  613. tenant_no = _get_tenant_no(db, user)
  614. data, errors = publish_app(
  615. db, app_id, tenant_no=tenant_no, user_id=user.get("user_id")
  616. )
  617. if errors:
  618. return error_response(400, "发布校验未通过", data={"errors": errors})
  619. return success_response(data, message="发布成功")
  620. # ---------------------------------------------------------------------------
  621. # 运行时:模板 / 实例 / 任务
  622. # ---------------------------------------------------------------------------
  623. class OaStartInstanceBody(BaseModel):
  624. model_config = ConfigDict(populate_by_name=True)
  625. app_id: str = Field(..., alias="appId")
  626. form_data: Optional[Dict[str, Any]] = Field(None, alias="formData")
  627. title: Optional[str] = None
  628. initiator_dept_id: Optional[str] = Field(None, alias="initiatorDeptId")
  629. initiator_select_by_node: Optional[Dict[str, List[str]]] = Field(
  630. None, alias="initiatorSelectByNode"
  631. )
  632. related_instance_ids: Optional[List[str]] = Field(None, alias="relatedInstanceIds")
  633. source_instance_id: Optional[str] = Field(None, alias="sourceInstanceId")
  634. class OaFlowPreviewBody(BaseModel):
  635. model_config = ConfigDict(populate_by_name=True)
  636. form_data: Optional[Dict[str, Any]] = Field(None, alias="formData")
  637. initiator_select_by_node: Optional[Dict[str, List[str]]] = Field(
  638. None, alias="initiatorSelectByNode"
  639. )
  640. class OaTaskActionBody(BaseModel):
  641. model_config = ConfigDict(populate_by_name=True)
  642. comment: Optional[str] = None
  643. class OaCcReadBatchBody(BaseModel):
  644. model_config = ConfigDict(populate_by_name=True)
  645. ids: List[str] = Field(default_factory=list)
  646. class OaAddSignBody(BaseModel):
  647. model_config = ConfigDict(populate_by_name=True)
  648. user_ids: List[str] = Field(default_factory=list, alias="userIds")
  649. comment: Optional[str] = None
  650. class OaTransferBody(BaseModel):
  651. model_config = ConfigDict(populate_by_name=True)
  652. target_user_id: str = Field(..., alias="targetUserId")
  653. comment: Optional[str] = None
  654. class OaResubmitBody(BaseModel):
  655. model_config = ConfigDict(populate_by_name=True)
  656. form_data: Optional[Dict[str, Any]] = Field(None, alias="formData")
  657. initiator_select_by_node: Optional[Dict[str, List[str]]] = Field(
  658. None, alias="initiatorSelectByNode"
  659. )
  660. @router.get("/templates")
  661. async def list_oa_templates(
  662. user: dict = Depends(require_admin_or_super_admin),
  663. db: Session = Depends(get_db),
  664. ):
  665. from app.services import oa_engine
  666. tenant_no = _get_tenant_no(db, user)
  667. items = oa_engine.list_templates(db, tenant_no=tenant_no, user_id=user.get("user_id") or "")
  668. return success_response({"list": items})
  669. @router.get("/templates/{app_id}")
  670. async def get_oa_template(
  671. app_id: str,
  672. user: dict = Depends(require_admin_or_super_admin),
  673. db: Session = Depends(get_db),
  674. ):
  675. from app.services.oa_engine import OaEngineError, get_template_detail
  676. try:
  677. tenant_no = _get_tenant_no(db, user)
  678. data = get_template_detail(
  679. db,
  680. tenant_no=tenant_no,
  681. app_id=app_id,
  682. user_id=user.get("user_id") or "",
  683. )
  684. return success_response(data)
  685. except OaEngineError as e:
  686. return error_response(400, str(e))
  687. @router.post("/templates/{app_id}/flow-preview")
  688. async def preview_oa_template_flow(
  689. app_id: str,
  690. body: OaFlowPreviewBody,
  691. user: dict = Depends(require_admin_or_super_admin),
  692. db: Session = Depends(get_db),
  693. ):
  694. """发起前预览审批链(条件齐后解析最终路径与审批人)。"""
  695. from app.services.oa_engine import OaEngineError, preview_start_flow
  696. try:
  697. tenant_no = _get_tenant_no(db, user)
  698. uid = user.get("user_id") or ""
  699. dept_id = None
  700. if uid:
  701. row = db.query(SysUser).filter(SysUser.id == uid, SysUser.del_flag == 0).first()
  702. if row:
  703. dept_id = row.dept_id
  704. data = preview_start_flow(
  705. db,
  706. tenant_no=tenant_no,
  707. app_id=app_id,
  708. initiator_user_id=uid,
  709. initiator_dept_id=dept_id,
  710. initiator_select_by_node=body.initiator_select_by_node,
  711. form_data=body.form_data,
  712. )
  713. return success_response(data)
  714. except OaEngineError as e:
  715. return error_response(400, str(e))
  716. @router.get("/templates/{app_id}/flow-preview")
  717. async def preview_oa_template_flow_get(
  718. app_id: str,
  719. user: dict = Depends(require_admin_or_super_admin),
  720. db: Session = Depends(get_db),
  721. ):
  722. """兼容旧 GET:无 formData,含条件分支时多为待确定占位。"""
  723. from app.services.oa_engine import OaEngineError, preview_start_flow
  724. try:
  725. tenant_no = _get_tenant_no(db, user)
  726. uid = user.get("user_id") or ""
  727. dept_id = None
  728. if uid:
  729. row = db.query(SysUser).filter(SysUser.id == uid, SysUser.del_flag == 0).first()
  730. if row:
  731. dept_id = row.dept_id
  732. data = preview_start_flow(
  733. db,
  734. tenant_no=tenant_no,
  735. app_id=app_id,
  736. initiator_user_id=uid,
  737. initiator_dept_id=dept_id,
  738. initiator_select_by_node=None,
  739. form_data=None,
  740. )
  741. return success_response(data)
  742. except OaEngineError as e:
  743. return error_response(400, str(e))
  744. @router.post("/instances")
  745. async def start_oa_instance(
  746. body: OaStartInstanceBody,
  747. user: dict = Depends(require_admin_or_super_admin),
  748. db: Session = Depends(get_db),
  749. ):
  750. from app.services.oa_engine import OaEngineError, start_instance
  751. try:
  752. tenant_no = _get_tenant_no(db, user)
  753. data = start_instance(
  754. db,
  755. tenant_no=tenant_no,
  756. app_id=body.app_id,
  757. initiator_user_id=user.get("user_id") or "",
  758. initiator_dept_id=body.initiator_dept_id,
  759. form_data=body.form_data,
  760. title=body.title,
  761. initiator_select_by_node=body.initiator_select_by_node,
  762. related_instance_ids=body.related_instance_ids,
  763. source_instance_id=body.source_instance_id,
  764. )
  765. return success_response(data, message="发起成功")
  766. except OaEngineError as e:
  767. return error_response(400, str(e))
  768. @router.get("/instances/{instance_id}")
  769. async def get_oa_instance(
  770. instance_id: str,
  771. user: dict = Depends(require_admin_or_super_admin),
  772. db: Session = Depends(get_db),
  773. ):
  774. from app.services.oa_engine import OaEngineError, get_instance_detail
  775. try:
  776. tenant_no = _get_tenant_no(db, user)
  777. return success_response(get_instance_detail(db, instance_id, tenant_no=tenant_no))
  778. except OaEngineError as e:
  779. return error_response(400, str(e))
  780. @router.get("/related-candidates")
  781. async def list_related_candidates(
  782. keyword: str = Query(""),
  783. page: int = Query(1),
  784. pageSize: int = Query(20, alias="pageSize"),
  785. user: dict = Depends(require_admin_or_super_admin),
  786. db: Session = Depends(get_db),
  787. ):
  788. from app.services import oa_related_approval as rel
  789. tenant_no = _get_tenant_no(db, user)
  790. data = rel.list_related_candidates(
  791. db,
  792. tenant_no=tenant_no,
  793. user_id=user.get("user_id") or "",
  794. keyword=keyword,
  795. page=page,
  796. page_size=pageSize,
  797. )
  798. return success_response(data)
  799. @router.get("/related-summaries")
  800. async def get_related_summaries(
  801. ids: str = Query("", description="comma-separated instance ids"),
  802. mode: str = Query("picker"),
  803. user: dict = Depends(require_admin_or_super_admin),
  804. db: Session = Depends(get_db),
  805. ):
  806. from app.services import oa_related_approval as rel
  807. from app.services.oa_engine import OaEngineError
  808. tenant_no = _get_tenant_no(db, user)
  809. id_list = [x.strip() for x in (ids or "").split(",") if x.strip()]
  810. try:
  811. items = rel.build_related_summaries(
  812. db,
  813. tenant_no=tenant_no,
  814. user_id=user.get("user_id") or "",
  815. ids=id_list,
  816. mode=mode,
  817. )
  818. except OaEngineError as e:
  819. return error_response(400, str(e))
  820. return success_response({"list": items})
  821. @router.get("/tasks/pending/count")
  822. async def oa_pending_task_count(
  823. user: dict = Depends(require_admin_or_super_admin),
  824. db: Session = Depends(get_db),
  825. ):
  826. from app.services.oa_engine import OaEngineError, count_pending_tasks
  827. try:
  828. tenant_no = _get_tenant_no(db, user)
  829. n = count_pending_tasks(
  830. db, tenant_no=tenant_no, user_id=user.get("user_id") or ""
  831. )
  832. return success_response({"count": int(n)})
  833. except OaEngineError as e:
  834. return error_response(400, str(e))
  835. @router.get("/tasks/cc/unread-count")
  836. async def oa_cc_unread_count(
  837. user: dict = Depends(require_admin_or_super_admin),
  838. db: Session = Depends(get_db),
  839. ):
  840. from app.services.oa_engine import OaEngineError, count_cc_unread
  841. try:
  842. tenant_no = _get_tenant_no(db, user)
  843. n = count_cc_unread(
  844. db, tenant_no=tenant_no, user_id=user.get("user_id") or ""
  845. )
  846. return success_response({"count": int(n)})
  847. except OaEngineError as e:
  848. return error_response(400, str(e))
  849. @router.post("/tasks/cc/read-batch")
  850. async def oa_cc_read_batch(
  851. body: OaCcReadBatchBody,
  852. user: dict = Depends(require_admin_or_super_admin),
  853. db: Session = Depends(get_db),
  854. ):
  855. from app.services.oa_engine import OaEngineError, mark_cc_tasks_read_batch
  856. try:
  857. tenant_no = _get_tenant_no(db, user)
  858. data = mark_cc_tasks_read_batch(
  859. db,
  860. tenant_no=tenant_no,
  861. user_id=user.get("user_id") or "",
  862. ids=body.ids or [],
  863. )
  864. return success_response(data, message="已标记已读")
  865. except OaEngineError as e:
  866. return error_response(400, str(e))
  867. @router.post("/tasks/{task_id}/read")
  868. async def oa_task_mark_read(
  869. task_id: str,
  870. user: dict = Depends(require_admin_or_super_admin),
  871. db: Session = Depends(get_db),
  872. ):
  873. from app.services.oa_engine import OaEngineError, mark_cc_task_read
  874. try:
  875. tenant_no = _get_tenant_no(db, user)
  876. data = mark_cc_task_read(
  877. db,
  878. tenant_no=tenant_no,
  879. user_id=user.get("user_id") or "",
  880. task_id=task_id,
  881. )
  882. return success_response(data, message="已标记已读")
  883. except OaEngineError as e:
  884. return error_response(400, str(e))
  885. @router.get("/tasks/{kind}")
  886. async def list_oa_tasks(
  887. kind: str,
  888. readStatus: Optional[str] = Query(None, alias="readStatus"),
  889. user: dict = Depends(require_admin_or_super_admin),
  890. db: Session = Depends(get_db),
  891. ):
  892. from app.services.oa_engine import OaEngineError, list_tasks
  893. try:
  894. tenant_no = _get_tenant_no(db, user)
  895. items = list_tasks(
  896. db,
  897. tenant_no=tenant_no,
  898. user_id=user.get("user_id") or "",
  899. kind=kind,
  900. read_status=readStatus,
  901. )
  902. return success_response({"list": items})
  903. except OaEngineError as e:
  904. return error_response(400, str(e))
  905. @router.post("/tasks/{task_id}/approve")
  906. async def approve_oa_task(
  907. task_id: str,
  908. body: Optional[OaTaskActionBody] = None,
  909. user: dict = Depends(require_admin_or_super_admin),
  910. db: Session = Depends(get_db),
  911. ):
  912. from app.services.oa_engine import OaEngineError, complete_task
  913. try:
  914. tenant_no = _get_tenant_no(db, user)
  915. data = complete_task(
  916. db,
  917. task_id,
  918. tenant_no=tenant_no,
  919. user_id=user.get("user_id") or "",
  920. action="approve",
  921. comment=(body.comment if body else None),
  922. )
  923. return success_response(data, message="已同意")
  924. except OaEngineError as e:
  925. return error_response(400, str(e))
  926. @router.post("/tasks/{task_id}/reject")
  927. async def reject_oa_task(
  928. task_id: str,
  929. body: Optional[OaTaskActionBody] = None,
  930. user: dict = Depends(require_admin_or_super_admin),
  931. db: Session = Depends(get_db),
  932. ):
  933. from app.services.oa_engine import OaEngineError, complete_task
  934. try:
  935. tenant_no = _get_tenant_no(db, user)
  936. data = complete_task(
  937. db,
  938. task_id,
  939. tenant_no=tenant_no,
  940. user_id=user.get("user_id") or "",
  941. action="reject",
  942. comment=(body.comment if body else None),
  943. )
  944. return success_response(data, message="已拒绝")
  945. except OaEngineError as e:
  946. return error_response(400, str(e))
  947. @router.post("/tasks/{task_id}/return")
  948. async def return_oa_task(
  949. task_id: str,
  950. body: Optional[OaTaskActionBody] = None,
  951. user: dict = Depends(require_admin_or_super_admin),
  952. db: Session = Depends(get_db),
  953. ):
  954. from app.services.oa_engine import OaEngineError, return_task
  955. try:
  956. tenant_no = _get_tenant_no(db, user)
  957. data = return_task(
  958. db,
  959. task_id,
  960. tenant_no=tenant_no,
  961. user_id=user.get("user_id") or "",
  962. comment=(body.comment if body else None),
  963. )
  964. return success_response(data, message="已打回")
  965. except OaEngineError as e:
  966. return error_response(400, str(e))
  967. @router.post("/instances/{instance_id}/resubmit")
  968. async def resubmit_oa_instance(
  969. instance_id: str,
  970. body: Optional[OaResubmitBody] = None,
  971. user: dict = Depends(require_admin_or_super_admin),
  972. db: Session = Depends(get_db),
  973. ):
  974. from app.services.oa_engine import OaEngineError, resubmit_instance
  975. try:
  976. tenant_no = _get_tenant_no(db, user)
  977. data = resubmit_instance(
  978. db,
  979. instance_id,
  980. tenant_no=tenant_no,
  981. user_id=user.get("user_id") or "",
  982. form_data=(body.form_data if body else None),
  983. initiator_select_by_node=(body.initiator_select_by_node if body else None),
  984. )
  985. return success_response(data, message="已再次提交")
  986. except OaEngineError as e:
  987. return error_response(400, str(e))
  988. @router.post("/tasks/{task_id}/add-sign")
  989. async def add_sign_oa_task(
  990. task_id: str,
  991. body: OaAddSignBody,
  992. user: dict = Depends(require_admin_or_super_admin),
  993. db: Session = Depends(get_db),
  994. ):
  995. from app.services.oa_engine import OaEngineError, add_sign
  996. try:
  997. tenant_no = _get_tenant_no(db, user)
  998. data = add_sign(
  999. db,
  1000. task_id,
  1001. tenant_no=tenant_no,
  1002. user_id=user.get("user_id") or "",
  1003. user_ids=body.user_ids,
  1004. comment=body.comment,
  1005. )
  1006. return success_response(data, message="加签成功")
  1007. except OaEngineError as e:
  1008. return error_response(400, str(e))
  1009. @router.post("/tasks/{task_id}/transfer")
  1010. async def transfer_oa_task(
  1011. task_id: str,
  1012. body: OaTransferBody,
  1013. user: dict = Depends(require_admin_or_super_admin),
  1014. db: Session = Depends(get_db),
  1015. ):
  1016. from app.services.oa_engine import OaEngineError, transfer_task
  1017. try:
  1018. tenant_no = _get_tenant_no(db, user)
  1019. data = transfer_task(
  1020. db,
  1021. task_id,
  1022. tenant_no=tenant_no,
  1023. user_id=user.get("user_id") or "",
  1024. target_user_id=body.target_user_id,
  1025. comment=body.comment,
  1026. )
  1027. return success_response(data, message="已转交")
  1028. except OaEngineError as e:
  1029. return error_response(400, str(e))
  1030. @router.post("/instances/{instance_id}/withdraw")
  1031. async def withdraw_oa_instance(
  1032. instance_id: str,
  1033. user: dict = Depends(require_admin_or_super_admin),
  1034. db: Session = Depends(get_db),
  1035. ):
  1036. from app.services.oa_engine import OaEngineError, withdraw_instance
  1037. try:
  1038. tenant_no = _get_tenant_no(db, user)
  1039. data = withdraw_instance(
  1040. db, instance_id, tenant_no=tenant_no, user_id=user.get("user_id") or ""
  1041. )
  1042. return success_response(data, message="已撤销")
  1043. except OaEngineError as e:
  1044. return error_response(400, str(e))