jianxun/application/api/controller/Userfollow.php

<?php

namespace app\api\controller;

use app\common\controller\Api;
use think\Db;
/**
 * 关注
 */
class Userfollow extends Api
{
    protected $noNeedLogin = [];
    protected $noNeedRight = ['*'];

    //我的关注列表
    public function my_follow_list(){
        $list = Db::name('user_follow')
            ->alias('follow')
            ->join('user','follow.follow_uid = user.id','LEFT')
            ->join('user_wallet uw','user.id = uw.user_id','LEFT')
            ->field('user.id,user.username,user.nickname,user.avatar,user.bio,user.birthday,user.gender,user.attribute,uw.vip_endtime')
            ->where('follow.uid',$this->auth->id)->order('follow.id desc')->autopage()->select();

        $list = list_domain_image($list,['avatar']);
        $list = list_birthday_age($list);

        if(!empty($list)){
            foreach($list as $key => &$val){
                //用户vip
                $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0;
                unset($val['vip_endtime']);
                //是否关注
                $val['is_follow'] = 1;
            }
        }

        $this->success('success',$list);
    }

    //我的粉丝列表
    public function my_fans_list(){
        $list = Db::name('user_follow')
            ->alias('follow')
            ->join('user','follow.uid = user.id','LEFT')
            ->join('user_wallet uw','user.id = uw.user_id','LEFT')
            ->field('user.id,user.username,user.nickname,user.avatar,user.bio,user.birthday,user.gender,user.attribute,uw.vip_endtime')
            ->where('follow.follow_uid',$this->auth->id)->order('follow.id desc')->autopage()->select();

        $list = list_domain_image($list,['avatar']);
        $list = list_birthday_age($list);

        //我的关注uids
        $my_follow_uids = $this->my_follow_uids();

        if(!empty($list)){
            foreach($list as $key => &$val){
                //用户vip
                $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0;
                unset($val['vip_endtime']);
                //是否关注
                $val['is_follow'] = in_array($val['id'],$my_follow_uids) ? 1 : 0;
            }
        }

        $this->success('success',$list);
    }

    //我的好友,拿粉丝列表改的
    public function my_friend_list(){
        $list = Db::name('user_follow')
            ->alias('follow')
            ->join('user','follow.uid = user.id','LEFT')
            ->join('user_wallet uw','user.id = uw.user_id','LEFT')
            ->field('user.id,user.username,user.nickname,user.avatar,user.bio,user.birthday,user.gender,user.attribute,uw.vip_endtime')
            ->where('follow.follow_uid',$this->auth->id)->order('follow.id desc')->autopage()->select();

        $list = list_domain_image($list,['avatar']);
        $list = list_birthday_age($list);

        //我的关注uids
        $my_follow_uids = $this->my_follow_uids();

        $new_rs = []; //另起
        if(!empty($list)){
            foreach($list as $key => &$val){
                //用户vip
                $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0;
                unset($val['vip_endtime']);
                //是否关注
                $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);
    }

    //好友审核列表。粉丝列表改的。关注了我，我还没关注他的
    //接口转移了，使用 newfriend_list
    public function my_fans_unfollow_list(){

        $this->newfriend_list();
        //我的关注uids
        $my_follow_uids = $this->my_follow_uids();

        $list = Db::name('user_follow')
            ->alias('follow')
            ->join('user','follow.uid = user.id','LEFT')
            ->join('user_wallet uw','user.id = uw.user_id','LEFT')
            ->field('user.id,user.username,user.nickname,user.avatar,user.bio,user.birthday,user.gender,user.attribute,uw.vip_endtime')
            ->where('follow.follow_uid',$this->auth->id)->where('user.id','NOT IN',$my_follow_uids)->order('follow.id desc')->autopage()->select();

        $list = list_domain_image($list,['avatar']);
        $list = list_birthday_age($list);

        if(!empty($list)){
            foreach($list as $key => &$val){
                //用户vip
                $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0;
                unset($val['vip_endtime']);
                //是否关注
                $val['is_follow'] = in_array($val['id'],$my_follow_uids) ? 1 : 0;
            }
        }

        $this->success('success',$list);
    }

    //好友待审核列表。
    public function newfriend_list(){
        //我的关注uids
        $my_follow_uids = $this->my_follow_uids();
//        dump($my_follow_uids);
        //向我发起好友消息的人，未读
        $user_ids = Db::name('message')->where('infotype','newfriend')->where('user_id',$this->auth->id)->where('status',0)->order('id desc')->column('infotype_id');
//        dump($user_ids);
        $list = [];
        if(!empty($user_ids)){
            $user_ids_str = implode(',',$user_ids);
            $list = Db::name('user')->alias('user')
                ->join('user_wallet uw','user.id = uw.user_id','LEFT')
                ->field('user.id,user.username,user.nickname,user.avatar,user.bio,user.birthday,user.gender,user.attribute,uw.vip_endtime')
                ->where('user.id','IN',$user_ids)
                ->where('user.id','NOT IN',$my_follow_uids)
                ->orderRaw('field(user.id,'.$user_ids_str.')')->autopage()->select();

            $list = list_domain_image($list,['avatar']);
            $list = list_birthday_age($list);

            if(!empty($list)){
                foreach($list as $key => &$val){
                    //用户vip
                    $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0;
                    unset($val['vip_endtime']);
                    //是否关注
                    $val['is_follow'] = in_array($val['id'],$my_follow_uids) ? 1 : 0;
                }
            }
        }

        $this->success('success',$list);
    }


    //关注某人
    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();
        $id = Db::name('user_follow')->insertGetId($map);
        if(!$id){
            Db::rollback();
            $this->error('关注失败');
        }

        //被关注人如果没有关注我，发一条消息，让他加好友，也就是让他回关
        $map2 = [
            'uid' => $follow_uid,
            'follow_uid' => $this->auth->id,
        ];

        $check = Db::name('user_follow')->where($map2)->find();
        if(empty($check) && $this->user_power($this->auth->id,'yinsi') != 1){
            $message = [
                'user_id' => $follow_uid,
                'title'   => '好友请求',
                'content' => '有人关注了你，回关TA成为好友',
                'createtime' => time(),
                'status' => 0,
                'infotype' => 'newfriend',//关注，请求好友
                'infotype_id' => $this->auth->id,
            ];
            Db::name('message')->insertGetId($message);
        }

        

        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');
    }
}