controller.py 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675
  1. from typing import Annotated
  2. import uuid
  3. from fastapi import APIRouter, Depends, Path, Query
  4. from fastapi.responses import JSONResponse
  5. from app.api.v1.module_system.auth.schema import AuthSchema
  6. from app.common.response import ResponseSchema, SuccessResponse
  7. from app.core.dependencies import AuthPermission
  8. from app.core.logger import log
  9. from app.core.router_class import OperationLogRoute
  10. from app.plugin.module_payment.expense.institution.schema import InstitutionListOutSchema
  11. from .service import InstitutionService, InstitutionScopeService, IssueruleService
  12. from alipay.aop.api.domain.AlipayEbppInvoiceInstitutionCreateModel import (
  13. AlipayEbppInvoiceInstitutionCreateModel,
  14. )
  15. from alipay.aop.api.response.AlipayEbppInvoiceInstitutionCreateResponse import (
  16. AlipayEbppInvoiceInstitutionCreateResponse,
  17. )
  18. from alipay.aop.api.domain.AlipayEbppInvoiceInstitutionDeleteModel import (
  19. AlipayEbppInvoiceInstitutionDeleteModel,
  20. )
  21. from alipay.aop.api.response.AlipayEbppInvoiceInstitutionDeleteResponse import (
  22. AlipayEbppInvoiceInstitutionDeleteResponse,
  23. )
  24. from alipay.aop.api.domain.AlipayEbppInvoiceInstitutionModifyModel import (
  25. AlipayEbppInvoiceInstitutionModifyModel,
  26. )
  27. from alipay.aop.api.response.AlipayEbppInvoiceInstitutionModifyResponse import (
  28. AlipayEbppInvoiceInstitutionModifyResponse,
  29. )
  30. InstitutionRouter = APIRouter(
  31. route_class=OperationLogRoute,
  32. prefix="/institution",
  33. tags=["费控制度"],
  34. )
  35. @InstitutionRouter.post(
  36. "",
  37. summary="创建费控制度",
  38. description="创建费控制度。支持串联调用:创建制度→设置成员→创建发放规则",
  39. )
  40. async def create_institution_controller(
  41. data: dict,
  42. auth: Annotated[AuthSchema, Depends(AuthPermission(["module_payment:expense:institution:create"]))],
  43. ) -> JSONResponse:
  44. """创建费控制度(含完整串联流程)"""
  45. enterprise_id = data.get("enterprise_id", "")
  46. if not enterprise_id:
  47. from app.plugin.module_payment.enterprise.model import EnterpriseModel
  48. from sqlalchemy import select
  49. tenant_id = auth.user.tenant_id if auth.user and auth.user.tenant_id else auth.tenant_id
  50. log.info(f"推导 enterprise_id: tenant_id={tenant_id}, user_tenant_id={getattr(auth.user, 'tenant_id', None)}")
  51. stmt = select(EnterpriseModel).where(EnterpriseModel.tenant_id == tenant_id).limit(1)
  52. result = await auth.db.execute(stmt)
  53. enterprise = result.scalar_one_or_none()
  54. log.info(f"查询 enterprise 结果: {enterprise.enterprise_id if enterprise else 'None'}")
  55. enterprise_id = enterprise.enterprise_id if enterprise else ""
  56. if enterprise_id:
  57. data["enterprise_id"] = enterprise_id
  58. # 字段映射:前端 name → Alipay institution_name
  59. if data.get("name") and not data.get("institution_name"):
  60. data["institution_name"] = data["name"]
  61. # Alipay 必填:商户外部单据号(唯一标识)
  62. if not data.get("outer_source_id"):
  63. data["outer_source_id"] = str(uuid.uuid4()).replace("-", "")
  64. # expense_type 映射:前端值 → 支付宝标准值
  65. EXPENSE_TYPE_MAP = {"GENERAL": "DEFAULT", "DEFAULT": "DEFAULT"}
  66. if data.get("expense_type") in EXPENSE_TYPE_MAP:
  67. data["expense_type"] = EXPENSE_TYPE_MAP[data["expense_type"]]
  68. # 时间格式补全:YYYY-MM-DD → YYYY-MM-DD HH:mm:ss
  69. if data.get("effective_start_date") and len(data["effective_start_date"]) == 10:
  70. data["effective_start_date"] = data["effective_start_date"] + " 00:00:00"
  71. if data.get("effective_end_date") and len(data["effective_end_date"]) == 10:
  72. data["effective_end_date"] = data["effective_end_date"] + " 23:59:59"
  73. elif not data.get("effective_end_date") and data.get("effective_time_type") == "unlimited":
  74. # 长期有效:设为2099年底
  75. data["effective_end_date"] = "2099-12-31 23:59:59"
  76. # 默认使用规则(支付宝必填)
  77. if not data.get("standard_info_list"):
  78. single_limit = data.get("single_limit", 0)
  79. period_type = data.get("period_type", "")
  80. amount = data.get("amount", 0)
  81. standard_info = {
  82. "standard_name": data.get("institution_name", "默认规则"),
  83. "standard_desc": f"单笔限额{single_limit}元" if single_limit else "通用规则",
  84. "consume_mode": "DEFAULT",
  85. "payment_policy": "PERSONAL",
  86. "personal_qrcode_mode": 0,
  87. "outer_source_id": str(uuid.uuid4()).replace("-", ""),
  88. }
  89. condition_list = []
  90. if single_limit:
  91. condition_list.append({"rule_factor": "QUOTA_TOTAL", "rule_name": "单次消费金额", "rule_value": str(single_limit)})
  92. # 定额发放时,将周期限额写入使用规则条件
  93. PERIOD_FACTOR_MAP = {
  94. "daily": "QUOTA_DAY", "weekly": "QUOTA_WEEK",
  95. "monthly": "QUOTA_MONTH", "quarterly": "QUOTA_QUARTER",
  96. "yearly": "QUOTA_YEAR",
  97. }
  98. if data.get("grant_mode") == "period" and period_type in PERIOD_FACTOR_MAP and amount:
  99. condition_list.append({
  100. "rule_factor": PERIOD_FACTOR_MAP[period_type],
  101. "rule_name": f"{period_type}限额",
  102. "rule_value": str(amount),
  103. })
  104. # 至少保证有一条条件规则(支付宝必填)
  105. if not condition_list:
  106. condition_list.append({
  107. "rule_factor": "QUOTA_TOTAL",
  108. "rule_name": "单次消费金额",
  109. "rule_value": "0",
  110. })
  111. standard_info["standard_condition_info_list"] = condition_list
  112. data["standard_info_list"] = [standard_info]
  113. institution_create_model = AlipayEbppInvoiceInstitutionCreateModel.from_alipay_dict(data)
  114. # 解析适用成员数据
  115. scope_data = None
  116. adapter_type = data.get("applicable_scope")
  117. if adapter_type and adapter_type not in ("NONE", "none"):
  118. ADAPTER_TYPE_MAP = {"all": "EMPLOYEE_ALL", "employee": "EMPLOYEE_SELECT", "department": "EMPLOYEE_DEPARTMENT"}
  119. mapped_adapter = ADAPTER_TYPE_MAP.get(adapter_type, adapter_type)
  120. scope_data = {
  121. "adapter_type": mapped_adapter,
  122. "owner_type": data.get("scope_owner_type", "EMPLOYEE"),
  123. "add_owner_id_list": data.get("scope_owner_id_list"),
  124. }
  125. # 全体员工时把 scope 写入创建请求(避免默认无scope导致支付宝后台不可操作)
  126. if adapter_type == "all":
  127. data["institution_scope_info"] = {
  128. "adapter_type": "ALL",
  129. "owner_type": "EMPLOYEE",
  130. }
  131. # 解析发放规则数据
  132. issuerule_data = None
  133. if data.get("grant_mode") == "period":
  134. period_type_raw = data.get("period_type", "monthly")
  135. # 映射前端period_type到支付宝枚举
  136. ISSUE_TYPE_MAP = {
  137. "daily": "ISSUE_DAY",
  138. "weekly": "ISSUE_WEEK",
  139. "monthly": "ISSUE_MONTH",
  140. "quarterly": "ISSUE_QUARTER",
  141. "yearly": "ISSUE_YEAR",
  142. }
  143. issue_type = ISSUE_TYPE_MAP.get(period_type_raw, "ISSUE_MONTH")
  144. amount = data.get("amount", 0)
  145. # 有效时间配置
  146. effective_time_type = data.get("effective_time_type", "unlimited")
  147. if effective_time_type == "unlimited":
  148. effective_period = '{"all": true}'
  149. elif effective_time_type == "workday":
  150. workday_start = data.get("workday_start_time", "00:00")
  151. workday_end = data.get("workday_end_time", "23:59")
  152. effective_period = f'{{"regular":{{"workday":[["{workday_start}","{workday_end}"]]}}}}'
  153. else:
  154. effective_period = '{"all": true}'
  155. issuerule_data = {
  156. "quota_type": "CAP",
  157. "issue_type": issue_type,
  158. "issue_amount_value": str(amount),
  159. "issue_rule_name": data.get("name", "") + "-发放规则",
  160. "effective_period": effective_period,
  161. "invalid_mode": 1 if data.get("effective_time_type") == "unlimited" else 0,
  162. "share_mode": 0,
  163. "outer_source_id": data.get("outer_source_id") or str(uuid.uuid4()),
  164. }
  165. result = await InstitutionService.create_institution_full_flow(
  166. auth=auth,
  167. institution_model=institution_create_model,
  168. enterprise_id=enterprise_id,
  169. scope_data=scope_data,
  170. issuerule_data=issuerule_data,
  171. raw_data=data,
  172. )
  173. log.info(f"创建费控制度成功: institution_id={result.get('institution_id')}")
  174. return SuccessResponse(data=result, msg="创建费控制度成功")
  175. @InstitutionRouter.get(
  176. "",
  177. summary="查询费控制度列表",
  178. description="分页查询费控制度列表",
  179. response_model=ResponseSchema[InstitutionListOutSchema],
  180. )
  181. async def list_institution_controller(
  182. auth: Annotated[AuthSchema, Depends(AuthPermission(["module_payment:expense:institution:list"]))],
  183. page_no: Annotated[int, Query(description="页码")] = 1,
  184. page_size: Annotated[int, Query(description="每页数量")] = 20,
  185. enterprise_id: Annotated[str | None, Query(description="企业ID")] = None,
  186. name: Annotated[str | None, Query(description="制度名称")] = None,
  187. expense_type: Annotated[str | None, Query(description="费用类型")] = None,
  188. status: Annotated[str | None, Query(description="状态")] = None,
  189. ) -> JSONResponse:
  190. """查询费控制度列表"""
  191. search = {}
  192. if enterprise_id:
  193. search["enterprise_id"] = enterprise_id
  194. if name:
  195. search["name"] = name
  196. if expense_type:
  197. search["expense_type"] = expense_type
  198. if status:
  199. search["status"] = status
  200. result = await InstitutionService.list_service(
  201. auth=auth, page_no=page_no, page_size=page_size, search=search
  202. )
  203. return SuccessResponse(data=result, msg="查询费控制度列表成功")
  204. @InstitutionRouter.get(
  205. "/{institution_id}",
  206. summary="查询费控制度详情",
  207. description="查询费控制度详情 (alipay.ebpp.invoice.institution.detailinfo.query),失败时降级到本地DB",
  208. )
  209. async def detail_institution_controller(
  210. institution_id: Annotated[str, Path(description="制度ID")],
  211. auth: Annotated[AuthSchema, Depends(AuthPermission(["module_payment:expense:institution:detail"]))],
  212. enterprise_id: Annotated[str | None, Query(description="企业ID")] = None,
  213. ) -> JSONResponse:
  214. """查询费控制度详情"""
  215. if not enterprise_id:
  216. from app.plugin.module_payment.enterprise.model import EnterpriseModel
  217. from sqlalchemy import select
  218. tenant_id = auth.user.tenant_id if auth.user and auth.user.tenant_id else auth.tenant_id
  219. stmt = select(EnterpriseModel).where(EnterpriseModel.tenant_id == tenant_id).limit(1)
  220. result = await auth.db.execute(stmt)
  221. ent = result.scalar_one_or_none()
  222. enterprise_id = ent.enterprise_id if ent else ""
  223. result = await InstitutionService.detailinfo_query_service(
  224. auth=auth,
  225. institution_id=institution_id,
  226. enterprise_id=enterprise_id,
  227. )
  228. if result is None:
  229. return SuccessResponse(data=None, msg="制度不存在")
  230. return SuccessResponse(data=result, msg="查询费控制度详情成功")
  231. @InstitutionRouter.delete(
  232. "",
  233. summary="删除费控制度",
  234. description="删除费控制度 (alipay.ebpp.invoice.institution.delete)",
  235. )
  236. async def delete_institution_controller(
  237. data: dict,
  238. auth: Annotated[AuthSchema, Depends(AuthPermission(["module_payment:expense:institution:delete"]))],
  239. ) -> JSONResponse:
  240. """删除费控制度"""
  241. institution_delete_model = AlipayEbppInvoiceInstitutionDeleteModel.from_alipay_dict(data)
  242. result = await InstitutionService.delete_institution_service(auth=auth, data=institution_delete_model)
  243. log.info(f"删除费控制度成功: institution_id={institution_delete_model.institution_id}, enterprise_id={institution_delete_model.enterprise_id}")
  244. return SuccessResponse(data=result, msg="删除费控制度成功")
  245. @InstitutionRouter.post(
  246. "/modify",
  247. summary="编辑费控制度",
  248. description="编辑费控制度 (alipay.ebpp.invoice.institution.modify)",
  249. )
  250. async def modify_institution_controller(
  251. data: dict,
  252. auth: Annotated[AuthSchema, Depends(AuthPermission(["module_payment:expense:institution:modify"]))],
  253. ) -> JSONResponse:
  254. """编辑费控制度"""
  255. # enterprise_id 推导
  256. if not data.get("enterprise_id"):
  257. from app.plugin.module_payment.enterprise.model import EnterpriseModel
  258. from sqlalchemy import select
  259. tenant_id = auth.user.tenant_id if auth.user and auth.user.tenant_id else auth.tenant_id
  260. stmt = select(EnterpriseModel).where(EnterpriseModel.tenant_id == tenant_id).limit(1)
  261. result = await auth.db.execute(stmt)
  262. enterprise = result.scalar_one_or_none()
  263. if enterprise:
  264. data["enterprise_id"] = enterprise.enterprise_id
  265. # name → institution_name
  266. if data.get("name") and not data.get("institution_name"):
  267. data["institution_name"] = data["name"]
  268. # 时间格式
  269. if data.get("effective_start_date") and len(data["effective_start_date"]) == 10:
  270. data["effective_start_date"] = data["effective_start_date"] + " 00:00:00"
  271. if data.get("effective_end_date") and len(data["effective_end_date"]) == 10:
  272. data["effective_end_date"] = data["effective_end_date"] + " 23:59:59"
  273. elif not data.get("effective_end_date") and data.get("effective_time_type") == "unlimited":
  274. data["effective_end_date"] = "2099-12-31 23:59:59"
  275. # expense_type 映射
  276. EXPENSE_TYPE_MAP = {"GENERAL": "DEFAULT", "DEFAULT": "DEFAULT"}
  277. if data.get("expense_type") in EXPENSE_TYPE_MAP:
  278. data["expense_type"] = EXPENSE_TYPE_MAP[data["expense_type"]]
  279. # 提取 scope 变更数据(需与基础修改分两次请求)
  280. applicable_scope = data.get("applicable_scope", "")
  281. scope_info = None
  282. enterprise_id = data.get("enterprise_id", "")
  283. if applicable_scope and applicable_scope not in ("NONE", "none"):
  284. ADAPTER_MAP = {"all": "EMPLOYEE_ALL", "employee": "EMPLOYEE_SELECT", "department": "EMPLOYEE_DEPARTMENT"}
  285. new_adapter = ADAPTER_MAP.get(applicable_scope, applicable_scope)
  286. # 查询当前scope:计算旧→新的差异
  287. old_ids = []
  288. try:
  289. scope_old = await InstitutionScopeService.scopepageinfo_query_service(
  290. auth=auth, institution_id=institution_id, enterprise_id=enterprise_id,
  291. page_num=1, page_size=500,
  292. )
  293. old_ids = [str(i) for i in (scope_old.get("owner_id_list") or []) if i]
  294. except Exception:
  295. log.warning(f"查询旧scope失败,将全量覆盖: institution_id={data.get('institution_id', '')}")
  296. new_ids_raw = data.get("scope_owner_id_list") or []
  297. new_ids = [str(i) for i in new_ids_raw if i is not None and str(i).strip()]
  298. # 计算差异
  299. old_set, new_set = set(old_ids), set(new_ids)
  300. add_ids = list(new_set - old_set)
  301. delete_ids = list(old_set - new_set)
  302. scope_info = {
  303. "enterprise_id": enterprise_id,
  304. "adapter_type": new_adapter,
  305. "owner_type": "EMPLOYEE",
  306. }
  307. if add_ids:
  308. scope_info["add_owner_id_list"] = add_ids
  309. if delete_ids:
  310. scope_info["delete_owner_id_list"] = delete_ids
  311. log.info(
  312. f"scope 差异: add={add_ids}, delete={delete_ids}, "
  313. f"old_count={len(old_ids)}, new_count={len(new_ids)}"
  314. )
  315. if not add_ids and not delete_ids:
  316. scope_info = None
  317. log.info("scope 无变化,跳过")
  318. elif applicable_scope in ("NONE", "none"):
  319. # 暂不设置:清空支付宝范围(调用 scope.modify 删除所有成员)
  320. try:
  321. scope_old = await InstitutionScopeService.scopepageinfo_query_service(
  322. auth=auth, institution_id=institution_id, enterprise_id=enterprise_id,
  323. page_num=1, page_size=500,
  324. )
  325. old_adapter = scope_old.get("adapter_type", "")
  326. old_ids = [str(i) for i in (scope_old.get("owner_id_list") or []) if i]
  327. # 对非NONE的旧范围,清空所有成员
  328. if old_adapter and old_adapter not in ("NONE",) and old_ids:
  329. scope_info = {
  330. "enterprise_id": enterprise_id,
  331. "adapter_type": old_adapter,
  332. "owner_type": "EMPLOYEE",
  333. "delete_owner_id_list": old_ids,
  334. }
  335. log.info(f"暂不设置 - 清空支付宝旧成员: {old_adapter}, count={len(old_ids)}")
  336. except Exception:
  337. log.warning(f"查询旧scope失败,跳过清空支付宝成员")
  338. # 从请求中移除 scope 数据,避免与基础修改冲突
  339. data.pop("modify_scope_info", None)
  340. # 第1次请求:仅修改制度基础信息(不含 scope)
  341. base_data = {k: v for k, v in data.items() if k != "modify_scope_info"}
  342. institution_modify_model = AlipayEbppInvoiceInstitutionModifyModel.from_alipay_dict(base_data)
  343. try:
  344. result = await InstitutionService.modify_institution_service(
  345. auth=auth, data=institution_modify_model, raw_data=base_data, scope_info=scope_info
  346. )
  347. except Exception as e:
  348. err_msg = str(e)
  349. if "consult" in err_msg.lower() or "咨询" in err_msg or "发" in err_msg:
  350. raise CustomException(msg="制度下存在发放规则,咨询模式不允许修改为外部服务商,请先删除发放规则后再试")
  351. raise
  352. log.info(f"编辑费控制度成功: institution_id={institution_modify_model.institution_id}")
  353. return SuccessResponse(data=result, msg="编辑费控制度成功")
  354. # ========== 制度成员范围管理 ==========
  355. @InstitutionRouter.get(
  356. "/{institution_id}/scope",
  357. summary="查询制度成员范围",
  358. description="查询制度下成员范围 (alipay.ebpp.invoice.institution.scopepageinfo.query)",
  359. )
  360. async def list_scope_controller(
  361. institution_id: Annotated[str, Path(description="制度ID")],
  362. auth: Annotated[AuthSchema, Depends(AuthPermission(["module_payment:expense:institution:scope:list"]))],
  363. enterprise_id: Annotated[str | None, Query(description="企业ID")] = None,
  364. owner_type: Annotated[str | None, Query(description="适配ID类型")] = None,
  365. page_num: Annotated[int, Query(description="页码")] = 1,
  366. page_size: Annotated[int, Query(description="每页条数")] = 20,
  367. ) -> JSONResponse:
  368. """查询制度成员"""
  369. result = await InstitutionScopeService.scopepageinfo_query_service(
  370. auth=auth,
  371. institution_id=institution_id,
  372. enterprise_id=enterprise_id,
  373. page_num=page_num,
  374. page_size=page_size,
  375. owner_type=owner_type,
  376. )
  377. return SuccessResponse(data=result, msg="查询成功")
  378. @InstitutionRouter.post(
  379. "/{institution_id}/scope",
  380. summary="设置制度成员范围",
  381. description="设置/修改制度成员范围 (alipay.ebpp.invoice.institution.scope.modify)",
  382. )
  383. async def modify_scope_controller(
  384. institution_id: Annotated[str, Path(description="制度ID")],
  385. data: dict,
  386. auth: Annotated[AuthSchema, Depends(AuthPermission(["module_payment:expense:institution:scope:modify"]))],
  387. ) -> JSONResponse:
  388. """设置制度成员"""
  389. from app.plugin.module_payment.employee.model import EmployeeModel
  390. from sqlalchemy import select
  391. enterprise_id = data.get("enterprise_id", "")
  392. new_adapter = data.get("adapter_type", "EMPLOYEE_ALL")
  393. # ====== 1. 查询旧适配类型和老员工ID列表 ======
  394. old_adapter = "NONE"
  395. old_employee_ids: set[str] = set()
  396. try:
  397. scope_old = await InstitutionScopeService.scopepageinfo_query_service(
  398. auth=auth, institution_id=institution_id, enterprise_id=enterprise_id,
  399. page_num=1, page_size=500,
  400. )
  401. old_adapter = scope_old.get("adapter_type", old_adapter)
  402. raw_old = [str(i) for i in (scope_old.get("owner_id_list") or []) if i]
  403. if old_adapter == "EMPLOYEE_ALL":
  404. # 全体员工模式 → 所有已签约员工
  405. stmt = select(EmployeeModel.employee_id).where(
  406. EmployeeModel.enterprise_id == enterprise_id,
  407. EmployeeModel.status == "ACTIVATED",
  408. )
  409. result = await auth.db.execute(stmt)
  410. old_employee_ids = {row[0] for row in result.fetchall() if row[0]}
  411. elif old_adapter == "EMPLOYEE_DEPARTMENT":
  412. # 按部门模式 → 部门下的所有已签约员工
  413. from app.plugin.module_payment.employee.model import EmployeeModel
  414. stmt = select(EmployeeModel.employee_id, EmployeeModel.department_ids).where(
  415. EmployeeModel.enterprise_id == enterprise_id,
  416. EmployeeModel.status == "ACTIVATED",
  417. )
  418. result = await auth.db.execute(stmt)
  419. dept_set = set(raw_old)
  420. for row in result.fetchall():
  421. if row[1] and dept_set.intersection(set(row[1])):
  422. if row[0]:
  423. old_employee_ids.add(row[0])
  424. else:
  425. old_employee_ids = set(raw_old)
  426. except Exception:
  427. old_adapter = "NONE" # 查不到旧范围时标记为NONE,确保走分步调用的逻辑
  428. log.warning(f"查询旧scope失败(将全量处理): institution_id={institution_id}")
  429. # ====== 2. 计算新员工ID列表 ======
  430. new_employee_ids: set[str] = set()
  431. if new_adapter == "EMPLOYEE_ALL":
  432. stmt = select(EmployeeModel.employee_id).where(
  433. EmployeeModel.enterprise_id == enterprise_id,
  434. EmployeeModel.status == "ACTIVATED",
  435. )
  436. result = await auth.db.execute(stmt)
  437. new_employee_ids = {row[0] for row in result.fetchall() if row[0]}
  438. elif new_adapter == "EMPLOYEE_DEPARTMENT":
  439. dept_ids = data.get("add_owner_id_list") or []
  440. dept_set = set(str(d) for d in dept_ids if d)
  441. stmt = select(EmployeeModel.employee_id, EmployeeModel.department_ids).where(
  442. EmployeeModel.enterprise_id == enterprise_id,
  443. EmployeeModel.status == "ACTIVATED",
  444. )
  445. result = await auth.db.execute(stmt)
  446. for row in result.fetchall():
  447. if row[1] and dept_set.intersection(set(row[1])):
  448. if row[0]:
  449. new_employee_ids.add(row[0])
  450. else:
  451. raw_new = data.get("add_owner_id_list") or []
  452. new_employee_ids = set(str(i) for i in raw_new if i is not None and str(i).strip())
  453. # ====== 3. 计算员工级差异(用于配额联动) ======
  454. add_emp_ids = list(new_employee_ids - old_employee_ids)
  455. delete_emp_ids = list(old_employee_ids - new_employee_ids)
  456. # 提取传给支付宝的原始ID(部门模式传部门ID,员工模式传员工ID) ======
  457. alipay_add_ids: list[str] = []
  458. alipay_delete_ids: list[str] = []
  459. if new_adapter == "EMPLOYEE_DEPARTMENT":
  460. dept_ids = data.get("add_owner_id_list") or []
  461. alipay_add_ids = [str(d) for d in dept_ids if d]
  462. elif new_adapter == "EMPLOYEE_SELECT":
  463. alipay_add_ids = list(new_employee_ids - old_employee_ids)
  464. alipay_delete_ids = list(old_employee_ids - new_employee_ids)
  465. # ====== 4. 调用支付宝 scope.modify ======
  466. # 部门模式:需一次性传部门ID,不支持分步
  467. if new_adapter == "EMPLOYEE_DEPARTMENT":
  468. scope_data = {
  469. "enterprise_id": enterprise_id,
  470. "adapter_type": "EMPLOYEE_DEPARTMENT",
  471. "owner_type": data.get("owner_type", "EMPLOYEE"),
  472. }
  473. if alipay_add_ids:
  474. scope_data["add_owner_id_list"] = alipay_add_ids
  475. result = await InstitutionScopeService.scope_modify_service(
  476. auth=auth, institution_id=institution_id, data=scope_data,
  477. )
  478. elif old_adapter != new_adapter and new_adapter != "EMPLOYEE_ALL":
  479. # SELECT模式 + 适配类型变更:先改类型,再加员工
  480. await InstitutionScopeService.scope_modify_service(
  481. auth=auth, institution_id=institution_id,
  482. data={
  483. "enterprise_id": enterprise_id,
  484. "adapter_type": new_adapter,
  485. "owner_type": data.get("owner_type", "EMPLOYEE"),
  486. },
  487. )
  488. if alipay_add_ids or alipay_delete_ids:
  489. scope_data = {
  490. "enterprise_id": enterprise_id,
  491. "adapter_type": new_adapter,
  492. "owner_type": data.get("owner_type", "EMPLOYEE"),
  493. }
  494. if alipay_add_ids:
  495. scope_data["add_owner_id_list"] = alipay_add_ids
  496. if alipay_delete_ids:
  497. scope_data["delete_owner_id_list"] = alipay_delete_ids
  498. result = await InstitutionScopeService.scope_modify_service(
  499. auth=auth, institution_id=institution_id, data=scope_data,
  500. )
  501. else:
  502. result = {"result": True}
  503. else:
  504. # ALL模式 或 类型不变
  505. if alipay_add_ids or alipay_delete_ids:
  506. scope_data = {
  507. "enterprise_id": enterprise_id,
  508. "adapter_type": new_adapter,
  509. "owner_type": data.get("owner_type", "EMPLOYEE"),
  510. }
  511. if alipay_add_ids:
  512. scope_data["add_owner_id_list"] = alipay_add_ids
  513. if alipay_delete_ids:
  514. scope_data["delete_owner_id_list"] = alipay_delete_ids
  515. result = await InstitutionScopeService.scope_modify_service(
  516. auth=auth, institution_id=institution_id, data=scope_data,
  517. )
  518. else:
  519. result = {"result": True}
  520. # ====== 5. 更新本地库 + 额度联动 ======
  521. try:
  522. from .crud import InstitutionCRUD
  523. crud = InstitutionCRUD(auth)
  524. scope_map = {"EMPLOYEE_ALL": "all", "EMPLOYEE_SELECT": "employee", "EMPLOYEE_DEPARTMENT": "department"}
  525. applicable_scope = scope_map.get(new_adapter, "all")
  526. update_data = {"applicable_scope": applicable_scope}
  527. if new_adapter == "EMPLOYEE_DEPARTMENT":
  528. dept_ids = data.get("add_owner_id_list") or []
  529. if dept_ids:
  530. update_data["department_id"] = str(dept_ids[0])
  531. await crud.update_by_institution_id(institution_id, update_data)
  532. if enterprise_id:
  533. from .service import InstitutionService
  534. scope_info = {
  535. "adapter_type": new_adapter,
  536. "owner_type": "EMPLOYEE",
  537. "add_owner_id_list": add_emp_ids,
  538. "delete_owner_id_list": delete_emp_ids,
  539. }
  540. await InstitutionService._sync_modify_quotas_by_scope(
  541. auth=auth,
  542. institution_id=institution_id,
  543. enterprise_id=enterprise_id,
  544. scope_info=scope_info,
  545. raw_data={},
  546. )
  547. except Exception as e:
  548. log.warning(f"本地scope同步失败(不影响支付宝侧): {e}")
  549. log.info(f"设置成员成功: {old_adapter}→{new_adapter}, "
  550. f"加{len(add_ids)}人, 减{len(delete_ids)}人")
  551. return SuccessResponse(data=result, msg="设置成功")
  552. # ========== 自动额度发放规则管理 ==========
  553. @InstitutionRouter.post(
  554. "/{institution_id}/issuerule",
  555. summary="创建自动发放规则",
  556. description="创建自动额度发放规则 (alipay.ebpp.invoice.issuerule.create)",
  557. )
  558. async def create_issuerule_controller(
  559. institution_id: Annotated[str, Path(description="制度ID")],
  560. data: dict,
  561. auth: Annotated[AuthSchema, Depends(AuthPermission(["module_payment:expense:institution:issuerule:create"]))],
  562. ) -> JSONResponse:
  563. """创建自动发放规则"""
  564. result = await IssueruleService.create_issuerule_service(
  565. auth=auth,
  566. institution_id=institution_id,
  567. enterprise_id=data.get("enterprise_id", ""),
  568. quota_type=data.get("quota_type", "CAP"),
  569. issue_type=data.get("issue_type", "ISSUE_MONTH"),
  570. issue_amount_value=data.get("issue_amount_value", "0"),
  571. outer_source_id=data.get("outer_source_id"),
  572. issue_rule_name=data.get("issue_rule_name"),
  573. effective_period=data.get("effective_period"),
  574. invalid_mode=data.get("invalid_mode"),
  575. share_mode=data.get("share_mode"),
  576. )
  577. log.info(f"创建自动发放规则成功: institution_id={institution_id}")
  578. return SuccessResponse(data=result, msg="创建自动发放规则成功")
  579. @InstitutionRouter.put(
  580. "/{institution_id}/issuerule/{issue_rule_id}",
  581. summary="编辑自动发放规则",
  582. description="编辑自动额度发放规则 (alipay.ebpp.invoice.issuerule.modify)",
  583. )
  584. async def modify_issuerule_controller(
  585. institution_id: Annotated[str, Path(description="制度ID")],
  586. issue_rule_id: Annotated[str, Path(description="发放规则ID")],
  587. data: dict,
  588. auth: Annotated[AuthSchema, Depends(AuthPermission(["module_payment:expense:institution:issuerule:modify"]))],
  589. ) -> JSONResponse:
  590. result = await IssueruleService.modify_issuerule_service(
  591. auth=auth,
  592. institution_id=institution_id,
  593. issue_rule_id=issue_rule_id,
  594. enterprise_id=data.get("enterprise_id", ""),
  595. quota_type=data.get("quota_type"),
  596. issue_type=data.get("issue_type"),
  597. issue_amount_value=data.get("issue_amount_value"),
  598. issue_rule_name=data.get("issue_rule_name"),
  599. effective=data.get("effective"),
  600. effective_period=data.get("effective_period"),
  601. invalid_mode=data.get("invalid_mode"),
  602. share_mode=data.get("share_mode"),
  603. )
  604. log.info(f"编辑自动发放规则成功: issue_rule_id={issue_rule_id}")
  605. return SuccessResponse(data=result, msg="编辑自动发放规则成功")
  606. @InstitutionRouter.delete(
  607. "/{institution_id}/issuerule",
  608. summary="删除自动发放规则",
  609. description="删除自动额度发放规则 (alipay.ebpp.invoice.issuerule.delete)",
  610. )
  611. async def delete_issuerule_controller(
  612. institution_id: Annotated[str, Path(description="制度ID")],
  613. data: dict,
  614. auth: Annotated[AuthSchema, Depends(AuthPermission(["module_payment:expense:institution:issuerule:delete"]))],
  615. ) -> JSONResponse:
  616. result = await IssueruleService.delete_issuerule_service(
  617. auth=auth,
  618. institution_id=institution_id,
  619. issue_rule_id_list=data.get("issue_rule_id_list", []),
  620. enterprise_id=data.get("enterprise_id", ""),
  621. )
  622. log.info(f"删除自动发放规则成功: institution_id={institution_id}")
  623. return SuccessResponse(data=result, msg="删除自动发放规则成功")