<?php

namespace JinDouYun\Dao\Price;

use JinDouYun\Dao\BaseDao;

class DPriceAdjustment extends BaseDao
{
    public function __construct($serviceDB = 'price')
    {
        $this->_table = 'priceAdjustmentSheet';
        $this->_primary = 'id';
        $this->_fields = [
            "id", //int(10) NOT NULL AUTO_INCREMENT COMMENT '自增id',
            "no", //char(20) NOT NULL COMMENT '调价单号',
            "goodsCode", //varchar(50) NOT NULL COMMENT '商品code',
            "goodsName", //varchar(100) NOT NULL COMMENT '商品名称',
            "goodsId", //int(10) NOT NULL COMMENT '商品id',
            "saleType", //tinyint(3) NOT NULL DEFAULT '1' COMMENT '销售类型 1实物销售 2虚库销售',
            "salePriceAreaType", //tinyint(3) NOT NULL COMMENT '销售价格生效区域类型 1全国统一价 2大区价',
            "salePriceType", //tinyint(3) NOT NULL DEFAULT '1' COMMENT '销售价格类型 1销售价格 2秒杀活动价',
            "shopId", //int(10) NOT NULL COMMENT '店铺id',
            "shopName",//varchar(50) DEFAULT NULL COMMENT '店铺名称',
            "cargoOwnerCode", //varchar(50) DEFAULT NULL COMMENT '货主编码',
            "createTime", //int(10) NOT NULL COMMENT '创建时间',
            "updateTime", //int(10) NOT NULL COMMENT '修改时间',
            "deleteStatus", //tinyint(3) NOT NULL DEFAULT '1' COMMENT '删除状态 4删除 5正常',
            "effectiveStatus", //tinyint(3) NOT NULL DEFAULT '1' COMMENT '生效状态 1.待审 2审核通过 3未通过 4审核中',
            "salePrice", //json NOT NULL COMMENT '销售价格',
            "createUserId", //int(10) NOT NULL COMMENT '创建人',
            "createUserName", //varchar(50) NOT NULL COMMENT '创建人姓名',
            "effectiveUserName",//
            "effectiveUserId",//
        ];
        $this->_readonly = ['id'];
        $this->_create_autofill = [
        ];
        $this->_update_autofill = [
        ];

        parent::__construct($serviceDB);
    }
}