CouponDetailController.php 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589
  1. <?php
  2. namespace app\admin\controller\coupon;
  3. use app\admin\service\coupon\CouponService;
  4. use app\admin\service\member\MemberService;
  5. use app\controller\Curd;
  6. use app\model\Coupon;
  7. use app\model\CouponDetail;
  8. use app\model\CouponGoods;
  9. use app\model\Member;
  10. use app\model\SysDept;
  11. use support\Request;
  12. use support\Response;
  13. class CouponDetailController extends Curd
  14. {
  15. public function __construct()
  16. {
  17. $this->model = new CouponDetail();
  18. }
  19. public function select(Request $request): Response
  20. {
  21. [$where, $format, $limit, $field, $order] = $this->selectInput($request);
  22. // if (empty($where['coupon_detail_status'])) {
  23. // $where['coupon_detail_status'] = ['<>', 'DISABLED'];
  24. // }
  25. // $where['join_coupon_detail_member_id'] = ['<>', ''];
  26. $order = $request->get('order', 'desc');
  27. $field = $field ?? 'coupon_detail_addtimes';
  28. $couponName = $request->get('coupon_name', '');
  29. if (!empty($couponName)) {
  30. $couponIds = Coupon::where('coupon_name', 'like', '%' . $couponName . '%')->pluck('coupon_id')->toArray();
  31. if (empty($couponIds)) {
  32. $couponIds = ['default'];
  33. }
  34. $where['join_detail_coupon_id'] = ['in', $couponIds];
  35. }
  36. $addTimes = $request->get('coupon_detail_addtimes', []);
  37. if (!empty($addTimes)) {
  38. $addTimes[0] = isset($addTimes[0]) ? strtotime($addTimes[0]) : time();
  39. $addTimes[1] = isset($addTimes[1]) ? strtotime($addTimes[1]) : time();
  40. $where['coupon_detail_addtimes'] = $addTimes;
  41. }
  42. $query = $this->doSelect($where, $field, $order, $request);
  43. return $this->doFormat($query, $format, $limit);
  44. }
  45. protected function doSelect(array $where, string $field = null, string $order = 'desc')
  46. {
  47. $request = \request();
  48. $model = $this->model->with([
  49. 'detail' => function ($query) {
  50. $query->select('join_detail_coupon_id', 'coupon_detail_status', 'coupon_detail_gain_datetime', 'coupon_detail_used_datetime', 'coupon_detail_remark');
  51. },
  52. 'coupon',
  53. 'member' => function ($query) {
  54. $query->select('member_id', 'member_mobile');
  55. },
  56. 'cert' => function ($query) {
  57. $query->select('join_cert_member_id', 'member_cert_name');
  58. },
  59. 'info' => function ($query) {
  60. $query->select('join_info_member_id', 'member_info_nickname');
  61. }
  62. ]);
  63. if (!empty($request->get('coupon_classify'))) {
  64. $model = $model->leftJoin('coupon', 'coupon.coupon_id', '=', 'coupon_detail.join_detail_coupon_id')
  65. ->select('coupon.coupon_classify', 'coupon_detail.*')
  66. ->where('coupon_classify', $request->get('coupon_classify'));
  67. }
  68. if (!empty($request->get('get_type'))) {
  69. $model = $model->whereJsonContains("coupon_detail_extend_json->gettype", $request->get('get_type'));
  70. }
  71. foreach ($where as $column => $value) {
  72. if (is_array($value)) {
  73. if ($value[0] === 'like' || $value[0] === 'not like') {
  74. $model = $model->where($column, $value[0], "%$value[1]%");
  75. } elseif (in_array($value[0], ['>', '=', '<', '<>'])) {
  76. $model = $model->where($column, $value[0], $value[1]);
  77. } elseif ($value[0] == 'in' && !empty($value[1])) {
  78. $valArr = $value[1];
  79. if (is_string($value[1])) {
  80. $valArr = explode(",", trim($value[1]));
  81. }
  82. $model = $model->whereIn($column, $valArr);
  83. } elseif ($value[0] == 'not in' && !empty($value[1])) {
  84. $valArr = $value[1];
  85. if (is_string($value[1])) {
  86. $valArr = explode(",", trim($value[1]));
  87. }
  88. $model = $model->whereNotIn($column, $valArr);
  89. } elseif ($value[0] == 'null') {
  90. $model = $model->whereNull($column);
  91. } elseif ($value[0] == 'not null') {
  92. $model = $model->whereNotNull($column);
  93. } elseif ($value[0] !== '' || $value[1] !== '') {
  94. $model = $model->whereBetween($column, $value);
  95. }
  96. } else {
  97. $model = $model->where($column, $value);
  98. }
  99. }
  100. // $model = $model->selectRaw('join_detail_coupon_id,join_coupon_detail_member_id,MAX(coupon_detail_addtimes) as coupon_detail_addtimes,COUNT(*) as total');
  101. // $model = $model->groupBy('join_coupon_detail_member_id', 'join_detail_coupon_id');
  102. if ($field) {
  103. $model = $model->orderBy($field, $order);
  104. }
  105. $model = $model->orderBy('coupon_detail_gain_datetime', 'ASC');
  106. return $model;
  107. }
  108. public function afterQuery($items)
  109. {
  110. foreach ($items as &$item) {
  111. $mobile = $certName = $nickname = '';
  112. if (!empty($item['member']) && !empty($item['member']['member_mobile'])) {
  113. $mobile = $item['member']['member_mobile'];
  114. }
  115. if (!empty($item['cert']) && !empty($item['cert']['member_cert_name'])) {
  116. $certName = $item['cert']['member_cert_name'];
  117. }
  118. if (!empty($item['info']) && !empty($item['info']['member_info_nickname'])) {
  119. $nickname = $item['info']['member_info_nickname'];
  120. }
  121. $item['member_name'] = MemberService::getMemberName($mobile, $certName, $nickname);
  122. $item['member_used'] = 0;
  123. foreach ($item['detail'] as $detail) {
  124. if ($detail['coupon_detail_status'] == 'USED') {
  125. $item['member_used'] += 1;
  126. }
  127. }
  128. unset($item['detail']);
  129. if (!empty($item['coupon_detail_extend_json'])) {
  130. $couponDetailExtendJson = json_decode($item['coupon_detail_extend_json'], true);
  131. if (isset($couponDetailExtendJson['gettype'])) {
  132. $item['gettype'] = $couponDetailExtendJson['gettype'];
  133. }
  134. }
  135. if (!empty($item['coupon_detail_deadline_datetime'])) {
  136. $item['coupon_detail_deadline_datetime'] = date('Y/m/d H:i:s', strtotime($item['coupon_detail_deadline_datetime']));
  137. }
  138. if (!empty($item['coupon_detail_gain_datetime'])) {
  139. $item['coupon_detail_gain_datetime'] = date('Y/m/d H:i:s', strtotime($item['coupon_detail_gain_datetime']));
  140. }
  141. }
  142. return $items;
  143. }
  144. /**
  145. * @Desc 优惠券详情顶部统计
  146. * @Author Gorden
  147. * @Date 2024/11/1 11:33
  148. *
  149. * @param Request $request
  150. * @return Response
  151. */
  152. public function statistics(Request $request)
  153. {
  154. $params = $request->get();
  155. $couponDetailModel = CouponDetail::leftJoin('coupon', 'coupon.coupon_id', '=', 'coupon_detail.join_detail_coupon_id')
  156. ->when(!empty($params['coupon_classify']), function ($query) use ($params) {
  157. $query->where('coupon.coupon_classify', $params['coupon_classify']);
  158. })->when(!empty($params['coupon_detail_status']), function ($query) use ($params) {
  159. $query->where('coupon_detail_status', $params['coupon_detail_status']);
  160. })->when(!empty($params['get_type']), function ($query) use ($params) {
  161. if ($params['get_type'] == 'SEND') {
  162. $query->where(function ($query2) {
  163. $query2->whereJsonContains('coupon_detail_extend_json->gettype', 'SEND')
  164. ->orWhereJsonContains('coupon_detail_extend_json->gettype', 'SYSTEN');
  165. });
  166. } else {
  167. $query->whereJsonContains('coupon_detail_extend_json->gettype', $params['get_type']);
  168. }
  169. })->when(!empty($params['coupon_name']), function ($query) use ($params) {
  170. $query->where('coupon_name', 'like', '%' . trim($params['coupon_name']) . '%');
  171. })->when(!empty($params['join_coupon_detail_member_id']), function ($query) use ($params) {
  172. $query->where('join_coupon_detail_member_id', $params['join_coupon_detail_member_id']);
  173. })->when(!empty($params['coupon_detail_addtimes']), function ($query) use ($params) {
  174. $params['coupon_detail_addtimes'][0] = strtotime($params['coupon_detail_addtimes'][0]);
  175. $params['coupon_detail_addtimes'][1] = strtotime($params['coupon_detail_addtimes'][1]);
  176. $query->whereBetween('coupon_detail_addtimes', $params['coupon_detail_addtimes']);
  177. });
  178. $totalModel = clone $couponDetailModel;
  179. $total = $totalModel->count('coupon_detail_id');
  180. $unUsedTotalModel = clone $couponDetailModel;
  181. $unUsedTotal = $unUsedTotalModel->whereIn('coupon_detail_status', ['ACTIVED'])->count('coupon_detail_id');
  182. $waitingTotalModel = clone $couponDetailModel;
  183. $waitingTotal = $waitingTotalModel->whereIn('coupon_detail_status', ['WAITING'])->count('coupon_detail_id');
  184. $usedTotalModel = clone $couponDetailModel;
  185. $usedTotal = $usedTotalModel->whereIn('coupon_detail_status', ['USED'])->count('coupon_detail_id');
  186. $disabledTotalModel = clone $couponDetailModel;
  187. $disabledTotal = $disabledTotalModel->whereIn('coupon_detail_status', ['DISABLED'])->count('coupon_detail_id');
  188. $expiredTotalModel = clone $couponDetailModel;
  189. $expiredTotal = $expiredTotalModel->whereIn('coupon_detail_status', ['EXPIRED'])->count('coupon_detail_id');
  190. $pendingTotalModel = clone $couponDetailModel;
  191. $pendingTotal = $pendingTotalModel->whereIn('coupon_detail_status', ['INIT', 'PENDING'])->count('coupon_detail_id');
  192. return json_success('success', [
  193. 'total' => $total,
  194. 'usedTotal' => $usedTotal,
  195. 'unUsedTotal' => $unUsedTotal,
  196. 'disabledTotal' => $disabledTotal,
  197. 'expiredTotal' => $expiredTotal,
  198. 'waitingTotal' => $waitingTotal,
  199. 'pendingTotal' => $pendingTotal
  200. ]);
  201. }
  202. /**
  203. * @Desc 修改状态
  204. * @Author Gorden
  205. * @Date 2024/8/22 8:44
  206. *
  207. * @param Request $request
  208. * @return Response
  209. */
  210. public function updateStatus(Request $request)
  211. {
  212. $detailId = $request->post('coupon_detail_id', '');
  213. $status = $request->post('status', '');
  214. $detail = CouponDetail::where('coupon_detail_id', $detailId)->first();
  215. if (!$detail) {
  216. return json_fail('数据不存在');
  217. }
  218. //状态 INIT|PENDING=等待领取|ACTIVED=可用|WAITING=已占用(待完成)|USED=已使用|DISABLED|CANCEL|EXPIRED
  219. if (!in_array($status, ['INIT', 'PENDING', 'ACTIVED', 'WAITING', 'USED', 'DISABLED', 'CANCEL', 'EXPIRED'])) {
  220. return json_fail("状态异常");
  221. }
  222. try {
  223. CouponDetail::where('coupon_detail_id', $detailId)->update(['coupon_detail_status' => $status]);
  224. return json_success('success');
  225. } catch (\Exception $e) {
  226. dump($e->getMessage());
  227. return json_fail('数据修改失败');
  228. }
  229. }
  230. /**
  231. * @Desc 详情
  232. * @Author Gorden
  233. * @Date 2024/8/22 11:46
  234. *
  235. * @param Request $request
  236. * @return Response
  237. */
  238. public function info(Request $request): Response
  239. {
  240. $detailId = $request->get('detail_id', '');
  241. if (empty($detailId)) {
  242. return json_fail('参数异常');
  243. }
  244. $detail = CouponDetail::where('coupon_detail_id', $detailId)
  245. ->select('coupon_detail_id', 'coupon_detail_extend_json', 'join_coupon_detail_member_id')
  246. ->first();
  247. if (!empty($detail->coupon_detail_extend_json)) {
  248. $couponDetailExtendJson = json_decode($detail->coupon_detail_extend_json, true);
  249. if (isset($couponDetailExtendJson['from'])) {
  250. $detail['from'] = MemberService::getMemberNameByMemberId($couponDetailExtendJson['from']);
  251. }
  252. }
  253. $member = Member::with([
  254. 'info' => function ($query) {
  255. $query->select('join_info_member_id', 'member_info_headimg');
  256. },
  257. 'role' => function ($query) {
  258. $query->select('member_role_id', 'member_role_name');
  259. }
  260. ])->where('member_id', $detail->join_coupon_detail_member_id)
  261. ->select('member_id', 'join_member_role_id', 'member_is_owner', 'member_is_vip', 'member_is_partner', 'member_is_referrer')
  262. ->first();
  263. $member->info->member_info_headimg = MemberService::getAvatarUrl(!empty($member->info) && !empty($member->info->member_info_headimg) ? $member->info->member_info_headimg : '');
  264. $detail->member = $member;
  265. return json_success('', $detail);
  266. }
  267. public function myCouponGrouping(Request $request)
  268. {
  269. $memberId = $request->get('member_id', '');
  270. $goods = $request->get('goods', []);
  271. $settlementNow = $request->get('settlement_now', 'N');
  272. if ($memberId == '') {
  273. return json_fail("参数异常");
  274. }
  275. $goodsIds = array_column($goods, 'goods_id');
  276. $couponGoods = CouponGoods::whereIn('join_coupon_goods_id', $goodsIds)->get()->toArray();
  277. $couponIds = [];
  278. foreach ($couponGoods as $couponGood) {
  279. foreach ($goods as $good) {
  280. if ($good['sku_id'] = $couponGood['join_coupon_goods_sku_id']) {
  281. $couponIds[] = $couponGood['join_goods_coupon_id'];
  282. }
  283. }
  284. }
  285. $details = CouponDetail::with([
  286. 'coupon' => function ($query) {
  287. $query->select('coupon_id', 'coupon_name', 'coupon_classify', 'coupon_value', 'coupon_category', 'coupon_minimum_limit');
  288. }
  289. ])->whereIn('join_detail_coupon_id', $couponIds)
  290. ->where('join_coupon_detail_member_id', $memberId)
  291. ->where('coupon_detail_gain_datetime', '<', date('Y-m-d H:i:s'))
  292. ->where('coupon_detail_deadline_datetime', '>', date('Y-m-d H:i:s'));
  293. if ($settlementNow == 'Y') {
  294. $details = $details->whereIn('coupon_detail.coupon_detail_status', ['ACTIVED', 'WAITING']);
  295. } else {
  296. $details = $details->where('coupon_detail.coupon_detail_status', 'ACTIVED');
  297. }
  298. $details = $details->selectRaw('join_detail_coupon_id,join_coupon_detail_member_id,COUNT(*) as count')
  299. ->groupBy('join_detail_coupon_id', 'join_coupon_detail_member_id')
  300. ->get()
  301. ->toArray();
  302. $data = [];
  303. foreach ($details as $detail) {
  304. if (empty($detail['coupon'])) {
  305. continue;
  306. }
  307. $classify = CouponService::couponClassifyInfo($detail['coupon']['coupon_classify'], $detail['coupon']['coupon_category'], $detail['coupon']['coupon_value'], $detail['coupon']['coupon_minimum_limit']);
  308. $data[] = [
  309. 'coupon_id' => $detail['coupon']['coupon_id'],
  310. 'coupon_name' => $detail['coupon']['coupon_name'],
  311. 'classify' => $classify,
  312. 'count' => $detail['count'],
  313. 'coupon_classify' => $detail['coupon']['coupon_classify'],
  314. 'coupon_value' => $detail['coupon']['coupon_value'] ?? '',
  315. 'coupon_minimum_limit' => $detail['coupon']['coupon_minimum_limit'] ?? '',
  316. ];
  317. }
  318. return json_success('', $data);
  319. }
  320. /**
  321. * @Desc 推广的优惠券
  322. * @Author Gorden
  323. * @Date 2024/11/5 13:39
  324. *
  325. * @param Request $request
  326. * @return Response
  327. */
  328. public function promotionCoupon(Request $request)
  329. {
  330. $goods = $request->get('goods', []);
  331. $goodsIds = array_column($goods, 'goods_id');
  332. $goods = array_column($goods, null, 'goods_id');
  333. $coupons = Coupon::where('coupon_category', 'PROMOTION')
  334. ->where('coupon_status', 'ACTIVED')
  335. ->select('coupon_id')
  336. ->get()
  337. ->toArray();
  338. $data = [];
  339. foreach ($coupons as $coupon) {
  340. $couponGoods = CouponGoods::whereIn('join_coupon_goods_id', $goodsIds)
  341. ->where('join_goods_coupon_id', $coupon['coupon_id'])
  342. ->select('join_goods_coupon_id', 'join_coupon_goods_id')
  343. ->get()
  344. ->toArray();
  345. $money = 0;
  346. $moneyGoodsIds = [];
  347. foreach ($couponGoods as $couponGood) {
  348. if (isset($goods[$couponGood['join_coupon_goods_id']]) && !in_array($couponGood['join_coupon_goods_id'], $moneyGoodsIds)) {
  349. $good = $goods[$couponGood['join_coupon_goods_id']];
  350. $money = $money + ($good['price'] * $good['nbr']);
  351. $moneyGoodsIds[] = $couponGood['join_coupon_goods_id'];
  352. }
  353. }
  354. if ($money <= 0) {
  355. continue;
  356. }
  357. $promotionCoupon = Coupon::where('coupon_id', $coupon['coupon_id'])
  358. ->where(function ($query) use ($money) {
  359. $query->where('coupon_minimum_limit', 0)
  360. ->orWhere('coupon_minimum_limit', '<=', $money);
  361. })->select('coupon_id', 'coupon_name', 'coupon_minimum_limit', 'coupon_classify', 'coupon_value', 'coupon_category', 'coupon_priority')
  362. ->first();
  363. if (empty($promotionCoupon)) {
  364. continue;
  365. }
  366. $promotionCoupon = $promotionCoupon->toArray();
  367. $classify = CouponService::couponClassifyInfo($promotionCoupon['coupon_classify'], $promotionCoupon['coupon_category'], $promotionCoupon['coupon_value'], $promotionCoupon['coupon_minimum_limit']);
  368. $data[] = [
  369. 'coupon_id' => $promotionCoupon['coupon_id'],
  370. 'coupon_name' => $promotionCoupon['coupon_name'],
  371. 'classify' => $classify,
  372. 'count' => 1,
  373. 'coupon_classify' => $promotionCoupon['coupon_classify'],
  374. 'coupon_value' => $promotionCoupon['coupon_value'] ?? '',
  375. 'coupon_minimum_limit' => $promotionCoupon['coupon_minimum_limit'] ?? '',
  376. 'priority' => $promotionCoupon['coupon_priority']
  377. ];
  378. }
  379. return json_success('', $data);
  380. }
  381. /**
  382. * @Desc 导出优惠券明细
  383. * @Author Gorden
  384. * @Date 2024/11/1 9:19
  385. *
  386. * @param Request $request
  387. * @return Response
  388. */
  389. public function export(Request $request)
  390. {
  391. $couponName = $request->get('coupon_name', '');
  392. $couponClassify = $request->get('coupon_classify');
  393. $getType = $request->get('get_type');
  394. $couponDetailStatus = $request->get('coupon_detail_status');
  395. $memberId = $request->get('join_coupon_detail_member_id');
  396. $couponDetailAddtimes = $request->get('coupon_detail_addtimes');
  397. $couponDetailIds = $request->get('coupon_detail_ids', []);
  398. $model = CouponDetail::with([
  399. 'member' => function ($query) {
  400. $query->select('member_id', 'member_mobile', 'join_invite_member_id', 'member_extend_json');
  401. },
  402. 'cert' => function ($query) {
  403. $query->select('join_cert_member_id', 'member_cert_name');
  404. },
  405. 'info' => function ($query) {
  406. $query->select('join_info_member_id', 'member_info_business', 'member_info_service');
  407. }
  408. ])->leftJoin('coupon', 'coupon.coupon_id', '=', 'coupon_detail.join_detail_coupon_id')
  409. ->select('coupon_detail.*', 'coupon.coupon_id', 'coupon.coupon_name', 'coupon.coupon_json', 'coupon.coupon_classify');
  410. if ($couponClassify) {
  411. $model = $model->where('coupon.coupon_classify', $couponClassify);
  412. }
  413. if (!empty($getType)) {
  414. $model = $model->whereJsonContains("coupon_detail_extend_json->gettype", $getType);
  415. }
  416. if (!empty($couponDetailStatus)) {
  417. $model = $model->where('coupon_detail_status', $couponDetailStatus);
  418. } else {
  419. $model = $model->where('coupon_detail_status', '<>', 'DISABLED');
  420. }
  421. if (!empty($memberId)) {
  422. $model = $model->where('join_coupon_detail_member_id', $memberId);
  423. }
  424. if (!empty($couponDetailAddtimes)) {
  425. $couponDetailAddtimes[0] = strtotime($couponDetailAddtimes[0]);
  426. $couponDetailAddtimes[1] = strtotime($couponDetailAddtimes[1]);
  427. $model = $model->whereBetween('coupon_detail_addtimes', $couponDetailAddtimes);
  428. }
  429. if (!empty($couponDetailIds)) {
  430. $model = $model->whereIn('coupon_detail_id', $couponDetailIds);
  431. }
  432. if (!empty($couponName)) {
  433. $couponIds = Coupon::where('coupon_name', 'like', '%' . $couponName . '%')->pluck('coupon_id')->toArray();
  434. $model = $model->whereIn('join_detail_coupon_id', $couponIds);
  435. }
  436. $details = $model->orderBy('coupon_detail_addtimes', 'DESC')
  437. ->orderBy('coupon_detail_gain_datetime', 'ASC')
  438. ->get()
  439. ->toArray();
  440. // 查出所有门店
  441. $depts = SysDept::where('dept_category', '营业场所')->pluck('dept_name', 'dept_id')->toArray();
  442. $data = [];
  443. foreach ($details as $detail) {
  444. $mobile = !empty($detail['member']) ? $detail['member']['member_mobile'] : '';
  445. $certName = !empty($detail['cert']) ? $detail['cert']['member_cert_name'] : '';
  446. $business = !empty($detail['info']) ? $detail['info']['member_info_business'] : '';
  447. $service = !empty($detail['info']) ? $detail['info']['member_info_service'] : '';
  448. // 推荐人
  449. if (!empty($detail['member']) && !empty($detail['member']['join_invite_member_id'])) {
  450. $referrer = Member::with([
  451. 'cert' => function ($query) {
  452. $query->select('join_cert_member_id', 'member_cert_name');
  453. }
  454. ])->where('member_id', $detail['member']['join_invite_member_id'])
  455. ->select('member_id', 'member_mobile')
  456. ->first();
  457. $referrerMobile = !empty($referrer->member_mobile) ? $referrer->member_mobile : '';
  458. $referrerCertName = !empty($referrer->cert) ? $referrer->cert->member_cert_name : '';
  459. $detail['referrer_name'] = MemberService::getMemberCertName($referrerMobile, $referrerCertName, '');
  460. }
  461. // 顾问
  462. if (!empty($detail['member']) && !empty($detail['member']['member_extend_json'])) {
  463. $memberExtendJson = json_decode($detail['member']['member_extend_json'], true);
  464. if (!empty($memberExtendJson['referee'])) {
  465. $consultant = [];
  466. foreach ($memberExtendJson['referee'] as $item) {
  467. $consultant[] = $item;
  468. }
  469. $detail['consultant'] = implode(',', $consultant);
  470. }
  471. }
  472. // 门店
  473. if (!empty($detail['coupon_json'])) {
  474. $couponJson = json_decode($detail['coupon_json'], true);
  475. if (!isset($couponJson['premises'])) {
  476. $detail['premises'] = "所有门店";
  477. } else {
  478. $deptName = [];
  479. foreach ($couponJson['premises'] as $premisesId) {
  480. if (isset($depts[$premisesId]) && !in_array($depts[$premisesId], $deptName)) {
  481. $deptName[] = $depts[$premisesId];
  482. }
  483. }
  484. $detail['premises'] = implode(',', $deptName);
  485. }
  486. }
  487. // 获得方式
  488. if (!empty($detail['coupon_detail_extend_json'])) {
  489. $couponDetailExtendsJson = json_decode($detail['coupon_detail_extend_json'], true);
  490. if (isset($couponDetailExtendsJson['gettype'])) {
  491. $detail['get_type'] = self::$getType[$couponDetailExtendsJson['gettype']] ?? '';
  492. }
  493. }
  494. // 有效期限
  495. $detail['coupon_detail_gain_datetime'] = !empty($detail['coupon_detail_gain_datetime']) ? date('Y/m/d H:i:s', strtotime($detail['coupon_detail_gain_datetime'])) : '';
  496. $detail['coupon_detail_deadline_datetime'] = !empty($detail['coupon_detail_deadline_datetime']) ? date('Y/m/d H:i:s', strtotime($detail['coupon_detail_deadline_datetime'])) : '';
  497. $data[] = [
  498. 'cert_name' => $certName,
  499. 'mobile' => $mobile,
  500. // 'member_name' => MemberService::getMemberCertName($mobile, $certName, ''),
  501. 'referrer_name' => $detail['referrer_name'] ?? '',
  502. 'coupon_name' => $detail['coupon_name'] ?? '',
  503. 'coupon_classify' => $detail['coupon_classify'] ?? '',
  504. 'premises' => $detail['premises'] ?? '',
  505. 'get_type' => $detail['get_type'] ?? '',
  506. 'status' => self::$detailStatus[$detail['coupon_detail_status']] ?? '',
  507. 'coupon_detail_used_datetime' => $detail['coupon_detail_used_datetime'] ?? '',
  508. 'valid_date' => !empty($detail['coupon_detail_gain_datetime']) ? $detail['coupon_detail_gain_datetime'] . ' - ' . $detail['coupon_detail_deadline_datetime'] : '',
  509. 'coupon_detail_addtimes' => $detail['coupon_detail_addtimes'],
  510. 'consultant' => $detail['consultant'] ?? '',
  511. 'business' => $business,
  512. 'service' => $service
  513. ];
  514. }
  515. return json_success('success', $data);
  516. }
  517. /**
  518. * @var string[]
  519. */
  520. public static $getType = [
  521. 'VIP' => '购买VIP',
  522. 'RECEIVE' => '领取',
  523. 'SEND' => '后台发放',
  524. 'GIVE' => '转增',
  525. 'EXCHANGE' => '兑换',
  526. 'COMBINE' => '新客专享',
  527. 'ROLE' => '会员升级',
  528. 'PARTNER' => '会员合伙人',
  529. 'REFERRER' => '康养推荐官',
  530. 'PACKAGE' => '购买套包',
  531. 'SYSTEM' => '后台发放'
  532. ];
  533. /**
  534. * @var string[]
  535. */
  536. public static $detailStatus = [
  537. 'INIT' => '初始状态',
  538. 'PENDING' => '待领取',
  539. 'ACTIVED' => '可用',
  540. 'WAITING' => '待完成',
  541. 'USED' => '已使用',
  542. 'DISABLED' => '禁用',
  543. 'CANCEL' => '取消',
  544. 'EXPIRED' => '过期',
  545. ];
  546. }