| 123456789101112131415161718192021222324252627282930313233343536 |
- from __future__ import annotations
- from sqlmodel import Field, SQLModel
- class WeighingSlip(SQLModel, table=True):
- """地磅单表 - 对应 weighing_slips"""
- __tablename__ = "weighing_slips"
- id: int | None = Field(default=None, primary_key=True)
- vehicle_no: str = Field(max_length=255, index=True) # 车号
- plan_no: str | None = Field(default=None, max_length=255, index=True) # 计划单号
- cargo_name: str = Field(max_length=255, index=True) # 货物名称
- business_type: str = Field(max_length=255) # 业务类型（入库/出库）
- batch_no: str | None = Field(default=None, max_length=255) # 批次号
- supplier: str = Field(max_length=255) # 供货单位
- consignee: str = Field(max_length=255) # 收货单位
- gross_weight: float = Field() # 毛重（kg）
- gross_weight_time: str = Field(max_length=255, index=True) # 毛重时间
- tare_weight: float = Field() # 皮重（kg）
- tare_weight_time: str = Field(max_length=255) # 皮重时间
- deduction: float | None = Field(default=0) # 扣杂（kg）
- net_weight: float = Field() # 净重（kg）
- planned_quantity: float | None = Field(default=None) # 计划数量（kg）
- executed_quantity: float | None = Field(default=None) # 执行数量（kg）
- purchase_plan_id: int | None = Field(default=None, index=True) # 关联的计划ID
- inbound_outbound_id: int | None = Field(default=None, index=True) # 关联的出入库单ID
- weighing_point: str | None = Field(default="山峡地磅", max_length=255) # 称重点
- remarks: str | None = Field(default=None) # 备注
- current_quantity: float | None = Field(default=None) # 本次量（kg）
- is_voided: int = Field(default=0, index=True) # 是否作废(0=否, 1=是)
- created_at: str = Field(max_length=255) # 创建时间
- # 保留别名以兼容
- Weighing = WeighingSlip
|
