crm_contract_routes.py 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853
  1. """CRM 合同 API 路由 — GET/PUT/DELETE/POST 对齐原 Java CRM"""
  2. from __future__ import annotations
  3. from datetime import datetime
  4. from typing import Optional
  5. from fastapi import Depends, Query, Request
  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, require_menu_code
  9. from app.core.oper_log_decorator import oper_log
  10. from app.core.response import error_response, success_response
  11. from app.core.tenant_context import get_tenant_no
  12. from app.crud.crm.data_scope_helpers import crm_user_info
  13. from app.crud.crm.contract import (
  14. batch_assign_owner,
  15. batch_submit_contract_approval,
  16. create_contract,
  17. create_from_opportunity,
  18. create_from_quote,
  19. download_contract_pdf,
  20. export_contracts,
  21. finish_contract,
  22. get_contract_detail,
  23. get_template,
  24. invalid_contract,
  25. list_contracts,
  26. query_expiring,
  27. renew_contract,
  28. save_template,
  29. sign_contract,
  30. soft_delete_contracts,
  31. start_execute,
  32. statistics_by_status,
  33. statistics_by_type,
  34. statistics_overview,
  35. statistics_trend,
  36. submit_contract_approval,
  37. total_pages,
  38. update_contract,
  39. upload_attachments,
  40. upload_attachments_with_category,
  41. upload_file,
  42. withdraw_contract_approval,
  43. )
  44. from app.crud.crm.contract_approval import (
  45. approve_contract_by_contract_id,
  46. list_contract_approvals,
  47. )
  48. from app.crud.crm.contract_approver_setting import get_setting as get_contract_approver_setting
  49. from app.crud.crm.contract_approver_setting import save_setting as save_contract_approver_setting
  50. from app.schemas.crm.contract_approver_setting import ContractApproverSettingSaveBody
  51. from app.schemas.crm.contract import (
  52. ContractApprovalActionBody,
  53. ContractBatchAssignBody,
  54. ContractBatchSubmitBody,
  55. ContractCreateBody,
  56. ContractExportBody,
  57. ContractInvalidBody,
  58. ContractListQuery,
  59. ContractRenewBody,
  60. ContractSignBody,
  61. ContractStatisticsOverviewQuery,
  62. ContractStatisticsTrendQuery,
  63. ContractStatusBody,
  64. ContractSubmitBody,
  65. ContractTemplateSaveBody,
  66. ContractUpdateBody,
  67. ContractUploadAttachmentsBody,
  68. ContractUploadFileBody,
  69. ContractWithdrawBody,
  70. )
  71. from app.utils.crm_export_columns import CONTRACT_EXPORT_COLUMNS
  72. from app.utils.excel_export import (
  73. ExportValidationError,
  74. export_rows_to_xlsx_response,
  75. filter_export_columns,
  76. )
  77. from app.api.crm import _filter_export_rows_by_ids
  78. def register_contract_routes(router):
  79. @router.get("/contract/list")
  80. async def contract_list(
  81. request: Request,
  82. pageNum: int = Query(1, ge=1),
  83. pageSize: int = Query(10, ge=1, le=500),
  84. keyword: Optional[str] = Query(
  85. None, description="即时检索:合同编号/合同产品名称/产品拼音首字母"
  86. ),
  87. contractNo: Optional[str] = None,
  88. contractName: Optional[str] = None,
  89. customerName: Optional[str] = None,
  90. customerId: Optional[str] = None,
  91. opportunityId: Optional[str] = None,
  92. quoteId: Optional[str] = None,
  93. contractType: Optional[str] = None,
  94. status: Optional[str] = None,
  95. excludeStatus: Optional[str] = None,
  96. approvalStatus: Optional[str] = None,
  97. ownerUserId: Optional[str] = None,
  98. pendingApprovalUserId: Optional[str] = None,
  99. approvedByUserId: Optional[str] = None,
  100. minAmount: Optional[float] = None,
  101. maxAmount: Optional[float] = None,
  102. signDateBegin: Optional[str] = None,
  103. signDateEnd: Optional[str] = None,
  104. beginTime: Optional[str] = None,
  105. endTime: Optional[str] = None,
  106. includeProducts: bool = Query(False, description="是否附带合同产品明细"),
  107. _user: dict = Depends(require_admin_or_super_admin),
  108. db: Session = Depends(get_db),
  109. ):
  110. try:
  111. tenant_no = get_tenant_no(db, _user)
  112. user_info = crm_user_info(_user)
  113. user_id = _user.get("user_id", "") or _user.get("id", "")
  114. query = ContractListQuery(
  115. pageNum=pageNum,
  116. pageSize=pageSize,
  117. keyword=keyword,
  118. contractNo=contractNo,
  119. contractName=contractName,
  120. customerName=customerName,
  121. customerId=customerId,
  122. opportunityId=opportunityId,
  123. quoteId=quoteId,
  124. contractType=contractType,
  125. status=status,
  126. excludeStatus=excludeStatus,
  127. approvalStatus=approvalStatus,
  128. ownerUserId=ownerUserId,
  129. pendingApprovalUserId=pendingApprovalUserId,
  130. approvedByUserId=approvedByUserId,
  131. minAmount=minAmount,
  132. maxAmount=maxAmount,
  133. signDateBegin=signDateBegin,
  134. signDateEnd=signDateEnd,
  135. beginTime=beginTime,
  136. endTime=endTime,
  137. )
  138. filters = query.model_dump(
  139. by_alias=True,
  140. exclude={"pageNum", "pageSize"},
  141. exclude_none=True,
  142. )
  143. # 列头漏斗等未在签名中声明的 query 参数一并透传
  144. skip_keys = {
  145. "pageNum",
  146. "pageSize",
  147. "includeProducts",
  148. *filters.keys(),
  149. }
  150. for key, val in request.query_params.multi_items():
  151. if key in skip_keys or val is None or str(val).strip() == "":
  152. continue
  153. filters[key] = val
  154. rows, total = list_contracts(
  155. db,
  156. tenant_no,
  157. user_info=user_info,
  158. page=query.pageNum,
  159. page_size=query.pageSize,
  160. filters=filters,
  161. current_user_id=user_id,
  162. include_products=includeProducts,
  163. )
  164. tp = total_pages(total, query.pageSize)
  165. return success_response(
  166. {
  167. "list": rows,
  168. "rows": rows,
  169. "total": total,
  170. "pageNum": query.pageNum,
  171. "pageSize": query.pageSize,
  172. "totalPages": tp,
  173. }
  174. )
  175. except ValueError as e:
  176. return error_response(400, str(e))
  177. except Exception as e:
  178. return error_response(500, str(e))
  179. @router.post("/contract")
  180. @oper_log(title="CRM合同管理", business_type=1, summary="新增合同【{contractName}】")
  181. async def contract_add(
  182. body: ContractCreateBody,
  183. _user: dict = Depends(require_admin_or_super_admin),
  184. db: Session = Depends(get_db),
  185. ):
  186. try:
  187. tenant_no = get_tenant_no(db, _user)
  188. user_info = crm_user_info(_user)
  189. user_id = _user.get("user_id", "") or _user.get("id", "")
  190. dept_id = _user.get("dept_id", "") or _user.get("create_dept_id", "") or ""
  191. detail = create_contract(
  192. db,
  193. tenant_no=tenant_no,
  194. data=body.model_dump(by_alias=True),
  195. user_id=user_id,
  196. dept_id=dept_id,
  197. )
  198. return success_response(detail["id"], message="新增成功")
  199. except ValueError as e:
  200. return error_response(400, str(e))
  201. except Exception as e:
  202. return error_response(500, str(e))
  203. @router.put("/contract")
  204. @oper_log(title="CRM合同管理", business_type=2, summary="修改合同【{contractName}】")
  205. async def contract_edit(
  206. body: ContractUpdateBody,
  207. _user: dict = Depends(require_admin_or_super_admin),
  208. db: Session = Depends(get_db),
  209. ):
  210. try:
  211. tenant_no = get_tenant_no(db, _user)
  212. user_info = crm_user_info(_user)
  213. user_id = _user.get("user_id", "") or _user.get("id", "")
  214. dept_id = _user.get("dept_id", "") or _user.get("create_dept_id", "") or ""
  215. data = body.model_dump(by_alias=True)
  216. contract_id = data.pop("id")
  217. detail = update_contract(
  218. db,
  219. contract_id,
  220. tenant_no=tenant_no,
  221. data=data,
  222. user_id=user_id,
  223. dept_id=dept_id,
  224. user_info=user_info,
  225. )
  226. return success_response(detail, message="修改成功")
  227. except ValueError as e:
  228. return error_response(400, str(e))
  229. except Exception as e:
  230. return error_response(500, str(e))
  231. @router.delete("/contract/{ids}")
  232. @oper_log(title="CRM合同管理", business_type=3, path_param="ids", summary="删除合同")
  233. async def contract_remove(
  234. ids: str,
  235. _user: dict = Depends(require_admin_or_super_admin),
  236. db: Session = Depends(get_db),
  237. ):
  238. try:
  239. tenant_no = get_tenant_no(db, _user)
  240. user_info = crm_user_info(_user)
  241. id_list = [x.strip() for x in ids.split(",") if x.strip()]
  242. soft_delete_contracts(db, id_list, tenant_no=tenant_no, user_info=user_info)
  243. return success_response(None, message="删除成功")
  244. except ValueError as e:
  245. return error_response(400, str(e))
  246. except Exception as e:
  247. return error_response(500, str(e))
  248. @router.put("/contract/submitApproval")
  249. async def contract_submit_approval(
  250. body: ContractSubmitBody,
  251. _user: dict = Depends(require_admin_or_super_admin),
  252. db: Session = Depends(get_db),
  253. ):
  254. try:
  255. tenant_no = get_tenant_no(db, _user)
  256. user_info = crm_user_info(_user)
  257. user_id = _user.get("user_id", "") or _user.get("id", "")
  258. dept_id = _user.get("dept_id", "") or _user.get("create_dept_id", "") or ""
  259. submit_contract_approval(
  260. db,
  261. body.id,
  262. tenant_no=tenant_no,
  263. approver_ids=body.approverIds,
  264. remark=body.remark,
  265. user_id=user_id,
  266. dept_id=dept_id,
  267. user_info=user_info,
  268. )
  269. return success_response(None, message="提交成功")
  270. except ValueError as e:
  271. return error_response(400, str(e))
  272. except Exception as e:
  273. return error_response(500, str(e))
  274. @router.put("/contract/batchSubmitApproval")
  275. async def contract_batch_submit_approval(
  276. body: ContractBatchSubmitBody,
  277. _user: dict = Depends(require_admin_or_super_admin),
  278. db: Session = Depends(get_db),
  279. ):
  280. try:
  281. tenant_no = get_tenant_no(db, _user)
  282. user_info = crm_user_info(_user)
  283. user_id = _user.get("user_id", "") or _user.get("id", "")
  284. dept_id = _user.get("dept_id", "") or _user.get("create_dept_id", "") or ""
  285. count = batch_submit_contract_approval(
  286. db,
  287. body.ids,
  288. tenant_no=tenant_no,
  289. approver_ids=body.approverIds,
  290. remark=body.remark,
  291. user_id=user_id,
  292. dept_id=dept_id,
  293. user_info=user_info,
  294. )
  295. return success_response(count, message="批量提交完成")
  296. except ValueError as e:
  297. return error_response(400, str(e))
  298. except Exception as e:
  299. return error_response(500, str(e))
  300. @router.put("/contract/withdrawApproval")
  301. async def contract_withdraw_approval(
  302. body: ContractWithdrawBody,
  303. _user: dict = Depends(require_admin_or_super_admin),
  304. db: Session = Depends(get_db),
  305. ):
  306. try:
  307. tenant_no = get_tenant_no(db, _user)
  308. user_info = crm_user_info(_user)
  309. user_id = _user.get("user_id", "") or _user.get("id", "")
  310. withdraw_contract_approval(
  311. db,
  312. body.id,
  313. tenant_no=tenant_no,
  314. remark=body.remark,
  315. user_id=user_id,
  316. user_info=user_info,
  317. )
  318. return success_response(None, message="撤回成功")
  319. except ValueError as e:
  320. return error_response(400, str(e))
  321. except Exception as e:
  322. return error_response(500, str(e))
  323. @router.put("/contract/startExecute")
  324. async def contract_start_execute(
  325. body: ContractStatusBody,
  326. _user: dict = Depends(require_admin_or_super_admin),
  327. db: Session = Depends(get_db),
  328. ):
  329. try:
  330. tenant_no = get_tenant_no(db, _user)
  331. user_info = crm_user_info(_user)
  332. user_id = _user.get("user_id", "") or _user.get("id", "")
  333. start_execute(db, body.id, tenant_no=tenant_no, remark=body.remark, user_id=user_id)
  334. return success_response(None, message="操作成功")
  335. except ValueError as e:
  336. return error_response(400, str(e))
  337. except Exception as e:
  338. return error_response(500, str(e))
  339. @router.put("/contract/finish")
  340. async def contract_finish(
  341. body: ContractStatusBody,
  342. _user: dict = Depends(require_admin_or_super_admin),
  343. db: Session = Depends(get_db),
  344. ):
  345. try:
  346. tenant_no = get_tenant_no(db, _user)
  347. user_info = crm_user_info(_user)
  348. user_id = _user.get("user_id", "") or _user.get("id", "")
  349. finish_contract(db, body.id, tenant_no=tenant_no, remark=body.remark, user_id=user_id)
  350. return success_response(None, message="操作成功")
  351. except ValueError as e:
  352. return error_response(400, str(e))
  353. except Exception as e:
  354. return error_response(500, str(e))
  355. @router.put("/contract/invalid")
  356. @oper_log(title="CRM合同管理", business_type=2, summary="作废合同")
  357. async def contract_invalid(
  358. body: ContractInvalidBody,
  359. _user: dict = Depends(require_admin_or_super_admin),
  360. db: Session = Depends(get_db),
  361. ):
  362. try:
  363. tenant_no = get_tenant_no(db, _user)
  364. user_info = crm_user_info(_user)
  365. user_id = _user.get("user_id", "") or _user.get("id", "")
  366. invalid_contract(
  367. db,
  368. body.id,
  369. tenant_no=tenant_no,
  370. invalid_reason=body.invalidReason,
  371. remark=body.remark,
  372. user_id=user_id,
  373. user_info=user_info,
  374. )
  375. return success_response(None, message="作废成功")
  376. except ValueError as e:
  377. return error_response(400, str(e))
  378. except Exception as e:
  379. return error_response(500, str(e))
  380. @router.post("/contract/saveTemplate")
  381. async def contract_save_template(
  382. body: ContractTemplateSaveBody,
  383. _user: dict = Depends(require_admin_or_super_admin),
  384. db: Session = Depends(get_db),
  385. ):
  386. try:
  387. tenant_no = get_tenant_no(db, _user)
  388. user_info = crm_user_info(_user)
  389. save_template(
  390. db,
  391. body.id,
  392. body.templateContent,
  393. tenant_no=tenant_no,
  394. settlement_clause_drafts=body.settlementClauseDrafts,
  395. user_info=user_info,
  396. )
  397. return success_response(None, message="保存成功")
  398. except ValueError as e:
  399. return error_response(400, str(e))
  400. except Exception as e:
  401. return error_response(500, str(e))
  402. @router.get("/contract/getTemplate/{contract_id}")
  403. async def contract_get_template(
  404. contract_id: str,
  405. _user: dict = Depends(require_admin_or_super_admin),
  406. db: Session = Depends(get_db),
  407. ):
  408. try:
  409. tenant_no = get_tenant_no(db, _user)
  410. user_info = crm_user_info(_user)
  411. content = get_template(db, contract_id, tenant_no=tenant_no, user_info=user_info)
  412. return success_response(content or "", message="获取模板成功")
  413. except ValueError as e:
  414. return error_response(400, str(e))
  415. except Exception as e:
  416. return error_response(500, str(e))
  417. @router.post("/contract/uploadFile")
  418. async def contract_upload_file(
  419. body: ContractUploadFileBody,
  420. _user: dict = Depends(require_admin_or_super_admin),
  421. db: Session = Depends(get_db),
  422. ):
  423. try:
  424. tenant_no = get_tenant_no(db, _user)
  425. user_info = crm_user_info(_user)
  426. upload_file(db, body.id, body.fileUrl, tenant_no=tenant_no)
  427. return success_response(None, message="上传成功")
  428. except ValueError as e:
  429. return error_response(400, str(e))
  430. except Exception as e:
  431. return error_response(500, str(e))
  432. @router.post("/contract/uploadAttachments")
  433. async def contract_upload_attachments(
  434. body: ContractUploadAttachmentsBody,
  435. _user: dict = Depends(require_admin_or_super_admin),
  436. db: Session = Depends(get_db),
  437. ):
  438. try:
  439. tenant_no = get_tenant_no(db, _user)
  440. user_info = crm_user_info(_user)
  441. # attachments 显式传入(含 [])表示整表覆盖保存,允许清空扫描件
  442. if body.attachments is not None:
  443. upload_attachments_with_category(
  444. db, body.id, body.attachments, tenant_no=tenant_no,
  445. user_info=user_info,
  446. )
  447. elif body.ossIds:
  448. upload_attachments(db, body.id, body.ossIds, tenant_no=tenant_no)
  449. else:
  450. return error_response(400, "附件参数不能为空")
  451. return success_response(None, message="上传成功")
  452. except ValueError as e:
  453. return error_response(400, str(e))
  454. except Exception as e:
  455. return error_response(500, str(e))
  456. @router.post("/contract/export")
  457. @oper_log(title="CRM合同管理", business_type=5, summary="导出合同列表")
  458. async def contract_export(
  459. body: ContractExportBody = None,
  460. _user: dict = Depends(require_admin_or_super_admin),
  461. db: Session = Depends(get_db),
  462. ):
  463. try:
  464. tenant_no = get_tenant_no(db, _user)
  465. user_info = crm_user_info(_user)
  466. list_body = body or ContractExportBody()
  467. filters = list_body.model_dump(
  468. by_alias=True,
  469. exclude={"pageNum", "pageSize"},
  470. exclude_none=True,
  471. )
  472. rows = export_contracts(db, tenant_no, filters=filters)
  473. rows = _filter_export_rows_by_ids(rows, getattr(list_body, "ids", None))
  474. export_cols = filter_export_columns(CONTRACT_EXPORT_COLUMNS, getattr(list_body, "columns", None))
  475. return export_rows_to_xlsx_response(
  476. db,
  477. tenant_no=tenant_no,
  478. sheet_title="合同",
  479. columns=export_cols,
  480. rows=rows,
  481. filename_stem=f"合同_{datetime.now().strftime('%Y%m%d%H%M%S')}",
  482. include_legacy_filename=False,
  483. )
  484. except ExportValidationError as e:
  485. return error_response(400, str(e))
  486. except ValueError as e:
  487. return error_response(400, str(e))
  488. except Exception as e:
  489. return error_response(500, str(e))
  490. @router.get("/contract/statistics/overview")
  491. async def contract_statistics_overview(
  492. ownerUserId: Optional[str] = None,
  493. beginTime: Optional[str] = None,
  494. endTime: Optional[str] = None,
  495. _user: dict = Depends(require_admin_or_super_admin),
  496. db: Session = Depends(get_db),
  497. ):
  498. try:
  499. tenant_no = get_tenant_no(db, _user)
  500. user_info = crm_user_info(_user)
  501. req = ContractStatisticsOverviewQuery(
  502. ownerUserId=ownerUserId,
  503. beginTime=beginTime,
  504. endTime=endTime,
  505. )
  506. data = statistics_overview(
  507. db,
  508. tenant_no,
  509. owner_user_id=req.ownerUserId,
  510. begin_time=req.beginTime,
  511. end_time=req.endTime,
  512. user_info=user_info,
  513. )
  514. return success_response(data)
  515. except ValueError as e:
  516. return error_response(400, str(e))
  517. except Exception as e:
  518. return error_response(500, str(e))
  519. @router.get("/contract/statistics/status")
  520. async def contract_statistics_status(
  521. _user: dict = Depends(require_admin_or_super_admin),
  522. db: Session = Depends(get_db),
  523. ):
  524. try:
  525. tenant_no = get_tenant_no(db, _user)
  526. user_info = crm_user_info(_user)
  527. return success_response(statistics_by_status(db, tenant_no))
  528. except ValueError as e:
  529. return error_response(400, str(e))
  530. except Exception as e:
  531. return error_response(500, str(e))
  532. @router.get("/contract/statistics/type")
  533. async def contract_statistics_type(
  534. _user: dict = Depends(require_admin_or_super_admin),
  535. db: Session = Depends(get_db),
  536. ):
  537. try:
  538. tenant_no = get_tenant_no(db, _user)
  539. user_info = crm_user_info(_user)
  540. return success_response(statistics_by_type(db, tenant_no))
  541. except ValueError as e:
  542. return error_response(400, str(e))
  543. except Exception as e:
  544. return error_response(500, str(e))
  545. @router.get("/contract/statistics/trend")
  546. async def contract_statistics_trend(
  547. type: str = Query("month"),
  548. beginTime: Optional[str] = None,
  549. endTime: Optional[str] = None,
  550. _user: dict = Depends(require_admin_or_super_admin),
  551. db: Session = Depends(get_db),
  552. ):
  553. try:
  554. tenant_no = get_tenant_no(db, _user)
  555. user_info = crm_user_info(_user)
  556. req = ContractStatisticsTrendQuery(type=type, beginTime=beginTime, endTime=endTime)
  557. data = statistics_trend(
  558. db,
  559. tenant_no,
  560. period_type=req.type or "month",
  561. begin_time=req.beginTime,
  562. end_time=req.endTime,
  563. user_info=user_info,
  564. )
  565. return success_response(data)
  566. except ValueError as e:
  567. return error_response(400, str(e))
  568. except Exception as e:
  569. return error_response(500, str(e))
  570. @router.get("/contract/statistics/expiring")
  571. async def contract_statistics_expiring(
  572. days: int = Query(30, ge=1),
  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. user_info = crm_user_info(_user)
  579. rows = query_expiring(db, tenant_no, days=days)
  580. return success_response(rows)
  581. except ValueError as e:
  582. return error_response(400, str(e))
  583. except Exception as e:
  584. return error_response(500, str(e))
  585. @router.post("/contract/renew/{parent_id}")
  586. async def contract_renew(
  587. parent_id: str,
  588. body: ContractRenewBody,
  589. _user: dict = Depends(require_admin_or_super_admin),
  590. db: Session = Depends(get_db),
  591. ):
  592. try:
  593. tenant_no = get_tenant_no(db, _user)
  594. user_info = crm_user_info(_user)
  595. user_id = _user.get("user_id", "") or _user.get("id", "")
  596. dept_id = _user.get("dept_id", "") or _user.get("create_dept_id", "") or ""
  597. new_id = renew_contract(
  598. db,
  599. parent_id,
  600. tenant_no=tenant_no,
  601. data=body.model_dump(by_alias=True),
  602. user_id=user_id,
  603. dept_id=dept_id,
  604. )
  605. return success_response(new_id, message="续签成功")
  606. except ValueError as e:
  607. return error_response(400, str(e))
  608. except Exception as e:
  609. return error_response(500, str(e))
  610. @router.post("/contract/createFromQuote/{quote_id}")
  611. async def contract_create_from_quote(
  612. quote_id: str,
  613. body: ContractCreateBody,
  614. _user: dict = Depends(require_admin_or_super_admin),
  615. db: Session = Depends(get_db),
  616. ):
  617. try:
  618. tenant_no = get_tenant_no(db, _user)
  619. user_info = crm_user_info(_user)
  620. user_id = _user.get("user_id", "") or _user.get("id", "")
  621. dept_id = _user.get("dept_id", "") or _user.get("create_dept_id", "") or ""
  622. contract_id = create_from_quote(
  623. db,
  624. quote_id,
  625. tenant_no=tenant_no,
  626. data=body.model_dump(by_alias=True),
  627. user_id=user_id,
  628. dept_id=dept_id,
  629. )
  630. return success_response(contract_id, message="创建成功")
  631. except ValueError as e:
  632. return error_response(400, str(e))
  633. except Exception as e:
  634. return error_response(500, str(e))
  635. @router.post("/contract/createFromOpportunity/{opportunity_id}")
  636. async def contract_create_from_opportunity(
  637. opportunity_id: str,
  638. body: ContractCreateBody,
  639. _user: dict = Depends(require_admin_or_super_admin),
  640. db: Session = Depends(get_db),
  641. ):
  642. try:
  643. tenant_no = get_tenant_no(db, _user)
  644. user_info = crm_user_info(_user)
  645. user_id = _user.get("user_id", "") or _user.get("id", "")
  646. dept_id = _user.get("dept_id", "") or _user.get("create_dept_id", "") or ""
  647. contract_id = create_from_opportunity(
  648. db,
  649. opportunity_id,
  650. tenant_no=tenant_no,
  651. data=body.model_dump(by_alias=True),
  652. user_id=user_id,
  653. dept_id=dept_id,
  654. )
  655. return success_response(contract_id, message="创建成功")
  656. except ValueError as e:
  657. return error_response(400, str(e))
  658. except Exception as e:
  659. return error_response(500, str(e))
  660. @router.put("/contract/sign")
  661. async def contract_sign(
  662. body: ContractSignBody,
  663. _user: dict = Depends(require_admin_or_super_admin),
  664. db: Session = Depends(get_db),
  665. ):
  666. try:
  667. tenant_no = get_tenant_no(db, _user)
  668. user_info = crm_user_info(_user)
  669. user_id = _user.get("user_id", "") or _user.get("id", "")
  670. sign_contract(
  671. db,
  672. body.id,
  673. tenant_no=tenant_no,
  674. actual_sign_date=body.actualSignDate,
  675. contract_file=body.contractFile,
  676. remark=body.remark or "",
  677. user_id=user_id,
  678. user_info=user_info,
  679. )
  680. return success_response(None, message="签订成功")
  681. except ValueError as e:
  682. return error_response(400, str(e))
  683. except Exception as e:
  684. return error_response(500, str(e))
  685. @router.put("/contract/batch/assign")
  686. async def contract_batch_assign(
  687. body: ContractBatchAssignBody,
  688. _user: dict = Depends(require_admin_or_super_admin),
  689. db: Session = Depends(get_db),
  690. ):
  691. try:
  692. tenant_no = get_tenant_no(db, _user)
  693. user_info = crm_user_info(_user)
  694. user_id = _user.get("user_id", "") or _user.get("id", "")
  695. count = batch_assign_owner(
  696. db,
  697. body.ids,
  698. tenant_no=tenant_no,
  699. owner_user_id=body.ownerUserId,
  700. remark=body.remark or "",
  701. user_id=user_id,
  702. user_info=user_info,
  703. )
  704. return success_response(count, message="分配成功")
  705. except ValueError as e:
  706. return error_response(400, str(e))
  707. except Exception as e:
  708. return error_response(500, str(e))
  709. @router.get("/contract/download/{contract_id}")
  710. async def contract_download(
  711. contract_id: str,
  712. _user: dict = Depends(require_admin_or_super_admin),
  713. db: Session = Depends(get_db),
  714. ):
  715. try:
  716. tenant_no = get_tenant_no(db, _user)
  717. user_info = crm_user_info(_user)
  718. file_path = download_contract_pdf(db, contract_id, tenant_no=tenant_no)
  719. return success_response(file_path)
  720. except ValueError as e:
  721. return error_response(400, str(e))
  722. except Exception as e:
  723. return error_response(500, str(e))
  724. @router.post("/contract/approval")
  725. async def contract_approval_by_contract_id(
  726. body: ContractApprovalActionBody,
  727. _user: dict = Depends(require_admin_or_super_admin),
  728. db: Session = Depends(get_db),
  729. ):
  730. try:
  731. tenant_no = get_tenant_no(db, _user)
  732. user_id = _user.get("user_id", "") or _user.get("id", "")
  733. approve_contract_by_contract_id(
  734. db,
  735. body.id,
  736. approval_result=body.approvalResult,
  737. approval_opinion=body.approvalOpinion or "",
  738. attachments=body.attachments or "",
  739. remark=body.remark or "",
  740. user_id=user_id,
  741. )
  742. db.commit()
  743. return success_response(None, message="审批成功")
  744. except ValueError as e:
  745. return error_response(400, str(e))
  746. except Exception as e:
  747. return error_response(500, str(e))
  748. @router.get("/contract/approval/flow/{contract_id}")
  749. async def contract_approval_flow(
  750. contract_id: str,
  751. _user: dict = Depends(require_admin_or_super_admin),
  752. db: Session = Depends(get_db),
  753. ):
  754. try:
  755. tenant_no = get_tenant_no(db, _user)
  756. user_info = crm_user_info(_user)
  757. rows = list_contract_approvals(db, contract_id, tenant_no=tenant_no)
  758. return success_response(rows)
  759. except ValueError as e:
  760. return error_response(400, str(e))
  761. except Exception as e:
  762. return error_response(500, str(e))
  763. @router.post("/contract-approver-setting/get")
  764. async def contract_approver_setting_get(
  765. _user: dict = Depends(require_admin_or_super_admin),
  766. db: Session = Depends(get_db),
  767. ):
  768. try:
  769. tenant_no = get_tenant_no(db, _user)
  770. data = get_contract_approver_setting(db, tenant_no=tenant_no)
  771. return success_response(data or {"approverIds": [], "status": "0"})
  772. except Exception as e:
  773. return error_response(500, str(e))
  774. @router.post("/contract-approver-setting/save")
  775. async def contract_approver_setting_save(
  776. body: ContractApproverSettingSaveBody,
  777. _user: dict = Depends(require_menu_code("system:approverSetting")),
  778. db: Session = Depends(get_db),
  779. ):
  780. try:
  781. tenant_no = get_tenant_no(db, _user)
  782. user_id = _user.get("user_id", "") or _user.get("id", "")
  783. dept_id = _user.get("dept_id", "") or _user.get("create_dept_id", "") or ""
  784. data = save_contract_approver_setting(
  785. db,
  786. tenant_no=tenant_no,
  787. approver_ids=body.approverIds or [],
  788. status=body.status or "0",
  789. user_id=user_id,
  790. dept_id=dept_id,
  791. )
  792. return success_response(data, message="保存成功")
  793. except ValueError as e:
  794. return error_response(400, str(e))
  795. except Exception as e:
  796. return error_response(500, str(e))
  797. @router.get("/contract/{contract_id}")
  798. async def contract_detail(
  799. contract_id: str,
  800. _user: dict = Depends(require_admin_or_super_admin),
  801. db: Session = Depends(get_db),
  802. ):
  803. try:
  804. tenant_no = get_tenant_no(db, _user)
  805. user_info = crm_user_info(_user)
  806. user_id = _user.get("user_id", "") or _user.get("id", "")
  807. detail = get_contract_detail(
  808. db,
  809. contract_id,
  810. tenant_no=tenant_no,
  811. current_user_id=user_id,
  812. user_info=user_info,
  813. )
  814. return success_response(detail)
  815. except ValueError as e:
  816. return error_response(400, str(e))
  817. except Exception as e:
  818. return error_response(500, str(e))