DMemberBalanceDetail.Class.php 1.9 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * User: Gss
  5. * Date: 2021/3/26 0026
  6. * Time: 10:44
  7. */
  8. namespace JinDouYun\Dao\Customer;
  9. use JinDouYun\Dao\BaseDao;
  10. class DMemberBalanceDetail extends BaseDao
  11. {
  12. public function __construct($serviceDB = 'default')
  13. {
  14. $this->_table = 'qianniao_member_balance_detail_1';
  15. $this->_primary = 'id';
  16. $this->_fields = [
  17. 'id',//int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '会员余额明细表',
  18. 'customerId',//int(10) DEFAULT NULL COMMENT '客户id',
  19. 'userCenterId',//int(10) DEFAULT NULL COMMENT '账户id',
  20. 'type',//int(1) NOT NULL COMMENT '金额类型 5收入/4支出',
  21. 'purpose',//varchar(255) NOT NULL COMMENT '用途',
  22. 'beforeMoney',//decimal(15,4) NOT NULL COMMENT '变动之前余额',
  23. 'money',//decimal(15,4) NOT NULL COMMENT '变动金额',
  24. 'afterMoney',//decimal(15,4) NOT NULL COMMENT '变动之后金额',
  25. 'orderIds',// int(10) DEFAULT NULL COMMENT '订单id',
  26. 'accountId',// int(10) DEFAULT NULL COMMENT '账户id',
  27. 'accountNumber',// varchar(255) DEFAULT NULL COMMENT '账号',
  28. 'accountName',// varchar(255) DEFAULT NULL COMMENT '账号名称',
  29. 'remark',//text COMMENT '备注',
  30. 'createTime',//int(10) NOT NULL COMMENT '创建时间',
  31. 'updateTime',//int(10) DEFAULT NULL COMMENT '更新时间',
  32. 'extend',//json DEFAULT NULL COMMENT '扩展字段',
  33. 'explain',// varchar(255) 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. }