chengluApp/app/Services/NoticeService.php

<?php


namespace App\Services;


use App\Models\DynamicZanModel;
use App\Models\UserLikeModel;
use App\Models\UserSystemMessageModel;
use function Symfony\Component\Translation\t;

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

    }

    /**
     * 获取喜欢列表
     */
    public function get_like_list($param){
        $query = UserLikeModel::query();
        if($param['type']==1){
            //我喜欢
            $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']);
        }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']);

            //清除喜欢我未读状态
            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;  //计算距离
        }
        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($v['atime']);
            $query['data'][$k]['dynamic']['img_url'] = json_decode($v['dynamic']['img_url'],true);
        }
        return $query;
    }


}