service.py 38 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927
  1. import asyncio
  2. from app.api.v1.module_system.auth.schema import AuthSchema
  3. from app.core.alipay import AlipayClient
  4. from app.core.exceptions import CustomException
  5. from app.core.logger import log
  6. from app.plugin.module_payment.expense.institution.schema import InstitutionListOutSchema, InstitutionCreateSchema
  7. from .crud import InstitutionCRUD
  8. from .enums import InstitutionStatusEnum
  9. from alipay.aop.api.request.AlipayEbppInvoiceInstitutionCreateRequest import (
  10. AlipayEbppInvoiceInstitutionCreateRequest,
  11. )
  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.request.AlipayEbppInvoiceInstitutionPageinfoQueryRequest import (
  19. AlipayEbppInvoiceInstitutionPageinfoQueryRequest,
  20. )
  21. from alipay.aop.api.domain.AlipayEbppInvoiceInstitutionPageinfoQueryModel import (
  22. AlipayEbppInvoiceInstitutionPageinfoQueryModel,
  23. )
  24. from alipay.aop.api.response.AlipayEbppInvoiceInstitutionPageinfoQueryResponse import (
  25. AlipayEbppInvoiceInstitutionPageinfoQueryResponse,
  26. )
  27. from alipay.aop.api.request.AlipayEbppInvoiceInstitutionDetailinfoQueryRequest import (
  28. AlipayEbppInvoiceInstitutionDetailinfoQueryRequest,
  29. )
  30. from alipay.aop.api.domain.AlipayEbppInvoiceInstitutionDetailinfoQueryModel import (
  31. AlipayEbppInvoiceInstitutionDetailinfoQueryModel,
  32. )
  33. from alipay.aop.api.response.AlipayEbppInvoiceInstitutionDetailinfoQueryResponse import (
  34. AlipayEbppInvoiceInstitutionDetailinfoQueryResponse,
  35. )
  36. from alipay.aop.api.request.AlipayEbppInvoiceInstitutionDeleteRequest import (
  37. AlipayEbppInvoiceInstitutionDeleteRequest,
  38. )
  39. from alipay.aop.api.domain.AlipayEbppInvoiceInstitutionDeleteModel import (
  40. AlipayEbppInvoiceInstitutionDeleteModel,
  41. )
  42. from alipay.aop.api.response.AlipayEbppInvoiceInstitutionDeleteResponse import (
  43. AlipayEbppInvoiceInstitutionDeleteResponse,
  44. )
  45. from alipay.aop.api.request.AlipayEbppInvoiceInstitutionModifyRequest import (
  46. AlipayEbppInvoiceInstitutionModifyRequest,
  47. )
  48. from alipay.aop.api.domain.AlipayEbppInvoiceInstitutionModifyModel import (
  49. AlipayEbppInvoiceInstitutionModifyModel,
  50. )
  51. from alipay.aop.api.response.AlipayEbppInvoiceInstitutionModifyResponse import (
  52. AlipayEbppInvoiceInstitutionModifyResponse,
  53. )
  54. class InstitutionService:
  55. """费控制度服务层"""
  56. @classmethod
  57. def _execute_alipay(cls, request):
  58. """同步执行支付宝调用(通过线程池避免阻塞事件循环)"""
  59. client = AlipayClient.get_client()
  60. return client.execute(request)
  61. @classmethod
  62. async def create_institution_service(
  63. cls, auth: AuthSchema, data: AlipayEbppInvoiceInstitutionCreateModel
  64. ) -> AlipayEbppInvoiceInstitutionCreateResponse:
  65. """
  66. 创建费控制度(仅调 institution.create,不包含串联流程)
  67. 调用: alipay.ebpp.invoice.institution.create
  68. """
  69. if data.enterprise_id is None:
  70. raise CustomException(msg="创建费控制度失败: 企业ID不能为空")
  71. data.currency = 'CNY'
  72. request = AlipayEbppInvoiceInstitutionCreateRequest()
  73. request.biz_model = data
  74. response = await asyncio.to_thread(cls._execute_alipay, request)
  75. if not response:
  76. raise CustomException(msg="创建费控制度失败: 无响应")
  77. result = AlipayEbppInvoiceInstitutionCreateResponse()
  78. result.parse_response_content(response)
  79. if not result.is_success():
  80. log.error(f"支付宝接口调用失败: {result.code} - {result.msg}")
  81. raise CustomException(msg=f"创建费控制度失败: {result.msg}")
  82. return result
  83. @classmethod
  84. async def create_institution_full_flow(
  85. cls,
  86. auth: AuthSchema,
  87. institution_model: AlipayEbppInvoiceInstitutionCreateModel,
  88. enterprise_id: str,
  89. scope_data: dict | None = None,
  90. issuerule_data: dict | None = None,
  91. raw_data: dict | None = None,
  92. ) -> dict:
  93. """
  94. 创建费控制度(完整串联流程)
  95. 流程:
  96. 1. institution.create → 获取 institution_id
  97. 2. scope.modify ← 如有适用成员数据(scope_data)
  98. 3. issuerule.create ← 如为"按固定周期发放"(issuerule_data)
  99. 4. 保存到本地DB(制度 + 使用规则 + 发放规则)
  100. """
  101. # 第1步:创建制度
  102. institution_result = await cls.create_institution_service(auth=auth, data=institution_model)
  103. institution_id = institution_result.institution_id
  104. try:
  105. # 第2步:设置适用成员(如有)
  106. scope_modified = False
  107. if scope_data and scope_data.get("adapter_type") and scope_data.get("adapter_type") != "NONE":
  108. await InstitutionScopeService.scope_modify_service(
  109. auth=auth,
  110. institution_id=institution_id,
  111. data={
  112. "enterprise_id": enterprise_id,
  113. "adapter_type": scope_data["adapter_type"],
  114. "owner_type": scope_data.get("owner_type"),
  115. "add_owner_id_list": scope_data.get("add_owner_id_list"),
  116. },
  117. )
  118. scope_modified = True
  119. log.info(f"成员设置成功: institution_id={institution_id}")
  120. # 第3步:创建自动发放规则(如为"按固定周期发放")
  121. issue_rule_id = None
  122. if issuerule_data:
  123. issuerule_result = await IssueruleService.create_issuerule_service(
  124. auth=auth,
  125. institution_id=institution_id,
  126. enterprise_id=enterprise_id,
  127. quota_type=issuerule_data.get("quota_type", "CAP"),
  128. issue_type=issuerule_data.get("issue_type", "ISSUE_MONTH"),
  129. issue_amount_value=issuerule_data.get("issue_amount_value", "0"),
  130. outer_source_id=issuerule_data.get("outer_source_id"),
  131. issue_rule_name=issuerule_data.get("issue_rule_name"),
  132. effective_period=issuerule_data.get("effective_period"),
  133. invalid_mode=issuerule_data.get("invalid_mode", 0),
  134. share_mode=issuerule_data.get("share_mode", 0),
  135. )
  136. issue_rule_id = issuerule_result.get("issue_rule_id")
  137. log.info(f"发放规则创建成功: institution_id={institution_id}, issue_rule_id={issue_rule_id}")
  138. except Exception as e:
  139. # 子步骤失败:删除已创建的支付宝制度(补偿事务)
  140. log.error(f"创建串联流程失败: {e},开始回滚 institution_id={institution_id}")
  141. try:
  142. from alipay.aop.api.request.AlipayEbppInvoiceInstitutionDeleteRequest import (
  143. AlipayEbppInvoiceInstitutionDeleteRequest,
  144. )
  145. from alipay.aop.api.domain.AlipayEbppInvoiceInstitutionDeleteModel import (
  146. AlipayEbppInvoiceInstitutionDeleteModel,
  147. )
  148. rollback_model = AlipayEbppInvoiceInstitutionDeleteModel()
  149. rollback_model.institution_id = institution_id
  150. rollback_model.enterprise_id = enterprise_id
  151. req = AlipayEbppInvoiceInstitutionDeleteRequest()
  152. req.biz_model = rollback_model
  153. await asyncio.to_thread(cls._execute_alipay, req)
  154. log.info(f"回滚成功: 已删除 institution_id={institution_id}")
  155. except Exception as rollback_err:
  156. log.error(f"回滚失败: {rollback_err}")
  157. raise
  158. # 第4步:保存到本地DB
  159. create_data = InstitutionCreateSchema(
  160. enterprise_id=enterprise_id,
  161. institution_id=institution_id,
  162. institution_name=getattr(institution_model, 'institution_name', None),
  163. institution_desc=getattr(institution_model, 'institution_desc', None),
  164. scene_type=getattr(institution_model, 'scene_type', None),
  165. expense_type=getattr(institution_model, 'expense_type', None),
  166. expense_sub_type=getattr(institution_model, 'expense_sub_type', None),
  167. status=InstitutionStatusEnum.INSTITUTION_CREATE.value,
  168. effective=getattr(institution_model, 'effective', None),
  169. effective_start_date=getattr(institution_model, 'effective_start_date', None),
  170. effective_end_date=getattr(institution_model, 'effective_end_date', None),
  171. consult_mode=getattr(institution_model, 'consult_mode', None),
  172. multi_employee_share_mode=getattr(institution_model, 'multi_employee_share_mode', None),
  173. currency=getattr(institution_model, 'currency', None)
  174. )
  175. create_data_dict = create_data.model_dump(exclude_unset=True)
  176. crud = InstitutionCRUD(auth)
  177. await crud.create(create_data_dict)
  178. # 第5步:保存使用规则到本地
  179. if raw_data and raw_data.get("standard_info_list") and hasattr(institution_result, 'standard_id_info_list') and institution_result.standard_id_info_list:
  180. from app.plugin.module_payment.expense.rule.crud import RuleCRUD
  181. from app.plugin.module_payment.expense.rule.service import RuleService
  182. standard_id_map = {}
  183. for info in institution_result.standard_id_info_list:
  184. if hasattr(info, 'outer_source_id') and hasattr(info, 'standard_id'):
  185. standard_id_map[info.outer_source_id] = info.standard_id
  186. for idx, std in enumerate(raw_data["standard_info_list"]):
  187. std_data = {
  188. "out_biz_no": std.get("outer_source_id", f"std_{institution_id}_{idx}"),
  189. "institution_id": institution_id,
  190. "rule_id": standard_id_map.get(std.get("outer_source_id", "")),
  191. "standard_name": std.get("standard_name"),
  192. "standard_desc": std.get("standard_desc"),
  193. "expense_type_sub_category": std.get("expense_type_sub_category", "DEFAULT"),
  194. "enterprise_id": enterprise_id,
  195. }
  196. try:
  197. from app.plugin.module_payment.expense.rule.model import ExpenseRuleModel
  198. from sqlalchemy import insert
  199. stmt = insert(ExpenseRuleModel).values(**std_data)
  200. await auth.db.execute(stmt)
  201. await auth.db.flush()
  202. except Exception as e:
  203. log.warning(f"保存使用规则到本地失败: {e}")
  204. # 第6步:保存发放规则到本地
  205. if issuerule_data and issue_rule_id:
  206. from app.plugin.module_payment.expense.quota.model import QuotaModel
  207. quota_save_data = {
  208. "employee_id": "",
  209. "institution_id": institution_id,
  210. "out_biz_no": issuerule_data.get("outer_source_id", f"issue_{institution_id}"),
  211. "quota_id": issue_rule_id,
  212. "total_amount": float(issuerule_data.get("issue_amount_value", 0)),
  213. "available_amount": float(issuerule_data.get("issue_amount_value", 0)),
  214. "status": "QUOTA_ACTIVE",
  215. "enterprise_id": enterprise_id,
  216. }
  217. try:
  218. from sqlalchemy import insert
  219. stmt = insert(QuotaModel).values(**quota_save_data)
  220. await auth.db.execute(stmt)
  221. await auth.db.flush()
  222. except Exception as e:
  223. log.warning(f"保存发放规则到本地失败: {e}")
  224. return {
  225. "institution_id": institution_id,
  226. "scope_modified": scope_modified,
  227. "issue_rule_id": issue_rule_id,
  228. }
  229. @classmethod
  230. async def pageinfo_query_service(
  231. cls,
  232. auth: AuthSchema,
  233. enterprise_id: str,
  234. page_no: int = 1,
  235. page_size: int = 20,
  236. institution_name: str | None = None,
  237. ) -> dict:
  238. """
  239. 从支付宝查询费控制度列表
  240. 调用: alipay.ebpp.invoice.institution.pageinfo.query
  241. 失败时降级到本地DB
  242. """
  243. try:
  244. model = AlipayEbppInvoiceInstitutionPageinfoQueryModel()
  245. model.enterprise_id = enterprise_id
  246. model.page_num = page_no
  247. model.page_size = page_size
  248. if institution_name:
  249. model.institution_name = institution_name
  250. req = AlipayEbppInvoiceInstitutionPageinfoQueryRequest()
  251. req.biz_model = model
  252. response = await asyncio.to_thread(cls._execute_alipay, req)
  253. if response:
  254. result = AlipayEbppInvoiceInstitutionPageinfoQueryResponse()
  255. result.parse_response_content(response)
  256. if result.is_success():
  257. return {
  258. "page_no": getattr(result, 'page_num', page_no) or page_no,
  259. "page_size": getattr(result, 'page_size', page_size) or page_size,
  260. "total": getattr(result, 'total_page_count', 0) or 0,
  261. "list": getattr(result, 'institution_list', []) or [],
  262. }
  263. log.warning("支付宝 pageinfo.query 失败,降级到本地DB")
  264. except Exception as e:
  265. log.warning(f"支付宝 pageinfo.query 异常: {e},降级到本地DB")
  266. # 降级:查本地DB
  267. crud = InstitutionCRUD(auth)
  268. search = {"enterprise_id": enterprise_id}
  269. if institution_name:
  270. search["institution_name"] = institution_name
  271. offset = (page_no - 1) * page_size
  272. return await crud.page(
  273. offset=offset,
  274. limit=page_size,
  275. order_by=[{"id": "desc"}],
  276. search=search,
  277. out_schema=InstitutionListOutSchema,
  278. )
  279. @classmethod
  280. async def detailinfo_query_service(
  281. cls,
  282. auth: AuthSchema,
  283. institution_id: str,
  284. enterprise_id: str,
  285. ) -> dict | None:
  286. """
  287. 从支付宝查询费控制度详情
  288. 调用: alipay.ebpp.invoice.institution.detailinfo.query
  289. 失败时降级到本地DB
  290. """
  291. try:
  292. model = AlipayEbppInvoiceInstitutionDetailinfoQueryModel()
  293. model.institution_id = institution_id
  294. model.enterprise_id = enterprise_id
  295. req = AlipayEbppInvoiceInstitutionDetailinfoQueryRequest()
  296. req.biz_model = model
  297. response = await asyncio.to_thread(cls._execute_alipay, req)
  298. if response:
  299. result = AlipayEbppInvoiceInstitutionDetailinfoQueryResponse()
  300. result.parse_response_content(response)
  301. if result.is_success():
  302. return result.to_alipay_dict()
  303. log.warning("支付宝 detailinfo.query 失败,降级到本地DB")
  304. except Exception as e:
  305. log.warning(f"支付宝 detailinfo.query 异常: {e},降级到本地DB")
  306. # 降级:查本地DB
  307. crud = InstitutionCRUD(auth)
  308. obj = await crud.get(institution_id=institution_id, enterprise_id=enterprise_id)
  309. if obj:
  310. return InstitutionListOutSchema.model_validate(obj).model_dump()
  311. return None
  312. @classmethod
  313. async def list_service(
  314. cls,
  315. auth: AuthSchema,
  316. page_no: int = 1,
  317. page_size: int = 20,
  318. search: dict | None = None,
  319. ) -> dict:
  320. """
  321. 查询费控制度列表
  322. 优先调支付宝,失败降级到本地DB
  323. """
  324. enterprise_id = (search or {}).get("enterprise_id", "")
  325. institution_name = (search or {}).get("name") or (search or {}).get("institution_name")
  326. if enterprise_id:
  327. return await cls.pageinfo_query_service(
  328. auth=auth,
  329. enterprise_id=enterprise_id,
  330. page_no=page_no,
  331. page_size=page_size,
  332. institution_name=institution_name,
  333. )
  334. # 无 enterprise_id 时直接查本地
  335. crud = InstitutionCRUD(auth)
  336. offset = (page_no - 1) * page_size
  337. return await crud.page(
  338. offset=offset,
  339. limit=page_size,
  340. order_by=[{"id": "desc"}],
  341. search=search or {},
  342. out_schema=InstitutionListOutSchema,
  343. )
  344. @classmethod
  345. async def delete_institution_service(
  346. cls, auth: AuthSchema, data: AlipayEbppInvoiceInstitutionDeleteModel
  347. ) -> AlipayEbppInvoiceInstitutionDeleteResponse:
  348. """
  349. 删除费控制度
  350. 调用: alipay.ebpp.invoice.institution.delete
  351. """
  352. request = AlipayEbppInvoiceInstitutionDeleteRequest()
  353. request.biz_model = data
  354. response = await asyncio.to_thread(cls._execute_alipay, request)
  355. if not response:
  356. raise CustomException(msg="删除费控制度失败: 无响应")
  357. result = AlipayEbppInvoiceInstitutionDeleteResponse()
  358. result.parse_response_content(response)
  359. if not result.is_success():
  360. log.error(f"支付宝接口调用失败: {result.code} - {result.msg}")
  361. raise CustomException(msg=f"删除费控制度失败: {result.msg}")
  362. # 同步删除本地记录
  363. try:
  364. crud = InstitutionCRUD(auth)
  365. institution_id = getattr(data, 'institution_id', None)
  366. if institution_id:
  367. obj = await crud.get(institution_id=institution_id)
  368. if obj:
  369. await crud.delete(ids=[obj.id])
  370. log.info(f"已删除本地记录: institution_id={institution_id}")
  371. except Exception as e:
  372. log.warning(f"删除本地记录失败(不影响支付宝侧): {e}")
  373. return result
  374. @classmethod
  375. async def modify_institution_service(
  376. cls, auth: AuthSchema, data: AlipayEbppInvoiceInstitutionModifyModel, raw_data: dict | None = None
  377. ) -> AlipayEbppInvoiceInstitutionModifyResponse:
  378. """
  379. 编辑费控制度
  380. 调用: alipay.ebpp.invoice.institution.modify
  381. 支付宝成功后同步更新本地DB:
  382. - 制度基本信息
  383. - 使用规则(standard_info_list → pay_expense_rule)
  384. - 额度(issuerule → pay_expense_quota)
  385. """
  386. if data.institution_id is None:
  387. raise CustomException(msg="编辑费控制度失败: 制度ID不能为空")
  388. request = AlipayEbppInvoiceInstitutionModifyRequest()
  389. request.biz_model = data
  390. response = await asyncio.to_thread(cls._execute_alipay, request)
  391. if not response:
  392. raise CustomException(msg="编辑费控制度失败: 无响应")
  393. result = AlipayEbppInvoiceInstitutionModifyResponse()
  394. result.parse_response_content(response)
  395. if not result.is_success():
  396. log.error(f"支付宝接口调用失败: {result.code} - {result.msg}")
  397. raise CustomException(msg=f"编辑费控制度失败: {result.msg}")
  398. # 同步更新本地数据库
  399. institution_id = getattr(data, 'institution_id', None)
  400. if not institution_id:
  401. return result
  402. try:
  403. crud = InstitutionCRUD(auth)
  404. update_data = {}
  405. if hasattr(data, 'institution_name') and data.institution_name:
  406. update_data['institution_name'] = data.institution_name
  407. if hasattr(data, 'institution_desc') and data.institution_desc:
  408. update_data['institution_desc'] = data.institution_desc
  409. if hasattr(data, 'effective') and data.effective is not None:
  410. update_data['effective'] = data.effective
  411. update_data['status'] = (
  412. InstitutionStatusEnum.INSTITUTION_EFFECTIVE.value
  413. if data.effective == "1"
  414. else InstitutionStatusEnum.INSTITUTION_INVALID.value
  415. )
  416. if hasattr(data, 'effective_start_date') and data.effective_start_date:
  417. update_data['effective_start_date'] = data.effective_start_date
  418. if hasattr(data, 'effective_end_date') and data.effective_end_date:
  419. update_data['effective_end_date'] = data.effective_end_date
  420. if update_data:
  421. await crud.update_by_institution_id(institution_id, update_data)
  422. log.info(f"已更新本地制度: institution_id={institution_id}")
  423. # 同步标准规则(modify_standard_detail_info)
  424. std_detail = (raw_data or {}).get("modify_standard_detail_info") or {}
  425. if std_detail:
  426. from app.plugin.module_payment.expense.rule.model import ExpenseRuleModel
  427. from sqlalchemy import delete as sa_delete
  428. # 删除规则
  429. delete_ids = std_detail.get("delete_standard_id_list", [])
  430. if delete_ids:
  431. d_stmt = sa_delete(ExpenseRuleModel).where(
  432. ExpenseRuleModel.rule_id.in_(delete_ids)
  433. )
  434. await auth.db.execute(d_stmt)
  435. # 新增规则
  436. add_list = std_detail.get("add_standard_list", [])
  437. from sqlalchemy import insert as sa_insert
  438. for std in add_list:
  439. ins_data = {
  440. "out_biz_no": std.get("outer_source_id", f"std_{institution_id}"),
  441. "institution_id": institution_id,
  442. "rule_id": std.get("standard_id"),
  443. "standard_name": std.get("standard_name"),
  444. "standard_desc": std.get("standard_desc"),
  445. "expense_type_sub_category": std.get("expense_type_sub_category", "DEFAULT"),
  446. "enterprise_id": raw_data.get("enterprise_id", ""),
  447. }
  448. stmt = sa_insert(ExpenseRuleModel).values(**ins_data)
  449. await auth.db.execute(stmt)
  450. # 修改规则
  451. modify_list = std_detail.get("modify_standard_list", [])
  452. for std in modify_list:
  453. std_id = std.get("standard_id", "").strip('"')
  454. update_std = {}
  455. if std.get("standard_name"):
  456. update_std["standard_name"] = std["standard_name"]
  457. if std.get("standard_desc"):
  458. update_std["standard_desc"] = std["standard_desc"]
  459. if update_std and std_id:
  460. from sqlalchemy import update as sa_update
  461. u_stmt = sa_update(ExpenseRuleModel).where(
  462. ExpenseRuleModel.rule_id == std_id
  463. ).values(**update_std)
  464. await auth.db.execute(u_stmt)
  465. await auth.db.flush()
  466. log.info(f"已同步使用规则: institution_id={institution_id}")
  467. # 同步发放规则(modify_issue_rule_detail_info)
  468. issue_detail = (raw_data or {}).get("modify_issue_rule_detail_info") or {}
  469. if issue_detail:
  470. from app.plugin.module_payment.expense.quota.model import QuotaModel
  471. from sqlalchemy import delete as sa_delete
  472. # 删除发放规则
  473. delete_ids = issue_detail.get("delete_issue_rule_id_list", [])
  474. if delete_ids:
  475. d_stmt = sa_delete(QuotaModel).where(
  476. QuotaModel.quota_id.in_(delete_ids)
  477. )
  478. await auth.db.execute(d_stmt)
  479. # 新增发放规则
  480. add_list = issue_detail.get("add_issue_rule_list", [])
  481. for rule in add_list:
  482. amount = float(rule.get("issue_amount_value", 0))
  483. ins_data = {
  484. "employee_id": "",
  485. "institution_id": institution_id,
  486. "out_biz_no": rule.get("outer_source_id", f"issue_{institution_id}"),
  487. "quota_id": rule.get("issue_rule_id"),
  488. "total_amount": amount,
  489. "available_amount": amount,
  490. "status": "QUOTA_ACTIVE",
  491. "enterprise_id": raw_data.get("enterprise_id", ""),
  492. }
  493. stmt = sa_insert(QuotaModel).values(**ins_data)
  494. await auth.db.execute(stmt)
  495. # 修改发放规则
  496. modify_rule = issue_detail.get("modify_issue_rule_list") or {}
  497. if modify_rule.get("issue_rule_id"):
  498. q_id = modify_rule["issue_rule_id"].strip('"')
  499. update_q = {}
  500. if modify_rule.get("issue_amount_value"):
  501. update_q["total_amount"] = float(modify_rule["issue_amount_value"])
  502. update_q["available_amount"] = float(modify_rule["issue_amount_value"])
  503. if modify_rule.get("issue_rule_name"):
  504. update_q["standard_name"] = modify_rule["issue_rule_name"]
  505. if update_q and q_id:
  506. from sqlalchemy import update as sa_update
  507. u_stmt = sa_update(QuotaModel).where(
  508. QuotaModel.quota_id == q_id
  509. ).values(**update_q)
  510. await auth.db.execute(u_stmt)
  511. await auth.db.flush()
  512. log.info(f"已同步发放规则: institution_id={institution_id}")
  513. except Exception as e:
  514. log.warning(f"本地同步失败(不影响支付宝侧): {e}")
  515. return result
  516. class InstitutionScopeService:
  517. """费控制度成员范围服务层"""
  518. @classmethod
  519. def _execute_alipay(cls, request):
  520. """同步执行支付宝调用"""
  521. client = AlipayClient.get_client()
  522. return client.execute(request)
  523. @classmethod
  524. async def scope_modify_service(
  525. cls,
  526. auth: AuthSchema,
  527. institution_id: str,
  528. data: dict,
  529. ) -> dict:
  530. """
  531. 设置/修改制度成员范围
  532. 调用: alipay.ebpp.invoice.institution.scope.modify
  533. """
  534. try:
  535. from alipay.aop.api.request.AlipayEbppInvoiceInstitutionScopeModifyRequest import (
  536. AlipayEbppInvoiceInstitutionScopeModifyRequest,
  537. )
  538. from alipay.aop.api.domain.AlipayEbppInvoiceInstitutionScopeModifyModel import (
  539. AlipayEbppInvoiceInstitutionScopeModifyModel,
  540. )
  541. from alipay.aop.api.response.AlipayEbppInvoiceInstitutionScopeModifyResponse import (
  542. AlipayEbppInvoiceInstitutionScopeModifyResponse,
  543. )
  544. except ImportError:
  545. raise CustomException(msg="支付宝SDK未正确安装(alipay-ebpp-invoice-institution-scope-modify)")
  546. model = AlipayEbppInvoiceInstitutionScopeModifyModel()
  547. model.institution_id = institution_id
  548. model.enterprise_id = data.get("enterprise_id", "")
  549. model.adapter_type = data.get("adapter_type", "EMPLOYEE_ALL")
  550. if data.get("owner_type"):
  551. model.owner_type = data["owner_type"]
  552. if data.get("add_owner_id_list"):
  553. model.add_owner_id_list = data["add_owner_id_list"]
  554. if data.get("delete_owner_id_list"):
  555. model.delete_owner_id_list = data["delete_owner_id_list"]
  556. request = AlipayEbppInvoiceInstitutionScopeModifyRequest()
  557. request.biz_model = model
  558. response = await asyncio.to_thread(cls._execute_alipay, request)
  559. if not response:
  560. raise CustomException(msg="设置制度成员失败: 无响应")
  561. result = AlipayEbppInvoiceInstitutionScopeModifyResponse()
  562. result.parse_response_content(response)
  563. if not result.is_success():
  564. log.error(f"设置制度成员失败: {result.code} - {result.msg}")
  565. raise CustomException(msg=f"设置制度成员失败: {result.msg}")
  566. return {"result": True}
  567. @classmethod
  568. async def scopepageinfo_query_service(
  569. cls,
  570. auth: AuthSchema,
  571. institution_id: str,
  572. enterprise_id: str | None = None,
  573. page_num: int = 1,
  574. page_size: int = 20,
  575. owner_type: str | None = None,
  576. ) -> dict:
  577. """
  578. 查询制度成员范围
  579. 调用: alipay.ebpp.invoice.institution.scopepageinfo.query
  580. """
  581. try:
  582. from alipay.aop.api.request.AlipayEbppInvoiceInstitutionScopepageinfoQueryRequest import (
  583. AlipayEbppInvoiceInstitutionScopepageinfoQueryRequest,
  584. )
  585. from alipay.aop.api.domain.AlipayEbppInvoiceInstitutionScopepageinfoQueryModel import (
  586. AlipayEbppInvoiceInstitutionScopepageinfoQueryModel,
  587. )
  588. from alipay.aop.api.response.AlipayEbppInvoiceInstitutionScopepageinfoQueryResponse import (
  589. AlipayEbppInvoiceInstitutionScopepageinfoQueryResponse,
  590. )
  591. except ImportError:
  592. raise CustomException(msg="支付宝SDK未正确安装(alipay-ebpp-invoice-institution-scopepageinfo-query)")
  593. model = AlipayEbppInvoiceInstitutionScopepageinfoQueryModel()
  594. model.institution_id = institution_id
  595. model.page_num = page_num
  596. model.page_size = page_size
  597. if enterprise_id:
  598. model.enterprise_id = enterprise_id
  599. if owner_type:
  600. model.owner_type = owner_type
  601. request = AlipayEbppInvoiceInstitutionScopepageinfoQueryRequest()
  602. request.biz_model = model
  603. response = await asyncio.to_thread(cls._execute_alipay, request)
  604. if not response:
  605. raise CustomException(msg="查询制度成员失败: 无响应")
  606. result = AlipayEbppInvoiceInstitutionScopepageinfoQueryResponse()
  607. result.parse_response_content(response)
  608. if not result.is_success():
  609. log.error(f"查询制度成员失败: {result.code} - {result.msg}")
  610. raise CustomException(msg=f"查询制度成员失败: {result.msg}")
  611. return {
  612. "page_num": getattr(result, 'page_num', page_num) or page_num,
  613. "page_size": getattr(result, 'page_size', page_size) or page_size,
  614. "total_page_count": getattr(result, 'total_page_count', 0) or 0,
  615. "adapter_type": getattr(result, 'adapter_type', None),
  616. "owner_id_list": getattr(result, 'owner_id_list', []) or [],
  617. "owner_open_id_list": getattr(result, 'onwer_open_id_list', []) or [],
  618. "scope_info_list": [
  619. {
  620. "adapter_type": getattr(result, 'adapter_type', None),
  621. "owner_id_list": getattr(result, 'owner_id_list', []) or [],
  622. "owner_open_id_list": getattr(result, 'onwer_open_id_list', []) or [],
  623. }
  624. ] if getattr(result, 'adapter_type', None) else [],
  625. }
  626. class IssueruleService:
  627. """自动额度发放规则服务层"""
  628. ISSUE_TYPE_MAP = {
  629. "daily": "ISSUE_DAY",
  630. "weekly": "ISSUE_WEEK",
  631. "monthly": "ISSUE_MONTH",
  632. "quarterly": "ISSUE_QUARTER",
  633. "yearly": "ISSUE_YEAR",
  634. }
  635. @classmethod
  636. def _execute_alipay(cls, request):
  637. client = AlipayClient.get_client()
  638. return client.execute(request)
  639. @classmethod
  640. async def create_issuerule_service(
  641. cls,
  642. auth: AuthSchema,
  643. institution_id: str,
  644. enterprise_id: str,
  645. quota_type: str,
  646. issue_type: str,
  647. issue_amount_value: str,
  648. outer_source_id: str | None = None,
  649. issue_rule_name: str | None = None,
  650. effective_period: str | None = None,
  651. invalid_mode: int | None = None,
  652. share_mode: int | None = None,
  653. ) -> dict:
  654. """
  655. 创建自动额度发放规则
  656. 调用: alipay.ebpp.invoice.issuerule.create
  657. """
  658. try:
  659. from alipay.aop.api.request.AlipayEbppInvoiceIssueruleCreateRequest import (
  660. AlipayEbppInvoiceIssueruleCreateRequest,
  661. )
  662. from alipay.aop.api.domain.AlipayEbppInvoiceIssueruleCreateModel import (
  663. AlipayEbppInvoiceIssueruleCreateModel,
  664. )
  665. from alipay.aop.api.response.AlipayEbppInvoiceIssueruleCreateResponse import (
  666. AlipayEbppInvoiceIssueruleCreateResponse,
  667. )
  668. except ImportError:
  669. raise CustomException(msg="支付宝SDK未正确安装(alipay-ebpp-invoice-issuerule-create)")
  670. # 参数约束校验
  671. if quota_type == "CAP" and invalid_mode is not None and invalid_mode != 1:
  672. raise CustomException(msg="余额类型(CP)的发放规则必须为可累计(invalid_mode=1)")
  673. if quota_type == "COUNT" and share_mode is not None and share_mode != 0:
  674. raise CustomException(msg="次卡类型(COUNT)的发放规则不可转赠(share_mode=0)")
  675. model = AlipayEbppInvoiceIssueruleCreateModel()
  676. model.target_type = "INSTITUTION"
  677. model.target_id = institution_id
  678. model.quota_type = quota_type
  679. model.issue_type = issue_type
  680. model.issue_amount_value = issue_amount_value
  681. model.enterprise_id = enterprise_id
  682. if outer_source_id:
  683. model.outer_source_id = outer_source_id
  684. if issue_rule_name:
  685. model.issue_rule_name = issue_rule_name
  686. if effective_period:
  687. model.effective_period = effective_period
  688. if invalid_mode is not None:
  689. model.invalid_mode = invalid_mode
  690. if share_mode is not None:
  691. model.share_mode = share_mode
  692. request = AlipayEbppInvoiceIssueruleCreateRequest()
  693. request.biz_model = model
  694. response = await asyncio.to_thread(cls._execute_alipay, request)
  695. if not response:
  696. raise CustomException(msg="创建发放规则失败: 无响应")
  697. result = AlipayEbppInvoiceIssueruleCreateResponse()
  698. result.parse_response_content(response)
  699. if not result.is_success():
  700. log.error(f"创建发放规则失败: {result.code} - {result.msg}")
  701. raise CustomException(msg=f"创建发放规则失败: {result.msg}")
  702. return {
  703. "issue_rule_id": getattr(result, 'issue_rule_id', None),
  704. }
  705. @classmethod
  706. async def modify_issuerule_service(
  707. cls,
  708. auth: AuthSchema,
  709. institution_id: str,
  710. issue_rule_id: str,
  711. enterprise_id: str,
  712. quota_type: str | None = None,
  713. issue_type: str | None = None,
  714. issue_amount_value: str | None = None,
  715. issue_rule_name: str | None = None,
  716. effective: str | None = None,
  717. effective_period: str | None = None,
  718. invalid_mode: int | None = None,
  719. share_mode: int | None = None,
  720. ) -> dict:
  721. """
  722. 编辑自动额度发放规则
  723. 调用: alipay.ebpp.invoice.issuerule.modify
  724. """
  725. try:
  726. from alipay.aop.api.request.AlipayEbppInvoiceIssueruleModifyRequest import (
  727. AlipayEbppInvoiceIssueruleModifyRequest,
  728. )
  729. from alipay.aop.api.domain.AlipayEbppInvoiceIssueruleModifyModel import (
  730. AlipayEbppInvoiceIssueruleModifyModel,
  731. )
  732. from alipay.aop.api.response.AlipayEbppInvoiceIssueruleModifyResponse import (
  733. AlipayEbppInvoiceIssueruleModifyResponse,
  734. )
  735. except ImportError:
  736. raise CustomException(msg="支付宝SDK未正确安装(alipay-ebpp-invoice-issuerule-modify)")
  737. model = AlipayEbppInvoiceIssueruleModifyModel()
  738. model.target_type = "INSTITUTION"
  739. model.target_id = institution_id
  740. model.issue_rule_id = issue_rule_id
  741. model.action = "MODIFY_BASIC_INFO"
  742. model.enterprise_id = enterprise_id
  743. if issue_rule_name:
  744. model.issue_rule_name = issue_rule_name
  745. if quota_type:
  746. model.quota_type = quota_type
  747. if issue_type:
  748. model.issue_type = issue_type
  749. if issue_amount_value:
  750. model.issue_amount_value = issue_amount_value
  751. if effective is not None:
  752. model.effective = effective
  753. if effective_period:
  754. model.effective_period = effective_period
  755. if invalid_mode is not None:
  756. model.invalid_mode = invalid_mode
  757. if share_mode is not None:
  758. model.share_mode = share_mode
  759. request = AlipayEbppInvoiceIssueruleModifyRequest()
  760. request.biz_model = model
  761. response = await asyncio.to_thread(cls._execute_alipay, request)
  762. if not response:
  763. raise CustomException(msg="编辑发放规则失败: 无响应")
  764. result = AlipayEbppInvoiceIssueruleModifyResponse()
  765. result.parse_response_content(response)
  766. if not result.is_success():
  767. log.error(f"编辑发放规则失败: {result.code} - {result.msg}")
  768. raise CustomException(msg=f"编辑发放规则失败: {result.msg}")
  769. return {"result": True}
  770. @classmethod
  771. async def delete_issuerule_service(
  772. cls,
  773. auth: AuthSchema,
  774. institution_id: str,
  775. issue_rule_id_list: list[str],
  776. enterprise_id: str,
  777. ) -> dict:
  778. """
  779. 删除自动额度发放规则
  780. 调用: alipay.ebpp.invoice.issuerule.delete
  781. """
  782. try:
  783. from alipay.aop.api.request.AlipayEbppInvoiceIssueruleDeleteRequest import (
  784. AlipayEbppInvoiceIssueruleDeleteRequest,
  785. )
  786. from alipay.aop.api.domain.AlipayEbppInvoiceIssueruleDeleteModel import (
  787. AlipayEbppInvoiceIssueruleDeleteModel,
  788. )
  789. from alipay.aop.api.response.AlipayEbppInvoiceIssueruleDeleteResponse import (
  790. AlipayEbppInvoiceIssueruleDeleteResponse,
  791. )
  792. except ImportError:
  793. raise CustomException(msg="支付宝SDK未正确安装(alipay-ebpp-invoice-issuerule-delete)")
  794. model = AlipayEbppInvoiceIssueruleDeleteModel()
  795. model.target_type = "INSTITUTION"
  796. model.target_id = institution_id
  797. model.issue_rule_id_list = issue_rule_id_list
  798. model.enterprise_id = enterprise_id
  799. request = AlipayEbppInvoiceIssueruleDeleteRequest()
  800. request.biz_model = model
  801. response = await asyncio.to_thread(cls._execute_alipay, request)
  802. if not response:
  803. raise CustomException(msg="删除发放规则失败: 无响应")
  804. result = AlipayEbppInvoiceIssueruleDeleteResponse()
  805. result.parse_response_content(response)
  806. if not result.is_success():
  807. log.error(f"删除发放规则失败: {result.code} - {result.msg}")
  808. raise CustomException(msg=f"删除发放规则失败: {result.msg}")
  809. return {"result": True}