| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392 |
- """中试服务管理 API(细胞产品类型/规格/价格体系/项目价格、渠道信息、体检机构)"""
- from typing import Any, List, Optional
- from fastapi import APIRouter, Depends, Query
- from pydantic import BaseModel, ConfigDict, Field
- from sqlalchemy.orm import Session
- from app.core.database import get_db
- from app.core.menu_guard import require_admin_or_super_admin
- from app.core.response import error_response, success_response
- from app.crud import pilot_service as ps_svc
- from app.models.models import SysUser
- router = APIRouter(prefix="/web/admin", tags=["中试服务管理"])
- def _get_tenant_no(db: Session, user: dict) -> str:
- user_id = user.get("user_id")
- if not user_id:
- raise PermissionError("用户身份信息缺失,无法确定租户")
- sys_user = db.query(SysUser).filter(SysUser.id == user_id).first()
- if not sys_user or not sys_user.tenant_no:
- raise PermissionError("用户租户信息缺失")
- return sys_user.tenant_no
- # ---------------------------------------------------------------------------
- # 1. 细胞产品类型
- # ---------------------------------------------------------------------------
- class CellProductTypeCreateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- product_type_code: str = Field(..., alias="productTypeCode")
- product_type_name: str = Field(..., alias="productTypeName")
- order_num: Optional[int] = Field(0, alias="orderNum")
- remark: Optional[str] = None
- class CellProductTypeUpdateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- product_type_code: Optional[str] = Field(None, alias="productTypeCode")
- product_type_name: Optional[str] = Field(None, alias="productTypeName")
- order_num: Optional[int] = Field(None, alias="orderNum")
- remark: Optional[str] = None
- @router.get("/cell-product-types")
- async def list_cell_product_types(
- page: int = Query(1, ge=1),
- pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
- keyword: Optional[str] = None,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- tenant_no = _get_tenant_no(db, user)
- items, total = ps_svc.list_cell_product_types(
- db, page=page, page_size=pageSize, keyword=keyword, tenant_no=tenant_no, user_info=user
- )
- tp = ps_svc.total_pages(total, pageSize)
- return success_response(
- {"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp}
- )
- @router.post("/cell-product-types")
- async def create_cell_product_type(
- body: CellProductTypeCreateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- obj = ps_svc.create_cell_product_type(
- db,
- product_type_code=body.product_type_code,
- product_type_name=body.product_type_name,
- tenant_no=tenant_no,
- order_num=body.order_num,
- remark=body.remark,
- user_id=user.get("user_id"),
- )
- return success_response(ps_svc._row_to_dict_cell_product_type(obj), message="创建成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.put("/cell-product-types/{row_id}")
- async def update_cell_product_type(
- row_id: str,
- body: CellProductTypeUpdateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
- obj = ps_svc.update_cell_product_type(
- db,
- row_id,
- product_type_code=payload.get("product_type_code"),
- product_type_name=payload.get("product_type_name"),
- order_num=payload.get("order_num"),
- remark=payload.get("remark"),
- user_id=user.get("user_id"),
- tenant_no=tenant_no,
- )
- return success_response(ps_svc._row_to_dict_cell_product_type(obj), message="更新成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.delete("/cell-product-types/{row_id}")
- async def delete_cell_product_type(
- row_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- ps_svc.soft_delete_cell_product_type(db, row_id, tenant_no=tenant_no)
- return success_response(None, message="删除成功")
- except ValueError as e:
- return error_response(400, str(e))
- # ---------------------------------------------------------------------------
- # 2. 细胞产品规格
- # ---------------------------------------------------------------------------
- class CellProductSpecCreateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- spec_code: str = Field(..., alias="specCode")
- spec_name: str = Field(..., alias="specName")
- order_num: Optional[int] = Field(0, alias="orderNum")
- remark: Optional[str] = None
- class CellProductSpecUpdateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- spec_code: Optional[str] = Field(None, alias="specCode")
- spec_name: Optional[str] = Field(None, alias="specName")
- order_num: Optional[int] = Field(None, alias="orderNum")
- remark: Optional[str] = None
- @router.get("/cell-product-specs")
- async def list_cell_product_specs(
- page: int = Query(1, ge=1),
- pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
- keyword: Optional[str] = None,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- tenant_no = _get_tenant_no(db, user)
- items, total = ps_svc.list_cell_product_specs(
- db, page=page, page_size=pageSize, keyword=keyword, tenant_no=tenant_no, user_info=user
- )
- tp = ps_svc.total_pages(total, pageSize)
- return success_response(
- {"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp}
- )
- @router.post("/cell-product-specs")
- async def create_cell_product_spec(
- body: CellProductSpecCreateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- obj = ps_svc.create_cell_product_spec(
- db,
- spec_code=body.spec_code,
- spec_name=body.spec_name,
- tenant_no=tenant_no,
- order_num=body.order_num,
- remark=body.remark,
- user_id=user.get("user_id"),
- )
- return success_response(ps_svc._row_to_dict_cell_product_spec(obj), message="创建成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.put("/cell-product-specs/{row_id}")
- async def update_cell_product_spec(
- row_id: str,
- body: CellProductSpecUpdateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
- obj = ps_svc.update_cell_product_spec(
- db,
- row_id,
- spec_code=payload.get("spec_code"),
- spec_name=payload.get("spec_name"),
- order_num=payload.get("order_num"),
- remark=payload.get("remark"),
- user_id=user.get("user_id"),
- tenant_no=tenant_no,
- )
- return success_response(ps_svc._row_to_dict_cell_product_spec(obj), message="更新成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.delete("/cell-product-specs/{row_id}")
- async def delete_cell_product_spec(
- row_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- ps_svc.soft_delete_cell_product_spec(db, row_id, tenant_no=tenant_no)
- return success_response(None, message="删除成功")
- except ValueError as e:
- return error_response(400, str(e))
- # ---------------------------------------------------------------------------
- # 3. 细胞产品价格
- # ---------------------------------------------------------------------------
- class CellProductPriceCreateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- project_name: str = Field(..., alias="projectName")
- project_code: str = Field(..., alias="projectCode")
- cell_type_code: Optional[str] = Field(None, alias="cellTypeCode")
- cell_type_name: Optional[str] = Field(None, alias="cellTypeName")
- spec_text: Optional[str] = Field(None, alias="specText")
- spec_id: Optional[str] = Field(None, alias="specId")
- cell_product_type_id: Optional[str] = Field(None, alias="cellProductTypeId")
- unit_price: Optional[float] = Field(None, alias="unitPrice")
- order_num: Optional[int] = Field(0, alias="orderNum")
- remark: Optional[str] = None
- class CellProductPriceUpdateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- project_name: Optional[str] = Field(None, alias="projectName")
- project_code: Optional[str] = Field(None, alias="projectCode")
- cell_type_code: Optional[str] = Field(None, alias="cellTypeCode")
- cell_type_name: Optional[str] = Field(None, alias="cellTypeName")
- spec_text: Optional[str] = Field(None, alias="specText")
- spec_id: Optional[str] = Field(None, alias="specId")
- cell_product_type_id: Optional[str] = Field(None, alias="cellProductTypeId")
- unit_price: Optional[float] = Field(None, alias="unitPrice")
- order_num: Optional[int] = Field(None, alias="orderNum")
- remark: Optional[str] = None
- @router.get("/cell-product-prices")
- async def list_cell_product_prices(
- page: int = Query(1, ge=1),
- pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
- keyword: Optional[str] = None,
- cell_product_type_id: Optional[str] = Query(None, alias="cellProductTypeId"),
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- tenant_no = _get_tenant_no(db, user)
- items, total = ps_svc.list_cell_product_prices(
- db,
- page=page,
- page_size=pageSize,
- keyword=keyword,
- tenant_no=tenant_no,
- cell_product_type_id=cell_product_type_id,
- user_info=user,
- )
- tp = ps_svc.total_pages(total, pageSize)
- return success_response(
- {"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp}
- )
- @router.post("/cell-product-prices")
- async def create_cell_product_price(
- body: CellProductPriceCreateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- obj = ps_svc.create_cell_product_price(
- db,
- project_name=body.project_name,
- project_code=body.project_code,
- cell_type_code=body.cell_type_code or "",
- cell_type_name=body.cell_type_name or "",
- spec_text=body.spec_text or "",
- spec_id=body.spec_id or "",
- cell_product_type_id=body.cell_product_type_id or "",
- unit_price=body.unit_price,
- tenant_no=tenant_no,
- order_num=body.order_num,
- remark=body.remark,
- user_id=user.get("user_id"),
- )
- return success_response(ps_svc._row_to_dict_cell_product_price(obj), message="创建成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.put("/cell-product-prices/{row_id}")
- async def update_cell_product_price(
- row_id: str,
- body: CellProductPriceUpdateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
- obj = ps_svc.update_cell_product_price(
- db,
- row_id,
- project_name=payload.get("project_name"),
- project_code=payload.get("project_code"),
- cell_type_code=payload.get("cell_type_code"),
- cell_type_name=payload.get("cell_type_name"),
- spec_text=payload.get("spec_text"),
- spec_id=payload.get("spec_id"),
- cell_product_type_id=payload.get("cell_product_type_id"),
- unit_price=payload.get("unit_price"),
- order_num=payload.get("order_num"),
- remark=payload.get("remark"),
- user_id=user.get("user_id"),
- tenant_no=tenant_no,
- )
- return success_response(ps_svc._row_to_dict_cell_product_price(obj), message="更新成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.delete("/cell-product-prices/{row_id}")
- async def delete_cell_product_price(
- row_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- ps_svc.soft_delete_cell_product_price(db, row_id, tenant_no=tenant_no)
- return success_response(None, message="删除成功")
- except ValueError as e:
- return error_response(400, str(e))
- # ---------------------------------------------------------------------------
- # 4. 项目价格体系(主表 + 明细子表)
- # ---------------------------------------------------------------------------
- class ProjectSystemCreateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- system_name: str = Field(..., alias="systemName")
- system_code: str = Field(..., alias="systemCode")
- status: Optional[str] = Field("1", alias="status")
- order_num: Optional[int] = Field(0, alias="orderNum")
- remark: Optional[str] = None
- class ProjectSystemUpdateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- system_name: Optional[str] = Field(None, alias="systemName")
- system_code: Optional[str] = Field(None, alias="systemCode")
- status: Optional[str] = Field(None, alias="status")
- order_num: Optional[int] = Field(None, alias="orderNum")
- remark: Optional[str] = None
- @router.get("/project-price-systems")
- async def list_project_systems(
- page: int = Query(1, ge=1),
- pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
- keyword: Optional[str] = None,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- tenant_no = _get_tenant_no(db, user)
- items, total = ps_svc.list_project_systems(
- db, page=page, page_size=pageSize, keyword=keyword, tenant_no=tenant_no, user_info=user
- )
- tp = ps_svc.total_pages(total, pageSize)
- return success_response(
- {"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp}
- )
- @router.post("/project-price-systems")
- async def create_project_system(
- body: ProjectSystemCreateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- obj = ps_svc.create_project_system(
- db,
- system_name=body.system_name,
- system_code=body.system_code,
- status=body.status,
- tenant_no=tenant_no,
- order_num=body.order_num,
- remark=body.remark,
- user_id=user.get("user_id"),
- )
- return success_response(ps_svc._row_to_dict_project_system(obj), message="创建成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.put("/project-price-systems/{row_id}")
- async def update_project_system(
- row_id: str,
- body: ProjectSystemUpdateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
- obj = ps_svc.update_project_system(
- db,
- row_id,
- system_name=payload.get("system_name"),
- system_code=payload.get("system_code"),
- status=payload.get("status"),
- order_num=payload.get("order_num"),
- remark=payload.get("remark"),
- user_id=user.get("user_id"),
- tenant_no=tenant_no,
- )
- return success_response(ps_svc._row_to_dict_project_system(obj), message="更新成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.delete("/project-price-systems/{row_id}")
- async def delete_project_system(
- row_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- ps_svc.soft_delete_project_system(db, row_id, tenant_no=tenant_no)
- return success_response(None, message="删除成功")
- except ValueError as e:
- return error_response(400, str(e))
- # --- 项目价格体系明细 ---
- class ProjectSystemItemCreateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- source_price_id: Optional[str] = Field(None, alias="sourcePriceId")
- project_name: str = Field(..., alias="projectName")
- project_code: str = Field(..., alias="projectCode")
- cell_type_code: Optional[str] = Field(None, alias="cellTypeCode")
- cell_type_name: Optional[str] = Field(None, alias="cellTypeName")
- spec_text: Optional[str] = Field(None, alias="specText")
- spec_id: Optional[str] = Field(None, alias="specId")
- cell_product_type_id: Optional[str] = Field(None, alias="cellProductTypeId")
- unit_price: Optional[float] = Field(None, alias="unitPrice")
- order_num: Optional[int] = Field(0, alias="orderNum")
- remark: Optional[str] = None
- class ProjectSystemItemUpdateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- source_price_id: Optional[str] = Field(None, alias="sourcePriceId")
- project_name: Optional[str] = Field(None, alias="projectName")
- project_code: Optional[str] = Field(None, alias="projectCode")
- cell_type_code: Optional[str] = Field(None, alias="cellTypeCode")
- cell_type_name: Optional[str] = Field(None, alias="cellTypeName")
- spec_text: Optional[str] = Field(None, alias="specText")
- spec_id: Optional[str] = Field(None, alias="specId")
- cell_product_type_id: Optional[str] = Field(None, alias="cellProductTypeId")
- unit_price: Optional[float] = Field(None, alias="unitPrice")
- order_num: Optional[int] = Field(None, alias="orderNum")
- remark: Optional[str] = None
- @router.get("/project-price-systems/{system_id}/items")
- async def list_project_system_items(
- system_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- items = ps_svc.list_project_system_items(db, system_id, tenant_no=tenant_no, user_info=user)
- return success_response(items)
- except ValueError as e:
- return error_response(400, str(e))
- @router.post("/project-price-systems/{system_id}/items")
- async def create_project_system_item(
- system_id: str,
- body: ProjectSystemItemCreateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- obj = ps_svc.create_project_system_item(
- db,
- project_system_id=system_id,
- source_price_id=body.source_price_id or "",
- project_name=body.project_name,
- project_code=body.project_code,
- cell_type_code=body.cell_type_code or "",
- cell_type_name=body.cell_type_name or "",
- spec_text=body.spec_text or "",
- spec_id=body.spec_id or "",
- cell_product_type_id=body.cell_product_type_id or "",
- unit_price=body.unit_price,
- tenant_no=tenant_no,
- order_num=body.order_num,
- remark=body.remark,
- user_id=user.get("user_id"),
- )
- return success_response(ps_svc._row_to_dict_project_system_item(obj), message="创建成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.put("/project-system-items/{item_id}")
- async def update_project_system_item(
- item_id: str,
- body: ProjectSystemItemUpdateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
- obj = ps_svc.update_project_system_item(
- db,
- item_id,
- source_price_id=payload.get("source_price_id"),
- project_name=payload.get("project_name"),
- project_code=payload.get("project_code"),
- cell_type_code=payload.get("cell_type_code"),
- cell_type_name=payload.get("cell_type_name"),
- spec_text=payload.get("spec_text"),
- spec_id=payload.get("spec_id"),
- cell_product_type_id=payload.get("cell_product_type_id"),
- unit_price=payload.get("unit_price"),
- order_num=payload.get("order_num"),
- remark=payload.get("remark"),
- user_id=user.get("user_id"),
- tenant_no=tenant_no,
- )
- return success_response(ps_svc._row_to_dict_project_system_item(obj), message="更新成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.delete("/project-system-items/{item_id}")
- async def delete_project_system_item(
- item_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- ps_svc.soft_delete_project_system_item(db, item_id, tenant_no=tenant_no)
- return success_response(None, message="删除成功")
- except ValueError as e:
- return error_response(400, str(e))
- # ---------------------------------------------------------------------------
- # 5. 渠道信息(主表 + 开票/邮寄地址/协议/协议产品价格子表)
- # ---------------------------------------------------------------------------
- class ChannelCreateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- channel_name: str = Field(..., alias="channelName")
- credit_code: Optional[str] = Field(None, alias="creditCode")
- channel_type: Optional[str] = Field(None, alias="channelType")
- contact_name: Optional[str] = Field(None, alias="contactName")
- contact_phone: Optional[str] = Field(None, alias="contactPhone")
- contact_email: Optional[str] = Field(None, alias="contactEmail")
- protocol_attachments: Optional[str] = Field(None, alias="protocolAttachments")
- order_num: Optional[int] = Field(0, alias="orderNum")
- remark: Optional[str] = None
- class ChannelUpdateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- channel_name: Optional[str] = Field(None, alias="channelName")
- credit_code: Optional[str] = Field(None, alias="creditCode")
- channel_type: Optional[str] = Field(None, alias="channelType")
- contact_name: Optional[str] = Field(None, alias="contactName")
- contact_phone: Optional[str] = Field(None, alias="contactPhone")
- contact_email: Optional[str] = Field(None, alias="contactEmail")
- protocol_attachments: Optional[str] = Field(None, alias="protocolAttachments")
- order_num: Optional[int] = Field(None, alias="orderNum")
- remark: Optional[str] = None
- @router.get("/channels")
- async def list_channels(
- page: int = Query(1, ge=1),
- pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
- keyword: Optional[str] = None,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- tenant_no = _get_tenant_no(db, user)
- items, total = ps_svc.list_channels(
- db, page=page, page_size=pageSize, keyword=keyword, tenant_no=tenant_no, user_info=user
- )
- tp = ps_svc.total_pages(total, pageSize)
- return success_response(
- {"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp}
- )
- @router.post("/channels")
- async def create_channel(
- body: ChannelCreateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- obj = ps_svc.create_channel(
- db,
- channel_name=body.channel_name,
- credit_code=body.credit_code,
- channel_type=body.channel_type,
- contact_name=body.contact_name,
- contact_phone=body.contact_phone,
- contact_email=body.contact_email,
- protocol_attachments=body.protocol_attachments,
- tenant_no=tenant_no,
- order_num=body.order_num,
- remark=body.remark,
- user_id=user.get("user_id"),
- )
- return success_response(
- ps_svc._row_to_dict_channel(obj, db, tenant_no),
- message="创建成功",
- )
- except ValueError as e:
- return error_response(400, str(e))
- @router.put("/channels/{row_id}")
- async def update_channel(
- row_id: str,
- body: ChannelUpdateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
- obj = ps_svc.update_channel(
- db,
- row_id,
- channel_name=payload.get("channel_name"),
- credit_code=payload.get("credit_code"),
- channel_type=payload.get("channel_type"),
- contact_name=payload.get("contact_name"),
- contact_phone=payload.get("contact_phone"),
- contact_email=payload.get("contact_email"),
- protocol_attachments=payload.get("protocol_attachments"),
- order_num=payload.get("order_num"),
- remark=payload.get("remark"),
- user_id=user.get("user_id"),
- tenant_no=tenant_no,
- )
- return success_response(
- ps_svc._row_to_dict_channel(obj, db, tenant_no),
- message="更新成功",
- )
- except ValueError as e:
- return error_response(400, str(e))
- @router.delete("/channels/{row_id}")
- async def delete_channel(
- row_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- ps_svc.soft_delete_channel(db, row_id, tenant_no=tenant_no)
- return success_response(None, message="删除成功")
- except ValueError as e:
- return error_response(400, str(e))
- # --- 渠道开票信息 ---
- class ChannelInvoiceCreateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- company_name: str = Field(..., alias="companyName")
- tax_no: Optional[str] = Field(None, alias="taxNo")
- company_address: Optional[str] = Field(None, alias="companyAddress")
- company_phone: Optional[str] = Field(None, alias="companyPhone")
- bank_name: Optional[str] = Field(None, alias="bankName")
- bank_account: Optional[str] = Field(None, alias="bankAccount")
- order_num: Optional[int] = Field(0, alias="orderNum")
- remark: Optional[str] = None
- class ChannelInvoiceUpdateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- company_name: Optional[str] = Field(None, alias="companyName")
- tax_no: Optional[str] = Field(None, alias="taxNo")
- company_address: Optional[str] = Field(None, alias="companyAddress")
- company_phone: Optional[str] = Field(None, alias="companyPhone")
- bank_name: Optional[str] = Field(None, alias="bankName")
- bank_account: Optional[str] = Field(None, alias="bankAccount")
- order_num: Optional[int] = Field(None, alias="orderNum")
- remark: Optional[str] = None
- @router.get("/channels/{channel_id}/invoices")
- async def list_channel_invoices(
- channel_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- items = ps_svc.list_channel_invoices(db, channel_id, tenant_no=tenant_no, user_info=user)
- return success_response(items)
- except ValueError as e:
- return error_response(400, str(e))
- @router.post("/channels/{channel_id}/invoices")
- async def create_channel_invoice(
- channel_id: str,
- body: ChannelInvoiceCreateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- obj = ps_svc.create_channel_invoice(
- db,
- channel_id=channel_id,
- company_name=body.company_name,
- tax_no=body.tax_no,
- company_address=body.company_address,
- company_phone=body.company_phone,
- bank_name=body.bank_name,
- bank_account=body.bank_account,
- tenant_no=tenant_no,
- order_num=body.order_num,
- remark=body.remark,
- user_id=user.get("user_id"),
- )
- return success_response(ps_svc._row_to_dict_channel_invoice(obj), message="创建成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.put("/channel-invoices/{invoice_id}")
- async def update_channel_invoice(
- invoice_id: str,
- body: ChannelInvoiceUpdateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
- obj = ps_svc.update_channel_invoice(
- db,
- invoice_id,
- company_name=payload.get("company_name"),
- tax_no=payload.get("tax_no"),
- company_address=payload.get("company_address"),
- company_phone=payload.get("company_phone"),
- bank_name=payload.get("bank_name"),
- bank_account=payload.get("bank_account"),
- order_num=payload.get("order_num"),
- remark=payload.get("remark"),
- user_id=user.get("user_id"),
- tenant_no=tenant_no,
- )
- return success_response(ps_svc._row_to_dict_channel_invoice(obj), message="更新成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.delete("/channel-invoices/{invoice_id}")
- async def delete_channel_invoice(
- invoice_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- ps_svc.soft_delete_channel_invoice(db, invoice_id, tenant_no=tenant_no)
- return success_response(None, message="删除成功")
- except ValueError as e:
- return error_response(400, str(e))
- # --- 渠道邮寄地址 ---
- class ChannelMailAddressCreateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- mail_address: str = Field(..., alias="mailAddress")
- mail_contact: Optional[str] = Field(None, alias="mailContact")
- mail_phone: Optional[str] = Field(None, alias="mailPhone")
- order_num: Optional[int] = Field(0, alias="orderNum")
- remark: Optional[str] = None
- class ChannelMailAddressUpdateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- mail_address: Optional[str] = Field(None, alias="mailAddress")
- mail_contact: Optional[str] = Field(None, alias="mailContact")
- mail_phone: Optional[str] = Field(None, alias="mailPhone")
- order_num: Optional[int] = Field(None, alias="orderNum")
- remark: Optional[str] = None
- @router.get("/channels/{channel_id}/mail-addresses")
- async def list_channel_mail_addresses(
- channel_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- items = ps_svc.list_channel_mail_addresses(db, channel_id, tenant_no=tenant_no, user_info=user)
- return success_response(items)
- except ValueError as e:
- return error_response(400, str(e))
- @router.post("/channels/{channel_id}/mail-addresses")
- async def create_channel_mail_address(
- channel_id: str,
- body: ChannelMailAddressCreateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- obj = ps_svc.create_channel_mail_address(
- db,
- channel_id=channel_id,
- mail_address=body.mail_address,
- mail_contact=body.mail_contact,
- mail_phone=body.mail_phone,
- tenant_no=tenant_no,
- order_num=body.order_num,
- remark=body.remark,
- user_id=user.get("user_id"),
- )
- return success_response(ps_svc._row_to_dict_channel_mail_address(obj), message="创建成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.put("/channel-mail-addresses/{address_id}")
- async def update_channel_mail_address(
- address_id: str,
- body: ChannelMailAddressUpdateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
- obj = ps_svc.update_channel_mail_address(
- db,
- address_id,
- mail_address=payload.get("mail_address"),
- mail_contact=payload.get("mail_contact"),
- mail_phone=payload.get("mail_phone"),
- order_num=payload.get("order_num"),
- remark=payload.get("remark"),
- user_id=user.get("user_id"),
- tenant_no=tenant_no,
- )
- return success_response(ps_svc._row_to_dict_channel_mail_address(obj), message="更新成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.delete("/channel-mail-addresses/{address_id}")
- async def delete_channel_mail_address(
- address_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- ps_svc.soft_delete_channel_mail_address(db, address_id, tenant_no=tenant_no)
- return success_response(None, message="删除成功")
- except ValueError as e:
- return error_response(400, str(e))
- # --- 渠道协议 ---
- class ChannelAgreementCreateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- agreement_type: str = Field(..., alias="agreementType")
- business_type: Optional[str] = Field(None, alias="businessType")
- settle_mode: Optional[str] = Field(None, alias="settleMode")
- credit_limit_amount: Optional[float] = Field(None, alias="creditLimitAmount")
- effective_date: Optional[str] = Field(None, alias="effectiveDate")
- expire_date: Optional[str] = Field(None, alias="expireDate")
- order_num: Optional[int] = Field(0, alias="orderNum")
- remark: Optional[str] = None
- class ChannelAgreementUpdateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- agreement_type: Optional[str] = Field(None, alias="agreementType")
- business_type: Optional[str] = Field(None, alias="businessType")
- settle_mode: Optional[str] = Field(None, alias="settleMode")
- credit_limit_amount: Optional[float] = Field(None, alias="creditLimitAmount")
- effective_date: Optional[str] = Field(None, alias="effectiveDate")
- expire_date: Optional[str] = Field(None, alias="expireDate")
- order_num: Optional[int] = Field(None, alias="orderNum")
- remark: Optional[str] = None
- @router.get("/channels/{channel_id}/agreements")
- async def list_channel_agreements(
- channel_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- items = ps_svc.list_channel_agreements(db, channel_id, tenant_no=tenant_no, user_info=user)
- return success_response(items)
- except ValueError as e:
- return error_response(400, str(e))
- @router.post("/channels/{channel_id}/agreements")
- async def create_channel_agreement(
- channel_id: str,
- body: ChannelAgreementCreateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- obj = ps_svc.create_channel_agreement(
- db,
- channel_id=channel_id,
- agreement_type=body.agreement_type,
- business_type=body.business_type,
- settle_mode=body.settle_mode,
- credit_limit_amount=body.credit_limit_amount,
- effective_date=body.effective_date,
- expire_date=body.expire_date,
- tenant_no=tenant_no,
- order_num=body.order_num,
- remark=body.remark,
- user_id=user.get("user_id"),
- )
- return success_response(ps_svc._row_to_dict_channel_agreement(obj), message="创建成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.put("/channel-agreements/{agreement_id}")
- async def update_channel_agreement(
- agreement_id: str,
- body: ChannelAgreementUpdateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
- obj = ps_svc.update_channel_agreement(
- db,
- agreement_id,
- agreement_type=payload.get("agreement_type"),
- business_type=payload.get("business_type"),
- settle_mode=payload.get("settle_mode"),
- credit_limit_amount=payload.get("credit_limit_amount"),
- effective_date=payload.get("effective_date"),
- expire_date=payload.get("expire_date"),
- order_num=payload.get("order_num"),
- remark=payload.get("remark"),
- user_id=user.get("user_id"),
- tenant_no=tenant_no,
- )
- return success_response(ps_svc._row_to_dict_channel_agreement(obj), message="更新成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.delete("/channel-agreements/{agreement_id}")
- async def delete_channel_agreement(
- agreement_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- ps_svc.soft_delete_channel_agreement(db, agreement_id, tenant_no=tenant_no)
- return success_response(None, message="删除成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.put("/channel-agreements/{agreement_id}/activate")
- async def activate_channel_agreement(
- agreement_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- obj = ps_svc.activate_channel_agreement(
- db,
- agreement_id,
- tenant_no=tenant_no,
- user_id=user.get("user_id"),
- )
- return success_response(ps_svc._row_to_dict_channel_agreement(obj), message="生效成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.put("/channel-agreements/{agreement_id}/void")
- async def void_channel_agreement(
- agreement_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- obj = ps_svc.void_channel_agreement(
- db,
- agreement_id,
- tenant_no=tenant_no,
- user_id=user.get("user_id"),
- )
- return success_response(ps_svc._row_to_dict_channel_agreement(obj), message="作废成功")
- except ValueError as e:
- return error_response(400, str(e))
- # --- 渠道协议产品价格 ---
- class ChannelAgreementPriceCreateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- project_name: Optional[str] = Field(None, alias="projectName")
- project_code: Optional[str] = Field(None, alias="projectCode")
- cell_type_code: Optional[str] = Field(None, alias="cellTypeCode")
- cell_type_name: Optional[str] = Field(None, alias="cellTypeName")
- spec_text: Optional[str] = Field(None, alias="specText")
- original_price: Optional[float] = Field(None, alias="originalPrice")
- agreement_price: Optional[float] = Field(None, alias="agreementPrice")
- order_num: Optional[int] = Field(0, alias="orderNum")
- remark: Optional[str] = None
- class ChannelAgreementPriceUpdateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- project_name: Optional[str] = Field(None, alias="projectName")
- project_code: Optional[str] = Field(None, alias="projectCode")
- cell_type_code: Optional[str] = Field(None, alias="cellTypeCode")
- cell_type_name: Optional[str] = Field(None, alias="cellTypeName")
- spec_text: Optional[str] = Field(None, alias="specText")
- original_price: Optional[float] = Field(None, alias="originalPrice")
- agreement_price: Optional[float] = Field(None, alias="agreementPrice")
- order_num: Optional[int] = Field(None, alias="orderNum")
- remark: Optional[str] = None
- @router.get("/channel-agreements/{agreement_id}/product-prices")
- async def list_channel_agreement_prices(
- agreement_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- items = ps_svc.list_channel_agreement_prices(db, agreement_id, tenant_no=tenant_no, user_info=user)
- return success_response(items)
- except ValueError as e:
- return error_response(400, str(e))
- @router.post("/channel-agreements/{agreement_id}/product-prices")
- async def create_channel_agreement_price(
- agreement_id: str,
- body: ChannelAgreementPriceCreateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- obj = ps_svc.create_channel_agreement_price(
- db,
- channel_agreement_id=agreement_id,
- project_name=body.project_name,
- project_code=body.project_code,
- cell_type_code=body.cell_type_code,
- cell_type_name=body.cell_type_name,
- spec_text=body.spec_text,
- original_price=body.original_price,
- agreement_price=body.agreement_price,
- tenant_no=tenant_no,
- order_num=body.order_num,
- remark=body.remark,
- user_id=user.get("user_id"),
- )
- return success_response(ps_svc._row_to_dict_channel_agreement_price(obj), message="创建成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.put("/channel-agreement-product-prices/{price_id}")
- async def update_channel_agreement_price(
- price_id: str,
- body: ChannelAgreementPriceUpdateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
- obj = ps_svc.update_channel_agreement_price(
- db,
- price_id,
- project_name=payload.get("project_name"),
- project_code=payload.get("project_code"),
- cell_type_code=payload.get("cell_type_code"),
- cell_type_name=payload.get("cell_type_name"),
- spec_text=payload.get("spec_text"),
- original_price=payload.get("original_price"),
- agreement_price=payload.get("agreement_price"),
- order_num=payload.get("order_num"),
- remark=payload.get("remark"),
- user_id=user.get("user_id"),
- tenant_no=tenant_no,
- )
- return success_response(ps_svc._row_to_dict_channel_agreement_price(obj), message="更新成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.delete("/channel-agreement-product-prices/{price_id}")
- async def delete_channel_agreement_price(
- price_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- ps_svc.soft_delete_channel_agreement_price(db, price_id, tenant_no=tenant_no)
- return success_response(None, message="删除成功")
- except ValueError as e:
- return error_response(400, str(e))
- # ---------------------------------------------------------------------------
- # 6. 体检机构(主表 + 开票信息/项目及价格子表)
- # ---------------------------------------------------------------------------
- class CheckupInstitutionCreateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- institution_name: str = Field(..., alias="institutionName")
- institution_address: Optional[str] = Field(None, alias="institutionAddress")
- contact_name: Optional[str] = Field(None, alias="contactName")
- contact_phone: Optional[str] = Field(None, alias="contactPhone")
- institution_logo: Optional[str] = Field(None, alias="institutionLogo")
- status: Optional[str] = Field("1", alias="status")
- order_num: Optional[int] = Field(0, alias="orderNum")
- remark: Optional[str] = None
- class CheckupInstitutionUpdateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- institution_name: Optional[str] = Field(None, alias="institutionName")
- institution_address: Optional[str] = Field(None, alias="institutionAddress")
- contact_name: Optional[str] = Field(None, alias="contactName")
- contact_phone: Optional[str] = Field(None, alias="contactPhone")
- institution_logo: Optional[str] = Field(None, alias="institutionLogo")
- status: Optional[str] = Field(None, alias="status")
- order_num: Optional[int] = Field(None, alias="orderNum")
- remark: Optional[str] = None
- @router.get("/checkup-institutions")
- async def list_checkup_institutions(
- page: int = Query(1, ge=1),
- pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
- keyword: Optional[str] = None,
- status: Optional[str] = None,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- tenant_no = _get_tenant_no(db, user)
- items, total = ps_svc.list_checkup_institutions(
- db,
- page=page,
- page_size=pageSize,
- keyword=keyword,
- status=status,
- tenant_no=tenant_no,
- user_info=user,
- )
- tp = ps_svc.total_pages(total, pageSize)
- return success_response(
- {"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp}
- )
- @router.post("/checkup-institutions")
- async def create_checkup_institution(
- body: CheckupInstitutionCreateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- obj = ps_svc.create_checkup_institution(
- db,
- institution_name=body.institution_name,
- institution_address=body.institution_address,
- contact_name=body.contact_name,
- contact_phone=body.contact_phone,
- institution_logo=body.institution_logo,
- status=body.status,
- tenant_no=tenant_no,
- order_num=body.order_num,
- remark=body.remark,
- user_id=user.get("user_id"),
- )
- return success_response(ps_svc._row_to_dict_checkup_institution(obj), message="创建成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.put("/checkup-institutions/{row_id}")
- async def update_checkup_institution(
- row_id: str,
- body: CheckupInstitutionUpdateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
- obj = ps_svc.update_checkup_institution(
- db,
- row_id,
- institution_name=payload.get("institution_name"),
- institution_address=payload.get("institution_address"),
- contact_name=payload.get("contact_name"),
- contact_phone=payload.get("contact_phone"),
- institution_logo=payload.get("institution_logo"),
- status=payload.get("status"),
- order_num=payload.get("order_num"),
- remark=payload.get("remark"),
- user_id=user.get("user_id"),
- tenant_no=tenant_no,
- )
- return success_response(ps_svc._row_to_dict_checkup_institution(obj), message="更新成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.delete("/checkup-institutions/{row_id}")
- async def delete_checkup_institution(
- row_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- ps_svc.soft_delete_checkup_institution(db, row_id, tenant_no=tenant_no)
- return success_response(None, message="删除成功")
- except ValueError as e:
- return error_response(400, str(e))
- # --- 体检机构开票信息 ---
- class CheckupInstitutionInvoiceCreateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- company_name: str = Field(..., alias="companyName")
- tax_no: Optional[str] = Field(None, alias="taxNo")
- company_address: Optional[str] = Field(None, alias="companyAddress")
- company_phone: Optional[str] = Field(None, alias="companyPhone")
- bank_name: Optional[str] = Field(None, alias="bankName")
- bank_account: Optional[str] = Field(None, alias="bankAccount")
- order_num: Optional[int] = Field(0, alias="orderNum")
- remark: Optional[str] = None
- class CheckupInstitutionInvoiceUpdateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- company_name: Optional[str] = Field(None, alias="companyName")
- tax_no: Optional[str] = Field(None, alias="taxNo")
- company_address: Optional[str] = Field(None, alias="companyAddress")
- company_phone: Optional[str] = Field(None, alias="companyPhone")
- bank_name: Optional[str] = Field(None, alias="bankName")
- bank_account: Optional[str] = Field(None, alias="bankAccount")
- order_num: Optional[int] = Field(None, alias="orderNum")
- remark: Optional[str] = None
- @router.get("/checkup-institutions/{institution_id}/invoices")
- async def list_checkup_institution_invoices(
- institution_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- items = ps_svc.list_checkup_institution_invoices(db, institution_id, tenant_no=tenant_no, user_info=user)
- return success_response(items)
- except ValueError as e:
- return error_response(400, str(e))
- @router.post("/checkup-institutions/{institution_id}/invoices")
- async def create_checkup_institution_invoice(
- institution_id: str,
- body: CheckupInstitutionInvoiceCreateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- obj = ps_svc.create_checkup_institution_invoice(
- db,
- checkup_institution_id=institution_id,
- company_name=body.company_name,
- tax_no=body.tax_no,
- company_address=body.company_address,
- company_phone=body.company_phone,
- bank_name=body.bank_name,
- bank_account=body.bank_account,
- tenant_no=tenant_no,
- order_num=body.order_num,
- remark=body.remark,
- user_id=user.get("user_id"),
- )
- return success_response(ps_svc._row_to_dict_checkup_institution_invoice(obj), message="创建成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.put("/checkup-institution-invoices/{invoice_id}")
- async def update_checkup_institution_invoice(
- invoice_id: str,
- body: CheckupInstitutionInvoiceUpdateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
- obj = ps_svc.update_checkup_institution_invoice(
- db,
- invoice_id,
- company_name=payload.get("company_name"),
- tax_no=payload.get("tax_no"),
- company_address=payload.get("company_address"),
- company_phone=payload.get("company_phone"),
- bank_name=payload.get("bank_name"),
- bank_account=payload.get("bank_account"),
- order_num=payload.get("order_num"),
- remark=payload.get("remark"),
- user_id=user.get("user_id"),
- tenant_no=tenant_no,
- )
- return success_response(ps_svc._row_to_dict_checkup_institution_invoice(obj), message="更新成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.delete("/checkup-institution-invoices/{invoice_id}")
- async def delete_checkup_institution_invoice(
- invoice_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- ps_svc.soft_delete_checkup_institution_invoice(db, invoice_id, tenant_no=tenant_no)
- return success_response(None, message="删除成功")
- except ValueError as e:
- return error_response(400, str(e))
- # --- 体检机构项目及价格 ---
- class CheckupInstitutionProjectCreateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- project_name: str = Field(..., alias="projectName")
- project_fee: Optional[float] = Field(None, alias="projectFee")
- status: Optional[str] = Field("1", alias="status")
- order_num: Optional[int] = Field(0, alias="orderNum")
- remark: Optional[str] = None
- class CheckupInstitutionProjectUpdateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- project_name: Optional[str] = Field(None, alias="projectName")
- project_fee: Optional[float] = Field(None, alias="projectFee")
- status: Optional[str] = Field(None, alias="status")
- order_num: Optional[int] = Field(None, alias="orderNum")
- remark: Optional[str] = None
- @router.get("/checkup-institutions/{institution_id}/projects")
- async def list_checkup_institution_projects(
- institution_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- items = ps_svc.list_checkup_institution_projects(db, institution_id, tenant_no=tenant_no, user_info=user)
- return success_response(items)
- except ValueError as e:
- return error_response(400, str(e))
- @router.post("/checkup-institutions/{institution_id}/projects")
- async def create_checkup_institution_project(
- institution_id: str,
- body: CheckupInstitutionProjectCreateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- obj = ps_svc.create_checkup_institution_project(
- db,
- checkup_institution_id=institution_id,
- project_name=body.project_name,
- project_fee=body.project_fee,
- status=body.status,
- tenant_no=tenant_no,
- order_num=body.order_num,
- remark=body.remark,
- user_id=user.get("user_id"),
- )
- return success_response(ps_svc._row_to_dict_checkup_institution_project(obj), message="创建成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.put("/checkup-institution-projects/{project_id}")
- async def update_checkup_institution_project(
- project_id: str,
- body: CheckupInstitutionProjectUpdateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
- obj = ps_svc.update_checkup_institution_project(
- db,
- project_id,
- project_name=payload.get("project_name"),
- project_fee=payload.get("project_fee"),
- status=payload.get("status"),
- order_num=payload.get("order_num"),
- remark=payload.get("remark"),
- user_id=user.get("user_id"),
- tenant_no=tenant_no,
- )
- return success_response(ps_svc._row_to_dict_checkup_institution_project(obj), message="更新成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.delete("/checkup-institution-projects/{project_id}")
- async def delete_checkup_institution_project(
- project_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- ps_svc.soft_delete_checkup_institution_project(db, project_id, tenant_no=tenant_no)
- return success_response(None, message="删除成功")
- except ValueError as e:
- return error_response(400, str(e))
- # ---------------------------------------------------------------------------
- # 7. 渠道服务购买订单
- # ---------------------------------------------------------------------------
- class ServiceOrderProductItem(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- project_code: Optional[str] = Field(None, alias="projectCode")
- project_name: Optional[str] = Field(None, alias="projectName")
- cell_type: Optional[str] = Field(None, alias="cellType")
- spec_text: Optional[str] = Field(None, alias="specText")
- agreement_unit_price: Optional[float] = Field(None, alias="agreementUnitPrice")
- buy_qty: Optional[float] = Field(None, alias="buyQty")
- buy_amount: Optional[float] = Field(None, alias="buyAmount")
- class ServiceOrderCreateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- channel_id: str = Field(..., alias="channelId")
- order_type: str = Field(..., alias="orderType") # yfk / gmcp
- order_name: Optional[str] = Field(None, alias="orderName")
- dept_name: Optional[str] = Field(None, alias="deptName")
- prepay_amount: Optional[float] = Field(None, alias="prepayAmount")
- channel_agreement_id: Optional[str] = Field(None, alias="channelAgreementId")
- products: Optional[List[ServiceOrderProductItem]] = None
- remark: Optional[str] = None
- class ServiceOrderUpdateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- dept_name: Optional[str] = Field(None, alias="deptName")
- order_name: Optional[str] = Field(None, alias="orderName")
- remark: Optional[str] = None
- prepay_amount: Optional[float] = Field(None, alias="prepayAmount")
- channel_agreement_id: Optional[str] = Field(None, alias="channelAgreementId")
- products: Optional[List[ServiceOrderProductItem]] = None
- class FinanceSubmitBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- finance_submit_remark: Optional[str] = Field(None, alias="financeSubmitRemark")
- finance_submit_attachments: Optional[str] = Field(None, alias="financeSubmitAttachments")
- class FinanceConfirmBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- finance_remark: Optional[str] = Field(None, alias="financeRemark")
- finance_confirm_attachments: Optional[str] = Field(None, alias="financeConfirmAttachments")
- class RefundSubmitBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- refund_amount: Optional[float] = Field(None, alias="refundAmount")
- refund_remark: Optional[str] = Field(None, alias="refundRemark")
- refund_attachments: Optional[str] = Field(None, alias="refundAttachments")
- class RefundConfirmBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- refund_finance_remark: Optional[str] = Field(None, alias="refundFinanceRemark")
- refund_finance_confirm_attachments: Optional[str] = Field(
- None, alias="refundFinanceConfirmAttachments"
- )
- class TxnRechargeBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- amount: float = Field(..., gt=0, alias="amount")
- remark: Optional[str] = Field(None, alias="remark")
- finance_submit_attachments: Optional[str] = Field(None, alias="financeSubmitAttachments")
- class TxnRefundBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- amount: float = Field(..., gt=0, alias="amount")
- remark: Optional[str] = Field(None, alias="remark")
- attachments: Optional[str] = Field(None, alias="attachments")
- class TxnProductItem(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- project_code: Optional[str] = Field(None, alias="projectCode")
- project_name: Optional[str] = Field(None, alias="projectName")
- cell_type: Optional[str] = Field(None, alias="cellType")
- spec_text: Optional[str] = Field(None, alias="specText")
- agreement_unit_price: Optional[float] = Field(None, alias="agreementUnitPrice")
- qty: Optional[float] = Field(None, alias="qty")
- amount: Optional[float] = Field(None, alias="amount")
- class TxnPurchaseBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- products: List[TxnProductItem] = Field(..., alias="products")
- remark: Optional[str] = Field(None, alias="remark")
- class TxnUnsubscribeBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- products: List[TxnProductItem] = Field(..., alias="products")
- remark: Optional[str] = Field(None, alias="remark")
- class TxnUpdateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- amount: Optional[float] = Field(None, gt=0, alias="amount")
- remark: Optional[str] = Field(None, alias="remark")
- finance_submit_attachments: Optional[str] = Field(None, alias="financeSubmitAttachments")
- refund_attachments: Optional[str] = Field(None, alias="refundAttachments")
- products: Optional[List[TxnProductItem]] = Field(None, alias="products")
- class TxnFinanceSubmitBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- finance_submit_remark: Optional[str] = Field(None, alias="financeSubmitRemark")
- finance_submit_attachments: Optional[str] = Field(None, alias="financeSubmitAttachments")
- class TxnFinanceConfirmBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- finance_remark: Optional[str] = Field(None, alias="financeRemark")
- finance_confirm_attachments: Optional[str] = Field(None, alias="financeConfirmAttachments")
- @router.get("/channel-service-orders")
- async def list_channel_service_orders(
- page: int = Query(1, ge=1),
- pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
- orderType: Optional[str] = Query(None, alias="orderType"),
- orderStatus: Optional[str] = Query(None, alias="orderStatus"),
- channelId: Optional[str] = Query(None, alias="channelId"),
- keyword: Optional[str] = None,
- createTimeStart: Optional[str] = Query(None, alias="createTimeStart"),
- createTimeEnd: Optional[str] = Query(None, alias="createTimeEnd"),
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- tenant_no = _get_tenant_no(db, user)
- items, total = ps_svc.list_channel_service_orders(
- db,
- page=page,
- page_size=pageSize,
- order_type=orderType,
- order_status=orderStatus,
- channel_id=channelId,
- keyword=keyword,
- create_time_start=createTimeStart,
- create_time_end=createTimeEnd,
- tenant_no=tenant_no,
- user_info=user,
- )
- tp = ps_svc.total_pages(total, pageSize)
- return success_response(
- {"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp}
- )
- @router.get("/channel-service-orders/{order_id}")
- async def get_channel_service_order_detail(
- order_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- order = ps_svc.get_service_order(db, order_id, tenant_no=tenant_no)
- if not order:
- return error_response(404, "订单不存在")
- order_dict = ps_svc._row_to_dict_service_order(order, db, tenant_no)
- user_ids = [x for x in (order.create_by, order.finance_submit_by) if x]
- name_map = ps_svc._user_nick_name_map(db, user_ids)
- order_dict["createByName"] = name_map.get(order.create_by or "", "") or (order.create_by or "")
- order_dict["financeSubmitByName"] = name_map.get(order.finance_submit_by or "", "") or (
- order.finance_submit_by or ""
- )
- products = ps_svc.get_service_order_products(db, order_id, tenant_no=tenant_no)
- order_dict["products"] = products
- txns, _ = ps_svc.list_service_order_txns(db, service_order_id=order_id, tenant_no=tenant_no, page_size=200)
- order_dict["transactions"] = txns
- if order.order_type == "gmcp":
- has_lock = ps_svc._gmcp_has_purchase_lock(db, order_id, tenant_no)
- order_dict["hasPurchaseTxn"] = has_lock
- order_dict["agreementEditable"] = ps_svc.gmcp_agreement_editable(db, order, tenant_no)
- else:
- order_dict["hasPurchaseTxn"] = False
- order_dict["agreementEditable"] = order.order_status == "dsx"
- return success_response(order_dict)
- except ValueError as e:
- return error_response(400, str(e))
- @router.post("/channel-service-orders")
- async def create_channel_service_order(
- body: ServiceOrderCreateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- products_data = None
- if body.products:
- products_data = [p.model_dump(by_alias=False) for p in body.products]
- order = ps_svc.create_channel_service_order(
- db,
- channel_id=body.channel_id,
- order_type=body.order_type,
- order_name=body.order_name,
- dept_name=body.dept_name,
- prepay_amount=body.prepay_amount,
- channel_agreement_id=body.channel_agreement_id,
- products=products_data,
- tenant_no=tenant_no,
- remark=body.remark,
- user_id=user.get("user_id"),
- )
- order_dict = ps_svc._row_to_dict_service_order(order, db, tenant_no)
- order_dict["products"] = ps_svc.get_service_order_products(db, order.id, tenant_no=tenant_no)
- return success_response(order_dict, message="创建成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.put("/channel-service-orders/{order_id}")
- async def update_channel_service_order(
- order_id: str,
- body: ServiceOrderUpdateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
- products_data = None
- if "products" in payload:
- products_data = payload.pop("products")
- if products_data is not None:
- products_data = [
- p.model_dump(by_alias=False) if hasattr(p, "model_dump") else p
- for p in (body.products or [])
- ]
- obj = ps_svc.update_channel_service_order(
- db,
- order_id,
- tenant_no=tenant_no,
- user_id=user.get("user_id"),
- products=products_data,
- **payload,
- )
- return success_response(
- ps_svc._row_to_dict_service_order(obj, db, tenant_no), message="更新成功"
- )
- except ValueError as e:
- return error_response(400, str(e))
- @router.delete("/channel-service-orders/{order_id}")
- async def delete_channel_service_order(
- order_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- ps_svc.soft_delete_service_order(db, order_id, tenant_no=tenant_no)
- return success_response(None, message="删除成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.post("/channel-service-orders/{order_id}/submit-finance-confirm")
- async def submit_service_order_finance_confirm(
- order_id: str,
- body: FinanceSubmitBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- obj = ps_svc.submit_finance_confirm(
- db,
- order_id,
- finance_submit_remark=body.finance_submit_remark,
- finance_submit_attachments=body.finance_submit_attachments,
- tenant_no=tenant_no,
- user_id=user.get("user_id"),
- )
- return success_response(
- ps_svc._row_to_dict_service_order(obj, db, tenant_no), message="已发起财务确认"
- )
- except ValueError as e:
- return error_response(400, str(e))
- @router.post("/channel-service-orders/{order_id}/confirm-receipt")
- async def confirm_service_order_receipt(
- order_id: str,
- body: FinanceConfirmBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- obj = ps_svc.confirm_receipt(
- db,
- order_id,
- finance_remark=body.finance_remark,
- finance_confirm_attachments=body.finance_confirm_attachments,
- tenant_no=tenant_no,
- user_id=user.get("user_id"),
- )
- return success_response(
- ps_svc._row_to_dict_service_order(obj, db, tenant_no), message="确认收款成功"
- )
- except ValueError as e:
- return error_response(400, str(e))
- @router.post("/channel-service-orders/{order_id}/submit-refund")
- async def submit_service_order_refund(
- order_id: str,
- body: RefundSubmitBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- obj = ps_svc.submit_refund(
- db,
- order_id,
- refund_amount=body.refund_amount,
- refund_remark=body.refund_remark,
- refund_attachments=body.refund_attachments,
- tenant_no=tenant_no,
- user_id=user.get("user_id"),
- )
- return success_response(
- ps_svc._row_to_dict_service_order(obj, db, tenant_no), message="提交退款成功"
- )
- except ValueError as e:
- return error_response(400, str(e))
- @router.post("/channel-service-orders/{order_id}/confirm-refund")
- async def confirm_service_order_refund(
- order_id: str,
- body: RefundConfirmBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- obj = ps_svc.confirm_refund(
- db,
- order_id,
- refund_finance_remark=body.refund_finance_remark,
- refund_finance_confirm_attachments=body.refund_finance_confirm_attachments,
- tenant_no=tenant_no,
- user_id=user.get("user_id"),
- )
- return success_response(
- ps_svc._row_to_dict_service_order(obj, db, tenant_no), message="确认退款成功"
- )
- except ValueError as e:
- return error_response(400, str(e))
- @router.put("/channel-service-orders/{order_id}/void")
- async def void_channel_service_order(
- order_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- obj = ps_svc.void_service_order(
- db,
- order_id,
- tenant_no=tenant_no,
- user_id=user.get("user_id"),
- )
- return success_response(
- ps_svc._row_to_dict_service_order(obj, db, tenant_no), message="作废成功"
- )
- except ValueError as e:
- return error_response(400, str(e))
- @router.get("/channel-service-order-txns")
- async def list_service_order_txns(
- page: int = Query(1, ge=1),
- pageSize: int = Query(20, ge=1, le=100, alias="pageSize"),
- serviceOrderId: Optional[str] = Query(None, alias="serviceOrderId"),
- txnStatus: Optional[str] = Query(None, alias="txnStatus"),
- txnType: Optional[str] = Query(None, alias="txnType"),
- keyword: Optional[str] = None,
- createTimeStart: Optional[str] = Query(None, alias="createTimeStart"),
- createTimeEnd: Optional[str] = Query(None, alias="createTimeEnd"),
- financeDoneOnly: Optional[bool] = Query(False, alias="financeDoneOnly"),
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- tenant_no = _get_tenant_no(db, user)
- items, total = ps_svc.list_service_order_txns(
- db,
- service_order_id=serviceOrderId,
- txn_status=txnStatus,
- txn_type=txnType,
- keyword=keyword,
- create_time_start=createTimeStart,
- create_time_end=createTimeEnd,
- finance_done_only=bool(financeDoneOnly),
- page=page,
- page_size=pageSize,
- tenant_no=tenant_no,
- )
- tp = ps_svc.total_pages(total, pageSize)
- return success_response(
- {"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp}
- )
- @router.get("/channel-service-order-txns/{txn_id}")
- async def get_service_order_txn_detail(
- txn_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- txn = ps_svc.get_service_order_txn(db, txn_id, tenant_no=tenant_no)
- if not txn:
- return error_response(404, "流水不存在")
- txn_dict = ps_svc._service_order_txn_to_response_dict(db, txn, tenant_no)
- return success_response(txn_dict)
- except ValueError as e:
- return error_response(400, str(e))
- @router.post("/channel-service-orders/{order_id}/recharge")
- async def create_recharge_txn(
- order_id: str,
- body: TxnRechargeBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- txn = ps_svc.create_recharge_txn(
- db,
- order_id,
- amount=body.amount,
- remark=body.remark,
- finance_submit_attachments=body.finance_submit_attachments,
- tenant_no=tenant_no,
- user_id=user.get("user_id"),
- )
- return success_response(
- ps_svc._row_to_dict_service_order_txn(txn, db, tenant_no), message="充值流水创建成功"
- )
- except ValueError as e:
- return error_response(400, str(e))
- @router.post("/channel-service-orders/{order_id}/refund")
- async def create_refund_txn(
- order_id: str,
- body: TxnRefundBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- txn = ps_svc.create_refund_txn(
- db,
- order_id,
- amount=body.amount,
- remark=body.remark,
- attachments=body.attachments,
- tenant_no=tenant_no,
- user_id=user.get("user_id"),
- )
- return success_response(
- ps_svc._row_to_dict_service_order_txn(txn, db, tenant_no), message="退款流水创建成功"
- )
- except ValueError as e:
- return error_response(400, str(e))
- @router.post("/channel-service-orders/{order_id}/purchase")
- async def create_purchase_txn(
- order_id: str,
- body: TxnPurchaseBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- products_data = [p.model_dump(by_alias=False) for p in body.products]
- txn = ps_svc.create_purchase_txn(
- db,
- order_id,
- products=products_data,
- remark=body.remark,
- tenant_no=tenant_no,
- user_id=user.get("user_id"),
- )
- return success_response(
- ps_svc._row_to_dict_service_order_txn(txn, db, tenant_no), message="购买产品流水创建成功"
- )
- except ValueError as e:
- return error_response(400, str(e))
- @router.post("/channel-service-orders/{order_id}/unsubscribe")
- async def create_unsubscribe_txn(
- order_id: str,
- body: TxnUnsubscribeBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- products_data = [p.model_dump(by_alias=False) for p in body.products]
- txn = ps_svc.create_unsubscribe_txn(
- db,
- order_id,
- products=products_data,
- remark=body.remark,
- tenant_no=tenant_no,
- user_id=user.get("user_id"),
- )
- return success_response(
- ps_svc._row_to_dict_service_order_txn(txn, db, tenant_no), message="退订产品流水创建成功"
- )
- except ValueError as e:
- return error_response(400, str(e))
- @router.put("/channel-service-order-txns/{txn_id}")
- async def update_service_order_txn(
- txn_id: str,
- body: TxnUpdateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- products_data = None
- if body.products is not None:
- products_data = [p.model_dump(by_alias=False) for p in body.products]
- txn = ps_svc.update_service_order_txn(
- db,
- txn_id,
- amount=body.amount,
- remark=body.remark,
- finance_submit_attachments=body.finance_submit_attachments,
- refund_attachments=body.refund_attachments,
- products=products_data,
- tenant_no=tenant_no,
- user_id=user.get("user_id"),
- )
- return success_response(
- ps_svc._row_to_dict_service_order_txn(txn, db, tenant_no), message="更新成功"
- )
- except ValueError as e:
- return error_response(400, str(e))
- @router.post("/channel-service-order-txns/{txn_id}/submit-finance")
- async def submit_txn_finance(
- txn_id: str,
- body: TxnFinanceSubmitBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- txn = ps_svc.submit_txn_finance(
- db,
- txn_id,
- finance_submit_remark=body.finance_submit_remark,
- finance_submit_attachments=body.finance_submit_attachments,
- tenant_no=tenant_no,
- user_id=user.get("user_id"),
- )
- return success_response(
- ps_svc._row_to_dict_service_order_txn(txn, db, tenant_no), message="已发起财务确认"
- )
- except ValueError as e:
- return error_response(400, str(e))
- @router.post("/channel-service-order-txns/{txn_id}/confirm")
- async def confirm_txn(
- txn_id: str,
- body: TxnFinanceConfirmBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- txn = ps_svc.confirm_txn(
- db,
- txn_id,
- finance_remark=body.finance_remark,
- finance_confirm_attachments=body.finance_confirm_attachments,
- tenant_no=tenant_no,
- user_id=user.get("user_id"),
- )
- return success_response(
- ps_svc._service_order_txn_to_response_dict(db, txn, tenant_no),
- message="财务确认成功",
- )
- except ValueError as e:
- return error_response(400, str(e))
- @router.put("/channel-service-order-txns/{txn_id}/void")
- async def void_txn(
- txn_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- txn = ps_svc.void_txn(
- db,
- txn_id,
- tenant_no=tenant_no,
- user_id=user.get("user_id"),
- )
- return success_response(
- ps_svc._service_order_txn_to_response_dict(db, txn, tenant_no),
- message="作废成功",
- )
- except ValueError as e:
- return error_response(400, str(e))
- @router.get("/channels/{channel_id}/account")
- async def get_channel_account_info(
- channel_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- account = ps_svc.get_channel_account(db, channel_id, tenant_no=tenant_no)
- if not account:
- return success_response({"channelId": channel_id, "balanceAmount": 0.0})
- return success_response(ps_svc._row_to_dict_channel_account(account))
- except ValueError as e:
- return error_response(400, str(e))
- @router.get("/channels/{channel_id}/product-quotas")
- async def list_channel_product_quotas(
- channel_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- items = ps_svc.list_channel_product_quotas(db, channel_id, tenant_no=tenant_no)
- return success_response(items)
- except ValueError as e:
- return error_response(400, str(e))
- # --- 体检机构项目套餐 ---
- class CheckupPackageItemBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- checkup_institution_project_id: str = Field(..., alias="checkupInstitutionProjectId")
- project_name: Optional[str] = Field(None, alias="projectName")
- project_fee: Optional[float] = Field(None, alias="projectFee")
- order_num: Optional[int] = Field(None, alias="orderNum")
- remark: Optional[str] = None
- class CheckupInstitutionPackageCreateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- package_name: str = Field(..., alias="packageName")
- package_code: str = Field(..., alias="packageCode")
- status: Optional[str] = Field("1", alias="status")
- order_num: Optional[int] = Field(0, alias="orderNum")
- remark: Optional[str] = None
- items: List[CheckupPackageItemBody] = Field(default_factory=list)
- class CheckupInstitutionPackageUpdateBody(BaseModel):
- model_config = ConfigDict(populate_by_name=True)
- package_name: Optional[str] = Field(None, alias="packageName")
- package_code: Optional[str] = Field(None, alias="packageCode")
- status: Optional[str] = Field(None, alias="status")
- order_num: Optional[int] = Field(None, alias="orderNum")
- remark: Optional[str] = None
- items: Optional[List[CheckupPackageItemBody]] = None
- def _package_items_to_crud(items) -> List[dict]:
- out = []
- for x in items:
- if isinstance(x, dict):
- out.append(
- {
- "checkup_institution_project_id": x.get("checkup_institution_project_id")
- or x.get("checkupInstitutionProjectId"),
- "project_name": x.get("project_name") or x.get("projectName"),
- "project_fee": x.get("project_fee") if x.get("project_fee") is not None else x.get("projectFee"),
- "order_num": x.get("order_num") if x.get("order_num") is not None else x.get("orderNum"),
- "remark": x.get("remark"),
- }
- )
- else:
- out.append(
- {
- "checkup_institution_project_id": x.checkup_institution_project_id,
- "project_name": x.project_name,
- "project_fee": x.project_fee,
- "order_num": x.order_num,
- "remark": x.remark,
- }
- )
- return out
- @router.get("/checkup-institutions/{institution_id}/packages")
- async def list_checkup_institution_packages(
- institution_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- items = ps_svc.list_checkup_institution_packages(db, institution_id, tenant_no=tenant_no, user_info=user)
- return success_response(items)
- except ValueError as e:
- return error_response(400, str(e))
- @router.post("/checkup-institutions/{institution_id}/packages")
- async def create_checkup_institution_package(
- institution_id: str,
- body: CheckupInstitutionPackageCreateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- detail = ps_svc.create_checkup_institution_package(
- db,
- checkup_institution_id=institution_id,
- package_name=body.package_name,
- package_code=body.package_code,
- status=body.status,
- items=_package_items_to_crud(body.items),
- tenant_no=tenant_no,
- order_num=body.order_num,
- remark=body.remark,
- user_id=user.get("user_id"),
- )
- return success_response(detail, message="创建成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.get("/checkup-institution-packages/{package_id}")
- async def get_checkup_institution_package_detail(
- package_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- detail = ps_svc.get_checkup_institution_package_detail(db, package_id, tenant_no=tenant_no)
- if not detail:
- return error_response(404, "记录不存在")
- return success_response(detail)
- except ValueError as e:
- return error_response(400, str(e))
- @router.put("/checkup-institution-packages/{package_id}")
- async def update_checkup_institution_package(
- package_id: str,
- body: CheckupInstitutionPackageUpdateBody,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- payload = body.model_dump(exclude_unset=True, by_alias=False)
- items_raw = payload.pop("items", None)
- items = _package_items_to_crud(items_raw) if items_raw is not None else None
- detail = ps_svc.update_checkup_institution_package(
- db,
- package_id,
- package_name=payload.get("package_name"),
- package_code=payload.get("package_code"),
- status=payload.get("status"),
- items=items,
- order_num=payload.get("order_num"),
- remark=payload.get("remark"),
- user_id=user.get("user_id"),
- tenant_no=tenant_no,
- )
- return success_response(detail, message="更新成功")
- except ValueError as e:
- return error_response(400, str(e))
- @router.delete("/checkup-institution-packages/{package_id}")
- async def delete_checkup_institution_package(
- package_id: str,
- user: dict = Depends(require_admin_or_super_admin),
- db: Session = Depends(get_db),
- ):
- try:
- tenant_no = _get_tenant_no(db, user)
- ps_svc.soft_delete_checkup_institution_package(db, package_id, tenant_no=tenant_no)
- return success_response(None, message="删除成功")
- except ValueError as e:
- return error_response(400, str(e))
|