DReceiptRequisition.Class.php 1.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * User: Gss
  5. * Date: 2021/3/6 0006
  6. * Time: 14:44
  7. */
  8. namespace JinDouYun\Dao\Finance;
  9. use JinDouYun\Dao\BaseDao;
  10. class DReceiptRequisition extends BaseDao
  11. {
  12. public function __construct($serviceDB = 'default')
  13. {
  14. $this->_table = 'qianniao_receipt_requisition_1';
  15. $this->_primary = 'id';
  16. $this->_fields = [
  17. 'id',//int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
  18. 'no',// varchar(255) DEFAULT NULL COMMENT 'no编号',
  19. 'customerId',//int(10) unsigned NOT NULL COMMENT '客户id',
  20. 'customerName',//char(50) NOT NULL COMMENT '客户名称',
  21. 'receivable',//decimal(15,4) NOT NULL COMMENT '当前应收',
  22. 'totalCollectionAmount',// decimal(15,4) DEFAULT NULL COMMENT '总收金额',
  23. 'totalPreferentialAmount',// decimal(15,4) DEFAULT NULL COMMENT '总优惠金额',
  24. 'totalActualAmount',// decimal(15,4) DEFAULT NULL COMMENT '总实际金额',
  25. 'operatorId',//int(10) NOT NULL COMMENT '收款人id',
  26. 'operatorName',//char(50) NOT NULL COMMENT '收款人名称',
  27. 'shopId',// int(10) DEFAULT NULL COMMENT '店铺id',
  28. 'shopName',// char(50) DEFAULT NULL COMMENT '店铺名称',
  29. 'auditStatus',// int(10) unsigned DEFAULT '1' COMMENT '审核状态',
  30. 'deleteStatus',// int(10) unsigned NOT NULL DEFAULT '5' COMMENT '删除状态',
  31. 'createTime',//int(10) DEFAULT NULL COMMENT '创建时间',
  32. 'updateTime',//int(10) DEFAULT NULL COMMENT '更新时间',
  33. 'extend',//json DEFAULT NULL COMMENT '扩展字段',
  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. }