您最多选择25个主题 主题必须以字母或数字开头,可以包含连字符 (-),并且长度不得超过35个字符

MemberCardServices.php 17KB

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