chengluApp/app/Services/HomeService.php

<?php


namespace App\Services;


use App\Http\Params\UserCommentParam;
use App\Http\Params\UserLikeParam;
use App\Models\User;
use App\Models\UserComment;
use App\Models\UserInfoModel;
use App\Models\UserLikeModel;
use Illuminate\Support\Facades\DB;
use PHPUnit\Util\Exception;

class HomeService
{
    /**
     * 获取首页内容
     * @param $param
     */
    public function get_list($param){

        $query = User::query()
            ->leftJoin("users_info",'users.id','=','users_info.user_id')
            ->select(['users.id','users.is_vip','users.tencent_im_user_id','users.sex','users.is_auth','users.latitude','users.longitude','users.online','users_info.avatar','users_info.nickname','users_info.area','users_info.birthday','users_info.height','users_info.weight'])
            ->addSelect(DB::raw("acos(cos(" .$param['latitude'] . "*pi()/180)*cos(cl_users.latitude*pi()/180)*cos(" . $param['longitude'] . "*pi()/180-cl_users.longitude*pi()/180)+sin(" . $param['latitude'] . "*pi()/180)*sin(cl_users.latitude * pi()/180)) * 6367000 AS distance"));

        if($param['keyword']!=""){
            $query = $query->where('users_info.nickname','like','%'.$param['keyword'].'%');
        }
        if($param['online']==1){
            $query = $query->where(['users.online'=>$param['online']]);
        }

        if($param['new']==1){
            $query = $query->orderBy('users.created_at','desc');
        }

        if($param['nearby']==1){
            $query = $query->orderBy('distance','ASC');
        }


        $query = $query->paginate(request('perPage',20));
        $query = $query->toArray();
        foreach ($query['data'] as $k=>$v){
                $query['data'][$k]['age'] =!empty($v['birthday'])? birthday($v['birthday']):0;
                //计算距离
               $query['data'][$k]['distance'] =  $v['distance']>1000?round($v['distance']/1000,2).'km':round($v['distance']).'m';
        }
        return $query;
    }

    //用户详情
    public function user_detail($user_id){
        $user = auth('api')->user();
        $is_like = 0;
        $is_comment = 0;
        if($user){
            //登录状态  增加 谁看了我记录
            look_log($user->id,$user_id);
            if(UserLikeModel::query()->where(['user_id'=>$user->id,'like_id'=>$user_id])->first()){
                $is_like = 1;
            }

            //查询评价

            if(UserComment::query()->where(['user_id'=>$user->id,'comment_id'=>$user_id])->first()){
                $is_comment = 1;
            }
        }
        $userinfo = User::query()
            ->leftJoin('users_info','users.id','=','users_info.user_id')
            ->where('users.id',$user_id)
            ->select(['users.id','users.sex','users.is_auth','users.is_vip','users.tencent_im_user_id','users.online','users_info.*'])
            ->first();
        $userinfo->hobby = !empty($userinfo->hobby)?explode(',',$userinfo->hobby):array();
        $userinfo->photo = !empty($userinfo->photo)?json_decode($userinfo->photo,true):array();
        $userinfo->video = !empty($userinfo->video)?json_decode($userinfo->video,true):array();

        $userinfo->is_like = $is_like;

        //查询评价
        $userinfo->is_comment = $is_comment;
        //评价星级
        $con1_star = UserComment::query()->where(['comment_id'=>$user_id])->avg('con1');
        $con2_star = UserComment::query()->where(['comment_id'=>$user_id])->avg('con2');
        $con3_star = UserComment::query()->where(['comment_id'=>$user_id])->avg('con3');
        $con4_star = UserComment::query()->where(['comment_id'=>$user_id])->avg('con4');
        $total_star = round(($con1_star+$con2_star+$con3_star+$con4_star)/4,1);
        $total_num = UserComment::query()->where(['comment_id'=>$user_id])->count();
        $comment = array();
        $comment['con1_star'] = round($con1_star,1);
        $comment['con2_star'] = round($con2_star,1);
        $comment['con3_star'] = round($con3_star,1);
        $comment['con4_star'] = round($con4_star,1);
        $comment['total_star'] = $total_star;
        $comment['total_num'] = $total_num;
        $userinfo->comment = $comment;
        return $userinfo;
    }

    //用户喜欢
    public function do_like(UserLikeParam $param){
        if(empty($param->like_id)){
            throw new Exception('参数错误');
        }
        $user = User::query()->where(['id'=>$param->like_id])->first();
        if(!$user){
            throw new Exception("用户不存在");
        }
        $is_like = 0;
        if($like = UserLikeModel::query()->where(['user_id'=>$param->user_id,'like_id'=>$param->like_id])->first()){
            $is_like = 0;
            User::query()->where('id',$param->like_id)->decrement('like_me_num',1);
            User::query()->where('id',$param->user_id)->decrement('like_num',1);
            $like->delete();
        }else{
            $is_like = 1;
            User::query()->where('id',$param->like_id)->increment('like_me_num',1);
            User::query()->where('id',$param->user_id)->increment('like_num',1);
            UserLikeModel::query()->create([
               'user_id'=>$param->user_id,
               'like_id'=>$param->like_id,
               'status'=>0,
               'atime'=>date('Y-m-d H:i:s'),
            ]);
        }
        return $is_like;
    }

    //用户评论
    public function do_comment(UserCommentParam $param){
        if(empty($param->comment_id)){
            throw new Exception('参数错误');
        }
        $user = User::query()->where(['id'=>$param->comment_id])->first();
        if(!$user){
            throw new Exception("用户不存在");
        }
        if(UserComment::query()->where(['user_id'=>$param->user_id,'comment_id'=>$param->comment_id])->first()){
            throw new Exception("已经评价过");
        }
        UserComment::query()->create([
           'user_id'=>$param->user_id,
           'comment_id'=>$param->comment_id,
           'con1'=>$param->con1,
           'con2'=>$param->con2,
           'con3'=>$param->con3,
           'con4'=>$param->con4,
        ]);
        return true;
    }

    //解锁微信
    public function get_weixin($user_id){
        if(empty($user_id)){
            throw new Exception('参数错误');
        }
        $user = User::query()->where(['id'=>$user_id])->first();
        if(!$user){
            throw new Exception("用户不存在");
        }
        $weixin = UserInfoModel::query()->where('user_id',$user_id)->value('weixin');
        return $weixin;
    }
}