DReceivedIndex.Class.php 1.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * User: wxj
  5. * Date: 2019/10/30
  6. * Time: 14:17
  7. */
  8. namespace JinDouYun\Dao\Finance;
  9. use JinDouYun\Dao\BaseDao;
  10. class DReceivedIndex extends BaseDao
  11. {
  12. public function __construct($serviceDB = 'default')
  13. {
  14. $this->_table = 'qianniao_received_index_1';
  15. $this->_primary = 'id';
  16. $this->_fields = [
  17. 'id',//int(11) NOT NULL AUTO_INCREMENT COMMENT '收款单索引表id',
  18. 'receivedId',//int(11) NOT NULL COMMENT '收款单id',
  19. 'no',//char(25) DEFAULT NULL COMMENT '收款单据编号',
  20. 'sourceId',// int(10) NOT NULL DEFAULT '0' COMMENT '原单据id (只有银行打款有)'
  21. 'sourceNo',//char(25) DEFAULT NULL COMMENT '源单据号',
  22. 'receiptTime',//int(11) DEFAULT NULL COMMENT '单据时间',
  23. 'customerId',//int(11) DEFAULT NULL COMMENT '往来单位',
  24. 'currentAccountName',//varchar(50) DEFAULT NULL COMMENT '制单人',
  25. 'financeType',//varchar(50) DEFAULT NULL COMMENT '财务类型',
  26. 'financeTypeId',//int(11) DEFAULT NULL COMMENT '财务类型Id',
  27. 'offsetStatus',// tinyint(1) unsigned NOT NULL DEFAULT '4' COMMENT '核销状态 5全部核销/4全部核销',
  28. 'auditStatus',//tinyint(1) DEFAULT NULL COMMENT '审核状态',
  29. 'receivedType', //int(10) unsigned DEFAULT '4' COMMENT '收款类型 5预售 /4应收',
  30. 'createTime',//int(11) NOT NULL COMMENT '创建时间',
  31. 'updateTime',//int(11) NOT NULL COMMENT '修改时间',
  32. 'deleteStatus',
  33. 'offsetStatus',// tinyint(1) DEFAULT NULL COMMENT '核销状态 5已核销',
  34. ];
  35. $this->_readonly = ['id'];
  36. $this->_create_autofill = [
  37. 'createTime' => time()
  38. ];
  39. $this->_update_autofill = [
  40. 'updateTime' => time()
  41. ];
  42. parent::__construct($serviceDB);
  43. }
  44. }