MemberService.php 34 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | LARAVEL8.0 框架 [ LARAVEL ][ RXThinkCMF ]
  4. // +----------------------------------------------------------------------
  5. // | 版权所有 2017~2021 LARAVEL研发中心
  6. // +----------------------------------------------------------------------
  7. // | 官方网站: http://www.laravel.cn
  8. // +----------------------------------------------------------------------
  9. // | Author: laravel开发员 <laravel.qq.com>
  10. // +----------------------------------------------------------------------
  11. namespace App\Services\Common;
  12. use App\Helpers\Jwt;
  13. use App\Models\AccountModel;
  14. use App\Models\ActionLogModel;
  15. use App\Models\MemberModel;
  16. use App\Models\ShopModel;
  17. use App\Services\BaseService;
  18. use App\Services\ConfigService;
  19. use App\Services\RedisService;
  20. use Illuminate\Support\Facades\DB;
  21. use phpQrcode\QRcode;
  22. /**
  23. * 会员管理-服务类
  24. * @author laravel开发员
  25. * @since 2020/11/11
  26. * Class MemberService
  27. * @package App\Services\Common
  28. */
  29. class MemberService extends BaseService
  30. {
  31. protected static $instance = null;
  32. /**
  33. * 构造函数
  34. * @author laravel开发员
  35. * @since 2020/11/11
  36. * MemberService constructor.
  37. */
  38. public function __construct()
  39. {
  40. $this->model = new MemberModel();
  41. }
  42. /**
  43. * 静态入口
  44. * @return static|null
  45. */
  46. public static function make()
  47. {
  48. if (!self::$instance) {
  49. self::$instance = (new static());
  50. }
  51. return self::$instance;
  52. }
  53. /**
  54. * 获取资料详情
  55. * @param $where
  56. * @param array $field
  57. */
  58. public function getInfo($where, array $field = [])
  59. {
  60. $field = $field ? $field : ['id', 'username', 'realname','mobile', 'nickname','is_trade','login_shop_id','code','parent_id', 'openid','score_rate', 'idcard', 'idcard_check', 'idcard_front_img', 'idcard_back_img', 'member_level', 'bonus','bonus_total','score', 'status', 'avatar'];
  61. if (is_array($where)) {
  62. $info = $this->model->where($where)->select($field)->first();
  63. } else {
  64. $info = $this->model->where(['id' => (int)$where])->select($field)->first();
  65. }
  66. $info = $info ? $info->toArray() : [];
  67. if ($info) {
  68. $info['version'] = env('VERSION','v1.1.20');
  69. $info['avatar'] = $info['avatar'] ? get_image_url($info['avatar']) : '';
  70. $info['bonus'] = round($info['bonus'],0);
  71. $info['mobile_text'] = $info['mobile'];
  72. $info['mobile'] = $info['mobile']? format_mobile($info['mobile']):'';
  73. $info['show_bonus'] = GoodsService::make()->checkNewGoods($info['id']);
  74. // 积分
  75. $scoreRate = isset($info['score_rate'])? $info['score_rate'] : 1;
  76. $scoreRate = $scoreRate>0 && $scoreRate<=1? $scoreRate : 1;
  77. $info['real_score'] = intval($scoreRate * $info['score']);
  78. // 二维码
  79. $inviteUrl = env('WEB_URL').'h5/#/pages/register/index?code='.$info['code'];
  80. $qrcode = $this->makeQrcode($inviteUrl);
  81. $info['qrcode'] = $qrcode? get_image_url($qrcode):'';
  82. $info['invite_url'] = $inviteUrl;
  83. $info['shop_info'] = [];
  84. if(isset($info['login_shop_id']) && $info['login_shop_id']){
  85. $shopInfo = ShopService::make()->getInfo($info['login_shop_id']);
  86. $snapTime = ConfigService::make()->getConfigByCode('snap_time');
  87. $snapTime = $snapTime? $snapTime : 5;
  88. $curTime = strtotime(date('H:i:s'));
  89. $startTime = isset($shopInfo['start_time'])&&$shopInfo['start_time']? strtotime($shopInfo['start_time']) : 0;
  90. $endTime = isset($shopInfo['end_time'])&&$shopInfo['end_time']? strtotime($shopInfo['end_time']) : 0;
  91. $timeLock = $startTime - $curTime>0? $startTime - $curTime : 0;
  92. $shopInfo['timeData'] = [
  93. 'hours'=> 0,
  94. 'minutes'=> 0,
  95. 'seconds'=> 0,
  96. ];
  97. $shopInfo['snap_time'] = $snapTime;
  98. $shopInfo['time_lock'] = 0;
  99. $shopInfo['trade_status'] = 2;
  100. // if($timeLock ){
  101. if($timeLock && $timeLock<= $snapTime*60){
  102. $shopInfo['time_lock'] = $timeLock;
  103. $shopInfo['timeData']['hours'] = intval($timeLock/3600);
  104. $shopInfo['timeData']['minutes'] = intval($timeLock%3600/60);
  105. $shopInfo['timeData']['seconds'] = intval($timeLock%3600%60);
  106. $shopInfo['trade_status'] = 1;
  107. }else if($endTime>=$curTime && $curTime>=$startTime){
  108. $shopInfo['trade_status'] = 1;
  109. }
  110. $info['shop_info'] = $shopInfo;
  111. }
  112. $info['parent_info'] = [];
  113. if(isset($info['parent_id']) && $info['parent_id']){
  114. $info['parent_info'] = $this->model->where(['id'=>$info['parent_id'],'mark'=>1])
  115. ->select(['id','nickname','username','code'])
  116. ->first();
  117. }
  118. $type = request()->post('type', 0);
  119. if($type == 3){
  120. // 银行卡信息
  121. $info['bank_info'] = MemberBankService::make()->getBindInfo($info['id']);
  122. }
  123. if($type == 1){
  124. // 交易订单统计
  125. $info['orderCounts'] = TradeService::make()->getNewTradeCountByStatus($info['id'],[1,2,3]);
  126. // 积分订单统计
  127. $info['scoreOrderCount'] = OrderService::make()->getNewTradeCount($info['id'],[1,2,3,4,5]);
  128. }
  129. }
  130. return $info;
  131. }
  132. /**
  133. * 分销中心信息
  134. * @param $where
  135. * @param array $field
  136. * @return array
  137. */
  138. public function getMarketInfo($where, array $field = [])
  139. {
  140. $field = $field ? $field : ['id', 'username', 'realname','mobile', 'nickname','is_trade','login_shop_id','code','parent_id', 'openid','score_rate','merits_count','merits_total', 'idcard', 'idcard_check', 'idcard_front_img', 'idcard_back_img', 'member_level', 'bonus','bonus_total','score', 'status', 'avatar'];
  141. if (is_array($where)) {
  142. $info = $this->model->where($where)->select($field)->first();
  143. } else {
  144. $info = $this->model->where(['id' => (int)$where])->select($field)->first();
  145. }
  146. $info = $info ? $info->toArray() : [];
  147. if ($info) {
  148. $info['avatar'] = $info['avatar'] ? get_image_url($info['avatar']) : '';
  149. $info['bonus'] = round($info['bonus'],0);
  150. $info['bonus_total'] = round($info['bonus_total'],0);
  151. $info['mobile'] = $info['mobile']? format_mobile($info['mobile']):'';
  152. $info['show_bonus'] = GoodsService::make()->checkNewGoods($info['id']);
  153. if($info['show_bonus']<=0){
  154. $info['bonus_total']= max(0,$info['bonus_total']-$info['bonus']);
  155. }
  156. $info['shop_info'] = [];
  157. if(isset($info['login_shop_id']) && $info['login_shop_id']) {
  158. $shopInfo = ShopService::make()->getInfo($info['login_shop_id']);
  159. $info['shop_info'] = $shopInfo;
  160. }
  161. if(isset($info['parent_id']) && $info['parent_id']) {
  162. $parentInfo = MemberModel::where(['id'=> $info['parent_id']])->select(['id','nickname','mobile','code'])->first();
  163. $info['parent_info'] = $parentInfo;
  164. $info['parent_mobile'] = isset($parentInfo['mobile'])? format_mobile($parentInfo['mobile']) : '';
  165. }
  166. // 团队人数
  167. $info['team_num'] = MemberService::make()->getInviteNums($info['id']);
  168. // // 本人业绩
  169. // $info['merits_count'] = TradeService::make()->getUserTradeTotal($info['id'],[3,4]);
  170. //
  171. // // 总业绩
  172. // $info['merits_total'] = TradeService::make()->getTeamTradeTotal($info['id'],[3,4]);
  173. }
  174. return $info;
  175. }
  176. /**
  177. * 用户登录
  178. * @param $params
  179. * @return array|false
  180. */
  181. public function login($params)
  182. {
  183. $mobile = isset($params['mobile']) ? $params['mobile'] : '';
  184. $password = isset($params['password']) ? $params['password'] : '';
  185. $shopCode = isset($params['shop_code']) ? $params['shop_code'] : '';
  186. if (empty($mobile) || empty($password)) {
  187. $this->error = 2009;
  188. return false;
  189. }
  190. if(empty($shopCode)){
  191. $this->error = 2010;
  192. return false;
  193. }
  194. // 验证店铺
  195. $shopInfo = ShopModel::where(['code'=> $shopCode,'status'=>1,'mark'=>1])->first();
  196. $shopId = isset($shopInfo['id'])? $shopInfo['id'] : 0;
  197. $shopUserId = isset($shopInfo['user_id'])? $shopInfo['user_id'] : 0;
  198. if(!$shopId){
  199. $this->error = 2011;
  200. return false;
  201. }
  202. // 用户验证
  203. $info = $this->model->where(['mobile'=>$mobile,'mark'=>1])
  204. ->select(['id','username','nickname','mobile','password','code','parent_id','login_count','login_shop_id','status'])
  205. ->first();
  206. if (!$info) {
  207. $this->error = 2001;
  208. return false;
  209. }
  210. $userId = isset($info['id'])? $info['id'] : 0;
  211. $loginShopId = isset($info['login_shop_id'])? $info['login_shop_id'] : 0;
  212. if(($shopUserId != $userId) && $loginShopId>0 && ($loginShopId != $shopId)){
  213. $this->error = 2022;
  214. return false;
  215. }
  216. // 密码校验
  217. $password = get_password($password);
  218. if ($password != $info['password']) {
  219. $this->error = 2002;
  220. return false;
  221. }
  222. // 使用状态校验
  223. if ($info['status'] != 1) {
  224. $this->error = 2012;
  225. return false;
  226. }
  227. // 设置日志标题
  228. ActionLogModel::setTitle("会员登录");
  229. ActionLogModel::record($info);
  230. // JWT生成token
  231. $jwt = new Jwt('jwt_app');
  232. $token = $jwt->getToken($info['id']);
  233. RedisService::set("stores:auths:info:{$info['id']}", $info, 5, 10);
  234. // 登录
  235. $updateData = ['login_time' => time(),'login_shop_id'=> $shopId,'login_count'=>$info['login_count']+1, 'login_ip' => get_client_ip()];
  236. $this->model->where(['id' => $info['id']])->update($updateData);
  237. // 登录数据
  238. return [
  239. 'token' => $token,
  240. 'user_id' => $info['id'],
  241. 'shop_id' => $shopId,
  242. ];
  243. }
  244. /**
  245. * 用户注册
  246. * @param $params
  247. * @return bool
  248. */
  249. public function register($params)
  250. {
  251. // 检测账号是否存在
  252. if ($this->checkExists('mobile', $params['mobile'])) {
  253. $this->error = '2005';
  254. return false;
  255. }
  256. $mobile = isset($params['mobile']) ? trim($params['mobile']) : '';
  257. $nickname = isset($params['nickname']) ? trim($params['nickname']) : '';
  258. $password = isset($params['password']) ? trim($params['password']) : '';
  259. $safePassword = isset($params['safe_password']) ? trim($params['safe_password']) : '';
  260. $inviteCode = isset($params['invite_code']) ? trim($params['invite_code']) : '';
  261. $inviteInfo = $this->model->where(['code'=> $inviteCode,'mark'=>1])->select(['id','code','username','parents'])->first();
  262. if(empty($inviteInfo)){
  263. $this->error = '2013';
  264. return false;
  265. }
  266. $parentId = isset($inviteInfo['id'])? $inviteInfo['id'] : 0;
  267. $parents = isset($inviteInfo['parents'])? $inviteInfo['parents'] : '';
  268. $parents = $parents? rtrim($parents,',').",{$parentId}," : "{$parentId},";
  269. $data = [
  270. 'nickname' => $nickname? $nickname : '用户_u'.get_random_code(6),
  271. 'username' => strtoupper('U'.get_random_code(7)),
  272. 'password' => get_password($password),
  273. 'safe_password' => get_password($safePassword),
  274. 'mobile' => $mobile,
  275. 'parents' => $parents,
  276. 'parent_id' => $parentId,
  277. 'status' => 1,
  278. 'mark' => 1,
  279. 'merits_time' => date('Y-m-d H:i:s'),
  280. 'create_time' => time(),
  281. ];
  282. if ($id = $this->model->edit($data)) {
  283. $this->model->where(['id'=> $id])->update(['code'=> strtoupper('Q'.get_random_code(8))]);
  284. $this->error = 2008;
  285. return true;
  286. }
  287. $this->error = 2007;
  288. return false;
  289. }
  290. /**
  291. * 修改保存用户资料
  292. * @param $userId
  293. * @param $params
  294. * @return mixed
  295. */
  296. public function saveInfo($userId, $params)
  297. {
  298. $data = [
  299. 'nickname' => isset($params['nickname'])? trim($params['nickname']) : '',
  300. 'update_time' => time(),
  301. ];
  302. return $this->model->where(['id'=> $userId])->update($data);
  303. }
  304. /**
  305. * 列表
  306. * @param $params
  307. * @param int $pageSize
  308. * @return array
  309. */
  310. public function getDataList($params, $pageSize = 15)
  311. {
  312. $where = ['a.mark' => 1];
  313. $status = isset($params['status'])? $params['status'] : 0;
  314. $parentId = isset($params['parent_id'])? $params['parent_id'] : 0;
  315. $time = isset($params['time'])&&$params['time']? $params['time'] : 0; // 默认今日
  316. if($parentId>0){
  317. $where['a.parent_id'] = $parentId;
  318. }
  319. $loginShopId = isset($params['login_shop_id'])? $params['login_shop_id'] : 0;
  320. if($loginShopId>0){
  321. $where['a.login_shop_id'] = $loginShopId;
  322. }
  323. if($status>0){
  324. $where['a.status'] = $status;
  325. }
  326. $list = $this->model->from('member as a')
  327. // ->leftJoin('shop as b', 'b.user_id', '=', 'a.id')
  328. ->leftJoin('member as c', 'c.id', '=', 'a.parent_id')
  329. ->where($where)
  330. ->where(function ($query) use($params){
  331. $keyword = isset($params['keyword'])? $params['keyword'] : '';
  332. if($keyword){
  333. $query->where('a.username','like',"%{$keyword}%")->orWhere('a.mobile','like',"%{$keyword}%");
  334. }
  335. $keyword1 = isset($params['keyword1'])? $params['keyword1'] : '';
  336. if($keyword1){
  337. $query->where('a.nickname','like',"%{$keyword1}%")->orWhere('a.mobile','like',"%{$keyword1}%");
  338. }
  339. })
  340. ->select(['a.*','c.code as parent_code','c.nickname as parent_name'])
  341. ->orderBy('a.create_time','desc')
  342. ->paginate($pageSize > 0 ? $pageSize : 9999999);
  343. $list = $list? $list->toArray() :[];
  344. if($list){
  345. foreach($list['data'] as &$item){
  346. $item['selected'] = false;
  347. $item['nickname'] = trim($item['nickname']);
  348. $item['rank_num'] = $item['id']%10+1;
  349. $item['create_time'] = $item['create_time']? datetime($item['create_time'],'Y-m-d H.i.s') : '';
  350. $item['login_time'] = $item['login_time']? datetime($item['login_time'],'Y-m-d H.i.s') : '';
  351. $item['avatar'] = isset($item['avatar']) && $item['avatar']? get_image_url($item['avatar']) : '';
  352. $item['parent_code'] = isset($item['parent_code']) && $item['parent_code']? $item['parent_code'] : '无';
  353. $showType = isset($params['show_type'])? $params['show_type'] : 1;
  354. if($showType==1){
  355. $item['invite_num'] = MemberService::make()->getInviteNums($item['id']);
  356. }else if($showType == 3){
  357. $item['bonus_total'] = TradeService::make()->getTradeBonusTotal($item['id'], $time);
  358. $item['profit_total'] = TradeService::make()->getTradeProfitTotal($item['id'], $time);
  359. }
  360. }
  361. }
  362. return [
  363. 'pageSize'=> $pageSize,
  364. 'total'=>isset($list['total'])? $list['total'] : 0,
  365. 'list'=> isset($list['data'])? $list['data'] : []
  366. ];
  367. }
  368. /**
  369. * 直推用户数
  370. * @param $userId
  371. * @return array|mixed
  372. */
  373. public function getInviteNums($userId)
  374. {
  375. $cacheKey = "caches:member:inviteNums";
  376. $data = RedisService::get($cacheKey);
  377. if($data){
  378. return $data;
  379. }
  380. $data = $this->model->where(['parent_id'=> $userId, 'mark'=> 1,'status'=>1])->count('id');
  381. if($data){
  382. RedisService::set($cacheKey, $data, rand(3, 5));
  383. }
  384. return $data;
  385. }
  386. /**
  387. * 用户选项
  388. * @return array
  389. */
  390. public function options()
  391. {
  392. // 获取参数
  393. $param = request()->all();
  394. // 用户ID
  395. $keyword = getter($param, "keyword");
  396. $parentId = getter($param, "parent_id");
  397. $userId = getter($param, "user_id");
  398. $datas = $this->model->where(function($query) use($parentId){
  399. if($parentId){
  400. $query->where(['id'=> $parentId,'mark'=>1]);
  401. }else{
  402. $query->where(['status'=> 1,'mark'=>1]);
  403. }
  404. })
  405. ->where(function($query) use($userId){
  406. if($userId){
  407. $query->whereNotIn('id', [$userId]);
  408. }
  409. })
  410. ->where(function($query) use($keyword){
  411. if($keyword){
  412. $query->where('nickname','like',"%{$keyword}%")->orWhere('mobile','like',"%{$keyword}%");
  413. }
  414. })
  415. ->select(['id','username','mobile','code','nickname','status'])
  416. ->get();
  417. return $datas? $datas->toArray() : [];
  418. }
  419. /**
  420. * 上级用户列表
  421. * @return array
  422. */
  423. public function parents()
  424. {
  425. // 获取参数
  426. $param = request()->all();
  427. // 用户ID
  428. $keyword = getter($param, "keyword");
  429. $parentId = getter($param, "parent_id");
  430. $userId = getter($param, "user_id");
  431. $datas = $this->model->where(function($query) use($parentId){
  432. if($parentId){
  433. $query->where(['id'=> $parentId,'mark'=>1]);
  434. }else{
  435. $query->where(['status'=> 1,'mark'=>1]);
  436. }
  437. })
  438. ->where(function($query) use($userId){
  439. if($userId){
  440. $query->whereNotIn('id', [$userId]);
  441. }
  442. })
  443. ->where(function($query) use($keyword){
  444. if($keyword){
  445. $query->where('username','like',"{$keyword}%")->orWhere('mobile','like',"{$keyword}%");
  446. }
  447. })
  448. ->select(['id','username','mobile','code','nickname','status'])
  449. ->get();
  450. return $datas? $datas->toArray() : [];
  451. }
  452. /**
  453. * 生成普通参数二维码
  454. * @param $str 参数
  455. * @param bool $refresh 是否重新生成
  456. * @return bool
  457. */
  458. public function makeQrcode($str, $refresh = false, $size = 4, $margin = 2, $level = 2)
  459. {
  460. $qrFile = '/images/qrcode/';
  461. if (!is_dir('/uploads' . $qrFile)) {
  462. @mkdir('./uploads' . $qrFile, 0755, true);
  463. }
  464. $qrFile = $qrFile . 'C_' . strtoupper(md5($str . '_' . $size . $margin . $level)) . '.png';
  465. $cacheKey = "caches:qrcodes:member_" . md5($str);
  466. if (RedisService::get($cacheKey) && is_file('/uploads' . $qrFile) && !$refresh) {
  467. //return $qrFile;
  468. }
  469. QRcode::png($str, './uploads' . $qrFile, $level, $size, $margin);
  470. if (!file_exists('./uploads' . $qrFile)) {
  471. return false;
  472. }
  473. RedisService::set($cacheKey, ['str' => $str, 'qrcode' => $qrFile, 'date' => date('Y-m-d H:i:s')], 7 * 24 * 3600);
  474. return $qrFile;
  475. }
  476. /**
  477. * 推荐树
  478. * @return array|false|mixed
  479. */
  480. public function getTree()
  481. {
  482. // 请求参数
  483. $keyword = request()->post('keyword','');
  484. $cacheKey = "caches:member:trees:".md5('t'.$keyword);
  485. $datas = RedisService::get($cacheKey);
  486. if($datas){
  487. return $datas;
  488. }
  489. $datas = $this->model->where(['status'=>1,'mark'=>1])
  490. ->select(['id','username','nickname','mobile','parent_id','status'])
  491. ->get()->keyBy('id');
  492. $datas = $datas? $datas->toArray() : [];
  493. $pid = 0;
  494. if($keyword){
  495. $data = $this->model->where(function($query) use($keyword){
  496. $query->where('nickname','like',"{$keyword}%")->orWhere('mobile','like',"{$keyword}%");
  497. })
  498. ->where(['status'=>1,'mark'=>1])
  499. ->orderBy('parent_id','asc')
  500. ->select(['id','parent_id','nickname','mobile','username'])
  501. ->first();
  502. $nickname = isset($data['nickname'])? $data['nickname'] : '';
  503. $username = isset($data['username'])? $data['username'] : '';
  504. $mobile = isset($data['mobile'])? $data['mobile'] : '';
  505. if($data){
  506. $pid = isset($data['id'])? $data['id'] : 0;
  507. $data['label'] = $nickname.($mobile?"({$mobile})":"");
  508. unset($data['nickname']);
  509. unset($data['username']);
  510. }
  511. }
  512. $datas = get_tree($datas, $pid);
  513. if($datas){
  514. if($pid){
  515. $data['children'] = $datas;
  516. $newDatas[0] = $data;
  517. $datas = $newDatas;
  518. }
  519. RedisService::set($cacheKey, $datas, rand(3,5));
  520. }
  521. return $datas;
  522. }
  523. /**
  524. * 添加会编辑会员
  525. * @return array
  526. * @since 2020/11/11
  527. * @author laravel开发员
  528. */
  529. public function edit()
  530. {
  531. // 请求参数
  532. $data = request()->all();
  533. // 头像处理
  534. $avatar = isset($data['avatar'])? trim($data['avatar']) : '';
  535. if ($avatar && strpos($avatar, "temp")) {
  536. $data['avatar'] = save_image($avatar, 'member');
  537. } else if($avatar){
  538. $data['avatar'] = str_replace(IMG_URL, "", $data['avatar']);
  539. }
  540. return parent::edit($data); // TODO: Change the autogenerated stub
  541. }
  542. /**
  543. * 修改头像
  544. * @param $userId
  545. * @param $avatar
  546. * @return mixed
  547. */
  548. public function saveAvatar($userId, $avatar)
  549. {
  550. return $this->model->where(['id'=> $userId])->update(['avatar'=> $avatar,'update_time'=> time()]);
  551. }
  552. /**
  553. * 重置密码
  554. * @return array
  555. * @since 2020/11/14
  556. * @author laravel开发员
  557. */
  558. public function resetPwd()
  559. {
  560. // 获取参数
  561. $param = request()->all();
  562. // 用户ID
  563. $userId = getter($param, "id");
  564. if (!$userId) {
  565. return message("用户ID不能为空", false);
  566. }
  567. $userInfo = $this->model->getInfo($userId);
  568. if (!$userInfo) {
  569. return message("用户信息不存在", false);
  570. }
  571. // 设置新密码
  572. $password = '123456';
  573. $userInfo['password'] = get_password($password);
  574. $result = $this->model->edit($userInfo);
  575. if (!$result) {
  576. return message("重置密码失败", false);
  577. }
  578. return message("重置密码成功");
  579. }
  580. /**
  581. * 修改账号
  582. * @param $userId
  583. * @param $params
  584. * @return bool
  585. */
  586. public function modify($userId, $params)
  587. {
  588. $username = isset($params['username']) ? $params['username'] : '';
  589. $newUsername = isset($params['new_username']) ? $params['new_username'] : '';
  590. $password = isset($params['password']) ? $params['password'] : '';
  591. if (empty($username) || empty($password)) {
  592. $this->error = 1013;
  593. return false;
  594. }
  595. // 用户验证
  596. $info = $this->model->getOne([['username', '=', $username]]);
  597. if (!$info || $info['id'] != $userId) {
  598. $this->error = 2001;
  599. return false;
  600. }
  601. // 使用状态校验
  602. if ($info['status'] != 1) {
  603. $this->error = 2009;
  604. return false;
  605. }
  606. // 密码校验
  607. $password = get_password($password);
  608. if ($password != $info['password']) {
  609. $this->error = 2002;
  610. return false;
  611. }
  612. $checkInfo = $this->model->getOne([['username', '=', $newUsername]]);
  613. if ($checkInfo && $checkInfo['id'] != $info['id']) {
  614. $this->error = 2005;
  615. return false;
  616. }
  617. if (!$this->model->where(['id' => $info['id']])->update(['username' => $newUsername, 'update_time' => time()])) {
  618. $this->error = 2021;
  619. return false;
  620. }
  621. $this->error = 2020;
  622. return true;
  623. }
  624. /**
  625. * 修改更新登录密码
  626. * @param $userId
  627. * @param $params
  628. * @return bool
  629. */
  630. public function updatePassword($userId, $params)
  631. {
  632. $password = isset($params['password']) ? $params['password'] : '';
  633. $oldPassword = isset($params['old_password']) ? $params['old_password'] : '';
  634. if (empty($oldPassword)) {
  635. $this->error = 2014;
  636. return false;
  637. }
  638. if (empty($password)) {
  639. $this->error = 2015;
  640. return false;
  641. }
  642. // 用户验证
  643. $info = $this->model->getOne([['id', '=', $userId,'mark'=>1]]);
  644. if (!$info) {
  645. $this->error = 2001;
  646. return false;
  647. }
  648. // 使用状态校验
  649. if ($info['status'] != 1) {
  650. $this->error = 2012;
  651. return false;
  652. }
  653. // 更新登录密码
  654. $passwordStr = get_password($password);
  655. $oldPasswordStr = get_password($oldPassword);
  656. if($info['password'] != $oldPasswordStr){
  657. $this->error = 2002;
  658. return false;
  659. }
  660. if($oldPassword == $password){
  661. $this->error = 2016;
  662. return false;
  663. }
  664. if (!$this->model->where(['id' => $info['id']])->update(['password' => $passwordStr, 'update_time' => time()])) {
  665. $this->error = 2025;
  666. return false;
  667. }
  668. $this->error = 2024;
  669. return true;
  670. }
  671. /**
  672. * 修改更新支付密码
  673. * @param $userId
  674. * @param $params
  675. * @return bool
  676. */
  677. public function updateSafePassword($userId, $params)
  678. {
  679. $password = isset($params['password']) ? $params['password'] : '';
  680. $safePassword = isset($params['safe_password']) ? $params['safe_password'] : '';
  681. if (empty($safePassword)) {
  682. $this->error = 2017;
  683. return false;
  684. }
  685. if (empty($password)) {
  686. $this->error = 2018;
  687. return false;
  688. }
  689. // 用户验证
  690. $info = $this->model->getOne([['id', '=', $userId,'mark'=>1]]);
  691. if (!$info) {
  692. $this->error = 2001;
  693. return false;
  694. }
  695. // 使用状态校验
  696. if ($info['status'] != 1) {
  697. $this->error = 2012;
  698. return false;
  699. }
  700. // 更新登录密码
  701. $safePassword = get_password($safePassword);
  702. $oldPasswordStr = get_password($password);
  703. if($info['password'] != $oldPasswordStr){
  704. $this->error = 2002;
  705. return false;
  706. }
  707. if (!$this->model->where(['id' => $info['id']])->update(['safe_password' => $safePassword, 'update_time' => time()])) {
  708. $this->error = 2025;
  709. return false;
  710. }
  711. $this->error = 2024;
  712. return true;
  713. }
  714. /**
  715. * 转换佣金
  716. * @param $userId
  717. * @param int $shopId
  718. * @param int $catchUid
  719. * @return bool
  720. */
  721. public function switchBonus($userId, $shopId=0, $catchUid=0)
  722. {
  723. if($userId>0){
  724. $info = $this->model->where(['id'=> $userId,'mark'=>1])
  725. ->select(['id','bonus','login_shop_id','bonus','score','status'])
  726. ->first();
  727. $score = isset($info['score'])? $info['score'] : 0;
  728. $bonus = isset($info['bonus'])? $info['bonus'] : 0;
  729. $status = isset($info['status'])? $info['status'] : 0;
  730. if(empty($info) || $status != 1){
  731. $this->error = 2019;
  732. return false;
  733. }
  734. if($bonus<=0){
  735. $this->error = 2026;
  736. return false;
  737. }
  738. DB::beginTransaction();
  739. $scoreRate = ConfigService::make()->getConfigByCode('score_rate');
  740. $scoreRate = $scoreRate? $scoreRate : 1;
  741. $switchScore = intval($bonus*$scoreRate);
  742. if(!$this->model->where(['id'=> $userId])->update(['bonus'=> 0,'score'=> intval($score + $switchScore), 'update_time'=> time()])){
  743. DB::rollBack();
  744. return false;
  745. }
  746. $logDatas[0] = [
  747. 'user_id'=> $userId,
  748. 'shop_id'=> $info['login_shop_id'],
  749. 'type'=> 5,
  750. 'coin_type'=> 2,
  751. 'money'=> -$info['bonus'],
  752. 'balance'=> $info['bonus'],
  753. 'create_time'=>time(),
  754. 'update_time'=>time(),
  755. 'remark'=> '佣金转换',
  756. 'status'=>1,
  757. 'mark'=> 1,
  758. ];
  759. $logDatas[1] = [
  760. 'user_id'=> $userId,
  761. 'shop_id'=> $info['login_shop_id'],
  762. 'type'=> 5,
  763. 'coin_type'=> 3,
  764. 'money'=> $switchScore,
  765. 'balance'=> $info['score'],
  766. 'create_time'=>time(),
  767. 'update_time'=>time(),
  768. 'remark'=> '佣金转换【¥'.$bonus.'】',
  769. 'status'=>1,
  770. 'mark'=> 1,
  771. ];
  772. if(!AccountModel::insert($logDatas)){
  773. DB::rollBack();
  774. return false;
  775. }
  776. DB::commit();
  777. $this->error = 1002;
  778. return true;
  779. }
  780. // 店铺一键转换
  781. else if ($shopId>0){
  782. $datas = $this->model->where(['login_shop_id'=> $shopId,'mark'=>1,'status'=>1])
  783. ->where('bonus','>', 0)
  784. ->select(['id','bonus','login_shop_id','bonus','score'])
  785. ->get();
  786. if($datas){
  787. $logDatas = [];
  788. $scoreRate = ConfigService::make()->getConfigByCode('score_rate');
  789. $scoreRate = $scoreRate? $scoreRate : 1;
  790. foreach($datas as $v){
  791. // 佣金
  792. $logDatas[] = [
  793. 'user_id'=> $v['id'],
  794. 'shop_id'=> $v['login_shop_id'],
  795. 'type'=> 5,
  796. 'coin_type'=> 2,
  797. 'money'=> -$v['bonus'],
  798. 'balance'=> $v['bonus'],
  799. 'create_time'=>time(),
  800. 'update_time'=>time(),
  801. 'remark'=> '佣金转换',
  802. 'status'=>1,
  803. 'mark'=> 1,
  804. ];
  805. // 积分
  806. $logDatas[] = [
  807. 'user_id'=> $v['id'],
  808. 'shop_id'=> $v['login_shop_id'],
  809. 'type'=> 5,
  810. 'coin_type'=> 3,
  811. 'money'=> $v['bonus']*$scoreRate,
  812. 'balance'=> $v['score'],
  813. 'create_time'=>time(),
  814. 'update_time'=>time(),
  815. 'remark'=> '佣金转换',
  816. 'status'=>1,
  817. 'mark'=> 1,
  818. ];
  819. }
  820. $sql = "UPDATE lev_member set `score`=`score`+(`bonus`)*{$scoreRate},`bonus`=0,update_time=".time()." where login_shop_id={$shopId} and status=1 and mark=1 and bonus >0";
  821. DB::beginTransaction();
  822. if(!DB::update(DB::raw($sql))){
  823. DB::rollBack();
  824. return false;
  825. }
  826. if(!AccountModel::insert($logDatas)){
  827. DB::rollBack();
  828. return false;
  829. }
  830. DB::commit();
  831. $this->error = 1002;
  832. return true;
  833. }
  834. }
  835. return true;
  836. }
  837. /**
  838. * 设置抢拍状态
  839. * @param $userId
  840. * @param $shopId
  841. * @param int $status
  842. * @return mixed
  843. */
  844. public function setTrade($userId, $shopId, $status=1)
  845. {
  846. if($userId>0){
  847. return $this->model->where(['id'=> $userId])->update(['is_trade'=>$status,'update_time'=> time()]);
  848. }else if($shopId){
  849. return $this->model->where(['login_shop_id'=> $shopId,'mark'=>1])->update(['is_trade'=>$status,'update_time'=> time()]);
  850. }
  851. }
  852. /**
  853. * 删除用户
  854. * @param $userId
  855. * @return mixed
  856. */
  857. public function setLock()
  858. {
  859. $id = request()->post('id', 0);
  860. if(!$id){
  861. $this->error =1013;
  862. return false;
  863. }
  864. return $this->model->where(['id'=> $id])->update(['status'=> 2,'update_time'=> time()]);
  865. }
  866. /**
  867. * 修改登录店铺
  868. * @param $userId
  869. * @return mixed
  870. */
  871. public function modifyShop()
  872. {
  873. $ids = request()->post('ids', 0);
  874. $shopCode = request()->post('shop_code','');
  875. if(empty($ids)){
  876. $this->error =2401;
  877. return false;
  878. }
  879. if(empty($shopCode)){
  880. $this->error = 2402;
  881. return false;
  882. }
  883. $shopInfo = ShopModel::where(['code'=>$shopCode,'mark'=>1,'status'=>1])->first();
  884. $shopId = isset($shopInfo['id'])? $shopInfo['id'] : 0;
  885. if(empty($shopInfo) && empty($shopId)){
  886. $this->error = 2403;
  887. return false;
  888. }
  889. return $this->model->whereIn('id', $ids)->update(['login_shop_id'=> $shopId,'update_time'=> time()]);
  890. }
  891. }