pilot_service.py 86 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388
  1. """中试服务管理 API(细胞产品类型/规格/价格体系/项目价格、渠道信息、体检机构)"""
  2. from typing import Any, List, Optional
  3. from fastapi import APIRouter, Depends, Query
  4. from pydantic import BaseModel, ConfigDict, Field
  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
  8. from app.core.response import error_response, success_response
  9. from app.crud import pilot_service as ps_svc
  10. from app.models.models import SysUser
  11. router = APIRouter(prefix="/web/admin", tags=["中试服务管理"])
  12. def _get_tenant_no(db: Session, user: dict) -> str:
  13. user_id = user.get("user_id")
  14. if not user_id:
  15. raise PermissionError("用户身份信息缺失,无法确定租户")
  16. sys_user = db.query(SysUser).filter(SysUser.id == user_id).first()
  17. if not sys_user or not sys_user.tenant_no:
  18. raise PermissionError("用户租户信息缺失")
  19. return sys_user.tenant_no
  20. # ---------------------------------------------------------------------------
  21. # 1. 细胞产品类型
  22. # ---------------------------------------------------------------------------
  23. class CellProductTypeCreateBody(BaseModel):
  24. model_config = ConfigDict(populate_by_name=True)
  25. product_type_code: str = Field(..., alias="productTypeCode")
  26. product_type_name: str = Field(..., alias="productTypeName")
  27. order_num: Optional[int] = Field(0, alias="orderNum")
  28. remark: Optional[str] = None
  29. class CellProductTypeUpdateBody(BaseModel):
  30. model_config = ConfigDict(populate_by_name=True)
  31. product_type_code: Optional[str] = Field(None, alias="productTypeCode")
  32. product_type_name: Optional[str] = Field(None, alias="productTypeName")
  33. order_num: Optional[int] = Field(None, alias="orderNum")
  34. remark: Optional[str] = None
  35. @router.get("/cell-product-types")
  36. async def list_cell_product_types(
  37. page: int = Query(1, ge=1),
  38. pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
  39. keyword: Optional[str] = None,
  40. user: dict = Depends(require_admin_or_super_admin),
  41. db: Session = Depends(get_db),
  42. ):
  43. tenant_no = _get_tenant_no(db, user)
  44. items, total = ps_svc.list_cell_product_types(
  45. db, page=page, page_size=pageSize, keyword=keyword, tenant_no=tenant_no, user_info=user
  46. )
  47. tp = ps_svc.total_pages(total, pageSize)
  48. return success_response(
  49. {"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp}
  50. )
  51. @router.post("/cell-product-types")
  52. async def create_cell_product_type(
  53. body: CellProductTypeCreateBody,
  54. user: dict = Depends(require_admin_or_super_admin),
  55. db: Session = Depends(get_db),
  56. ):
  57. try:
  58. tenant_no = _get_tenant_no(db, user)
  59. obj = ps_svc.create_cell_product_type(
  60. db,
  61. product_type_code=body.product_type_code,
  62. product_type_name=body.product_type_name,
  63. tenant_no=tenant_no,
  64. order_num=body.order_num,
  65. remark=body.remark,
  66. user_id=user.get("user_id"),
  67. )
  68. return success_response(ps_svc._row_to_dict_cell_product_type(obj), message="创建成功")
  69. except ValueError as e:
  70. return error_response(400, str(e))
  71. @router.put("/cell-product-types/{row_id}")
  72. async def update_cell_product_type(
  73. row_id: str,
  74. body: CellProductTypeUpdateBody,
  75. user: dict = Depends(require_admin_or_super_admin),
  76. db: Session = Depends(get_db),
  77. ):
  78. try:
  79. tenant_no = _get_tenant_no(db, user)
  80. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  81. obj = ps_svc.update_cell_product_type(
  82. db,
  83. row_id,
  84. product_type_code=payload.get("product_type_code"),
  85. product_type_name=payload.get("product_type_name"),
  86. order_num=payload.get("order_num"),
  87. remark=payload.get("remark"),
  88. user_id=user.get("user_id"),
  89. tenant_no=tenant_no,
  90. )
  91. return success_response(ps_svc._row_to_dict_cell_product_type(obj), message="更新成功")
  92. except ValueError as e:
  93. return error_response(400, str(e))
  94. @router.delete("/cell-product-types/{row_id}")
  95. async def delete_cell_product_type(
  96. row_id: str,
  97. user: dict = Depends(require_admin_or_super_admin),
  98. db: Session = Depends(get_db),
  99. ):
  100. try:
  101. tenant_no = _get_tenant_no(db, user)
  102. ps_svc.soft_delete_cell_product_type(db, row_id, tenant_no=tenant_no)
  103. return success_response(None, message="删除成功")
  104. except ValueError as e:
  105. return error_response(400, str(e))
  106. # ---------------------------------------------------------------------------
  107. # 2. 细胞产品规格
  108. # ---------------------------------------------------------------------------
  109. class CellProductSpecCreateBody(BaseModel):
  110. model_config = ConfigDict(populate_by_name=True)
  111. spec_code: str = Field(..., alias="specCode")
  112. spec_name: str = Field(..., alias="specName")
  113. order_num: Optional[int] = Field(0, alias="orderNum")
  114. remark: Optional[str] = None
  115. class CellProductSpecUpdateBody(BaseModel):
  116. model_config = ConfigDict(populate_by_name=True)
  117. spec_code: Optional[str] = Field(None, alias="specCode")
  118. spec_name: Optional[str] = Field(None, alias="specName")
  119. order_num: Optional[int] = Field(None, alias="orderNum")
  120. remark: Optional[str] = None
  121. @router.get("/cell-product-specs")
  122. async def list_cell_product_specs(
  123. page: int = Query(1, ge=1),
  124. pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
  125. keyword: Optional[str] = None,
  126. user: dict = Depends(require_admin_or_super_admin),
  127. db: Session = Depends(get_db),
  128. ):
  129. tenant_no = _get_tenant_no(db, user)
  130. items, total = ps_svc.list_cell_product_specs(
  131. db, page=page, page_size=pageSize, keyword=keyword, tenant_no=tenant_no, user_info=user
  132. )
  133. tp = ps_svc.total_pages(total, pageSize)
  134. return success_response(
  135. {"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp}
  136. )
  137. @router.post("/cell-product-specs")
  138. async def create_cell_product_spec(
  139. body: CellProductSpecCreateBody,
  140. user: dict = Depends(require_admin_or_super_admin),
  141. db: Session = Depends(get_db),
  142. ):
  143. try:
  144. tenant_no = _get_tenant_no(db, user)
  145. obj = ps_svc.create_cell_product_spec(
  146. db,
  147. spec_code=body.spec_code,
  148. spec_name=body.spec_name,
  149. tenant_no=tenant_no,
  150. order_num=body.order_num,
  151. remark=body.remark,
  152. user_id=user.get("user_id"),
  153. )
  154. return success_response(ps_svc._row_to_dict_cell_product_spec(obj), message="创建成功")
  155. except ValueError as e:
  156. return error_response(400, str(e))
  157. @router.put("/cell-product-specs/{row_id}")
  158. async def update_cell_product_spec(
  159. row_id: str,
  160. body: CellProductSpecUpdateBody,
  161. user: dict = Depends(require_admin_or_super_admin),
  162. db: Session = Depends(get_db),
  163. ):
  164. try:
  165. tenant_no = _get_tenant_no(db, user)
  166. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  167. obj = ps_svc.update_cell_product_spec(
  168. db,
  169. row_id,
  170. spec_code=payload.get("spec_code"),
  171. spec_name=payload.get("spec_name"),
  172. order_num=payload.get("order_num"),
  173. remark=payload.get("remark"),
  174. user_id=user.get("user_id"),
  175. tenant_no=tenant_no,
  176. )
  177. return success_response(ps_svc._row_to_dict_cell_product_spec(obj), message="更新成功")
  178. except ValueError as e:
  179. return error_response(400, str(e))
  180. @router.delete("/cell-product-specs/{row_id}")
  181. async def delete_cell_product_spec(
  182. row_id: str,
  183. user: dict = Depends(require_admin_or_super_admin),
  184. db: Session = Depends(get_db),
  185. ):
  186. try:
  187. tenant_no = _get_tenant_no(db, user)
  188. ps_svc.soft_delete_cell_product_spec(db, row_id, tenant_no=tenant_no)
  189. return success_response(None, message="删除成功")
  190. except ValueError as e:
  191. return error_response(400, str(e))
  192. # ---------------------------------------------------------------------------
  193. # 3. 细胞产品价格
  194. # ---------------------------------------------------------------------------
  195. class CellProductPriceCreateBody(BaseModel):
  196. model_config = ConfigDict(populate_by_name=True)
  197. project_name: str = Field(..., alias="projectName")
  198. project_code: str = Field(..., alias="projectCode")
  199. cell_type_code: Optional[str] = Field(None, alias="cellTypeCode")
  200. cell_type_name: Optional[str] = Field(None, alias="cellTypeName")
  201. spec_text: Optional[str] = Field(None, alias="specText")
  202. spec_id: Optional[str] = Field(None, alias="specId")
  203. cell_product_type_id: Optional[str] = Field(None, alias="cellProductTypeId")
  204. unit_price: Optional[float] = Field(None, alias="unitPrice")
  205. order_num: Optional[int] = Field(0, alias="orderNum")
  206. remark: Optional[str] = None
  207. class CellProductPriceUpdateBody(BaseModel):
  208. model_config = ConfigDict(populate_by_name=True)
  209. project_name: Optional[str] = Field(None, alias="projectName")
  210. project_code: Optional[str] = Field(None, alias="projectCode")
  211. cell_type_code: Optional[str] = Field(None, alias="cellTypeCode")
  212. cell_type_name: Optional[str] = Field(None, alias="cellTypeName")
  213. spec_text: Optional[str] = Field(None, alias="specText")
  214. spec_id: Optional[str] = Field(None, alias="specId")
  215. cell_product_type_id: Optional[str] = Field(None, alias="cellProductTypeId")
  216. unit_price: Optional[float] = Field(None, alias="unitPrice")
  217. order_num: Optional[int] = Field(None, alias="orderNum")
  218. remark: Optional[str] = None
  219. @router.get("/cell-product-prices")
  220. async def list_cell_product_prices(
  221. page: int = Query(1, ge=1),
  222. pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
  223. keyword: Optional[str] = None,
  224. cell_product_type_id: Optional[str] = Query(None, alias="cellProductTypeId"),
  225. user: dict = Depends(require_admin_or_super_admin),
  226. db: Session = Depends(get_db),
  227. ):
  228. tenant_no = _get_tenant_no(db, user)
  229. items, total = ps_svc.list_cell_product_prices(
  230. db,
  231. page=page,
  232. page_size=pageSize,
  233. keyword=keyword,
  234. tenant_no=tenant_no,
  235. cell_product_type_id=cell_product_type_id,
  236. user_info=user,
  237. )
  238. tp = ps_svc.total_pages(total, pageSize)
  239. return success_response(
  240. {"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp}
  241. )
  242. @router.post("/cell-product-prices")
  243. async def create_cell_product_price(
  244. body: CellProductPriceCreateBody,
  245. user: dict = Depends(require_admin_or_super_admin),
  246. db: Session = Depends(get_db),
  247. ):
  248. try:
  249. tenant_no = _get_tenant_no(db, user)
  250. obj = ps_svc.create_cell_product_price(
  251. db,
  252. project_name=body.project_name,
  253. project_code=body.project_code,
  254. cell_type_code=body.cell_type_code or "",
  255. cell_type_name=body.cell_type_name or "",
  256. spec_text=body.spec_text or "",
  257. spec_id=body.spec_id or "",
  258. cell_product_type_id=body.cell_product_type_id or "",
  259. unit_price=body.unit_price,
  260. tenant_no=tenant_no,
  261. order_num=body.order_num,
  262. remark=body.remark,
  263. user_id=user.get("user_id"),
  264. )
  265. return success_response(ps_svc._row_to_dict_cell_product_price(obj), message="创建成功")
  266. except ValueError as e:
  267. return error_response(400, str(e))
  268. @router.put("/cell-product-prices/{row_id}")
  269. async def update_cell_product_price(
  270. row_id: str,
  271. body: CellProductPriceUpdateBody,
  272. user: dict = Depends(require_admin_or_super_admin),
  273. db: Session = Depends(get_db),
  274. ):
  275. try:
  276. tenant_no = _get_tenant_no(db, user)
  277. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  278. obj = ps_svc.update_cell_product_price(
  279. db,
  280. row_id,
  281. project_name=payload.get("project_name"),
  282. project_code=payload.get("project_code"),
  283. cell_type_code=payload.get("cell_type_code"),
  284. cell_type_name=payload.get("cell_type_name"),
  285. spec_text=payload.get("spec_text"),
  286. spec_id=payload.get("spec_id"),
  287. cell_product_type_id=payload.get("cell_product_type_id"),
  288. unit_price=payload.get("unit_price"),
  289. order_num=payload.get("order_num"),
  290. remark=payload.get("remark"),
  291. user_id=user.get("user_id"),
  292. tenant_no=tenant_no,
  293. )
  294. return success_response(ps_svc._row_to_dict_cell_product_price(obj), message="更新成功")
  295. except ValueError as e:
  296. return error_response(400, str(e))
  297. @router.delete("/cell-product-prices/{row_id}")
  298. async def delete_cell_product_price(
  299. row_id: str,
  300. user: dict = Depends(require_admin_or_super_admin),
  301. db: Session = Depends(get_db),
  302. ):
  303. try:
  304. tenant_no = _get_tenant_no(db, user)
  305. ps_svc.soft_delete_cell_product_price(db, row_id, tenant_no=tenant_no)
  306. return success_response(None, message="删除成功")
  307. except ValueError as e:
  308. return error_response(400, str(e))
  309. # ---------------------------------------------------------------------------
  310. # 4. 项目价格体系(主表 + 明细子表)
  311. # ---------------------------------------------------------------------------
  312. class ProjectSystemCreateBody(BaseModel):
  313. model_config = ConfigDict(populate_by_name=True)
  314. system_name: str = Field(..., alias="systemName")
  315. system_code: str = Field(..., alias="systemCode")
  316. status: Optional[str] = Field("1", alias="status")
  317. order_num: Optional[int] = Field(0, alias="orderNum")
  318. remark: Optional[str] = None
  319. class ProjectSystemUpdateBody(BaseModel):
  320. model_config = ConfigDict(populate_by_name=True)
  321. system_name: Optional[str] = Field(None, alias="systemName")
  322. system_code: Optional[str] = Field(None, alias="systemCode")
  323. status: Optional[str] = Field(None, alias="status")
  324. order_num: Optional[int] = Field(None, alias="orderNum")
  325. remark: Optional[str] = None
  326. @router.get("/project-price-systems")
  327. async def list_project_systems(
  328. page: int = Query(1, ge=1),
  329. pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
  330. keyword: Optional[str] = None,
  331. user: dict = Depends(require_admin_or_super_admin),
  332. db: Session = Depends(get_db),
  333. ):
  334. tenant_no = _get_tenant_no(db, user)
  335. items, total = ps_svc.list_project_systems(
  336. db, page=page, page_size=pageSize, keyword=keyword, tenant_no=tenant_no, user_info=user
  337. )
  338. tp = ps_svc.total_pages(total, pageSize)
  339. return success_response(
  340. {"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp}
  341. )
  342. @router.post("/project-price-systems")
  343. async def create_project_system(
  344. body: ProjectSystemCreateBody,
  345. user: dict = Depends(require_admin_or_super_admin),
  346. db: Session = Depends(get_db),
  347. ):
  348. try:
  349. tenant_no = _get_tenant_no(db, user)
  350. obj = ps_svc.create_project_system(
  351. db,
  352. system_name=body.system_name,
  353. system_code=body.system_code,
  354. status=body.status,
  355. tenant_no=tenant_no,
  356. order_num=body.order_num,
  357. remark=body.remark,
  358. user_id=user.get("user_id"),
  359. )
  360. return success_response(ps_svc._row_to_dict_project_system(obj), message="创建成功")
  361. except ValueError as e:
  362. return error_response(400, str(e))
  363. @router.put("/project-price-systems/{row_id}")
  364. async def update_project_system(
  365. row_id: str,
  366. body: ProjectSystemUpdateBody,
  367. user: dict = Depends(require_admin_or_super_admin),
  368. db: Session = Depends(get_db),
  369. ):
  370. try:
  371. tenant_no = _get_tenant_no(db, user)
  372. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  373. obj = ps_svc.update_project_system(
  374. db,
  375. row_id,
  376. system_name=payload.get("system_name"),
  377. system_code=payload.get("system_code"),
  378. status=payload.get("status"),
  379. order_num=payload.get("order_num"),
  380. remark=payload.get("remark"),
  381. user_id=user.get("user_id"),
  382. tenant_no=tenant_no,
  383. )
  384. return success_response(ps_svc._row_to_dict_project_system(obj), message="更新成功")
  385. except ValueError as e:
  386. return error_response(400, str(e))
  387. @router.delete("/project-price-systems/{row_id}")
  388. async def delete_project_system(
  389. row_id: str,
  390. user: dict = Depends(require_admin_or_super_admin),
  391. db: Session = Depends(get_db),
  392. ):
  393. try:
  394. tenant_no = _get_tenant_no(db, user)
  395. ps_svc.soft_delete_project_system(db, row_id, tenant_no=tenant_no)
  396. return success_response(None, message="删除成功")
  397. except ValueError as e:
  398. return error_response(400, str(e))
  399. # --- 项目价格体系明细 ---
  400. class ProjectSystemItemCreateBody(BaseModel):
  401. model_config = ConfigDict(populate_by_name=True)
  402. source_price_id: Optional[str] = Field(None, alias="sourcePriceId")
  403. project_name: str = Field(..., alias="projectName")
  404. project_code: str = Field(..., alias="projectCode")
  405. cell_type_code: Optional[str] = Field(None, alias="cellTypeCode")
  406. cell_type_name: Optional[str] = Field(None, alias="cellTypeName")
  407. spec_text: Optional[str] = Field(None, alias="specText")
  408. spec_id: Optional[str] = Field(None, alias="specId")
  409. cell_product_type_id: Optional[str] = Field(None, alias="cellProductTypeId")
  410. unit_price: Optional[float] = Field(None, alias="unitPrice")
  411. order_num: Optional[int] = Field(0, alias="orderNum")
  412. remark: Optional[str] = None
  413. class ProjectSystemItemUpdateBody(BaseModel):
  414. model_config = ConfigDict(populate_by_name=True)
  415. source_price_id: Optional[str] = Field(None, alias="sourcePriceId")
  416. project_name: Optional[str] = Field(None, alias="projectName")
  417. project_code: Optional[str] = Field(None, alias="projectCode")
  418. cell_type_code: Optional[str] = Field(None, alias="cellTypeCode")
  419. cell_type_name: Optional[str] = Field(None, alias="cellTypeName")
  420. spec_text: Optional[str] = Field(None, alias="specText")
  421. spec_id: Optional[str] = Field(None, alias="specId")
  422. cell_product_type_id: Optional[str] = Field(None, alias="cellProductTypeId")
  423. unit_price: Optional[float] = Field(None, alias="unitPrice")
  424. order_num: Optional[int] = Field(None, alias="orderNum")
  425. remark: Optional[str] = None
  426. @router.get("/project-price-systems/{system_id}/items")
  427. async def list_project_system_items(
  428. system_id: str,
  429. user: dict = Depends(require_admin_or_super_admin),
  430. db: Session = Depends(get_db),
  431. ):
  432. try:
  433. tenant_no = _get_tenant_no(db, user)
  434. items = ps_svc.list_project_system_items(db, system_id, tenant_no=tenant_no, user_info=user)
  435. return success_response(items)
  436. except ValueError as e:
  437. return error_response(400, str(e))
  438. @router.post("/project-price-systems/{system_id}/items")
  439. async def create_project_system_item(
  440. system_id: str,
  441. body: ProjectSystemItemCreateBody,
  442. user: dict = Depends(require_admin_or_super_admin),
  443. db: Session = Depends(get_db),
  444. ):
  445. try:
  446. tenant_no = _get_tenant_no(db, user)
  447. obj = ps_svc.create_project_system_item(
  448. db,
  449. project_system_id=system_id,
  450. source_price_id=body.source_price_id or "",
  451. project_name=body.project_name,
  452. project_code=body.project_code,
  453. cell_type_code=body.cell_type_code or "",
  454. cell_type_name=body.cell_type_name or "",
  455. spec_text=body.spec_text or "",
  456. spec_id=body.spec_id or "",
  457. cell_product_type_id=body.cell_product_type_id or "",
  458. unit_price=body.unit_price,
  459. tenant_no=tenant_no,
  460. order_num=body.order_num,
  461. remark=body.remark,
  462. user_id=user.get("user_id"),
  463. )
  464. return success_response(ps_svc._row_to_dict_project_system_item(obj), message="创建成功")
  465. except ValueError as e:
  466. return error_response(400, str(e))
  467. @router.put("/project-system-items/{item_id}")
  468. async def update_project_system_item(
  469. item_id: str,
  470. body: ProjectSystemItemUpdateBody,
  471. user: dict = Depends(require_admin_or_super_admin),
  472. db: Session = Depends(get_db),
  473. ):
  474. try:
  475. tenant_no = _get_tenant_no(db, user)
  476. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  477. obj = ps_svc.update_project_system_item(
  478. db,
  479. item_id,
  480. source_price_id=payload.get("source_price_id"),
  481. project_name=payload.get("project_name"),
  482. project_code=payload.get("project_code"),
  483. cell_type_code=payload.get("cell_type_code"),
  484. cell_type_name=payload.get("cell_type_name"),
  485. spec_text=payload.get("spec_text"),
  486. spec_id=payload.get("spec_id"),
  487. cell_product_type_id=payload.get("cell_product_type_id"),
  488. unit_price=payload.get("unit_price"),
  489. order_num=payload.get("order_num"),
  490. remark=payload.get("remark"),
  491. user_id=user.get("user_id"),
  492. tenant_no=tenant_no,
  493. )
  494. return success_response(ps_svc._row_to_dict_project_system_item(obj), message="更新成功")
  495. except ValueError as e:
  496. return error_response(400, str(e))
  497. @router.delete("/project-system-items/{item_id}")
  498. async def delete_project_system_item(
  499. item_id: str,
  500. user: dict = Depends(require_admin_or_super_admin),
  501. db: Session = Depends(get_db),
  502. ):
  503. try:
  504. tenant_no = _get_tenant_no(db, user)
  505. ps_svc.soft_delete_project_system_item(db, item_id, tenant_no=tenant_no)
  506. return success_response(None, message="删除成功")
  507. except ValueError as e:
  508. return error_response(400, str(e))
  509. # ---------------------------------------------------------------------------
  510. # 5. 渠道信息(主表 + 开票/邮寄地址/协议/协议产品价格子表)
  511. # ---------------------------------------------------------------------------
  512. class ChannelCreateBody(BaseModel):
  513. model_config = ConfigDict(populate_by_name=True)
  514. channel_name: str = Field(..., alias="channelName")
  515. credit_code: Optional[str] = Field(None, alias="creditCode")
  516. channel_type: Optional[str] = Field(None, alias="channelType")
  517. contact_name: Optional[str] = Field(None, alias="contactName")
  518. contact_phone: Optional[str] = Field(None, alias="contactPhone")
  519. contact_email: Optional[str] = Field(None, alias="contactEmail")
  520. protocol_attachments: Optional[str] = Field(None, alias="protocolAttachments")
  521. order_num: Optional[int] = Field(0, alias="orderNum")
  522. remark: Optional[str] = None
  523. class ChannelUpdateBody(BaseModel):
  524. model_config = ConfigDict(populate_by_name=True)
  525. channel_name: Optional[str] = Field(None, alias="channelName")
  526. credit_code: Optional[str] = Field(None, alias="creditCode")
  527. channel_type: Optional[str] = Field(None, alias="channelType")
  528. contact_name: Optional[str] = Field(None, alias="contactName")
  529. contact_phone: Optional[str] = Field(None, alias="contactPhone")
  530. contact_email: Optional[str] = Field(None, alias="contactEmail")
  531. protocol_attachments: Optional[str] = Field(None, alias="protocolAttachments")
  532. order_num: Optional[int] = Field(None, alias="orderNum")
  533. remark: Optional[str] = None
  534. @router.get("/channels")
  535. async def list_channels(
  536. page: int = Query(1, ge=1),
  537. pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
  538. keyword: Optional[str] = None,
  539. user: dict = Depends(require_admin_or_super_admin),
  540. db: Session = Depends(get_db),
  541. ):
  542. tenant_no = _get_tenant_no(db, user)
  543. items, total = ps_svc.list_channels(
  544. db, page=page, page_size=pageSize, keyword=keyword, tenant_no=tenant_no, user_info=user
  545. )
  546. tp = ps_svc.total_pages(total, pageSize)
  547. return success_response(
  548. {"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp}
  549. )
  550. @router.post("/channels")
  551. async def create_channel(
  552. body: ChannelCreateBody,
  553. user: dict = Depends(require_admin_or_super_admin),
  554. db: Session = Depends(get_db),
  555. ):
  556. try:
  557. tenant_no = _get_tenant_no(db, user)
  558. obj = ps_svc.create_channel(
  559. db,
  560. channel_name=body.channel_name,
  561. credit_code=body.credit_code,
  562. channel_type=body.channel_type,
  563. contact_name=body.contact_name,
  564. contact_phone=body.contact_phone,
  565. contact_email=body.contact_email,
  566. protocol_attachments=body.protocol_attachments,
  567. tenant_no=tenant_no,
  568. order_num=body.order_num,
  569. remark=body.remark,
  570. user_id=user.get("user_id"),
  571. )
  572. return success_response(
  573. ps_svc._row_to_dict_channel(obj, db, tenant_no),
  574. message="创建成功",
  575. )
  576. except ValueError as e:
  577. return error_response(400, str(e))
  578. @router.put("/channels/{row_id}")
  579. async def update_channel(
  580. row_id: str,
  581. body: ChannelUpdateBody,
  582. user: dict = Depends(require_admin_or_super_admin),
  583. db: Session = Depends(get_db),
  584. ):
  585. try:
  586. tenant_no = _get_tenant_no(db, user)
  587. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  588. obj = ps_svc.update_channel(
  589. db,
  590. row_id,
  591. channel_name=payload.get("channel_name"),
  592. credit_code=payload.get("credit_code"),
  593. channel_type=payload.get("channel_type"),
  594. contact_name=payload.get("contact_name"),
  595. contact_phone=payload.get("contact_phone"),
  596. contact_email=payload.get("contact_email"),
  597. protocol_attachments=payload.get("protocol_attachments"),
  598. order_num=payload.get("order_num"),
  599. remark=payload.get("remark"),
  600. user_id=user.get("user_id"),
  601. tenant_no=tenant_no,
  602. )
  603. return success_response(
  604. ps_svc._row_to_dict_channel(obj, db, tenant_no),
  605. message="更新成功",
  606. )
  607. except ValueError as e:
  608. return error_response(400, str(e))
  609. @router.delete("/channels/{row_id}")
  610. async def delete_channel(
  611. row_id: str,
  612. user: dict = Depends(require_admin_or_super_admin),
  613. db: Session = Depends(get_db),
  614. ):
  615. try:
  616. tenant_no = _get_tenant_no(db, user)
  617. ps_svc.soft_delete_channel(db, row_id, tenant_no=tenant_no)
  618. return success_response(None, message="删除成功")
  619. except ValueError as e:
  620. return error_response(400, str(e))
  621. # --- 渠道开票信息 ---
  622. class ChannelInvoiceCreateBody(BaseModel):
  623. model_config = ConfigDict(populate_by_name=True)
  624. company_name: str = Field(..., alias="companyName")
  625. tax_no: Optional[str] = Field(None, alias="taxNo")
  626. company_address: Optional[str] = Field(None, alias="companyAddress")
  627. company_phone: Optional[str] = Field(None, alias="companyPhone")
  628. bank_name: Optional[str] = Field(None, alias="bankName")
  629. bank_account: Optional[str] = Field(None, alias="bankAccount")
  630. order_num: Optional[int] = Field(0, alias="orderNum")
  631. remark: Optional[str] = None
  632. class ChannelInvoiceUpdateBody(BaseModel):
  633. model_config = ConfigDict(populate_by_name=True)
  634. company_name: Optional[str] = Field(None, alias="companyName")
  635. tax_no: Optional[str] = Field(None, alias="taxNo")
  636. company_address: Optional[str] = Field(None, alias="companyAddress")
  637. company_phone: Optional[str] = Field(None, alias="companyPhone")
  638. bank_name: Optional[str] = Field(None, alias="bankName")
  639. bank_account: Optional[str] = Field(None, alias="bankAccount")
  640. order_num: Optional[int] = Field(None, alias="orderNum")
  641. remark: Optional[str] = None
  642. @router.get("/channels/{channel_id}/invoices")
  643. async def list_channel_invoices(
  644. channel_id: str,
  645. user: dict = Depends(require_admin_or_super_admin),
  646. db: Session = Depends(get_db),
  647. ):
  648. try:
  649. tenant_no = _get_tenant_no(db, user)
  650. items = ps_svc.list_channel_invoices(db, channel_id, tenant_no=tenant_no, user_info=user)
  651. return success_response(items)
  652. except ValueError as e:
  653. return error_response(400, str(e))
  654. @router.post("/channels/{channel_id}/invoices")
  655. async def create_channel_invoice(
  656. channel_id: str,
  657. body: ChannelInvoiceCreateBody,
  658. user: dict = Depends(require_admin_or_super_admin),
  659. db: Session = Depends(get_db),
  660. ):
  661. try:
  662. tenant_no = _get_tenant_no(db, user)
  663. obj = ps_svc.create_channel_invoice(
  664. db,
  665. channel_id=channel_id,
  666. company_name=body.company_name,
  667. tax_no=body.tax_no,
  668. company_address=body.company_address,
  669. company_phone=body.company_phone,
  670. bank_name=body.bank_name,
  671. bank_account=body.bank_account,
  672. tenant_no=tenant_no,
  673. order_num=body.order_num,
  674. remark=body.remark,
  675. user_id=user.get("user_id"),
  676. )
  677. return success_response(ps_svc._row_to_dict_channel_invoice(obj), message="创建成功")
  678. except ValueError as e:
  679. return error_response(400, str(e))
  680. @router.put("/channel-invoices/{invoice_id}")
  681. async def update_channel_invoice(
  682. invoice_id: str,
  683. body: ChannelInvoiceUpdateBody,
  684. user: dict = Depends(require_admin_or_super_admin),
  685. db: Session = Depends(get_db),
  686. ):
  687. try:
  688. tenant_no = _get_tenant_no(db, user)
  689. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  690. obj = ps_svc.update_channel_invoice(
  691. db,
  692. invoice_id,
  693. company_name=payload.get("company_name"),
  694. tax_no=payload.get("tax_no"),
  695. company_address=payload.get("company_address"),
  696. company_phone=payload.get("company_phone"),
  697. bank_name=payload.get("bank_name"),
  698. bank_account=payload.get("bank_account"),
  699. order_num=payload.get("order_num"),
  700. remark=payload.get("remark"),
  701. user_id=user.get("user_id"),
  702. tenant_no=tenant_no,
  703. )
  704. return success_response(ps_svc._row_to_dict_channel_invoice(obj), message="更新成功")
  705. except ValueError as e:
  706. return error_response(400, str(e))
  707. @router.delete("/channel-invoices/{invoice_id}")
  708. async def delete_channel_invoice(
  709. invoice_id: str,
  710. user: dict = Depends(require_admin_or_super_admin),
  711. db: Session = Depends(get_db),
  712. ):
  713. try:
  714. tenant_no = _get_tenant_no(db, user)
  715. ps_svc.soft_delete_channel_invoice(db, invoice_id, tenant_no=tenant_no)
  716. return success_response(None, message="删除成功")
  717. except ValueError as e:
  718. return error_response(400, str(e))
  719. # --- 渠道邮寄地址 ---
  720. class ChannelMailAddressCreateBody(BaseModel):
  721. model_config = ConfigDict(populate_by_name=True)
  722. mail_address: str = Field(..., alias="mailAddress")
  723. mail_contact: Optional[str] = Field(None, alias="mailContact")
  724. mail_phone: Optional[str] = Field(None, alias="mailPhone")
  725. order_num: Optional[int] = Field(0, alias="orderNum")
  726. remark: Optional[str] = None
  727. class ChannelMailAddressUpdateBody(BaseModel):
  728. model_config = ConfigDict(populate_by_name=True)
  729. mail_address: Optional[str] = Field(None, alias="mailAddress")
  730. mail_contact: Optional[str] = Field(None, alias="mailContact")
  731. mail_phone: Optional[str] = Field(None, alias="mailPhone")
  732. order_num: Optional[int] = Field(None, alias="orderNum")
  733. remark: Optional[str] = None
  734. @router.get("/channels/{channel_id}/mail-addresses")
  735. async def list_channel_mail_addresses(
  736. channel_id: str,
  737. user: dict = Depends(require_admin_or_super_admin),
  738. db: Session = Depends(get_db),
  739. ):
  740. try:
  741. tenant_no = _get_tenant_no(db, user)
  742. items = ps_svc.list_channel_mail_addresses(db, channel_id, tenant_no=tenant_no, user_info=user)
  743. return success_response(items)
  744. except ValueError as e:
  745. return error_response(400, str(e))
  746. @router.post("/channels/{channel_id}/mail-addresses")
  747. async def create_channel_mail_address(
  748. channel_id: str,
  749. body: ChannelMailAddressCreateBody,
  750. user: dict = Depends(require_admin_or_super_admin),
  751. db: Session = Depends(get_db),
  752. ):
  753. try:
  754. tenant_no = _get_tenant_no(db, user)
  755. obj = ps_svc.create_channel_mail_address(
  756. db,
  757. channel_id=channel_id,
  758. mail_address=body.mail_address,
  759. mail_contact=body.mail_contact,
  760. mail_phone=body.mail_phone,
  761. tenant_no=tenant_no,
  762. order_num=body.order_num,
  763. remark=body.remark,
  764. user_id=user.get("user_id"),
  765. )
  766. return success_response(ps_svc._row_to_dict_channel_mail_address(obj), message="创建成功")
  767. except ValueError as e:
  768. return error_response(400, str(e))
  769. @router.put("/channel-mail-addresses/{address_id}")
  770. async def update_channel_mail_address(
  771. address_id: str,
  772. body: ChannelMailAddressUpdateBody,
  773. user: dict = Depends(require_admin_or_super_admin),
  774. db: Session = Depends(get_db),
  775. ):
  776. try:
  777. tenant_no = _get_tenant_no(db, user)
  778. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  779. obj = ps_svc.update_channel_mail_address(
  780. db,
  781. address_id,
  782. mail_address=payload.get("mail_address"),
  783. mail_contact=payload.get("mail_contact"),
  784. mail_phone=payload.get("mail_phone"),
  785. order_num=payload.get("order_num"),
  786. remark=payload.get("remark"),
  787. user_id=user.get("user_id"),
  788. tenant_no=tenant_no,
  789. )
  790. return success_response(ps_svc._row_to_dict_channel_mail_address(obj), message="更新成功")
  791. except ValueError as e:
  792. return error_response(400, str(e))
  793. @router.delete("/channel-mail-addresses/{address_id}")
  794. async def delete_channel_mail_address(
  795. address_id: str,
  796. user: dict = Depends(require_admin_or_super_admin),
  797. db: Session = Depends(get_db),
  798. ):
  799. try:
  800. tenant_no = _get_tenant_no(db, user)
  801. ps_svc.soft_delete_channel_mail_address(db, address_id, tenant_no=tenant_no)
  802. return success_response(None, message="删除成功")
  803. except ValueError as e:
  804. return error_response(400, str(e))
  805. # --- 渠道协议 ---
  806. class ChannelAgreementCreateBody(BaseModel):
  807. model_config = ConfigDict(populate_by_name=True)
  808. agreement_type: str = Field(..., alias="agreementType")
  809. business_type: Optional[str] = Field(None, alias="businessType")
  810. settle_mode: Optional[str] = Field(None, alias="settleMode")
  811. credit_limit_amount: Optional[float] = Field(None, alias="creditLimitAmount")
  812. effective_date: Optional[str] = Field(None, alias="effectiveDate")
  813. expire_date: Optional[str] = Field(None, alias="expireDate")
  814. order_num: Optional[int] = Field(0, alias="orderNum")
  815. remark: Optional[str] = None
  816. class ChannelAgreementUpdateBody(BaseModel):
  817. model_config = ConfigDict(populate_by_name=True)
  818. agreement_type: Optional[str] = Field(None, alias="agreementType")
  819. business_type: Optional[str] = Field(None, alias="businessType")
  820. settle_mode: Optional[str] = Field(None, alias="settleMode")
  821. credit_limit_amount: Optional[float] = Field(None, alias="creditLimitAmount")
  822. effective_date: Optional[str] = Field(None, alias="effectiveDate")
  823. expire_date: Optional[str] = Field(None, alias="expireDate")
  824. order_num: Optional[int] = Field(None, alias="orderNum")
  825. remark: Optional[str] = None
  826. @router.get("/channels/{channel_id}/agreements")
  827. async def list_channel_agreements(
  828. channel_id: str,
  829. user: dict = Depends(require_admin_or_super_admin),
  830. db: Session = Depends(get_db),
  831. ):
  832. try:
  833. tenant_no = _get_tenant_no(db, user)
  834. items = ps_svc.list_channel_agreements(db, channel_id, tenant_no=tenant_no, user_info=user)
  835. return success_response(items)
  836. except ValueError as e:
  837. return error_response(400, str(e))
  838. @router.post("/channels/{channel_id}/agreements")
  839. async def create_channel_agreement(
  840. channel_id: str,
  841. body: ChannelAgreementCreateBody,
  842. user: dict = Depends(require_admin_or_super_admin),
  843. db: Session = Depends(get_db),
  844. ):
  845. try:
  846. tenant_no = _get_tenant_no(db, user)
  847. obj = ps_svc.create_channel_agreement(
  848. db,
  849. channel_id=channel_id,
  850. agreement_type=body.agreement_type,
  851. business_type=body.business_type,
  852. settle_mode=body.settle_mode,
  853. credit_limit_amount=body.credit_limit_amount,
  854. effective_date=body.effective_date,
  855. expire_date=body.expire_date,
  856. tenant_no=tenant_no,
  857. order_num=body.order_num,
  858. remark=body.remark,
  859. user_id=user.get("user_id"),
  860. )
  861. return success_response(ps_svc._row_to_dict_channel_agreement(obj), message="创建成功")
  862. except ValueError as e:
  863. return error_response(400, str(e))
  864. @router.put("/channel-agreements/{agreement_id}")
  865. async def update_channel_agreement(
  866. agreement_id: str,
  867. body: ChannelAgreementUpdateBody,
  868. user: dict = Depends(require_admin_or_super_admin),
  869. db: Session = Depends(get_db),
  870. ):
  871. try:
  872. tenant_no = _get_tenant_no(db, user)
  873. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  874. obj = ps_svc.update_channel_agreement(
  875. db,
  876. agreement_id,
  877. agreement_type=payload.get("agreement_type"),
  878. business_type=payload.get("business_type"),
  879. settle_mode=payload.get("settle_mode"),
  880. credit_limit_amount=payload.get("credit_limit_amount"),
  881. effective_date=payload.get("effective_date"),
  882. expire_date=payload.get("expire_date"),
  883. order_num=payload.get("order_num"),
  884. remark=payload.get("remark"),
  885. user_id=user.get("user_id"),
  886. tenant_no=tenant_no,
  887. )
  888. return success_response(ps_svc._row_to_dict_channel_agreement(obj), message="更新成功")
  889. except ValueError as e:
  890. return error_response(400, str(e))
  891. @router.delete("/channel-agreements/{agreement_id}")
  892. async def delete_channel_agreement(
  893. agreement_id: str,
  894. user: dict = Depends(require_admin_or_super_admin),
  895. db: Session = Depends(get_db),
  896. ):
  897. try:
  898. tenant_no = _get_tenant_no(db, user)
  899. ps_svc.soft_delete_channel_agreement(db, agreement_id, tenant_no=tenant_no)
  900. return success_response(None, message="删除成功")
  901. except ValueError as e:
  902. return error_response(400, str(e))
  903. @router.put("/channel-agreements/{agreement_id}/activate")
  904. async def activate_channel_agreement(
  905. agreement_id: str,
  906. user: dict = Depends(require_admin_or_super_admin),
  907. db: Session = Depends(get_db),
  908. ):
  909. try:
  910. tenant_no = _get_tenant_no(db, user)
  911. obj = ps_svc.activate_channel_agreement(
  912. db,
  913. agreement_id,
  914. tenant_no=tenant_no,
  915. user_id=user.get("user_id"),
  916. )
  917. return success_response(ps_svc._row_to_dict_channel_agreement(obj), message="生效成功")
  918. except ValueError as e:
  919. return error_response(400, str(e))
  920. @router.put("/channel-agreements/{agreement_id}/void")
  921. async def void_channel_agreement(
  922. agreement_id: str,
  923. user: dict = Depends(require_admin_or_super_admin),
  924. db: Session = Depends(get_db),
  925. ):
  926. try:
  927. tenant_no = _get_tenant_no(db, user)
  928. obj = ps_svc.void_channel_agreement(
  929. db,
  930. agreement_id,
  931. tenant_no=tenant_no,
  932. user_id=user.get("user_id"),
  933. )
  934. return success_response(ps_svc._row_to_dict_channel_agreement(obj), message="作废成功")
  935. except ValueError as e:
  936. return error_response(400, str(e))
  937. # --- 渠道协议产品价格 ---
  938. class ChannelAgreementPriceCreateBody(BaseModel):
  939. model_config = ConfigDict(populate_by_name=True)
  940. project_name: Optional[str] = Field(None, alias="projectName")
  941. project_code: Optional[str] = Field(None, alias="projectCode")
  942. cell_type_code: Optional[str] = Field(None, alias="cellTypeCode")
  943. cell_type_name: Optional[str] = Field(None, alias="cellTypeName")
  944. spec_text: Optional[str] = Field(None, alias="specText")
  945. original_price: Optional[float] = Field(None, alias="originalPrice")
  946. agreement_price: Optional[float] = Field(None, alias="agreementPrice")
  947. order_num: Optional[int] = Field(0, alias="orderNum")
  948. remark: Optional[str] = None
  949. class ChannelAgreementPriceUpdateBody(BaseModel):
  950. model_config = ConfigDict(populate_by_name=True)
  951. project_name: Optional[str] = Field(None, alias="projectName")
  952. project_code: Optional[str] = Field(None, alias="projectCode")
  953. cell_type_code: Optional[str] = Field(None, alias="cellTypeCode")
  954. cell_type_name: Optional[str] = Field(None, alias="cellTypeName")
  955. spec_text: Optional[str] = Field(None, alias="specText")
  956. original_price: Optional[float] = Field(None, alias="originalPrice")
  957. agreement_price: Optional[float] = Field(None, alias="agreementPrice")
  958. order_num: Optional[int] = Field(None, alias="orderNum")
  959. remark: Optional[str] = None
  960. @router.get("/channel-agreements/{agreement_id}/product-prices")
  961. async def list_channel_agreement_prices(
  962. agreement_id: str,
  963. user: dict = Depends(require_admin_or_super_admin),
  964. db: Session = Depends(get_db),
  965. ):
  966. try:
  967. tenant_no = _get_tenant_no(db, user)
  968. items = ps_svc.list_channel_agreement_prices(db, agreement_id, tenant_no=tenant_no, user_info=user)
  969. return success_response(items)
  970. except ValueError as e:
  971. return error_response(400, str(e))
  972. @router.post("/channel-agreements/{agreement_id}/product-prices")
  973. async def create_channel_agreement_price(
  974. agreement_id: str,
  975. body: ChannelAgreementPriceCreateBody,
  976. user: dict = Depends(require_admin_or_super_admin),
  977. db: Session = Depends(get_db),
  978. ):
  979. try:
  980. tenant_no = _get_tenant_no(db, user)
  981. obj = ps_svc.create_channel_agreement_price(
  982. db,
  983. channel_agreement_id=agreement_id,
  984. project_name=body.project_name,
  985. project_code=body.project_code,
  986. cell_type_code=body.cell_type_code,
  987. cell_type_name=body.cell_type_name,
  988. spec_text=body.spec_text,
  989. original_price=body.original_price,
  990. agreement_price=body.agreement_price,
  991. tenant_no=tenant_no,
  992. order_num=body.order_num,
  993. remark=body.remark,
  994. user_id=user.get("user_id"),
  995. )
  996. return success_response(ps_svc._row_to_dict_channel_agreement_price(obj), message="创建成功")
  997. except ValueError as e:
  998. return error_response(400, str(e))
  999. @router.put("/channel-agreement-product-prices/{price_id}")
  1000. async def update_channel_agreement_price(
  1001. price_id: str,
  1002. body: ChannelAgreementPriceUpdateBody,
  1003. user: dict = Depends(require_admin_or_super_admin),
  1004. db: Session = Depends(get_db),
  1005. ):
  1006. try:
  1007. tenant_no = _get_tenant_no(db, user)
  1008. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  1009. obj = ps_svc.update_channel_agreement_price(
  1010. db,
  1011. price_id,
  1012. project_name=payload.get("project_name"),
  1013. project_code=payload.get("project_code"),
  1014. cell_type_code=payload.get("cell_type_code"),
  1015. cell_type_name=payload.get("cell_type_name"),
  1016. spec_text=payload.get("spec_text"),
  1017. original_price=payload.get("original_price"),
  1018. agreement_price=payload.get("agreement_price"),
  1019. order_num=payload.get("order_num"),
  1020. remark=payload.get("remark"),
  1021. user_id=user.get("user_id"),
  1022. tenant_no=tenant_no,
  1023. )
  1024. return success_response(ps_svc._row_to_dict_channel_agreement_price(obj), message="更新成功")
  1025. except ValueError as e:
  1026. return error_response(400, str(e))
  1027. @router.delete("/channel-agreement-product-prices/{price_id}")
  1028. async def delete_channel_agreement_price(
  1029. price_id: str,
  1030. user: dict = Depends(require_admin_or_super_admin),
  1031. db: Session = Depends(get_db),
  1032. ):
  1033. try:
  1034. tenant_no = _get_tenant_no(db, user)
  1035. ps_svc.soft_delete_channel_agreement_price(db, price_id, tenant_no=tenant_no)
  1036. return success_response(None, message="删除成功")
  1037. except ValueError as e:
  1038. return error_response(400, str(e))
  1039. # ---------------------------------------------------------------------------
  1040. # 6. 体检机构(主表 + 开票信息/项目及价格子表)
  1041. # ---------------------------------------------------------------------------
  1042. class CheckupInstitutionCreateBody(BaseModel):
  1043. model_config = ConfigDict(populate_by_name=True)
  1044. institution_name: str = Field(..., alias="institutionName")
  1045. institution_address: Optional[str] = Field(None, alias="institutionAddress")
  1046. contact_name: Optional[str] = Field(None, alias="contactName")
  1047. contact_phone: Optional[str] = Field(None, alias="contactPhone")
  1048. status: Optional[str] = Field("1", alias="status")
  1049. order_num: Optional[int] = Field(0, alias="orderNum")
  1050. remark: Optional[str] = None
  1051. class CheckupInstitutionUpdateBody(BaseModel):
  1052. model_config = ConfigDict(populate_by_name=True)
  1053. institution_name: Optional[str] = Field(None, alias="institutionName")
  1054. institution_address: Optional[str] = Field(None, alias="institutionAddress")
  1055. contact_name: Optional[str] = Field(None, alias="contactName")
  1056. contact_phone: Optional[str] = Field(None, alias="contactPhone")
  1057. status: Optional[str] = Field(None, alias="status")
  1058. order_num: Optional[int] = Field(None, alias="orderNum")
  1059. remark: Optional[str] = None
  1060. @router.get("/checkup-institutions")
  1061. async def list_checkup_institutions(
  1062. page: int = Query(1, ge=1),
  1063. pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
  1064. keyword: Optional[str] = None,
  1065. status: Optional[str] = None,
  1066. user: dict = Depends(require_admin_or_super_admin),
  1067. db: Session = Depends(get_db),
  1068. ):
  1069. tenant_no = _get_tenant_no(db, user)
  1070. items, total = ps_svc.list_checkup_institutions(
  1071. db,
  1072. page=page,
  1073. page_size=pageSize,
  1074. keyword=keyword,
  1075. status=status,
  1076. tenant_no=tenant_no,
  1077. user_info=user,
  1078. )
  1079. tp = ps_svc.total_pages(total, pageSize)
  1080. return success_response(
  1081. {"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp}
  1082. )
  1083. @router.post("/checkup-institutions")
  1084. async def create_checkup_institution(
  1085. body: CheckupInstitutionCreateBody,
  1086. user: dict = Depends(require_admin_or_super_admin),
  1087. db: Session = Depends(get_db),
  1088. ):
  1089. try:
  1090. tenant_no = _get_tenant_no(db, user)
  1091. obj = ps_svc.create_checkup_institution(
  1092. db,
  1093. institution_name=body.institution_name,
  1094. institution_address=body.institution_address,
  1095. contact_name=body.contact_name,
  1096. contact_phone=body.contact_phone,
  1097. status=body.status,
  1098. tenant_no=tenant_no,
  1099. order_num=body.order_num,
  1100. remark=body.remark,
  1101. user_id=user.get("user_id"),
  1102. )
  1103. return success_response(ps_svc._row_to_dict_checkup_institution(obj), message="创建成功")
  1104. except ValueError as e:
  1105. return error_response(400, str(e))
  1106. @router.put("/checkup-institutions/{row_id}")
  1107. async def update_checkup_institution(
  1108. row_id: str,
  1109. body: CheckupInstitutionUpdateBody,
  1110. user: dict = Depends(require_admin_or_super_admin),
  1111. db: Session = Depends(get_db),
  1112. ):
  1113. try:
  1114. tenant_no = _get_tenant_no(db, user)
  1115. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  1116. obj = ps_svc.update_checkup_institution(
  1117. db,
  1118. row_id,
  1119. institution_name=payload.get("institution_name"),
  1120. institution_address=payload.get("institution_address"),
  1121. contact_name=payload.get("contact_name"),
  1122. contact_phone=payload.get("contact_phone"),
  1123. status=payload.get("status"),
  1124. order_num=payload.get("order_num"),
  1125. remark=payload.get("remark"),
  1126. user_id=user.get("user_id"),
  1127. tenant_no=tenant_no,
  1128. )
  1129. return success_response(ps_svc._row_to_dict_checkup_institution(obj), message="更新成功")
  1130. except ValueError as e:
  1131. return error_response(400, str(e))
  1132. @router.delete("/checkup-institutions/{row_id}")
  1133. async def delete_checkup_institution(
  1134. row_id: str,
  1135. user: dict = Depends(require_admin_or_super_admin),
  1136. db: Session = Depends(get_db),
  1137. ):
  1138. try:
  1139. tenant_no = _get_tenant_no(db, user)
  1140. ps_svc.soft_delete_checkup_institution(db, row_id, tenant_no=tenant_no)
  1141. return success_response(None, message="删除成功")
  1142. except ValueError as e:
  1143. return error_response(400, str(e))
  1144. # --- 体检机构开票信息 ---
  1145. class CheckupInstitutionInvoiceCreateBody(BaseModel):
  1146. model_config = ConfigDict(populate_by_name=True)
  1147. company_name: str = Field(..., alias="companyName")
  1148. tax_no: Optional[str] = Field(None, alias="taxNo")
  1149. company_address: Optional[str] = Field(None, alias="companyAddress")
  1150. company_phone: Optional[str] = Field(None, alias="companyPhone")
  1151. bank_name: Optional[str] = Field(None, alias="bankName")
  1152. bank_account: Optional[str] = Field(None, alias="bankAccount")
  1153. order_num: Optional[int] = Field(0, alias="orderNum")
  1154. remark: Optional[str] = None
  1155. class CheckupInstitutionInvoiceUpdateBody(BaseModel):
  1156. model_config = ConfigDict(populate_by_name=True)
  1157. company_name: Optional[str] = Field(None, alias="companyName")
  1158. tax_no: Optional[str] = Field(None, alias="taxNo")
  1159. company_address: Optional[str] = Field(None, alias="companyAddress")
  1160. company_phone: Optional[str] = Field(None, alias="companyPhone")
  1161. bank_name: Optional[str] = Field(None, alias="bankName")
  1162. bank_account: Optional[str] = Field(None, alias="bankAccount")
  1163. order_num: Optional[int] = Field(None, alias="orderNum")
  1164. remark: Optional[str] = None
  1165. @router.get("/checkup-institutions/{institution_id}/invoices")
  1166. async def list_checkup_institution_invoices(
  1167. institution_id: str,
  1168. user: dict = Depends(require_admin_or_super_admin),
  1169. db: Session = Depends(get_db),
  1170. ):
  1171. try:
  1172. tenant_no = _get_tenant_no(db, user)
  1173. items = ps_svc.list_checkup_institution_invoices(db, institution_id, tenant_no=tenant_no, user_info=user)
  1174. return success_response(items)
  1175. except ValueError as e:
  1176. return error_response(400, str(e))
  1177. @router.post("/checkup-institutions/{institution_id}/invoices")
  1178. async def create_checkup_institution_invoice(
  1179. institution_id: str,
  1180. body: CheckupInstitutionInvoiceCreateBody,
  1181. user: dict = Depends(require_admin_or_super_admin),
  1182. db: Session = Depends(get_db),
  1183. ):
  1184. try:
  1185. tenant_no = _get_tenant_no(db, user)
  1186. obj = ps_svc.create_checkup_institution_invoice(
  1187. db,
  1188. checkup_institution_id=institution_id,
  1189. company_name=body.company_name,
  1190. tax_no=body.tax_no,
  1191. company_address=body.company_address,
  1192. company_phone=body.company_phone,
  1193. bank_name=body.bank_name,
  1194. bank_account=body.bank_account,
  1195. tenant_no=tenant_no,
  1196. order_num=body.order_num,
  1197. remark=body.remark,
  1198. user_id=user.get("user_id"),
  1199. )
  1200. return success_response(ps_svc._row_to_dict_checkup_institution_invoice(obj), message="创建成功")
  1201. except ValueError as e:
  1202. return error_response(400, str(e))
  1203. @router.put("/checkup-institution-invoices/{invoice_id}")
  1204. async def update_checkup_institution_invoice(
  1205. invoice_id: str,
  1206. body: CheckupInstitutionInvoiceUpdateBody,
  1207. user: dict = Depends(require_admin_or_super_admin),
  1208. db: Session = Depends(get_db),
  1209. ):
  1210. try:
  1211. tenant_no = _get_tenant_no(db, user)
  1212. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  1213. obj = ps_svc.update_checkup_institution_invoice(
  1214. db,
  1215. invoice_id,
  1216. company_name=payload.get("company_name"),
  1217. tax_no=payload.get("tax_no"),
  1218. company_address=payload.get("company_address"),
  1219. company_phone=payload.get("company_phone"),
  1220. bank_name=payload.get("bank_name"),
  1221. bank_account=payload.get("bank_account"),
  1222. order_num=payload.get("order_num"),
  1223. remark=payload.get("remark"),
  1224. user_id=user.get("user_id"),
  1225. tenant_no=tenant_no,
  1226. )
  1227. return success_response(ps_svc._row_to_dict_checkup_institution_invoice(obj), message="更新成功")
  1228. except ValueError as e:
  1229. return error_response(400, str(e))
  1230. @router.delete("/checkup-institution-invoices/{invoice_id}")
  1231. async def delete_checkup_institution_invoice(
  1232. invoice_id: str,
  1233. user: dict = Depends(require_admin_or_super_admin),
  1234. db: Session = Depends(get_db),
  1235. ):
  1236. try:
  1237. tenant_no = _get_tenant_no(db, user)
  1238. ps_svc.soft_delete_checkup_institution_invoice(db, invoice_id, tenant_no=tenant_no)
  1239. return success_response(None, message="删除成功")
  1240. except ValueError as e:
  1241. return error_response(400, str(e))
  1242. # --- 体检机构项目及价格 ---
  1243. class CheckupInstitutionProjectCreateBody(BaseModel):
  1244. model_config = ConfigDict(populate_by_name=True)
  1245. project_name: str = Field(..., alias="projectName")
  1246. project_fee: Optional[float] = Field(None, alias="projectFee")
  1247. status: Optional[str] = Field("1", alias="status")
  1248. order_num: Optional[int] = Field(0, alias="orderNum")
  1249. remark: Optional[str] = None
  1250. class CheckupInstitutionProjectUpdateBody(BaseModel):
  1251. model_config = ConfigDict(populate_by_name=True)
  1252. project_name: Optional[str] = Field(None, alias="projectName")
  1253. project_fee: Optional[float] = Field(None, alias="projectFee")
  1254. status: Optional[str] = Field(None, alias="status")
  1255. order_num: Optional[int] = Field(None, alias="orderNum")
  1256. remark: Optional[str] = None
  1257. @router.get("/checkup-institutions/{institution_id}/projects")
  1258. async def list_checkup_institution_projects(
  1259. institution_id: str,
  1260. user: dict = Depends(require_admin_or_super_admin),
  1261. db: Session = Depends(get_db),
  1262. ):
  1263. try:
  1264. tenant_no = _get_tenant_no(db, user)
  1265. items = ps_svc.list_checkup_institution_projects(db, institution_id, tenant_no=tenant_no, user_info=user)
  1266. return success_response(items)
  1267. except ValueError as e:
  1268. return error_response(400, str(e))
  1269. @router.post("/checkup-institutions/{institution_id}/projects")
  1270. async def create_checkup_institution_project(
  1271. institution_id: str,
  1272. body: CheckupInstitutionProjectCreateBody,
  1273. user: dict = Depends(require_admin_or_super_admin),
  1274. db: Session = Depends(get_db),
  1275. ):
  1276. try:
  1277. tenant_no = _get_tenant_no(db, user)
  1278. obj = ps_svc.create_checkup_institution_project(
  1279. db,
  1280. checkup_institution_id=institution_id,
  1281. project_name=body.project_name,
  1282. project_fee=body.project_fee,
  1283. status=body.status,
  1284. tenant_no=tenant_no,
  1285. order_num=body.order_num,
  1286. remark=body.remark,
  1287. user_id=user.get("user_id"),
  1288. )
  1289. return success_response(ps_svc._row_to_dict_checkup_institution_project(obj), message="创建成功")
  1290. except ValueError as e:
  1291. return error_response(400, str(e))
  1292. @router.put("/checkup-institution-projects/{project_id}")
  1293. async def update_checkup_institution_project(
  1294. project_id: str,
  1295. body: CheckupInstitutionProjectUpdateBody,
  1296. user: dict = Depends(require_admin_or_super_admin),
  1297. db: Session = Depends(get_db),
  1298. ):
  1299. try:
  1300. tenant_no = _get_tenant_no(db, user)
  1301. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  1302. obj = ps_svc.update_checkup_institution_project(
  1303. db,
  1304. project_id,
  1305. project_name=payload.get("project_name"),
  1306. project_fee=payload.get("project_fee"),
  1307. status=payload.get("status"),
  1308. order_num=payload.get("order_num"),
  1309. remark=payload.get("remark"),
  1310. user_id=user.get("user_id"),
  1311. tenant_no=tenant_no,
  1312. )
  1313. return success_response(ps_svc._row_to_dict_checkup_institution_project(obj), message="更新成功")
  1314. except ValueError as e:
  1315. return error_response(400, str(e))
  1316. @router.delete("/checkup-institution-projects/{project_id}")
  1317. async def delete_checkup_institution_project(
  1318. project_id: str,
  1319. user: dict = Depends(require_admin_or_super_admin),
  1320. db: Session = Depends(get_db),
  1321. ):
  1322. try:
  1323. tenant_no = _get_tenant_no(db, user)
  1324. ps_svc.soft_delete_checkup_institution_project(db, project_id, tenant_no=tenant_no)
  1325. return success_response(None, message="删除成功")
  1326. except ValueError as e:
  1327. return error_response(400, str(e))
  1328. # ---------------------------------------------------------------------------
  1329. # 7. 渠道服务购买订单
  1330. # ---------------------------------------------------------------------------
  1331. class ServiceOrderProductItem(BaseModel):
  1332. model_config = ConfigDict(populate_by_name=True)
  1333. project_code: Optional[str] = Field(None, alias="projectCode")
  1334. project_name: Optional[str] = Field(None, alias="projectName")
  1335. cell_type: Optional[str] = Field(None, alias="cellType")
  1336. spec_text: Optional[str] = Field(None, alias="specText")
  1337. agreement_unit_price: Optional[float] = Field(None, alias="agreementUnitPrice")
  1338. buy_qty: Optional[float] = Field(None, alias="buyQty")
  1339. buy_amount: Optional[float] = Field(None, alias="buyAmount")
  1340. class ServiceOrderCreateBody(BaseModel):
  1341. model_config = ConfigDict(populate_by_name=True)
  1342. channel_id: str = Field(..., alias="channelId")
  1343. order_type: str = Field(..., alias="orderType") # yfk / gmcp
  1344. order_name: Optional[str] = Field(None, alias="orderName")
  1345. dept_name: Optional[str] = Field(None, alias="deptName")
  1346. prepay_amount: Optional[float] = Field(None, alias="prepayAmount")
  1347. channel_agreement_id: Optional[str] = Field(None, alias="channelAgreementId")
  1348. products: Optional[List[ServiceOrderProductItem]] = None
  1349. remark: Optional[str] = None
  1350. class ServiceOrderUpdateBody(BaseModel):
  1351. model_config = ConfigDict(populate_by_name=True)
  1352. dept_name: Optional[str] = Field(None, alias="deptName")
  1353. order_name: Optional[str] = Field(None, alias="orderName")
  1354. remark: Optional[str] = None
  1355. prepay_amount: Optional[float] = Field(None, alias="prepayAmount")
  1356. channel_agreement_id: Optional[str] = Field(None, alias="channelAgreementId")
  1357. products: Optional[List[ServiceOrderProductItem]] = None
  1358. class FinanceSubmitBody(BaseModel):
  1359. model_config = ConfigDict(populate_by_name=True)
  1360. finance_submit_remark: Optional[str] = Field(None, alias="financeSubmitRemark")
  1361. finance_submit_attachments: Optional[str] = Field(None, alias="financeSubmitAttachments")
  1362. class FinanceConfirmBody(BaseModel):
  1363. model_config = ConfigDict(populate_by_name=True)
  1364. finance_remark: Optional[str] = Field(None, alias="financeRemark")
  1365. finance_confirm_attachments: Optional[str] = Field(None, alias="financeConfirmAttachments")
  1366. class RefundSubmitBody(BaseModel):
  1367. model_config = ConfigDict(populate_by_name=True)
  1368. refund_amount: Optional[float] = Field(None, alias="refundAmount")
  1369. refund_remark: Optional[str] = Field(None, alias="refundRemark")
  1370. refund_attachments: Optional[str] = Field(None, alias="refundAttachments")
  1371. class RefundConfirmBody(BaseModel):
  1372. model_config = ConfigDict(populate_by_name=True)
  1373. refund_finance_remark: Optional[str] = Field(None, alias="refundFinanceRemark")
  1374. refund_finance_confirm_attachments: Optional[str] = Field(
  1375. None, alias="refundFinanceConfirmAttachments"
  1376. )
  1377. class TxnRechargeBody(BaseModel):
  1378. model_config = ConfigDict(populate_by_name=True)
  1379. amount: float = Field(..., gt=0, alias="amount")
  1380. remark: Optional[str] = Field(None, alias="remark")
  1381. finance_submit_attachments: Optional[str] = Field(None, alias="financeSubmitAttachments")
  1382. class TxnRefundBody(BaseModel):
  1383. model_config = ConfigDict(populate_by_name=True)
  1384. amount: float = Field(..., gt=0, alias="amount")
  1385. remark: Optional[str] = Field(None, alias="remark")
  1386. attachments: Optional[str] = Field(None, alias="attachments")
  1387. class TxnProductItem(BaseModel):
  1388. model_config = ConfigDict(populate_by_name=True)
  1389. project_code: Optional[str] = Field(None, alias="projectCode")
  1390. project_name: Optional[str] = Field(None, alias="projectName")
  1391. cell_type: Optional[str] = Field(None, alias="cellType")
  1392. spec_text: Optional[str] = Field(None, alias="specText")
  1393. agreement_unit_price: Optional[float] = Field(None, alias="agreementUnitPrice")
  1394. qty: Optional[float] = Field(None, alias="qty")
  1395. amount: Optional[float] = Field(None, alias="amount")
  1396. class TxnPurchaseBody(BaseModel):
  1397. model_config = ConfigDict(populate_by_name=True)
  1398. products: List[TxnProductItem] = Field(..., alias="products")
  1399. remark: Optional[str] = Field(None, alias="remark")
  1400. class TxnUnsubscribeBody(BaseModel):
  1401. model_config = ConfigDict(populate_by_name=True)
  1402. products: List[TxnProductItem] = Field(..., alias="products")
  1403. remark: Optional[str] = Field(None, alias="remark")
  1404. class TxnUpdateBody(BaseModel):
  1405. model_config = ConfigDict(populate_by_name=True)
  1406. amount: Optional[float] = Field(None, gt=0, alias="amount")
  1407. remark: Optional[str] = Field(None, alias="remark")
  1408. finance_submit_attachments: Optional[str] = Field(None, alias="financeSubmitAttachments")
  1409. refund_attachments: Optional[str] = Field(None, alias="refundAttachments")
  1410. products: Optional[List[TxnProductItem]] = Field(None, alias="products")
  1411. class TxnFinanceSubmitBody(BaseModel):
  1412. model_config = ConfigDict(populate_by_name=True)
  1413. finance_submit_remark: Optional[str] = Field(None, alias="financeSubmitRemark")
  1414. finance_submit_attachments: Optional[str] = Field(None, alias="financeSubmitAttachments")
  1415. class TxnFinanceConfirmBody(BaseModel):
  1416. model_config = ConfigDict(populate_by_name=True)
  1417. finance_remark: Optional[str] = Field(None, alias="financeRemark")
  1418. finance_confirm_attachments: Optional[str] = Field(None, alias="financeConfirmAttachments")
  1419. @router.get("/channel-service-orders")
  1420. async def list_channel_service_orders(
  1421. page: int = Query(1, ge=1),
  1422. pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
  1423. orderType: Optional[str] = Query(None, alias="orderType"),
  1424. orderStatus: Optional[str] = Query(None, alias="orderStatus"),
  1425. channelId: Optional[str] = Query(None, alias="channelId"),
  1426. keyword: Optional[str] = None,
  1427. createTimeStart: Optional[str] = Query(None, alias="createTimeStart"),
  1428. createTimeEnd: Optional[str] = Query(None, alias="createTimeEnd"),
  1429. user: dict = Depends(require_admin_or_super_admin),
  1430. db: Session = Depends(get_db),
  1431. ):
  1432. tenant_no = _get_tenant_no(db, user)
  1433. items, total = ps_svc.list_channel_service_orders(
  1434. db,
  1435. page=page,
  1436. page_size=pageSize,
  1437. order_type=orderType,
  1438. order_status=orderStatus,
  1439. channel_id=channelId,
  1440. keyword=keyword,
  1441. create_time_start=createTimeStart,
  1442. create_time_end=createTimeEnd,
  1443. tenant_no=tenant_no,
  1444. user_info=user,
  1445. )
  1446. tp = ps_svc.total_pages(total, pageSize)
  1447. return success_response(
  1448. {"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp}
  1449. )
  1450. @router.get("/channel-service-orders/{order_id}")
  1451. async def get_channel_service_order_detail(
  1452. order_id: str,
  1453. user: dict = Depends(require_admin_or_super_admin),
  1454. db: Session = Depends(get_db),
  1455. ):
  1456. try:
  1457. tenant_no = _get_tenant_no(db, user)
  1458. order = ps_svc.get_service_order(db, order_id, tenant_no=tenant_no)
  1459. if not order:
  1460. return error_response(404, "订单不存在")
  1461. order_dict = ps_svc._row_to_dict_service_order(order, db, tenant_no)
  1462. user_ids = [x for x in (order.create_by, order.finance_submit_by) if x]
  1463. name_map = ps_svc._user_nick_name_map(db, user_ids)
  1464. order_dict["createByName"] = name_map.get(order.create_by or "", "") or (order.create_by or "")
  1465. order_dict["financeSubmitByName"] = name_map.get(order.finance_submit_by or "", "") or (
  1466. order.finance_submit_by or ""
  1467. )
  1468. products = ps_svc.get_service_order_products(db, order_id, tenant_no=tenant_no)
  1469. order_dict["products"] = products
  1470. txns, _ = ps_svc.list_service_order_txns(db, service_order_id=order_id, tenant_no=tenant_no, page_size=200)
  1471. order_dict["transactions"] = txns
  1472. if order.order_type == "gmcp":
  1473. has_lock = ps_svc._gmcp_has_purchase_lock(db, order_id, tenant_no)
  1474. order_dict["hasPurchaseTxn"] = has_lock
  1475. order_dict["agreementEditable"] = ps_svc.gmcp_agreement_editable(db, order, tenant_no)
  1476. else:
  1477. order_dict["hasPurchaseTxn"] = False
  1478. order_dict["agreementEditable"] = order.order_status == "dsx"
  1479. return success_response(order_dict)
  1480. except ValueError as e:
  1481. return error_response(400, str(e))
  1482. @router.post("/channel-service-orders")
  1483. async def create_channel_service_order(
  1484. body: ServiceOrderCreateBody,
  1485. user: dict = Depends(require_admin_or_super_admin),
  1486. db: Session = Depends(get_db),
  1487. ):
  1488. try:
  1489. tenant_no = _get_tenant_no(db, user)
  1490. products_data = None
  1491. if body.products:
  1492. products_data = [p.model_dump(by_alias=False) for p in body.products]
  1493. order = ps_svc.create_channel_service_order(
  1494. db,
  1495. channel_id=body.channel_id,
  1496. order_type=body.order_type,
  1497. order_name=body.order_name,
  1498. dept_name=body.dept_name,
  1499. prepay_amount=body.prepay_amount,
  1500. channel_agreement_id=body.channel_agreement_id,
  1501. products=products_data,
  1502. tenant_no=tenant_no,
  1503. remark=body.remark,
  1504. user_id=user.get("user_id"),
  1505. )
  1506. order_dict = ps_svc._row_to_dict_service_order(order, db, tenant_no)
  1507. order_dict["products"] = ps_svc.get_service_order_products(db, order.id, tenant_no=tenant_no)
  1508. return success_response(order_dict, message="创建成功")
  1509. except ValueError as e:
  1510. return error_response(400, str(e))
  1511. @router.put("/channel-service-orders/{order_id}")
  1512. async def update_channel_service_order(
  1513. order_id: str,
  1514. body: ServiceOrderUpdateBody,
  1515. user: dict = Depends(require_admin_or_super_admin),
  1516. db: Session = Depends(get_db),
  1517. ):
  1518. try:
  1519. tenant_no = _get_tenant_no(db, user)
  1520. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  1521. products_data = None
  1522. if "products" in payload:
  1523. products_data = payload.pop("products")
  1524. if products_data is not None:
  1525. products_data = [
  1526. p.model_dump(by_alias=False) if hasattr(p, "model_dump") else p
  1527. for p in (body.products or [])
  1528. ]
  1529. obj = ps_svc.update_channel_service_order(
  1530. db,
  1531. order_id,
  1532. tenant_no=tenant_no,
  1533. user_id=user.get("user_id"),
  1534. products=products_data,
  1535. **payload,
  1536. )
  1537. return success_response(
  1538. ps_svc._row_to_dict_service_order(obj, db, tenant_no), message="更新成功"
  1539. )
  1540. except ValueError as e:
  1541. return error_response(400, str(e))
  1542. @router.delete("/channel-service-orders/{order_id}")
  1543. async def delete_channel_service_order(
  1544. order_id: str,
  1545. user: dict = Depends(require_admin_or_super_admin),
  1546. db: Session = Depends(get_db),
  1547. ):
  1548. try:
  1549. tenant_no = _get_tenant_no(db, user)
  1550. ps_svc.soft_delete_service_order(db, order_id, tenant_no=tenant_no)
  1551. return success_response(None, message="删除成功")
  1552. except ValueError as e:
  1553. return error_response(400, str(e))
  1554. @router.post("/channel-service-orders/{order_id}/submit-finance-confirm")
  1555. async def submit_service_order_finance_confirm(
  1556. order_id: str,
  1557. body: FinanceSubmitBody,
  1558. user: dict = Depends(require_admin_or_super_admin),
  1559. db: Session = Depends(get_db),
  1560. ):
  1561. try:
  1562. tenant_no = _get_tenant_no(db, user)
  1563. obj = ps_svc.submit_finance_confirm(
  1564. db,
  1565. order_id,
  1566. finance_submit_remark=body.finance_submit_remark,
  1567. finance_submit_attachments=body.finance_submit_attachments,
  1568. tenant_no=tenant_no,
  1569. user_id=user.get("user_id"),
  1570. )
  1571. return success_response(
  1572. ps_svc._row_to_dict_service_order(obj, db, tenant_no), message="已发起财务确认"
  1573. )
  1574. except ValueError as e:
  1575. return error_response(400, str(e))
  1576. @router.post("/channel-service-orders/{order_id}/confirm-receipt")
  1577. async def confirm_service_order_receipt(
  1578. order_id: str,
  1579. body: FinanceConfirmBody,
  1580. user: dict = Depends(require_admin_or_super_admin),
  1581. db: Session = Depends(get_db),
  1582. ):
  1583. try:
  1584. tenant_no = _get_tenant_no(db, user)
  1585. obj = ps_svc.confirm_receipt(
  1586. db,
  1587. order_id,
  1588. finance_remark=body.finance_remark,
  1589. finance_confirm_attachments=body.finance_confirm_attachments,
  1590. tenant_no=tenant_no,
  1591. user_id=user.get("user_id"),
  1592. )
  1593. return success_response(
  1594. ps_svc._row_to_dict_service_order(obj, db, tenant_no), message="确认收款成功"
  1595. )
  1596. except ValueError as e:
  1597. return error_response(400, str(e))
  1598. @router.post("/channel-service-orders/{order_id}/submit-refund")
  1599. async def submit_service_order_refund(
  1600. order_id: str,
  1601. body: RefundSubmitBody,
  1602. user: dict = Depends(require_admin_or_super_admin),
  1603. db: Session = Depends(get_db),
  1604. ):
  1605. try:
  1606. tenant_no = _get_tenant_no(db, user)
  1607. obj = ps_svc.submit_refund(
  1608. db,
  1609. order_id,
  1610. refund_amount=body.refund_amount,
  1611. refund_remark=body.refund_remark,
  1612. refund_attachments=body.refund_attachments,
  1613. tenant_no=tenant_no,
  1614. user_id=user.get("user_id"),
  1615. )
  1616. return success_response(
  1617. ps_svc._row_to_dict_service_order(obj, db, tenant_no), message="提交退款成功"
  1618. )
  1619. except ValueError as e:
  1620. return error_response(400, str(e))
  1621. @router.post("/channel-service-orders/{order_id}/confirm-refund")
  1622. async def confirm_service_order_refund(
  1623. order_id: str,
  1624. body: RefundConfirmBody,
  1625. user: dict = Depends(require_admin_or_super_admin),
  1626. db: Session = Depends(get_db),
  1627. ):
  1628. try:
  1629. tenant_no = _get_tenant_no(db, user)
  1630. obj = ps_svc.confirm_refund(
  1631. db,
  1632. order_id,
  1633. refund_finance_remark=body.refund_finance_remark,
  1634. refund_finance_confirm_attachments=body.refund_finance_confirm_attachments,
  1635. tenant_no=tenant_no,
  1636. user_id=user.get("user_id"),
  1637. )
  1638. return success_response(
  1639. ps_svc._row_to_dict_service_order(obj, db, tenant_no), message="确认退款成功"
  1640. )
  1641. except ValueError as e:
  1642. return error_response(400, str(e))
  1643. @router.put("/channel-service-orders/{order_id}/void")
  1644. async def void_channel_service_order(
  1645. order_id: str,
  1646. user: dict = Depends(require_admin_or_super_admin),
  1647. db: Session = Depends(get_db),
  1648. ):
  1649. try:
  1650. tenant_no = _get_tenant_no(db, user)
  1651. obj = ps_svc.void_service_order(
  1652. db,
  1653. order_id,
  1654. tenant_no=tenant_no,
  1655. user_id=user.get("user_id"),
  1656. )
  1657. return success_response(
  1658. ps_svc._row_to_dict_service_order(obj, db, tenant_no), message="作废成功"
  1659. )
  1660. except ValueError as e:
  1661. return error_response(400, str(e))
  1662. @router.get("/channel-service-order-txns")
  1663. async def list_service_order_txns(
  1664. page: int = Query(1, ge=1),
  1665. pageSize: int = Query(20, ge=1, le=100, alias="pageSize"),
  1666. serviceOrderId: Optional[str] = Query(None, alias="serviceOrderId"),
  1667. txnStatus: Optional[str] = Query(None, alias="txnStatus"),
  1668. txnType: Optional[str] = Query(None, alias="txnType"),
  1669. keyword: Optional[str] = None,
  1670. createTimeStart: Optional[str] = Query(None, alias="createTimeStart"),
  1671. createTimeEnd: Optional[str] = Query(None, alias="createTimeEnd"),
  1672. financeDoneOnly: Optional[bool] = Query(False, alias="financeDoneOnly"),
  1673. user: dict = Depends(require_admin_or_super_admin),
  1674. db: Session = Depends(get_db),
  1675. ):
  1676. tenant_no = _get_tenant_no(db, user)
  1677. items, total = ps_svc.list_service_order_txns(
  1678. db,
  1679. service_order_id=serviceOrderId,
  1680. txn_status=txnStatus,
  1681. txn_type=txnType,
  1682. keyword=keyword,
  1683. create_time_start=createTimeStart,
  1684. create_time_end=createTimeEnd,
  1685. finance_done_only=bool(financeDoneOnly),
  1686. page=page,
  1687. page_size=pageSize,
  1688. tenant_no=tenant_no,
  1689. )
  1690. tp = ps_svc.total_pages(total, pageSize)
  1691. return success_response(
  1692. {"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp}
  1693. )
  1694. @router.get("/channel-service-order-txns/{txn_id}")
  1695. async def get_service_order_txn_detail(
  1696. txn_id: str,
  1697. user: dict = Depends(require_admin_or_super_admin),
  1698. db: Session = Depends(get_db),
  1699. ):
  1700. try:
  1701. tenant_no = _get_tenant_no(db, user)
  1702. txn = ps_svc.get_service_order_txn(db, txn_id, tenant_no=tenant_no)
  1703. if not txn:
  1704. return error_response(404, "流水不存在")
  1705. txn_dict = ps_svc._service_order_txn_to_response_dict(db, txn, tenant_no)
  1706. return success_response(txn_dict)
  1707. except ValueError as e:
  1708. return error_response(400, str(e))
  1709. @router.post("/channel-service-orders/{order_id}/recharge")
  1710. async def create_recharge_txn(
  1711. order_id: str,
  1712. body: TxnRechargeBody,
  1713. user: dict = Depends(require_admin_or_super_admin),
  1714. db: Session = Depends(get_db),
  1715. ):
  1716. try:
  1717. tenant_no = _get_tenant_no(db, user)
  1718. txn = ps_svc.create_recharge_txn(
  1719. db,
  1720. order_id,
  1721. amount=body.amount,
  1722. remark=body.remark,
  1723. finance_submit_attachments=body.finance_submit_attachments,
  1724. tenant_no=tenant_no,
  1725. user_id=user.get("user_id"),
  1726. )
  1727. return success_response(
  1728. ps_svc._row_to_dict_service_order_txn(txn, db, tenant_no), message="充值流水创建成功"
  1729. )
  1730. except ValueError as e:
  1731. return error_response(400, str(e))
  1732. @router.post("/channel-service-orders/{order_id}/refund")
  1733. async def create_refund_txn(
  1734. order_id: str,
  1735. body: TxnRefundBody,
  1736. user: dict = Depends(require_admin_or_super_admin),
  1737. db: Session = Depends(get_db),
  1738. ):
  1739. try:
  1740. tenant_no = _get_tenant_no(db, user)
  1741. txn = ps_svc.create_refund_txn(
  1742. db,
  1743. order_id,
  1744. amount=body.amount,
  1745. remark=body.remark,
  1746. attachments=body.attachments,
  1747. tenant_no=tenant_no,
  1748. user_id=user.get("user_id"),
  1749. )
  1750. return success_response(
  1751. ps_svc._row_to_dict_service_order_txn(txn, db, tenant_no), message="退款流水创建成功"
  1752. )
  1753. except ValueError as e:
  1754. return error_response(400, str(e))
  1755. @router.post("/channel-service-orders/{order_id}/purchase")
  1756. async def create_purchase_txn(
  1757. order_id: str,
  1758. body: TxnPurchaseBody,
  1759. user: dict = Depends(require_admin_or_super_admin),
  1760. db: Session = Depends(get_db),
  1761. ):
  1762. try:
  1763. tenant_no = _get_tenant_no(db, user)
  1764. products_data = [p.model_dump(by_alias=False) for p in body.products]
  1765. txn = ps_svc.create_purchase_txn(
  1766. db,
  1767. order_id,
  1768. products=products_data,
  1769. remark=body.remark,
  1770. tenant_no=tenant_no,
  1771. user_id=user.get("user_id"),
  1772. )
  1773. return success_response(
  1774. ps_svc._row_to_dict_service_order_txn(txn, db, tenant_no), message="购买产品流水创建成功"
  1775. )
  1776. except ValueError as e:
  1777. return error_response(400, str(e))
  1778. @router.post("/channel-service-orders/{order_id}/unsubscribe")
  1779. async def create_unsubscribe_txn(
  1780. order_id: str,
  1781. body: TxnUnsubscribeBody,
  1782. user: dict = Depends(require_admin_or_super_admin),
  1783. db: Session = Depends(get_db),
  1784. ):
  1785. try:
  1786. tenant_no = _get_tenant_no(db, user)
  1787. products_data = [p.model_dump(by_alias=False) for p in body.products]
  1788. txn = ps_svc.create_unsubscribe_txn(
  1789. db,
  1790. order_id,
  1791. products=products_data,
  1792. remark=body.remark,
  1793. tenant_no=tenant_no,
  1794. user_id=user.get("user_id"),
  1795. )
  1796. return success_response(
  1797. ps_svc._row_to_dict_service_order_txn(txn, db, tenant_no), message="退订产品流水创建成功"
  1798. )
  1799. except ValueError as e:
  1800. return error_response(400, str(e))
  1801. @router.put("/channel-service-order-txns/{txn_id}")
  1802. async def update_service_order_txn(
  1803. txn_id: str,
  1804. body: TxnUpdateBody,
  1805. user: dict = Depends(require_admin_or_super_admin),
  1806. db: Session = Depends(get_db),
  1807. ):
  1808. try:
  1809. tenant_no = _get_tenant_no(db, user)
  1810. products_data = None
  1811. if body.products is not None:
  1812. products_data = [p.model_dump(by_alias=False) for p in body.products]
  1813. txn = ps_svc.update_service_order_txn(
  1814. db,
  1815. txn_id,
  1816. amount=body.amount,
  1817. remark=body.remark,
  1818. finance_submit_attachments=body.finance_submit_attachments,
  1819. refund_attachments=body.refund_attachments,
  1820. products=products_data,
  1821. tenant_no=tenant_no,
  1822. user_id=user.get("user_id"),
  1823. )
  1824. return success_response(
  1825. ps_svc._row_to_dict_service_order_txn(txn, db, tenant_no), message="更新成功"
  1826. )
  1827. except ValueError as e:
  1828. return error_response(400, str(e))
  1829. @router.post("/channel-service-order-txns/{txn_id}/submit-finance")
  1830. async def submit_txn_finance(
  1831. txn_id: str,
  1832. body: TxnFinanceSubmitBody,
  1833. user: dict = Depends(require_admin_or_super_admin),
  1834. db: Session = Depends(get_db),
  1835. ):
  1836. try:
  1837. tenant_no = _get_tenant_no(db, user)
  1838. txn = ps_svc.submit_txn_finance(
  1839. db,
  1840. txn_id,
  1841. finance_submit_remark=body.finance_submit_remark,
  1842. finance_submit_attachments=body.finance_submit_attachments,
  1843. tenant_no=tenant_no,
  1844. user_id=user.get("user_id"),
  1845. )
  1846. return success_response(
  1847. ps_svc._row_to_dict_service_order_txn(txn, db, tenant_no), message="已发起财务确认"
  1848. )
  1849. except ValueError as e:
  1850. return error_response(400, str(e))
  1851. @router.post("/channel-service-order-txns/{txn_id}/confirm")
  1852. async def confirm_txn(
  1853. txn_id: str,
  1854. body: TxnFinanceConfirmBody,
  1855. user: dict = Depends(require_admin_or_super_admin),
  1856. db: Session = Depends(get_db),
  1857. ):
  1858. try:
  1859. tenant_no = _get_tenant_no(db, user)
  1860. txn = ps_svc.confirm_txn(
  1861. db,
  1862. txn_id,
  1863. finance_remark=body.finance_remark,
  1864. finance_confirm_attachments=body.finance_confirm_attachments,
  1865. tenant_no=tenant_no,
  1866. user_id=user.get("user_id"),
  1867. )
  1868. return success_response(
  1869. ps_svc._service_order_txn_to_response_dict(db, txn, tenant_no),
  1870. message="财务确认成功",
  1871. )
  1872. except ValueError as e:
  1873. return error_response(400, str(e))
  1874. @router.put("/channel-service-order-txns/{txn_id}/void")
  1875. async def void_txn(
  1876. txn_id: str,
  1877. user: dict = Depends(require_admin_or_super_admin),
  1878. db: Session = Depends(get_db),
  1879. ):
  1880. try:
  1881. tenant_no = _get_tenant_no(db, user)
  1882. txn = ps_svc.void_txn(
  1883. db,
  1884. txn_id,
  1885. tenant_no=tenant_no,
  1886. user_id=user.get("user_id"),
  1887. )
  1888. return success_response(
  1889. ps_svc._service_order_txn_to_response_dict(db, txn, tenant_no),
  1890. message="作废成功",
  1891. )
  1892. except ValueError as e:
  1893. return error_response(400, str(e))
  1894. @router.get("/channels/{channel_id}/account")
  1895. async def get_channel_account_info(
  1896. channel_id: str,
  1897. user: dict = Depends(require_admin_or_super_admin),
  1898. db: Session = Depends(get_db),
  1899. ):
  1900. try:
  1901. tenant_no = _get_tenant_no(db, user)
  1902. account = ps_svc.get_channel_account(db, channel_id, tenant_no=tenant_no)
  1903. if not account:
  1904. return success_response({"channelId": channel_id, "balanceAmount": 0.0})
  1905. return success_response(ps_svc._row_to_dict_channel_account(account))
  1906. except ValueError as e:
  1907. return error_response(400, str(e))
  1908. @router.get("/channels/{channel_id}/product-quotas")
  1909. async def list_channel_product_quotas(
  1910. channel_id: str,
  1911. user: dict = Depends(require_admin_or_super_admin),
  1912. db: Session = Depends(get_db),
  1913. ):
  1914. try:
  1915. tenant_no = _get_tenant_no(db, user)
  1916. items = ps_svc.list_channel_product_quotas(db, channel_id, tenant_no=tenant_no)
  1917. return success_response(items)
  1918. except ValueError as e:
  1919. return error_response(400, str(e))
  1920. # --- 体检机构项目套餐 ---
  1921. class CheckupPackageItemBody(BaseModel):
  1922. model_config = ConfigDict(populate_by_name=True)
  1923. checkup_institution_project_id: str = Field(..., alias="checkupInstitutionProjectId")
  1924. project_name: Optional[str] = Field(None, alias="projectName")
  1925. project_fee: Optional[float] = Field(None, alias="projectFee")
  1926. order_num: Optional[int] = Field(None, alias="orderNum")
  1927. remark: Optional[str] = None
  1928. class CheckupInstitutionPackageCreateBody(BaseModel):
  1929. model_config = ConfigDict(populate_by_name=True)
  1930. package_name: str = Field(..., alias="packageName")
  1931. package_code: str = Field(..., alias="packageCode")
  1932. status: Optional[str] = Field("1", alias="status")
  1933. order_num: Optional[int] = Field(0, alias="orderNum")
  1934. remark: Optional[str] = None
  1935. items: List[CheckupPackageItemBody] = Field(default_factory=list)
  1936. class CheckupInstitutionPackageUpdateBody(BaseModel):
  1937. model_config = ConfigDict(populate_by_name=True)
  1938. package_name: Optional[str] = Field(None, alias="packageName")
  1939. package_code: Optional[str] = Field(None, alias="packageCode")
  1940. status: Optional[str] = Field(None, alias="status")
  1941. order_num: Optional[int] = Field(None, alias="orderNum")
  1942. remark: Optional[str] = None
  1943. items: Optional[List[CheckupPackageItemBody]] = None
  1944. def _package_items_to_crud(items) -> List[dict]:
  1945. out = []
  1946. for x in items:
  1947. if isinstance(x, dict):
  1948. out.append(
  1949. {
  1950. "checkup_institution_project_id": x.get("checkup_institution_project_id")
  1951. or x.get("checkupInstitutionProjectId"),
  1952. "project_name": x.get("project_name") or x.get("projectName"),
  1953. "project_fee": x.get("project_fee") if x.get("project_fee") is not None else x.get("projectFee"),
  1954. "order_num": x.get("order_num") if x.get("order_num") is not None else x.get("orderNum"),
  1955. "remark": x.get("remark"),
  1956. }
  1957. )
  1958. else:
  1959. out.append(
  1960. {
  1961. "checkup_institution_project_id": x.checkup_institution_project_id,
  1962. "project_name": x.project_name,
  1963. "project_fee": x.project_fee,
  1964. "order_num": x.order_num,
  1965. "remark": x.remark,
  1966. }
  1967. )
  1968. return out
  1969. @router.get("/checkup-institutions/{institution_id}/packages")
  1970. async def list_checkup_institution_packages(
  1971. institution_id: str,
  1972. user: dict = Depends(require_admin_or_super_admin),
  1973. db: Session = Depends(get_db),
  1974. ):
  1975. try:
  1976. tenant_no = _get_tenant_no(db, user)
  1977. items = ps_svc.list_checkup_institution_packages(db, institution_id, tenant_no=tenant_no, user_info=user)
  1978. return success_response(items)
  1979. except ValueError as e:
  1980. return error_response(400, str(e))
  1981. @router.post("/checkup-institutions/{institution_id}/packages")
  1982. async def create_checkup_institution_package(
  1983. institution_id: str,
  1984. body: CheckupInstitutionPackageCreateBody,
  1985. user: dict = Depends(require_admin_or_super_admin),
  1986. db: Session = Depends(get_db),
  1987. ):
  1988. try:
  1989. tenant_no = _get_tenant_no(db, user)
  1990. detail = ps_svc.create_checkup_institution_package(
  1991. db,
  1992. checkup_institution_id=institution_id,
  1993. package_name=body.package_name,
  1994. package_code=body.package_code,
  1995. status=body.status,
  1996. items=_package_items_to_crud(body.items),
  1997. tenant_no=tenant_no,
  1998. order_num=body.order_num,
  1999. remark=body.remark,
  2000. user_id=user.get("user_id"),
  2001. )
  2002. return success_response(detail, message="创建成功")
  2003. except ValueError as e:
  2004. return error_response(400, str(e))
  2005. @router.get("/checkup-institution-packages/{package_id}")
  2006. async def get_checkup_institution_package_detail(
  2007. package_id: str,
  2008. user: dict = Depends(require_admin_or_super_admin),
  2009. db: Session = Depends(get_db),
  2010. ):
  2011. try:
  2012. tenant_no = _get_tenant_no(db, user)
  2013. detail = ps_svc.get_checkup_institution_package_detail(db, package_id, tenant_no=tenant_no)
  2014. if not detail:
  2015. return error_response(404, "记录不存在")
  2016. return success_response(detail)
  2017. except ValueError as e:
  2018. return error_response(400, str(e))
  2019. @router.put("/checkup-institution-packages/{package_id}")
  2020. async def update_checkup_institution_package(
  2021. package_id: str,
  2022. body: CheckupInstitutionPackageUpdateBody,
  2023. user: dict = Depends(require_admin_or_super_admin),
  2024. db: Session = Depends(get_db),
  2025. ):
  2026. try:
  2027. tenant_no = _get_tenant_no(db, user)
  2028. payload = body.model_dump(exclude_unset=True, by_alias=False)
  2029. items_raw = payload.pop("items", None)
  2030. items = _package_items_to_crud(items_raw) if items_raw is not None else None
  2031. detail = ps_svc.update_checkup_institution_package(
  2032. db,
  2033. package_id,
  2034. package_name=payload.get("package_name"),
  2035. package_code=payload.get("package_code"),
  2036. status=payload.get("status"),
  2037. items=items,
  2038. order_num=payload.get("order_num"),
  2039. remark=payload.get("remark"),
  2040. user_id=user.get("user_id"),
  2041. tenant_no=tenant_no,
  2042. )
  2043. return success_response(detail, message="更新成功")
  2044. except ValueError as e:
  2045. return error_response(400, str(e))
  2046. @router.delete("/checkup-institution-packages/{package_id}")
  2047. async def delete_checkup_institution_package(
  2048. package_id: str,
  2049. user: dict = Depends(require_admin_or_super_admin),
  2050. db: Session = Depends(get_db),
  2051. ):
  2052. try:
  2053. tenant_no = _get_tenant_no(db, user)
  2054. ps_svc.soft_delete_checkup_institution_package(db, package_id, tenant_no=tenant_no)
  2055. return success_response(None, message="删除成功")
  2056. except ValueError as e:
  2057. return error_response(400, str(e))