Usercenter.php 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528
  1. <?php
  2. namespace app\api\controller;
  3. use addons\epay\library\Service;
  4. use app\api\controller\Common;
  5. use app\api\validate\user\Report;
  6. use app\common\model\UserPower;
  7. use app\common\service\TenimService;
  8. use outh\outh;
  9. use think\Db;
  10. use app\common\controller\RedisLeaderboard;
  11. use Redis;
  12. use GatewayClient\Gateway;
  13. use think\Exception;
  14. /**
  15. * 会员中心接口
  16. */
  17. class UserCenter extends Common
  18. {
  19. protected $noNeedLogin = ['shujuhuifu','getAnchorType','getRecharConfig','getExchangeConfig','getLevelExplain'];
  20. protected $noNeedRight = '*';
  21. public function _initialize()
  22. {
  23. parent::_initialize();
  24. $this->userModel = new \app\common\model\User();
  25. }
  26. /**
  27. * 获取个人信息
  28. */
  29. public function getUserInfo() {
  30. $user_id = input("user_id");
  31. if (!$user_id) {
  32. $this->error(__('Invalid parameters'));
  33. }
  34. // 获取基本信息
  35. $where = [];
  36. $where["id"] = $user_id;
  37. $userInfo = $this->userModel->field("id,nickname,mobile,avatar,gender,u_id,level,age_id,province_id,city_id,desc,charm_level,wealth_level,job_id")->where($where)->find();
  38. if(!$userInfo){
  39. $this->error('不存在的用户');
  40. }
  41. $userInfo = info_domain_image($userInfo,['avatar']);
  42. //用户钱包
  43. $userwallet = Db::name('user_wallet')->where('user_id',$user_id)->find();
  44. $userInfo['wallet'] = $userwallet;
  45. $userInfoA = $this->userModel->getAppendData($userInfo);
  46. $userInfo['age_text'] = $userInfoA['age_text'];
  47. $userInfo['province_text'] = $userInfoA['province_text'];
  48. $userInfo['city_text'] = $userInfoA['city_text'];
  49. // $userInfo['friends_num'] = $userInfoA['friends_num'];
  50. $userInfo['look_num'] = $userInfoA['look_num'];
  51. //关注人数,粉丝人数
  52. $follow_num = Db::name('user_follow')->where(['uid'=>$user_id])->count('id');
  53. $fans_num = Db::name('user_follow')->where(['follow_uid'=>$user_id])->count('id');
  54. $userinfo['follow_num'] = $follow_num;
  55. $userinfo['fans_num'] = $fans_num;
  56. // 查看者是否已关注
  57. $userInfo["is_follow"] = $this->is_follow($this->auth->id,$user_id);
  58. $userInfo['is_friend'] = $this->is_friend($this->auth->id,$user_id);
  59. $userInfo['is_black'] = $this->is_black($this->auth->id,$user_id);
  60. // 获取用户在派对直播间情况信息
  61. $redis = new Redis();
  62. $redisconfig = config("redis");
  63. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  64. if ($redisconfig['redis_pwd']) {
  65. $redis->auth($redisconfig['redis_pwd']);
  66. }
  67. if($redisconfig['redis_selectdb'] > 0){
  68. $redis->select($redisconfig['redis_selectdb']);
  69. }
  70. $livingUserPartyId = $redis->hGet("livingUser", $user_id);
  71. $userInfo['party_info'] = json([]);
  72. if ($livingUserPartyId) {
  73. $party = \app\common\model\Party::where('id',$livingUserPartyId)->field('id,room_type')->find();
  74. $userInfo['party_info'] = ['party_id' => $party['id'], 'room_type' => $party['room_type']];
  75. }
  76. $memberinfo = Db::name('guild_member')->alias('m')->field('m.id as `member_id`,m.user_id,guild.name,guild.image,guild.member,guild.desc')->join('guild','m.guild_id = guild.id','LEFT')->where(['m.user_id'=>$user_id,'m.status'=>1])->find();
  77. if ($memberinfo) {
  78. $userInfo['memberinfo'] = $memberinfo;
  79. }
  80. //家族信息
  81. $guildField = 'g.id,g.g_id,g.user_id,g.party_id,g.name,g.image,g.desc,g.member,g.status';
  82. $guildWhere['gm.user_id'] = $user_id;
  83. $guildWhere['g.status'] = 1;
  84. $guildInfo = model('Guild')->alias('g')->field($guildField)
  85. ->join('guild_member gm','gm.guild_id = g.id','LEFT')
  86. ->where($guildWhere)->order('id desc')->find();
  87. $userInfo['guild_info'] = !empty($guildInfo) ? $guildInfo : [];
  88. $guildStatus = -2;
  89. if (!empty($guildInfo)) {
  90. $guildStatus = (int)$guildInfo['status'];
  91. }
  92. $userInfo['guild_status'] = $guildStatus;//家族状态:公会状态:0=待审核,1=正常,-1=已解散,-2无公会
  93. //访客记录
  94. if ($this->auth->id != $user_id) {
  95. $visit_data = [
  96. 'user_id' => $this->auth->id,
  97. 'visit_user_id' => $user_id,
  98. ];
  99. $visit_check = Db::name('user_visitlist')->where($visit_data)->find();
  100. if(empty($visit_check)){
  101. $visit_data['updatetime'] = time();
  102. Db::name('user_visitlist')->insertGetId($visit_data);
  103. }else{
  104. Db::name('user_visitlist')->where('id',$visit_check['id'])->update(['updatetime'=>time()]);
  105. }
  106. }
  107. $this->success("获取成功!",$userInfo);
  108. }
  109. /**
  110. * 获取最近访客
  111. * (消息)
  112. */
  113. public function getMyVisitList(){
  114. $list = Db::name('user_visitlist')->alias('uv')
  115. ->field('uv.user_id,uv.updatetime,user.nickname,user.avatar,user.gender,user.desc')
  116. ->join('user','uv.user_id = user.id','LEFT')
  117. ->where('uv.visit_user_id',$this->auth->id) //被访问者
  118. ->order('uv.id desc')->autopage()->select();
  119. $list = list_domain_image($list,['avatar']);
  120. if(!empty($list)){
  121. foreach($list as $key => &$val){
  122. //关注
  123. $val['is_follow'] = $this->is_follow($this->auth->id,$val['user_id']);
  124. }
  125. }
  126. $this->success(1,$list);
  127. }
  128. /**
  129. * 获取用户财富等级配置
  130. */
  131. public function get_wealth_config() {
  132. $data = Db::name('user_config_wealth')->order('level asc')->select();
  133. $data = list_domain_image($data,['image']);
  134. return $this->success("获取成功!",$data);
  135. }
  136. /**
  137. * 获取用户财富等级信息
  138. */
  139. public function getUserwealthInfo() {
  140. $res = [];$exstart = 0;$exend = 0;
  141. $userInfo = Db::name('user')->field("id,wealth_level,wealth_empirical")->where(["id"=>$this->auth->id])->find();
  142. if(!$userInfo) {
  143. $this->error("用户信息获取失败!");
  144. }
  145. //当前的等级
  146. $where = [];
  147. $where["empirical"] = ["elt",$userInfo["wealth_empirical"]];
  148. $userexplainstart = Db::name('user_config_wealth')->where($where)->order("empirical","desc")->limit(1)->select();
  149. //即将升到的等级
  150. $where = [];
  151. $where["empirical"] = ["gt",$userInfo["wealth_empirical"]];
  152. $userexplainend = Db::name('user_config_wealth')->where($where)->order("empirical","asc")->limit(1)->select();
  153. //当前等级 与 即将升到的等级,缺省补充
  154. if(!$userexplainstart && !$userexplainend) {
  155. $this->error("经验等级信息获取失败!");
  156. } elseif(!$userexplainstart && $userexplainend) {
  157. $res["level_start"] = 0;
  158. $res["level_end"] = $userexplainend[0]["level"];
  159. } elseif($userexplainstart && !$userexplainend) {
  160. $res["level_start"] = $userexplainstart[0]["level"];
  161. $res["level_end"] = $userexplainstart[0]["level"];
  162. } elseif($userexplainstart && $userexplainend) {
  163. $res["level_start"] = $userexplainstart[0]["level"];
  164. $res["level_end"] = $userexplainend[0]["level"];
  165. }
  166. $userexplainstart && $exstart = $userexplainstart[0]["empirical"];
  167. $userexplainend && $exend = $userexplainend[0]["empirical"];
  168. $r1 = $exend-$exstart; // 等级经验值差
  169. $r2 = $userInfo["wealth_empirical"]-$exstart; // 当前等级与最低等级经验值差
  170. $r3 = $exend-$userInfo["wealth_empirical"]; // 还需多少经验值升级
  171. if($r1 == 0) {
  172. $res["level_rate"] = 1; //百分百
  173. } elseif($r2 == 0) {
  174. $res["level_rate"] = 0; //百分0
  175. if($res["level_start"] == $res["level_end"]) {
  176. $res["level_rate"] = 1;
  177. }
  178. } else {
  179. $res["level_rate"] = intval(($r2/$r1)*100)/100;
  180. }
  181. $res["to_up_need"] = $r3>0?$r3:0;
  182. // // 满级
  183. // if($r3 == 0 && !$userexplainend) {
  184. // $res["level_rate"] = 1;
  185. // }
  186. //规则
  187. $rule = config('site.caifulevel_rule');
  188. $new_rule = [];
  189. foreach($rule as $title => $info){
  190. $new_rule[] = [
  191. 'title'=>$title,
  192. 'info'=>$info,
  193. ];
  194. }
  195. $res['rule'] = $new_rule;
  196. $this->success("获取成功!",$res);
  197. }
  198. ///////////////////////////没用到////////////////////////
  199. /**
  200. * 获取关注人列表.派对信息
  201. */
  202. public function getFollowsLive() {
  203. $is_online = $this->request->request("is_online");// 是否在线:1=直播中,0=未开播
  204. $page = $this->request->request('page',1); // 分页
  205. $pageNum = $this->request->request('pageNum',10); // 分页
  206. // 分页搜索构建
  207. $pageStart = ($page-1)*$pageNum;
  208. $is_online == 1 || $is_online = 0;
  209. $fanfollowModel = new \app\common\model\UserFansFollow();
  210. $where = [];
  211. $where["a.fans_id"] = $this->auth->id;
  212. $where["p.room_type"] = 2;
  213. $where["p.is_online"] = $is_online;
  214. if($is_online == 1) {
  215. $field = "p.id as party_id,u.u_id,u.nickname,p.party_name,p.party_hot,p.party_logo,u.avatar,t.id as party_type";
  216. } else {
  217. $field = "p.id as party_id,a.user_id,u.avatar,u.gender,u.level,u.nickname,p.party_name,p.party_logo,t.id as party_type";
  218. }
  219. $list = $fanfollowModel->alias("a")
  220. ->field($field)
  221. ->join("hx_user u","u.id = a.user_id")
  222. ->join("hx_party p","p.user_id = a.user_id")
  223. ->join("hx_party_type t","t.id = p.party_type","left")
  224. ->limit($pageStart,$pageNum)
  225. ->where($where)->select();
  226. if($list) {
  227. foreach($list as $k => $v) {
  228. $mod = isset($v["party_type"])?intval($v["party_type"])%5:1;
  229. if(isset($v["type_name"]) && $v["type_name"]) {
  230. $type_name = $v["type_name"];
  231. } else {
  232. $type_name = "普通房";
  233. }
  234. $list[$k]["party_type"] = $type_name;
  235. $list[$k]["party_type_color"] = $mod == 0?5:$mod;
  236. }
  237. $this->success("获取成功!",$list);
  238. } else {
  239. $this->success("数据为空!",[]);
  240. }
  241. }
  242. /**
  243. * 主播申请
  244. */
  245. public function anchorApply() {
  246. $type_id = $this->request->request('type_id',0); // 技能分类ID
  247. $party_type_id = $this->request->request('party_type_id'); //分类ID
  248. $desc = $this->request->request('desc'); // 申请备注
  249. if (!$party_type_id && !$desc) {
  250. $this->error(__('Invalid parameters'));
  251. }
  252. $useranchorModel = new \app\common\model\UserAnchor();
  253. $data = [];
  254. $data["user_id"] = $this->auth->id;
  255. $data["type_id"] = $type_id;
  256. $data["party_type_id"] = $party_type_id;
  257. if($useranchorModel->where($data)->find()) $this->error(__('您已申请过该类型的主播,请勿重复申请!'));
  258. $data["desc"] = $desc;
  259. $data["createtime"] = time();
  260. $res = $useranchorModel->insertGetId($data);
  261. if($res) {
  262. \app\common\model\User::update(["is_anchor"=>1],["id"=>$this->auth->id]);
  263. $vbot = new \addons\vbot\Vbot();
  264. $vbot->vbotSendMsg('Anchor_Application_Notice', [], []);
  265. $this->success("申请发送成功!");
  266. } else {
  267. $this->error("网络错误,请稍后重试");
  268. }
  269. }
  270. /**
  271. * 实名认证
  272. */
  273. public function authApply() {
  274. $realname = $this->request->request('realname'); // 真实姓名
  275. $idcard = $this->request->request('idcard'); // 身份证号
  276. $zimage = $this->request->request('zimage'); // 身份证正面照
  277. $fimage = $this->request->request('fimage'); // 身份证反面照
  278. if (!$realname && !$idcard && !$zimage && !$fimage) {
  279. $this->error(__('Invalid parameters'));
  280. }
  281. $userauthModel = new \app\common\model\UserAuth();
  282. $data = [];
  283. $data["user_id"] = $this->auth->id;
  284. //$data["idcard"] = $idcard;
  285. $userAuth = $userauthModel->where($data)->find();
  286. if (!empty($userAuth)) {
  287. if(in_array($userAuth['status'],[0,1])) $this->error('您已经申请过了,请勿重复操作!');
  288. }
  289. // 测试需要 开始
  290. $data["realname"] = $realname;
  291. $zimage && $data["zimage"] = $zimage;
  292. $fimage && $data["fimage"] = $fimage;
  293. $data["status"] = 1;
  294. if (!empty($userAuth)) {
  295. $data["updatetime"] = time();
  296. $authWhere['user_id'] = $this->auth->id;
  297. $res = $userauthModel->where($authWhere)->update($data);
  298. } else {
  299. $data["createtime"] = time();
  300. $res = $userauthModel->insertGetId($data);
  301. }
  302. if($res) {
  303. \app\common\model\User::update(["is_auth"=>2],["id"=>$this->auth->id]);
  304. $this->success("恭喜,实名认证成功!");
  305. } else {
  306. $this->error("网络错误,请稍后重试");
  307. }
  308. // 测试需要 结束
  309. // 实名认证验证
  310. $configInfo = config("auth");
  311. $outh = new outh($configInfo["api_url"],$configInfo["customer_code"],$configInfo["private_key"],$configInfo["key"]);
  312. $out_trade_no = date("YmdHis").rand(1000,9999);
  313. $ret = $outh->toVerify($out_trade_no,$realname,$idcard);
  314. if(isset($ret["code"])) {
  315. if($ret["code"] == "1008") {
  316. $this->error(__('身份证格式错误'));
  317. }
  318. if($ret["code"] == "1009") {
  319. $this->error(__('身份证格式错误'));
  320. }
  321. if($ret["code"] == "0001") {
  322. $this->error(__('姓名和身份证号不匹配!'));
  323. }
  324. if($ret["code"] == "0000") {
  325. $data["realname"] = $realname;
  326. $zimage && $data["zimage"] = $zimage;
  327. $fimage && $data["fimage"] = $fimage;
  328. $data["status"] = 1;
  329. $data["createtime"] = time();
  330. $res = $userauthModel->insertGetId($data);
  331. if($res) {
  332. \app\common\model\User::update(["is_auth"=>2],["id"=>$this->auth->id]);
  333. $this->success("恭喜,实名认证成功!");
  334. } else {
  335. $this->error("网络错误,请稍后重试");
  336. }
  337. }
  338. } else {
  339. $this->error("网络错误,请稍后重试");
  340. }
  341. }
  342. /**
  343. * 获取主播分类
  344. */
  345. public function getAnchorType() {
  346. $this->success("获取成功!",\app\common\model\UserAnchorType::select());
  347. }
  348. /**
  349. * redis 数据恢复---非redis数据丢失请勿使用!!!!
  350. */
  351. public function shujuhuifu() {
  352. $key = $this->request->request("key");// 操作验证 123456
  353. if($key != 123456) {
  354. $this->error(__('Invalid parameters'));
  355. }
  356. $giftuserpartyModel = new \app\common\model\GiftUserParty();
  357. $redis = new Redis();
  358. $redisconfig = config("redis");
  359. $redis->connect($redisconfig["host"], $redisconfig["port"]);
  360. if ($redisconfig['redis_pwd']) {
  361. $redis->auth($redisconfig['redis_pwd']);
  362. }
  363. if($redisconfig['redis_selectdb'] > 0){
  364. $redis->select($redisconfig['redis_selectdb']);
  365. }
  366. // 获取本周第一天
  367. $weekday = $this->firstOfWeek(date("Y-m-d H:i:s"));
  368. // 获取本月第一天
  369. $monthday = date("Ym01");
  370. $where = [];
  371. $where["createtime"] = ["gt",strtotime($weekday)];
  372. $list1 = $giftuserpartyModel->where($where)->select();
  373. foreach($list1 as $k => $v) {
  374. // 添加redis记录做财富排行榜周榜用
  375. $redis->zIncrBy("jewel_get_".$v["party_id"].":".$weekday,$v["value"],$v["user_to_id"]);
  376. // 添加redis记录做贡献排行榜周榜用
  377. $redis->zIncrBy("jewel_to_".$v["party_id"].":".$weekday,$v["value"],$v["user_id"]);
  378. }
  379. $where = [];
  380. $where["createtime"] = ["gt",strtotime(date("Y-m-01"))];
  381. $list2 = $giftuserpartyModel->where($where)->select();
  382. foreach($list2 as $k => $v) {
  383. // 添加redis记录做财富排行榜月榜用
  384. $redis->zIncrBy("jewel_get_".$v["party_id"].":".$monthday,$v["value"],$v["user_to_id"]);
  385. // 添加redis记录做贡献排行榜月榜用
  386. $redis->zIncrBy("jewel_to_".$v["party_id"].":".$monthday,$v["value"],$v["user_id"]);
  387. }
  388. $this->success("执行成功!");
  389. }
  390. /**
  391. * 获取用户等级说明
  392. */
  393. public function getLevelExplain() {
  394. $data = \app\common\model\UserLevelExplain::field("title,content")->select();
  395. return $this->success("获取成功!",$data);
  396. }
  397. /**
  398. * 获取用户等级信息
  399. */
  400. public function getUserLevelInfo() {
  401. $res = [];$exstart = 0;$exend = 0;
  402. $userModel = new \app\common\model\User();
  403. $userInfo = $userModel->field("id,nickname,avatar,level,empirical")->where(["id"=>$this->auth->id])->find();
  404. if(!$userInfo) {
  405. $this->error("用户信息获取失败!");
  406. }
  407. $res["avatar"] = $userInfo['avatar'];
  408. $res["nickname"] = $userInfo['nickname'];
  409. // 获取用户当前经验值对应等级
  410. $userconfigModel = new \app\common\model\UserLevelConfig();
  411. $where = [];
  412. $where["empirical"] = ["elt",$userInfo["empirical"]];
  413. $userexplainstart = $userconfigModel->where($where)->order("empirical","desc")->limit(1)->select();
  414. $where = [];
  415. $where["empirical"] = ["gt",$userInfo["empirical"]];
  416. $userexplainend = $userconfigModel->where($where)->order("empirical","asc")->limit(1)->select();
  417. if(!$userexplainstart && !$userexplainend) {
  418. $this->error("经验等级信息获取失败!");
  419. } elseif(!$userexplainstart && $userexplainend) {
  420. $res["level_start"] = 0;
  421. $res["level_end"] = $userexplainend[0]["level"];
  422. } elseif($userexplainstart && !$userexplainend) {
  423. $res["level_start"] = $userexplainstart[0]["level"];
  424. $res["level_end"] = $userexplainstart[0]["level"];
  425. } elseif($userexplainstart && $userexplainend) {
  426. $res["level_start"] = $userexplainstart[0]["level"];
  427. $res["level_end"] = $userexplainend[0]["level"];
  428. }
  429. $userexplainstart && $exstart = $userexplainstart[0]["empirical"];
  430. $userexplainend && $exend = $userexplainend[0]["empirical"];
  431. $r1 = $exend-$exstart; // 等级经验值差
  432. $r2 = $userInfo["empirical"]-$exstart; // 当前等级与最低等级经验值差
  433. $r3 = $exend-$userInfo["empirical"]; // 还需多少经验值升级
  434. if($r1 == 0) {
  435. $res["level_rate"] = 1;
  436. } elseif($r2 == 0) {
  437. $res["level_rate"] = 0;
  438. if($res["level_start"] == $res["level_end"]) {
  439. $res["level_rate"] = 1;
  440. }
  441. } else {
  442. $res["level_rate"] = intval(($r2/$r1)*100)/100;
  443. }
  444. $res["to_up_need"] = $r3>0?$r3:0;
  445. // // 满级
  446. // if($r3 == 0 && !$userexplainend) {
  447. // $res["level_rate"] = 1;
  448. // }
  449. $this->success("获取成功!",$res);
  450. }
  451. }