<?php
/**
 * Created by PhpStorm.
 * User: wxj
 * Date: 2019/10/30
 * Time: 14:17
 */

namespace JinDouYun\Dao\Finance;

use JinDouYun\Dao\BaseDao;

class DReceivedIndex extends BaseDao
{
    public function __construct($serviceDB = 'default')
    {
        $this->_table = 'qianniao_received_index_1';
        $this->_primary = 'id';
        $this->_fields = [
            'id',//int(11) NOT NULL AUTO_INCREMENT COMMENT '收款单索引表id',
            'receivedId',//int(11) NOT NULL COMMENT '收款单id',
            'no',//char(25) DEFAULT NULL COMMENT '收款单据编号',
            'sourceId',// int(10) NOT NULL DEFAULT '0' COMMENT '原单据id （只有银行打款有）'
            'sourceNo',//char(25) DEFAULT NULL COMMENT '源单据号',
            'receiptTime',//int(11) DEFAULT NULL COMMENT '单据时间',
            'customerId',//int(11) DEFAULT NULL COMMENT '往来单位',
            'currentAccountName',//varchar(50) DEFAULT NULL COMMENT '制单人',
            'financeType',//varchar(50) DEFAULT NULL COMMENT '财务类型',
            'financeTypeId',//int(11) DEFAULT NULL COMMENT '财务类型Id',
            'offsetStatus',// tinyint(1) unsigned NOT NULL DEFAULT '4' COMMENT '核销状态 5全部核销/4全部核销',
            'auditStatus',//tinyint(1) DEFAULT NULL COMMENT '审核状态',
            'receivedType', //int(10) unsigned DEFAULT '4' COMMENT '收款类型 5预售 /4应收',
            'createTime',//int(11) NOT NULL COMMENT '创建时间',
            'updateTime',//int(11) NOT NULL COMMENT '修改时间',
            'deleteStatus',
            'offsetStatus',// tinyint(1) DEFAULT NULL COMMENT '核销状态  5已核销',
        ];
        $this->_readonly = ['id'];
        $this->_create_autofill = [
            'createTime' => time()
        ];
        $this->_update_autofill = [
            'updateTime' => time()
        ];

        parent::__construct($serviceDB);
    }
}