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中实现事务回滚的方法)
- laravel数据迁移(Laravel框架实现的上传图片到七牛功能详解)
- laravel队列是如何触发的(laravel使用Faker数据填充的实现方法)
- laravel指定管理员(在laravel-admin中列表中禁止某行编辑、删除的方法)
- laravel实现跨域访问(使用laravel和ajax实现整个页面无刷新的操作方法)
- laravel线上如何调试(解决Laravel 不能创建 migration 的问题)
- laravel框架的运行机制(Laravel5框架自定义错误页面配置操作示例)
- laravel关联查询限制数量(laravel-admin 后台表格筛选设置默认的查询日期方法)
- laravel循环插入数据(Laravel 实现关系模型取出需要的字段)
- laravel如何设置默认模块(Laravel框架控制器的middleware中间件用法分析)
- laravel授权怎么用(laravel 使用auth编写登录的方法)
- laravel认证系统(Laravel框架Auth用户认证操作实例分析)
- laravel语法有哪些(对laravel in 查询的使用方法详解)
- laravel count 报错(解决laravel5.5访问public报错的问题)
- laravel设置跨域请求(Laravel实现ApiToken认证请求)
- laravel数据转换层(laravel通过a标签从视图向控制器实现传值)
- 美国数十万加仑牛奶倒入下水道,贫民区食不果腹,历史再次重演(美国数十万加仑牛奶倒入下水道)
- 美国倒掉数十万加仑牛奶 上热搜第一,这一幕似曾相识(美国倒掉数十万加仑牛奶)
- 深度 倒牛奶 这一幕为何又在美国上演(深度倒牛奶)
- 美国数十万加仑牛奶倒下水道怎么回事 原因曝光令人心痛(美国数十万加仑牛奶倒下水道怎么回事)
- 探索中国神秘文字(探索中国神秘文字)
- 重温《蜗居》 宋思明选中海藻为红颜知己,纯属巧合,与爱无关(宋思明选中海藻为红颜知己)
热门推荐
- php依赖注入和控制反转的区别(php反射学习之依赖注入示例)
- 如何实现让dede三级栏目数据调用(dede调取三级栏目名及栏目下的内容列表的方法)
- 用python实现atm银行系统(Python实现的银行系统模拟程序完整案例)
- docker安装详细教程linux(linux中docker的安装教程)
- jquerycss3轮播案例(CSS3实现列表无限滚动/轮播效果)
- navicat如何连接sql数据库(Navicat 连接SQLServer数据库图文步骤)
- 数据库sql语句大全及例题(数据库之SQL技巧整理案例)
- python ssh登录服务器(python利用跳板机ssh远程连接redis的方法)
- 表空间不足无法登录(System表空间不足的报警问题浅析)
- VS调试时无法命中断点
排行榜
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9