qc.py 45 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325
  1. """质量检测 — 第三方/实验室主数据、质检工单、质检任务 API"""
  2. from typing import Any, Dict, List, Optional
  3. from fastapi import APIRouter, Depends, HTTPException, Query
  4. from pydantic import BaseModel, ConfigDict, Field
  5. from sqlalchemy.orm import Session
  6. from datetime import datetime
  7. from decimal import Decimal
  8. from app.core.database import get_db
  9. from app.core.menu_guard import require_admin_or_super_admin, require_menu_code
  10. from app.core.response import error_response, success_response
  11. from app.core.utils import parse_datetime
  12. from app.crud import qc_lab_test_item as lab_svc
  13. from app.crud import qc_item_param as param_svc
  14. from app.crud import qc_task_result as result_svc
  15. from app.crud import qc_task as task_svc
  16. from app.crud import qc_third_party_company as tpc_svc
  17. from app.crud import qc_third_party_item as tpi_svc
  18. from app.crud import qc_material as mat_svc
  19. from app.crud import qc_material_usage as mu_svc
  20. from app.crud import qc_work_order as wo_svc
  21. from app.crud.collection_protocol import total_pages
  22. from app.api.sample_reception import _get_current_user_id, _get_tenant_no, _page_payload
  23. from app.schemas.qc_work_order import QcWorkOrderCreateBody, QcWorkOrderUpdateBody
  24. from app.schemas.qc_task import QcTaskCreateBody
  25. router = APIRouter(prefix="/web/admin", tags=["质量检测"])
  26. # ---------- 第三方检测公司 ----------
  27. class ThirdPartyCompanyBody(BaseModel):
  28. model_config = ConfigDict(populate_by_name=True)
  29. company_code: str = Field(..., alias="companyCode")
  30. company_name: str = Field(..., alias="companyName")
  31. contact_name: Optional[str] = Field(None, alias="contactName")
  32. contact_phone: Optional[str] = Field(None, alias="contactPhone")
  33. address: Optional[str] = None
  34. invoice_title: Optional[str] = Field(None, alias="invoiceTitle")
  35. tax_id: Optional[str] = Field(None, alias="taxId")
  36. bank_name: Optional[str] = Field(None, alias="bankName")
  37. bank_account: Optional[str] = Field(None, alias="bankAccount")
  38. status: str = "1"
  39. order_num: Optional[int] = Field(None, alias="orderNum")
  40. remark: Optional[str] = None
  41. class ThirdPartyCompanyUpdateBody(BaseModel):
  42. model_config = ConfigDict(populate_by_name=True)
  43. company_code: Optional[str] = Field(None, alias="companyCode")
  44. company_name: Optional[str] = Field(None, alias="companyName")
  45. contact_name: Optional[str] = Field(None, alias="contactName")
  46. contact_phone: Optional[str] = Field(None, alias="contactPhone")
  47. address: Optional[str] = None
  48. invoice_title: Optional[str] = Field(None, alias="invoiceTitle")
  49. tax_id: Optional[str] = Field(None, alias="taxId")
  50. bank_name: Optional[str] = Field(None, alias="bankName")
  51. bank_account: Optional[str] = Field(None, alias="bankAccount")
  52. status: Optional[str] = None
  53. order_num: Optional[int] = Field(None, alias="orderNum")
  54. remark: Optional[str] = None
  55. @router.get("/qc-third-party-companies")
  56. async def list_qc_third_party_companies(
  57. page: int = Query(1, ge=1),
  58. pageSize: int = Query(10, ge=1, le=100),
  59. keyword: Optional[str] = None,
  60. status: Optional[str] = None,
  61. db: Session = Depends(get_db),
  62. user: dict = Depends(require_menu_code("biz:qcThirdPartyCompany:list")),
  63. ):
  64. try:
  65. tenant_no = _get_tenant_no(db, user)
  66. items, total = tpc_svc.list_companies(
  67. db, page=page, page_size=pageSize, keyword=keyword, status=status, tenant_no=tenant_no,
  68. user_info=user
  69. )
  70. return success_response(_page_payload(items, total, page, pageSize))
  71. except PermissionError as e:
  72. return error_response(403, str(e))
  73. except Exception as e:
  74. return error_response(400, str(e))
  75. @router.get("/qc-third-party-companies/options")
  76. async def list_qc_third_party_company_options(
  77. db: Session = Depends(get_db),
  78. user: dict = Depends(require_menu_code("biz:qcWorkOrder:list")),
  79. ):
  80. try:
  81. tenant_no = _get_tenant_no(db, user)
  82. return success_response(tpc_svc.list_company_options(db, tenant_no))
  83. except PermissionError as e:
  84. return error_response(403, str(e))
  85. except Exception as e:
  86. return error_response(400, str(e))
  87. @router.post("/qc-third-party-companies")
  88. async def create_qc_third_party_company(
  89. body: ThirdPartyCompanyBody,
  90. db: Session = Depends(get_db),
  91. user: dict = Depends(require_menu_code("biz:qcThirdPartyCompany:list")),
  92. ):
  93. try:
  94. tenant_no = _get_tenant_no(db, user)
  95. obj = tpc_svc.create_company(
  96. db,
  97. company_code=body.company_code,
  98. company_name=body.company_name,
  99. contact_name=body.contact_name,
  100. contact_phone=body.contact_phone,
  101. address=body.address,
  102. invoice_title=body.invoice_title,
  103. tax_id=body.tax_id,
  104. bank_name=body.bank_name,
  105. bank_account=body.bank_account,
  106. status=body.status,
  107. tenant_no=tenant_no,
  108. order_num=body.order_num,
  109. remark=body.remark,
  110. user_id=_get_current_user_id(user),
  111. )
  112. return success_response(tpc_svc._row_to_dict(obj), message="创建成功")
  113. except PermissionError as e:
  114. return error_response(403, str(e))
  115. except ValueError as e:
  116. return error_response(400, str(e))
  117. except Exception as e:
  118. return error_response(400, str(e))
  119. @router.put("/qc-third-party-companies/{company_id}")
  120. async def update_qc_third_party_company(
  121. company_id: str,
  122. body: ThirdPartyCompanyUpdateBody,
  123. db: Session = Depends(get_db),
  124. user: dict = Depends(require_menu_code("biz:qcThirdPartyCompany:list")),
  125. ):
  126. try:
  127. tenant_no = _get_tenant_no(db, user)
  128. obj = tpc_svc.update_company(
  129. db,
  130. company_id,
  131. company_code=body.company_code,
  132. company_name=body.company_name,
  133. contact_name=body.contact_name,
  134. contact_phone=body.contact_phone,
  135. address=body.address,
  136. invoice_title=body.invoice_title,
  137. tax_id=body.tax_id,
  138. bank_name=body.bank_name,
  139. bank_account=body.bank_account,
  140. status=body.status,
  141. order_num=body.order_num,
  142. remark=body.remark,
  143. user_id=_get_current_user_id(user),
  144. tenant_no=tenant_no,
  145. )
  146. return success_response(tpc_svc._row_to_dict(obj), message="更新成功")
  147. except PermissionError as e:
  148. return error_response(403, str(e))
  149. except ValueError as e:
  150. return error_response(400, str(e))
  151. except Exception as e:
  152. return error_response(400, str(e))
  153. @router.delete("/qc-third-party-companies/{company_id}")
  154. async def delete_qc_third_party_company(
  155. company_id: str,
  156. db: Session = Depends(get_db),
  157. user: dict = Depends(require_menu_code("biz:qcThirdPartyCompany:list")),
  158. ):
  159. try:
  160. tenant_no = _get_tenant_no(db, user)
  161. tpc_svc.soft_delete_company(db, company_id, tenant_no=tenant_no)
  162. return success_response(None, message="删除成功")
  163. except PermissionError as e:
  164. return error_response(403, str(e))
  165. except ValueError as e:
  166. return error_response(400, str(e))
  167. except Exception as e:
  168. return error_response(400, str(e))
  169. # ---------- 第三方检测项目 ----------
  170. class ThirdPartyItemBody(BaseModel):
  171. model_config = ConfigDict(populate_by_name=True)
  172. company_id: str = Field(..., alias="companyId")
  173. item_code: str = Field(..., alias="itemCode")
  174. item_name: str = Field(..., alias="itemName")
  175. fee_amount: float = Field(..., alias="feeAmount")
  176. status: str = "1"
  177. order_num: Optional[int] = Field(None, alias="orderNum")
  178. remark: Optional[str] = None
  179. class ThirdPartyItemUpdateBody(BaseModel):
  180. model_config = ConfigDict(populate_by_name=True)
  181. company_id: Optional[str] = Field(None, alias="companyId")
  182. item_code: Optional[str] = Field(None, alias="itemCode")
  183. item_name: Optional[str] = Field(None, alias="itemName")
  184. fee_amount: Optional[float] = Field(None, alias="feeAmount")
  185. status: Optional[str] = None
  186. order_num: Optional[int] = Field(None, alias="orderNum")
  187. remark: Optional[str] = None
  188. @router.get("/qc-third-party-items")
  189. async def list_qc_third_party_items(
  190. page: int = Query(1, ge=1),
  191. pageSize: int = Query(10, ge=1, le=100),
  192. keyword: Optional[str] = None,
  193. status: Optional[str] = None,
  194. companyId: Optional[str] = None,
  195. db: Session = Depends(get_db),
  196. user: dict = Depends(require_menu_code("biz:qcThirdPartyCompany:list")),
  197. ):
  198. try:
  199. tenant_no = _get_tenant_no(db, user)
  200. items, total = tpi_svc.list_items(
  201. db,
  202. page=page,
  203. page_size=pageSize,
  204. keyword=keyword,
  205. status=status,
  206. company_id=companyId,
  207. tenant_no=tenant_no,
  208. user_info=user,
  209. )
  210. return success_response(_page_payload(items, total, page, pageSize))
  211. except PermissionError as e:
  212. return error_response(403, str(e))
  213. except Exception as e:
  214. return error_response(400, str(e))
  215. @router.get("/qc-third-party-items/active")
  216. async def list_qc_third_party_items_active(
  217. companyId: Optional[str] = None,
  218. db: Session = Depends(get_db),
  219. user: dict = Depends(require_menu_code("biz:qcWorkOrder:list")),
  220. ):
  221. try:
  222. tenant_no = _get_tenant_no(db, user)
  223. return success_response(tpi_svc.list_active_items(db, tenant_no, company_id=companyId, user_info=user))
  224. except PermissionError as e:
  225. return error_response(403, str(e))
  226. except Exception as e:
  227. return error_response(400, str(e))
  228. @router.post("/qc-third-party-items")
  229. async def create_qc_third_party_item(
  230. body: ThirdPartyItemBody,
  231. db: Session = Depends(get_db),
  232. user: dict = Depends(require_menu_code("biz:qcThirdPartyCompany:list")),
  233. ):
  234. try:
  235. tenant_no = _get_tenant_no(db, user)
  236. obj = tpi_svc.create_item(
  237. db,
  238. company_id=body.company_id,
  239. item_code=body.item_code,
  240. item_name=body.item_name,
  241. fee_amount=body.fee_amount,
  242. status=body.status,
  243. tenant_no=tenant_no,
  244. order_num=body.order_num,
  245. remark=body.remark,
  246. user_id=_get_current_user_id(user),
  247. )
  248. return success_response(tpi_svc._row_to_dict(obj, ""), message="创建成功")
  249. except PermissionError as e:
  250. return error_response(403, str(e))
  251. except ValueError as e:
  252. return error_response(400, str(e))
  253. except Exception as e:
  254. return error_response(400, str(e))
  255. @router.put("/qc-third-party-items/{item_id}")
  256. async def update_qc_third_party_item(
  257. item_id: str,
  258. body: ThirdPartyItemUpdateBody,
  259. db: Session = Depends(get_db),
  260. user: dict = Depends(require_menu_code("biz:qcThirdPartyCompany:list")),
  261. ):
  262. try:
  263. tenant_no = _get_tenant_no(db, user)
  264. obj = tpi_svc.update_item(
  265. db,
  266. item_id,
  267. company_id=body.company_id,
  268. item_code=body.item_code,
  269. item_name=body.item_name,
  270. fee_amount=body.fee_amount,
  271. status=body.status,
  272. order_num=body.order_num,
  273. remark=body.remark,
  274. user_id=_get_current_user_id(user),
  275. tenant_no=tenant_no,
  276. )
  277. return success_response(tpi_svc._row_to_dict(obj, ""), message="更新成功")
  278. except PermissionError as e:
  279. return error_response(403, str(e))
  280. except ValueError as e:
  281. return error_response(400, str(e))
  282. except Exception as e:
  283. return error_response(400, str(e))
  284. @router.delete("/qc-third-party-items/{item_id}")
  285. async def delete_qc_third_party_item(
  286. item_id: str,
  287. db: Session = Depends(get_db),
  288. user: dict = Depends(require_menu_code("biz:qcThirdPartyCompany:list")),
  289. ):
  290. try:
  291. tenant_no = _get_tenant_no(db, user)
  292. tpi_svc.soft_delete_item(db, item_id, tenant_no=tenant_no)
  293. return success_response(None, message="删除成功")
  294. except PermissionError as e:
  295. return error_response(403, str(e))
  296. except ValueError as e:
  297. return error_response(400, str(e))
  298. except Exception as e:
  299. return error_response(400, str(e))
  300. # ---------- 实验室自检项目 ----------
  301. class LabTestItemBody(BaseModel):
  302. model_config = ConfigDict(populate_by_name=True)
  303. item_code: str = Field(..., alias="itemCode")
  304. item_name: str = Field(..., alias="itemName")
  305. description: Optional[str] = None
  306. status: str = "1"
  307. order_num: Optional[int] = Field(None, alias="orderNum")
  308. remark: Optional[str] = None
  309. class LabTestItemUpdateBody(BaseModel):
  310. model_config = ConfigDict(populate_by_name=True)
  311. item_code: Optional[str] = Field(None, alias="itemCode")
  312. item_name: Optional[str] = Field(None, alias="itemName")
  313. description: Optional[str] = None
  314. status: Optional[str] = None
  315. order_num: Optional[int] = Field(None, alias="orderNum")
  316. remark: Optional[str] = None
  317. # ---------- 检测项目参数模板 ----------
  318. class ItemParamBody(BaseModel):
  319. model_config = ConfigDict(populate_by_name=True)
  320. params: List[Dict[str, Any]] = Field(default_factory=list, alias="params")
  321. class TaskResultBody(BaseModel):
  322. model_config = ConfigDict(populate_by_name=True)
  323. results: List[Dict[str, Any]] = Field(default_factory=list, alias="results")
  324. class TaskCompleteWithResultBody(BaseModel):
  325. model_config = ConfigDict(populate_by_name=True)
  326. conclusion: str = Field(..., alias="conclusion")
  327. results: List[Dict[str, Any]] = Field(default_factory=list, alias="results")
  328. remark: Optional[str] = Field(None, alias="remark")
  329. third_party_attachments: Optional[str] = Field(None, alias="thirdPartyAttachments")
  330. material_usages: Optional[List[Dict[str, Any]]] = Field(None, alias="materialUsages")
  331. @router.get("/qc-lab-test-items")
  332. async def list_qc_lab_test_items(
  333. page: int = Query(1, ge=1),
  334. pageSize: int = Query(10, ge=1, le=100),
  335. keyword: Optional[str] = None,
  336. status: Optional[str] = None,
  337. db: Session = Depends(get_db),
  338. user: dict = Depends(require_menu_code("biz:qcLabTestItem:list")),
  339. ):
  340. try:
  341. tenant_no = _get_tenant_no(db, user)
  342. items, total = lab_svc.list_lab_items(
  343. db, page=page, page_size=pageSize, keyword=keyword, status=status, tenant_no=tenant_no,
  344. user_info=user
  345. )
  346. return success_response(_page_payload(items, total, page, pageSize))
  347. except PermissionError as e:
  348. return error_response(403, str(e))
  349. except Exception as e:
  350. return error_response(400, str(e))
  351. @router.get("/qc-lab-test-items/active")
  352. async def list_qc_lab_test_items_active(
  353. db: Session = Depends(get_db),
  354. user: dict = Depends(require_menu_code("biz:qcWorkOrder:list")),
  355. ):
  356. try:
  357. tenant_no = _get_tenant_no(db, user)
  358. return success_response(lab_svc.list_active_lab_items(db, tenant_no, user_info=user))
  359. except PermissionError as e:
  360. return error_response(403, str(e))
  361. except Exception as e:
  362. return error_response(400, str(e))
  363. @router.post("/qc-lab-test-items")
  364. async def create_qc_lab_test_item(
  365. body: LabTestItemBody,
  366. db: Session = Depends(get_db),
  367. user: dict = Depends(require_menu_code("biz:qcLabTestItem:list")),
  368. ):
  369. try:
  370. tenant_no = _get_tenant_no(db, user)
  371. obj = lab_svc.create_lab_item(
  372. db,
  373. item_code=body.item_code,
  374. item_name=body.item_name,
  375. description=body.description,
  376. status=body.status,
  377. tenant_no=tenant_no,
  378. order_num=body.order_num,
  379. remark=body.remark,
  380. user_id=_get_current_user_id(user),
  381. )
  382. return success_response(lab_svc._row_to_dict(obj), message="创建成功")
  383. except PermissionError as e:
  384. return error_response(403, str(e))
  385. except ValueError as e:
  386. return error_response(400, str(e))
  387. except Exception as e:
  388. return error_response(400, str(e))
  389. @router.put("/qc-lab-test-items/{item_id}")
  390. async def update_qc_lab_test_item(
  391. item_id: str,
  392. body: LabTestItemUpdateBody,
  393. db: Session = Depends(get_db),
  394. user: dict = Depends(require_menu_code("biz:qcLabTestItem:list")),
  395. ):
  396. try:
  397. tenant_no = _get_tenant_no(db, user)
  398. obj = lab_svc.update_lab_item(
  399. db,
  400. item_id,
  401. item_code=body.item_code,
  402. item_name=body.item_name,
  403. description=body.description,
  404. status=body.status,
  405. order_num=body.order_num,
  406. remark=body.remark,
  407. user_id=_get_current_user_id(user),
  408. tenant_no=tenant_no,
  409. )
  410. return success_response(lab_svc._row_to_dict(obj), message="更新成功")
  411. except PermissionError as e:
  412. return error_response(403, str(e))
  413. except ValueError as e:
  414. return error_response(400, str(e))
  415. except Exception as e:
  416. return error_response(400, str(e))
  417. @router.delete("/qc-lab-test-items/{item_id}")
  418. async def delete_qc_lab_test_item(
  419. item_id: str,
  420. db: Session = Depends(get_db),
  421. user: dict = Depends(require_menu_code("biz:qcLabTestItem:list")),
  422. ):
  423. try:
  424. tenant_no = _get_tenant_no(db, user)
  425. lab_svc.soft_delete_lab_item(db, item_id, tenant_no=tenant_no)
  426. return success_response(None, message="删除成功")
  427. except PermissionError as e:
  428. return error_response(403, str(e))
  429. except ValueError as e:
  430. return error_response(400, str(e))
  431. except Exception as e:
  432. return error_response(400, str(e))
  433. # ---------- 检测项目参数模板 ----------
  434. @router.get("/qc-item-params")
  435. async def list_item_params(
  436. itemSource: str = Query(...),
  437. itemId: str = Query(...),
  438. db: Session = Depends(get_db),
  439. user: dict = Depends(require_menu_code("biz:qcLabTestItem:list")),
  440. ):
  441. try:
  442. tenant_no = _get_tenant_no(db, user)
  443. return success_response(param_svc.list_params_by_item(db, itemSource, itemId, tenant_no, user_info=user))
  444. except PermissionError as e:
  445. return error_response(403, str(e))
  446. except Exception as e:
  447. return error_response(400, str(e))
  448. @router.put("/qc-item-params")
  449. async def save_item_params(
  450. body: ItemParamBody,
  451. itemSource: str = Query(...),
  452. itemId: str = Query(...),
  453. db: Session = Depends(get_db),
  454. user: dict = Depends(require_menu_code("biz:qcLabTestItem:list")),
  455. ):
  456. try:
  457. tenant_no = _get_tenant_no(db, user)
  458. return success_response(
  459. param_svc.save_params_for_item(db, itemSource, itemId, body.params, tenant_no, _get_current_user_id(user)),
  460. message="保存成功",
  461. )
  462. except PermissionError as e:
  463. return error_response(403, str(e))
  464. except Exception as e:
  465. return error_response(400, str(e))
  466. # ---------- 质检工单 ----------
  467. class WorkOrderConfigureBody(BaseModel):
  468. model_config = ConfigDict(populate_by_name=True)
  469. has_lab: bool = Field(False, alias="hasLab")
  470. has_third_party: bool = Field(False, alias="hasThirdParty")
  471. lab_item_ids: List[str] = Field(default_factory=list, alias="labItemIds")
  472. third_party_item_ids: List[str] = Field(default_factory=list, alias="thirdPartyItemIds")
  473. @router.post("/qc-work-orders")
  474. async def create_qc_work_order(
  475. body: QcWorkOrderCreateBody,
  476. db: Session = Depends(get_db),
  477. user: dict = Depends(require_menu_code("biz:qcWorkOrder:list")),
  478. ):
  479. try:
  480. tenant_no = _get_tenant_no(db, user)
  481. wo_type = (body.work_order_type or "inbound").strip()
  482. if wo_type == "temporary":
  483. wo = wo_svc.create_temp_qc_work_order(
  484. db,
  485. tenant_no=tenant_no,
  486. user_id=user.get("user_id"),
  487. create_dept_id=user.get("dept_id", ""),
  488. cell_product_id=body.cell_product_id or "",
  489. remark=body.remark or "",
  490. )
  491. else:
  492. wo = wo_svc.create_qc_work_order_manual(
  493. db,
  494. tenant_no=tenant_no,
  495. user_id=user.get("user_id"),
  496. create_dept_id=user.get("dept_id", ""),
  497. protocol_no=body.protocol_no or "",
  498. sample_code=body.sample_code or "",
  499. reception_source=body.reception_source or "cell_storage",
  500. qc_biz_type=body.qc_biz_type or "inbound",
  501. remark=body.remark or "",
  502. )
  503. db.commit()
  504. return success_response(wo_svc._wo_to_dict(wo), message="创建成功")
  505. except PermissionError as e:
  506. return error_response(403, str(e))
  507. except Exception as e:
  508. db.rollback()
  509. return error_response(400, str(e))
  510. @router.get("/qc-work-orders")
  511. async def list_qc_work_orders(
  512. page: int = Query(1, ge=1),
  513. pageSize: int = Query(10, ge=1, le=100),
  514. keyword: Optional[str] = None,
  515. workOrderStatus: Optional[str] = None,
  516. workOrderType: Optional[str] = None,
  517. createTimeStart: Optional[str] = Query(None, alias="createTimeStart"),
  518. createTimeEnd: Optional[str] = Query(None, alias="createTimeEnd"),
  519. db: Session = Depends(get_db),
  520. user: dict = Depends(require_menu_code("biz:qcWorkOrder:list")),
  521. ):
  522. try:
  523. tenant_no = _get_tenant_no(db, user)
  524. items, total = wo_svc.list_work_orders(
  525. db,
  526. page=page,
  527. page_size=pageSize,
  528. keyword=keyword,
  529. work_order_status=workOrderStatus,
  530. work_order_type=workOrderType,
  531. create_time_start=createTimeStart,
  532. create_time_end=createTimeEnd,
  533. tenant_no=tenant_no,
  534. user_info=user,
  535. )
  536. return success_response(_page_payload(items, total, page, pageSize))
  537. except PermissionError as e:
  538. return error_response(403, str(e))
  539. except Exception as e:
  540. return error_response(400, str(e))
  541. @router.get("/qc-work-orders/{work_order_id}")
  542. async def get_qc_work_order_detail(
  543. work_order_id: str,
  544. db: Session = Depends(get_db),
  545. user: dict = Depends(require_menu_code("biz:qcWorkOrder:list")),
  546. ):
  547. try:
  548. tenant_no = _get_tenant_no(db, user)
  549. data = wo_svc.get_work_order_detail(db, work_order_id, tenant_no)
  550. return success_response(data)
  551. except PermissionError as e:
  552. return error_response(403, str(e))
  553. except ValueError as e:
  554. return error_response(400, str(e))
  555. except Exception as e:
  556. return error_response(400, str(e))
  557. @router.put("/qc-work-orders/{work_order_id}")
  558. async def update_qc_work_order(
  559. work_order_id: str,
  560. body: QcWorkOrderUpdateBody,
  561. db: Session = Depends(get_db),
  562. user: dict = Depends(require_menu_code("biz:qcWorkOrder:list")),
  563. ):
  564. try:
  565. tenant_no = _get_tenant_no(db, user)
  566. wo = wo_svc.update_qc_work_order(
  567. db,
  568. work_order_id,
  569. tenant_no=tenant_no,
  570. user_id=_get_current_user_id(user),
  571. cell_product_id=body.cell_product_id,
  572. remark=body.remark,
  573. )
  574. db.commit()
  575. return success_response(wo_svc._wo_to_dict(wo), message="保存成功")
  576. except PermissionError as e:
  577. return error_response(403, str(e))
  578. except ValueError as e:
  579. db.rollback()
  580. return error_response(400, str(e))
  581. except Exception as e:
  582. db.rollback()
  583. return error_response(400, str(e))
  584. @router.delete("/qc-work-orders/{work_order_id}")
  585. async def delete_qc_work_order_api(
  586. work_order_id: str,
  587. user: dict = Depends(require_admin_or_super_admin),
  588. db: Session = Depends(get_db),
  589. ):
  590. try:
  591. tenant_no = _get_tenant_no(db, user)
  592. wo_svc.delete_qc_work_order(db, work_order_id, tenant_no, user.get("user_id"))
  593. return success_response(None, message="删除成功")
  594. except ValueError as e:
  595. return error_response(400, str(e))
  596. @router.post("/qc-work-orders/{work_order_id}/configure")
  597. async def configure_qc_work_order(
  598. work_order_id: str,
  599. body: WorkOrderConfigureBody,
  600. db: Session = Depends(get_db),
  601. user: dict = Depends(require_menu_code("biz:qcWorkOrder:list")),
  602. ):
  603. try:
  604. tenant_no = _get_tenant_no(db, user)
  605. obj = wo_svc.configure_work_order(
  606. db,
  607. work_order_id,
  608. has_lab=body.has_lab,
  609. has_third_party=body.has_third_party,
  610. lab_item_ids=body.lab_item_ids,
  611. third_party_item_ids=body.third_party_item_ids,
  612. tenant_no=tenant_no,
  613. user_id=_get_current_user_id(user),
  614. )
  615. return success_response(wo_svc._wo_to_dict(obj), message="配置成功")
  616. except PermissionError as e:
  617. return error_response(403, str(e))
  618. except ValueError as e:
  619. return error_response(400, str(e))
  620. except Exception as e:
  621. return error_response(400, str(e))
  622. # ---------- 质检任务 ----------
  623. class TaskAttachmentsBody(BaseModel):
  624. model_config = ConfigDict(populate_by_name=True)
  625. third_party_attachments: str = Field("", alias="thirdPartyAttachments")
  626. @router.post("/qc-tasks")
  627. async def create_qc_task(
  628. body: QcTaskCreateBody,
  629. db: Session = Depends(get_db),
  630. user: dict = Depends(require_menu_code("biz:qcTask:list")),
  631. ):
  632. try:
  633. tenant_no = _get_tenant_no(db, user)
  634. task = task_svc.create_qc_task_manual(
  635. db,
  636. tenant_no=tenant_no,
  637. user_id=user.get("user_id"),
  638. create_dept_id=user.get("dept_id", ""),
  639. task_type=body.task_type,
  640. item_code=body.item_code,
  641. item_name=body.item_name,
  642. company_id=body.company_id,
  643. company_name=body.company_name,
  644. fee_amount=body.fee_amount,
  645. sample_code=body.sample_code or "",
  646. work_order_id=body.work_order_id or "",
  647. remark=body.remark or "",
  648. )
  649. db.commit()
  650. return success_response(task_svc._task_to_dict(task), message="创建成功")
  651. except PermissionError as e:
  652. return error_response(403, str(e))
  653. except Exception as e:
  654. db.rollback()
  655. return error_response(400, str(e))
  656. @router.get("/qc-tasks")
  657. async def list_qc_tasks(
  658. page: int = Query(1, ge=1),
  659. pageSize: int = Query(10, ge=1, le=100),
  660. keyword: Optional[str] = None,
  661. taskType: Optional[str] = None,
  662. taskStatus: Optional[str] = None,
  663. workOrderId: Optional[str] = None,
  664. qcBizType: Optional[str] = None,
  665. db: Session = Depends(get_db),
  666. user: dict = Depends(require_menu_code("biz:qcTask:list")),
  667. ):
  668. try:
  669. tenant_no = _get_tenant_no(db, user)
  670. items, total = task_svc.list_tasks(
  671. db,
  672. page=page,
  673. page_size=pageSize,
  674. keyword=keyword,
  675. task_type=taskType,
  676. task_status=taskStatus,
  677. work_order_id=workOrderId,
  678. qc_biz_type=qcBizType,
  679. tenant_no=tenant_no,
  680. user_info=user,
  681. )
  682. return success_response(_page_payload(items, total, page, pageSize))
  683. except PermissionError as e:
  684. return error_response(403, str(e))
  685. except Exception as e:
  686. return error_response(400, str(e))
  687. @router.get("/qc-tasks/{task_id}")
  688. async def get_qc_task_detail(
  689. task_id: str,
  690. db: Session = Depends(get_db),
  691. user: dict = Depends(require_menu_code("biz:qcTask:list")),
  692. ):
  693. try:
  694. tenant_no = _get_tenant_no(db, user)
  695. data = task_svc.get_task_detail(db, task_id, tenant_no)
  696. return success_response(data)
  697. except PermissionError as e:
  698. return error_response(403, str(e))
  699. except ValueError as e:
  700. return error_response(400, str(e))
  701. except Exception as e:
  702. return error_response(400, str(e))
  703. @router.post("/qc-tasks/{task_id}/start")
  704. async def start_qc_task(
  705. task_id: str,
  706. db: Session = Depends(get_db),
  707. user: dict = Depends(require_menu_code("biz:qcTask:list")),
  708. ):
  709. try:
  710. tenant_no = _get_tenant_no(db, user)
  711. obj = task_svc.start_task(db, task_id, tenant_no=tenant_no, user_id=_get_current_user_id(user))
  712. return success_response(task_svc._task_to_dict(obj), message="已开始")
  713. except PermissionError as e:
  714. return error_response(403, str(e))
  715. except ValueError as e:
  716. return error_response(400, str(e))
  717. except Exception as e:
  718. return error_response(400, str(e))
  719. @router.post("/qc-tasks/{task_id}/complete")
  720. async def complete_qc_task(
  721. task_id: str,
  722. db: Session = Depends(get_db),
  723. user: dict = Depends(require_menu_code("biz:qcTask:list")),
  724. ):
  725. try:
  726. tenant_no = _get_tenant_no(db, user)
  727. obj = task_svc.complete_task(
  728. db, task_id, tenant_no=tenant_no, user_id=_get_current_user_id(user)
  729. )
  730. return success_response(task_svc._task_to_dict(obj), message="已完成")
  731. except PermissionError as e:
  732. return error_response(403, str(e))
  733. except ValueError as e:
  734. return error_response(400, str(e))
  735. except Exception as e:
  736. return error_response(400, str(e))
  737. @router.get("/qc-tasks/{task_id}/results")
  738. async def get_task_results(
  739. task_id: str,
  740. db: Session = Depends(get_db),
  741. user: dict = Depends(require_menu_code("biz:qcTask:list")),
  742. ):
  743. try:
  744. tenant_no = _get_tenant_no(db, user)
  745. return success_response(result_svc.list_results_by_task(db, task_id, tenant_no, user_info=user))
  746. except PermissionError as e:
  747. return error_response(403, str(e))
  748. except Exception as e:
  749. return error_response(400, str(e))
  750. @router.get("/qc-tasks/{task_id}/material-usages")
  751. async def get_task_material_usages(
  752. task_id: str,
  753. db: Session = Depends(get_db),
  754. user: dict = Depends(require_menu_code("biz:qcTask:list")),
  755. ):
  756. try:
  757. tenant_no = _get_tenant_no(db, user)
  758. t = task_svc.get_task(db, task_id, tenant_no=tenant_no)
  759. if not t:
  760. return error_response(404, "任务不存在")
  761. return success_response(
  762. mu_svc.list_usages_by_task(db, task_id, tenant_no, user_info=user)
  763. )
  764. except PermissionError as e:
  765. return error_response(403, str(e))
  766. except Exception as e:
  767. return error_response(400, str(e))
  768. @router.post("/qc-tasks/{task_id}/complete-with-result")
  769. async def complete_task_with_result(
  770. task_id: str,
  771. body: TaskCompleteWithResultBody,
  772. db: Session = Depends(get_db),
  773. user: dict = Depends(require_menu_code("biz:qcTask:list")),
  774. ):
  775. try:
  776. tenant_no = _get_tenant_no(db, user)
  777. user_id = _get_current_user_id(user)
  778. t = task_svc.get_task(db, task_id, tenant_no=tenant_no)
  779. if not t:
  780. return error_response(404, "任务不存在")
  781. was_done = (t.task_status or "").strip() == "ywc"
  782. if body.results:
  783. result_svc.save_results_for_task(
  784. db, task_id, body.results, tenant_no, user_id, commit=False,
  785. )
  786. concl = (body.conclusion or "").strip()
  787. if concl not in ("tg", "btg"):
  788. return error_response(400, "请选择检测结论(通过/不通过)")
  789. if body.third_party_attachments is not None:
  790. task_svc.update_task_attachments(
  791. db, task_id, attachments=body.third_party_attachments,
  792. tenant_no=tenant_no, user_id=user_id, commit=False,
  793. )
  794. obj = task_svc.apply_task_result(
  795. db,
  796. task_id,
  797. tenant_no=tenant_no,
  798. user_id=user_id,
  799. conclusion=concl,
  800. remark=body.remark,
  801. material_usages=body.material_usages,
  802. commit=False,
  803. )
  804. db.commit()
  805. db.refresh(obj)
  806. if (obj.task_status or "").strip() == "ywc":
  807. wo_svc.try_complete_work_order(db, obj.work_order_id, tenant_no)
  808. return success_response(
  809. task_svc._task_to_dict(obj, work_order_no="", db=db, tenant_no=tenant_no),
  810. message="已保存" if was_done else "已完成",
  811. )
  812. except HTTPException as e:
  813. db.rollback()
  814. detail = e.detail
  815. msg = detail if isinstance(detail, str) else str(detail)
  816. return error_response(e.status_code, msg)
  817. except PermissionError as e:
  818. db.rollback()
  819. return error_response(403, str(e))
  820. except ValueError as e:
  821. db.rollback()
  822. return error_response(400, str(e))
  823. except Exception as e:
  824. db.rollback()
  825. return error_response(400, str(e))
  826. @router.put("/qc-tasks/{task_id}/attachments")
  827. async def update_qc_task_attachments(
  828. task_id: str,
  829. body: TaskAttachmentsBody,
  830. db: Session = Depends(get_db),
  831. user: dict = Depends(require_menu_code("biz:qcTask:list")),
  832. ):
  833. try:
  834. tenant_no = _get_tenant_no(db, user)
  835. obj = task_svc.update_task_attachments(
  836. db,
  837. task_id,
  838. attachments=body.third_party_attachments,
  839. tenant_no=tenant_no,
  840. user_id=_get_current_user_id(user),
  841. )
  842. return success_response(task_svc._task_to_dict(obj), message="已保存")
  843. except PermissionError as e:
  844. return error_response(403, str(e))
  845. except ValueError as e:
  846. return error_response(400, str(e))
  847. except Exception as e:
  848. return error_response(400, str(e))
  849. @router.delete("/qc-tasks/{task_id}")
  850. async def delete_qc_task_api(
  851. task_id: str,
  852. user: dict = Depends(require_admin_or_super_admin),
  853. db: Session = Depends(get_db),
  854. ):
  855. try:
  856. tenant_no = _get_tenant_no(db, user)
  857. task_svc.delete_qc_task(db, task_id, tenant_no, user.get("user_id"))
  858. return success_response(None, message="删除成功")
  859. except ValueError as e:
  860. return error_response(400, str(e))
  861. # ---------- 质检物料库 ----------
  862. class QcMaterialBody(BaseModel):
  863. model_config = ConfigDict(populate_by_name=True)
  864. material_code: str = Field(..., alias="materialCode")
  865. material_name: str = Field(..., alias="materialName")
  866. spec_model: Optional[str] = Field(None, alias="specModel")
  867. unit: Optional[str] = None
  868. warning_qty: Optional[float] = Field(0, alias="warningQty")
  869. status: str = "1"
  870. remark: Optional[str] = None
  871. class QcMaterialUpdateBody(BaseModel):
  872. model_config = ConfigDict(populate_by_name=True)
  873. material_code: Optional[str] = Field(None, alias="materialCode")
  874. material_name: Optional[str] = Field(None, alias="materialName")
  875. spec_model: Optional[str] = Field(None, alias="specModel")
  876. unit: Optional[str] = None
  877. warning_qty: Optional[float] = Field(None, alias="warningQty")
  878. status: Optional[str] = None
  879. remark: Optional[str] = None
  880. class StockInBody(BaseModel):
  881. model_config = ConfigDict(populate_by_name=True)
  882. qty: float = Field(..., gt=0)
  883. remark: Optional[str] = None
  884. stock_in_time: Optional[str] = Field(None, alias="stockInTime")
  885. class StockOutBody(BaseModel):
  886. model_config = ConfigDict(populate_by_name=True)
  887. qty: float = Field(..., gt=0)
  888. receiver: Optional[str] = None
  889. purpose: Optional[str] = None
  890. remark: Optional[str] = None
  891. stock_out_time: Optional[str] = Field(None, alias="stockOutTime")
  892. class BatchStockInItem(BaseModel):
  893. model_config = ConfigDict(populate_by_name=True)
  894. material_id: str = Field(..., alias="materialId")
  895. qty: float = Field(..., gt=0)
  896. remark: Optional[str] = None
  897. class BatchStockInBody(BaseModel):
  898. model_config = ConfigDict(populate_by_name=True)
  899. items: List[BatchStockInItem] = Field(..., min_length=1)
  900. remark: Optional[str] = None
  901. stock_in_time: Optional[str] = Field(None, alias="stockInTime")
  902. class BatchStockOutItem(BaseModel):
  903. model_config = ConfigDict(populate_by_name=True)
  904. material_id: str = Field(..., alias="materialId")
  905. qty: float = Field(..., gt=0)
  906. remark: Optional[str] = None
  907. class BatchStockOutBody(BaseModel):
  908. model_config = ConfigDict(populate_by_name=True)
  909. items: List[BatchStockOutItem] = Field(..., min_length=1)
  910. receiver: Optional[str] = None
  911. purpose: Optional[str] = None
  912. remark: Optional[str] = None
  913. stock_out_time: Optional[str] = Field(None, alias="stockOutTime")
  914. @router.get("/qc-materials")
  915. async def list_qc_materials(
  916. page: int = Query(1, ge=1),
  917. pageSize: int = Query(10, ge=1, le=100),
  918. keyword: Optional[str] = None,
  919. status: Optional[str] = None,
  920. db: Session = Depends(get_db),
  921. user: dict = Depends(require_menu_code("biz:qcMaterial:list")),
  922. ):
  923. try:
  924. tenant_no = _get_tenant_no(db, user)
  925. items, total = mat_svc.list_materials(
  926. db, page=page, page_size=pageSize, keyword=keyword, status=status, tenant_no=tenant_no,
  927. user_info=user,
  928. )
  929. return success_response(_page_payload(items, total, page, pageSize))
  930. except PermissionError as e:
  931. return error_response(403, str(e))
  932. except Exception as e:
  933. return error_response(400, str(e))
  934. @router.get("/qc-materials/options")
  935. async def qc_material_options(
  936. db: Session = Depends(get_db),
  937. user: dict = Depends(require_menu_code("biz:qcMaterial:list")),
  938. ):
  939. try:
  940. tenant_no = _get_tenant_no(db, user)
  941. return success_response(mat_svc.options_list(db, tenant_no=tenant_no))
  942. except Exception as e:
  943. return error_response(400, str(e))
  944. @router.post("/qc-materials")
  945. async def create_qc_material(
  946. body: QcMaterialBody,
  947. db: Session = Depends(get_db),
  948. user: dict = Depends(require_menu_code("biz:qcMaterial:list")),
  949. ):
  950. try:
  951. tenant_no = _get_tenant_no(db, user)
  952. user_id = _get_current_user_id(user)
  953. obj = mat_svc.create_material(
  954. db,
  955. material_code=body.material_code,
  956. material_name=body.material_name,
  957. spec_model=body.spec_model,
  958. unit=body.unit,
  959. warning_qty=Decimal(str(body.warning_qty))
  960. if body.warning_qty is not None
  961. else None,
  962. status=mat_svc._norm_status(body.status),
  963. remark=body.remark,
  964. tenant_no=tenant_no,
  965. user_id=user_id,
  966. )
  967. return success_response(mat_svc._row_to_dict(obj), message="创建成功")
  968. except ValueError as e:
  969. return error_response(400, str(e))
  970. except Exception as e:
  971. return error_response(400, str(e))
  972. @router.put("/qc-materials/{material_id}")
  973. async def update_qc_material(
  974. material_id: str,
  975. body: QcMaterialUpdateBody,
  976. db: Session = Depends(get_db),
  977. user: dict = Depends(require_menu_code("biz:qcMaterial:list")),
  978. ):
  979. try:
  980. tenant_no = _get_tenant_no(db, user)
  981. user_id = _get_current_user_id(user)
  982. data = body.model_dump(exclude_none=True)
  983. if "warning_qty" in data:
  984. data["warning_qty"] = Decimal(str(data["warning_qty"]))
  985. if "status" in data:
  986. data["status"] = mat_svc._norm_status(data["status"])
  987. obj = mat_svc.update_material(
  988. db,
  989. material_id,
  990. tenant_no=tenant_no,
  991. user_id=user_id,
  992. **data,
  993. )
  994. return success_response(mat_svc._row_to_dict(obj), message="更新成功")
  995. except ValueError as e:
  996. return error_response(400, str(e))
  997. except Exception as e:
  998. return error_response(400, str(e))
  999. @router.delete("/qc-materials/{material_id}")
  1000. async def delete_qc_material(
  1001. material_id: str,
  1002. db: Session = Depends(get_db),
  1003. user: dict = Depends(require_menu_code("biz:qcMaterial:list")),
  1004. ):
  1005. try:
  1006. tenant_no = _get_tenant_no(db, user)
  1007. user_id = _get_current_user_id(user)
  1008. mat_svc.soft_delete_material(db, material_id, tenant_no=tenant_no)
  1009. return success_response(None, message="删除成功")
  1010. except ValueError as e:
  1011. return error_response(400, str(e))
  1012. except Exception as e:
  1013. return error_response(400, str(e))
  1014. @router.post("/qc-materials/batch-stock-in")
  1015. async def batch_stock_in_qc_material(
  1016. body: BatchStockInBody,
  1017. db: Session = Depends(get_db),
  1018. user: dict = Depends(require_menu_code("biz:qcMaterial:list")),
  1019. ):
  1020. try:
  1021. tenant_no = _get_tenant_no(db, user)
  1022. user_id = _get_current_user_id(user)
  1023. operate_time = datetime.now()
  1024. if body.stock_in_time:
  1025. rt = parse_datetime(body.stock_in_time)
  1026. if not rt:
  1027. return error_response(400, "入库时间格式无效")
  1028. operate_time = rt
  1029. items = [
  1030. {"material_id": x.material_id, "qty": x.qty, "remark": x.remark}
  1031. for x in body.items
  1032. ]
  1033. count = mat_svc.batch_stock_in(
  1034. db,
  1035. items=items,
  1036. remark=body.remark,
  1037. tenant_no=tenant_no,
  1038. user_id=user_id,
  1039. operate_time=operate_time,
  1040. )
  1041. return success_response({"count": count}, message=f"批量入库成功,共 {count} 项")
  1042. except ValueError as e:
  1043. return error_response(400, str(e))
  1044. except Exception as e:
  1045. return error_response(400, str(e))
  1046. @router.post("/qc-materials/batch-stock-out")
  1047. async def batch_stock_out_qc_material(
  1048. body: BatchStockOutBody,
  1049. db: Session = Depends(get_db),
  1050. user: dict = Depends(require_menu_code("biz:qcMaterial:list")),
  1051. ):
  1052. try:
  1053. tenant_no = _get_tenant_no(db, user)
  1054. user_id = _get_current_user_id(user)
  1055. operate_time = datetime.now()
  1056. if body.stock_out_time:
  1057. rt = parse_datetime(body.stock_out_time)
  1058. if not rt:
  1059. return error_response(400, "出库时间格式无效")
  1060. operate_time = rt
  1061. items = [
  1062. {"material_id": x.material_id, "qty": x.qty, "remark": x.remark}
  1063. for x in body.items
  1064. ]
  1065. count = mat_svc.batch_stock_out(
  1066. db,
  1067. items=items,
  1068. receiver=body.receiver,
  1069. purpose=body.purpose,
  1070. remark=body.remark,
  1071. tenant_no=tenant_no,
  1072. user_id=user_id,
  1073. operate_time=operate_time,
  1074. )
  1075. return success_response({"count": count}, message=f"批量出库成功,共 {count} 项")
  1076. except ValueError as e:
  1077. return error_response(400, str(e))
  1078. except Exception as e:
  1079. return error_response(400, str(e))
  1080. @router.post("/qc-materials/{material_id}/stock-in")
  1081. async def stock_in_qc_material(
  1082. material_id: str,
  1083. body: StockInBody,
  1084. db: Session = Depends(get_db),
  1085. user: dict = Depends(require_menu_code("biz:qcMaterial:list")),
  1086. ):
  1087. try:
  1088. tenant_no = _get_tenant_no(db, user)
  1089. user_id = _get_current_user_id(user)
  1090. operate_time = datetime.now()
  1091. if body.stock_in_time:
  1092. rt = parse_datetime(body.stock_in_time)
  1093. if not rt:
  1094. return error_response(400, "入库时间格式无效")
  1095. operate_time = rt
  1096. from decimal import Decimal
  1097. obj = mat_svc.stock_in(
  1098. db,
  1099. material_id,
  1100. qty=Decimal(str(body.qty)),
  1101. remark=body.remark,
  1102. tenant_no=tenant_no,
  1103. user_id=user_id,
  1104. operate_time=operate_time,
  1105. )
  1106. return success_response(mat_svc._row_to_dict(obj), message="入库成功")
  1107. except ValueError as e:
  1108. return error_response(400, str(e))
  1109. except Exception as e:
  1110. return error_response(400, str(e))
  1111. @router.post("/qc-materials/{material_id}/stock-out")
  1112. async def stock_out_qc_material(
  1113. material_id: str,
  1114. body: StockOutBody,
  1115. db: Session = Depends(get_db),
  1116. user: dict = Depends(require_menu_code("biz:qcMaterial:list")),
  1117. ):
  1118. try:
  1119. tenant_no = _get_tenant_no(db, user)
  1120. user_id = _get_current_user_id(user)
  1121. operate_time = datetime.now()
  1122. if body.stock_out_time:
  1123. rt = parse_datetime(body.stock_out_time)
  1124. if not rt:
  1125. return error_response(400, "出库时间格式无效")
  1126. operate_time = rt
  1127. from decimal import Decimal
  1128. obj = mat_svc.stock_out(
  1129. db,
  1130. material_id,
  1131. qty=Decimal(str(body.qty)),
  1132. receiver=body.receiver,
  1133. purpose=body.purpose,
  1134. remark=body.remark,
  1135. tenant_no=tenant_no,
  1136. user_id=user_id,
  1137. operate_time=operate_time,
  1138. )
  1139. return success_response(mat_svc._row_to_dict(obj), message="出库成功")
  1140. except ValueError as e:
  1141. return error_response(400, str(e))
  1142. except Exception as e:
  1143. return error_response(400, str(e))
  1144. # ---------- 物料变动记录 ----------
  1145. @router.get("/qc-material-usages")
  1146. async def list_qc_material_usages(
  1147. page: int = Query(1, ge=1),
  1148. pageSize: int = Query(10, ge=1, le=100),
  1149. materialId: Optional[str] = None,
  1150. changeType: Optional[str] = None,
  1151. startTime: Optional[str] = None,
  1152. endTime: Optional[str] = None,
  1153. db: Session = Depends(get_db),
  1154. user: dict = Depends(require_menu_code("biz:qcMaterialUsage:list")),
  1155. ):
  1156. try:
  1157. tenant_no = _get_tenant_no(db, user)
  1158. items, total = mu_svc.list_usages(
  1159. db, tenant_no, page=page, page_size=pageSize,
  1160. material_id=materialId, change_type=changeType,
  1161. start_time=startTime, end_time=endTime,
  1162. user_info=user,
  1163. )
  1164. return success_response(_page_payload(items, total, page, pageSize))
  1165. except PermissionError as e:
  1166. return error_response(403, str(e))
  1167. except Exception as e:
  1168. return error_response(400, str(e))