outbound_handover_inventory.py 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485
  1. """输注计划出库交接 — 细胞产品状态与市场物料库存联动。"""
  2. from __future__ import annotations
  3. from datetime import datetime
  4. from decimal import Decimal
  5. from typing import Any, Dict, Iterable, List, Optional, Set
  6. from fastapi import HTTPException
  7. from sqlalchemy.orm import Session
  8. from app.core.utils import generate_uuid
  9. from app.crud import storage_occupancy as occupancy_svc
  10. from app.crud.material import _is_enabled_status
  11. from app.crud.material_stock_batch import _get_material_for_update, _usage_batch_snapshots
  12. from app.models.material import BizMaterialStockBatch, BizMaterialUsage
  13. from app.models.models import BizCellProduct, BizStorageSlotOccupancy
  14. from app.models.qc_material import BizQcMaterial, BizQcMaterialUsage
  15. # 出库交接后细胞产品目标状态(已售卖/已出库)
  16. HANDOVER_CELL_OUT_STATUS = "sold"
  17. HANDOVER_MARKET_SOURCE_TYPE = "outbound_handover"
  18. # 历史数据:曾扣减质检物料库存
  19. HANDOVER_QC_SOURCE_TYPE = "outbound_handover"
  20. def _handover_usage_remark(schedule_id: str) -> str:
  21. return f"输注计划出库交接;scheduleId={schedule_id}"
  22. def _handover_usage_remark_prefix(schedule_id: str) -> str:
  23. return f"scheduleId={schedule_id}"
  24. def _remove_cell_occupancy_no_commit(
  25. db: Session,
  26. item_id: str,
  27. *,
  28. user_id: Optional[str] = None,
  29. ) -> None:
  30. """按细胞产品 ID 释放库位占用(不 commit)。"""
  31. obj = (
  32. db.query(BizStorageSlotOccupancy)
  33. .filter(
  34. BizStorageSlotOccupancy.item_type == "cell_product",
  35. BizStorageSlotOccupancy.item_id == item_id,
  36. BizStorageSlotOccupancy.occupancy_status == "stored",
  37. BizStorageSlotOccupancy.del_flag == 0,
  38. )
  39. .first()
  40. )
  41. if not obj:
  42. return
  43. now = datetime.now()
  44. obj.occupancy_status = "removed"
  45. obj.removed_at = now
  46. obj.update_by = user_id
  47. obj.update_time = now
  48. db.add(obj)
  49. db.flush()
  50. occupancy_svc._refresh_slot_cache(db, obj.slot_id)
  51. def _restore_cell_occupancy_no_commit(
  52. db: Session,
  53. product: BizCellProduct,
  54. *,
  55. tenant_no: str,
  56. user_id: Optional[str] = None,
  57. ) -> None:
  58. """出库交接回滚时恢复库位占用(不 commit)。"""
  59. slot_id = (product.storage_slot_id or "").strip()
  60. if not slot_id:
  61. return
  62. existing_stored = (
  63. db.query(BizStorageSlotOccupancy)
  64. .filter(
  65. BizStorageSlotOccupancy.item_type == "cell_product",
  66. BizStorageSlotOccupancy.item_id == product.id,
  67. BizStorageSlotOccupancy.occupancy_status == "stored",
  68. BizStorageSlotOccupancy.del_flag == 0,
  69. )
  70. .first()
  71. )
  72. if existing_stored:
  73. return
  74. now = datetime.now()
  75. latest_removed = (
  76. db.query(BizStorageSlotOccupancy)
  77. .filter(
  78. BizStorageSlotOccupancy.item_type == "cell_product",
  79. BizStorageSlotOccupancy.item_id == product.id,
  80. BizStorageSlotOccupancy.occupancy_status == "removed",
  81. BizStorageSlotOccupancy.del_flag == 0,
  82. )
  83. .order_by(BizStorageSlotOccupancy.removed_at.desc())
  84. .first()
  85. )
  86. if latest_removed:
  87. occupancy_svc.assert_slot_vacant(
  88. db, latest_removed.slot_id, tenant_no=tenant_no, exclude_product_id=product.id,
  89. )
  90. latest_removed.occupancy_status = "stored"
  91. latest_removed.removed_at = None
  92. latest_removed.update_by = user_id
  93. latest_removed.update_time = now
  94. db.add(latest_removed)
  95. db.flush()
  96. occupancy_svc._refresh_slot_cache(db, latest_removed.slot_id)
  97. return
  98. occupancy_svc.assert_slot_vacant(
  99. db, slot_id, tenant_no=tenant_no, exclude_product_id=product.id,
  100. )
  101. db.add(
  102. BizStorageSlotOccupancy(
  103. id=generate_uuid(),
  104. slot_id=slot_id,
  105. item_type="cell_product",
  106. item_id=product.id,
  107. item_code=(product.product_code or "").strip() or None,
  108. item_name=(product.product_name or "").strip() or None,
  109. item_source="outbound_handover_revert",
  110. stored_at=now,
  111. removed_at=None,
  112. occupancy_status="stored",
  113. tenant_no=tenant_no,
  114. order_num=0,
  115. remark="出库交接回滚恢复占用",
  116. create_by=user_id,
  117. create_dept_id=product.create_dept_id or "",
  118. create_time=now,
  119. update_by=user_id,
  120. update_time=now,
  121. del_flag=0,
  122. )
  123. )
  124. db.flush()
  125. occupancy_svc._refresh_slot_cache(db, slot_id)
  126. def _get_cell_product_locked(
  127. db: Session, cell_product_id: str, tenant_no: str
  128. ) -> BizCellProduct:
  129. product = (
  130. db.query(BizCellProduct)
  131. .with_for_update()
  132. .filter(
  133. BizCellProduct.id == cell_product_id,
  134. BizCellProduct.tenant_no == tenant_no,
  135. BizCellProduct.del_flag == 0,
  136. )
  137. .first()
  138. )
  139. if not product:
  140. raise HTTPException(
  141. status_code=400,
  142. detail=f"细胞产品不存在或已删除(ID: {cell_product_id})",
  143. )
  144. return product
  145. def _revert_legacy_qc_handover_usages(
  146. db: Session,
  147. *,
  148. schedule_id: str,
  149. tenant_no: str,
  150. user_id: Optional[str],
  151. remark_prefix: str,
  152. now: datetime,
  153. ) -> None:
  154. """回滚历史版本曾写入的质检物料出库交接记录。"""
  155. usage_rows = (
  156. db.query(BizQcMaterialUsage)
  157. .filter(
  158. BizQcMaterialUsage.tenant_no == tenant_no,
  159. BizQcMaterialUsage.del_flag == 0,
  160. BizQcMaterialUsage.source_type == HANDOVER_QC_SOURCE_TYPE,
  161. BizQcMaterialUsage.change_type == "use",
  162. BizQcMaterialUsage.remark.like(f"%{remark_prefix}%"),
  163. )
  164. .all()
  165. )
  166. for usage in usage_rows:
  167. restore_qty = abs(usage.change_qty) if usage.change_qty is not None else Decimal("0")
  168. if restore_qty > 0:
  169. material = (
  170. db.query(BizQcMaterial)
  171. .with_for_update()
  172. .filter(
  173. BizQcMaterial.id == usage.material_id,
  174. BizQcMaterial.tenant_no == tenant_no,
  175. BizQcMaterial.del_flag == 0,
  176. )
  177. .first()
  178. )
  179. if material:
  180. material.stock_qty = (material.stock_qty or Decimal("0")) + restore_qty
  181. material.update_by = user_id
  182. material.update_time = now
  183. db.add(material)
  184. usage.del_flag = 1
  185. usage.update_by = user_id
  186. usage.update_time = now
  187. db.add(usage)
  188. def _revert_market_handover_usages(
  189. db: Session,
  190. *,
  191. schedule_id: str,
  192. tenant_no: str,
  193. user_id: Optional[str],
  194. remark_prefix: str,
  195. now: datetime,
  196. ) -> None:
  197. """回滚市场物料出库交接记录(含批次剩余量)。"""
  198. usage_rows = (
  199. db.query(BizMaterialUsage)
  200. .filter(
  201. BizMaterialUsage.tenant_no == tenant_no,
  202. BizMaterialUsage.del_flag == 0,
  203. BizMaterialUsage.source_type == HANDOVER_MARKET_SOURCE_TYPE,
  204. BizMaterialUsage.change_type == "use",
  205. BizMaterialUsage.remark.like(f"%{remark_prefix}%"),
  206. )
  207. .all()
  208. )
  209. for usage in usage_rows:
  210. restore_qty = abs(usage.change_qty) if usage.change_qty is not None else Decimal("0")
  211. if restore_qty > 0:
  212. material = _get_material_for_update(db, usage.material_id, tenant_no)
  213. material.stock_qty = (material.stock_qty or Decimal("0")) + restore_qty
  214. material.update_by = user_id
  215. material.update_time = now
  216. db.add(material)
  217. batch_id = (usage.batch_id or "").strip()
  218. if batch_id:
  219. batch = (
  220. db.query(BizMaterialStockBatch)
  221. .with_for_update()
  222. .filter(
  223. BizMaterialStockBatch.id == batch_id,
  224. BizMaterialStockBatch.tenant_no == tenant_no,
  225. BizMaterialStockBatch.del_flag == 0,
  226. )
  227. .first()
  228. )
  229. if batch:
  230. batch.remaining_qty = (batch.remaining_qty or Decimal("0")) + restore_qty
  231. batch.update_by = user_id
  232. batch.update_time = now
  233. db.add(batch)
  234. usage.del_flag = 1
  235. usage.update_by = user_id
  236. usage.update_time = now
  237. db.add(usage)
  238. def revert_handover_inventory(
  239. db: Session,
  240. schedule_id: str,
  241. *,
  242. cell_product_ids: Iterable[str],
  243. tenant_no: str,
  244. user_id: Optional[str] = None,
  245. ) -> None:
  246. """回滚本输注计划上次出库交接产生的库存/状态变更(不 commit)。"""
  247. sid = (schedule_id or "").strip()
  248. if not sid:
  249. return
  250. remark_prefix = _handover_usage_remark_prefix(sid)
  251. now = datetime.now()
  252. _revert_legacy_qc_handover_usages(
  253. db,
  254. schedule_id=sid,
  255. tenant_no=tenant_no,
  256. user_id=user_id,
  257. remark_prefix=remark_prefix,
  258. now=now,
  259. )
  260. _revert_market_handover_usages(
  261. db,
  262. schedule_id=sid,
  263. tenant_no=tenant_no,
  264. user_id=user_id,
  265. remark_prefix=remark_prefix,
  266. now=now,
  267. )
  268. seen: Set[str] = set()
  269. for raw_id in cell_product_ids:
  270. cp_id = (raw_id or "").strip()
  271. if not cp_id or cp_id in seen:
  272. continue
  273. seen.add(cp_id)
  274. product = _get_cell_product_locked(db, cp_id, tenant_no)
  275. current = (product.product_status or "frozen").strip()
  276. if current != HANDOVER_CELL_OUT_STATUS:
  277. continue
  278. product.product_status = "frozen"
  279. product.update_by = user_id
  280. product.update_time = now
  281. db.add(product)
  282. _restore_cell_occupancy_no_commit(
  283. db, product, tenant_no=tenant_no, user_id=user_id
  284. )
  285. db.flush()
  286. def _deduct_market_material_for_handover(
  287. db: Session,
  288. material_id: str,
  289. qty: Decimal,
  290. *,
  291. schedule_id: str,
  292. tenant_no: str,
  293. user_id: Optional[str],
  294. create_dept_id: str,
  295. receiver_person: str,
  296. line_remark: str,
  297. now: datetime,
  298. ) -> None:
  299. """按 FIFO 从市场物料入库批次扣减,并写入变动记录。"""
  300. material = _get_material_for_update(db, material_id, tenant_no)
  301. if not _is_enabled_status(material.status):
  302. raise HTTPException(
  303. status_code=400,
  304. detail=f"市场物料「{material.material_name}」已停用,无法出库",
  305. )
  306. stock_before = material.stock_qty if material.stock_qty is not None else Decimal("0")
  307. if stock_before < qty:
  308. raise HTTPException(
  309. status_code=400,
  310. detail=(
  311. f"物料「{material.material_name}」库存不足,"
  312. f"当前库存 {stock_before},需出库 {qty}"
  313. ),
  314. )
  315. batches = (
  316. db.query(BizMaterialStockBatch)
  317. .with_for_update()
  318. .filter(
  319. BizMaterialStockBatch.material_id == material_id,
  320. BizMaterialStockBatch.tenant_no == tenant_no,
  321. BizMaterialStockBatch.del_flag == 0,
  322. BizMaterialStockBatch.remaining_qty > 0,
  323. )
  324. .order_by(
  325. BizMaterialStockBatch.stock_in_date.asc(),
  326. BizMaterialStockBatch.create_time.asc(),
  327. )
  328. .all()
  329. )
  330. usage_remark = _handover_usage_remark(schedule_id)
  331. receiver = (receiver_person or "").strip() or None
  332. remaining = qty
  333. running_stock = stock_before
  334. for batch in batches:
  335. if remaining <= 0:
  336. break
  337. rem = batch.remaining_qty if batch.remaining_qty is not None else Decimal("0")
  338. if rem <= 0:
  339. continue
  340. take = min(rem, remaining)
  341. batch.remaining_qty = rem - take
  342. batch.update_by = user_id
  343. batch.update_time = now
  344. db.add(batch)
  345. stock_after = running_stock - take
  346. snaps = _usage_batch_snapshots(batch, out_qty=take)
  347. db.add(
  348. BizMaterialUsage(
  349. id=generate_uuid(),
  350. material_id=material.id,
  351. material_code=material.material_code,
  352. material_name=material.material_name,
  353. change_type="use",
  354. change_qty=-take,
  355. usage_unit=(material.unit or "").strip() or None,
  356. stock_before=running_stock,
  357. stock_after=stock_after,
  358. source_type=HANDOVER_MARKET_SOURCE_TYPE,
  359. requisition_status="closed",
  360. tenant_no=tenant_no,
  361. receiver=receiver,
  362. purpose="输注计划出库交接",
  363. remark=usage_remark if not line_remark else f"{usage_remark};{line_remark}",
  364. create_by=user_id,
  365. create_dept_id=create_dept_id or "",
  366. create_time=now,
  367. update_by=user_id,
  368. update_time=now,
  369. del_flag=0,
  370. **snaps,
  371. )
  372. )
  373. running_stock = stock_after
  374. remaining -= take
  375. if remaining > 0:
  376. raise HTTPException(
  377. status_code=400,
  378. detail=(
  379. f"物料「{material.material_name}」批次库存不足,"
  380. f"汇总库存 {stock_before},需出库 {qty},批次可分配 {qty - remaining}"
  381. ),
  382. )
  383. material.stock_qty = stock_before - qty
  384. material.update_by = user_id
  385. material.update_time = now
  386. db.add(material)
  387. def apply_handover_inventory(
  388. db: Session,
  389. schedule_id: str,
  390. *,
  391. cells: List[Dict[str, Any]],
  392. qc_materials: List[Dict[str, Any]],
  393. tenant_no: str,
  394. user_id: Optional[str] = None,
  395. create_dept_id: str = "",
  396. receiver_person: str = "",
  397. ) -> None:
  398. """应用出库交接:细胞产品出库 + 市场物料扣减(不 commit)。"""
  399. sid = (schedule_id or "").strip()
  400. now = datetime.now()
  401. for item in cells or []:
  402. cp_id = (item.get("cellProductId") or item.get("cell_product_id") or "").strip()
  403. if not cp_id:
  404. continue
  405. product = _get_cell_product_locked(db, cp_id, tenant_no)
  406. current = (product.product_status or "frozen").strip()
  407. if current != "frozen":
  408. label = product.product_code or product.product_name or cp_id
  409. raise HTTPException(
  410. status_code=400,
  411. detail=(
  412. f"细胞产品「{label}」当前状态不可出库交接"
  413. f"(仅「已冻存」可出库,当前为 {current or '未知'})"
  414. ),
  415. )
  416. product.product_status = HANDOVER_CELL_OUT_STATUS
  417. product.update_by = user_id
  418. product.update_time = now
  419. db.add(product)
  420. _remove_cell_occupancy_no_commit(db, cp_id, user_id=user_id)
  421. for item in qc_materials or []:
  422. mid = (item.get("materialId") or item.get("material_id") or "").strip()
  423. qty_raw = item.get("qty")
  424. if not mid:
  425. raise HTTPException(status_code=400, detail="市场物料ID不能为空")
  426. try:
  427. qty_dec = Decimal(str(qty_raw))
  428. except Exception:
  429. raise HTTPException(status_code=400, detail="物料用量格式无效")
  430. if qty_dec <= 0:
  431. raise HTTPException(status_code=400, detail="物料用量必须大于0")
  432. line_remark = (item.get("remark") or "").strip()
  433. _deduct_market_material_for_handover(
  434. db,
  435. mid,
  436. qty_dec,
  437. schedule_id=sid,
  438. tenant_no=tenant_no,
  439. user_id=user_id,
  440. create_dept_id=create_dept_id,
  441. receiver_person=receiver_person,
  442. line_remark=line_remark,
  443. now=now,
  444. )
  445. db.flush()