seaBlueQueue/Jobs/Dao/Purchase/DPurchase.Class.php

<?php
/**
 * 采购Dao
 * Created by PhpStorm.
 * User: XiaoMing
 * Date: 2019/11/11
 * Time: 17:46
 */

namespace Jobs\Dao\Purchase;

use Jobs\Dao\BaseDao;

class DPurchase extends BaseDao
{
    public function __construct($serviceDB = 'stock')
    {
        $this->_table = 'purchase';
        $this->_primary = 'id';
        $this->_fields = [
            "id", //int(10) NOT NULL AUTO_INCREMENT,
            "no", //char(20) NOT NULL COMMENT '采购单号',
            "shopId", //int(10) NOT NULL DEFAULT '0' COMMENT '采购门店id',
            "shopName", //varchar(255) NOT NULL DEFAULT '' COMMENT '门店名称',
            "supplierId", //int(10) NOT NULL DEFAULT '0' COMMENT '供应商Id',
            "supplierName", //varchar(255) NOT NULL DEFAULT '' COMMENT '供应商名称',
            "buyerId", //int(10) NOT NULL DEFAULT '0' COMMENT '采购人员Id',
            "buyerName", //varchar(255) NOT NULL DEFAULT '' COMMENT '采购人员名称',
            "remark", //varchar(255) DEFAULT '' COMMENT '备注',
            "operatorId", //int(10) NOT NULL DEFAULT '0' COMMENT '制单人员Id',
            "operatorName", //varchar(255) NOT NULL DEFAULT '' COMMENT '制单人名',
            "purchaseAmount", //decimal(15,4) DEFAULT '0.0000' COMMENT '采购金额',
            "couponAmount", //decimal(15,4) DEFAULT '0.0000' COMMENT '优惠金额',
            "otherAmount", //decimal(15,4) DEFAULT '0.0000' COMMENT '其他金额',
            "goodsNum", //decimal(20,8) NOT NULL COMMENT '采购商品数量',
            "extends", //json DEFAULT NULL COMMENT '拓展字段',
            "orderStatus", //tinyint(3) DEFAULT '4' COMMENT '单据入库状态 4:未入库 5:已入库',
            "auditStatus", //tinyint(3) NOT NULL DEFAULT '1' COMMENT '审核状态  默认1 待审 2审核通过 3审核未通过 4审核中',
            "deleteStatus", //tinyint(3) NOT NULL DEFAULT '5' COMMENT '是否删除 默认5 正常 4删除',
            "auditId", //int(10) NOT NULL DEFAULT '0' COMMENT '审核人员Id',
            "auditName", //varchar(255) NOT NULL DEFAULT '' COMMENT '审核人员名册',
            "auditTime", //int(10) NOT NULL DEFAULT '0' COMMENT '审核时间',
            "createTime", //int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
            "updateTime", //int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
        ];
        $this->_readonly = ['id'];
        $this->_create_autofill = [
            'createTime' => time()
        ];
        $this->_update_autofill = [
            'updateTime' => time()
        ];

        parent::__construct($serviceDB);
    }
}