production.py 60 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628
  1. """生产管理 API 路由(7 个子模块:耗材、试剂、SOP文档、工艺工序分类、产出物类型、耗材包、工艺库)"""
  2. from fastapi import APIRouter, Depends, Query
  3. from pydantic import BaseModel, ConfigDict, Field
  4. from sqlalchemy.orm import Session
  5. from typing import Any, Optional, List
  6. from app.core.database import get_db
  7. from app.core.menu_guard import require_admin_or_super_admin, require_menu_code
  8. from app.core.response import success_response, error_response
  9. from app.crud import consumable as consumable_svc
  10. from app.crud import reagent as reagent_svc
  11. from app.crud import sop_document as sop_document_svc
  12. from app.crud import process_category as process_category_svc
  13. from app.crud import output_type as output_type_svc
  14. from app.crud import consumable_pack as consumable_pack_svc
  15. from app.crud import process as process_svc
  16. from app.crud import process_route as route_svc
  17. from app.schemas.process_route import (
  18. ProcessRouteCreateBody,
  19. ProcessRouteUpdateBody,
  20. SetCurrentBody,
  21. StepAddBody,
  22. StepCopyBody,
  23. StepUpdateBody,
  24. StepReorderBody,
  25. StepReagentUpdateBody,
  26. StepConsumableUpdateBody,
  27. StepOutputUpdateBody,
  28. StepDataCollectionUpdateBody,
  29. )
  30. from app.models.models import SysUser
  31. from app.crud import production_work_order as production_work_order_svc
  32. from app.crud import production_task as production_task_svc
  33. from app.crud import cell_product as cell_product_svc
  34. from app.schemas.production_work_order import ProductionWorkOrderListQuery, ProductionWorkOrderComplete
  35. from app.schemas.production_task import (
  36. ProductionTaskCreate,
  37. ProductionTaskUpdate,
  38. ProductionTaskStatusUpdate,
  39. TaskStepAdd,
  40. TaskStepUpdate,
  41. TaskStepMaterialItem,
  42. TaskStepDataCollectionItem,
  43. TaskInputItem,
  44. TaskOutputItem,
  45. )
  46. from app.schemas.cell_product import CellProductCreate, CellProductUpdate
  47. router = APIRouter(prefix="/web/admin", tags=["生产管理"])
  48. def _get_tenant_no(db: Session, user: dict) -> str:
  49. user_id = user.get("user_id")
  50. if not user_id:
  51. return "zkxw"
  52. sys_user = db.query(SysUser).filter(SysUser.id == user_id).first()
  53. return (sys_user.tenant_no if sys_user else None) or "zkxw"
  54. # ---------------------------------------------------------------------------
  55. # 1. 耗材
  56. # ---------------------------------------------------------------------------
  57. class ConsumableCreateBody(BaseModel):
  58. model_config = ConfigDict(populate_by_name=True)
  59. consumable_code: str = Field(..., alias="consumableCode")
  60. consumable_name: str = Field(..., alias="consumableName")
  61. spec_model: Optional[str] = Field(None, alias="specModel")
  62. standard_usage: Optional[str] = Field(None, alias="standardUsage")
  63. unit: Optional[str] = None
  64. description: Optional[str] = None
  65. order_num: Optional[int] = Field(0, alias="orderNum")
  66. remark: Optional[str] = None
  67. class ConsumableUpdateBody(BaseModel):
  68. model_config = ConfigDict(populate_by_name=True)
  69. consumable_code: Optional[str] = Field(None, alias="consumableCode")
  70. consumable_name: Optional[str] = Field(None, alias="consumableName")
  71. spec_model: Optional[str] = Field(None, alias="specModel")
  72. standard_usage: Optional[str] = Field(None, alias="standardUsage")
  73. unit: Optional[str] = None
  74. description: Optional[str] = None
  75. order_num: Optional[int] = Field(None, alias="orderNum")
  76. remark: Optional[str] = None
  77. @router.get("/consumables")
  78. async def list_consumables(
  79. page: int = Query(1, ge=1),
  80. pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
  81. keyword: Optional[str] = None,
  82. user: dict = Depends(require_menu_code("production:consumable:list")),
  83. db: Session = Depends(get_db),
  84. ):
  85. tenant_no = _get_tenant_no(db, user)
  86. items, total = consumable_svc.list_consumables(db, page=page, page_size=pageSize, keyword=keyword, tenant_no=tenant_no)
  87. tp = consumable_svc.total_pages(total, pageSize)
  88. return success_response({"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp})
  89. @router.get("/consumables/all")
  90. async def list_all_consumables(
  91. user: dict = Depends(require_admin_or_super_admin),
  92. db: Session = Depends(get_db),
  93. ):
  94. tenant_no = _get_tenant_no(db, user)
  95. items, _ = consumable_svc.list_consumables(db, page=1, page_size=9999, tenant_no=tenant_no)
  96. return success_response(items)
  97. @router.post("/consumables")
  98. async def create_consumable(
  99. body: ConsumableCreateBody,
  100. user: dict = Depends(require_admin_or_super_admin),
  101. db: Session = Depends(get_db),
  102. ):
  103. try:
  104. tenant_no = _get_tenant_no(db, user)
  105. obj = consumable_svc.create_consumable(
  106. db,
  107. consumable_code=body.consumable_code,
  108. consumable_name=body.consumable_name,
  109. spec_model=body.spec_model,
  110. standard_usage=body.standard_usage,
  111. unit=body.unit,
  112. description=body.description,
  113. tenant_no=tenant_no,
  114. order_num=body.order_num,
  115. remark=body.remark,
  116. user_id=user.get("user_id"),
  117. )
  118. return success_response(consumable_svc._row_to_dict(obj), message="创建成功")
  119. except ValueError as e:
  120. return error_response(400, str(e))
  121. @router.put("/consumables/{consumable_id}")
  122. async def update_consumable(
  123. consumable_id: str,
  124. body: ConsumableUpdateBody,
  125. user: dict = Depends(require_admin_or_super_admin),
  126. db: Session = Depends(get_db),
  127. ):
  128. try:
  129. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  130. obj = consumable_svc.update_consumable(
  131. db,
  132. consumable_id,
  133. consumable_code=payload.get("consumable_code"),
  134. consumable_name=payload.get("consumable_name"),
  135. spec_model=payload.get("spec_model"),
  136. standard_usage=payload.get("standard_usage"),
  137. unit=payload.get("unit"),
  138. description=payload.get("description"),
  139. order_num=payload.get("order_num"),
  140. remark=payload.get("remark"),
  141. user_id=user.get("user_id"),
  142. )
  143. return success_response(consumable_svc._row_to_dict(obj), message="更新成功")
  144. except ValueError as e:
  145. return error_response(400, str(e))
  146. @router.delete("/consumables/{consumable_id}")
  147. async def delete_consumable(
  148. consumable_id: str,
  149. _user: dict = Depends(require_admin_or_super_admin),
  150. db: Session = Depends(get_db),
  151. ):
  152. try:
  153. consumable_svc.soft_delete_consumable(db, consumable_id)
  154. return success_response(None, message="删除成功")
  155. except ValueError as e:
  156. return error_response(400, str(e))
  157. # ---------------------------------------------------------------------------
  158. # 2. 试剂
  159. # ---------------------------------------------------------------------------
  160. class ReagentCreateBody(BaseModel):
  161. model_config = ConfigDict(populate_by_name=True)
  162. reagent_code: str = Field(..., alias="reagentCode")
  163. reagent_name: str = Field(..., alias="reagentName")
  164. spec: Optional[str] = None
  165. standard_usage: Optional[str] = Field(None, alias="standardUsage")
  166. unit: Optional[str] = None
  167. description: Optional[str] = None
  168. order_num: Optional[int] = Field(0, alias="orderNum")
  169. remark: Optional[str] = None
  170. class ReagentUpdateBody(BaseModel):
  171. model_config = ConfigDict(populate_by_name=True)
  172. reagent_code: Optional[str] = Field(None, alias="reagentCode")
  173. reagent_name: Optional[str] = Field(None, alias="reagentName")
  174. spec: Optional[str] = None
  175. standard_usage: Optional[str] = Field(None, alias="standardUsage")
  176. unit: Optional[str] = None
  177. description: Optional[str] = None
  178. order_num: Optional[int] = Field(None, alias="orderNum")
  179. remark: Optional[str] = None
  180. @router.get("/reagents")
  181. async def list_reagents(
  182. page: int = Query(1, ge=1),
  183. pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
  184. keyword: Optional[str] = None,
  185. user: dict = Depends(require_menu_code("production:reagent:list")),
  186. db: Session = Depends(get_db),
  187. ):
  188. tenant_no = _get_tenant_no(db, user)
  189. items, total = reagent_svc.list_reagents(db, page=page, page_size=pageSize, keyword=keyword, tenant_no=tenant_no)
  190. tp = reagent_svc.total_pages(total, pageSize)
  191. return success_response({"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp})
  192. @router.get("/reagents/all")
  193. async def list_all_reagents(
  194. user: dict = Depends(require_admin_or_super_admin),
  195. db: Session = Depends(get_db),
  196. ):
  197. tenant_no = _get_tenant_no(db, user)
  198. items, _ = reagent_svc.list_reagents(db, page=1, page_size=9999, tenant_no=tenant_no)
  199. return success_response(items)
  200. @router.post("/reagents")
  201. async def create_reagent(
  202. body: ReagentCreateBody,
  203. user: dict = Depends(require_admin_or_super_admin),
  204. db: Session = Depends(get_db),
  205. ):
  206. try:
  207. tenant_no = _get_tenant_no(db, user)
  208. obj = reagent_svc.create_reagent(
  209. db,
  210. reagent_code=body.reagent_code,
  211. reagent_name=body.reagent_name,
  212. spec=body.spec,
  213. standard_usage=body.standard_usage,
  214. unit=body.unit,
  215. description=body.description,
  216. tenant_no=tenant_no,
  217. order_num=body.order_num,
  218. remark=body.remark,
  219. user_id=user.get("user_id"),
  220. )
  221. return success_response(reagent_svc._row_to_dict(obj), message="创建成功")
  222. except ValueError as e:
  223. return error_response(400, str(e))
  224. @router.put("/reagents/{reagent_id}")
  225. async def update_reagent(
  226. reagent_id: str,
  227. body: ReagentUpdateBody,
  228. user: dict = Depends(require_admin_or_super_admin),
  229. db: Session = Depends(get_db),
  230. ):
  231. try:
  232. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  233. obj = reagent_svc.update_reagent(
  234. db,
  235. reagent_id,
  236. reagent_code=payload.get("reagent_code"),
  237. reagent_name=payload.get("reagent_name"),
  238. spec=payload.get("spec"),
  239. standard_usage=payload.get("standard_usage"),
  240. unit=payload.get("unit"),
  241. description=payload.get("description"),
  242. order_num=payload.get("order_num"),
  243. remark=payload.get("remark"),
  244. user_id=user.get("user_id"),
  245. )
  246. return success_response(reagent_svc._row_to_dict(obj), message="更新成功")
  247. except ValueError as e:
  248. return error_response(400, str(e))
  249. @router.delete("/reagents/{reagent_id}")
  250. async def delete_reagent(
  251. reagent_id: str,
  252. _user: dict = Depends(require_admin_or_super_admin),
  253. db: Session = Depends(get_db),
  254. ):
  255. try:
  256. reagent_svc.soft_delete_reagent(db, reagent_id)
  257. return success_response(None, message="删除成功")
  258. except ValueError as e:
  259. return error_response(400, str(e))
  260. # ---------------------------------------------------------------------------
  261. # 3. SOP文档
  262. # ---------------------------------------------------------------------------
  263. class SopDocumentCreateBody(BaseModel):
  264. model_config = ConfigDict(populate_by_name=True)
  265. sop_code: str = Field(..., alias="sopCode")
  266. sop_name: str = Field(..., alias="sopName")
  267. version_no: Optional[str] = Field(None, alias="versionNo")
  268. sop_attachments: Optional[str] = Field(None, alias="sopAttachments")
  269. order_num: Optional[int] = Field(0, alias="orderNum")
  270. remark: Optional[str] = None
  271. class SopDocumentUpdateBody(BaseModel):
  272. model_config = ConfigDict(populate_by_name=True)
  273. sop_code: Optional[str] = Field(None, alias="sopCode")
  274. sop_name: Optional[str] = Field(None, alias="sopName")
  275. version_no: Optional[str] = Field(None, alias="versionNo")
  276. sop_attachments: Optional[str] = Field(None, alias="sopAttachments")
  277. order_num: Optional[int] = Field(None, alias="orderNum")
  278. remark: Optional[str] = None
  279. @router.get("/sop-documents")
  280. async def list_sop_documents(
  281. page: int = Query(1, ge=1),
  282. pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
  283. keyword: Optional[str] = None,
  284. user: dict = Depends(require_menu_code("production:sop-document:list")),
  285. db: Session = Depends(get_db),
  286. ):
  287. tenant_no = _get_tenant_no(db, user)
  288. items, total = sop_document_svc.list_sop_documents(db, page=page, page_size=pageSize, keyword=keyword, tenant_no=tenant_no)
  289. tp = sop_document_svc.total_pages(total, pageSize)
  290. return success_response({"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp})
  291. @router.get("/sop-documents/all")
  292. async def list_all_sop_documents(
  293. user: dict = Depends(require_admin_or_super_admin),
  294. db: Session = Depends(get_db),
  295. ):
  296. tenant_no = _get_tenant_no(db, user)
  297. items, _ = sop_document_svc.list_sop_documents(db, page=1, page_size=9999, tenant_no=tenant_no)
  298. return success_response(items)
  299. @router.post("/sop-documents")
  300. async def create_sop_document(
  301. body: SopDocumentCreateBody,
  302. user: dict = Depends(require_admin_or_super_admin),
  303. db: Session = Depends(get_db),
  304. ):
  305. try:
  306. tenant_no = _get_tenant_no(db, user)
  307. obj = sop_document_svc.create_sop_document(
  308. db,
  309. sop_code=body.sop_code,
  310. sop_name=body.sop_name,
  311. version_no=body.version_no,
  312. sop_attachments=body.sop_attachments,
  313. tenant_no=tenant_no,
  314. order_num=body.order_num,
  315. remark=body.remark,
  316. user_id=user.get("user_id"),
  317. )
  318. return success_response(
  319. sop_document_svc._row_to_dict(obj, db, tenant_no),
  320. message="创建成功",
  321. )
  322. except ValueError as e:
  323. return error_response(400, str(e))
  324. @router.put("/sop-documents/{sop_id}")
  325. async def update_sop_document(
  326. sop_id: str,
  327. body: SopDocumentUpdateBody,
  328. user: dict = Depends(require_admin_or_super_admin),
  329. db: Session = Depends(get_db),
  330. ):
  331. try:
  332. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  333. obj = sop_document_svc.update_sop_document(
  334. db,
  335. sop_id,
  336. sop_code=payload.get("sop_code"),
  337. sop_name=payload.get("sop_name"),
  338. version_no=payload.get("version_no"),
  339. sop_attachments=payload.get("sop_attachments"),
  340. order_num=payload.get("order_num"),
  341. remark=payload.get("remark"),
  342. user_id=user.get("user_id"),
  343. )
  344. tenant_no = _get_tenant_no(db, user)
  345. return success_response(
  346. sop_document_svc._row_to_dict(obj, db, tenant_no),
  347. message="更新成功",
  348. )
  349. except ValueError as e:
  350. return error_response(400, str(e))
  351. @router.delete("/sop-documents/{sop_id}")
  352. async def delete_sop_document(
  353. sop_id: str,
  354. _user: dict = Depends(require_admin_or_super_admin),
  355. db: Session = Depends(get_db),
  356. ):
  357. try:
  358. sop_document_svc.soft_delete_sop_document(db, sop_id)
  359. return success_response(None, message="删除成功")
  360. except ValueError as e:
  361. return error_response(400, str(e))
  362. # ---------------------------------------------------------------------------
  363. # 4. 工艺工序分类
  364. # ---------------------------------------------------------------------------
  365. class ProcessCategoryCreateBody(BaseModel):
  366. model_config = ConfigDict(populate_by_name=True)
  367. category_code: str = Field(..., alias="categoryCode")
  368. category_name: str = Field(..., alias="categoryName")
  369. order_num: Optional[int] = Field(0, alias="orderNum")
  370. remark: Optional[str] = None
  371. class ProcessCategoryUpdateBody(BaseModel):
  372. model_config = ConfigDict(populate_by_name=True)
  373. category_code: Optional[str] = Field(None, alias="categoryCode")
  374. category_name: Optional[str] = Field(None, alias="categoryName")
  375. order_num: Optional[int] = Field(None, alias="orderNum")
  376. remark: Optional[str] = None
  377. @router.get("/process-categories")
  378. async def list_process_categories(
  379. page: int = Query(1, ge=1),
  380. pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
  381. keyword: Optional[str] = None,
  382. user: dict = Depends(require_menu_code("production:process-category:list")),
  383. db: Session = Depends(get_db),
  384. ):
  385. tenant_no = _get_tenant_no(db, user)
  386. items, total = process_category_svc.list_process_categories(db, page=page, page_size=pageSize, keyword=keyword, tenant_no=tenant_no)
  387. tp = process_category_svc.total_pages(total, pageSize)
  388. return success_response({"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp})
  389. @router.get("/process-categories/all")
  390. async def list_all_process_categories(
  391. user: dict = Depends(require_admin_or_super_admin),
  392. db: Session = Depends(get_db),
  393. ):
  394. tenant_no = _get_tenant_no(db, user)
  395. items, _ = process_category_svc.list_process_categories(db, page=1, page_size=9999, tenant_no=tenant_no)
  396. return success_response(items)
  397. @router.post("/process-categories")
  398. async def create_process_category(
  399. body: ProcessCategoryCreateBody,
  400. user: dict = Depends(require_admin_or_super_admin),
  401. db: Session = Depends(get_db),
  402. ):
  403. try:
  404. tenant_no = _get_tenant_no(db, user)
  405. obj = process_category_svc.create_process_category(
  406. db,
  407. category_code=body.category_code,
  408. category_name=body.category_name,
  409. tenant_no=tenant_no,
  410. order_num=body.order_num,
  411. remark=body.remark,
  412. user_id=user.get("user_id"),
  413. )
  414. return success_response(process_category_svc._row_to_dict(obj), message="创建成功")
  415. except ValueError as e:
  416. return error_response(400, str(e))
  417. @router.put("/process-categories/{category_id}")
  418. async def update_process_category(
  419. category_id: str,
  420. body: ProcessCategoryUpdateBody,
  421. user: dict = Depends(require_admin_or_super_admin),
  422. db: Session = Depends(get_db),
  423. ):
  424. try:
  425. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  426. obj = process_category_svc.update_process_category(
  427. db,
  428. category_id,
  429. category_code=payload.get("category_code"),
  430. category_name=payload.get("category_name"),
  431. order_num=payload.get("order_num"),
  432. remark=payload.get("remark"),
  433. user_id=user.get("user_id"),
  434. )
  435. return success_response(process_category_svc._row_to_dict(obj), message="更新成功")
  436. except ValueError as e:
  437. return error_response(400, str(e))
  438. @router.delete("/process-categories/{category_id}")
  439. async def delete_process_category(
  440. category_id: str,
  441. _user: dict = Depends(require_admin_or_super_admin),
  442. db: Session = Depends(get_db),
  443. ):
  444. try:
  445. process_category_svc.soft_delete_process_category(db, category_id)
  446. return success_response(None, message="删除成功")
  447. except ValueError as e:
  448. return error_response(400, str(e))
  449. # ---------------------------------------------------------------------------
  450. # 5. 工艺产出物类型
  451. # ---------------------------------------------------------------------------
  452. class OutputTypeCreateBody(BaseModel):
  453. model_config = ConfigDict(populate_by_name=True)
  454. type_code: str = Field(..., alias="typeCode")
  455. type_name: str = Field(..., alias="typeName")
  456. order_num: Optional[int] = Field(0, alias="orderNum")
  457. remark: Optional[str] = None
  458. class OutputTypeUpdateBody(BaseModel):
  459. model_config = ConfigDict(populate_by_name=True)
  460. type_code: Optional[str] = Field(None, alias="typeCode")
  461. type_name: Optional[str] = Field(None, alias="typeName")
  462. order_num: Optional[int] = Field(None, alias="orderNum")
  463. remark: Optional[str] = None
  464. @router.get("/output-types")
  465. async def list_output_types(
  466. page: int = Query(1, ge=1),
  467. pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
  468. keyword: Optional[str] = None,
  469. user: dict = Depends(require_menu_code("production:output-type:list")),
  470. db: Session = Depends(get_db),
  471. ):
  472. tenant_no = _get_tenant_no(db, user)
  473. items, total = output_type_svc.list_output_types(db, page=page, page_size=pageSize, keyword=keyword, tenant_no=tenant_no)
  474. tp = output_type_svc.total_pages(total, pageSize)
  475. return success_response({"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp})
  476. @router.get("/output-types/all")
  477. async def list_all_output_types(
  478. user: dict = Depends(require_admin_or_super_admin),
  479. db: Session = Depends(get_db),
  480. ):
  481. tenant_no = _get_tenant_no(db, user)
  482. items, _ = output_type_svc.list_output_types(db, page=1, page_size=9999, tenant_no=tenant_no)
  483. return success_response(items)
  484. @router.post("/output-types")
  485. async def create_output_type(
  486. body: OutputTypeCreateBody,
  487. user: dict = Depends(require_admin_or_super_admin),
  488. db: Session = Depends(get_db),
  489. ):
  490. try:
  491. tenant_no = _get_tenant_no(db, user)
  492. obj = output_type_svc.create_output_type(
  493. db,
  494. type_code=body.type_code,
  495. type_name=body.type_name,
  496. tenant_no=tenant_no,
  497. order_num=body.order_num,
  498. remark=body.remark,
  499. user_id=user.get("user_id"),
  500. )
  501. return success_response(output_type_svc._row_to_dict(obj), message="创建成功")
  502. except ValueError as e:
  503. return error_response(400, str(e))
  504. @router.put("/output-types/{type_id}")
  505. async def update_output_type(
  506. type_id: str,
  507. body: OutputTypeUpdateBody,
  508. user: dict = Depends(require_admin_or_super_admin),
  509. db: Session = Depends(get_db),
  510. ):
  511. try:
  512. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  513. obj = output_type_svc.update_output_type(
  514. db,
  515. type_id,
  516. type_code=payload.get("type_code"),
  517. type_name=payload.get("type_name"),
  518. order_num=payload.get("order_num"),
  519. remark=payload.get("remark"),
  520. user_id=user.get("user_id"),
  521. )
  522. return success_response(output_type_svc._row_to_dict(obj), message="更新成功")
  523. except ValueError as e:
  524. return error_response(400, str(e))
  525. @router.delete("/output-types/{type_id}")
  526. async def delete_output_type(
  527. type_id: str,
  528. _user: dict = Depends(require_admin_or_super_admin),
  529. db: Session = Depends(get_db),
  530. ):
  531. try:
  532. output_type_svc.soft_delete_output_type(db, type_id)
  533. return success_response(None, message="删除成功")
  534. except ValueError as e:
  535. return error_response(400, str(e))
  536. # ---------------------------------------------------------------------------
  537. # 6. 耗材包(主 + 子项)
  538. # ---------------------------------------------------------------------------
  539. class PackItemInput(BaseModel):
  540. model_config = ConfigDict(populate_by_name=True)
  541. consumable_code: Optional[str] = Field(None, alias="consumableCode")
  542. consumable_name: Optional[str] = Field(None, alias="consumableName")
  543. spec_model: Optional[str] = Field(None, alias="specModel")
  544. standard_usage: Optional[str] = Field(None, alias="standardUsage")
  545. unit: Optional[str] = None
  546. remark: Optional[str] = None
  547. class ConsumablePackCreateBody(BaseModel):
  548. model_config = ConfigDict(populate_by_name=True)
  549. pack_code: str = Field(..., alias="packCode")
  550. pack_name: str = Field(..., alias="packName")
  551. usage_scene: Optional[str] = Field(None, alias="usageScene")
  552. pack_type: Optional[str] = Field(None, alias="packType")
  553. status: Optional[int] = 1
  554. order_num: Optional[int] = Field(0, alias="orderNum")
  555. remark: Optional[str] = None
  556. items: List[PackItemInput] = []
  557. class ConsumablePackUpdateBody(BaseModel):
  558. model_config = ConfigDict(populate_by_name=True)
  559. pack_code: Optional[str] = Field(None, alias="packCode")
  560. pack_name: Optional[str] = Field(None, alias="packName")
  561. usage_scene: Optional[str] = Field(None, alias="usageScene")
  562. pack_type: Optional[str] = Field(None, alias="packType")
  563. status: Optional[int] = None
  564. order_num: Optional[int] = Field(None, alias="orderNum")
  565. remark: Optional[str] = None
  566. items: Optional[List[PackItemInput]] = None
  567. @router.get("/consumable-packs")
  568. async def list_consumable_packs(
  569. page: int = Query(1, ge=1),
  570. pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
  571. keyword: Optional[str] = None,
  572. user: dict = Depends(require_menu_code("production:consumable-pack:list")),
  573. db: Session = Depends(get_db),
  574. ):
  575. tenant_no = _get_tenant_no(db, user)
  576. items, total = consumable_pack_svc.list_consumable_packs(db, page=page, page_size=pageSize, keyword=keyword, tenant_no=tenant_no)
  577. tp = consumable_pack_svc.total_pages(total, pageSize)
  578. return success_response({"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp})
  579. @router.get("/consumable-packs/all")
  580. async def list_all_consumable_packs(
  581. user: dict = Depends(require_admin_or_super_admin),
  582. db: Session = Depends(get_db),
  583. ):
  584. tenant_no = _get_tenant_no(db, user)
  585. items = consumable_pack_svc.list_all_packs(db, tenant_no)
  586. return success_response(items)
  587. @router.get("/consumable-packs/{pack_id}")
  588. async def get_consumable_pack_detail(
  589. pack_id: str,
  590. user: dict = Depends(require_admin_or_super_admin),
  591. db: Session = Depends(get_db),
  592. ):
  593. detail = consumable_pack_svc.get_pack_detail(db, pack_id)
  594. if not detail:
  595. return error_response(404, "耗材包不存在")
  596. return success_response(detail)
  597. @router.post("/consumable-packs")
  598. async def create_consumable_pack(
  599. body: ConsumablePackCreateBody,
  600. user: dict = Depends(require_admin_or_super_admin),
  601. db: Session = Depends(get_db),
  602. ):
  603. try:
  604. tenant_no = _get_tenant_no(db, user)
  605. items_data = [it.model_dump(by_alias=False) for it in body.items] if body.items else None
  606. obj = consumable_pack_svc.create_consumable_pack(
  607. db,
  608. pack_code=body.pack_code,
  609. pack_name=body.pack_name,
  610. usage_scene=body.usage_scene,
  611. pack_type=body.pack_type,
  612. status=body.status,
  613. items=items_data,
  614. tenant_no=tenant_no,
  615. order_num=body.order_num,
  616. remark=body.remark,
  617. user_id=user.get("user_id"),
  618. )
  619. return success_response(consumable_pack_svc._row_to_dict(obj), message="创建成功")
  620. except ValueError as e:
  621. return error_response(400, str(e))
  622. @router.put("/consumable-packs/{pack_id}")
  623. async def update_consumable_pack(
  624. pack_id: str,
  625. body: ConsumablePackUpdateBody,
  626. user: dict = Depends(require_admin_or_super_admin),
  627. db: Session = Depends(get_db),
  628. ):
  629. try:
  630. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  631. items_data = [it.model_dump(by_alias=False) for it in body.items] if body.items is not None else None
  632. obj = consumable_pack_svc.update_consumable_pack(
  633. db,
  634. pack_id,
  635. pack_code=payload.get("pack_code"),
  636. pack_name=payload.get("pack_name"),
  637. usage_scene=payload.get("usage_scene"),
  638. pack_type=payload.get("pack_type"),
  639. status=payload.get("status"),
  640. items=items_data,
  641. order_num=payload.get("order_num"),
  642. remark=payload.get("remark"),
  643. user_id=user.get("user_id"),
  644. )
  645. return success_response(consumable_pack_svc._row_to_dict(obj), message="更新成功")
  646. except ValueError as e:
  647. return error_response(400, str(e))
  648. @router.delete("/consumable-packs/{pack_id}")
  649. async def delete_consumable_pack(
  650. pack_id: str,
  651. _user: dict = Depends(require_admin_or_super_admin),
  652. db: Session = Depends(get_db),
  653. ):
  654. try:
  655. consumable_pack_svc.soft_delete_consumable_pack(db, pack_id)
  656. return success_response(None, message="删除成功")
  657. except ValueError as e:
  658. return error_response(400, str(e))
  659. # ---------------------------------------------------------------------------
  660. # 7. 工艺库(主 + 3 个子表:试剂、耗材、产出物)
  661. # ---------------------------------------------------------------------------
  662. class ProcessReagentInput(BaseModel):
  663. model_config = ConfigDict(populate_by_name=True)
  664. reagent_code: Optional[str] = Field(None, alias="reagentCode")
  665. reagent_name: Optional[str] = Field(None, alias="reagentName")
  666. spec: Optional[str] = None
  667. standard_usage: Optional[str] = Field(None, alias="standardUsage")
  668. unit: Optional[str] = None
  669. is_key_material: Optional[str] = Field("0", alias="isKeyMaterial")
  670. remark: Optional[str] = None
  671. class ProcessConsumableInput(BaseModel):
  672. model_config = ConfigDict(populate_by_name=True)
  673. consumable_code: Optional[str] = Field(None, alias="consumableCode")
  674. consumable_name: Optional[str] = Field(None, alias="consumableName")
  675. spec_model: Optional[str] = Field(None, alias="specModel")
  676. standard_usage: Optional[str] = Field(None, alias="standardUsage")
  677. unit: Optional[str] = None
  678. is_required: Optional[str] = Field("1", alias="isRequired")
  679. remark: Optional[str] = None
  680. class ProcessOutputInput(BaseModel):
  681. model_config = ConfigDict(populate_by_name=True)
  682. output_type_id: Optional[str] = Field(None, alias="outputTypeId")
  683. output_name: Optional[str] = Field(None, alias="outputName")
  684. output_barcode: Optional[str] = Field(None, alias="outputBarcode")
  685. remark: Optional[str] = None
  686. class ProcessDataCollectionInput(BaseModel):
  687. model_config = ConfigDict(populate_by_name=True)
  688. collection_name: str = Field(..., alias="collectionName")
  689. unit: Optional[str] = None
  690. order_num: Optional[int] = Field(0, alias="orderNum")
  691. remark: Optional[str] = None
  692. class ProcessCreateBody(BaseModel):
  693. model_config = ConfigDict(populate_by_name=True)
  694. process_code: str = Field(..., alias="processCode")
  695. category_id: Optional[str] = Field(None, alias="categoryId")
  696. process_name: str = Field(..., alias="processName")
  697. description: Optional[str] = None
  698. equipment_name: Optional[str] = Field(None, alias="equipmentName")
  699. estimated_duration: Optional[str] = Field(None, alias="estimatedDuration")
  700. sop_ids: Optional[str] = Field(None, alias="sopIds")
  701. order_num: Optional[int] = Field(0, alias="orderNum")
  702. remark: Optional[str] = None
  703. reagents: List[ProcessReagentInput] = []
  704. consumables: List[ProcessConsumableInput] = []
  705. outputs: List[ProcessOutputInput] = []
  706. data_collections: List[ProcessDataCollectionInput] = Field([], alias="dataCollections")
  707. class ProcessUpdateBody(BaseModel):
  708. model_config = ConfigDict(populate_by_name=True)
  709. process_code: Optional[str] = Field(None, alias="processCode")
  710. category_id: Optional[str] = Field(None, alias="categoryId")
  711. process_name: Optional[str] = Field(None, alias="processName")
  712. description: Optional[str] = None
  713. equipment_name: Optional[str] = Field(None, alias="equipmentName")
  714. estimated_duration: Optional[str] = Field(None, alias="estimatedDuration")
  715. sop_ids: Optional[str] = Field(None, alias="sopIds")
  716. order_num: Optional[int] = Field(None, alias="orderNum")
  717. remark: Optional[str] = None
  718. reagents: Optional[List[ProcessReagentInput]] = None
  719. consumables: Optional[List[ProcessConsumableInput]] = None
  720. outputs: Optional[List[ProcessOutputInput]] = None
  721. data_collections: Optional[List[ProcessDataCollectionInput]] = Field(None, alias="dataCollections")
  722. @router.get("/processes")
  723. async def list_processes(
  724. page: int = Query(1, ge=1),
  725. pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
  726. keyword: Optional[str] = None,
  727. user: dict = Depends(require_menu_code("production:process:list")),
  728. db: Session = Depends(get_db),
  729. ):
  730. tenant_no = _get_tenant_no(db, user)
  731. items, total = process_svc.list_processes(db, page=page, page_size=pageSize, keyword=keyword, tenant_no=tenant_no)
  732. tp = process_svc.total_pages(total, pageSize)
  733. return success_response({"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp})
  734. @router.get("/processes/all")
  735. async def list_all_processes(
  736. user: dict = Depends(require_admin_or_super_admin),
  737. db: Session = Depends(get_db),
  738. ):
  739. tenant_no = _get_tenant_no(db, user)
  740. items = process_svc.list_all_processes(db, tenant_no)
  741. return success_response(items)
  742. @router.get("/processes/{process_id}")
  743. async def get_process_detail(
  744. process_id: str,
  745. user: dict = Depends(require_admin_or_super_admin),
  746. db: Session = Depends(get_db),
  747. ):
  748. detail = process_svc.get_process_detail(db, process_id)
  749. if not detail:
  750. return error_response(404, "工艺不存在")
  751. return success_response(detail)
  752. @router.post("/processes")
  753. async def create_process(
  754. body: ProcessCreateBody,
  755. user: dict = Depends(require_admin_or_super_admin),
  756. db: Session = Depends(get_db),
  757. ):
  758. try:
  759. tenant_no = _get_tenant_no(db, user)
  760. reagents_data = [r.model_dump(by_alias=False) for r in body.reagents] if body.reagents else None
  761. consumables_data = [c.model_dump(by_alias=False) for c in body.consumables] if body.consumables else None
  762. outputs_data = [o.model_dump(by_alias=False) for o in body.outputs] if body.outputs else None
  763. data_collections_data = [d.model_dump(by_alias=False) for d in body.data_collections] if body.data_collections else None
  764. # Convert string fields to appropriate types for sub-records
  765. for rd in (reagents_data or []):
  766. if "is_key_material" in rd and isinstance(rd["is_key_material"], str):
  767. rd["is_key_material"] = int(rd["is_key_material"])
  768. for cd in (consumables_data or []):
  769. if "is_required" in cd and isinstance(cd["is_required"], str):
  770. cd["is_required"] = int(cd["is_required"])
  771. obj = process_svc.create_process(
  772. db,
  773. process_code=body.process_code,
  774. category_id=body.category_id,
  775. process_name=body.process_name,
  776. description=body.description,
  777. equipment_name=body.equipment_name,
  778. estimated_duration=body.estimated_duration,
  779. sop_ids=body.sop_ids,
  780. reagents=reagents_data,
  781. consumables=consumables_data,
  782. outputs=outputs_data,
  783. data_collections=data_collections_data,
  784. tenant_no=tenant_no,
  785. order_num=body.order_num,
  786. remark=body.remark,
  787. user_id=user.get("user_id"),
  788. )
  789. return success_response(process_svc._row_to_dict(obj), message="创建成功")
  790. except ValueError as e:
  791. return error_response(400, str(e))
  792. @router.put("/processes/{process_id}")
  793. async def update_process(
  794. process_id: str,
  795. body: ProcessUpdateBody,
  796. user: dict = Depends(require_admin_or_super_admin),
  797. db: Session = Depends(get_db),
  798. ):
  799. try:
  800. payload: dict[str, Any] = body.model_dump(exclude_unset=True, by_alias=False)
  801. reagents_data = [r.model_dump(by_alias=False) for r in body.reagents] if body.reagents is not None else None
  802. consumables_data = [c.model_dump(by_alias=False) for c in body.consumables] if body.consumables is not None else None
  803. outputs_data = [o.model_dump(by_alias=False) for o in body.outputs] if body.outputs is not None else None
  804. data_collections_data = [d.model_dump(by_alias=False) for d in body.data_collections] if body.data_collections is not None else None
  805. # Convert string fields to appropriate types for sub-records
  806. for rd in (reagents_data or []):
  807. if "is_key_material" in rd and isinstance(rd["is_key_material"], str):
  808. rd["is_key_material"] = int(rd["is_key_material"])
  809. for cd in (consumables_data or []):
  810. if "is_required" in cd and isinstance(cd["is_required"], str):
  811. cd["is_required"] = int(cd["is_required"])
  812. obj = process_svc.update_process(
  813. db,
  814. process_id,
  815. process_code=payload.get("process_code"),
  816. category_id=payload.get("category_id"),
  817. process_name=payload.get("process_name"),
  818. description=payload.get("description"),
  819. equipment_name=payload.get("equipment_name"),
  820. estimated_duration=payload.get("estimated_duration"),
  821. sop_ids=payload.get("sop_ids"),
  822. reagents=reagents_data,
  823. consumables=consumables_data,
  824. outputs=outputs_data,
  825. data_collections=data_collections_data,
  826. order_num=payload.get("order_num"),
  827. remark=payload.get("remark"),
  828. user_id=user.get("user_id"),
  829. )
  830. return success_response(process_svc._row_to_dict(obj), message="更新成功")
  831. except ValueError as e:
  832. return error_response(400, str(e))
  833. @router.delete("/processes/{process_id}")
  834. async def delete_process(
  835. process_id: str,
  836. _user: dict = Depends(require_admin_or_super_admin),
  837. db: Session = Depends(get_db),
  838. ):
  839. try:
  840. process_svc.soft_delete_process(db, process_id)
  841. return success_response(None, message="删除成功")
  842. except ValueError as e:
  843. return error_response(400, str(e))
  844. # ---------------------------------------------------------------------------
  845. # 8. 工艺路线管理
  846. # ---------------------------------------------------------------------------
  847. @router.get("/process-routes")
  848. async def list_process_routes(
  849. page: int = Query(1, ge=1),
  850. pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
  851. routeName: Optional[str] = None,
  852. routeCode: Optional[str] = None,
  853. productTypeId: Optional[str] = None,
  854. user: dict = Depends(require_menu_code("production:process-route:list")),
  855. db: Session = Depends(get_db),
  856. ):
  857. tenant_no = _get_tenant_no(db, user)
  858. items, total = route_svc.list_routes(
  859. db, page=page, page_size=pageSize,
  860. route_name=routeName, route_code=routeCode,
  861. product_type_id=productTypeId, tenant_no=tenant_no,
  862. )
  863. tp = route_svc.total_pages(total, pageSize)
  864. return success_response({"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp})
  865. @router.get("/process-routes/{route_id}")
  866. async def get_process_route_detail(
  867. route_id: str,
  868. _user: dict = Depends(require_admin_or_super_admin),
  869. db: Session = Depends(get_db),
  870. ):
  871. detail = route_svc.get_route_detail(db, route_id)
  872. if not detail:
  873. return error_response(404, "路线不存在")
  874. return success_response(detail)
  875. @router.post("/process-routes")
  876. async def create_process_route(
  877. body: ProcessRouteCreateBody,
  878. user: dict = Depends(require_admin_or_super_admin),
  879. db: Session = Depends(get_db),
  880. ):
  881. try:
  882. tenant_no = _get_tenant_no(db, user)
  883. obj = route_svc.create_route(
  884. db,
  885. route_code=body.route_code,
  886. route_name=body.route_name,
  887. product_type_id=body.product_type_id,
  888. version=body.version,
  889. remark=body.remark,
  890. tenant_no=tenant_no,
  891. user_id=user.get("user_id"),
  892. )
  893. return success_response(route_svc._route_row_to_dict(obj), message="创建成功")
  894. except ValueError as e:
  895. return error_response(400, str(e))
  896. @router.put("/process-routes/{route_id}")
  897. async def update_process_route(
  898. route_id: str,
  899. body: ProcessRouteUpdateBody,
  900. user: dict = Depends(require_admin_or_super_admin),
  901. db: Session = Depends(get_db),
  902. ):
  903. try:
  904. payload = body.model_dump(exclude_unset=True, by_alias=False)
  905. obj = route_svc.update_route(
  906. db, route_id,
  907. user_id=user.get("user_id"),
  908. route_code=payload.get("route_code"),
  909. route_name=payload.get("route_name"),
  910. product_type_id=payload.get("product_type_id"),
  911. version=payload.get("version"),
  912. remark=payload.get("remark"),
  913. )
  914. return success_response(route_svc._route_row_to_dict(obj), message="更新成功")
  915. except ValueError as e:
  916. return error_response(400, str(e))
  917. @router.put("/process-routes/set-current")
  918. async def set_current_process_route(
  919. body: SetCurrentBody,
  920. user: dict = Depends(require_admin_or_super_admin),
  921. db: Session = Depends(get_db),
  922. ):
  923. try:
  924. tenant_no = _get_tenant_no(db, user)
  925. obj = route_svc.set_current_route(db, body.route_id, tenant_no)
  926. return success_response(route_svc._route_row_to_dict(obj), message="设置成功")
  927. except ValueError as e:
  928. return error_response(400, str(e))
  929. @router.delete("/process-routes/{route_id}")
  930. async def delete_process_route(
  931. route_id: str,
  932. _user: dict = Depends(require_admin_or_super_admin),
  933. db: Session = Depends(get_db),
  934. ):
  935. try:
  936. route_svc.soft_delete_route(db, route_id)
  937. return success_response(None, message="删除成功")
  938. except ValueError as e:
  939. return error_response(400, str(e))
  940. # ----- 步骤操作 -----
  941. @router.post("/process-routes/step/add")
  942. async def add_route_step(
  943. body: StepAddBody,
  944. user: dict = Depends(require_admin_or_super_admin),
  945. db: Session = Depends(get_db),
  946. ):
  947. try:
  948. tenant_no = _get_tenant_no(db, user)
  949. step_data = route_svc.add_step(
  950. db,
  951. route_id=body.route_id,
  952. process_id=body.process_id,
  953. step_order=body.step_order,
  954. tenant_no=tenant_no,
  955. user_id=user.get("user_id"),
  956. )
  957. return success_response(step_data, message="添加成功")
  958. except ValueError as e:
  959. return error_response(400, str(e))
  960. @router.post("/process-routes/step/copy")
  961. async def copy_route_step(
  962. body: StepCopyBody,
  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. step_data = route_svc.copy_step(
  969. db,
  970. step_id=body.step_id,
  971. tenant_no=tenant_no,
  972. user_id=user.get("user_id"),
  973. )
  974. return success_response(step_data, message="复制成功")
  975. except ValueError as e:
  976. return error_response(400, str(e))
  977. @router.put("/process-routes/step/update")
  978. async def update_route_step(
  979. body: StepUpdateBody,
  980. user: dict = Depends(require_admin_or_super_admin),
  981. db: Session = Depends(get_db),
  982. ):
  983. try:
  984. payload = body.model_dump(exclude_unset=True, by_alias=False)
  985. payload.pop("step_id", None)
  986. obj = route_svc.update_step(db, body.step_id, user_id=user.get("user_id"), **payload)
  987. return success_response(route_svc._step_row_to_dict(obj), message="更新成功")
  988. except ValueError as e:
  989. return error_response(400, str(e))
  990. @router.put("/process-routes/step/reorder")
  991. async def reorder_route_steps(
  992. body: StepReorderBody,
  993. _user: dict = Depends(require_admin_or_super_admin),
  994. db: Session = Depends(get_db),
  995. ):
  996. try:
  997. route_svc.reorder_steps(db, body.route_id, body.step_ids)
  998. return success_response(None, message="排序成功")
  999. except ValueError as e:
  1000. return error_response(400, str(e))
  1001. @router.delete("/process-routes/step/{step_id}")
  1002. async def delete_route_step(
  1003. step_id: str,
  1004. _user: dict = Depends(require_admin_or_super_admin),
  1005. db: Session = Depends(get_db),
  1006. ):
  1007. try:
  1008. route_svc.soft_delete_step(db, step_id)
  1009. return success_response(None, message="删除成功")
  1010. except ValueError as e:
  1011. return error_response(400, str(e))
  1012. # ----- 步骤子表 -----
  1013. @router.put("/process-routes/step/reagent/update")
  1014. async def update_step_reagents(
  1015. body: StepReagentUpdateBody,
  1016. user: dict = Depends(require_admin_or_super_admin),
  1017. db: Session = Depends(get_db),
  1018. ):
  1019. try:
  1020. tenant_no = _get_tenant_no(db, user)
  1021. items_data = [it.model_dump(by_alias=False) for it in body.items]
  1022. route_svc.update_step_reagents(db, body.step_id, items_data, tenant_no, user.get("user_id"))
  1023. return success_response(None, message="更新成功")
  1024. except ValueError as e:
  1025. return error_response(400, str(e))
  1026. @router.put("/process-routes/step/consumable/update")
  1027. async def update_step_consumables(
  1028. body: StepConsumableUpdateBody,
  1029. user: dict = Depends(require_admin_or_super_admin),
  1030. db: Session = Depends(get_db),
  1031. ):
  1032. try:
  1033. tenant_no = _get_tenant_no(db, user)
  1034. items_data = [it.model_dump(by_alias=False) for it in body.items]
  1035. route_svc.update_step_consumables(db, body.step_id, items_data, tenant_no, user.get("user_id"))
  1036. return success_response(None, message="更新成功")
  1037. except ValueError as e:
  1038. return error_response(400, str(e))
  1039. @router.put("/process-routes/step/output/update")
  1040. async def update_step_outputs(
  1041. body: StepOutputUpdateBody,
  1042. user: dict = Depends(require_admin_or_super_admin),
  1043. db: Session = Depends(get_db),
  1044. ):
  1045. try:
  1046. tenant_no = _get_tenant_no(db, user)
  1047. items_data = [it.model_dump(by_alias=False) for it in body.items]
  1048. route_svc.update_step_outputs(db, body.step_id, items_data, tenant_no, user.get("user_id"))
  1049. return success_response(None, message="更新成功")
  1050. except ValueError as e:
  1051. return error_response(400, str(e))
  1052. @router.put("/process-routes/step/data-collection/update")
  1053. async def update_step_data_collections(
  1054. body: StepDataCollectionUpdateBody,
  1055. user: dict = Depends(require_admin_or_super_admin),
  1056. db: Session = Depends(get_db),
  1057. ):
  1058. try:
  1059. tenant_no = _get_tenant_no(db, user)
  1060. items_data = [it.model_dump(by_alias=False) for it in body.items]
  1061. route_svc.update_step_data_collections(db, body.step_id, items_data, tenant_no, user.get("user_id"))
  1062. return success_response(None, message="更新成功")
  1063. except ValueError as e:
  1064. return error_response(400, str(e))
  1065. # ---------------------------------------------------------------------------
  1066. # 9. 入库生产工单
  1067. # ---------------------------------------------------------------------------
  1068. @router.get("/production-work-orders")
  1069. async def list_production_work_orders(
  1070. page: int = Query(1, ge=1),
  1071. pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
  1072. workOrderNo: Optional[str] = None,
  1073. workOrderStatus: Optional[str] = None,
  1074. protocolNo: Optional[str] = None,
  1075. sampleCode: Optional[str] = None,
  1076. user: dict = Depends(require_admin_or_super_admin),
  1077. db: Session = Depends(get_db),
  1078. ):
  1079. tenant_no = _get_tenant_no(db, user)
  1080. query = ProductionWorkOrderListQuery(
  1081. page=page, page_size=pageSize,
  1082. work_order_no=workOrderNo, work_order_status=workOrderStatus,
  1083. protocol_no=protocolNo, sample_code=sampleCode,
  1084. )
  1085. result = production_work_order_svc.list_production_work_orders(
  1086. db, tenant_no=tenant_no, query=query, page=page, page_size=pageSize,
  1087. )
  1088. items = result.get("items", [])
  1089. total = result.get("total", 0)
  1090. tp = production_task_svc.total_pages(total, pageSize)
  1091. return success_response({"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp})
  1092. @router.get("/production-work-orders/{wo_id}")
  1093. async def get_production_work_order(
  1094. wo_id: str,
  1095. user: dict = Depends(require_admin_or_super_admin),
  1096. db: Session = Depends(get_db),
  1097. ):
  1098. tenant_no = _get_tenant_no(db, user)
  1099. wo = production_work_order_svc.get_production_work_order(db, wo_id, tenant_no)
  1100. if not wo:
  1101. return error_response(404, "工单不存在")
  1102. return success_response(production_work_order_svc._wo_to_dict(wo))
  1103. @router.put("/production-work-orders/{wo_id}/complete")
  1104. async def complete_production_work_order(
  1105. wo_id: str,
  1106. body: ProductionWorkOrderComplete,
  1107. user: dict = Depends(require_admin_or_super_admin),
  1108. db: Session = Depends(get_db),
  1109. ):
  1110. try:
  1111. tenant_no = _get_tenant_no(db, user)
  1112. wo = production_work_order_svc.complete_production_work_order(
  1113. db, wo_id, tenant_no, user.get("user_id"), body,
  1114. )
  1115. return success_response(production_work_order_svc._wo_to_dict(wo), message="操作成功")
  1116. except ValueError as e:
  1117. return error_response(400, str(e))
  1118. # ---------------------------------------------------------------------------
  1119. # 10. 生产任务
  1120. # ---------------------------------------------------------------------------
  1121. @router.post("/production-tasks")
  1122. async def create_production_task(
  1123. body: ProductionTaskCreate,
  1124. user: dict = Depends(require_admin_or_super_admin),
  1125. db: Session = Depends(get_db),
  1126. ):
  1127. try:
  1128. tenant_no = _get_tenant_no(db, user)
  1129. data = body.model_dump(by_alias=False)
  1130. task = production_task_svc.create_production_task(
  1131. db, tenant_no=tenant_no, user_id=user.get("user_id"),
  1132. create_dept_id="", data=data,
  1133. )
  1134. db.commit()
  1135. return success_response(production_task_svc._task_to_dict(task), message="创建成功")
  1136. except ValueError as e:
  1137. return error_response(400, str(e))
  1138. @router.get("/production-tasks")
  1139. async def list_production_tasks(
  1140. page: int = Query(1, ge=1),
  1141. pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
  1142. workOrderId: Optional[str] = None,
  1143. taskNo: Optional[str] = None,
  1144. taskStatus: Optional[str] = None,
  1145. user: dict = Depends(require_admin_or_super_admin),
  1146. db: Session = Depends(get_db),
  1147. ):
  1148. tenant_no = _get_tenant_no(db, user)
  1149. items, total = production_task_svc.list_production_tasks(
  1150. db, tenant_no=tenant_no, page=page, page_size=pageSize,
  1151. work_order_id=workOrderId, task_no=taskNo, task_status=taskStatus,
  1152. )
  1153. tp = production_task_svc.total_pages(total, pageSize)
  1154. return success_response({"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp})
  1155. @router.get("/production-tasks/{task_id}")
  1156. async def get_production_task_detail(
  1157. task_id: str,
  1158. user: dict = Depends(require_admin_or_super_admin),
  1159. db: Session = Depends(get_db),
  1160. ):
  1161. tenant_no = _get_tenant_no(db, user)
  1162. detail = production_task_svc.get_production_task_detail(db, task_id, tenant_no)
  1163. if not detail:
  1164. return error_response(404, "任务不存在")
  1165. return success_response(detail)
  1166. @router.put("/production-tasks/{task_id}")
  1167. async def update_production_task(
  1168. task_id: str,
  1169. body: ProductionTaskUpdate,
  1170. user: dict = Depends(require_admin_or_super_admin),
  1171. db: Session = Depends(get_db),
  1172. ):
  1173. try:
  1174. tenant_no = _get_tenant_no(db, user)
  1175. data = body.model_dump(exclude_unset=True, by_alias=False)
  1176. task = production_task_svc.update_production_task(
  1177. db, task_id, tenant_no, user.get("user_id"), data,
  1178. )
  1179. return success_response(production_task_svc._task_to_dict(task), message="更新成功")
  1180. except ValueError as e:
  1181. return error_response(400, str(e))
  1182. @router.put("/production-tasks/{task_id}/status")
  1183. async def update_production_task_status(
  1184. task_id: str,
  1185. body: ProductionTaskStatusUpdate,
  1186. user: dict = Depends(require_admin_or_super_admin),
  1187. db: Session = Depends(get_db),
  1188. ):
  1189. try:
  1190. tenant_no = _get_tenant_no(db, user)
  1191. task = production_task_svc.update_task_status(
  1192. db, task_id, tenant_no, user.get("user_id"), body.task_status,
  1193. )
  1194. return success_response(production_task_svc._task_to_dict(task), message="操作成功")
  1195. except ValueError as e:
  1196. return error_response(400, str(e))
  1197. @router.post("/production-tasks/{task_id}/steps")
  1198. async def add_production_task_step(
  1199. task_id: str,
  1200. body: TaskStepAdd,
  1201. user: dict = Depends(require_admin_or_super_admin),
  1202. db: Session = Depends(get_db),
  1203. ):
  1204. try:
  1205. tenant_no = _get_tenant_no(db, user)
  1206. data = body.model_dump(by_alias=False)
  1207. step_data = production_task_svc.add_task_step(
  1208. db, task_id, tenant_no, user.get("user_id"), data,
  1209. )
  1210. return success_response(step_data, message="添加成功")
  1211. except ValueError as e:
  1212. return error_response(400, str(e))
  1213. @router.put("/production-tasks/{task_id}/steps/{step_id}")
  1214. async def update_production_task_step(
  1215. task_id: str,
  1216. step_id: str,
  1217. body: TaskStepUpdate,
  1218. user: dict = Depends(require_admin_or_super_admin),
  1219. db: Session = Depends(get_db),
  1220. ):
  1221. try:
  1222. tenant_no = _get_tenant_no(db, user)
  1223. data = body.model_dump(exclude_unset=True, by_alias=False)
  1224. step = production_task_svc.update_task_step(
  1225. db, step_id, tenant_no, user.get("user_id"), data,
  1226. )
  1227. return success_response(production_task_svc._step_to_dict(step), message="更新成功")
  1228. except ValueError as e:
  1229. return error_response(400, str(e))
  1230. @router.delete("/production-tasks/{task_id}/steps/{step_id}")
  1231. async def delete_production_task_step(
  1232. task_id: str,
  1233. step_id: str,
  1234. user: dict = Depends(require_admin_or_super_admin),
  1235. db: Session = Depends(get_db),
  1236. ):
  1237. try:
  1238. tenant_no = _get_tenant_no(db, user)
  1239. production_task_svc.delete_task_step(db, step_id, tenant_no, user.get("user_id"))
  1240. return success_response(None, message="删除成功")
  1241. except ValueError as e:
  1242. return error_response(400, str(e))
  1243. @router.put("/production-tasks/{task_id}/steps/{step_id}/reagents")
  1244. async def replace_task_step_reagents(
  1245. task_id: str,
  1246. step_id: str,
  1247. body: List[TaskStepMaterialItem],
  1248. user: dict = Depends(require_admin_or_super_admin),
  1249. db: Session = Depends(get_db),
  1250. ):
  1251. try:
  1252. tenant_no = _get_tenant_no(db, user)
  1253. items_data = []
  1254. for it in body:
  1255. d = it.model_dump(by_alias=False)
  1256. items_data.append({
  1257. "reagent_code": d.get("material_code"),
  1258. "reagent_name": d.get("material_name"),
  1259. "spec": d.get("spec"),
  1260. "standard_usage": d.get("standard_usage"),
  1261. "actual_usage": d.get("actual_usage"),
  1262. "unit": d.get("unit"),
  1263. "is_key_material": d.get("is_key_material", "0"),
  1264. "remark": d.get("remark"),
  1265. })
  1266. production_task_svc.replace_step_reagents(db, step_id, tenant_no, user.get("user_id"), items_data)
  1267. return success_response(None, message="更新成功")
  1268. except ValueError as e:
  1269. return error_response(400, str(e))
  1270. @router.put("/production-tasks/{task_id}/steps/{step_id}/consumables")
  1271. async def replace_task_step_consumables(
  1272. task_id: str,
  1273. step_id: str,
  1274. body: List[TaskStepMaterialItem],
  1275. user: dict = Depends(require_admin_or_super_admin),
  1276. db: Session = Depends(get_db),
  1277. ):
  1278. try:
  1279. tenant_no = _get_tenant_no(db, user)
  1280. items_data = []
  1281. for it in body:
  1282. d = it.model_dump(by_alias=False)
  1283. items_data.append({
  1284. "consumable_code": d.get("material_code"),
  1285. "consumable_name": d.get("material_name"),
  1286. "spec_model": d.get("spec_model"),
  1287. "standard_usage": d.get("standard_usage"),
  1288. "actual_usage": d.get("actual_usage"),
  1289. "unit": d.get("unit"),
  1290. "is_required": d.get("is_required", "1"),
  1291. "remark": d.get("remark"),
  1292. })
  1293. production_task_svc.replace_step_consumables(db, step_id, tenant_no, user.get("user_id"), items_data)
  1294. return success_response(None, message="更新成功")
  1295. except ValueError as e:
  1296. return error_response(400, str(e))
  1297. @router.put("/production-tasks/{task_id}/steps/{step_id}/data-collection")
  1298. async def replace_task_step_data_collections(
  1299. task_id: str,
  1300. step_id: str,
  1301. body: List[TaskStepDataCollectionItem],
  1302. user: dict = Depends(require_admin_or_super_admin),
  1303. db: Session = Depends(get_db),
  1304. ):
  1305. try:
  1306. tenant_no = _get_tenant_no(db, user)
  1307. items_data = [it.model_dump(by_alias=False) for it in body]
  1308. production_task_svc.replace_step_data_collections(db, step_id, tenant_no, user.get("user_id"), items_data)
  1309. return success_response(None, message="更新成功")
  1310. except ValueError as e:
  1311. return error_response(400, str(e))
  1312. @router.post("/production-tasks/{task_id}/inputs")
  1313. async def set_production_task_inputs(
  1314. task_id: str,
  1315. body: List[TaskInputItem],
  1316. user: dict = Depends(require_admin_or_super_admin),
  1317. db: Session = Depends(get_db),
  1318. ):
  1319. try:
  1320. tenant_no = _get_tenant_no(db, user)
  1321. items_data = [it.model_dump(by_alias=False) for it in body]
  1322. production_task_svc.set_task_inputs(db, task_id, tenant_no, user.get("user_id"), items_data)
  1323. return success_response(None, message="设置成功")
  1324. except ValueError as e:
  1325. return error_response(400, str(e))
  1326. @router.post("/production-tasks/{task_id}/outputs")
  1327. async def set_production_task_outputs(
  1328. task_id: str,
  1329. body: List[TaskOutputItem],
  1330. user: dict = Depends(require_admin_or_super_admin),
  1331. db: Session = Depends(get_db),
  1332. ):
  1333. try:
  1334. tenant_no = _get_tenant_no(db, user)
  1335. items_data = [it.model_dump(by_alias=False) for it in body]
  1336. production_task_svc.set_task_outputs(db, task_id, tenant_no, user.get("user_id"), items_data)
  1337. return success_response(None, message="设置成功")
  1338. except ValueError as e:
  1339. return error_response(400, str(e))
  1340. # ---------------------------------------------------------------------------
  1341. # 11. 细胞产品库
  1342. # ---------------------------------------------------------------------------
  1343. @router.get("/cell-products")
  1344. async def list_cell_products(
  1345. page: int = Query(1, ge=1),
  1346. pageSize: int = Query(10, ge=1, le=100, alias="pageSize"),
  1347. productCode: Optional[str] = None,
  1348. productName: Optional[str] = None,
  1349. productTypeId: Optional[str] = None,
  1350. productStatus: Optional[str] = None,
  1351. user: dict = Depends(require_admin_or_super_admin),
  1352. db: Session = Depends(get_db),
  1353. ):
  1354. tenant_no = _get_tenant_no(db, user)
  1355. result = cell_product_svc.list_cell_products(
  1356. db, tenant_no=tenant_no, page=page, page_size=pageSize,
  1357. product_code=productCode, product_name=productName,
  1358. product_type_id=productTypeId, product_status=productStatus,
  1359. )
  1360. items = result.get("items", [])
  1361. total = result.get("total", 0)
  1362. tp = cell_product_svc.total_pages(total, pageSize)
  1363. return success_response({"list": items, "total": total, "page": page, "pageSize": pageSize, "totalPages": tp})
  1364. @router.get("/cell-products/{product_id}")
  1365. async def get_cell_product_detail(
  1366. product_id: str,
  1367. user: dict = Depends(require_admin_or_super_admin),
  1368. db: Session = Depends(get_db),
  1369. ):
  1370. tenant_no = _get_tenant_no(db, user)
  1371. obj = cell_product_svc.get_cell_product(db, product_id, tenant_no)
  1372. if not obj:
  1373. return error_response(404, "细胞产品不存在")
  1374. return success_response(cell_product_svc._row_to_dict(obj))
  1375. @router.post("/cell-products")
  1376. async def create_cell_product(
  1377. body: CellProductCreate,
  1378. user: dict = Depends(require_admin_or_super_admin),
  1379. db: Session = Depends(get_db),
  1380. ):
  1381. try:
  1382. tenant_no = _get_tenant_no(db, user)
  1383. obj = cell_product_svc.create_cell_product(
  1384. db, tenant_no=tenant_no, user_id=user.get("user_id"),
  1385. create_dept_id="", data=body,
  1386. )
  1387. return success_response(cell_product_svc._row_to_dict(obj), message="创建成功")
  1388. except ValueError as e:
  1389. return error_response(400, str(e))
  1390. @router.put("/cell-products/{product_id}")
  1391. async def update_cell_product(
  1392. product_id: str,
  1393. body: CellProductUpdate,
  1394. user: dict = Depends(require_admin_or_super_admin),
  1395. db: Session = Depends(get_db),
  1396. ):
  1397. try:
  1398. tenant_no = _get_tenant_no(db, user)
  1399. obj = cell_product_svc.update_cell_product(
  1400. db, product_id, tenant_no, user.get("user_id"), data=body,
  1401. )
  1402. return success_response(cell_product_svc._row_to_dict(obj), message="更新成功")
  1403. except ValueError as e:
  1404. return error_response(400, str(e))
  1405. @router.delete("/cell-products/{product_id}")
  1406. async def delete_cell_product(
  1407. product_id: str,
  1408. user: dict = Depends(require_admin_or_super_admin),
  1409. db: Session = Depends(get_db),
  1410. ):
  1411. try:
  1412. tenant_no = _get_tenant_no(db, user)
  1413. cell_product_svc.delete_cell_product(db, product_id, tenant_no, user.get("user_id"))
  1414. return success_response(None, message="删除成功")
  1415. except ValueError as e:
  1416. return error_response(400, str(e))