DAllocate.Class.php 2.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950
  1. <?php
  2. /**
  3. * 仓库调拨管理Dao
  4. * Created by PhpStorm.
  5. * User: 小威
  6. * Date: 2019/11/29
  7. * Time: 15:00
  8. */
  9. namespace JinDouYun\Dao\Stock;
  10. use JinDouYun\Dao\BaseDao;
  11. class DAllocate extends BaseDao
  12. {
  13. public function __construct($serviceDB = 'stock')
  14. {
  15. $this->_table = 'allocate';
  16. $this->_primary = 'id';
  17. $this->_fields = [
  18. "id", //int(10) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  19. "no", //char(20) DEFAULT NULL COMMENT '调拨入库单号',
  20. "warehouseId", //int(10) DEFAULT NULL COMMENT '仓库id',
  21. "warehouseName", //int(10) DEFAULT NULL COMMENT '仓库name',
  22. "num", //decimal(20,8) NOT NULL COMMENT '调拨商品数量',
  23. "inWarehouseId", //int(10) DEFAULT NULL COMMENT '调拨进入仓库id',
  24. "inWarehouseName", //int(10) DEFAULT NULL COMMENT '调拨进入仓库name',
  25. "operatorId", //int(10) DEFAULT NULL COMMENT '制单人信息',
  26. "operatorName", //varchar(30) DEFAULT NULL COMMENT '制单人姓名',
  27. "auditId", //int(10) DEFAULT NULL COMMENT '审核人id',
  28. "auditName", //varchar(30) DEFAULT NULL COMMENT '审核人姓名',
  29. "auditTime", //int(10) DEFAULT NULL COMMENT '审核时间',
  30. "auditStatus", //tinyint(3) DEFAULT '1' COMMENT '审核状态 1:待审核 2:已审核 3:审核失败 4:审核中',
  31. "remark", //varchar(255) DEFAULT NULL COMMENT '备注',
  32. "deleteStatus", //tinyint(3) DEFAULT '5' COMMENT '删除状态 4:已删除 5:正常',
  33. "createTime", //int(10) DEFAULT NULL COMMENT '创建时间',
  34. "updateTime", //int(10) DEFAULT NULL COMMENT '修改时间',
  35. "extend", //json DEFAULT NULL COMMENT '扩展字段',
  36. ];
  37. $this->_readonly = ['id'];
  38. $this->_create_autofill = [
  39. 'createTime' => time()
  40. ];
  41. $this->_update_autofill = [
  42. 'updateTime' => time()
  43. ];
  44. parent::__construct($serviceDB);
  45. }
  46. }