alias('follow') ->join('user','follow.follow_uid = user.id','LEFT') ->field('user.id,user.u_id,user.username,user.nickname,user.avatar,user.desc,user.gender,follow.createtime') ->where('follow.uid',$this->auth->id) ->where($where_search) ->order('follow.id desc')->autopage()->select(); $list = list_domain_image($list,['avatar']); if(!empty($list)){ foreach($list as $key => &$val){ $val['createtime_text'] = get_last_time($val['createtime']); //是否关注 $val['is_follow'] = 1; } } $this->success('success',$list); } //我的粉丝列表 public function my_fans_list(){ $where_search = []; $keyword = input('keyword',''); if(!empty($keyword)){ $where_search['user.u_id|user.nickname'] = $keyword; } $list = Db::name('user_follow') ->alias('follow') ->join('user','follow.uid = user.id','LEFT') ->field('user.id,user.u_id,user.username,user.nickname,user.avatar,user.desc,user.gender,follow.createtime') ->where('follow.follow_uid',$this->auth->id) ->where($where_search) ->order('follow.id desc')->autopage()->select(); $list = list_domain_image($list,['avatar']); //我的关注uids $my_follow_uids = $this->my_follow_uids(); if(!empty($list)){ foreach($list as $key => &$val){ $val['createtime_text'] = get_last_time($val['createtime']); //是否关注 $val['is_follow'] = in_array($val['id'],$my_follow_uids) ? 1 : 0; } } $this->success('success',$list); } //我的好友,拿粉丝列表改的 public function my_friend_list(){ $where_search = []; $keyword = input('keyword',''); if(!empty($keyword)){ $where_search['user.u_id|user.nickname'] = $keyword; } $list = Db::name('user_follow') ->alias('follow') ->join('user','follow.uid = user.id','LEFT') ->field('user.id,user.u_id,user.username,user.nickname,user.avatar,user.desc,user.gender') ->where('follow.follow_uid',$this->auth->id) ->where($where_search) ->order('follow.id desc')->autopage()->select(); $list = list_domain_image($list,['avatar']); //我的关注uids $my_follow_uids = $this->my_follow_uids(); $new_rs = []; //另起 if(!empty($list)){ foreach($list as $key => &$val){ //是否关注 $val['is_follow'] = in_array($val['id'],$my_follow_uids) ? 1 : 0; //我的粉丝,且是我的关注的,另起 if($val['is_follow'] == 1){ $new_rs[] = $val; } } } $this->success('success',$new_rs); } //关注某人 public function follow_one(){ $follow_uid = input('follow_uid',0); if(!$follow_uid){ $this->error(__('Invalid parameters')); } $checkuser = Db::name('user')->find($follow_uid); if(empty($checkuser)){ $this->error('此用户不存在'); } if($follow_uid == $this->auth->id){ $this->error('不能关注自己'); } $map = [ 'uid' => $this->auth->id, 'follow_uid' => $follow_uid, ]; $check = Db::name('user_follow')->where($map)->find(); if($check){ //取关 $rs = Db::name('user_follow')->where($map)->delete(); $this->success('操作成功'); } Db::startTrans(); $map['createtime'] = time(); $id = Db::name('user_follow')->insertGetId($map); if(!$id){ Db::rollback(); $this->error('关注失败'); } Db::commit(); $this->success('操作成功',$id); } //取关某人 public function un_follow_one(){ $follow_uid = input('follow_uid',0); if(!$follow_uid){ $this->error(__('Invalid parameters')); } $checkuser = Db::name('user')->find($follow_uid); if(empty($checkuser)){ $this->error('此用户不存在'); } $map = [ 'uid' => $this->auth->id, 'follow_uid' => $follow_uid, ]; //不检查,全删 $rs = Db::name('user_follow')->where($map)->delete(); $this->success('操作成功'); } //我的关注uids private function my_follow_uids(){ return Db::name('user_follow')->where('uid',$this->auth->id)->column('follow_uid'); } //我的粉丝uids private function my_fans_uids(){ return Db::name('user_follow')->where('follow_uid',$this->auth->id)->column('uid'); } }