cell_product.py 6.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162
  1. from datetime import datetime
  2. from typing import Any, List, Optional
  3. from pydantic import BaseModel, ConfigDict, Field, field_validator
  4. from app.core.utils import parse_datetime
  5. def _coerce_optional_datetime(value: Any) -> Optional[datetime]:
  6. """兼容前端 date-picker 的 YYYY-MM-DD 与完整日期时间字符串。"""
  7. if value is None or value == "":
  8. return None
  9. if isinstance(value, datetime):
  10. return value
  11. if isinstance(value, str):
  12. parsed = parse_datetime(value.strip())
  13. if parsed is not None:
  14. return parsed
  15. raise ValueError("无效的日期格式")
  16. return value
  17. class CellProductBatchItem(BaseModel):
  18. """批量入库时每一份产品的编码与储物格。"""
  19. model_config = ConfigDict(populate_by_name=True)
  20. product_code: str = Field(..., alias="productCode")
  21. storage_slot_id: Optional[str] = Field(None, alias="storageSlotId")
  22. passage: Optional[str] = None
  23. spec_name: Optional[str] = Field(None, alias="specName")
  24. expected_cell_count: Optional[float] = Field(None, alias="expectedCellCount")
  25. viability: Optional[float] = None
  26. @field_validator("passage")
  27. @classmethod
  28. def validate_item_passage(cls, v):
  29. if v is not None and v != "":
  30. valid = {f"P{i}" for i in range(1, 9)}
  31. if v.upper() not in valid:
  32. raise ValueError("代次必须为 P1~P8")
  33. return v.upper()
  34. return v
  35. @field_validator("viability")
  36. @classmethod
  37. def validate_item_viability(cls, v):
  38. if v is not None and (v < 0 or v > 100):
  39. raise ValueError("活性必须在 0~100 之间")
  40. return v
  41. class CellProductCreate(BaseModel):
  42. model_config = ConfigDict(populate_by_name=True)
  43. product_code: Optional[str] = Field(None, alias="productCode")
  44. product_name: str = Field(..., alias="productName")
  45. product_type_id: Optional[str] = Field(None, alias="productTypeId")
  46. spec_id: Optional[str] = Field(None, alias="specId")
  47. spec_name: Optional[str] = Field(None, alias="specName")
  48. batch_no: Optional[str] = Field(None, alias="batchNo")
  49. storage_slot_id: Optional[str] = Field(None, alias="storageSlotId")
  50. passage: Optional[str] = None
  51. freeze_date: Optional[datetime] = Field(None, alias="freezeDate")
  52. expected_cell_count: Optional[float] = Field(None, alias="expectedCellCount")
  53. viability: Optional[float] = None
  54. product_status: Optional[str] = Field("frozen", alias="productStatus")
  55. source_type: Optional[str] = Field("manual", alias="sourceType")
  56. quantity: Optional[float] = None
  57. unit: Optional[str] = None
  58. expiry_date: Optional[datetime] = Field(None, alias="expiryDate")
  59. product_images: Optional[str] = Field(None, alias="productImages")
  60. remark: Optional[str] = None
  61. items: Optional[List[CellProductBatchItem]] = Field(None, alias="items")
  62. @field_validator("freeze_date", "expiry_date", mode="before")
  63. @classmethod
  64. def coerce_date_fields(cls, v):
  65. return _coerce_optional_datetime(v)
  66. @field_validator("viability")
  67. @classmethod
  68. def validate_viability(cls, v):
  69. if v is not None and (v < 0 or v > 100):
  70. raise ValueError("活性必须在 0~100 之间")
  71. return v
  72. @field_validator("passage")
  73. @classmethod
  74. def validate_passage(cls, v):
  75. if v is not None:
  76. valid = {f"P{i}" for i in range(1, 9)}
  77. if v.upper() not in valid:
  78. raise ValueError("代次必须为 P1~P8")
  79. return v.upper()
  80. return v
  81. class CellProductUpdate(BaseModel):
  82. model_config = ConfigDict(populate_by_name=True)
  83. product_code: Optional[str] = Field(None, alias="productCode")
  84. product_name: Optional[str] = Field(None, alias="productName")
  85. product_type_id: Optional[str] = Field(None, alias="productTypeId")
  86. spec_id: Optional[str] = Field(None, alias="specId")
  87. spec_name: Optional[str] = Field(None, alias="specName")
  88. batch_no: Optional[str] = Field(None, alias="batchNo")
  89. storage_slot_id: Optional[str] = Field(None, alias="storageSlotId")
  90. passage: Optional[str] = None
  91. freeze_date: Optional[datetime] = Field(None, alias="freezeDate")
  92. expected_cell_count: Optional[float] = Field(None, alias="expectedCellCount")
  93. viability: Optional[float] = None
  94. product_status: Optional[str] = Field(None, alias="productStatus")
  95. quantity: Optional[float] = None
  96. unit: Optional[str] = None
  97. expiry_date: Optional[datetime] = Field(None, alias="expiryDate")
  98. product_images: Optional[str] = Field(None, alias="productImages")
  99. remark: Optional[str] = None
  100. @field_validator("freeze_date", "expiry_date", mode="before")
  101. @classmethod
  102. def coerce_date_fields(cls, v):
  103. return _coerce_optional_datetime(v)
  104. @field_validator("viability")
  105. @classmethod
  106. def validate_viability(cls, v):
  107. if v is not None and (v < 0 or v > 100):
  108. raise ValueError("活性必须在 0~100 之间")
  109. return v
  110. @field_validator("passage")
  111. @classmethod
  112. def validate_passage(cls, v):
  113. if v is not None:
  114. valid = {f"P{i}" for i in range(1, 9)}
  115. if v.upper() not in valid:
  116. raise ValueError("代次必须为 P1~P8")
  117. return v.upper()
  118. return v
  119. @field_validator("product_status")
  120. @classmethod
  121. def validate_status(cls, v):
  122. allowed = ("frozen", "sold", "used", "voided", "in_production", "thawed")
  123. if v is not None and v not in allowed:
  124. raise ValueError(f"状态必须为 {'/'.join(allowed)}")
  125. return v
  126. class CellProductListQuery(BaseModel):
  127. model_config = ConfigDict(populate_by_name=True)
  128. page: int = 1
  129. page_size: int = Field(20, alias="pageSize")
  130. keyword: Optional[str] = None
  131. product_code: Optional[str] = Field(None, alias="productCode")
  132. product_name: Optional[str] = Field(None, alias="productName")
  133. product_type_id: Optional[str] = Field(None, alias="productTypeId")
  134. product_status: Optional[str] = Field(None, alias="productStatus")
  135. passage: Optional[str] = None
  136. source_type: Optional[str] = Field(None, alias="sourceType")