<?php
/**
 * Created by PhpStorm.
 * User: Gss
 * Date: 2021/3/8 0008
 * Time: 15:24
 */

namespace JinDouYun\Dao\Finance;

use JinDouYun\Dao\BaseDao;

class DExpenseSingle extends BaseDao
{
    public function __construct($serviceDB = 'default')
    {
        $this->_table = 'qianniao_expense_single_1';
        $this->_primary = 'id';
        $this->_fields = [
            'id',//int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
            'no',//varchar(255) NOT NULL COMMENT '单据编号',
            'currentUnitId',// int(10) unsigned NOT NULL,
            'currentUnit',//varchar(255) NOT NULL COMMENT '往来单位',
            'type',// tinyint(1) DEFAULT NULL COMMENT '3 员工 / 4 客户 / 5 供应商',
            'billTime',//int(10) DEFAULT NULL COMMENT '单据实际',
            'manager',//varchar(50) NOT NULL COMMENT '经手人',
            'shopId',// int(10) NOT NULL DEFAULT '0' COMMENT '店铺id',
            'shopName',// varchar(255) DEFAULT NULL COMMENT '店铺名称',
            'consumeTypeId',//int(10) DEFAULT NULL COMMENT '消费类型id',
            'consumeTypeName',//varchar(255) DEFAULT NULL COMMENT '消费类型名称',
            'totalCollectionAmount',//decimal(15,4) DEFAULT NULL COMMENT '总收金额',
            'totalPreferentialAmount',//decimal(15,4) DEFAULT NULL COMMENT '总优惠金额',
            'totalActualAmount',//decimal(15,4) DEFAULT NULL COMMENT '总实际金额',
            'payType',// int(10) unsigned NOT NULL COMMENT '支出类型',
            'auditStatus',//int(10) NOT NULL DEFAULT '1' COMMENT '审核状态',
            'deleteStatus',//int(10) NOT NULL DEFAULT '5' COMMENT '删除状态',
            'createTime',//int(10) NOT NULL COMMENT '创建时间',
            'updateTime',//int(10) NOT NULL COMMENT '更新时间',
            'extend',//json DEFAULT NULL COMMENT '扩展字段',
        ];
        $this->_readonly = ['id'];
        $this->_create_autofill = [
            'createTime' => time()
        ];
        $this->_update_autofill = [
            'updateTime' => time()
        ];

        parent::__construct($serviceDB);
    }
}