error(__('Invalid parameters')); } // 获取基本信息 $where = []; $where["id"] = $user_id; $userInfo = Db::name('user')->field("id,nickname,mobile,avatar,gender,u_id,age_id,province_id,city_id,is_auth,desc,charm_level,wealth_level,job_id")->where($where)->find(); if(!$userInfo){ $this->error('不存在的用户'); } $userInfo = info_domain_image($userInfo,['avatar']); //用户钱包 $userwallet = Db::name('user_wallet')->where('user_id',$user_id)->find(); $userInfo['wallet'] = $userwallet; $userModel = new \app\common\model\User(); $userInfoA = $userModel->getAppendData($userInfo); $userInfo['age_text'] = $userInfoA['age_text']; $userInfo['province_text'] = $userInfoA['province_text']; $userInfo['city_text'] = $userInfoA['city_text']; $userInfo['job_text'] = $userInfoA['job_text']; $userInfo['friends_num'] = $userInfoA['friends_num']; $userInfo['look_num'] = $userInfoA['look_num']; //关注人数,粉丝人数 $follow_num = Db::name('user_follow')->where(['uid'=>$user_id])->count('id'); $fans_num = Db::name('user_follow')->where(['follow_uid'=>$user_id])->count('id'); $userInfo['follow_num'] = $follow_num; $userInfo['fans_num'] = $fans_num; // 查看者是否已关注 $userInfo["is_follow"] = $this->is_follow($this->auth->id,$user_id); $userInfo['is_friend'] = $this->is_friend($this->auth->id,$user_id); $userInfo['is_black'] = $this->is_black($this->auth->id,$user_id); // 获取用户在派对直播间情况信息 /*$redis = new Redis(); $redisconfig = config("redis"); $redis->connect($redisconfig["host"], $redisconfig["port"]); if ($redisconfig['redis_pwd']) { $redis->auth($redisconfig['redis_pwd']); } if($redisconfig['redis_selectdb'] > 0){ $redis->select($redisconfig['redis_selectdb']); } $livingUserPartyId = $redis->hGet("livingUser", $user_id); $userInfo['party_info'] = json([]); if ($livingUserPartyId) { $party = \app\common\model\Party::where('id',$livingUserPartyId)->field('id,room_type')->find(); $userInfo['party_info'] = ['party_id' => $party['id'], 'room_type' => $party['room_type']]; }*/ $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])->find(); if ($memberinfo) { $userInfo['memberinfo'] = $memberinfo; } //家族信息 $guildField = 'g.id,g.g_id,g.user_id,g.party_id,g.name,g.image,g.desc,g.member,g.status'; $guildWhere['gm.user_id'] = $user_id; $guildWhere['g.status'] = 1; $guildInfo = model('Guild')->alias('g')->field($guildField) ->join('guild_member gm','gm.guild_id = g.id','LEFT') ->where($guildWhere)->order('id desc')->find(); $userInfo['guild_info'] = !empty($guildInfo) ? $guildInfo : []; $guildStatus = -2; if (!empty($guildInfo)) { $guildStatus = (int)$guildInfo['status']; } $userInfo['guild_status'] = $guildStatus;//家族状态:公会状态:0=待审核,1=正常,-1=已解散,-2无公会 //访客记录 if ($this->auth->id != $user_id) { $visit_data = [ 'user_id' => $this->auth->id, 'visit_user_id' => $user_id, ]; $visit_check = Db::name('user_visitlist')->where($visit_data)->find(); if(empty($visit_check)){ $visit_data['updatetime'] = time(); Db::name('user_visitlist')->insertGetId($visit_data); }else{ Db::name('user_visitlist')->where('id',$visit_check['id'])->update(['updatetime'=>time()]); } } $this->success("获取成功!",$userInfo); } /** * 获取最近访客 * (消息) */ public function getMyVisitList(){ $list = Db::name('user_visitlist')->alias('uv') ->field('uv.user_id,uv.updatetime,user.nickname,user.avatar,user.gender,user.desc') ->join('user','uv.user_id = user.id','LEFT') ->where('uv.visit_user_id',$this->auth->id) //被访问者 ->order('uv.id desc')->autopage()->select(); $list = list_domain_image($list,['avatar']); if(!empty($list)){ foreach($list as $key => &$val){ //关注 $val['is_follow'] = $this->is_follow($this->auth->id,$val['user_id']); } } $this->success(1,$list); } /** * 获取用户财富等级配置 */ public function get_wealth_config() { $data = Db::name('user_config_wealth')->order('level asc')->select(); $data = list_domain_image($data,['image']); return $this->success("获取成功!",$data); } /** * 获取用户财富等级信息 */ public function getUserwealthInfo() { $res = [];$exstart = 0;$exend = 0; $userInfo = Db::name('user')->field("id,wealth_level,wealth_empirical")->where(["id"=>$this->auth->id])->find(); if(!$userInfo) { $this->error("用户信息获取失败!"); } //当前的等级 $where = []; $where["empirical"] = ["elt",$userInfo["wealth_empirical"]]; $userexplainstart = Db::name('user_config_wealth')->where($where)->order("empirical","desc")->limit(1)->select(); //即将升到的等级 $where = []; $where["empirical"] = ["gt",$userInfo["wealth_empirical"]]; $userexplainend = Db::name('user_config_wealth')->where($where)->order("empirical","asc")->limit(1)->select(); //当前等级 与 即将升到的等级,缺省补充 if(!$userexplainstart && !$userexplainend) { $this->error("经验等级信息获取失败!"); } elseif(!$userexplainstart && $userexplainend) { $res["level_start"] = 0; $res["level_start_empirical"] = 0; $res["level_end"] = $userexplainend[0]["level"]; $res["level_end_empirical"] = $userexplainend[0]["empirical"]; } elseif($userexplainstart && !$userexplainend) { $res["level_start"] = $userexplainstart[0]["level"]; $res["level_start_empirical"] = $userexplainstart[0]["empirical"]; $res["level_end"] = $userexplainstart[0]["level"]; $res["level_end_empirical"] = $userexplainstart[0]["empirical"]; } elseif($userexplainstart && $userexplainend) { $res["level_start"] = $userexplainstart[0]["level"]; $res["level_start_empirical"] = $userexplainstart[0]["empirical"]; $res["level_end"] = $userexplainend[0]["level"]; $res["level_end_empirical"] = $userexplainend[0]["empirical"]; } $exstart = $res["level_start_empirical"]; $exend = $res["level_end_empirical"]; $r1 = $exend-$exstart; // 等级经验值差 $r2 = $userInfo["wealth_empirical"]-$exstart; // 当前等级与最低等级经验值差 $r3 = $exend-$userInfo["wealth_empirical"]; // 还需多少经验值升级 if($r1 == 0) { $res["level_rate"] = 1; //百分百 } elseif($r2 == 0) { $res["level_rate"] = 0; //百分0 if($res["level_start"] == $res["level_end"]) { $res["level_rate"] = 1; } } else { $res["level_rate"] = intval(($r2/$r1)*100)/100; } $res["to_up_need"] = $r3>0?$r3:0; // // 满级 // if($r3 == 0 && !$userexplainend) { // $res["level_rate"] = 1; // } //规则 $rule = config('site.caifulevel_rule'); $new_rule = []; foreach($rule as $title => $info){ $new_rule[] = [ 'title'=>$title, 'info'=>$info, ]; } $res['rule'] = $new_rule; $this->success("获取成功!",$res); } ///////////////////////////没用到//////////////////////// /** * 获取关注人列表.派对信息 */ public function getFollowsLive() { $is_online = $this->request->request("is_online");// 是否在线:1=直播中,0=未开播 $page = $this->request->request('page',1); // 分页 $pageNum = $this->request->request('pageNum',10); // 分页 // 分页搜索构建 $pageStart = ($page-1)*$pageNum; $is_online == 1 || $is_online = 0; $fanfollowModel = new \app\common\model\UserFansFollow(); $where = []; $where["a.fans_id"] = $this->auth->id; $where["p.room_type"] = 2; $where["p.is_online"] = $is_online; if($is_online == 1) { $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"; } else { $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"; } $list = $fanfollowModel->alias("a") ->field($field) ->join("hx_user u","u.id = a.user_id") ->join("hx_party p","p.user_id = a.user_id") ->join("hx_party_type t","t.id = p.party_type","left") ->limit($pageStart,$pageNum) ->where($where)->select(); if($list) { foreach($list as $k => $v) { $mod = isset($v["party_type"])?intval($v["party_type"])%5:1; if(isset($v["type_name"]) && $v["type_name"]) { $type_name = $v["type_name"]; } else { $type_name = "普通房"; } $list[$k]["party_type"] = $type_name; $list[$k]["party_type_color"] = $mod == 0?5:$mod; } $this->success("获取成功!",$list); } else { $this->success("数据为空!",[]); } } /** * redis 数据恢复---非redis数据丢失请勿使用!!!! */ /*public function shujuhuifu() { $key = $this->request->request("key");// 操作验证 123456 if($key != 123456) { $this->error(__('Invalid parameters')); } $giftuserpartyModel = new \app\common\model\GiftUserParty(); $redis = new Redis(); $redisconfig = config("redis"); $redis->connect($redisconfig["host"], $redisconfig["port"]); if ($redisconfig['redis_pwd']) { $redis->auth($redisconfig['redis_pwd']); } if($redisconfig['redis_selectdb'] > 0){ $redis->select($redisconfig['redis_selectdb']); } // 获取本周第一天 $weekday = $this->firstOfWeek(date("Y-m-d H:i:s")); // 获取本月第一天 $monthday = date("Ym01"); $where = []; $where["createtime"] = ["gt",strtotime($weekday)]; $list1 = $giftuserpartyModel->where($where)->select(); foreach($list1 as $k => $v) { // 添加redis记录做魅力排行榜周榜用 $redis->zIncrBy("jewel_get_".$v["party_id"].":".$weekday,$v["value"],$v["user_to_id"]); // 添加redis记录做财富排行榜周榜用 $redis->zIncrBy("jewel_to_".$v["party_id"].":".$weekday,$v["value"],$v["user_id"]); } $where = []; $where["createtime"] = ["gt",strtotime(date("Y-m-01"))]; $list2 = $giftuserpartyModel->where($where)->select(); foreach($list2 as $k => $v) { // 添加redis记录做魅力排行榜月榜用 $redis->zIncrBy("jewel_get_".$v["party_id"].":".$monthday,$v["value"],$v["user_to_id"]); // 添加redis记录做财富排行榜月榜用 $redis->zIncrBy("jewel_to_".$v["party_id"].":".$monthday,$v["value"],$v["user_id"]); } $this->success("执行成功!"); }*/ /** * 获取用户等级说明 */ public function getLevelExplain() { $data = \app\common\model\UserLevelExplain::field("title,content")->select(); return $this->success("获取成功!",$data); } /** * 获取用户等级信息 */ public function getUserLevelInfo() { $res = [];$exstart = 0;$exend = 0; $userModel = new \app\common\model\User(); $userInfo = $userModel->field("id,nickname,avatar,level,empirical")->where(["id"=>$this->auth->id])->find(); if(!$userInfo) { $this->error("用户信息获取失败!"); } $res["avatar"] = $userInfo['avatar']; $res["nickname"] = $userInfo['nickname']; // 获取用户当前经验值对应等级 $userconfigModel = new \app\common\model\UserLevelConfig(); $where = []; $where["empirical"] = ["elt",$userInfo["empirical"]]; $userexplainstart = $userconfigModel->where($where)->order("empirical","desc")->limit(1)->select(); $where = []; $where["empirical"] = ["gt",$userInfo["empirical"]]; $userexplainend = $userconfigModel->where($where)->order("empirical","asc")->limit(1)->select(); if(!$userexplainstart && !$userexplainend) { $this->error("经验等级信息获取失败!"); } elseif(!$userexplainstart && $userexplainend) { $res["level_start"] = 0; $res["level_end"] = $userexplainend[0]["level"]; } elseif($userexplainstart && !$userexplainend) { $res["level_start"] = $userexplainstart[0]["level"]; $res["level_end"] = $userexplainstart[0]["level"]; } elseif($userexplainstart && $userexplainend) { $res["level_start"] = $userexplainstart[0]["level"]; $res["level_end"] = $userexplainend[0]["level"]; } $userexplainstart && $exstart = $userexplainstart[0]["empirical"]; $userexplainend && $exend = $userexplainend[0]["empirical"]; $r1 = $exend-$exstart; // 等级经验值差 $r2 = $userInfo["empirical"]-$exstart; // 当前等级与最低等级经验值差 $r3 = $exend-$userInfo["empirical"]; // 还需多少经验值升级 if($r1 == 0) { $res["level_rate"] = 1; } elseif($r2 == 0) { $res["level_rate"] = 0; if($res["level_start"] == $res["level_end"]) { $res["level_rate"] = 1; } } else { $res["level_rate"] = intval(($r2/$r1)*100)/100; } $res["to_up_need"] = $r3>0?$r3:0; // // 满级 // if($r3 == 0 && !$userexplainend) { // $res["level_rate"] = 1; // } $this->success("获取成功!",$res); } }