MerchantBill.php 4.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | CRMEB [ CRMEB赋能开发者,助力企业发展 ]
  4. // +----------------------------------------------------------------------
  5. // | Copyright (c) 2016~2022 https://www.crmeb.com All rights reserved.
  6. // +----------------------------------------------------------------------
  7. // | Licensed CRMEB并不是自由软件,未经许可不能去掉CRMEB相关版权
  8. // +----------------------------------------------------------------------
  9. // | Author: CRMEB Team <admin@crmeb.com>
  10. // +----------------------------------------------------------------------
  11. namespace app\admin\model\merchant;
  12. use service\SystemConfigService;
  13. use traits\ModelTrait;
  14. use basic\ModelBasic;
  15. use service\PhpSpreadsheetService;
  16. use app\admin\model\merchant\Merchant;
  17. /**
  18. * 讲师金额明细 model
  19. * Class UserBill
  20. * @package app\admin\model\merchant
  21. */
  22. class MerchantBill extends ModelBasic
  23. {
  24. use ModelTrait;
  25. protected $insert = ['add_time'];
  26. protected function setAddTimeAttr()
  27. {
  28. return time();
  29. }
  30. public static function income($title, $link_id, $mer_id, $category, $type, $number, $balance, $mark = '')
  31. {
  32. $pm = 1;
  33. return self::set(compact('title', 'link_id', 'mer_id', 'category', 'type', 'number', 'balance', 'mark', 'pm'));
  34. }
  35. public static function expend($title, $link_id, $mer_id, $category, $type, $number, $balance, $mark = '')
  36. {
  37. $pm = 0;
  38. return self::set(compact('title', 'link_id', 'mer_id', 'category', 'type', 'number', 'balance', 'mark', 'pm'));
  39. }
  40. public static function setWhere($where)
  41. {
  42. $model = new self();
  43. $model = $model->alias('b');
  44. if (isset($where['mer_id']) && $where['mer_id']) $model = $model->where('b.mer_id', $where['mer_id']);
  45. if ($where['start_time'] && $where['end_time']) $model = $model->where('b.add_time', 'between', [strtotime($where['start_time']), strtotime($where['end_time'])]);
  46. if ($where['category'] && $where['category'] != '') $model = $model->where('b.category', $where['category']);
  47. if ($where['category'] == 'now_money') {
  48. $model = $model->where('b.type', 'in', ['extract', 'user_refund', 'user_pay', 'gold_extract']);
  49. } else {
  50. $model = $model->where('b.type', 'in', ['extract', 'gold_turn_balance']);
  51. }
  52. $model = $model->join('merchant m', 'b.mer_id=m.id')->field('b.*,m.real_name');
  53. return $model;
  54. }
  55. /*
  56. * 获取佣金记录
  57. * */
  58. public static function getBillList($where)
  59. {
  60. $model = self::setWhere($where)->order('b.add_time desc');
  61. $list = $model->page((int)$where['page'], (int)$where['limit'])->select();
  62. $data = count($list) ? $list->toArray() : [];
  63. foreach ($data as &$item) {
  64. $item['add_time'] = date('Y-m-d H:i:s', $item['add_time']);
  65. $item['_type'] = $item['pm'] ? '收入' : '支出';
  66. $item['category'] = self::get_category($item['category']);
  67. }
  68. $count = self::setWhere($where)->count();
  69. return compact('data', 'count');
  70. }
  71. public static function get_category($category)
  72. {
  73. $gold_name = SystemConfigService::get("gold_name");
  74. switch ($category) {
  75. case 'now_money':
  76. $title = '余额';
  77. break;
  78. case 'gold_num':
  79. $title = $gold_name;
  80. break;
  81. }
  82. return $title;
  83. }
  84. /**流水导出
  85. * @param $where
  86. */
  87. public static function SaveExport($where)
  88. {
  89. $gold_name = SystemConfigService::get("gold_name");
  90. $data = ($data = self::setWhere($where)->select()) && count($data) ? $data->toArray() : [];
  91. $export = [];
  92. foreach ($data as $value) {
  93. $export[] = [
  94. $value['mer_id'],
  95. $value['pm'] ? '收入' : '支出',
  96. $value['title'],
  97. $value['number'],
  98. date('Y-m-d H:i:s', $value['add_time']),
  99. $value['mark'],
  100. ];
  101. }
  102. if ($where['category'] == 'now_money') {
  103. $filename = '讲师资金流水' . time() . '.xlsx';
  104. } else {
  105. $filename = '讲师' . $gold_name . '流水' . time() . '.xlsx';
  106. }
  107. $head = ['讲师ID', '类型', '标题', '金额', '创建时间', '备注'];
  108. PhpSpreadsheetService::outdata($filename, $export, $head);
  109. }
  110. }