crm_quote_routes.py 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866
  1. """CRM 报价单 API 路由 — 挂接到 crm.router"""
  2. from __future__ import annotations
  3. from datetime import datetime
  4. from fastapi import Depends
  5. from sqlalchemy.orm import Session
  6. from app.core.database import get_db
  7. from app.core.menu_guard import require_admin_or_super_admin, require_menu_code
  8. from app.core.response import error_response, success_response
  9. from app.core.tenant_context import get_tenant_no
  10. from app.crud.crm.contact import list_contacts_by_customer
  11. from app.crud.crm.customer import get_customer
  12. from app.crud.crm.data_scope_helpers import crm_user_info, ensure_crm_owner_row_in_scope
  13. from app.crud.crm.quote import (
  14. accept_quote,
  15. create_new_version,
  16. create_quote,
  17. generate_pdf,
  18. generate_share,
  19. get_quote_detail,
  20. get_template,
  21. invalid_quote,
  22. list_quote_column_facet_values,
  23. list_quotes,
  24. query_versions,
  25. reject_quote,
  26. save_template,
  27. soft_delete_quotes,
  28. statistics_overview,
  29. statistics_status,
  30. statistics_trend,
  31. submit_quote,
  32. to_contract,
  33. total_pages as quote_total_pages,
  34. update_quote,
  35. )
  36. from app.crud.crm.quote_approver_setting import get_setting, save_setting
  37. from app.crud.crm.quote_approval import (
  38. approve_quote,
  39. list_quote_approvals,
  40. refresh_approver_names,
  41. withdraw_approval,
  42. )
  43. from app.crud.crm.quote_product import (
  44. insert_quote_product,
  45. list_quote_products,
  46. soft_delete_quote_products,
  47. update_quote_product,
  48. )
  49. from app.crud.crm.quote_share_log import list_share_logs, share_log_statistics
  50. from app.schemas.crm.quote_approver_setting import QuoteApproverSettingSaveBody
  51. from app.schemas.crm.quote import (
  52. QuoteAcceptBody,
  53. QuoteApprovalApproveBody,
  54. QuoteApprovalListBody,
  55. QuoteApprovalRefreshNamesBody,
  56. QuoteApprovalWithdrawBody,
  57. QuoteColumnFacetBody,
  58. QuoteCreateBody,
  59. QuoteDeleteBody,
  60. QuoteDetailBody,
  61. QuoteInvalidBody,
  62. QuoteListBody,
  63. QuoteNewVersionBody,
  64. QuotePdfBody,
  65. QuoteProductCreateBody,
  66. QuoteProductDeleteBody,
  67. QuoteProductListBody,
  68. QuoteProductUpdateBody,
  69. QuoteRejectBody,
  70. QuoteShareGenerateBody,
  71. QuoteShareLogListBody,
  72. QuoteShareLogStatisticsBody,
  73. QuoteStatisticsOverviewBody,
  74. QuoteStatisticsTrendBody,
  75. QuoteSubmitBody,
  76. QuoteTemplateGetBody,
  77. QuoteTemplateSaveBody,
  78. QuoteToContractBody,
  79. QuoteUpdateBody,
  80. QuoteVersionsBody,
  81. )
  82. from app.utils.crm_export_columns import QUOTE_EXPORT_COLUMNS
  83. from app.utils.excel_export import (
  84. EXPORT_MAX_ROWS,
  85. ExportValidationError,
  86. export_rows_to_xlsx_response,
  87. filter_export_columns,
  88. )
  89. from app.api.crm import _filter_export_rows_by_ids
  90. def _mobile_quote_contact_snapshot(db, body, *, tenant_no, user_info):
  91. """移动保存先校验归属和权限,再将可信联系人快照交给原更新事务。"""
  92. current = get_quote_detail(db, body.id, tenant_no=tenant_no, user_info=user_info)
  93. customer_id = body.customerId
  94. customer = get_customer(db, customer_id)
  95. if not customer or customer.tenant_no != tenant_no:
  96. raise ValueError("客户不存在")
  97. ensure_crm_owner_row_in_scope(
  98. db, customer, user_info, tenant_no, message="无权访问该客户"
  99. )
  100. if "contactId" in body.model_fields_set:
  101. contact_id = (body.contactId or "").strip()
  102. elif customer_id == str(current.get("customerId") or ""):
  103. contact_id = str(current.get("contactId") or "").strip()
  104. else:
  105. # 更换客户却未选联系人时,不能继续携带上一个客户的联系人。
  106. contact_id = ""
  107. if not contact_id:
  108. return {"id": "", "contactName": "", "mobile": "", "email": ""}
  109. # 客户权限已在清空分支前统一校验,此处只查询该租户、客户的有效联系人。
  110. contacts = list_contacts_by_customer(db, tenant_no, customer_id)
  111. contact = next((row for row in contacts if str(row["id"]) == contact_id), None)
  112. if not contact:
  113. raise ValueError("所选联系人不存在或不属于当前客户")
  114. return {
  115. "id": contact_id,
  116. "contactName": contact.get("contactName") or "",
  117. "mobile": contact.get("mobile") or "",
  118. "email": contact.get("email") or "",
  119. }
  120. def register_quote_routes(router):
  121. @router.post("/quote/list")
  122. async def quote_list(
  123. body: QuoteListBody = None,
  124. _user: dict = Depends(require_admin_or_super_admin),
  125. db: Session = Depends(get_db),
  126. ):
  127. try:
  128. tenant_no = get_tenant_no(db, _user)
  129. user_info = crm_user_info(_user)
  130. list_body = body or QuoteListBody()
  131. user_id = _user.get("user_id", "") or _user.get("id", "")
  132. rows, total = list_quotes(
  133. db,
  134. tenant_no,
  135. user_info=user_info,
  136. page=list_body.page,
  137. page_size=list_body.pageSize,
  138. filters=list_body.model_dump(by_alias=True, exclude={"page", "pageSize"}),
  139. current_user_id=user_id,
  140. )
  141. tp = quote_total_pages(total, list_body.pageSize)
  142. return success_response(
  143. {
  144. "list": rows,
  145. "rows": rows,
  146. "total": total,
  147. "page": list_body.page,
  148. "pageSize": list_body.pageSize,
  149. "totalPages": tp,
  150. }
  151. )
  152. except ValueError as e:
  153. return error_response(400, str(e))
  154. except Exception as e:
  155. return error_response(500, str(e))
  156. @router.post("/quote/column-facet-values")
  157. async def quote_column_facet_values(
  158. body: QuoteColumnFacetBody,
  159. _user: dict = Depends(require_admin_or_super_admin),
  160. db: Session = Depends(get_db),
  161. ):
  162. """报价列表列头可选值(单号/客户去重;Excel 级联上下文)"""
  163. try:
  164. from app.services.crm.facet_context import facet_filter_kwargs_from_body
  165. tenant_no = get_tenant_no(db, _user)
  166. user_info = crm_user_info(_user)
  167. filter_kwargs = facet_filter_kwargs_from_body(body, body.field)
  168. rows = list_quote_column_facet_values(
  169. db,
  170. tenant_no,
  171. field=body.field,
  172. keyword=body.keyword,
  173. limit=body.limit if body.limit is not None else 500,
  174. user_info=user_info,
  175. filter_kwargs=filter_kwargs,
  176. )
  177. return success_response({"list": rows})
  178. except ValueError as e:
  179. return error_response(400, str(e))
  180. except Exception as e:
  181. return error_response(500, str(e))
  182. @router.post("/quote/detail")
  183. async def quote_detail(
  184. body: QuoteDetailBody,
  185. _user: dict = Depends(require_admin_or_super_admin),
  186. db: Session = Depends(get_db),
  187. ):
  188. try:
  189. tenant_no = get_tenant_no(db, _user)
  190. user_info = crm_user_info(_user)
  191. detail = get_quote_detail(db, body.id, tenant_no=tenant_no, user_info=user_info)
  192. return success_response(detail)
  193. except ValueError as e:
  194. return error_response(400, str(e))
  195. except Exception as e:
  196. return error_response(500, str(e))
  197. @router.post("/quote/add")
  198. async def quote_add(
  199. body: QuoteCreateBody,
  200. _user: dict = Depends(require_admin_or_super_admin),
  201. db: Session = Depends(get_db),
  202. ):
  203. try:
  204. tenant_no = get_tenant_no(db, _user)
  205. user_info = crm_user_info(_user)
  206. user_id = _user.get("user_id", "") or _user.get("id", "")
  207. dept_id = _user.get("dept_id", "") or _user.get("create_dept_id", "") or ""
  208. detail = create_quote(
  209. db,
  210. tenant_no=tenant_no,
  211. data=body.model_dump(by_alias=True),
  212. user_id=user_id,
  213. dept_id=dept_id,
  214. )
  215. return success_response(detail, message="新增成功")
  216. except ValueError as e:
  217. return error_response(400, str(e))
  218. except Exception as e:
  219. return error_response(500, str(e))
  220. @router.post("/quote/update")
  221. async def quote_update(
  222. body: QuoteUpdateBody,
  223. _user: dict = Depends(require_admin_or_super_admin),
  224. db: Session = Depends(get_db),
  225. ):
  226. try:
  227. tenant_no = get_tenant_no(db, _user)
  228. user_info = crm_user_info(_user)
  229. user_id = _user.get("user_id", "") or _user.get("id", "")
  230. dept_id = _user.get("dept_id", "") or _user.get("create_dept_id", "") or ""
  231. data = body.model_dump(by_alias=True)
  232. quote_id = data.pop("id")
  233. detail = update_quote(
  234. db,
  235. quote_id,
  236. tenant_no=tenant_no,
  237. data=data,
  238. user_id=user_id,
  239. dept_id=dept_id,
  240. user_info=user_info,
  241. )
  242. return success_response(detail, message="修改成功")
  243. except ValueError as e:
  244. return error_response(400, str(e))
  245. except Exception as e:
  246. return error_response(500, str(e))
  247. @router.post("/quote/mobile-update")
  248. async def quote_mobile_update(
  249. body: QuoteUpdateBody,
  250. _user: dict = Depends(require_admin_or_super_admin),
  251. db: Session = Depends(get_db),
  252. ):
  253. try:
  254. tenant_no = get_tenant_no(db, _user)
  255. user_info = crm_user_info(_user)
  256. snapshot = _mobile_quote_contact_snapshot(
  257. db, body, tenant_no=tenant_no, user_info=user_info
  258. )
  259. data = body.model_dump(by_alias=True)
  260. quote_id = data.pop("id")
  261. data["contactId"] = snapshot["id"]
  262. detail = update_quote(
  263. db,
  264. quote_id,
  265. tenant_no=tenant_no,
  266. data=data,
  267. user_id=_user.get("user_id", "") or _user.get("id", ""),
  268. dept_id=_user.get("dept_id", "") or _user.get("create_dept_id", "") or "",
  269. user_info=user_info,
  270. canonical_contact_snapshot=snapshot,
  271. )
  272. return success_response(detail, message="修改成功")
  273. except ValueError as e:
  274. return error_response(400, str(e))
  275. except Exception as e:
  276. return error_response(500, str(e))
  277. @router.post("/quote/delete")
  278. async def quote_delete(
  279. body: QuoteDeleteBody,
  280. _user: dict = Depends(require_admin_or_super_admin),
  281. db: Session = Depends(get_db),
  282. ):
  283. try:
  284. tenant_no = get_tenant_no(db, _user)
  285. user_info = crm_user_info(_user)
  286. soft_delete_quotes(db, body.ids, tenant_no=tenant_no, user_info=user_info)
  287. return success_response(None, message="删除成功")
  288. except ValueError as e:
  289. return error_response(400, str(e))
  290. except Exception as e:
  291. return error_response(500, str(e))
  292. @router.post("/quote/submit")
  293. async def quote_submit(
  294. body: QuoteSubmitBody,
  295. _user: dict = Depends(require_admin_or_super_admin),
  296. db: Session = Depends(get_db),
  297. ):
  298. try:
  299. tenant_no = get_tenant_no(db, _user)
  300. user_info = crm_user_info(_user)
  301. submit_quote(
  302. db,
  303. body.id,
  304. tenant_no=tenant_no,
  305. approver_ids=body.approverIds,
  306. remark=body.remark,
  307. user_info=user_info,
  308. )
  309. return success_response(None, message="提交成功")
  310. except ValueError as e:
  311. return error_response(400, str(e))
  312. except Exception as e:
  313. return error_response(500, str(e))
  314. @router.post("/quote/saveTemplate")
  315. async def quote_save_template(
  316. body: QuoteTemplateSaveBody,
  317. _user: dict = Depends(require_admin_or_super_admin),
  318. db: Session = Depends(get_db),
  319. ):
  320. try:
  321. tenant_no = get_tenant_no(db, _user)
  322. user_info = crm_user_info(_user)
  323. save_template(db, body.id, body.templateContent, tenant_no=tenant_no)
  324. return success_response(None, message="保存成功")
  325. except ValueError as e:
  326. return error_response(400, str(e))
  327. except Exception as e:
  328. return error_response(500, str(e))
  329. @router.post("/quote/getTemplate")
  330. async def quote_get_template(
  331. body: QuoteTemplateGetBody,
  332. _user: dict = Depends(require_admin_or_super_admin),
  333. db: Session = Depends(get_db),
  334. ):
  335. try:
  336. tenant_no = get_tenant_no(db, _user)
  337. user_info = crm_user_info(_user)
  338. content = get_template(db, body.id, tenant_no=tenant_no, user_info=user_info)
  339. return success_response(content or "")
  340. except ValueError as e:
  341. return error_response(400, str(e))
  342. except Exception as e:
  343. return error_response(500, str(e))
  344. @router.post("/quote/generatePdf")
  345. async def quote_generate_pdf(
  346. body: QuotePdfBody,
  347. _user: dict = Depends(require_admin_or_super_admin),
  348. db: Session = Depends(get_db),
  349. ):
  350. try:
  351. tenant_no = get_tenant_no(db, _user)
  352. user_info = crm_user_info(_user)
  353. pdf_url = generate_pdf(db, body.id, tenant_no=tenant_no)
  354. return success_response(pdf_url)
  355. except ValueError as e:
  356. return error_response(400, str(e))
  357. except Exception as e:
  358. return error_response(500, str(e))
  359. @router.post("/quote/generateShare")
  360. async def quote_generate_share(
  361. body: QuoteShareGenerateBody,
  362. _user: dict = Depends(require_admin_or_super_admin),
  363. db: Session = Depends(get_db),
  364. ):
  365. try:
  366. tenant_no = get_tenant_no(db, _user)
  367. user_info = crm_user_info(_user)
  368. link = generate_share(
  369. db,
  370. body.id,
  371. tenant_no=tenant_no,
  372. validity_days=body.validityDays,
  373. password=body.password or "",
  374. user_info=user_info,
  375. )
  376. return success_response(link)
  377. except ValueError as e:
  378. return error_response(400, str(e))
  379. except Exception as e:
  380. return error_response(500, str(e))
  381. @router.post("/quote/accept")
  382. async def quote_accept(
  383. body: QuoteAcceptBody,
  384. _user: dict = Depends(require_admin_or_super_admin),
  385. db: Session = Depends(get_db),
  386. ):
  387. try:
  388. tenant_no = get_tenant_no(db, _user)
  389. user_info = crm_user_info(_user)
  390. accept_quote(db, body.id, tenant_no=tenant_no, remark=body.remark)
  391. return success_response(None, message="操作成功")
  392. except ValueError as e:
  393. return error_response(400, str(e))
  394. except Exception as e:
  395. return error_response(500, str(e))
  396. @router.post("/quote/reject")
  397. async def quote_reject(
  398. body: QuoteRejectBody,
  399. _user: dict = Depends(require_admin_or_super_admin),
  400. db: Session = Depends(get_db),
  401. ):
  402. try:
  403. tenant_no = get_tenant_no(db, _user)
  404. user_info = crm_user_info(_user)
  405. reject_quote(
  406. db,
  407. body.id,
  408. tenant_no=tenant_no,
  409. reject_reason=body.rejectReason,
  410. remark=body.remark,
  411. user_info=user_info,
  412. )
  413. return success_response(None, message="操作成功")
  414. except ValueError as e:
  415. return error_response(400, str(e))
  416. except Exception as e:
  417. return error_response(500, str(e))
  418. @router.post("/quote/toContract")
  419. async def quote_to_contract(
  420. body: QuoteToContractBody,
  421. _user: dict = Depends(require_admin_or_super_admin),
  422. db: Session = Depends(get_db),
  423. ):
  424. try:
  425. tenant_no = get_tenant_no(db, _user)
  426. user_info = crm_user_info(_user)
  427. user_id = _user.get("user_id", "") or _user.get("id", "")
  428. dept_id = _user.get("dept_id", "") or _user.get("create_dept_id", "") or ""
  429. contract_id = to_contract(
  430. db,
  431. body.id,
  432. tenant_no=tenant_no,
  433. contract_no=body.contractNo,
  434. contract_title=body.contractTitle,
  435. sign_date=body.signDate,
  436. start_date=body.startDate,
  437. end_date=body.endDate,
  438. user_id=user_id,
  439. dept_id=dept_id,
  440. user_info=user_info,
  441. )
  442. return success_response(contract_id)
  443. except ValueError as e:
  444. return error_response(400, str(e))
  445. except Exception as e:
  446. return error_response(500, str(e))
  447. @router.post("/quote/newVersion")
  448. async def quote_new_version(
  449. body: QuoteNewVersionBody,
  450. _user: dict = Depends(require_admin_or_super_admin),
  451. db: Session = Depends(get_db),
  452. ):
  453. try:
  454. tenant_no = get_tenant_no(db, _user)
  455. user_info = crm_user_info(_user)
  456. user_id = _user.get("user_id", "") or _user.get("id", "")
  457. dept_id = _user.get("dept_id", "") or _user.get("create_dept_id", "") or ""
  458. new_id = create_new_version(
  459. db,
  460. body.id,
  461. tenant_no=tenant_no,
  462. version=body.version,
  463. remark=body.remark,
  464. user_id=user_id,
  465. dept_id=dept_id,
  466. user_info=user_info,
  467. )
  468. return success_response(new_id)
  469. except ValueError as e:
  470. return error_response(400, str(e))
  471. except Exception as e:
  472. return error_response(500, str(e))
  473. @router.post("/quote/versions")
  474. async def quote_versions(
  475. body: QuoteVersionsBody,
  476. _user: dict = Depends(require_admin_or_super_admin),
  477. db: Session = Depends(get_db),
  478. ):
  479. try:
  480. tenant_no = get_tenant_no(db, _user)
  481. user_info = crm_user_info(_user)
  482. rows = query_versions(db, body.quoteNo, tenant_no=tenant_no)
  483. return success_response(rows)
  484. except ValueError as e:
  485. return error_response(400, str(e))
  486. except Exception as e:
  487. return error_response(500, str(e))
  488. @router.post("/quote/invalid")
  489. async def quote_invalid(
  490. body: QuoteInvalidBody,
  491. _user: dict = Depends(require_admin_or_super_admin),
  492. db: Session = Depends(get_db),
  493. ):
  494. try:
  495. tenant_no = get_tenant_no(db, _user)
  496. user_info = crm_user_info(_user)
  497. invalid_quote(
  498. db,
  499. body.id,
  500. tenant_no=tenant_no,
  501. invalid_reason=body.invalidReason or "",
  502. remark=body.remark or "",
  503. user_info=user_info,
  504. )
  505. return success_response(None, message="作废成功")
  506. except ValueError as e:
  507. return error_response(400, str(e))
  508. except Exception as e:
  509. return error_response(500, str(e))
  510. @router.post("/quote/export")
  511. async def quote_export(
  512. body: QuoteListBody = None,
  513. _user: dict = Depends(require_admin_or_super_admin),
  514. db: Session = Depends(get_db),
  515. ):
  516. try:
  517. tenant_no = get_tenant_no(db, _user)
  518. user_info = crm_user_info(_user)
  519. list_body = body or QuoteListBody()
  520. rows, _ = list_quotes(
  521. db,
  522. tenant_no,
  523. user_info=user_info,
  524. page=1,
  525. page_size=EXPORT_MAX_ROWS,
  526. filters=list_body.model_dump(by_alias=True, exclude={"page", "pageSize"}),
  527. )
  528. rows = _filter_export_rows_by_ids(rows, getattr(list_body, "ids", None))
  529. export_cols = filter_export_columns(QUOTE_EXPORT_COLUMNS, getattr(list_body, "columns", None))
  530. return export_rows_to_xlsx_response(
  531. db,
  532. tenant_no=tenant_no,
  533. sheet_title="报价单",
  534. columns=export_cols,
  535. rows=rows,
  536. filename_stem=f"报价单_{datetime.now().strftime('%Y%m%d%H%M%S')}",
  537. include_legacy_filename=False,
  538. )
  539. except ExportValidationError as e:
  540. return error_response(400, str(e))
  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.post("/quote/statistics/overview")
  546. async def quote_statistics_overview(
  547. body: QuoteStatisticsOverviewBody = None,
  548. _user: dict = Depends(require_admin_or_super_admin),
  549. db: Session = Depends(get_db),
  550. ):
  551. try:
  552. tenant_no = get_tenant_no(db, _user)
  553. user_info = crm_user_info(_user)
  554. req = body or QuoteStatisticsOverviewBody()
  555. data = statistics_overview(
  556. db,
  557. tenant_no,
  558. owner_user_id=req.ownerUserId,
  559. begin_time=req.beginTime,
  560. end_time=req.endTime,
  561. user_info=user_info,
  562. )
  563. return success_response(data)
  564. except ValueError as e:
  565. return error_response(400, str(e))
  566. except Exception as e:
  567. return error_response(500, str(e))
  568. @router.post("/quote/statistics/status")
  569. async def quote_statistics_status(
  570. _user: dict = Depends(require_admin_or_super_admin),
  571. db: Session = Depends(get_db),
  572. ):
  573. try:
  574. tenant_no = get_tenant_no(db, _user)
  575. user_info = crm_user_info(_user)
  576. return success_response(statistics_status(db, tenant_no))
  577. except ValueError as e:
  578. return error_response(400, str(e))
  579. except Exception as e:
  580. return error_response(500, str(e))
  581. @router.post("/quote/statistics/trend")
  582. async def quote_statistics_trend(
  583. body: QuoteStatisticsTrendBody = None,
  584. _user: dict = Depends(require_admin_or_super_admin),
  585. db: Session = Depends(get_db),
  586. ):
  587. try:
  588. tenant_no = get_tenant_no(db, _user)
  589. user_info = crm_user_info(_user)
  590. req = body or QuoteStatisticsTrendBody()
  591. data = statistics_trend(
  592. db,
  593. tenant_no,
  594. period_type=req.type or "month",
  595. begin_time=req.beginTime,
  596. end_time=req.endTime,
  597. user_info=user_info,
  598. )
  599. return success_response(data)
  600. except ValueError as e:
  601. return error_response(400, str(e))
  602. except Exception as e:
  603. return error_response(500, str(e))
  604. @router.post("/quote/product/list")
  605. async def quote_product_list(
  606. body: QuoteProductListBody,
  607. _user: dict = Depends(require_admin_or_super_admin),
  608. db: Session = Depends(get_db),
  609. ):
  610. try:
  611. tenant_no = get_tenant_no(db, _user)
  612. user_info = crm_user_info(_user)
  613. rows = list_quote_products(db, body.quoteId, tenant_no=tenant_no)
  614. return success_response(rows)
  615. except ValueError as e:
  616. return error_response(400, str(e))
  617. except Exception as e:
  618. return error_response(500, str(e))
  619. @router.post("/quote/product/add")
  620. async def quote_product_add(
  621. body: QuoteProductCreateBody,
  622. _user: dict = Depends(require_admin_or_super_admin),
  623. db: Session = Depends(get_db),
  624. ):
  625. try:
  626. tenant_no = get_tenant_no(db, _user)
  627. user_info = crm_user_info(_user)
  628. user_id = _user.get("user_id", "") or _user.get("id", "")
  629. dept_id = _user.get("dept_id", "") or _user.get("create_dept_id", "") or ""
  630. obj = insert_quote_product(
  631. db,
  632. tenant_no=tenant_no,
  633. data=body.model_dump(by_alias=True),
  634. user_id=user_id,
  635. dept_id=dept_id,
  636. )
  637. from app.crud.crm.quote_product import product_row_to_dict
  638. return success_response(product_row_to_dict(obj), message="新增成功")
  639. except ValueError as e:
  640. return error_response(400, str(e))
  641. except Exception as e:
  642. return error_response(500, str(e))
  643. @router.post("/quote/product/update")
  644. async def quote_product_update(
  645. body: QuoteProductUpdateBody,
  646. _user: dict = Depends(require_admin_or_super_admin),
  647. db: Session = Depends(get_db),
  648. ):
  649. try:
  650. tenant_no = get_tenant_no(db, _user)
  651. user_info = crm_user_info(_user)
  652. user_id = _user.get("user_id", "") or _user.get("id", "")
  653. data = body.model_dump(by_alias=True)
  654. line_id = data.pop("id")
  655. obj = update_quote_product(
  656. db,
  657. line_id,
  658. tenant_no=tenant_no,
  659. data=data,
  660. user_id=user_id,
  661. user_info=user_info,
  662. )
  663. from app.crud.crm.quote_product import product_row_to_dict
  664. return success_response(product_row_to_dict(obj), message="修改成功")
  665. except ValueError as e:
  666. return error_response(400, str(e))
  667. except Exception as e:
  668. return error_response(500, str(e))
  669. @router.post("/quote/product/delete")
  670. async def quote_product_delete(
  671. body: QuoteProductDeleteBody,
  672. _user: dict = Depends(require_admin_or_super_admin),
  673. db: Session = Depends(get_db),
  674. ):
  675. try:
  676. tenant_no = get_tenant_no(db, _user)
  677. user_info = crm_user_info(_user)
  678. soft_delete_quote_products(db, body.ids, tenant_no=tenant_no, user_info=user_info)
  679. return success_response(None, message="删除成功")
  680. except ValueError as e:
  681. return error_response(400, str(e))
  682. except Exception as e:
  683. return error_response(500, str(e))
  684. @router.post("/quote/approval/list")
  685. async def quote_approval_list(
  686. body: QuoteApprovalListBody,
  687. _user: dict = Depends(require_admin_or_super_admin),
  688. db: Session = Depends(get_db),
  689. ):
  690. try:
  691. tenant_no = get_tenant_no(db, _user)
  692. user_info = crm_user_info(_user)
  693. rows = list_quote_approvals(db, body.quoteId, tenant_no=tenant_no)
  694. return success_response(rows)
  695. except ValueError as e:
  696. return error_response(400, str(e))
  697. except Exception as e:
  698. return error_response(500, str(e))
  699. @router.post("/quote/approval/approve")
  700. async def quote_approval_approve(
  701. body: QuoteApprovalApproveBody,
  702. _user: dict = Depends(require_admin_or_super_admin),
  703. db: Session = Depends(get_db),
  704. ):
  705. try:
  706. tenant_no = get_tenant_no(db, _user)
  707. user_id = _user.get("user_id", "") or _user.get("id", "")
  708. approve_quote(
  709. db,
  710. body.id,
  711. tenant_no=tenant_no,
  712. approval_result=body.approvalResult,
  713. approval_opinion=body.approvalOpinion or "",
  714. remark=body.remark or "",
  715. user_id=user_id,
  716. )
  717. return success_response(None, message="审批成功")
  718. except ValueError as e:
  719. return error_response(400, str(e))
  720. except Exception as e:
  721. return error_response(500, str(e))
  722. @router.post("/quote/approval/withdraw")
  723. async def quote_approval_withdraw(
  724. body: QuoteApprovalWithdrawBody,
  725. _user: dict = Depends(require_admin_or_super_admin),
  726. db: Session = Depends(get_db),
  727. ):
  728. try:
  729. tenant_no = get_tenant_no(db, _user)
  730. user_id = _user.get("user_id", "") or _user.get("id", "")
  731. withdraw_approval(
  732. db,
  733. body.quoteId,
  734. tenant_no=tenant_no,
  735. remark=body.remark or "",
  736. user_id=user_id,
  737. )
  738. return success_response(None, message="撤回成功")
  739. except ValueError as e:
  740. return error_response(400, str(e))
  741. except Exception as e:
  742. return error_response(500, str(e))
  743. @router.post("/quote/approval/refreshNames")
  744. async def quote_approval_refresh_names(
  745. body: QuoteApprovalRefreshNamesBody = None,
  746. _user: dict = Depends(require_admin_or_super_admin),
  747. db: Session = Depends(get_db),
  748. ):
  749. try:
  750. req = body or QuoteApprovalRefreshNamesBody()
  751. count = refresh_approver_names(db, quote_id=req.quoteId)
  752. return success_response(count)
  753. except ValueError as e:
  754. return error_response(400, str(e))
  755. except Exception as e:
  756. return error_response(500, str(e))
  757. @router.post("/quote/shareLog/list")
  758. async def quote_share_log_list(
  759. body: QuoteShareLogListBody,
  760. _user: dict = Depends(require_admin_or_super_admin),
  761. db: Session = Depends(get_db),
  762. ):
  763. try:
  764. tenant_no = get_tenant_no(db, _user)
  765. user_info = crm_user_info(_user)
  766. rows = list_share_logs(db, body.quoteId, tenant_no=tenant_no)
  767. return success_response(rows)
  768. except ValueError as e:
  769. return error_response(400, str(e))
  770. except Exception as e:
  771. return error_response(500, str(e))
  772. @router.post("/quote/shareLog/statistics")
  773. async def quote_share_log_statistics(
  774. body: QuoteShareLogStatisticsBody,
  775. _user: dict = Depends(require_admin_or_super_admin),
  776. db: Session = Depends(get_db),
  777. ):
  778. try:
  779. tenant_no = get_tenant_no(db, _user)
  780. user_info = crm_user_info(_user)
  781. stats = share_log_statistics(db, body.quoteId, tenant_no=tenant_no)
  782. return success_response(stats)
  783. except ValueError as e:
  784. return error_response(400, str(e))
  785. except Exception as e:
  786. return error_response(500, str(e))
  787. @router.post("/quote-approver-setting/get")
  788. async def quote_approver_setting_get(
  789. _user: dict = Depends(require_admin_or_super_admin),
  790. db: Session = Depends(get_db),
  791. ):
  792. try:
  793. tenant_no = get_tenant_no(db, _user)
  794. data = get_setting(db, tenant_no=tenant_no)
  795. # 无配置时默认「启用」,避免设置页首次打开落到「停用」导致保存后无法预填
  796. return success_response(data or {"approverIds": [], "status": "0"})
  797. except Exception as e:
  798. return error_response(500, str(e))
  799. @router.post("/quote-approver-setting/save")
  800. async def quote_approver_setting_save(
  801. body: QuoteApproverSettingSaveBody,
  802. _user: dict = Depends(require_menu_code("system:approverSetting")),
  803. db: Session = Depends(get_db),
  804. ):
  805. try:
  806. tenant_no = get_tenant_no(db, _user)
  807. user_id = _user.get("user_id", "") or _user.get("id", "")
  808. dept_id = _user.get("dept_id", "") or _user.get("create_dept_id", "") or ""
  809. data = save_setting(
  810. db,
  811. tenant_no=tenant_no,
  812. approver_ids=body.approverIds or [],
  813. status=body.status or "0",
  814. user_id=user_id,
  815. dept_id=dept_id,
  816. )
  817. return success_response(data, message="保存成功")
  818. except ValueError as e:
  819. return error_response(400, str(e))
  820. except Exception as e:
  821. return error_response(500, str(e))