DPickingIndex.Class.php 2.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * User: Gss
  5. * Date: 2021/5/17 0017
  6. * Time: 17:32
  7. */
  8. namespace JinDouYun\Dao\Stock;
  9. use JinDouYun\Dao\BaseDao;
  10. class DPickingIndex extends BaseDao
  11. {
  12. public function __construct($serviceDB = 'stock')
  13. {
  14. $this->_table = 'picking_index';
  15. $this->_primary = 'id';
  16. $this->_fields = [
  17. 'id',//int(10) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  18. 'no',//varchar(255) NOT NULL COMMENT '单据编号',
  19. 'shopId',//int(10) NOT NULL DEFAULT '0' COMMENT '店铺id',
  20. 'shopName',//varchar(255) NOT NULL COMMENT '店铺名称',
  21. 'merchantId',//int(10) NOT NULL DEFAULT '0' COMMENT '商户id',
  22. 'originId',//int(10) NOT NULL DEFAULT '0' COMMENT '源订单id',
  23. 'originNo',//varchar(255) NOT NULL COMMENT '源订单no',
  24. 'warehouseId',//int(10) NOT NULL DEFAULT '0' COMMENT '仓库id',
  25. 'warehouseName',//varchar(255) NOT NULL COMMENT '仓库名称',
  26. 'currentUnitId',// int(11) NOT NULL COMMENT '往来单位Id',
  27. 'currentUnit',//varchar(255) NOT NULL COMMENT '往来单位',
  28. 'personnel',//int(10) NOT NULL DEFAULT '0' COMMENT '拣货id',
  29. 'personnelName',//varchar(255) NOT NULL COMMENT '拣货人',
  30. 'sort',//int(10) NOT NULL COMMENT '排序',
  31. 'managerId',//int(10) NOT NULL DEFAULT '0' COMMENT '订单经手人ID',
  32. 'managerName',//varchar(255) NOT NULL COMMENT '订单经手人',
  33. 'pickingStatus',//tinyint(1) NOT NULL DEFAULT '4' COMMENT '拣货状态',
  34. 'pickingType',//tinyint(1) NOT NULL DEFAULT '4' COMMENT '拣货类型',
  35. 'createTime',//int(11) NOT NULL COMMENT '创建时间',
  36. 'updateTime',// int(11) DEFAULT NULL,
  37. ];
  38. $this->_readonly = ['id'];
  39. $this->_create_autofill = [
  40. 'createTime' => time()
  41. ];
  42. $this->_update_autofill = [
  43. 'updateTime' => time()
  44. ];
  45. parent::__construct($serviceDB);
  46. }
  47. }