xinglian/application/api/controller/Uservisit.php

<?php

namespace app\api\controller;

use app\common\controller\Api;
use think\Db;
/**
 * 访问足迹
 */
class Uservisit extends Api
{
    protected $noNeedLogin = [];
    protected $noNeedRight = ['*'];

    //我的访问列表
    public function my_visit_list(){

        $list = Db::name('user_visit')
            ->alias('visit')
            ->join('user','visit.to_uid = user.id','LEFT')
            ->join('user_remark ur', 'ur.to_user_id = user.id and ur.user_id = '.$this->auth->id, 'LEFT')
            ->field('user.id,user.nickname,user.avatar,user.bio,user.birthday,user.gender,ur.nickname_remark')
            ->where('visit.uid',$this->auth->id)->order('visit.updatetime desc')->autopage()->select();

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

        foreach ($list as &$val) {
            $val['nickname'] = !empty($val['nickname_remark']) ? $val['nickname_remark'] : $val['nickname'];
        }

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


    //访问我的人列表
    public function visit_me_list(){
        $time = Db::name('user_visit_time')->where(['user_id' => $this->auth->id])->find();
        if ($time) {
            Db::name('user_visit_time')->where(['user_id' => $this->auth->id])->setField('visittime', time());
        } else {
            Db::name('user_visit_time')->insertGetId(['user_id' => $this->auth->id, 'visittime' => time()]);
        }

        $list = Db::name('user_visit')
            ->alias('visit')
            ->join('user','visit.uid = user.id','LEFT')
            ->join('user_remark ur', 'ur.to_user_id = user.id and ur.user_id = '.$this->auth->id, 'LEFT')
            ->field('user.id,user.nickname,user.avatar,visit.updatetime,ur.nickname_remark')
            ->where('visit.to_uid',$this->auth->id)->order('visit.updatetime desc')->autopage()->select();

        $list = list_domain_image($list,['avatar']);
//        $list = list_birthday_age($list);
        //查询会员
        $vip_endtime = Db::name('user_wallet')->where(['user_id' => $this->auth->id])->value('vip_endtime');
        if ($this->auth->gender == 1 && $vip_endtime < time()) {
            $is_show = 0;
        } else {
            $is_show = 1; //是否正常显示信息: 1显示  0不显示
        }

        $mt_user_greet = Db::name('user_greet'); //是否打过招呼
        foreach ($list as &$v) {
            $v['updatetime'] = get_last_time($v['updatetime']);
            $v['is_show'] = $is_show;
            //查询是否搭讪过
            $count = $mt_user_greet->where(['user_id' => $this->auth->id, 'user_to_id' => $v['id']])->count('id');
            if ($count) {
                $v['is_chat'] = 1; //是否打过招呼: 1是  0否
            } else {
                $v['is_chat'] = 0; //是否打过招呼: 1是  0否
            }
            if ($is_show == 0) {
                $v['id'] = 0;
                $v['nickname'] = 'Ta偷偷来过';
                $v['avatar'] = config('avatar_girl');
            }

            $v['nickname'] = !empty($v['nickname_remark']) ? $v['nickname_remark'] : $v['nickname'];

        }

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


    //谁看过我汇总
    public function visitlist(){
        $time = Db::name('user_visit_time')->where(['user_id' => $this->auth->id])->value('visittime');

        $where = [];
        if ($time) {
            $where['updatetime'] = ['gt', $time];
        }

        $list = [];
        $count = Db::name('user_visit')->where(['to_uid' => $this->auth->id])->where($where)->count('id');
        if ($count) {
            $uid_list = Db::name('user_visit')->field('uid')->where(['to_uid' => $this->auth->id])->where($where)->limit(9)->column('uid');
            $mt_user = Db::name('user');
            foreach ($uid_list as &$v) {
                $avatar = $mt_user->where(['id' => $v])->value('avatar');
                $list[] = one_domain_image($avatar);
            }
        }

        $data['count'] = $count;
        $data['list'] = $list;

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

    //查看某人
    public function visit_one(){
       //放到usercenter/getuserinfo里了
    }


}