laravel请求耗时(Laravel统计一段时间间隔的数据方法)
类别:编程学习 浏览量:2397
时间:2021-10-13 00:28:59 laravel请求耗时
Laravel统计一段时间间隔的数据方法获取七天以前到现在的数据:
- $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统计一段时间间隔的数据方法就是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持我们。
原文链接:https://blog.csdn.net/zhezhebie/article/details/78622534
您可能感兴趣
- laravel初始化(Laravel 登录后清空COOKIE的操作方法)
- Laravel 中创建 Zip 压缩文件并提供下载的实现方法(Laravel 中创建 Zip 压缩文件并提供下载的实现方法)
- laravel服务器设置教程(laravel框架模型、视图与控制器简单操作示例)
- laravel检查关联模型(Laravel 关联模型-关联新增和关联更新的方法)
- laravel消息机制(laravel框架中间件 except 和 only 的用法示例)
- laravel终止函数执行(laravel 输出最后执行sql 附:whereIn的使用方法)
- laravel接口规范(Laravel5.5 手动分页和自定义分页样式的简单实现)
- laravel定时脚本(laravel实现按时间日期进行分组统计方法示例)
- laravel框架学习心得教程(Laravel5.7 Eloquent ORM快速入门详解)
- laravel自定义命令(laravel中数据显示方法默认值和下拉option默认选中)
- laravel验证码依赖(laravel5.2表单验证,并显示错误信息的实例)
- laravel关于视图使用语法(在laravel中使用with实现动态添加where条件)
- laravel授权怎么用(laravel 使用auth编写登录的方法)
- laravel队列流程(Laravel 创建指定表 migrate的例子)
- laravel数据绑定(laravel-admin表单提交隐藏一些数据,回调时获取数据的方法)
- laravel框架的业务流程顺序(Laravel+Dingo/Api 自定义响应的实现)
- 《刘老根3》热播,去世15年的她却再次被 伤害(去世15年的她却再次被)
- 十二星座爱情支配欲指数(十二星座爱情支配欲指数)
- 虐待儿童是发泄支配欲的愚蠢行为(虐待儿童是发泄支配欲的愚蠢行为)
- 你或许不知道你隐藏的支配欲望(你或许不知道你隐藏的支配欲望)
- 把宽体丰田86卖了,换成7.5代高尔夫GTI玩起姿态与性能并存的改装(把宽体丰田86卖了)
- 大众推出了第五代高尔夫GT(大众推出了第五代高尔夫GT)
热门推荐
- mysql数据表的创建与管理(MySQL数据操作-DML语句的使用)
- dedecms怎么调用标签(织梦DEDECMS dede:arclist,dede:list获取附加表字段内容的方法)
- sqlserver判断null(SQL Server索引超出了数组界限的解决方案)
- python获取excelsheet名称(python查询文件夹下excel的sheet名代码实例)
- localstorage可以存多少(解决localstorage存储boolean类型值的小坑)
- SQL group by分组查询
- extjs anchor 锚点布局
- sqlserver2016的安装(Sql Server2016 正式版安装程序图解教程)
- pandas如何指定空数据类型(解决Pandas的DataFrame输出截断和省略的问题)
- python里range循环(Python for循环与range函数的使用详解)
排行榜
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9