php查询排序 根据时间进行查询

 

 

设置查询      
$result = \app\user\model\Collection::where('user_id', $user['id'])
            ->where('type',3)
            ->order('create_time desc')
            ->field('aid,collect_id,user_id,type,collect_title,collect_img,collect_price,collect_sales,create_time')
            ->paginate();
        $arr=[];
        if ($result) {
            $result=$result->toArray();
            $total=$result['total'];
            $page=$result['current_page'];
            $last_page=$result['last_page'];
            foreach ($result['data'] as $k=>$v){
//                $time=date('Y年m月d日',strtotime($v['create_time']));
                $time=$this->formatTime($v['create_time']);
                $arr[$time]['year_month_day']=$time;
                $arr[$time]['data'][]=$v;
            }
            $arr= array_values($arr);
            $arrs=['data'=>$arr,'current_page'=>$page,'total'=>$total,'last_page'=>$last_page];

            return ApiReturn::r(1, $arrs, '请求成功');
        } else {
            return ApiReturn::r(1, [], '暂无数据');
        }

　　　　//设置友好时间
    public static function formatTime($time)
    {
        if (is_int($time)) {
            $time = intval($time);
        } elseif ($time instanceof Carbon) {
            $time = intval(strtotime($time));
        } else {
            return '';
        }

        $ctime = time();
        $t = $ctime - $time; //时间差 （秒）
        if ($t < 0) {
            return date('Y-m-d', $time);
        }
        $y = intval(date('Y', $ctime) - date('Y', $time));//是否跨年
        /**/
        $today=strtotime(date('Y-m-d',strtotime('0 day')));
        if($time > $today) {//一天内
            $text = '今天'; // 一天内
        } elseif ($t < 2592000) {//30天内
            if ($time > strtotime(date('Ymd', strtotime("-1 day")))) {
                $text = '昨天';
            } elseif ($time > strtotime(date('Ymd', strtotime("-2 days")))) {
                $text = '前天';
            } else {
                $text=date('Y.m.d',$time);
//                $text = floor($t / 86400) . '天前';
            }
        } elseif ($t < 31536000 && $y == 0) {//一年内 不跨年
            $m = date('m', $ctime) - date('m', $time) - 1;
            if ($m == 0) {
                $text=   date('Y.m.d',$time);
//                $text = floor($t / 86400) . '天前';
            } else {
                $text=   date('Y.m.d',$time);
//                $text = $m . '个月前';
            }
        } elseif ($t < 31536000 && $y > 0) {//一年内 跨年
            $text=date('Y.m.d',$time);
//            $text = (12 - date('m', $time) + date('m', $ctime)) . '个月前';
        } else {
            $text=   date('Y.m.d',$time);
//            $text = (date('Y', $ctime) - date('Y', $time)) . '年前';
        }
        return $text;
    }