无为清净楼资源网 Design By www.qnjia.com
获取七天以前到现在的数据:
$days = Input::get('days', 7); $range = \Carbon\Carbon::now()->subDays($days); $stats = User::where('created_at', '>=', $range) ->groupBy('date') ->orderBy('date', 'DESC') ->get([ DB::raw('Date(created_at) as date'), DB::raw('COUNT(*) as value') ]);
SELECT sum(case when `EmailSource`='FM' then 1 else 0 end) as FM_Statistic, sum(case when `EmailSource`='UOC' then 1 else 0 end) as UOC_Statistic, sum(case when `EmailSource`='OC' then 1 else 0 end) as OC_Statistic, DATE_FORMAT(Date,'%Y-%m-%d') AS `DateTime` FROM `user_performance` WHERE Email != '' AND Email != 'TOTAL' AND (DATE_FORMAT(Date,'%Y-%m-%d') >= DATE_FORMAT('2011-02-5','%Y-%m-%d')) AND (DATE_FORMAT(Date,'%Y-%m-%d') <= DATE_FORMAT('2011-03-07','%Y-%m-%d')) GROUP BY `Date`
public function getNumber() { $data = []; $customers = Customer::all(['id', 'customer_type', 'created_at']); #今天数据 $data['customer_today'] = Customer::where('customer_type', 1)->where('created_at', Carbon::today())->count(); $data['teacher_today'] = Customer::where('customer_type', 2)->where('created_at', Carbon::today())->count(); #昨天数据 $data['customer_yesterday'] = Customer::where('customer_type', 1)->where('created_at', Carbon::yesterday())->count(); $data['teacher_yesterday'] = Customer::where('customer_type', 2)->where('created_at', Carbon::yesterday())->count(); $data['today'] = $data['customer_today'] + $data['teacher_today']; $data['yesterday'] = $data['customer_yesterday'] + $data['teacher_yesterday']; // 本周数据 $this_week = [Carbon::now()->startOfWeek(), Carbon::now()->endOfWeek()]; $data['customer_this_week'] = Customer::where('customer_type', 1)->whereBetween('created_at', $this_week)->count(); $data['teacher_this_week'] = Customer::where('customer_type', 2)->whereBetween('created_at', $this_week)->count(); // 上周数据 $last_week = [Carbon::now()->startOfWeek()->subWeek(), Carbon::now()->endOfWeek()->subWeek()]; $data['customer_last_week'] = Customer::where('customer_type', 1)->whereBetween('created_at', $last_week)->count(); $data['teacher_last_week'] = Customer::where('customer_type', 2)->whereBetween('created_at', $last_week)->count(); $data['this_week'] = $data['customer_this_week'] + $data['teacher_this_week']; $data['last_week'] = $data['customer_last_week'] + $data['teacher_last_week']; // 本月数据 $data['customer_this_month'] = Customer::where('customer_type', 1)->whereMonth('created_at', Carbon::now()->month)->count(); $data['teacher_this_month'] = Customer::where('customer_type', 2)->whereMonth('created_at', Carbon::now()->month)->count(); // 上月数据 $data['customer_last_month'] = Customer::where('customer_type', 1)->whereMonth('created_at', Carbon::now()->subMonth()->month)->count(); $data['teacher_last_month'] = Customer::where('customer_type', 2)->whereMonth('created_at', Carbon::now()->subMonth()->month)->count(); $data['this_month'] = $data['customer_this_month'] + $data['teacher_this_month']; $data['last_month'] = $data['customer_last_month'] + $data['teacher_last_month']; // 本年数据 $data['customer_this_year'] = Customer::where('customer_type', 1)->whereYear('created_at', Carbon::now()->year)->count(); $data['teacher_this_year'] = Customer::where('customer_type', 2)->whereYear('created_at', Carbon::now()->year)->count(); $data['today_login_users'] = LoginLog::whereDate('created_at', '=', Carbon::today()) ->groupBy('customer_id') ->orderBy('customer_id') ->count(); $data['yesterday_login_users'] = LoginLog::whereDate('created_at', '=', Carbon::yesterday()) ->groupBy('customer_id') ->orderBy('customer_id') ->count(); $data['this_month_login_users'] = LoginLog::whereMonth('created_at', Carbon::now()->month) ->groupBy('customer_id') ->orderBy('customer_id') ->count(); $data['last_month_login_users'] = LoginLog::whereMonth('created_at', Carbon::now()->subMonth()->month) ->groupBy('customer_id') ->orderBy('customer_id') ->count(); return $data; }
public function numberCount() { $days = request('days', 7); $range = Carbon::today()->subDays($days); $day_stats = Customer::where('created_at', '>=', $range) ->groupBy('date') ->orderBy('date', 'DESC') ->get([ \DB::raw('DATE_FORMAT(created_at,\'%Y-%m-%d\') as date,SUM(CASE WHEN customer_type = 1 THEN 1 ELSE 0 END) AS customer,SUM(CASE WHEN customer_type = 2 THEN 1 ELSE 0 END) AS teacher'), ]) ->toJSON(); $week_stats = Customer::groupBy('week') ->orderBy('week', 'DESC') ->get([ \DB::raw('DATE_FORMAT(created_at,\'%Y W%u\') as week,SUM(CASE WHEN customer_type = 1 THEN 1 ELSE 0 END) AS customer, SUM(CASE WHEN customer_type = 2 THEN 1 ELSE 0 END) AS teacher'), ]) ->toJSON(); // dd($week_stats); // \DB::enableQueryLog(); $month_stats = Customer::groupBy('month') ->orderBy('month', 'DESC') ->get([ \DB::raw('DATE_FORMAT(created_at,\'%Y-%m\') as month,SUM(CASE WHEN customer_type = 1 THEN 1 ELSE 0 END) AS customer,SUM(CASE WHEN customer_type = 2 THEN 1 ELSE 0 END) AS teacher'), ]) ->toJSON(); // dd(\DB::getQueryLog()); // dd($week_stats, $month_stats); $data = $this->getNumber(); // dd($day_stats, $week_stats, $month_stats, $data); return view('admin.numberCount', compact('day_stats', 'week_stats', 'month_stats', 'data')); }
效果图:
以上这篇Laravel统计一段时间间隔的数据方法就是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持。
标签:
Laravel,统计,时间,数据
无为清净楼资源网 Design By www.qnjia.com
广告合作:本站广告合作请联系QQ:858582 申请时备注:广告合作(否则不回)
免责声明:本站文章均来自网站采集或用户投稿,网站不提供任何软件下载或自行开发的软件! 如有用户或公司发现本站内容信息存在侵权行为,请邮件告知! 858582#qq.com
免责声明:本站文章均来自网站采集或用户投稿,网站不提供任何软件下载或自行开发的软件! 如有用户或公司发现本站内容信息存在侵权行为,请邮件告知! 858582#qq.com
无为清净楼资源网 Design By www.qnjia.com
暂无评论...
更新日志
2024年09月25日
2024年09月25日
- 刘宇.2024-宇宙诗人【哔哟哔哟文化】【FLAC分轨】
- 《全景声白噪音》沉浸式大自然助眠 带你听自然的声音[mp3]
- 纯音入心系列纯音乐《古筝精选 十指弹一赏心曲一心奏出世人心》1CD[MP3][582MB]
- 纯音入心系列纯音乐《古筝与现代音乐的交织》1CD[MP3][96MB]
- 王俪婷.2011-ROMANCE【华研国际】【WAV+CUE】
- 狮子合唱团.2016-LION(引进版)【华纳】【WAV+CUE】
- 范文芳.1996-FNNTASY【HYPE】【WAV+CUE】
- 纯音入心系列纯音乐《韵味古筝曲》1CD[MP3][146.2MB]
- 纯音入心系列纯音乐《古筝系列-传统乐曲》1CD[MP3][974.7MB]
- 纯音入心系列纯音乐《古筝系列-弦凝指咽声停处》1CD[MP3][656.5MB]
- 群星.1994-大烂片2辑【派森】【WAV+CUE】
- 吴倩莲.1997-望爱【EMI百代】【WAV+CUE】
- 杨千嬅.2002-万紫千红演唱会2CD(2024环球红馆40复刻系列)【环球】【WAV+CUE】
- 郭采洁.2015-Begin.Again爱造飞鸡【华纳】【FLAC分轨】
- 许志安.2011-ON.AND.ON【东亚】【WAV+CUE】