DPurchaseOut.Class.php 2.8 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162
  1. <?php
  2. /**
  3. * 采购退货单Dao
  4. * Created by PhpStorm.
  5. * User: XiaoMing
  6. * Date: 2019/11/11
  7. * Time: 17:46
  8. */
  9. namespace JinDouYun\Dao\Purchase;
  10. use JinDouYun\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',
  23. 'shopName',
  24. 'warehouseId',
  25. 'warehouseName',
  26. "supplierId", //int(10) NOT NULL DEFAULT '0' COMMENT '供应商Id',
  27. "supplierName", //varchar(255) NOT NULL DEFAULT '' COMMENT '供应商名称',
  28. "merchantId",// int(10) NOT NULL DEFAULT '0' COMMENT '商户id',
  29. "merchantName",// varchar(255) NOT NULL COMMENT '商户名称',
  30. "buyerId", //int(10) NOT NULL DEFAULT '0' COMMENT '采购人员Id',
  31. "buyerName", //varchar(255) NOT NULL DEFAULT '' COMMENT '采购人员名称',
  32. "remark", //varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  33. "operatorId", //int(10) NOT NULL DEFAULT '0' COMMENT '制单人员Id',
  34. "operatorName", //varchar(255) NOT NULL DEFAULT '' COMMENT '制单人名',
  35. "purchaseAmount", //decimal(12,4) default '0.0000' COMMENT '采购退货金额',
  36. "couponAmount", //decimal(12,4) default '0.0000' COMMENT '优惠金额',
  37. "otherAmount", //decimal(12,4) default '0.0000' COMMENT '其他金额',
  38. "extends", //json DEFAULT NULL COMMENT '拓展字段',
  39. "purchaseStatus",// tinyint(1) DEFAULT '4' COMMENT '类型 , 5商户,4正常',
  40. "orderStatus",
  41. "auditStatus", //tinyint(3) NOT NULL DEFAULT '1' COMMENT '审核状态 默认1 待审 2审核通过 3审核未通过 4审核中',
  42. "deleteStatus", //tinyint(3) NOT NULL DEFAULT '5' COMMENT '是否删除 默认5 正常 4删除',
  43. "auditId", //int(10) NOT NULL DEFAULT '0' COMMENT '审核人员Id',
  44. "auditName", //varchar(255) NOT NULL DEFAULT '' COMMENT '审核人员名册',
  45. "auditTime", //int(10) NOT NULL DEFAULT '0' COMMENT '审核时间',
  46. "createTime", //int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
  47. "updateTime", //int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
  48. ];
  49. $this->_readonly = ['id'];
  50. $this->_create_autofill = [
  51. 'createTime' => time()
  52. ];
  53. $this->_update_autofill = [
  54. 'updateTime' => time()
  55. ];
  56. parent::__construct($serviceDB);
  57. }
  58. }