MemberCardServices.php 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | CRMEB [ CRMEB赋能开发者,助力企业发展 ]
  4. // +----------------------------------------------------------------------
  5. // | Copyright (c) 2016~2026 https://www.crmeb.com All rights reserved.
  6. // +----------------------------------------------------------------------
  7. // | Licensed CRMEB并不是自由软件,未经许可不能去掉CRMEB相关版权
  8. // +----------------------------------------------------------------------
  9. // | Author: CRMEB Team <admin@crmeb.com>
  10. // +----------------------------------------------------------------------
  11. namespace app\services\user\member;
  12. use app\dao\user\MemberCardDao;
  13. use app\services\BaseServices;
  14. use app\services\order\OtherOrderServices;
  15. use app\services\order\StoreOrderCreateServices;
  16. use app\services\user\UserServices;
  17. use crmeb\exceptions\AdminException;
  18. use crmeb\exceptions\ApiException;
  19. use crmeb\services\SystemConfigService;
  20. class MemberCardServices extends BaseServices
  21. {
  22. /**
  23. * @var MemberCardDao
  24. */
  25. protected $dao;
  26. /** 初始化,获得dao层句柄
  27. * MemberCardServices constructor.
  28. * @param MemberCardDao $memberCardDao
  29. */
  30. public static $_memberTypePrefix = ['month', 'quarter', 'year', 'ever', 'free', 'owner'];
  31. public function __construct(MemberCardDao $memberCardDao)
  32. {
  33. $this->dao = $memberCardDao;
  34. }
  35. public function getSearchList(array $where = [])
  36. {
  37. /** @var UserServices $userService */
  38. $userService = app()->make(UserServices::class);
  39. [$page, $limit] = $this->getPageValue();
  40. $where['batch_card_id'] = $where['card_batch_id'];
  41. if ($where['is_use'] != "") {
  42. if ($where['is_use'] == 0) {
  43. $where['use_time'] = 0;
  44. } else {
  45. $where['use_time'] = 1;
  46. }
  47. }
  48. unset($where['is_use']);
  49. $list = $this->dao->getSearchList($where, $page, $limit);
  50. $userIds = array_column($list->toArray(), 'use_uid');
  51. $userList = $userService->getColumn([['uid', 'in', $userIds]], 'nickname,phone,real_name', 'uid');
  52. foreach ($list as $k => $v) {
  53. if ($v['use_uid']) {
  54. $list[$k]['username'] = $userList[$v['use_uid']]['real_name'] ?: $userList[$v['use_uid']]['nickname'];
  55. $list[$k]['phone'] = $userList[$v['use_uid']] ? $userList[$v['use_uid']]['phone'] : "";
  56. }
  57. $list[$k]['add_time'] = date('Y-m-d H:i:s', $v['add_time']);
  58. $list[$k]['use_time'] = $v['use_time'] != 0 ? date('Y-m-d H:i:s', $v['use_time']) : "未使用";
  59. }
  60. $count = $this->dao->count($where);
  61. return compact('list', 'count');
  62. }
  63. /** 生成免费会员卡
  64. * @param array $data
  65. */
  66. public function addCard(array $data)
  67. {
  68. if (!isset($data['card_batch_id']) || !$data['card_batch_id'] || $data['card_batch_id'] == 0 || !isset($data['total_num']) || !$data['total_num'] || $data['total_num'] == 0) {
  69. throw new AdminException('参数错误');
  70. }
  71. try {
  72. if (!isset($data['total_num'])) throw new AdminException('参数错误');
  73. $num = $data['total_num'];
  74. unset($data['total_num']);
  75. $res = [];
  76. for ($i = 0; $i < $num; $i++) {
  77. $data['card_number'] = $this->makeRandomNumber("CR", $data['card_batch_id']);
  78. $data['card_password'] = $this->makeRandomNumber();
  79. $data['status'] = 1;
  80. $data['add_time'] = time();
  81. $res[] = $data;
  82. }
  83. //数据切片批量插入,提高性能。
  84. $chunk_inster_card = array_chunk($res, 100, true);
  85. foreach ($chunk_inster_card as $v) {
  86. $this->dao->saveAll($v);
  87. }
  88. return true;
  89. } catch (\Exception $exception) {
  90. throw new AdminException('生成卡失败');
  91. }
  92. }
  93. /**获取制卡卡号随机数
  94. * @param bool $prefix
  95. * @param bool $random
  96. * @return string
  97. */
  98. public function makeRandomNumber($prefix = false, $random = false)
  99. {
  100. if (!$prefix) {
  101. $prefix = "";
  102. }
  103. if (!$random || !is_numeric($random)) {
  104. $one_random = mt_rand(11111, 99999);
  105. } else {
  106. $one_random = sprintf("%05d", $random);
  107. }
  108. $date_random = date('ymd', time());
  109. $random_tmp = strlen($one_random);
  110. $two_randow = str_pad(mt_rand(1, 99999), $random_tmp, '0', STR_PAD_LEFT);
  111. if (!$random) {
  112. return $two_randow;
  113. } else {
  114. return $prefix . $one_random . $date_random . $two_randow;
  115. }
  116. }
  117. /** 领取会员卡
  118. * @param array $data
  119. * @param int $uid
  120. */
  121. public function drawMemberCard(array $data, int $uid)
  122. {
  123. if (!$uid || !$data) throw new ApiException('参数错误');
  124. $isOpenMember = $this->isOpenMemberCard();
  125. if (!$isOpenMember) throw new ApiException('会员功能暂未开启');
  126. if (!isset($data['member_card_code']) || !$data['member_card_code']) throw new ApiException('请输入会员卡号');
  127. if (!isset($data['member_card_code']) || !$data['member_card_pwd']) throw new ApiException('请输入领取卡密');
  128. $card_info = $this->dao->getOneByWhere(['card_number' => trim($data['member_card_code'])]);
  129. if (!$card_info) throw new ApiException('会员卡不存在');
  130. /** @var MemberCardBatchServices $memberBatchServices */
  131. $memberBatchServices = app()->make(MemberCardBatchServices::class);
  132. $batch_info = $memberBatchServices->getOne($card_info['card_batch_id']);
  133. if (!$batch_info) throw new ApiException('会员卡未激活,暂无法使用');
  134. if ($batch_info->status != 1) throw new ApiException('会员卡未激活,暂无法使用');
  135. if ($card_info['status'] == 0) throw new ApiException('会员卡未激活,暂无法使用');
  136. if ($card_info['card_password'] != trim($data['member_card_pwd'])) throw new ApiException('会员卡密码有误');
  137. if ($card_info['use_uid'] && $card_info['use_time']) throw new ApiException('会员卡已使用');
  138. /** @var UserServices $userServices */
  139. $userServices = app()->make(UserServices::class);
  140. $user_info = $userServices->getUserInfo($uid);
  141. if (!$user_info) throw new ApiException('用户不存在');
  142. if ($user_info->is_money_level > 0 && $user_info->is_ever_level == 1) throw new ApiException('您已是永久会员,无需再领取,可以将此卡转送亲朋好友,一起享受优惠');
  143. /**
  144. * 批次卡具体使用期限,业务需要打开即可,勿删。
  145. */
  146. if ($card_info->status != 1) throw new ApiException('会员卡未激活,暂无法使用');
  147. $this->transaction(function () use ($card_info, $user_info, $batch_info, $memberBatchServices, $userServices, $data) {
  148. $res1 = $this->dao->update($card_info->id, ['use_uid' => $user_info->uid, 'use_time' => time(), 'update_time' => time()], 'id');
  149. if ($res1) {
  150. $res2 = $memberBatchServices->useCardSetInc($batch_info->id, 'use_num', 1);
  151. $overdue_time = 0;
  152. switch ($user_info->is_money_level) {
  153. case 1:
  154. case 2:
  155. case 3:
  156. $overdue_time = bcadd(bcmul($batch_info->use_day, 86400, 0), $user_info->overdue_time, 0);
  157. $overdue_time = mktime(date('H'), date('i'), date('s'), date('m', $overdue_time), date('d', $overdue_time), date('Y', $overdue_time));
  158. break;
  159. case 0:
  160. $overdue_time = bcadd(bcmul($batch_info->use_day, 86400, 0), time(), 0);
  161. break;
  162. }
  163. $channel_type = $data['from'];
  164. /** @var OtherOrderServices $OtherOrderServices */
  165. $OtherOrderServices = app()->make(OtherOrderServices::class);
  166. $storeOrderCreateService = app()->make(StoreOrderCreateServices::class);
  167. $record_data['uid'] = $user_info->uid;
  168. $record_data['member_code'] = $card_info->card_number;
  169. $record_data['use_day'] = $batch_info->use_day;
  170. $record_data['overdue_time'] = $overdue_time;
  171. $record_data['order_id'] = $storeOrderCreateService->getNewOrderId();
  172. $record_data['channel_type'] = $channel_type;
  173. $record_data['member_type'] = "free";
  174. $record_data['vip_day'] = $batch_info->use_day;
  175. $record_data['type'] = 2;
  176. $record_data['paid'] = 1;
  177. $record_data['pay_time'] = time();
  178. $res3 = $OtherOrderServices->addOtherOrderData($record_data);
  179. //if ($res3) $res4 = $userServices->update($user_info->uid, ['level' => 1, 'overdue_time' => $overdue_time, 'is_permanent' => 0], 'uid');
  180. /** @var UserServices $userServices */
  181. $userServices = app()->make(UserServices::class);
  182. $res4 = $userServices->setMemberOverdueTime($batch_info->use_day, $user_info->uid, 2, $record_data['member_type']);
  183. $res5 = $res1 && $res2 && $res3 && $res4;
  184. return $res5;
  185. }
  186. });
  187. }
  188. /** 验证是否存在此类型会员卡
  189. * @param string $member_type
  190. * @return bool
  191. */
  192. public function checkmemberType(string $member_type)
  193. {
  194. $member_type_arr = $this->getMemberTypeInfo();
  195. if (!array_key_exists($member_type, $member_type_arr)) throw new ApiException('暂无此类型会员卡');
  196. return true;
  197. }
  198. /** 获取会员权益和说明配置
  199. * @return array
  200. */
  201. public function getMemberRightsInfo()
  202. {
  203. /** @var MemberRightServices $memberRightService */
  204. $memberRightService = app()->make(MemberRightServices::class);
  205. $memberRight = $memberRightService->getSearchList(['status' => 1]);
  206. if ($memberRight['list']) {
  207. foreach ($memberRight['list'] as $k => &$v) {
  208. $v['title'] = $v['show_title'];
  209. $v['pic'] = $v['image'];
  210. $v['right'] = $v['explain'];
  211. if ($v['right_type'] == 'offline') $v['explain'] = '线下支付打' . floatval(bcdiv((string)$v['number'], '10', 1)) . '折';
  212. if ($v['right_type'] == 'sign') $v['explain'] = '签到多得' . (int)$v['number'] . '倍积分';
  213. if ($v['right_type'] == 'express') $v['explain'] = '运费打' . floatval(bcdiv((string)$v['number'], '10', 1)) . '折';
  214. if ($v['right_type'] == 'integral') $v['explain'] = '消费多返' . (int)$v['number'] . '倍积分';
  215. }
  216. }
  217. return ['member_right' => $memberRight['list']];
  218. }
  219. /**获取会员卡配置
  220. * @return array
  221. */
  222. public function getMemberTypeInfo()
  223. {
  224. /** @var SystemConfigService $systemConfigService */
  225. $systemConfigService = app()->make(SystemConfigService::class);
  226. $data = [];
  227. foreach (self::$_memberTypePrefix as $v) {
  228. $data[$v] = $systemConfigService::more([$v . '_title', $v . '_vip_day', $v . '_pre_price', $v . '_price']);
  229. }
  230. return $data;
  231. }
  232. /**会员卡数据处理
  233. * @return array
  234. */
  235. public function DoMemberType()
  236. {
  237. $data = array();
  238. /** @var MemberShipServices $memberShipService */
  239. $memberShipService = app()->make(MemberShipServices::class);
  240. $list = $memberShipService->getApiList(['is_del' => 0]);
  241. foreach ($list as $v) {
  242. $data[] = [
  243. 'mc_id' => $v['id'],
  244. 'title' => $v['title'],
  245. 'type' => $v['type'],
  246. 'vip_day' => $v['vip_day'],
  247. 'pre_price' => $v['pre_price'],
  248. 'price' => $v['price'],
  249. ];
  250. }
  251. return $data;
  252. }
  253. /**会员类型数据
  254. * @return bool
  255. */
  256. public function getMemberTypeValue()
  257. {
  258. $member_type = $this->DoMemberType();
  259. if (!$member_type) return false;
  260. $new_member_data = [];
  261. foreach ($member_type as $k => $v) {
  262. $new_member_data[$v['mc_id']] = $v;
  263. }
  264. return $new_member_data;
  265. }
  266. /**导出会员卡
  267. * @param $where
  268. * @return \think\Collection
  269. * @throws \think\db\exception\DataNotFoundException
  270. * @throws \think\db\exception\DbException
  271. * @throws \think\db\exception\ModelNotFoundException
  272. */
  273. public function getExportData($where)
  274. {
  275. $data = $this->dao->getSearchList($where);
  276. /** @var UserServices $userService */
  277. $userService = app()->make(UserServices::class);
  278. /** @var MemberCardBatchServices $batchService */
  279. $batchService = app()->make(MemberCardBatchServices::class);
  280. foreach ($data as $k => $v) {
  281. $data[$k]['use_time'] = $v['use_time'] != 0 ? date('Y-m-d H:i:s', $v['use_time']) : "";
  282. $data[$k]['user_name'] = '';
  283. $data[$k]['user_phone'] = '';
  284. if ($v['use_uid'] != 0) {
  285. $userInfo = $userService->get($v['use_uid']);
  286. $data[$k]['user_name'] = $userInfo['nickname'] ?: $userInfo['account'];
  287. $data[$k]['user_phone'] = $userInfo['phone'];
  288. }
  289. }
  290. $batchInfo = $batchService->getOne($where['batch_card_id']);
  291. $dataArray['title'] = $batchInfo ? $batchInfo['title'] : "";
  292. $dataArray['data'] = $data;
  293. return $dataArray;
  294. }
  295. /**获取会员记录
  296. * @param array $where
  297. * @return array
  298. */
  299. public function getSearchRecordList(array $where)
  300. {
  301. /** @var OtherOrderServices $otherOrderSevice */
  302. $otherOrderSevice = app()->make(OtherOrderServices::class);
  303. return $otherOrderSevice->getMemberRecord($where);
  304. }
  305. /**
  306. * 看是否开启会员功能
  307. * @param string $rightType
  308. * @param bool $get_number
  309. * @return bool|mixed
  310. * @throws \think\db\exception\DataNotFoundException
  311. * @throws \think\db\exception\DbException
  312. * @throws \think\db\exception\ModelNotFoundException
  313. */
  314. public function isOpenMemberCard(string $rightType = '', bool $get_number = true)
  315. {
  316. $isOpen = sys_config('member_card_status', 1);
  317. //如果传入权益类别,查看是否具有某权益
  318. if (!$rightType) {
  319. if ($isOpen) return true;
  320. return false;
  321. } else {
  322. /** @var MemberRightServices $memberRightService */
  323. $memberRightService = app()->make(MemberRightServices::class);
  324. $memberRight = $memberRightService->getOne(['right_type' => $rightType], 'status,number');
  325. if ($isOpen && $memberRight && $memberRight['status']) {
  326. if ($get_number) {
  327. $number = $memberRight['number'];
  328. if (!$number) return false;
  329. return $number;
  330. }
  331. return true;
  332. }
  333. return false;
  334. }
  335. }
  336. /**
  337. * 修改会员卡状态
  338. * @param $id
  339. * @param $status
  340. * @return bool
  341. */
  342. public function setStatus($id, $status)
  343. {
  344. $card_batch_id = $this->dao->value(['id' => $id], 'card_batch_id');
  345. $card_batch_status = app()->make(MemberCardBatchServices::class)->value(['id' => $card_batch_id], 'status');
  346. if ($card_batch_status == 0) {
  347. throw new AdminException('批次未激活,暂无法使用');
  348. }
  349. $res = $this->dao->update($id, ['status' => $status]);
  350. if ($res) return true;
  351. return false;
  352. }
  353. }