DPurchaseOut.Class.php 2.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657
  1. <?php
  2. /**
  3. * 采购退货单Dao
  4. * Created by PhpStorm.
  5. * User: XiaoMing
  6. * Date: 2019/11/11
  7. * Time: 17:46
  8. */
  9. namespace Jobs\Dao\Purchase;
  10. use Jobs\Dao\BaseDao;
  11. class DPurchaseOut extends BaseDao
  12. {
  13. public function __construct($serviceDB = 'stock')
  14. {
  15. $this->_table = 'purchase_out';
  16. $this->_primary = 'id';
  17. $this->_fields = [
  18. "id", //int(10) NOT NULL AUTO_INCREMENT,
  19. "purchaseId", //int(10) NOT NULL DEFAULT '0' COMMENT '采购单id',
  20. "purchaseNo", //bigint(20) NOT NULL COMMENT '采购订单号',
  21. "no", //bigint(20) NOT NULL COMMENT '采购退货单号',
  22. "shopId", //int(10) NOT NULL DEFAULT '0' COMMENT '门店id',
  23. "shopName", //varchar(255) NOT NULL DEFAULT '' COMMENT '门店名称',
  24. "supplierId", //int(10) NOT NULL DEFAULT '0' COMMENT '供应商Id',
  25. "supplierName", //varchar(255) NOT NULL DEFAULT '' COMMENT '供应商名称',
  26. "buyerId", //int(10) NOT NULL DEFAULT '0' COMMENT '采购人员Id',
  27. "buyerName", //varchar(255) NOT NULL DEFAULT '' COMMENT '采购人员名称',
  28. "remark", //varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  29. "operatorId", //int(10) NOT NULL DEFAULT '0' COMMENT '制单人员Id',
  30. "operatorName", //varchar(255) NOT NULL DEFAULT '' COMMENT '制单人名',
  31. "purchaseAmount", //decimal(12,4) default '0.0000' COMMENT '采购退货金额',
  32. "couponAmount", //decimal(12,4) default '0.0000' COMMENT '优惠金额',
  33. "otherAmount", //decimal(12,4) default '0.0000' COMMENT '其他金额',
  34. "extends", //json DEFAULT NULL COMMENT '拓展字段',
  35. "orderStatus",
  36. "auditStatus", //tinyint(3) NOT NULL DEFAULT '1' COMMENT '审核状态 默认1 待审 2审核通过 3审核未通过 4审核中',
  37. "deleteStatus", //tinyint(3) NOT NULL DEFAULT '5' COMMENT '是否删除 默认5 正常 4删除',
  38. "auditId", //int(10) NOT NULL DEFAULT '0' COMMENT '审核人员Id',
  39. "auditName", //varchar(255) NOT NULL DEFAULT '' COMMENT '审核人员名册',
  40. "auditTime", //int(10) NOT NULL DEFAULT '0' COMMENT '审核时间',
  41. "createTime", //int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
  42. "updateTime", //int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
  43. ];
  44. $this->_readonly = ['id'];
  45. $this->_create_autofill = [
  46. 'createTime' => time()
  47. ];
  48. $this->_update_autofill = [
  49. 'updateTime' => time()
  50. ];
  51. parent::__construct($serviceDB);
  52. }
  53. }