DDeliveryDetails.Class.php 4.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * User: kang
  5. * Date: 2021/5/26
  6. * Time: 19:45
  7. */
  8. namespace JinDouYun\Dao\Delivery;
  9. use JinDouYun\Dao\BaseDao;
  10. class DDeliveryDetails extends BaseDao
  11. {
  12. public function __construct($serviceDB = 'stock')
  13. {
  14. $this->_table = 'delivery_details';
  15. $this->_primary = 'id';
  16. $this->_fields = [
  17. 'id' ,//int(10) NOT NULL AUTO_INCREMENT COMMENT '配送明细id',
  18. 'linkeId' ,//int(10) NOT NULL COMMENT '主单据表id',
  19. 'deliveryDate' ,//varchar(255) NOT NULL COMMENT '单据日期',
  20. 'TaskNo' ,//varchar(255) NOT NULL COMMENT '单据编号',
  21. "deliveryStatus" ,//int(11) NOT NULL DEFAULT '1' COMMENT '配送状态(1:待配送 2:已配送3:配送中)',
  22. 'sourceNo' ,//varchar(255) NOT NULL COMMENT '来源单号',
  23. 'customerId' ,//tinyint(255) NOT NULL COMMENT '客户id',
  24. 'customerName' ,//varchar(255) NOT NULL COMMENT '客户名称',
  25. 'manager' ,//varchar(255) NOT NULL COMMENT '经手人',
  26. 'receiver' ,//varchar(255) NOT NULL COMMENT '收货人',
  27. 'mobile' ,//varchar(255) NOT NULL COMMENT '联系电话',
  28. 'receivingAddress' ,//varchar(255) DEFAULT NULL COMMENT '收货地址',
  29. 'distributionRoute' ,//varchar(255) DEFAULT NULL COMMENT '配送线路',
  30. 'deliveryOrder' ,//varchar(255) DEFAULT NULL COMMENT '配送顺序',
  31. 'deliveryWarehouseId' ,//int(11) NOT NULL COMMENT '发货仓库id',
  32. 'binningNum' ,//varchar(255) NOT NULL COMMENT '装箱数量',
  33. 'deliveryQuantity' ,//varchar(255) NOT NULL COMMENT '发货数量',
  34. 'returnWarehouse' ,//varchar(255) NOT NULL COMMENT '退货仓库',
  35. 'returnGoodsNum' ,//varchar(255) DEFAULT NULL COMMENT '退货数量',
  36. 'containerLocation' ,//varchar(255) DEFAULT NULL COMMENT '集货位',
  37. 'estimateDeliveryDate' ,//varchar(255) DEFAULT NULL COMMENT '预计发货日期',
  38. 'remark' ,//varchar(255) DEFAULT NULL COMMENT '备注',
  39. 'deleteStatus' ,//tinyint(11) NOT NULL DEFAULT '5' COMMENT '是否删除 4 删除 5正常',
  40. 'createTime' ,//varchar(255) NOT NULL COMMENT '创建时间',
  41. 'updateTime' ,//varchar(255) DEFAULT NULL COMMENT '修改时间',
  42. 'extends' ,//json DEFAULT NULL COMMENT '扩展字段',
  43. 'enterpriseId' ,//int(10) unsigned zerofill NOT NULL DEFAULT '0000000000' COMMENT '企业id',
  44. "driverId",// int(10) DEFAULT NULL COMMENT '司机id',
  45. "driverName",// varchar(255) DEFAULT NULL COMMENT '司机名称',
  46. "carId",// int(10) DEFAULT NULL COMMENT '车辆id',
  47. "deliveryCar",// varchar(255) DEFAULT NULL COMMENT '车辆名称',
  48. 'deliveryOrderNum' ,//varchar(255) DEFAULT NULL COMMENT '送货数量',
  49. 'returnGoodsOrderNum' ,//varchar(255) DEFAULT NULL COMMENT '退货数量',
  50. 'deliverGoodsQuantity' ,//varchar(255) DEFAULT NULL COMMENT '发货数量',
  51. 'deliveryAmount' ,//varchar(255) DEFAULT NULL COMMENT '发货金额',
  52. 'signedQuantity' ,//varchar(255) DEFAULT NULL COMMENT '签收数量',
  53. 'signedAmount' ,//varchar(255) DEFAULT NULL COMMENT '签收金额',
  54. 'rejectionQuantity' ,//varchar(255) DEFAULT NULL COMMENT '拒收数量',
  55. 'rejectionAmount' ,//varchar(255) DEFAULT NULL COMMENT '拒收金额',
  56. 'deliveryMileage' ,//varchar(255) DEFAULT NULL COMMENT '配送里程',
  57. ];
  58. $this->_readonly = ['id'];
  59. $this->_create_autofill = [
  60. 'createTime' => time()
  61. ];
  62. $this->_update_autofill = [
  63. 'updateTime' => time()
  64. ];
  65. parent::__construct($serviceDB);
  66. }
  67. }