MemberRecord.php 6.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166
  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\user;
  12. use traits\ModelTrait;
  13. use basic\ModelBasic;
  14. use app\admin\model\user\MemberCard as MemberCardMode;
  15. use app\admin\model\user\MemberCardBatch;
  16. use app\admin\model\order\StoreOrder;
  17. /**
  18. * 会员设置 model
  19. * Class MemberRecord
  20. * @package app\admin\model\user
  21. */
  22. class MemberRecord extends ModelBasic
  23. {
  24. use ModelTrait;
  25. public static function getPurchaseRecordList($where)
  26. {
  27. $model = self::setWherePage(self::setWhere($where), $where, ['u.nickname', 'u.uid'], ['p.uid']);
  28. $model = $model->alias('p')->join('user u', 'p.uid=u.uid', 'left')->field('p.*,u.nickname');
  29. $list = $model->page((int)$where['page'], (int)$where['limit'])
  30. ->order('p.add_time DESC')
  31. ->select()
  32. ->each(function ($item) {
  33. $item['overdue_time'] = date('Y-m-d H:i:s', $item['overdue_time']);
  34. $item['add_time'] = date('Y-m-d H:i:s', $item['add_time']);
  35. if ($item['type'] == 1) {
  36. $item['price'] = '无';
  37. }
  38. if (!$item['type']) {
  39. switch ($item['validity']) {
  40. case 30:
  41. $item['title'] = '月卡';
  42. break;
  43. case 90:
  44. $item['title'] = '季卡';
  45. break;
  46. case 365:
  47. $item['title'] = '年卡';
  48. break;
  49. case -1:
  50. $item['title'] = '终身卡';
  51. break;
  52. default:
  53. $item['title'] = '免费';
  54. }
  55. } else {
  56. $item['title'] = '卡密';
  57. }
  58. if (!$item['code']) {
  59. $item['code'] = '无';
  60. }
  61. if ($item['nickname']) {
  62. $item['uid'] = $item['nickname'] . '/' . $item['uid'];
  63. } else {
  64. $item['uid'] = '暂无昵称/' . $item['uid'];
  65. }
  66. if ($item['oid']) {
  67. $order = StoreOrder::where('id', $item['oid'])->where('type', 1)->field('pay_type')->find();
  68. if ($order['pay_type'] == 'yue') {
  69. $item['source'] = '赠送';
  70. } else {
  71. $item['source'] = '购买';
  72. }
  73. } else {
  74. $item['source'] = '会员卡';
  75. }
  76. })->toArray();
  77. $count = self::setWherePage(self::setWhere($where), $where, ['u.nickname', 'u.uid'], ['p.uid'])->alias('p')->join('user u', 'p.uid=u.uid', 'left')->count();
  78. return ['count' => $count, 'data' => $list];
  79. }
  80. /**
  81. * 设置搜索条件
  82. *
  83. */
  84. public static function setWhere($where)
  85. {
  86. $model = new self;
  87. if ($where['title'] != '') {
  88. $model = $model->where('p.uid|u.nickname', 'like', "%$where[title]%");
  89. }
  90. if ($where['type'] != '') {
  91. switch ($where['type']) {
  92. case 1:
  93. $model = $model->where('p.validity', 30)->where('p.type', 0);
  94. break;
  95. case 2:
  96. $model = $model->where('p.validity', 90)->where('p.type', 0);
  97. break;
  98. case 3:
  99. $model = $model->where('p.validity', 365)->where('p.type', 0);
  100. break;
  101. case 4:
  102. $model = $model->where('p.validity', '<', 0)->where('p.type', 0);
  103. break;
  104. case 5:
  105. $model = $model->where('p.type', 1);
  106. break;
  107. case 6:
  108. $model = $model->where('p.type', 0)->where('p.is_free', 1);
  109. break;
  110. }
  111. }
  112. return $model;
  113. }
  114. public static function setMerWhere($uid)
  115. {
  116. $model = new self;
  117. $model = $model->where('uid', $uid);
  118. return $model;
  119. }
  120. public static function userOneRecord($uid = 0)
  121. {
  122. $model = self::setMerWhere($uid)->order('id desc');
  123. $data = $model->select();
  124. foreach ($data as $key => $item) {
  125. $item['overdue_time'] = date('Y-m-d H:i:s', $item['overdue_time']);
  126. $item['add_time'] = date('Y-m-d H:i:s', $item['add_time']);
  127. if ($item['type'] == 1) {
  128. $item['price'] = '无';
  129. }
  130. if (!$item['type']) {
  131. switch ($item['validity']) {
  132. case 30:
  133. $item['title'] = '月卡';
  134. break;
  135. case 90:
  136. $item['title'] = '季卡';
  137. break;
  138. case 365:
  139. $item['title'] = '年卡';
  140. break;
  141. case -1:
  142. $item['title'] = '终身卡';
  143. break;
  144. default:
  145. $item['title'] = '免费';
  146. }
  147. } else {
  148. $item['title'] = '卡密';
  149. }
  150. if (!$item['code']) {
  151. $item['code'] = '无';
  152. }
  153. }
  154. $count = self::setMerWhere($uid)->count();
  155. return ['count' => $count, 'data' => $data];
  156. }
  157. }