chengluApp/app/Services/NoticeService.php

<?php


namespace App\Services;


use App\Models\DynamicZanModel;
use App\Models\UserBlacklistModel;
use App\Models\UserLikeModel;
use App\Models\UserSystemMessageModel;
use Illuminate\Support\Facades\DB;
use PHPUnit\Util\Exception;
use function Symfony\Component\Translation\t;

class NoticeService
{
    /**
     * 获取消息列表
     */
    public function get_notice_list(){

    }

    /**
     * 获取喜欢列表
     */
    public function get_like_list($param){
        $query = UserLikeModel::query();

        //不看拉黑用户
        $black_list = UserBlacklistModel::query()
            ->where('user_id',$param['user_id'])
            ->orWhere('black_id',$param['user_id'])
            ->select(['black_id'])
            ->get()
            ->toArray();
        $ids = array_column($black_list,'black_id');
        $ids[]= $param['user_id'];


        if($param['type']==1){
            //我喜欢
            $query = $query->leftJoin('users','users_like.like_id','=','users.id')
                ->leftJoin('users_info','users_like.like_id','=','users_info.user_id')
                ->where('users_like.user_id',$param['user_id'])
                ->where('users.is_distory',0)
                ->whereNotIn('users_like.like_id',$ids)
                ->select(['users_like.id','users_like.user_id','users_like.like_id','users_like.atime','users.sex','users.is_vip','users.tencent_im_user_id','users_info.nickname','users_info.avatar','users_info.birthday','users_info.work','users_info.height','users_info.weight']);

        }else{
            //喜欢我
            $query = $query->leftJoin('users','users_like.user_id','=','users.id')
                ->leftJoin('users_info','users_like.user_id','=','users_info.user_id')
                ->where('users_like.like_id',$param['user_id'])
                ->where('users.is_distory',0)
                ->whereNotIn('users_like.user_id',$ids)
                ->select(['users_like.id','users_like.user_id','users_like.like_id','users_like.atime','users.sex','users.is_vip','users.tencent_im_user_id','users_info.nickname','users_info.avatar','users_info.birthday','users_info.work','users_info.height','users_info.weight']);
            //清除喜欢我未读状态
            UserLikeModel::query()->where(['like_id'=>$param['user_id'],'status'=>0])->update(['status'=>1]);
        }

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


    /**
     * 获取点赞列表
     */
    public function get_zan_list($param){

        //不看拉黑用户
        $black_list = UserBlacklistModel::query()
            ->where('user_id',$param['user_id'])
            ->orWhere('black_id',$param['user_id'])
            ->select(['black_id'])
            ->get()
            ->toArray();
        $ids = array_column($black_list,'black_id');
        $ids[]= $param['user_id'];


        $query = DynamicZanModel::query();
        if($param['type']==1){
            //他赞了我
            $query = $query
                ->leftJoin('dynamic','dynamic_zan.dynamic_id','=','dynamic.id')
                ->leftJoin('users','dynamic_zan.user_id','=','users.id')
                ->leftJoin('users_info','dynamic_zan.user_id','=','users_info.user_id')
                ->where('dynamic.user_id',$param['user_id'])
                ->where('users.is_distory',0)
                ->whereNotIn('dynamic_zan.user_id',$ids)
                ->select(['dynamic_zan.id','dynamic_zan.atime','dynamic_zan.user_id','dynamic.content','dynamic.img_url','users.sex','users.is_vip','users.tencent_im_user_id','users_info.nickname','users_info.avatar','users_info.birthday','users_info.work','users_info.height','users_info.weight']);

            //清除他赞了我未读状态
            DynamicZanModel::query()->with(['dynamic'])->where('status','=',0)->whereHas('dynamic',function ($query)use($param){
                $query->where('user_id',$param['user_id'])->select('id','user_id','content','img_url');
            })->update(['status'=>1]);
        }else{
            //我赞了他
            $query = $query
                ->leftJoin('dynamic','dynamic_zan.dynamic_id','=','dynamic.id')
                ->leftJoin('users','dynamic.user_id','=','users.id')
                ->leftJoin('users_info','dynamic.user_id','=','users_info.user_id')
                ->where('dynamic_zan.user_id',$param['user_id'])
                ->where('users.is_distory',0)
                ->whereNotIn('dynamic.user_id',$ids)
                ->select(['dynamic_zan.id','dynamic_zan.atime','dynamic.user_id','dynamic.content','dynamic.img_url','users.sex','users.is_vip','users.tencent_im_user_id','users_info.nickname','users_info.avatar','users_info.birthday','users_info.work','users_info.height','users_info.weight']);
        }
        $query = $query->orderByDesc('id')
            ->paginate(request('perPage',20));

        $query = $query->toArray();
        foreach ($query['data'] as $k=>$v){
            $query['data'][$k]['atime'] = uc_time_ago(strtotime($v['atime']));
            $query['data'][$k]['img_url'] = $v['img_url']=='[]'? null :json_decode($v['img_url'],true);
            $query['data'][$k]['age'] = !empty($v['birthday'])?birthday($v['birthday']):0;
        }
        return $query;
    }

    /**
     * 删除消息
     */
    public function del_message($id){
        if(empty($id)){
            throw new Exception("参数错误");
        }
        $user = auth('api')->user();
        if(!$message = UserSystemMessageModel::query()->where(['id'=>$id,'user_id'=>$user->id])->find($id)){
            throw new Exception("消息不存在");
        }
        $message->is_delete = 1;
        $message->save();
        return true;
    }


}