inventory.py 8.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195
  1. """运输计划管理 - 库存统计 Schema"""
  2. from datetime import date, datetime
  3. from decimal import Decimal
  4. from typing import Optional
  5. from pydantic import BaseModel, Field
  6. # =============================================================================
  7. # 库存台账 Schema
  8. # =============================================================================
  9. class InventoryRead(BaseModel):
  10. id: str
  11. product_id: str = Field(alias="productId")
  12. brand_id: str = Field(default="", alias="brandId")
  13. brand_name: Optional[str] = Field(default=None, alias="brandName")
  14. product_no: str = Field(alias="productNo")
  15. product_name: str = Field(alias="productName")
  16. model: Optional[str] = None
  17. unit: str
  18. stock_qty: Decimal = Field(alias="stockQty")
  19. stock_amount: Decimal = Field(alias="stockAmount")
  20. low_stock_warning: Optional[Decimal] = Field(default=None, alias="lowStockWarning")
  21. high_stock_warning: Optional[Decimal] = Field(default=None, alias="highStockWarning")
  22. tenant_no: str = Field(alias="tenantNo")
  23. create_time: datetime = Field(alias="createTime")
  24. update_time: datetime = Field(alias="updateTime")
  25. model_config = {"from_attributes": True, "populate_by_name": True}
  26. # =============================================================================
  27. # 库存流水 Schema
  28. # =============================================================================
  29. class InventoryTransactionRead(BaseModel):
  30. id: str
  31. product_id: str = Field(alias="productId")
  32. brand_id: str = Field(default="", alias="brandId")
  33. brand_name: Optional[str] = Field(default=None, alias="brandName")
  34. product_name: str = Field(alias="productName")
  35. transaction_type: str = Field(alias="transactionType")
  36. plan_id: Optional[str] = Field(default=None, alias="planId")
  37. plan_no: Optional[str] = Field(default=None, alias="planNo")
  38. qty: Decimal
  39. unit_price: Decimal = Field(alias="unitPrice")
  40. amount: Decimal
  41. stock_after: Decimal = Field(alias="stockAfter")
  42. tenant_no: str = Field(alias="tenantNo")
  43. create_time: datetime = Field(alias="createTime")
  44. model_config = {"from_attributes": True, "populate_by_name": True}
  45. # =============================================================================
  46. # 库存预警 Schema
  47. # =============================================================================
  48. class InventoryWarningRead(BaseModel):
  49. id: str
  50. product_id: str = Field(alias="productId")
  51. brand_id: str = Field(default="", alias="brandId")
  52. brand_name: Optional[str] = Field(default=None, alias="brandName")
  53. product_name: str = Field(alias="productName")
  54. warning_type: str = Field(alias="warningType")
  55. current_qty: Decimal = Field(alias="currentQty")
  56. threshold_value: Decimal = Field(alias="thresholdValue")
  57. status: str
  58. resolve_time: Optional[datetime] = Field(default=None, alias="resolveTime")
  59. resolve_remark: Optional[str] = Field(default=None, alias="resolveRemark")
  60. tenant_no: str = Field(alias="tenantNo")
  61. create_time: datetime = Field(alias="createTime")
  62. model_config = {"from_attributes": True, "populate_by_name": True}
  63. class InventoryWarningUpdate(BaseModel):
  64. status: str = Field(..., description="状态 pending/resolved")
  65. resolve_remark: Optional[str] = Field(default=None, alias="resolveRemark", description="处理备注")
  66. model_config = {"populate_by_name": True}
  67. class InventoryWarningThreshold(BaseModel):
  68. product_id: str = Field(..., alias="productId", description="产品ID")
  69. brand_id: str = Field(default="", alias="brandId", description="品牌ID,无品牌为空串")
  70. brand_name: Optional[str] = Field(default=None, alias="brandName", description="品牌名称")
  71. low_stock_warning: Optional[Decimal] = Field(default=None, alias="lowStockWarning", description="最低库存预警值")
  72. high_stock_warning: Optional[Decimal] = Field(default=None, alias="highStockWarning", description="最高库存预警值")
  73. model_config = {"populate_by_name": True}
  74. # =============================================================================
  75. # 证件到期提醒 Schema
  76. # =============================================================================
  77. class DocumentReminderRead(BaseModel):
  78. id: str
  79. cert_id: Optional[str] = Field(default=None, alias="certId")
  80. owner_type: Optional[str] = Field(default=None, alias="ownerType")
  81. owner_id: Optional[str] = Field(default=None, alias="ownerId")
  82. owner_label: Optional[str] = Field(default=None, alias="ownerLabel")
  83. driver_id: Optional[str] = Field(default=None, alias="driverId")
  84. driver_name: Optional[str] = Field(default=None, alias="driverName")
  85. document_type: str = Field(alias="documentType")
  86. document_no: Optional[str] = Field(default=None, alias="documentNo")
  87. expire_date: date = Field(alias="expireDate")
  88. days_remaining: int = Field(alias="daysRemaining")
  89. status: str
  90. tenant_no: str = Field(alias="tenantNo")
  91. create_time: datetime = Field(alias="createTime")
  92. model_config = {"from_attributes": True, "populate_by_name": True}
  93. class DocumentReminderUpdate(BaseModel):
  94. status: str = Field(..., description="状态 pending/resolved")
  95. remark: Optional[str] = None
  96. model_config = {"populate_by_name": True}
  97. class DocumentReminderStatsRead(BaseModel):
  98. expired_pending_count: int = Field(alias="expiredPendingCount")
  99. model_config = {"populate_by_name": True}
  100. # =============================================================================
  101. # 查询参数
  102. # =============================================================================
  103. class InventoryLedgerQuery(BaseModel):
  104. product_name: Optional[str] = Field(default=None, alias="productName", description="产品名称")
  105. page: int = Field(default=1, ge=1)
  106. page_size: int = Field(default=20, ge=1, le=100, alias="pageSize")
  107. model_config = {"populate_by_name": True}
  108. class InventoryLedgerResponse(BaseModel):
  109. total: int
  110. list: list[InventoryRead]
  111. class InventoryTransactionQuery(BaseModel):
  112. product_id: Optional[str] = Field(default=None, alias="productId", description="产品ID")
  113. transaction_type: Optional[str] = Field(default=None, alias="transactionType", description="事务类型 inbound/outbound")
  114. date_from: Optional[date] = Field(default=None, alias="dateFrom", description="开始日期")
  115. date_to: Optional[date] = Field(default=None, alias="dateTo", description="结束日期")
  116. page: int = Field(default=1, ge=1)
  117. page_size: int = Field(default=20, ge=1, le=100, alias="pageSize")
  118. model_config = {"populate_by_name": True}
  119. class InventoryTransactionResponse(BaseModel):
  120. total: int
  121. list: list[InventoryTransactionRead]
  122. class InventorySummaryQuery(BaseModel):
  123. group_by: str = Field(default="month", alias="groupBy", description="汇总维度 month/week")
  124. date_from: date = Field(..., alias="dateFrom", description="开始日期")
  125. date_to: date = Field(..., alias="dateTo", description="结束日期")
  126. product_id: Optional[str] = Field(default=None, alias="productId", description="产品ID")
  127. model_config = {"populate_by_name": True}
  128. class InventorySummaryItem(BaseModel):
  129. period: str
  130. product_id: Optional[str] = Field(default=None, alias="productId")
  131. product_name: str = Field(alias="productName")
  132. inbound_qty: Decimal = Field(alias="inboundQty")
  133. outbound_qty: Decimal = Field(alias="outboundQty")
  134. net_change: Decimal = Field(alias="netChange")
  135. class InventorySummaryResponse(BaseModel):
  136. list: list[InventorySummaryItem]
  137. class TransportStatsQuery(BaseModel):
  138. group_by: str = Field(default="carrier", alias="groupBy", description="统计维度 carrier/vehicle")
  139. date_from: Optional[date] = Field(default=None, alias="dateFrom", description="开始日期")
  140. date_to: Optional[date] = Field(default=None, alias="dateTo", description="结束日期")
  141. model_config = {"populate_by_name": True}
  142. class TransportStatsItem(BaseModel):
  143. group_key: str = Field(alias="groupKey")
  144. group_name: str = Field(alias="groupName")
  145. trip_count: int = Field(alias="tripCount")
  146. total_freight: Decimal = Field(alias="totalFreight")
  147. class TransportStatsResponse(BaseModel):
  148. list: list[TransportStatsItem]