chengluApp/app/Services/NoticeService.php

<?php


namespace App\Services;


use App\Models\DynamicZanModel;
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){

        if($param['type']==1){
            //我喜欢
            $query = UserLikeModel::query();
            $query = $query->with(['like_user'=>function($query){
                $query->select('id','sex','is_vip','tencent_im_user_id');
            },'like_user_info'])->where('user_id',$param['user_id']);

            $query = $query->orderByDesc('id')
                ->paginate(request('perPage',20));
//            $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'])
//                ->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->with(['user'=>function($query){
//                $query->select('id','sex','is_vip','tencent_im_user_id');
//            },'user_info'])->where('like_id',$param['user_id']);
            $query = DB::table('users_like')->union(DB::table('users')->get())->get();
//            $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'])
//                ->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->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){
        $query = DynamicZanModel::query();
        if($param['type']==1){
            //他赞了我
            $query = $query->with(['dynamic','user'=>function($query){
                $query->select('id','sex','is_vip','tencent_im_user_id');
            },'user_info'=>function($query){
                $query->select(['user_id','nickname','avatar','height','weight','work','birthday']);
            }])->whereHas('dynamic',function ($query)use($param){
                $query->where('user_id',$param['user_id'])->select();
            });

            //清除他赞了我未读状态
            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->with(['dynamic'=>function($query){
                $query->select('id','user_id','content','img_url');
            },'dynamic.user'=>function($querty){
                $querty->select('id','sex','is_vip','tencent_im_user_id');
            },'dynamic.user_info'=>function($querty){
                $querty->select(['user_id','nickname','avatar','height','weight','work','birthday']);
            }])
                ->where('user_id',$param['user_id']);
        }
        $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]['dynamic']['img_url'] = json_decode($v['dynamic']['img_url'],true);
        }
        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;
    }


}