MemberService.php 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840
  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\Api;
  12. use App\Models\ActionLogModel;
  13. use App\Models\MemberBankModel;
  14. use App\Models\MemberModel;
  15. use App\Services\BaseService;
  16. use App\Services\ConfigService;
  17. use App\Services\JwtService;
  18. use App\Services\MpService;
  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\Api
  28. */
  29. class MemberService extends BaseService
  30. {
  31. // 静态对象
  32. protected static $instance = null;
  33. /**
  34. * 构造函数
  35. * @author laravel开发员
  36. * @since 2020/11/11
  37. * MemberService constructor.
  38. */
  39. public function __construct()
  40. {
  41. $this->model = new MemberModel();
  42. }
  43. /**
  44. * 静态入口
  45. * @return MemberService|static|null
  46. */
  47. public static function make()
  48. {
  49. if (!self::$instance) {
  50. self::$instance = new static();
  51. }
  52. return self::$instance;
  53. }
  54. /**
  55. * 验证账号
  56. * @param $code
  57. * @param array $params
  58. * @return array|false
  59. */
  60. public function login($code, $params = [])
  61. {
  62. // 账号登录
  63. if (empty($code)) {
  64. $this->error = 1041;
  65. return false;
  66. }
  67. // 获取用户信息
  68. $result = MpService::make()->getUserInfo($code);
  69. $openid = isset($result['openid']) ? $result['openid'] : '';
  70. if (empty($openid)) {
  71. $this->error = 1042;
  72. return false;
  73. }
  74. // 验证是否注册,没有则注册
  75. $where = ['openid' => $openid,'mark'=>1];
  76. $data = $this->model->where($where)
  77. ->select(['id', 'openid', 'mobile', 'user_type', 'nickname', 'avatar', 'code', 'status', 'mark'])
  78. ->first();
  79. $data = $data ? $data->toArray() : [];
  80. $userId = isset($data['id']) ? $data['id'] : 0;
  81. $status = isset($data['status']) ? $data['status'] : 0;
  82. $mobile = isset($data['mobile']) ? $data['mobile'] : '';
  83. $nickname = isset($data['nickname']) ? $data['nickname'] : '';
  84. $avatar = isset($data['nickname']) ? $data['avatar'] : '';
  85. if($data && $status!= 1){
  86. $this->error = '账号已被冻结,请联系客服~';
  87. return false;
  88. }
  89. // 未注册或未完善资料
  90. if(empty($data) || empty($nickname) || empty($mobile)){
  91. return [
  92. 'access_token'=>'',
  93. 'info'=>['uid'=>$userId, 'openid'=>$openid,'mobile'=>$mobile]
  94. ];
  95. }
  96. // 已注册
  97. $system = isset($params['system']) ? $params['system'] : [];
  98. $system = $system && !is_array($system) ? json_decode($system, true) : $system;
  99. $appSources = isset($system['app_sources']) && $system['app_sources'] ? $system['app_sources'] : 'ios';
  100. $uuid = isset($system['uuid']) ? $system['uuid'] : '';
  101. $version = isset($system['app_version']) ? $system['app_version'] : '';
  102. if (!RedisService::get("caches:members:login_{$userId}")) {
  103. $updateData = [
  104. 'login_ip' => get_client_ip(),
  105. 'login_time' => time(),
  106. 'app_uuid' => $uuid,
  107. 'login_count' => DB::raw("login_count+1"),
  108. 'app_version' => $version,
  109. 'device' => $appSources == 'ios' ? 1 : 2,
  110. 'mark' => 1,
  111. ];
  112. $this->model->where(['id' => $userId])->update($updateData);
  113. RedisService::set("caches:members:login_{$userId}", $updateData, rand(30, 60));
  114. }
  115. // 获取登录授权token
  116. $token = JwtService::make()->encode($userId);
  117. // 结果返回
  118. $result = [
  119. 'access_token' => $token,
  120. 'info' => ['id' => $userId, 'openid' => $openid,'nickname'=>$nickname, 'mobile' => $mobile],
  121. ];
  122. // 用户缓存信息
  123. $this->error = 2019;
  124. $data['token'] = $token;
  125. unset($data['mobile']);
  126. RedisService::keyDel("caches:members:teamList*");
  127. RedisService::set("auths:info:{$userId}", $data, 24 * 3600);
  128. return $result;
  129. }
  130. /**
  131. * 授权注册
  132. * @param $code
  133. * @param array $params
  134. * @return array|false
  135. */
  136. public function register($params = [])
  137. {
  138. $openid = isset($params['openid'])? $params['openid'] : '';
  139. $phone = isset($params['mobile'])? $params['mobile'] : '';
  140. $avatar = isset($params['avatar'])? $params['avatar'] : '';
  141. $nickname = isset($params['nickname'])? $params['nickname'] : '';
  142. if(empty($openid)){
  143. $this->error = '请先获取授权';
  144. return false;
  145. }
  146. // 手机号
  147. if (empty($phone)) {
  148. $this->error = '请先授权获取手机号';
  149. return false;
  150. }
  151. if(empty($avatar) || empty($nickname)){
  152. $this->error = '请先授权设置用户信息';
  153. return false;
  154. }
  155. $avatar = save_base64_image($avatar, 'avatar');
  156. // 验证是否注册,没有则注册
  157. $where = ['openid' => $openid,'mark'=>1];
  158. $data = $this->model->where($where)
  159. ->select(['id', 'openid', 'mobile', 'user_type', 'nickname', 'avatar', 'code', 'status', 'mark'])
  160. ->first();
  161. $data = $data ? $data->toArray() : [];
  162. $userId = isset($data['id']) ? $data['id'] : 0;
  163. $status = isset($data['status']) ? $data['status'] : 0;
  164. if ($data && $userId && $status != 1) {
  165. $this->error = '账号已被冻结,请来奶昔客服~';
  166. return false;
  167. }
  168. $system = isset($params['system']) ? $params['system'] : [];
  169. $system = $system && !is_array($system) ? json_decode($system, true) : $system;
  170. $appSources = isset($system['app_sources']) && $system['app_sources'] ? $system['app_sources'] : 'ios';
  171. $uuid = isset($system['uuid']) ? $system['uuid'] : '';
  172. $version = isset($system['app_version']) ? $system['app_version'] : '';
  173. if (empty($data)) {
  174. // 清理无效注册数据
  175. $this->model->where(['openid'=>$openid,'mark'=>0])->delete();
  176. // 用户ID
  177. $userId = $this->model->max('id') + 1;
  178. // 推荐人
  179. $rid = isset($params['rid']) ? intval($params['rid']) : 0;
  180. $parents = '';
  181. if ($rid) {
  182. $inviteInfo = $this->model->where(['id' => $rid, 'mark' => 1])
  183. ->select(['id', 'parent_id', 'parents', 'status'])
  184. ->first();
  185. $rid = isset($inviteInfo['id']) ? $inviteInfo['id'] : 0;
  186. $parents = isset($inviteInfo['parents']) ? $inviteInfo['parents'] : '';
  187. if ($inviteInfo) {
  188. $parents = $parents ? $parents . $rid . ',' : ",{$rid},";
  189. }else{
  190. $rid = 1;
  191. $parents = ',1,';
  192. }
  193. }else{
  194. $rid = 1;
  195. $parents = ',1,';
  196. }
  197. // 滑落节点
  198. $pointId = 0;
  199. $points = '';
  200. if($rid>0){
  201. $pointId = $this->getPointParentId($rid);
  202. if($pointId){
  203. $pointParent = $this->model->where(['id'=> $pointId,'mark'=>1])->select(['id','points'])->first();
  204. $points = isset($pointParent['points']) && $pointParent['points']? $pointParent['points'].$pointId.',' : ($pointId ? $pointId . ',' : '');
  205. }
  206. }
  207. DB::beginTransaction();
  208. $data = [
  209. 'nickname' => $nickname,
  210. 'openid' => $openid,
  211. 'mobile' => $phone,
  212. 'avatar' => $avatar,
  213. 'parent_id' => $rid,
  214. 'parents' => $parents,
  215. 'point_id' => $pointId,
  216. 'points' => $points,
  217. 'code' => get_random_code(9, 'Q', $userId),
  218. 'password' => get_password('a123456'),
  219. 'login_ip' => get_client_ip(),
  220. 'create_time' => time(),
  221. 'login_time' => time(),
  222. 'login_count' => DB::raw("login_count+1"),
  223. 'app_version' => $version,
  224. 'app_uuid' => $uuid,
  225. 'device' => $appSources == 'ios' ? 1 : 2,
  226. ];
  227. if (!$userId = $this->model->insertGetId($data)) {
  228. DB::rollBack();
  229. $this->error = 2018;
  230. return false;
  231. }
  232. DB::commit();
  233. } // 更新登录信息
  234. else if (!RedisService::get("caches:members:login_{$userId}")) {
  235. $updateData = [
  236. 'login_ip' => get_client_ip(),
  237. 'login_time' => time(),
  238. 'app_uuid' => $uuid,
  239. 'login_count' => DB::raw("login_count+1"),
  240. 'app_version' => $version,
  241. 'device' => $appSources == 'ios' ? 1 : 2,
  242. 'mark' => 1,
  243. ];
  244. $this->model->where(['id' => $userId])->update($updateData);
  245. RedisService::set("caches:members:login_{$userId}", $updateData, rand(30, 60));
  246. }
  247. // 获取登录授权token
  248. $token = JwtService::make()->encode($userId);
  249. // 结果返回
  250. $result = [
  251. 'access_token' => $token,
  252. 'info' => ['id' => $userId, 'openid' => $openid, 'mobile' => $data['mobile']],
  253. ];
  254. // 用户缓存信息
  255. $this->error = 2019;
  256. $data['token'] = $token;
  257. unset($data['mobile']);
  258. RedisService::keyDel("caches:members:teamList*");
  259. RedisService::set("auths:info:{$userId}", $data, 24 * 3600);
  260. return $result;
  261. }
  262. /**
  263. * 获取点对点上级节点
  264. * @param $userId 推荐人ID
  265. * @return int|mixed
  266. */
  267. public function getPointParentId($userId)
  268. {
  269. if($userId<=0){
  270. return 0;
  271. }
  272. $userList = $this->model->where(['mark'=> 1])->whereRaw('FIND_IN_SET(?,points)', $userId)->select(['id','point_id','points'])->orderBy('create_time','asc')->get();
  273. $userList = $userList? $userList->toArray() : [];
  274. if(count($userList) < 2){
  275. return $userId;
  276. }
  277. $users = [];
  278. foreach($userList as $item){
  279. $points = isset($item['points']) && $item['points']? explode(',', $item['points']) : [];
  280. $points = array_filter($points);
  281. $users[$item['id']]['pointLen'] = count($points);
  282. $users[$item['id']]['children'] = isset($users[$item['id']]['children'])? $users[$item['id']]['children'] : 0;
  283. $users[$item['point_id']]['children'] = isset($users[$item['point_id']]['children'])? $users[$item['point_id']]['children'] + 1 : 1;
  284. }
  285. dump($userList);
  286. dump($users);
  287. $pointId = 0;
  288. $tempPointLen = 0;
  289. $tempChildren = 0;
  290. foreach ($userList as $item) {
  291. $id = isset($item['id'])? $item['id'] : 0;
  292. $children = isset($users[$id]['children'])? $users[$id]['children'] : 0;
  293. $pointLen = isset($users[$id]['pointLen'])? $users[$id]['pointLen'] : 0;
  294. if($pointLen<=$tempPointLen || $pointId == 0){
  295. if($children < $tempChildren || $pointId == 0){
  296. $pointId = $id;
  297. $tempPointLen = $pointLen;
  298. $tempChildren = $children;
  299. }
  300. }
  301. }
  302. return $pointId;
  303. }
  304. /**
  305. * 重置密码
  306. * @param $params
  307. * @return array|false
  308. */
  309. public function forget($params)
  310. {
  311. // 账号登录
  312. $mobile = isset($params['mobile']) ? trim($params['mobile']) : '';
  313. $password = isset($params['password']) ? trim($params['password']) : '';
  314. if (empty($params) || empty($mobile) || empty($password)) {
  315. $this->error = 1041;
  316. return false;
  317. }
  318. // 验证是否注册
  319. if (!$userId = $this->model->where(['mobile' => $mobile, 'mark' => 1])->value('id')) {
  320. $this->error = 1038;
  321. return false;
  322. }
  323. if (!$this->model->where(['id' => $userId])->update(['password' => get_password($password), 'update_time' => time()])) {
  324. $this->error = 2030;
  325. return false;
  326. }
  327. // 操作日志
  328. ActionLogModel::setRecord($userId, ['type' => 2, 'title' => '重置密码', 'content' => '重置登录密码', 'module' => 'member']);
  329. ActionLogModel::record();
  330. $this->error = 2031;
  331. return true;
  332. }
  333. /**
  334. * 获取资料详情
  335. * @param $where
  336. * @param array $field
  337. */
  338. public function getInfo($where, array $field = [], $refresh = true)
  339. {
  340. if (empty($where)) {
  341. return false;
  342. }
  343. $fieldKey = $field ? '_' . md5(json_encode($field)) : '';
  344. $cacheKey = "caches:members:info_" . (!is_array($where) ? $where . $fieldKey : md5(json_encode($where) . $fieldKey));
  345. $info = RedisService::get($cacheKey);
  346. if ($info && !$refresh) {
  347. return $info;
  348. }
  349. $defaultField = ['id', 'user_type', 'realname', 'mobile','is_auth','member_level','idcard', 'nickname','parent_id','point_id', 'balance','ls_score','bd_score','property','property_total','withdraw_property','bonus_total','withdraw_total', 'code', 'openid','create_time', 'status', 'avatar'];
  350. $field = $field ? $field : $defaultField;
  351. if (is_array($where)) {
  352. $info = $this->model->with(['parent','point','levelData'])->where(['mark' => 1])->where($where)->select($field)->first();
  353. } else {
  354. $info = $this->model->with(['parent','point','levelData'])->where(['mark' => 1])->where(['id' => (int)$where])->select($field)->first();
  355. }
  356. $info = $info ? $info->toArray() : [];
  357. if ($info) {
  358. $info['create_time'] = $info['create_time']?datetime(strtotime($info['create_time']),'Y-m-d H:i') : '';
  359. if (isset($info['mobile'])) {
  360. $info['mobile_text'] = $info['mobile'] ? format_mobile($info['mobile']) : '';
  361. }
  362. $params = request()->all();
  363. $type = isset($params['type'])?$params['type']:'';
  364. if($type == 'qrcode'){
  365. $info['qrcode'] = MpService::make()->getMiniQrcode('pages/index/index',"{$info['id']}");
  366. $info['qrcode'] = $info['qrcode']? get_image_url($info['qrcode']):'';
  367. }
  368. if($type == 'center'){
  369. $info['invite_count'] = $this->model->where(['parent_id'=>$info['id'],'mark'=>1])->count('id');
  370. }
  371. if($type == 'account' || $type == 'center'){
  372. $info['property_price'] = PriceService::make()->getTodayPrice(1);
  373. $info['property_total'] = floatval($info['property'] * $info['property_price']);
  374. }
  375. RedisService::set($cacheKey, $info, rand(10, 20));
  376. }
  377. return $info;
  378. }
  379. /**
  380. * 认证资料
  381. * @param $userId
  382. * @return array|mixed
  383. */
  384. public function authInfo($userId)
  385. {
  386. $cacheKey = "caches:members:authInfo:{$userId}";
  387. $info = RedisService::get($cacheKey);
  388. if ($info) {
  389. return $info;
  390. }
  391. $info = $this->model->where(['id' => $userId, 'mark' => 1])
  392. ->select(['id', 'realname','idcard','bank_name','bank_card','bank_branch','is_auth', 'status'])
  393. ->first();
  394. $info = $info?$info->toArray() : [];
  395. if($info){
  396. RedisService::set($cacheKey, $info, rand(300,600));
  397. }
  398. return $info;
  399. }
  400. /**
  401. * 绑定收款账户
  402. * @param $userId
  403. * @return array|mixed
  404. */
  405. public function bindAccount($userId, $params)
  406. {
  407. if($params['type']==1){
  408. $alipay = MemberBankModel::where(['type'=>1,'user_id'=>$userId,'mark'=>1])
  409. ->select(['id','user_id','type','realname','account','account_remark','status'])
  410. ->first();
  411. $alipayId = isset($alipay['id'])?$alipay['id'] : 0;
  412. $data = [
  413. 'type'=> 1,
  414. 'user_id'=> $userId,
  415. 'realname'=>$params['realname'],
  416. 'account'=>$params['account'],
  417. 'account_remark'=>isset($params['account_remark']) && $params['account_remark']?$params['account_remark']:'支付宝',
  418. 'status'=>1
  419. ];
  420. if($alipayId){
  421. $data['update_time']=time();
  422. MemberBankModel::where(['id'=>$alipayId])->update($data);
  423. }else {
  424. $data['create_time']=time();
  425. MemberBankModel::insertGetId($data);
  426. }
  427. } else if($params['type']==2){
  428. $banks = MemberBankModel::where(['type'=>2,'user_id'=>$userId,'mark'=>1])
  429. ->select(['id','user_id','type','realname','account','account_remark','status'])
  430. ->first();
  431. $bankId = isset($banks['id'])?$banks['id'] : 0;
  432. $data = [
  433. 'type'=>2,
  434. 'user_id'=> $userId,
  435. 'realname'=>$params['realname'],
  436. 'account'=>$params['account'],
  437. 'account_remark'=>$params['account_remark'],
  438. 'status'=>1
  439. ];
  440. if($bankId){
  441. $data['update_time']=time();
  442. MemberBankModel::where(['id'=>$bankId])->update($data);
  443. }else {
  444. $data['create_time']=time();
  445. MemberBankModel::insertGetId($data);
  446. }
  447. }else{
  448. $this->error = '账号类型错误';
  449. return false;
  450. }
  451. RedisService::keyDel("caches:members:account:{$userId}*");
  452. $this->error = '绑定收款账号成功';
  453. return true;
  454. }
  455. /**
  456. * 团队人数
  457. * @param $uid
  458. * @return array|int|mixed
  459. */
  460. public function getTeamCount($uid)
  461. {
  462. $cacheKey = "caches:members:teamCount:{$uid}";
  463. $data = RedisService::get($cacheKey);
  464. if ($data) {
  465. return $data;
  466. }
  467. $data = $this->model->from('member as a')
  468. ->where('a.parents', 'like', "%,{$uid},%")
  469. ->where(['a.status' => 1, 'a.mark' => 1])
  470. ->count('id');
  471. if($data){
  472. RedisService::set($cacheKey, $data, rand(5,10));
  473. }
  474. return $data;
  475. }
  476. /**
  477. * 生成普通参数二维码
  478. * @param $str 参数
  479. * @param bool $refresh 是否重新生成
  480. * @return bool
  481. */
  482. public function makeQrcode($str, $refresh = false, $size = 4, $margin = 2, $level = 2)
  483. {
  484. $basePath = base_path() . '/public';
  485. $qrFile = '/images/qrcode/';
  486. if (!is_dir($basePath . '/uploads' . $qrFile)) {
  487. @mkdir($basePath . '/uploads' . $qrFile, 0755, true);
  488. }
  489. $key = date('Ymd') . strtoupper(md5($str . '_' . $size . $margin . $level));
  490. $qrFile = $qrFile . "C_{$key}.png";
  491. $cacheKey = "caches:qrcodes:member_" . $key;
  492. if (RedisService::get($cacheKey) && is_file($basePath . '/uploads' . $qrFile) && !$refresh) {
  493. return $qrFile;
  494. }
  495. QRcode::png($str, $basePath . '/uploads' . $qrFile, $level, $size, $margin);
  496. if (!file_exists($basePath . '/uploads' . $qrFile)) {
  497. return false;
  498. }
  499. RedisService::set($cacheKey, ['str' => $str, 'qrcode' => $qrFile, 'date' => date('Y-m-d H:i:s')], 7 * 24 * 3600);
  500. return $qrFile;
  501. }
  502. /**
  503. * 修改信息
  504. * @param $userId
  505. * @param $params
  506. * @return bool
  507. */
  508. public function modify($userId, $params)
  509. {
  510. $cacheLockKey = "caches:members:modify_{$userId}";
  511. if (RedisService::get($cacheLockKey)) {
  512. $this->error = 1034;
  513. return false;
  514. }
  515. // 用户验证
  516. RedisService::set($cacheLockKey, ['user_id' => $userId, 'params' => $params], rand(2, 3));
  517. $info = $this->model->where(['id' => $userId, 'mark' => 1])
  518. ->select(['id', 'nickname','avatar','company','position','department', 'status'])
  519. ->first();
  520. if (!$info || $info['status'] != 1) {
  521. $this->error = 2016;
  522. RedisService::clear($cacheLockKey);
  523. return false;
  524. }
  525. // 修改数据
  526. $data = ['update_time' => time()];
  527. $nickname = isset($params['nickname']) ? $params['nickname'] : '';
  528. if (isset($params['nickname']) && $nickname) {
  529. $data['nickname'] = $nickname;
  530. }
  531. $mobile = isset($params['mobile']) ? $params['mobile'] : '';
  532. if (isset($params['mobile']) && $mobile) {
  533. $data['mobile'] = $mobile;
  534. }
  535. $company = isset($params['company']) ? $params['company'] : '';
  536. if (isset($params['company']) && $company) {
  537. $data['company'] = $company;
  538. }
  539. $department = isset($params['department']) ? $params['department'] : '';
  540. if (isset($params['department']) && $department) {
  541. $data['department'] = $department;
  542. }
  543. $position = isset($params['position']) ? $params['position'] : '';
  544. if (isset($params['position']) && $position) {
  545. $data['position'] = $position;
  546. }
  547. // 头像
  548. $avatar = isset($params['avatar']) ? $params['avatar'] : '';
  549. if (isset($params['avatar']) && $avatar) {
  550. $data['avatar'] = save_base64_image($avatar, 'avatar');
  551. }
  552. if (!$this->model->where(['id' => $userId])->update($data)) {
  553. $this->error = 1014;
  554. RedisService::clear($cacheLockKey);
  555. return false;
  556. }
  557. $oldAvatar = isset($info['avatar']) ? $info['avatar'] : '';
  558. if ($avatar && $oldAvatar && ($avatar != $oldAvatar) && file_exists(ATTACHMENT_PATH . $oldAvatar)) {
  559. @unlink(ATTACHMENT_PATH . $oldAvatar);
  560. }
  561. $this->error = 1013;
  562. RedisService::clear($cacheLockKey);
  563. RedisService::clear("caches:members:authInfo:{$userId}");
  564. RedisService::clear("caches:members:info_{$userId}");
  565. return true;
  566. }
  567. /**
  568. * 认证
  569. * @param $userId
  570. * @param $params
  571. * @return bool
  572. */
  573. public function auth($userId, $params)
  574. {
  575. $cacheLockKey = "caches:members:auth_{$userId}";
  576. if (RedisService::get($cacheLockKey)) {
  577. $this->error = 1034;
  578. return false;
  579. }
  580. // 用户验证
  581. RedisService::set($cacheLockKey, ['user_id' => $userId, 'params' => $params], rand(2, 3));
  582. $info = $this->model->where(['id' => $userId, 'mark' => 1])
  583. ->select(['id', 'realname','idcard','is_auth', 'status'])
  584. ->first();
  585. if (!$info || $info['status'] != 1) {
  586. $this->error = '账号或已被冻结,请联系客服';
  587. RedisService::clear($cacheLockKey);
  588. return false;
  589. }
  590. if($info['is_auth'] == 1 && $info['idcard'] && $info['realname']){
  591. $this->error = '抱歉,您已完成认证';
  592. RedisService::clear($cacheLockKey);
  593. return false;
  594. }
  595. // 认证数据
  596. $data = [
  597. 'realname'=> isset($params['realname'])?$params['realname'] : '',
  598. 'company'=> isset($params['company'])?$params['company'] : '',
  599. 'idcard'=> isset($params['idcard'])?$params['idcard'] : '',
  600. 'is_auth'=> 1,
  601. 'update_time' => time()
  602. ];
  603. if (!$this->model->where(['id' => $userId])->update($data)) {
  604. $this->error = '认证提交失败';
  605. RedisService::clear($cacheLockKey);
  606. return false;
  607. }
  608. $this->error = '恭喜您,已完成认证';
  609. RedisService::clear($cacheLockKey);
  610. RedisService::clear("caches:members:authInfo:{$userId}");
  611. RedisService::keyDel("caches:members:teamList*");
  612. return true;
  613. }
  614. /**
  615. * 获取团队列表
  616. * @param $userId
  617. * @param $params
  618. * @return array
  619. */
  620. public function getTeamList($userId,$params)
  621. {
  622. $page = isset($params['page'])?$params['page']: 1;
  623. $pageSize = isset($params['pageSize'])?$params['pageSize']: 12;
  624. $cacheKey = "caches:members:teamList_{$userId}:{$page}_".md5(json_encode($params));
  625. $list = RedisService::get($cacheKey);
  626. if ($list) {
  627. return [
  628. 'cache'=>true,
  629. 'pageSize'=> $pageSize,
  630. 'total'=>isset($list['total'])? $list['total'] : 0,
  631. 'list'=> isset($list['data'])? $list['data'] : []
  632. ];
  633. }
  634. $list = $this->model->from('member as a')
  635. ->where(['a.parent_id'=>$userId,'a.mark'=>1])
  636. ->where(function($query) use($params){
  637. $keyword = isset($params['keyword'])? $params['keyword'] : '';
  638. if($keyword){
  639. $query->where(function($query) use($keyword){
  640. $query->where('a.realname','like',"%{$keyword}%")
  641. ->orWhere('a.nickname','like',"%{$keyword}%")
  642. ->orWhere('a.mobile','like',"%{$keyword}%");
  643. });
  644. }
  645. })
  646. ->select(['a.id','a.realname','a.mobile','a.nickname','a.parent_id','a.avatar','a.is_auth','a.create_time','a.status'])
  647. ->groupBy('a.id')
  648. ->orderBy('a.create_time','desc')
  649. ->orderBy('a.id','desc')
  650. ->paginate($pageSize > 0 ? $pageSize : 9999999);
  651. $list = $list? $list->toArray() :[];
  652. $total = isset($list['total'])? $list['total'] : 0;
  653. if($total){
  654. RedisService::set($cacheKey, $list, rand(5,10));
  655. }
  656. return [
  657. 'pageSize'=> $pageSize,
  658. 'total'=>$total,
  659. 'list'=> isset($list['data'])? $list['data'] : []
  660. ];
  661. }
  662. /**
  663. * 设置账户参数
  664. * @param $userId
  665. * @param $params
  666. * @return array|false|mixed|string
  667. */
  668. public function setting($userId, $params)
  669. {
  670. $apiUrl = ConfigService::make()->getConfigByCode('bonus_settle_url','');
  671. if(empty($apiUrl)){
  672. $this->error = '设置失败,参数错误';
  673. return false;
  674. }
  675. $token = request()->headers->get('Authorization');
  676. $token = str_replace("Bearer ", null, $token);
  677. $header = [
  678. 'authorization: '.$token
  679. ];
  680. $position = isset($params['position'])?trim($params['position']): '';
  681. $point = isset($params['commission_point'])?floatval($params['commission_point']): 0;
  682. $result = httpRequest($apiUrl.'/team/setting',['id'=>$userId,'position'=>$position,'point'=>$point],'post','',5,$header);
  683. $err = isset($result['err']) && $result['err']?$result['err'] : -1;
  684. $msg = isset($result['msg']) && $result['msg']?$result['msg'] : '1003';
  685. $data = isset($result['data']) && $result['data']?$result['data'] : [];
  686. if($err==0){
  687. $this->error = '操作成功';
  688. return $data;
  689. }else{
  690. $this->error = $msg;
  691. return false;
  692. }
  693. }
  694. /*
  695. * 各等级身份人数
  696. * @return array|mixed
  697. */
  698. public function getCountsByLevel()
  699. {
  700. $cacheKey = "caches:member:counts_by_level";
  701. $data = RedisService::get($cacheKey);
  702. if($data){
  703. return $data;
  704. }
  705. $data = $this->model->where('member_level','>', 0)
  706. ->where(['mark'=>1])
  707. ->select(['id','member_level',DB::raw("count(id) as count")])
  708. ->groupBy('member_level')
  709. ->get()
  710. ->keyBy('member_level');
  711. $data = $data?$data->toArray() : [];
  712. if($data){
  713. RedisService::set($cacheKey, $data, rand(5,10));
  714. }
  715. return $data;
  716. }
  717. /**
  718. * 账号注销
  719. * @param $userId
  720. * @return bool
  721. */
  722. public function logOff($userId)
  723. {
  724. $info = $this->model->where(['id' => $userId, 'mark' => 1])
  725. ->select(['id', 'password', 'status'])
  726. ->first();
  727. $status = isset($info['status']) ? $info['status'] : 0;
  728. if (empty($info)) {
  729. $this->error = 2044;
  730. return false;
  731. }
  732. if ($status != 1) {
  733. $this->error = 2044;
  734. return false;
  735. }
  736. if (!$this->model->where(['id' => $userId])->update(['status' => 3, 'update_time' => time()])) {
  737. $this->error = 2049;
  738. return false;
  739. }
  740. $this->error = 2048;
  741. RedisService::clear("auths:info:" . $userId);
  742. return true;
  743. }
  744. }