DrawRecord.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310
  1. <?php
  2. namespace app\admin\controller\lottery;
  3. use app\common\controller\Backend;
  4. use app\common\Enum\StatusEnum;
  5. use app\common\Enum\LotteryEnum;
  6. /**
  7. * 抽奖记录管理
  8. *
  9. * @icon fa fa-list
  10. */
  11. class DrawRecord extends Backend
  12. {
  13. /**
  14. * DrawRecord模型对象
  15. * @var \app\admin\model\lottery\DrawRecord
  16. */
  17. protected $model = null;
  18. protected $relationSearch = true;
  19. public function _initialize()
  20. {
  21. parent::_initialize();
  22. $this->model = new \app\admin\model\lottery\DrawRecord;
  23. // 获取枚举值列表
  24. $this->view->assign([
  25. "triggerTypeList" => $this->model->getTriggerTypeList(),
  26. "statusList" => StatusEnum::getMap(),
  27. "isWinList" => LotteryEnum::getIsWinMap(),
  28. "deliverStatusList" => LotteryEnum::getDeliverStatusMap(),
  29. ]);
  30. $this->assignconfig("triggerTypeList", json_encode($this->model->getTriggerTypeList()));
  31. $this->assignconfig("statusList", json_encode(StatusEnum::getMap()));
  32. $this->assignconfig("isWinList", json_encode(LotteryEnum::getIsWinMap()));
  33. $this->assignconfig("deliverStatusList", json_encode(LotteryEnum::getDeliverStatusMap()));
  34. // 参与状态
  35. $this->assignconfig("drawStatusList", json_encode(LotteryEnum::getDrawStatusMap()));
  36. // 奖品类型配置
  37. $this->view->assign("prizeTypeList", LotteryEnum::getPrizeTypeMap());
  38. $this->assignconfig("prizeTypeList", json_encode(LotteryEnum::getPrizeTypeMap()));
  39. $this->assignconfig("prizeTypeList", json_encode(LotteryEnum::getPrizeTypeMap()));
  40. // 发放状态
  41. $this->view->assign("deliverStatusList", LotteryEnum::getDeliverStatusMap());
  42. $this->assignconfig("deliverStatusList", json_encode(LotteryEnum::getDeliverStatusMap()));
  43. // 抽奖类型
  44. $this->view->assign("lotteryTypeList", LotteryEnum::getLotteryTypeMap());
  45. $this->assignconfig("lotteryTypeList", json_encode(LotteryEnum::getLotteryTypeMap()));
  46. // 抽奖方式
  47. $this->view->assign("lotteryTypeList", LotteryEnum::getLotteryTypeMap());
  48. $this->assignconfig("lotteryTypeList", json_encode(LotteryEnum::getLotteryTypeMap()));
  49. }
  50. /**
  51. * 查看
  52. */
  53. public function index()
  54. {
  55. //当前是否为关联查询
  56. $this->relationSearch = true;
  57. //设置过滤方法
  58. $this->request->filter(['strip_tags', 'trim']);
  59. if ($this->request->isAjax()) {
  60. //如果发送的来源是Selectpage,则转发到Selectpage
  61. if ($this->request->request('keyField')) {
  62. return $this->selectpage();
  63. }
  64. list($where, $sort, $order, $offset, $limit) = $this->buildparams();
  65. $list = $this->model
  66. ->with(['activity', 'user', 'prize'])
  67. ->where($where)
  68. ->order($sort, $order)
  69. ->paginate($limit);
  70. // where in 查询 中奖记录
  71. $drawRecordIds = $list->column('id');
  72. $winRecord = new \app\admin\model\lottery\WinRecord;
  73. $objWinRecord = $winRecord->where('draw_record_id', 'in', $drawRecordIds)
  74. ->select();
  75. $winRecordList = collection($objWinRecord)->toArray();
  76. $winRecordMap = [];
  77. foreach ($winRecordList as $item) {
  78. $winRecordMap[$item['draw_record_id']] = $item;
  79. }
  80. $list->each(function($row) use ($winRecordMap) {
  81. $row->win_record_id = 0;
  82. $row->deliver_status = 0;
  83. $row->deliver_time = 0;
  84. if (isset($winRecordMap[$row->id])) {
  85. $row->win_record_id = $winRecordMap[$row->id]['id'] ?? 0;
  86. $row->deliver_status = $winRecordMap[$row->id]['deliver_status'] ?? 0;
  87. $row->deliver_time = $winRecordMap[$row->id]['deliver_time'] ?? 0;
  88. }
  89. });
  90. foreach ($list as $row) {
  91. $row->visible([
  92. 'id', 'activity_id', 'user_id', 'prize_id', 'is_win',
  93. 'trigger_type', 'trigger_order_id', 'trigger_amount',
  94. 'draw_ip', 'draw_time', 'device_info', 'status', 'createtime','win_record_id','deliver_status','deliver_time'
  95. ]);
  96. $row->visible(['activity', 'user', 'prize', 'winRecord']);
  97. // 处理关联数据
  98. if ($row->getRelation('activity')) {
  99. $row->getRelation('activity')->visible(['id', 'name', 'type','lottery_type','lottery_time']);
  100. }
  101. if ($row->getRelation('user')) {
  102. $row->getRelation('user')->visible(['id', 'username', 'mobile','avatar']);
  103. }
  104. if ($row->getRelation('prize')) {
  105. $row->getRelation('prize')->visible(['id', 'name', 'type', 'image']);
  106. }
  107. $row->win_record_id = 0;
  108. $row->deliver_status = 0;
  109. $row->deliver_time = 0;
  110. if (isset($winRecordMap[$row->id])) {
  111. $row->win_record_id = $winRecordMap[$row->id]['id'] ?? 0;
  112. $row->deliver_status = $winRecordMap[$row->id]['deliver_status'] ?? 0;
  113. $row->deliver_time = $winRecordMap[$row->id]['deliver_time'] ?? 0;
  114. }
  115. }
  116. $result = array("total" => $list->total(), "rows" => $list->items());
  117. return json($result);
  118. }
  119. return $this->view->fetch();
  120. }
  121. /**
  122. * 详情
  123. */
  124. public function detail($ids = null)
  125. {
  126. $row = $this->model->with(['activity', 'user', 'prize', 'winRecord'])->find($ids);
  127. if (!$row) {
  128. $this->error(__('No Results were found'));
  129. }
  130. // 解析win_info JSON数据
  131. if ($row->win_info) {
  132. $row->win_info_data = json_decode($row->win_info, true);
  133. }
  134. // 解析设备信息
  135. if ($row->device_info) {
  136. $row->device_info_data = json_decode($row->device_info, true);
  137. }
  138. $this->view->assign("row", $row);
  139. return $this->view->fetch();
  140. }
  141. /**
  142. * 统计数据
  143. */
  144. public function statistics()
  145. {
  146. $stats = [];
  147. // 总抽奖次数
  148. $stats['total_draws'] = $this->model->count();
  149. // 中奖次数
  150. $stats['total_wins'] = $this->model->where('is_win', 1)->count();
  151. // 中奖率
  152. $stats['win_rate'] = $stats['total_draws'] > 0 ?
  153. round($stats['total_wins'] / $stats['total_draws'] * 100, 2) : 0;
  154. // 按触发类型统计
  155. $stats['by_trigger_type'] = $this->model
  156. ->field('trigger_type, COUNT(*) as count')
  157. ->group('trigger_type')
  158. ->select()
  159. ->toArray();
  160. // 按奖品类型统计中奖情况
  161. $stats['by_prize_type'] = $this->model
  162. ->alias('dr')
  163. ->join('shop_lottery_prize p', 'dr.prize_id = p.id')
  164. ->field('p.type, COUNT(*) as total_count, SUM(dr.is_win) as win_count')
  165. ->group('p.type')
  166. ->select()
  167. ->toArray();
  168. // 最近7天抽奖趋势
  169. $stats['recent_trend'] = [];
  170. for ($i = 6; $i >= 0; $i--) {
  171. $date = date('Y-m-d', strtotime("-{$i} days"));
  172. $start_time = strtotime($date);
  173. $end_time = strtotime($date . ' 23:59:59');
  174. $daily_draws = $this->model
  175. ->where('draw_time', 'between', [$start_time, $end_time])
  176. ->count();
  177. $daily_wins = $this->model
  178. ->where('draw_time', 'between', [$start_time, $end_time])
  179. ->where('is_win', 1)
  180. ->count();
  181. $stats['recent_trend'][] = [
  182. 'date' => $date,
  183. 'draws' => $daily_draws,
  184. 'wins' => $daily_wins,
  185. 'rate' => $daily_draws > 0 ? round($daily_wins / $daily_draws * 100, 2) : 0
  186. ];
  187. }
  188. return json(['code' => 1, 'data' => $stats]);
  189. }
  190. /**
  191. * 导出记录
  192. */
  193. public function export()
  194. {
  195. // 获取导出参数
  196. $filter = $this->request->get('filter', '');
  197. $where = [];
  198. if ($filter) {
  199. $where = json_decode($filter, true);
  200. }
  201. $list = $this->model->with(['activity', 'user', 'prize', 'winRecord'])
  202. ->where($where)
  203. ->order('createtime', 'desc')
  204. ->select();
  205. $header = [
  206. 'ID', '活动名称', '用户昵称', '用户手机', '奖品名称', '奖品类型',
  207. '是否中奖', '触发类型', '触发金额', '抽奖IP', '抽奖时间',
  208. '发放状态', '收货人', '快递单号', '创建时间'
  209. ];
  210. $data = [];
  211. foreach ($list as $item) {
  212. $data[] = [
  213. $item->id,
  214. $item->activity->name ?? '',
  215. $item->user->nickname ?? '',
  216. $item->user->mobile ?? '',
  217. $item->prize->name ?? '',
  218. $item->prize->type_text ?? '',
  219. $item->is_win ? '是' : '否',
  220. $item->trigger_type_text,
  221. $item->trigger_amount ?? '',
  222. $item->draw_ip ?? '',
  223. date('Y-m-d H:i:s', $item->draw_time),
  224. $item->winRecord->deliver_status_text ?? '',
  225. $item->winRecord->receiver_name ?? '',
  226. $item->winRecord->express_number ?? '',
  227. date('Y-m-d H:i:s', $item->createtime)
  228. ];
  229. }
  230. // 这里可以集成Excel导出功能
  231. $this->success('导出成功', '', ['header' => $header, 'data' => $data]);
  232. }
  233. /**
  234. * 批量处理中奖发放
  235. */
  236. public function batchDeliver()
  237. {
  238. $ids = $this->request->post('ids');
  239. if (!$ids) {
  240. $this->error('请选择要处理的记录');
  241. }
  242. $count = 0;
  243. foreach ($ids as $id) {
  244. $record = $this->model->with('winRecord')->get($id);
  245. if ($record && $record->is_win && $record->winRecord) {
  246. // 这里可以调用具体的发放逻辑
  247. $count++;
  248. }
  249. }
  250. $this->success("成功处理 {$count} 条记录");
  251. }
  252. /**
  253. * 发货
  254. */
  255. public function deliver($ids = null)
  256. {
  257. $winRecordId = $this->request->param('win_record_id');
  258. $winRecord = \app\admin\model\lottery\WinRecord::get($winRecordId);
  259. if (!$winRecord) {
  260. $this->error('未找到中奖记录');
  261. }
  262. if ($this->request->isPost()) {
  263. $params = $this->request->post('row/a');
  264. if (!$params['express_company'] || !$params['express_number']) {
  265. $this->error('快递公司和快递单号不能为空');
  266. }
  267. $winRecord->express_company = $params['express_company'];
  268. $winRecord->express_number = $params['express_number'];
  269. $winRecord->deliver_status = LotteryEnum::DELIVER_STATUS_SUCCESS; // 假设1为已发货
  270. $winRecord->deliver_time = time();
  271. $winRecord->save();
  272. $this->success('发货成功');
  273. }
  274. $this->view->assign('row', $winRecord);
  275. return $this->view->fetch();
  276. }
  277. }