contract_approver_setting.py 2.8 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495
  1. from __future__ import annotations
  2. from datetime import datetime
  3. from typing import Any, Dict, List, Optional
  4. from sqlalchemy.orm import Session
  5. from app.core.utils import generate_uuid
  6. from app.crud.crm.quote_approver_setting import join_approver_ids, parse_approver_ids
  7. from app.models.crm_models import CrmContractApproverSetting
  8. from app.models.models import SysUser
  9. def _row_to_dict(row: CrmContractApproverSetting) -> Dict[str, Any]:
  10. return {
  11. "id": row.id,
  12. "approverIds": parse_approver_ids(row.approver_ids),
  13. "status": row.status or "0",
  14. "tenantNo": row.tenant_no,
  15. "updateTime": row.update_time.isoformat(sep=" ") if row.update_time else None,
  16. }
  17. def get_setting(db: Session, *, tenant_no: str) -> Optional[Dict[str, Any]]:
  18. row = (
  19. db.query(CrmContractApproverSetting)
  20. .filter(
  21. CrmContractApproverSetting.tenant_no == tenant_no,
  22. CrmContractApproverSetting.del_flag == 0,
  23. )
  24. .order_by(CrmContractApproverSetting.update_time.desc())
  25. .first()
  26. )
  27. return _row_to_dict(row) if row else None
  28. def _assert_users_exist(db: Session, *, tenant_no: str, approver_ids: List[str]) -> None:
  29. ids = [str(i).strip() for i in approver_ids if str(i).strip()]
  30. if not ids:
  31. return
  32. rows = (
  33. db.query(SysUser.id)
  34. .filter(SysUser.id.in_(ids), SysUser.del_flag == 0)
  35. .all()
  36. )
  37. found = {str(r[0]) for r in rows}
  38. missing = [i for i in ids if i not in found]
  39. if missing:
  40. raise ValueError(f"审批人无效或不存在:{','.join(missing)}")
  41. def save_setting(
  42. db: Session,
  43. *,
  44. tenant_no: str,
  45. approver_ids: List[str],
  46. status: str,
  47. user_id: str = None,
  48. dept_id: str = "",
  49. ) -> Dict[str, Any]:
  50. status_norm = "1" if str(status) == "1" else "0"
  51. ids = [str(i).strip() for i in (approver_ids or []) if str(i).strip()]
  52. _assert_users_exist(db, tenant_no=tenant_no, approver_ids=ids)
  53. row = (
  54. db.query(CrmContractApproverSetting)
  55. .filter(
  56. CrmContractApproverSetting.tenant_no == tenant_no,
  57. CrmContractApproverSetting.del_flag == 0,
  58. )
  59. .first()
  60. )
  61. now = datetime.now()
  62. if row:
  63. row.approver_ids = join_approver_ids(ids)
  64. row.status = status_norm
  65. row.update_by = user_id
  66. row.update_time = now
  67. else:
  68. row = CrmContractApproverSetting(
  69. id=generate_uuid(),
  70. approver_ids=join_approver_ids(ids),
  71. status=status_norm,
  72. tenant_no=tenant_no,
  73. create_by=user_id,
  74. create_dept_id=dept_id or "",
  75. create_time=now,
  76. update_by=user_id,
  77. update_time=now,
  78. del_flag=0,
  79. )
  80. db.add(row)
  81. db.commit()
  82. db.refresh(row)
  83. return _row_to_dict(row)