您现在的位置是：网站首页> 编程资料编程资料
yii 框架实现按天，月，年，自定义时间段统计数据的方法分析_php实例_
2023-05-25
306人已围观
简介 yii 框架实现按天，月，年，自定义时间段统计数据的方法分析_php实例_
本文实例讲述了yii 框架实现按天，月，年，自定义时间段统计数据的方法。分享给大家供大家参考，具体如下：
天(day)： 格式Y-m-d
月(month)：格式Y-m
年(year)：格式Y
时间段(range)： 格式Y-m-d
首先计算时间
天0-23小时
$rangeTime = range(0, 23);
月：1-月底
// $days = cal_days_in_month(CAL_GREGORIAN, $month, $year); $days = date("t",strtotime($year . '-' . $month)); // 生成1-days的天 $rangeTime = range(1, $days); 年：1-12月
$rangeTime = range(1, 12);
时间段；开始时间-结束时间
$stimestamp = strtotime($time); $etimestamp = strtotime($time2); // 计算日期段内有多少天 $days = ($etimestamp - $stimestamp) / 86400 + 1; // 保存每天日期 for($i = 0; $i < $days; $i++){ $newTimeStamp = $stimestamp + (86400 * $i); $rangeTime[] = date('Y-m-d', $newTimeStamp); $labels[] = date('d', $newTimeStamp) . Yii::t('backend', 'day'); } 封装一下
/** * 获取label和时间段 * type: day, month, year, range * time: 日期； day为具体的天y-m-d， month为具体的月y-m， year为具体的年y * time2 日期， 时间段的第二个时间 */ public function getLabelAndRangeTime($type, $time, $time2) { if(empty($time)) { $time = date('Y-m-d', time()); } $labels = []; $rangeTime = []; if($type == 'day') { // 生成1-24小时 $rangeTime = range(0, 23); foreach ($rangeTime as $key => $val) { $label = $val . Yii::t('backend', 'hour'); $labels[] = $label; } } else if($type == 'month') { $dateArr = explode('-', $time); if(count($dateArr > 1)) { $year = $dateArr[0]; $month = $dateArr[1]; $time = $year; $time2 = $month; // 获取当前年月的天数 // $days = cal_days_in_month(CAL_GREGORIAN, $month, $year); $days = date("t",strtotime($year . '-' . $month)); // 生成1-days的天 $rangeTime = range(1, $days); foreach ($rangeTime as $key => $val) { $label = $val . Yii::t('backend', 'day'); $labels[] = $label; } } } else if($type == 'year') { // 生成1-12月 $rangeTime = range(1, 12); foreach ($rangeTime as $key => $val) { $label = $val . Yii::t('backend', 'month'); $labels[] = $label; } } else if($type == 'range') { $stimestamp = strtotime($time); $etimestamp = strtotime($time2); // 计算日期段内有多少天 $days = ($etimestamp - $stimestamp) / 86400 + 1; // 保存每天日期 for($i = 0; $i < $days; $i++){ $newTimeStamp = $stimestamp + (86400 * $i); $rangeTime[] = date('Y-m-d', $newTimeStamp); $labels[] = date('d', $newTimeStamp) . Yii::t('backend', 'day'); } } return [ 'type' => $type, 'time' => $time, 'time2' => $time2, 'rangeTime' => $rangeTime, 'labels' => $labels ]; } 然后查询数据库
$query = Order::find(); if($type == 'day') { $query = $query->select(['FROM_UNIXTIME(pay_at,"%Y-%m-%d %H") as char_time', 'COUNT(id) as total_order', 'SUM(pay_amount) as total_order_amount']) ->where(['FROM_UNIXTIME(pay_at,"%Y-%m-%d")' => $time]); } else if($type == 'month') { $query = $query->select(['FROM_UNIXTIME(pay_at,"%Y-%m-%d") as char_time', 'COUNT(id) as total_order', 'SUM(pay_amount) as total_order_amount']) ->where(['FROM_UNIXTIME(pay_at,"%Y-%m")' => ($time . '-' . $time2)]); } else if ($type == 'year') { $query = $query->select(['FROM_UNIXTIME(pay_at,"%Y-%m") as char_time', 'COUNT(id) as total_order', 'SUM(pay_amount) as total_order_amount']) ->where(['FROM_UNIXTIME(pay_at,"%Y")' => $time]); } else if ($type == 'range') { $query = $query->select(['FROM_UNIXTIME(pay_at,"%Y-%m-%d") as char_time', 'COUNT(id) as total_order', 'SUM(pay_amount) as total_order_amount']) ->where(['between', 'FROM_UNIXTIME(pay_at,"%Y-%m-%d")', $time, $time2]); } $data = $query->andWhere(['pay_status' => 2])->groupBy('char_time')->all(); 按时间排列下
$dataArr = []; foreach ($data as $allKey => $allVal) { $dataArr[$allVal->char_time]['char_time'] = $allVal->char_time; $dataArr[$allVal->char_time]['total_order'] = $allVal->total_order; $dataArr[$allVal->char_time]['total_order_amount'] = bcdiv($allVal->total_order_amount, 100, 2); } 再按时间获取对应数据
foreach ($rangeTime as $key => $val) { if($type == 'range') { if (array_key_exists($val, $dataArr)) { $charCountDatas[] = $dataArr[$val]['total_order']; $charAmountDatas[] = $dataArr[$val]['total_order_amount']; } else { $charCountDatas[] = 0; $charAmountDatas[] = 0; } } else { $theNow = strlen($val) == 2 ? $val : '0' . $val; if($type == 'day') { $theTime = $time . ' ' . $theNow; } else if($type == 'month') { $theTime = $time . '-' . $time2 . '-' . $theNow; } else if($type == 'year') { $theTime = $time . '-' . $theNow; } if (array_key_exists($theTime, $dataArr)) { $charCountDatas[] = $dataArr[$theTime]['total_order']; $charAmountDatas[] = $dataArr[$theTime]['total_order_amount']; } else { $charCountDatas[] = 0; $charAmountDatas[] = 0; } } } 封装下
/** * 时间段内支付订单量及金额 * type 类型： day， month， year * time: 时间， day： 选择的时间； month: 表示年；year： 表示年; range: 第一个时间 * time2: 时间： day： ''； month: 表示月；year： ''; range: 第二个时间 * rangeTime 时间段 day: 1-24小时； month： 1-30天； year：1-12月，range： time和time2之间的天 */ public function getDayOrderPayChar($type, $time, $time2, $rangeTime) { $query = Order::find(); if($type == 'day') { $query = $query->select(['FROM_UNIXTIME(pay_at,"%Y-%m-%d %H") as char_time', 'COUNT(id) as total_order', 'SUM(pay_amount) as total_order_amount']) ->where(['FROM_UNIXTIME(pay_at,"%Y-%m-%d")' => $time]); } else if($type == 'month') { $query = $query->select(['FROM_UNIXTIME(pay_at,"%Y-%m-%d") as char_time', 'COUNT(id) as total_order', 'SUM(pay_amount) as total_order_amount']) ->where(['FROM_UNIXTIME(pay_at,"%Y-%m")' => ($time . '-' . $time2)]); } else if ($type == 'year') { $query = $query->select(['FROM_UNIXTIME(pay_at,"%Y-%m") as char_time', 'COUNT(id) as total_order', 'SUM(pay_amount) as total_order_amount']) ->where(['FROM_UNIXTIME(pay_at,"%Y")' => $time]); } else if ($type == 'range') { $query = $query->select(['FROM_UNIXTIME(pay_at,"%Y-%m-%d") as char_time', 'COUNT(id) as total_order', 'SUM(pay_amount) as total_order_amount']) ->where(['>=', 'FROM_UNIXTIME(pay_at,"%Y-%m-%d")', $time]) ->andWhere(['<=', 'FROM_UNIXTIME(pay_at,"%Y-%m-%d")', $time2]); } $data = $query->andWhere(['pay_status' => 2])->groupBy('char_time')->all(); $dataArr = []; foreach ($data as $allKey => $allVal) { $dataArr[$allVal->char_time]['char_time'] = $allVal->char_time; $dataArr[$allVal->char_time]['total_order'] = $allVal->total_order; $dataArr[$allVal->char_time]['total_order_amount'] = bcdiv($allVal->total_order_amount, 100, 2); } $charCountDatas = []; $charAmountDatas = []; foreach ($rangeTime as $key => $val) { if($type == 'range') { if (array_key_exists($val, $dataArr)) { $charCountDatas[] = $dataArr[$val]['total_order']; $charAmountDatas[] = $dataArr[$val]['total_order_amount']; } else { $charCountDatas[] = 0; $charAmountDatas[] = 0; } } else { $theNow = strlen($val) == 2 ? $val : '0' . $val; if($type == 'day') { $theTime = $time . ' ' . $theNow; } else if($type == 'month') { $theTime = $time . '-' . $time2 . '-' . $theNow; } else if($type == 'year') { $theTime = $time . '-' . $theNow; } if (array_key_exists($theTime, $dataArr)) { $charCountDatas[] = $dataArr[$theTime]['total_order']; $charAmountDatas[] = $dataArr[$theTime]['total_order_amount']; } else { $charCountDatas[] = 0; $charAmountDatas[] = 0; } } } $res = [ 'count' => [ 'name' => Yii::t('backend', 'hour_order_pay_count_title'), 'color' => '#99CC33', 'charData' => $charCountDatas ], 'amount' => [ 'name' => Yii::t('backend', 'hour_order_pay_amount_title'), 'color' => '#99CC33', 'charData' => $charAmountDatas ] ]; return $res; } 前端
Yii::t('backend', 'day'), 'month' => Yii::t('backend', 'month'), 'year' => Yii::t('backend', 'year'), 'range' => Yii::t('backend','range_time')], ['class' => 'type dashboard-time-type']) ?>'time', 'value' => (!empty($time) && $type == 'day') ? $time : '', 'options' => ['placeholder' => Yii::t('backend', 'date'), 'autocomplete' => 'off', 'class' => 'time'], 'removeButton' => false, 'pluginOptions' => [ 'format' => 'yyyy-mm-dd', 'startView' => 'month', 'minView' => 'month', 'maxView' => 'month', 'autoclose' => true ] ]) ?>'time', 'value' => (!empty($time) && $type == 'month') ? $time : '', 'options' => ['placeholder' => Yii::t('backend', 'date'), 'autocomplete' => 'off', 'class' => 'time'], 'removeButton' => false, 'pluginOptions' => [ 'format' => 'yyyy-mm', 'startView' => 'year', 'minView' => 'year', 'maxView' => 'year', 'autoclose' => true ] ]) ?>'time', 'value' => (!empty($time) && $type == 'year') ? $time : '', 'options' => ['placeholder' => Yii::t('backend', 'date'), 'autocomplete' => 'off', 'class' => 'time'], 'removeButton' => false, 'pluginOptions' => [ 'format' => 'yyyy', 'startView' => 'decade', 'minView' => 'decade', 'maxView' => 'decade', 'autoclose' => true ] ]) ?>'time', 'value' => (!empty($time) && $type == 'range') ? $time : '', 'options' => ['placeholder' => Yii::t('backend', 'date'), 'autocomplete' => 'off', 'class' =>
相关内容
- thinkphp5 框架结合plupload实现图片批量上传功能示例_php实例_
- phpQuery采集网页实现代码实例_php技巧_
- 通过PHP的Wrapper无缝迁移原有项目到新服务的实现方法_php实例_
- php计数排序算法的实现代码(附四个实例代码)_php技巧_
- php设计模式之观察者模式实例详解【星际争霸游戏案例】_php实例_
- TP5框架实现上传多张图片的方法分析_php实例_
- thinkphp框架无限级栏目的排序功能实现方法示例_php实例_
- php查看一个变量的占用内存的实例代码_php技巧_
- tp5框架前台无限极导航菜单类实现方法分析_php实例_
- PHP中类与对象功能、用法实例解读_php实例_
点击排行
本栏推荐
