pl_models.py 57 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935
  1. """运输计划管理模块数据模型"""
  2. from datetime import datetime
  3. from decimal import Decimal
  4. from sqlalchemy import (
  5. BigInteger,
  6. Column,
  7. DECIMAL,
  8. Date,
  9. DateTime,
  10. Integer,
  11. SmallInteger,
  12. String,
  13. Text,
  14. CHAR,
  15. ForeignKey,
  16. )
  17. from sqlalchemy.orm import relationship
  18. from app.core.database import Base
  19. # =============================================================================
  20. # 1. 基础数据:承运商、车辆、司机
  21. # =============================================================================
  22. class PlCarrier(Base):
  23. """承运商表 pl_carrier"""
  24. __tablename__ = "pl_carrier"
  25. id = Column(String(64), primary_key=True, comment="主键ID")
  26. carrier_name = Column(String(200), nullable=False, comment="承运商名称")
  27. contact_name = Column(String(100), nullable=True, comment="联系人")
  28. contact_phone = Column(String(32), nullable=True, comment="联系电话")
  29. status = Column(CHAR(1), nullable=False, default="1", comment="合作状态 1-合作中 0-已终止")
  30. business_license_urls = Column(String(2000), nullable=True, comment="营业执照附件URL,逗号分隔")
  31. road_transport_license_urls = Column(String(2000), nullable=True, comment="道路经营许可证附件URL,逗号分隔")
  32. transport_agreement_urls = Column(String(2000), nullable=True, comment="运输协议附件URL,逗号分隔")
  33. transport_agreement_expire_date = Column(Date, nullable=True, comment="运输协议有效期")
  34. audit_status = Column(String(20), nullable=False, default="pending", comment="审核状态 pending-待审核 approved-已通过 rejected-已驳回")
  35. audit_by = Column(String(64), nullable=True, comment="审核人id")
  36. audit_time = Column(DateTime, nullable=True, comment="审核时间")
  37. audit_remark = Column(String(512), nullable=True, comment="审核备注(驳回原因等)")
  38. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  39. order_num = Column(Integer, nullable=True, comment="排序号")
  40. remark = Column(String(512), nullable=True, comment="备注")
  41. create_by = Column(String(64), nullable=True, comment="创建人id")
  42. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  43. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  44. update_by = Column(String(64), nullable=True, comment="更新人id")
  45. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  46. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  47. class PlVehicle(Base):
  48. """车辆表 pl_vehicle"""
  49. __tablename__ = "pl_vehicle"
  50. id = Column(String(64), primary_key=True, comment="主键ID")
  51. vehicle_type = Column(String(20), nullable=False, comment="车辆类型 self-自有 carrier-承运商")
  52. carrier_id = Column(String(64), nullable=True, comment="承运商ID(类型为承运商时必填)")
  53. carrier_name = Column(String(200), nullable=True, comment="承运商名称(冗余)")
  54. license_plate = Column(String(20), nullable=False, unique=True, comment="车牌号")
  55. trailer_no = Column(String(20), nullable=True, comment="挂车号")
  56. default_driver_id = Column(String(64), nullable=True, comment="默认司机ID")
  57. default_driver_name = Column(String(100), nullable=True, comment="默认司机姓名(冗余)")
  58. load_capacity = Column(DECIMAL(10, 2), nullable=True, comment="载重(吨)")
  59. vehicle_status = Column(String(20), nullable=False, default="available", comment="车辆状态 available-可用 maintaining-维修中 scrapped-报废")
  60. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  61. order_num = Column(Integer, nullable=True, comment="排序号")
  62. remark = Column(String(512), nullable=True, comment="备注")
  63. create_by = Column(String(64), nullable=True, comment="创建人id")
  64. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  65. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  66. update_by = Column(String(64), nullable=True, comment="更新人id")
  67. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  68. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  69. class PlPersonnel(Base):
  70. """人员表 pl_personnel"""
  71. __tablename__ = "pl_personnel"
  72. id = Column(String(64), primary_key=True, comment="主键ID")
  73. personnel_name = Column(String(100), nullable=False, comment="姓名")
  74. phone_no = Column(String(32), nullable=True, comment="手机号(非必填)")
  75. age = Column(Integer, nullable=True, comment="年龄")
  76. id_card_no = Column(String(32), nullable=True, comment="身份证号")
  77. status = Column(CHAR(1), nullable=False, default="1", comment="状态 1-在职 0-停用")
  78. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  79. order_num = Column(Integer, nullable=True, comment="排序号")
  80. remark = Column(String(512), nullable=True, comment="备注")
  81. create_by = Column(String(64), nullable=True, comment="创建人id")
  82. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  83. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  84. update_by = Column(String(64), nullable=True, comment="更新人id")
  85. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  86. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  87. class PlTransportAddress(Base):
  88. """运输通用地址库 pl_transport_address"""
  89. __tablename__ = "pl_transport_address"
  90. id = Column(String(64), primary_key=True, comment="主键ID")
  91. address_name = Column(String(200), nullable=False, comment="地址名称")
  92. full_address = Column(String(500), nullable=False, comment="详细地址")
  93. lng = Column(DECIMAL(10, 6), nullable=False, comment="经度")
  94. lat = Column(DECIMAL(10, 6), nullable=False, comment="纬度")
  95. contact_name = Column(String(100), nullable=True, comment="联系人")
  96. contact_phone = Column(String(32), nullable=True, comment="联系电话")
  97. status = Column(CHAR(1), nullable=False, default="1", comment="状态 1-启用 0-停用")
  98. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  99. order_num = Column(Integer, nullable=True, comment="排序号")
  100. remark = Column(String(512), nullable=True, comment="备注")
  101. create_by = Column(String(64), nullable=True, comment="创建人id")
  102. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  103. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  104. update_by = Column(String(64), nullable=True, comment="更新人id")
  105. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  106. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  107. class PlCert(Base):
  108. """证书表 pl_cert"""
  109. __tablename__ = "pl_cert"
  110. id = Column(String(64), primary_key=True, comment="主键ID")
  111. owner_type = Column(String(20), nullable=False, comment="归属类型 vehicle-车辆 personnel-人员")
  112. owner_id = Column(String(64), nullable=False, comment="归属主体ID")
  113. vehicle_part = Column(String(20), nullable=True, comment="车辆部位 head-主车 trailer-挂车,人员证书为空")
  114. cert_name = Column(String(100), nullable=False, comment="证书名称")
  115. cert_no = Column(String(64), nullable=True, comment="证号")
  116. expire_date = Column(Date, nullable=True, comment="有效期")
  117. remind_days = Column(Integer, nullable=False, default=30, comment="提前提醒天数")
  118. attachment_urls = Column(String(2000), nullable=True, comment="附件URL(逗号分隔)")
  119. status = Column(String(20), nullable=False, default="valid", comment="状态 valid-有效 expired-已过期 revoked-已作废")
  120. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  121. order_num = Column(Integer, nullable=True, comment="排序号")
  122. remark = Column(String(512), nullable=True, comment="备注")
  123. create_by = Column(String(64), nullable=True, comment="创建人id")
  124. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  125. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  126. update_by = Column(String(64), nullable=True, comment="更新人id")
  127. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  128. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  129. class PlDriver(Base):
  130. """司机表 pl_driver(兼容旧表,迁移后逐步废弃)"""
  131. __tablename__ = "pl_driver"
  132. id = Column(String(64), primary_key=True, comment="主键ID")
  133. driver_name = Column(String(100), nullable=False, comment="姓名")
  134. phone_no = Column(String(32), nullable=False, comment="手机号")
  135. id_card_no = Column(String(32), nullable=True, comment="身份证号")
  136. driving_license_no = Column(String(32), nullable=True, comment="驾驶证号")
  137. driving_license_expire = Column(Date, nullable=True, comment="驾驶证有效期")
  138. vehicle_license_no = Column(String(32), nullable=True, comment="行驶证号")
  139. vehicle_license_expire = Column(Date, nullable=True, comment="行驶证有效期")
  140. hazmat_cert_no = Column(String(32), nullable=True, comment="危化品证号")
  141. hazmat_cert_expire = Column(Date, nullable=True, comment="危化品证有效期")
  142. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  143. order_num = Column(Integer, nullable=True, comment="排序号")
  144. remark = Column(String(512), nullable=True, comment="备注")
  145. create_by = Column(String(64), nullable=True, comment="创建人id")
  146. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  147. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  148. update_by = Column(String(64), nullable=True, comment="更新人id")
  149. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  150. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  151. class PlVehiclePersonnel(Base):
  152. """车辆-人员关联表 pl_vehicle_personnel"""
  153. __tablename__ = "pl_vehicle_personnel"
  154. id = Column(String(64), primary_key=True, comment="主键ID")
  155. vehicle_id = Column(String(64), nullable=False, comment="车辆ID")
  156. personnel_id = Column(String(64), nullable=False, comment="人员ID")
  157. role = Column(String(20), nullable=False, default="driver", comment="角色 driver-司机 escort-押运员")
  158. is_default = Column(SmallInteger, nullable=False, default=0, comment="是否默认司机 0-否 1-是")
  159. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  160. order_num = Column(Integer, nullable=True, comment="排序号")
  161. remark = Column(String(512), nullable=True, comment="关联备注")
  162. create_by = Column(String(64), nullable=True, comment="创建人id")
  163. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  164. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  165. update_by = Column(String(64), nullable=True, comment="更新人id")
  166. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  167. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  168. class PlVehicleDriver(Base):
  169. """车辆-司机关联表 pl_vehicle_driver(兼容旧表)"""
  170. __tablename__ = "pl_vehicle_driver"
  171. id = Column(String(64), primary_key=True, comment="主键ID")
  172. vehicle_id = Column(String(64), nullable=False, comment="车辆ID")
  173. driver_id = Column(String(64), nullable=False, comment="司机ID")
  174. is_default = Column(SmallInteger, nullable=False, default=0, comment="是否默认 0-否 1-是")
  175. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  176. order_num = Column(Integer, nullable=True, comment="排序号")
  177. remark = Column(String(512), nullable=True, comment="备注")
  178. create_by = Column(String(64), nullable=True, comment="创建人id")
  179. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  180. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  181. update_by = Column(String(64), nullable=True, comment="更新人id")
  182. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  183. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  184. # =============================================================================
  185. # 2. 计划管理:计划主表、产品明细、变更记录
  186. # =============================================================================
  187. class PlPlan(Base):
  188. """计划主表 pl_plan"""
  189. __tablename__ = "pl_plan"
  190. id = Column(String(64), primary_key=True, comment="主键ID")
  191. # 编号信息
  192. plan_no = Column(String(32), nullable=False, unique=True, comment="计划订单编号 SXDDHYYYYMMDD###")
  193. plan_date = Column(Date, nullable=False, comment="计划日期")
  194. # 基本信息
  195. belongs_company = Column(String(20), nullable=False, comment="归属公司 shanxia-安庆山峡 yundong-安徽云栋")
  196. plan_type = Column(String(20), nullable=False, comment="单据类型 direct-直销单 inbound-入库单 outbound-出库单")
  197. follow_status = Column(String(30), nullable=False, default="draft", comment="跟进状态")
  198. transport_status = Column(String(20), nullable=False, default="pending", comment="运输安排状态 pending-待安排 arranged-已安排")
  199. archive_status = Column(String(20), nullable=False, default="unarchived", comment="归档状态 unarchived-未归档 archived-已归档")
  200. complete_status = Column(String(10), nullable=False, default="no", comment="完成状态 yes-是 no-否")
  201. # 合同关联
  202. contract_id = Column(String(64), nullable=True, comment="CRM合同ID")
  203. contract_no = Column(String(50), nullable=True, comment="合同编号")
  204. # 供应商与目的地
  205. supplier_id = Column(String(64), nullable=True, comment="供应商ID")
  206. supplier_name = Column(String(200), nullable=True, comment="供应商名称")
  207. destination_id = Column(String(64), nullable=True, comment="目的地ID")
  208. destination_name = Column(String(200), nullable=True, comment="目的地名称")
  209. # 客户信息(冗余自合同)
  210. customer_id = Column(String(64), nullable=True, comment="客户ID")
  211. customer_name = Column(String(200), nullable=True, comment="客户名称")
  212. contact_name = Column(String(100), nullable=True, comment="联系人")
  213. contact_phone = Column(String(32), nullable=True, comment="联系电话")
  214. party_a = Column(String(200), nullable=True, comment="甲方")
  215. party_b = Column(String(200), nullable=True, comment="乙方")
  216. # 合同有效期
  217. contract_start_date = Column(Date, nullable=True, comment="合同开始日期")
  218. contract_end_date = Column(Date, nullable=True, comment="合同结束日期")
  219. # 送货与结算
  220. delivery_method = Column(String(20), nullable=True, comment="送货方式 self_pick-山峡自提 one_ticket-一票制 customer_pick-客户自提")
  221. settlement_method = Column(String(50), nullable=True, comment="结算方式")
  222. # 运输信息
  223. has_freight = Column(SmallInteger, nullable=False, default=0, comment="是否有运输费用 0-否 1-是")
  224. pickup_address = Column(String(500), nullable=True, comment="取货地址")
  225. pickup_lng = Column(DECIMAL(10, 6), nullable=True, comment="取货经度")
  226. pickup_lat = Column(DECIMAL(10, 6), nullable=True, comment="取货纬度")
  227. pickup_time = Column(DateTime, nullable=True, comment="取货时间")
  228. pickup_notes = Column(String(500), nullable=True, comment="取货注意事项")
  229. destination_address = Column(String(500), nullable=True, comment="目的地地址")
  230. destination_lng = Column(DECIMAL(10, 6), nullable=True, comment="送货经度")
  231. destination_lat = Column(DECIMAL(10, 6), nullable=True, comment="送货纬度")
  232. delivery_time = Column(DateTime, nullable=True, comment="送达时间")
  233. destination_notes = Column(String(500), nullable=True, comment="目的地注意事项")
  234. transport_id = Column(String(64), nullable=True, comment="运输ID")
  235. transport_no = Column(String(32), nullable=True, comment="运输编号")
  236. vehicle_id = Column(String(64), nullable=True, comment="车辆ID")
  237. license_plate = Column(String(20), nullable=True, comment="车牌号")
  238. trailer_no = Column(String(20), nullable=True, comment="挂车号(安排运输时快照)")
  239. driver_id = Column(String(64), nullable=True, comment="司机ID")
  240. driver_name = Column(String(100), nullable=True, comment="司机姓名")
  241. personnel_summary = Column(String(500), nullable=True, comment="关联人员摘要(安排运输时快照)")
  242. resource_snapshot = Column(Text, nullable=True, comment="车辆/人员/证件整包快照 JSON")
  243. # 金额汇总
  244. total_amount = Column(DECIMAL(15, 2), nullable=False, default=0, comment="计划总金额")
  245. freight_amount = Column(DECIMAL(15, 2), nullable=False, default=0, comment="运费合计")
  246. # 通知信息
  247. notify_message = Column(Text, nullable=True, comment="通知信息(标准模板)")
  248. # 跟进人
  249. follow_user_id = Column(String(64), nullable=True, comment="跟进人ID")
  250. follow_user_name = Column(String(100), nullable=True, comment="跟进人姓名")
  251. # 公共字段
  252. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  253. order_num = Column(Integer, nullable=True, comment="排序号")
  254. remark = Column(String(512), nullable=True, comment="备注")
  255. create_by = Column(String(64), nullable=True, comment="创建人id")
  256. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  257. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  258. update_by = Column(String(64), nullable=True, comment="更新人id")
  259. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  260. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  261. class PlPlanProduct(Base):
  262. """计划产品明细表 pl_plan_product"""
  263. __tablename__ = "pl_plan_product"
  264. id = Column(String(64), primary_key=True, comment="主键ID")
  265. plan_id = Column(String(64), nullable=False, comment="计划ID")
  266. # 产品信息
  267. product_id = Column(String(64), nullable=False, comment="产品ID")
  268. product_no = Column(String(50), nullable=False, comment="产品编号")
  269. product_name = Column(String(200), nullable=False, comment="产品名称")
  270. model = Column(String(100), nullable=True, comment="规格型号")
  271. unit = Column(String(20), nullable=False, default="吨", comment="单位")
  272. category_name = Column(String(200), nullable=True, comment="产品分类")
  273. package_spec = Column(String(200), nullable=True, comment="包装规格")
  274. delivery_method = Column(String(50), nullable=True, comment="送货方式")
  275. quantity = Column(DECIMAL(15, 3), nullable=True, comment="合同数量")
  276. actual_qty = Column(DECIMAL(15, 3), nullable=True, comment="实际数量")
  277. tax_price = Column(DECIMAL(15, 4), nullable=True, comment="含税单价")
  278. tax_amount = Column(DECIMAL(15, 2), nullable=True, comment="税费")
  279. tax_subtotal = Column(DECIMAL(15, 2), nullable=True, comment="含税总价")
  280. # 产品属性(冗余自产品主数据)
  281. is_explosive = Column(SmallInteger, nullable=False, default=0, comment="是否易制爆 0-否 1-是")
  282. is_toxic = Column(SmallInteger, nullable=False, default=0, comment="是否易制毒 0-否 1-是")
  283. # 购买证/合法使用证明
  284. purchase_cert_url = Column(String(500), nullable=True, comment="购买证URL")
  285. transport_cert_url = Column(String(500), nullable=True, comment="合法使用证明URL")
  286. # 入库信息
  287. inbound_estimate_qty = Column(DECIMAL(15, 3), nullable=True, comment="入库预估数")
  288. inbound_qty = Column(DECIMAL(15, 3), nullable=True, comment="入库数")
  289. inbound_price = Column(DECIMAL(15, 4), nullable=True, comment="入库价")
  290. inbound_amount = Column(DECIMAL(15, 2), nullable=True, comment="入库金额")
  291. # 出库信息
  292. outbound_estimate_qty = Column(DECIMAL(15, 3), nullable=True, comment="出库预估数")
  293. outbound_qty = Column(DECIMAL(15, 3), nullable=True, comment="出库数")
  294. outbound_price = Column(DECIMAL(15, 4), nullable=True, comment="出库单价")
  295. outbound_amount = Column(DECIMAL(15, 2), nullable=True, comment="出库金额")
  296. # 公共字段
  297. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  298. order_num = Column(Integer, nullable=True, comment="排序号")
  299. remark = Column(String(512), nullable=True, comment="备注")
  300. create_by = Column(String(64), nullable=True, comment="创建人id")
  301. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  302. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  303. update_by = Column(String(64), nullable=True, comment="更新人id")
  304. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  305. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  306. class PlPlanChange(Base):
  307. """计划变更记录表 pl_plan_change"""
  308. __tablename__ = "pl_plan_change"
  309. id = Column(String(64), primary_key=True, comment="主键ID")
  310. plan_id = Column(String(64), nullable=False, comment="计划ID")
  311. change_type = Column(String(30), nullable=False, comment="变更类型")
  312. change_content = Column(Text, nullable=True, comment="变更内容")
  313. change_user_id = Column(String(64), nullable=True, comment="变更人ID")
  314. change_user_name = Column(String(100), nullable=True, comment="变更人姓名")
  315. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  316. order_num = Column(Integer, nullable=True, comment="排序号")
  317. remark = Column(String(512), nullable=True, comment="备注")
  318. create_by = Column(String(64), nullable=True, comment="创建人id")
  319. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  320. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  321. update_by = Column(String(64), nullable=True, comment="更新人id")
  322. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  323. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  324. # =============================================================================
  325. # 3. 运输管理:运输表、审批记录
  326. # =============================================================================
  327. class PlTransport(Base):
  328. """运输表 pl_transport"""
  329. __tablename__ = "pl_transport"
  330. id = Column(String(64), primary_key=True, comment="主键ID")
  331. transport_no = Column(String(32), nullable=False, unique=True, comment="运输编号 SXYS######")
  332. # 车辆与司机
  333. vehicle_id = Column(String(64), nullable=True, comment="车辆ID")
  334. license_plate = Column(String(20), nullable=True, comment="车牌号")
  335. trailer_no = Column(String(20), nullable=True, comment="挂车号(安排运输时快照)")
  336. driver_id = Column(String(64), nullable=True, comment="司机ID")
  337. driver_name = Column(String(100), nullable=True, comment="司机姓名")
  338. driver_phone = Column(String(32), nullable=True, comment="司机电话")
  339. resource_snapshot = Column(Text, nullable=True, comment="车辆/人员/证件整包快照 JSON")
  340. # 承运商
  341. carrier_id = Column(String(64), nullable=True, comment="承运商ID")
  342. carrier_name = Column(String(200), nullable=True, comment="承运商名称")
  343. # 运输信息
  344. transport_medium = Column(String(100), nullable=True, comment="运输介质")
  345. start_point = Column(String(200), nullable=True, comment="运输起点")
  346. end_point = Column(String(200), nullable=True, comment="运输终点")
  347. distance_km = Column(DECIMAL(10, 2), nullable=True, comment="运输公里数")
  348. unit = Column(String(20), nullable=True, comment="计量单位 吨/趟")
  349. transport_qty = Column(DECIMAL(15, 3), nullable=True, comment="运输量(按重量计费基数)")
  350. # 运费
  351. freight_price = Column(DECIMAL(15, 4), nullable=True, comment="运输单价")
  352. freight_amount = Column(DECIMAL(15, 2), nullable=False, default=0, comment="运输费用")
  353. freight_type = Column(String(20), nullable=False, default="by_weight", comment="运费计算方式 by_weight-按重量 by_trip-按趟次")
  354. has_invoice = Column(SmallInteger, nullable=False, default=0, comment="是否开票 0-否 1-是")
  355. # 二维码
  356. qr_code = Column(String(500), nullable=True, comment="二维码内容")
  357. qr_expire_date = Column(Date, nullable=True, comment="二维码有效期")
  358. driver_access_token = Column(String(64), nullable=True, comment="司机免登录访问令牌")
  359. # 运输状态
  360. transport_status = Column(String(20), nullable=False, default="draft", comment="运输状态 draft-草稿 pending-待执行 executing-执行中 completed-已完成 cancelled-已取消")
  361. approval_status = Column(String(20), nullable=False, default="none", comment="审批状态 none-无需 pending-审批中 approved-已通过 rejected-已拒绝")
  362. # 司机回传信息
  363. feedback_time = Column(DateTime, nullable=True, comment="回传时间")
  364. feedback_qty = Column(DECIMAL(15, 3), nullable=True, comment="回传数量")
  365. feedback_images = Column(Text, nullable=True, comment="回传图片URLs(JSON数组)")
  366. feedback_remark = Column(String(500), nullable=True, comment="回传备注")
  367. # 公共字段
  368. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  369. order_num = Column(Integer, nullable=True, comment="排序号")
  370. remark = Column(String(512), nullable=True, comment="备注")
  371. create_by = Column(String(64), nullable=True, comment="创建人id")
  372. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  373. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  374. update_by = Column(String(64), nullable=True, comment="更新人id")
  375. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  376. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  377. class PlTransportDbLink(Base):
  378. """运输-地磅出入库关联 pl_transport_db_link"""
  379. __tablename__ = "pl_transport_db_link"
  380. id = Column(String(64), primary_key=True, comment="主键ID")
  381. transport_id = Column(String(64), nullable=False, comment="运输单ID")
  382. plan_id = Column(String(64), nullable=False, comment="运输计划ID")
  383. plan_product_id = Column(String(64), nullable=False, comment="计划产品行ID")
  384. db_purchase_plan_id = Column(String(64), nullable=False, comment="地磅计划ID")
  385. db_inventory_id = Column(String(64), nullable=False, comment="出入库单ID")
  386. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  387. order_num = Column(Integer, nullable=True, comment="排序号")
  388. remark = Column(String(512), nullable=True, comment="备注")
  389. create_by = Column(String(64), nullable=True, comment="创建人id")
  390. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  391. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  392. update_by = Column(String(64), nullable=True, comment="更新人id")
  393. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  394. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  395. class PlPlanTransport(Base):
  396. """计划-运输关联表 pl_plan_transport"""
  397. __tablename__ = "pl_plan_transport"
  398. id = Column(String(64), primary_key=True, comment="主键ID")
  399. plan_id = Column(String(64), nullable=False, comment="计划ID")
  400. transport_id = Column(String(64), nullable=False, comment="运输ID")
  401. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  402. order_num = Column(Integer, nullable=True, comment="排序号")
  403. remark = Column(String(512), nullable=True, comment="备注")
  404. create_by = Column(String(64), nullable=True, comment="创建人id")
  405. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  406. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  407. update_by = Column(String(64), nullable=True, comment="更新人id")
  408. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  409. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  410. class PlTransportSiteLink(Base):
  411. """运输计划现场链接 pl_transport_site_link(与地磅出入库单解耦)"""
  412. __tablename__ = "pl_transport_site_link"
  413. id = Column(String(64), primary_key=True, comment="主键ID")
  414. transport_id = Column(String(64), nullable=False, comment="运输单ID")
  415. plan_id = Column(String(64), nullable=False, comment="运输计划ID")
  416. plan_product_id = Column(String(64), nullable=False, comment="计划产品行ID")
  417. site_access_token = Column(String(64), nullable=False, comment="现场人员免登录访问令牌")
  418. business_type = Column(String(20), nullable=False, comment="业务类型:入库/出库")
  419. partner_company = Column(String(200), nullable=True, comment="往来单位")
  420. product_id = Column(String(64), nullable=True, comment="CRM产品ID")
  421. product = Column(String(200), nullable=True, comment="产品名称快照")
  422. specification = Column(String(200), nullable=True, comment="规格快照")
  423. quantity = Column(DECIMAL(15, 3), nullable=True, comment="数量(吨)")
  424. vehicle_no = Column(String(32), nullable=True, comment="车牌号")
  425. plan_no = Column(String(64), nullable=True, comment="运输计划号")
  426. plan_date = Column(Date, nullable=True, comment="计划日期")
  427. site_feedback_remark = Column(String(500), nullable=True, comment="现场回执备注")
  428. site_feedback_images = Column(Text, nullable=True, comment="现场回执附件URLs(JSON数组)")
  429. site_feedback_time = Column(DateTime, nullable=True, comment="现场回执保存时间")
  430. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  431. order_num = Column(Integer, nullable=True, comment="排序号")
  432. remark = Column(String(512), nullable=True, comment="备注")
  433. create_by = Column(String(64), nullable=True, comment="创建人id")
  434. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  435. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  436. update_by = Column(String(64), nullable=True, comment="更新人id")
  437. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  438. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  439. class PlTransportApproval(Base):
  440. """运输审批记录表 pl_transport_approval"""
  441. __tablename__ = "pl_transport_approval"
  442. id = Column(String(64), primary_key=True, comment="主键ID")
  443. transport_id = Column(String(64), nullable=False, comment="运输ID")
  444. approver_id = Column(String(64), nullable=False, comment="审批人ID")
  445. approver_name = Column(String(100), nullable=False, comment="审批人姓名")
  446. approval_order = Column(Integer, nullable=False, comment="审批顺序")
  447. status = Column(String(20), nullable=False, default="pending", comment="审批状态 pending-待审批 approved-已通过 rejected-已拒绝")
  448. comment = Column(String(500), nullable=True, comment="审批意见")
  449. approval_time = Column(DateTime, nullable=True, comment="审批时间")
  450. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  451. order_num = Column(Integer, nullable=True, comment="排序号")
  452. remark = Column(String(512), nullable=True, comment="备注")
  453. create_by = Column(String(64), nullable=True, comment="创建人id")
  454. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  455. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  456. update_by = Column(String(64), nullable=True, comment="更新人id")
  457. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  458. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  459. # =============================================================================
  460. # 4. 运费结算
  461. # =============================================================================
  462. class PlFreightSettlement(Base):
  463. """运费结算表 pl_freight_settlement"""
  464. __tablename__ = "pl_freight_settlement"
  465. id = Column(String(64), primary_key=True, comment="主键ID")
  466. settlement_no = Column(String(32), nullable=False, unique=True, comment="结算单编号")
  467. # 结算金额
  468. total_freight = Column(DECIMAL(15, 2), nullable=False, default=0, comment="运费合计")
  469. invoice_amount = Column(DECIMAL(15, 2), nullable=True, comment="发票金额")
  470. # 发票信息
  471. invoice_no = Column(String(50), nullable=True, comment="发票号")
  472. invoice_date = Column(Date, nullable=True, comment="开票日期")
  473. invoice_attachment_urls = Column(Text, nullable=True, comment="发票附件URLs,逗号分隔")
  474. # 结算状态
  475. settlement_status = Column(String(20), nullable=False, default="pending", comment="结算状态 pending-待提交 submitted-已提交 approved-审核通过 confirmed-已确认")
  476. # 公共字段
  477. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  478. order_num = Column(Integer, nullable=True, comment="排序号")
  479. remark = Column(String(512), nullable=True, comment="备注")
  480. create_by = Column(String(64), nullable=True, comment="创建人id")
  481. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  482. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  483. update_by = Column(String(64), nullable=True, comment="更新人id")
  484. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  485. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  486. class PlFreightSettlementApproval(Base):
  487. """运费结算审批 pl_freight_settlement_approval"""
  488. __tablename__ = "pl_freight_settlement_approval"
  489. id = Column(String(64), primary_key=True, comment="主键ID")
  490. settlement_id = Column(String(64), nullable=False, comment="结算单ID")
  491. step = Column(Integer, nullable=False, default=1, comment="步骤序号")
  492. step_name = Column(String(50), nullable=True, comment="步骤名称")
  493. approver_id = Column(String(64), nullable=False, comment="审批人ID")
  494. approver_name = Column(String(64), nullable=True, comment="审批人姓名")
  495. approval_type = Column(String(20), nullable=False, default="sequential", comment="审批类型")
  496. approval_result = Column(String(20), nullable=False, default="pending", comment="审批结果")
  497. approval_opinion = Column(String(500), nullable=True, comment="审批意见")
  498. approval_time = Column(DateTime, nullable=True, comment="审批时间")
  499. is_current = Column(SmallInteger, nullable=False, default=0, comment="是否当前节点")
  500. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  501. order_num = Column(Integer, nullable=True, comment="排序号")
  502. remark = Column(String(512), nullable=True, comment="备注")
  503. create_by = Column(String(64), nullable=True, comment="创建人id")
  504. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  505. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  506. update_by = Column(String(64), nullable=True, comment="更新人id")
  507. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  508. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  509. class PlFreightSettlementTransport(Base):
  510. """结算单-运输关联表 pl_freight_settlement_transport"""
  511. __tablename__ = "pl_freight_settlement_transport"
  512. id = Column(String(64), primary_key=True, comment="主键ID")
  513. settlement_id = Column(String(64), nullable=False, comment="结算单ID")
  514. transport_id = Column(String(64), nullable=False, comment="运输ID")
  515. freight_amount = Column(DECIMAL(15, 2), nullable=False, comment="运费金额")
  516. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  517. order_num = Column(Integer, nullable=True, comment="排序号")
  518. remark = Column(String(512), nullable=True, comment="备注")
  519. create_by = Column(String(64), nullable=True, comment="创建人id")
  520. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  521. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  522. update_by = Column(String(64), nullable=True, comment="更新人id")
  523. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  524. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  525. class PlRemittanceVoucher(Base):
  526. """汇款凭证表 pl_remittance_voucher"""
  527. __tablename__ = "pl_remittance_voucher"
  528. id = Column(String(64), primary_key=True, comment="主键ID")
  529. settlement_id = Column(String(64), nullable=False, comment="结算单ID")
  530. voucher_no = Column(String(32), nullable=True, comment="凭证编号")
  531. remittance_date = Column(Date, nullable=True, comment="汇款日期")
  532. remittance_amount = Column(DECIMAL(15, 2), nullable=True, comment="汇款金额")
  533. voucher_urls = Column(Text, nullable=True, comment="凭证文件URLs(JSON数组)")
  534. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  535. order_num = Column(Integer, nullable=True, comment="排序号")
  536. remark = Column(String(512), nullable=True, comment="备注")
  537. create_by = Column(String(64), nullable=True, comment="创建人id")
  538. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  539. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  540. update_by = Column(String(64), nullable=True, comment="更新人id")
  541. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  542. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  543. # =============================================================================
  544. # 5. 库存管理
  545. # =============================================================================
  546. class PlInventory(Base):
  547. """库存表 pl_inventory"""
  548. __tablename__ = "pl_inventory"
  549. id = Column(String(64), primary_key=True, comment="主键ID")
  550. product_id = Column(String(64), nullable=False, comment="产品ID")
  551. product_no = Column(String(50), nullable=False, comment="产品编号")
  552. product_name = Column(String(200), nullable=False, comment="产品名称")
  553. model = Column(String(100), nullable=True, comment="规格型号")
  554. unit = Column(String(20), nullable=False, default="吨", comment="单位")
  555. # 库存数量与金额
  556. stock_qty = Column(DECIMAL(15, 3), nullable=False, default=0, comment="库存数量")
  557. stock_amount = Column(DECIMAL(15, 2), nullable=False, default=0, comment="库存金额")
  558. # 预警阈值
  559. low_stock_warning = Column(DECIMAL(15, 3), nullable=True, comment="最低库存预警值")
  560. high_stock_warning = Column(DECIMAL(15, 3), nullable=True, comment="最高库存预警值")
  561. # 公共字段
  562. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  563. order_num = Column(Integer, nullable=True, comment="排序号")
  564. remark = Column(String(512), nullable=True, comment="备注")
  565. create_by = Column(String(64), nullable=True, comment="创建人id")
  566. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  567. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  568. update_by = Column(String(64), nullable=True, comment="更新人id")
  569. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  570. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  571. class PlInventoryTransaction(Base):
  572. """库存流水表 pl_inventory_transaction"""
  573. __tablename__ = "pl_inventory_transaction"
  574. id = Column(String(64), primary_key=True, comment="主键ID")
  575. product_id = Column(String(64), nullable=False, comment="产品ID")
  576. product_name = Column(String(200), nullable=False, comment="产品名称")
  577. transaction_type = Column(String(20), nullable=False, comment="事务类型 inbound-入库 outbound-出库")
  578. plan_id = Column(String(64), nullable=True, comment="计划ID")
  579. plan_no = Column(String(32), nullable=True, comment="计划编号")
  580. # 数量与价格
  581. qty = Column(DECIMAL(15, 3), nullable=False, comment="变动数量(正数入库/负数出库)")
  582. unit_price = Column(DECIMAL(15, 4), nullable=False, comment="单价")
  583. amount = Column(DECIMAL(15, 2), nullable=False, comment="金额")
  584. stock_after = Column(DECIMAL(15, 3), nullable=False, comment="变动后库存")
  585. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  586. order_num = Column(Integer, nullable=True, comment="排序号")
  587. remark = Column(String(512), nullable=True, comment="备注")
  588. create_by = Column(String(64), nullable=True, comment="创建人id")
  589. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  590. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  591. update_by = Column(String(64), nullable=True, comment="更新人id")
  592. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  593. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  594. class PlInventoryWarning(Base):
  595. """库存预警表 pl_inventory_warning"""
  596. __tablename__ = "pl_inventory_warning"
  597. id = Column(String(64), primary_key=True, comment="主键ID")
  598. product_id = Column(String(64), nullable=False, comment="产品ID")
  599. product_name = Column(String(200), nullable=False, comment="产品名称")
  600. warning_type = Column(String(20), nullable=False, comment="预警类型 low-低于最低 high-高于最高")
  601. current_qty = Column(DECIMAL(15, 3), nullable=False, comment="当前库存")
  602. threshold_value = Column(DECIMAL(15, 3), nullable=False, comment="阈值")
  603. status = Column(String(20), nullable=False, default="pending", comment="状态 pending-待处理 resolved-已处理")
  604. resolve_time = Column(DateTime, nullable=True, comment="处理时间")
  605. resolve_remark = Column(String(500), nullable=True, comment="处理备注")
  606. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  607. order_num = Column(Integer, nullable=True, comment="排序号")
  608. remark = Column(String(512), nullable=True, comment="备注")
  609. create_by = Column(String(64), nullable=True, comment="创建人id")
  610. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  611. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  612. update_by = Column(String(64), nullable=True, comment="更新人id")
  613. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  614. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  615. class PlDocumentReminder(Base):
  616. """证件到期提醒表 pl_document_reminder"""
  617. __tablename__ = "pl_document_reminder"
  618. id = Column(String(64), primary_key=True, comment="主键ID")
  619. cert_id = Column(String(64), nullable=True, comment="证书ID")
  620. owner_type = Column(String(20), nullable=True, comment="归属类型 vehicle/personnel")
  621. owner_id = Column(String(64), nullable=True, comment="归属主体ID")
  622. owner_label = Column(String(200), nullable=True, comment="归属展示名(车牌/姓名)")
  623. driver_id = Column(String(64), nullable=True, comment="司机/人员ID(兼容)")
  624. driver_name = Column(String(100), nullable=True, comment="司机/人员姓名(兼容)")
  625. document_type = Column(String(100), nullable=False, comment="证件类型/证书名称")
  626. document_no = Column(String(50), nullable=True, comment="证件号")
  627. expire_date = Column(Date, nullable=False, comment="到期日期")
  628. days_remaining = Column(Integer, nullable=False, comment="剩余天数")
  629. status = Column(String(20), nullable=False, default="pending", comment="状态 pending-待处理 resolved-已处理")
  630. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  631. order_num = Column(Integer, nullable=True, comment="排序号")
  632. remark = Column(String(512), nullable=True, comment="备注")
  633. create_by = Column(String(64), nullable=True, comment="创建人id")
  634. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  635. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  636. update_by = Column(String(64), nullable=True, comment="更新人id")
  637. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  638. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  639. class PlVehicleRechargeApply(Base):
  640. """车辆ETC/加油充值申请 pl_vehicle_recharge_apply"""
  641. __tablename__ = "pl_vehicle_recharge_apply"
  642. id = Column(String(64), primary_key=True, comment="主键ID")
  643. apply_no = Column(String(32), nullable=False, unique=True, comment="申请单号")
  644. license_plate = Column(String(20), nullable=False, comment="车牌号")
  645. recharge_type = Column(String(20), nullable=False, comment="充值类型 etc/fuel")
  646. apply_date = Column(Date, nullable=False, comment="申请日期")
  647. odometer_km = Column(DECIMAL(10, 1), nullable=True, comment="期初公里数")
  648. attachment_urls = Column(String(2000), nullable=True, comment="附件URL")
  649. applicant_id = Column(String(64), nullable=False, comment="申请人ID")
  650. status = Column(String(20), nullable=False, default="pending", comment="申请状态")
  651. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  652. order_num = Column(Integer, nullable=True, comment="排序号")
  653. remark = Column(String(512), nullable=True, comment="备注")
  654. create_by = Column(String(64), nullable=True, comment="创建人id")
  655. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  656. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  657. update_by = Column(String(64), nullable=True, comment="更新人id")
  658. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  659. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  660. class PlVehicleMaintenanceApply(Base):
  661. """车辆维保申请 pl_vehicle_maintenance_apply"""
  662. __tablename__ = "pl_vehicle_maintenance_apply"
  663. id = Column(String(64), primary_key=True, comment="主键ID")
  664. apply_no = Column(String(32), nullable=False, unique=True, comment="申请单号")
  665. license_plate = Column(String(20), nullable=False, comment="车牌号")
  666. applicant_id = Column(String(64), nullable=False, comment="申请人ID")
  667. apply_date = Column(Date, nullable=False, comment="申请时间")
  668. maintenance_type = Column(String(64), nullable=False, comment="维保类型")
  669. start_date = Column(Date, nullable=False, comment="维保开始时间")
  670. expected_pickup_date = Column(Date, nullable=True, comment="预计取车时间")
  671. maintenance_content = Column(String(1000), nullable=True, comment="维保内容")
  672. shop_address = Column(String(500), nullable=True, comment="维保店铺地址")
  673. attachment_urls = Column(String(2000), nullable=True, comment="附件URL")
  674. status = Column(String(20), nullable=False, default="pending", comment="申请状态")
  675. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  676. order_num = Column(Integer, nullable=True, comment="排序号")
  677. remark = Column(String(512), nullable=True, comment="备注")
  678. create_by = Column(String(64), nullable=True, comment="创建人id")
  679. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  680. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  681. update_by = Column(String(64), nullable=True, comment="更新人id")
  682. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  683. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  684. class PlVehicleMaintenanceProcess(Base):
  685. """车辆维保处理登记 pl_vehicle_maintenance_process"""
  686. __tablename__ = "pl_vehicle_maintenance_process"
  687. id = Column(String(64), primary_key=True, comment="主键ID")
  688. process_no = Column(String(32), nullable=False, unique=True, comment="处理单号")
  689. apply_id = Column(String(64), nullable=True, unique=True, comment="关联申请单ID")
  690. license_plate = Column(String(20), nullable=True, comment="车牌号冗余")
  691. amount = Column(DECIMAL(10, 2), nullable=True, comment="金额")
  692. handler_id = Column(String(64), nullable=False, comment="处理人ID")
  693. process_date = Column(Date, nullable=False, comment="处理时间")
  694. attachment_urls = Column(String(2000), nullable=True, comment="附件URL")
  695. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  696. order_num = Column(Integer, nullable=True, comment="排序号")
  697. remark = Column(String(512), nullable=True, comment="备注")
  698. create_by = Column(String(64), nullable=True, comment="创建人id")
  699. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  700. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  701. update_by = Column(String(64), nullable=True, comment="更新人id")
  702. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  703. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  704. class PlVehicleUreaApply(Base):
  705. """车辆尿素申请 pl_vehicle_urea_apply"""
  706. __tablename__ = "pl_vehicle_urea_apply"
  707. id = Column(String(64), primary_key=True, comment="主键ID")
  708. apply_no = Column(String(32), nullable=False, unique=True, comment="申请单号")
  709. license_plate = Column(String(20), nullable=False, comment="车牌号")
  710. applicant_id = Column(String(64), nullable=False, comment="申请人ID")
  711. apply_date = Column(Date, nullable=False, comment="申请时间")
  712. warehouse_in_date = Column(Date, nullable=False, comment="入库时间")
  713. unit = Column(String(32), nullable=False, comment="单位")
  714. quantity = Column(DECIMAL(10, 2), nullable=False, comment="入库数")
  715. apply_amount = Column(DECIMAL(10, 2), nullable=False, comment="申请金额")
  716. attachment_urls = Column(String(2000), nullable=True, comment="附件URL")
  717. status = Column(String(20), nullable=False, default="pending", comment="申请状态")
  718. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  719. order_num = Column(Integer, nullable=True, comment="排序号")
  720. remark = Column(String(512), nullable=True, comment="备注")
  721. create_by = Column(String(64), nullable=True, comment="创建人id")
  722. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  723. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  724. update_by = Column(String(64), nullable=True, comment="更新人id")
  725. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  726. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  727. class PlVehicleUreaDisburse(Base):
  728. """车辆尿素发放登记 pl_vehicle_urea_disburse"""
  729. __tablename__ = "pl_vehicle_urea_disburse"
  730. id = Column(String(64), primary_key=True, comment="主键ID")
  731. disburse_no = Column(String(32), nullable=False, unique=True, comment="发放单号")
  732. apply_id = Column(String(64), nullable=True, unique=True, comment="关联申请单ID")
  733. license_plate = Column(String(20), nullable=True, comment="车牌号冗余")
  734. amount = Column(DECIMAL(10, 2), nullable=False, comment="发放金额")
  735. handler_id = Column(String(64), nullable=False, comment="处理人ID")
  736. disburse_date = Column(Date, nullable=False, comment="发放时间")
  737. attachment_urls = Column(String(2000), nullable=True, comment="附件URL")
  738. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  739. order_num = Column(Integer, nullable=True, comment="排序号")
  740. remark = Column(String(512), nullable=True, comment="备注")
  741. create_by = Column(String(64), nullable=True, comment="创建人id")
  742. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  743. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  744. update_by = Column(String(64), nullable=True, comment="更新人id")
  745. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  746. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  747. class PlVehicleRechargeRecord(Base):
  748. """车辆ETC/加油充值发放登记 pl_vehicle_recharge_record"""
  749. __tablename__ = "pl_vehicle_recharge_record"
  750. id = Column(String(64), primary_key=True, comment="主键ID")
  751. recharge_order_no = Column(String(32), nullable=False, unique=True, comment="充值订单号")
  752. recharge_date = Column(Date, nullable=False, comment="充值日期")
  753. recharge_type = Column(String(20), nullable=False, comment="充值类型")
  754. card_no = Column(String(64), nullable=True, comment="卡号")
  755. gas_station = Column(String(200), nullable=True, comment="加油站/渠道")
  756. amount = Column(DECIMAL(10, 2), nullable=False, comment="充值金额")
  757. attachment_urls = Column(String(2000), nullable=True, comment="附件URL")
  758. apply_id = Column(String(64), nullable=True, unique=True, comment="关联申请单ID")
  759. license_plate = Column(String(20), nullable=True, comment="车牌号冗余")
  760. tenant_no = Column(String(64), nullable=False, default="shanxia2.0", comment="租户编号")
  761. order_num = Column(Integer, nullable=True, comment="排序号")
  762. remark = Column(String(512), nullable=True, comment="备注")
  763. create_by = Column(String(64), nullable=True, comment="创建人id")
  764. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  765. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  766. update_by = Column(String(64), nullable=True, comment="更新人id")
  767. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  768. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")