[laravel数据统计绘图(今天、7天、30天数据)]
$time = 7;
$data_arr = Info::where('created_at','<', Carbon::now())
->where('created_at','>', $time > 1 ? Carbon::today()->subDays($time):Carbon::today())
->select([$time > 1 ? DB::raw('DATE(created_at) as time') : DB::raw('DATE_FORMAT(created_at,\'%H\') as time'), DB::raw('COUNT("*") as count')])
->groupBy('time')
->get();
网友评论