DRefund.Class.php 2.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * User: Gss
  5. * Date: 2021/4/8 0008
  6. * Time: 19:30
  7. */
  8. namespace JinDouYun\Dao\Finance;
  9. use JinDouYun\Dao\BaseDao;
  10. class DRefund extends BaseDao
  11. {
  12. public function __construct($serviceDB = 'finance')
  13. {
  14. $this->_table = 'qianniao_refund_1';
  15. $this->_primary = 'id';
  16. $this->_fields = [
  17. 'id',//int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  18. 'no',//char(25) NOT NULL COMMENT '单据编号',
  19. 'auditStatus',//tinyint(1) NOT NULL DEFAULT '1' COMMENT '审核状态',
  20. 'unitId',// int(10) DEFAULT NULL COMMENT '退款单位id',
  21. 'unitName',// varchar(50) DEFAULT NULL COMMENT '退款单位名称',
  22. 'type',// tinyint(1) NOT NULL COMMENT '退款单位类型 1客户/2供应商',
  23. 'sourceNo',//char(25) NOT NULL COMMENT '原单据编号',
  24. 'currentAccountName',//varchar(50) NOT NULL COMMENT '往来账户人',
  25. 'financeType',//varchar(50) NOT NULL COMMENT '财务类型名称',
  26. 'financeTypeId',//tinyint(2) NOT NULL COMMENT '财务类型id',
  27. 'payType',// char(10) DEFAULT NULL COMMENT '支付方式',
  28. 'shopId',//int(10) NOT NULL COMMENT '所属商铺',
  29. 'shopName',//varchar(255) DEFAULT NULL COMMENT '商铺名称',
  30. 'money',//decimal(15,4) DEFAULT '0.0000' COMMENT '退款金额',
  31. 'operatorId',//int(10) NOT NULL COMMENT '操作人员id',
  32. 'originId',// int(10) DEFAULT NULL COMMENT '源订单id',
  33. 'originNo',// varchar(50) DEFAULT NULL COMMENT '原订单no',
  34. 'refundTime',//int(10) DEFAULT NULL COMMENT '单据日期',
  35. 'createTime',//int(10) DEFAULT NULL COMMENT '创建时间',
  36. 'updateTime',//int(10) DEFAULT NULL COMMENT '更新时间',
  37. 'offsetId',// int(10) DEFAULT NULL COMMENT '需要核销的单据id',
  38. ];
  39. $this->_readonly = ['id'];
  40. $this->_create_autofill = [
  41. 'createTime' => time()
  42. ];
  43. $this->_update_autofill = [
  44. 'updateTime' => time()
  45. ];
  46. parent::__construct($serviceDB);
  47. }
  48. }