php实现按天数、星期、月份查询的搜索框
发布:smiling 来源: PHP粉丝网 添加日期:2019-08-16 09:19:48 浏览: 评论:0
本文实例为大家分享了php实现按天数、星期、月份查询的搜索框,搜索时候展示数据的统计图,主要展示图形的效果,供大家参考,具体内容如下
1.ajax.php
- <?php
- $year = $_GET['y'];
- if(!isset($_GET['m'])){
- $month=1;
- }else{
- $month = $_GET['m'];
- }
- $week_arr = getMonthWeekArr($year, $month);
- echo json_encode($week_arr);
- die;
- /**
- * 获得系统某月的周数组,第一周不足的需要补足
- *
- * @param int $current_year
- * @param int $current_month
- * @return string[][]
- */
- function getMonthWeekArr($current_year, $current_month){
- //该月第一天
- $firstday = strtotime($current_year.'-'.$current_month.'-01');
- //该月的第一周有几天
- $firstweekday = (7 - date('N',$firstday) +1);
- //计算该月第一个周一的时间
- $starttime = $firstday-3600*24*(7-$firstweekday);
- //该月的最后一天
- $lastday = strtotime($current_year.'-'.$current_month.'-01'." +1 month -1 day");
- //该月的最后一周有几天
- $lastweekday = date('N',$lastday);
- //该月的最后一个周末的时间
- $endtime = $lastday-3600*24*($lastweekday%7);
- $step = 3600*24*7;//步长值
- $week_arr = array();
- for ($i=$starttime; $i<$endtime; $i= $i+3600*24*7){
- $week_arr[] = array('key'=>date('Y-m-d',$i).'|'.date('Y-m-d',$i+3600*24*6), 'val'=>date('Y-m-d',$i).'~'.date('Y-m-d',$i+3600*24*6));
- }
- //phpfensi.com
- return $week_arr;
- }
2.datehelper.php
- //获得系统年份数组
- /**
- *
- * @return string[]
- */
- function getSystemYearArr(){
- $year_arr = array('2010'=>'2010','2011'=>'2011','2012'=>'2012','2013'=>'2013','2014'=>'2014','2015'=>'2015','2016'=>'2016','2017'=>'2017','2018'=>'2018','2019'=>'2019','2020'=>'2020');
- return $year_arr;
- }
- /**
- * 获得系统月份数组
- *
- * @return array
- */
- function getSystemMonthArr(){
- $month_arr = array('1'=>'01','2'=>'02','3'=>'03','4'=>'04','5'=>'05','6'=>'06','7'=>'07','8'=>'08','9'=>'09','10'=>'10','11'=>'11','12'=>'12');
- return $month_arr;
- }
- /**
- * 获得系统周数组
- *
- * @return string[]
- */
- function getSystemWeekArr(){
- $week_arr = array('1'=>'周一','2'=>'周二','3'=>'周三','4'=>'周四','5'=>'周五','6'=>'周六','7'=>'周日');
- return $week_arr;
- }
- /**
- * 获取某月的最后一天
- *
- * @param int $year
- * @param int $month
- * @return number
- */
- function getMonthLastDay($year, $month){
- $t = mktime(0, 0, 0, $month + 1, 1, $year);
- $t = $t - 60 * 60 * 24;
- return $t;
- }
- /**
- * 获得系统某月的周数组,第一周不足的需要补足
- *
- * @param int $current_year
- * @param int $current_month
- * @return string[][]
- */
- function getMonthWeekArr($current_year, $current_month){
- //该月第一天
- $firstday = strtotime($current_year.'-'.$current_month.'-01');
- //该月的第一周有几天
- $firstweekday = (7 - date('N',$firstday) +1);
- //计算该月第一个周一的时间
- $starttime = $firstday-3600*24*(7-$firstweekday);
- //该月的最后一天
- $lastday = strtotime($current_year.'-'.$current_month.'-01'." +1 month -1 day");
- //该月的最后一周有几天
- $lastweekday = date('N',$lastday);
- //该月的最后一个周末的时间
- $endtime = $lastday-3600*24*($lastweekday%7);
- $step = 3600*24*7;//步长值
- $week_arr = array();
- for ($i=$starttime; $i<$endtime; $i= $i+3600*24*7){
- $week_arr[] = array('key'=>date('Y-m-d',$i).'|'.date('Y-m-d',$i+3600*24*6), 'val'=>date('Y-m-d',$i).'~'.date('Y-m-d',$i+3600*24*6));
- }
- return $week_arr;
- }
- /**
- * 处理搜索时间
- */
- function dealwithSearchTime($search_arr=''){
- //初始化时间
- //天
- if(!isset($search_arr['search_time'])){
- $search_arr['search_time'] = date('Y-m-d', time()- 86400);
- }
- $search_arr['day']['search_time'] = strtotime($search_arr['search_time']);//搜索的时间
- //周
- if(!isset($search_arr['searchweek_year'])){
- $search_arr['searchweek_year'] = date('Y', time());
- }
- if(!isset($search_arr['searchweek_month'])){
- $search_arr['searchweek_month'] = date('m', time());
- }
- if(!isset($search_arr['searchweek_week'])){
- $search_arr['searchweek_week'] = implode('|', getWeek_SdateAndEdate(time()));
- }
- $weekcurrent_year = $search_arr['searchweek_year'];
- $weekcurrent_month = $search_arr['searchweek_month'];
- $weekcurrent_week = $search_arr['searchweek_week'];
- $search_arr['week']['current_year'] = $weekcurrent_year;
- $search_arr['week']['current_month'] = $weekcurrent_month;
- $search_arr['week']['current_week'] = $weekcurrent_week;
- //月
- if(!isset($search_arr['searchmonth_year'])){
- $search_arr['searchmonth_year'] = date('Y', time());
- }
- if(!isset($search_arr['searchmonth_month'])){
- $search_arr['searchmonth_month'] = date('m', time());
- }
- $monthcurrent_year = $search_arr['searchmonth_year'];
- $monthcurrent_month = $search_arr['searchmonth_month'];
- $search_arr['month']['current_year'] = $monthcurrent_year;
- $search_arr['month']['current_month'] = $monthcurrent_month;
- return $search_arr;
- }
- /**
- * 获取本周的开始时间和结束时间
- *
- * @param int $current_time
- * @return string
- */
- function getWeek_SdateAndEdate($current_time){
- $current_time = strtotime(date('Y-m-d',$current_time));
- $return_arr['sdate'] = date('Y-m-d', $current_time-86400*(date('N',$current_time) - 1));
- $return_arr['edate'] = date('Y-m-d', $current_time+86400*(7- date('N',$current_time)));
- return $return_arr;
- }
- /**
- * 查询每月的周数组
- */
- function getweekofmonth(){
- $year = $_GET['y'];
- $month = $_GET['m'];
- $week_arr = getMonthWeekArr($year, $month);
- echo json_encode($week_arr);
- die;
- }
3.statistics.php
- <?php
- /**
- * 统计
- *
- * @abstract
- *
- * @copyright 格里西,2016
- *
- * @author liujun
- *
- * @version Id:statics v1.0 2016/2/5
- */
- /**
- * 获得折线图统计图数据
- *
- * param $statarr 图表需要的设置项
- * @return string
- */
- function getStatData_LineLabels($stat_arr){
- //图表区、图形区和通用图表配置选项
- $stat_arr['chart']['type'] = 'line';
- //图表序列颜色数组
- $stat_arr['colors']?'':$stat_arr['colors'] = array('#058DC7', '#ED561B', '#8bbc21', '#0d233a');
- //去除版权信息
- $stat_arr['credits']['enabled'] = false;
- //导出功能选项
- $stat_arr['exporting']['enabled'] = false;
- //标题如果为字符串则使用默认样式
- is_string($stat_arr['title'])?$stat_arr['title'] = array('text'=>"<b>{$stat_arr['title']}</b>",'x'=>-20):'';
- //子标题如果为字符串则使用默认样式
- is_string($stat_arr['subtitle'])?$stat_arr['subtitle'] = array('text'=>"<b>{$stat_arr['subtitle']}</b>",'x'=>-20):'';
- //Y轴如果为字符串则使用默认样式
- if(is_string($stat_arr['yAxis'])){
- $text = $stat_arr['yAxis'];
- unset($stat_arr['yAxis']);
- $stat_arr['yAxis']['title']['text'] = $text;
- }
- return json_encode($stat_arr);
- }
- /**
- * 获得Column2D统计图数据
- *
- * @param array $stat_arr
- * @return string
- */
- function getStatData_Column2D($stat_arr){
- //图表区、图形区和通用图表配置选项
- $stat_arr['chart']['type'] = 'column';
- //去除版权信息
- $stat_arr['credits']['enabled'] = false;
- //导出功能选项
- $stat_arr['exporting']['enabled'] = false;
- //标题如果为字符串则使用默认样式
- is_string($stat_arr['title'])?$stat_arr['title'] = array('text'=>"<b>{$stat_arr['title']}</b>",'x'=>-20):'';
- //子标题如果为字符串则使用默认样式
- is_string($stat_arr['subtitle'])?$stat_arr['subtitle'] = array('text'=>"<b>{$stat_arr['subtitle']}</b>",'x'=>-20):'';
- //Y轴如果为字符串则使用默认样式
- if(is_string($stat_arr['yAxis'])){
- $text = $stat_arr['yAxis'];
- unset($stat_arr['yAxis']);
- $stat_arr['yAxis']['title']['text'] = $text;
- }
- //柱形的颜色数组
- $color = array('#7a96a4','#cba952','#667b16','#a26642','#349898','#c04f51','#5c315e','#445a2b','#adae50','#14638a','#b56367','#a399bb','#070dfa','#47ff07','#f809b7');
- foreach ($stat_arr['series'] as $series_k=>$series_v){
- foreach ($series_v['data'] as $data_k=>$data_v){
- $data_v['color'] = $color[$data_k];
- $series_v['data'][$data_k] = $data_v;
- }
- $stat_arr['series'][$series_k]['data'] = $series_v['data'];
- }
- //print_r($stat_arr); die;
- return json_encode($stat_arr);
- }
- /**
- * 获得Basicbar统计图数据
- *
- * @param array $stat_arr
- * @return string
- */
- function getStatData_Basicbar($stat_arr){
- //图表区、图形区和通用图表配置选项
- $stat_arr['chart']['type'] = 'bar';
- //去除版权信息
- $stat_arr['credits']['enabled'] = false;
- //导出功能选项
- $stat_arr['exporting']['enabled'] = false;
- //显示datalabel
- $stat_arr['plotOptions']['bar']['dataLabels']['enabled'] = true;
- //标题如果为字符串则使用默认样式
- is_string($stat_arr['title'])?$stat_arr['title'] = array('text'=>"<b>{$stat_arr['title']}</b>",'x'=>-20):'';
- //子标题如果为字符串则使用默认样式
- is_string($stat_arr['subtitle'])?$stat_arr['subtitle'] = array('text'=>"<b>{$stat_arr['subtitle']}</b>",'x'=>-20):'';
- //Y轴如果为字符串则使用默认样式
- if(is_string($stat_arr['yAxis'])){
- $text = $stat_arr['yAxis'];
- unset($stat_arr['yAxis']);
- $stat_arr['yAxis']['title']['text'] = $text;
- }
- //柱形的颜色数组
- $color = array('#7a96a4','#cba952','#667b16','#a26642','#349898','#c04f51','#5c315e','#445a2b','#adae50','#14638a','#b56367','#a399bb','#070dfa','#47ff07','#f809b7');
- foreach ($stat_arr['series'] as $series_k=>$series_v){
- foreach ($series_v['data'] as $data_k=>$data_v){
- if (!$data_v['color']){
- $data_v['color'] = $color[$data_k%15];
- }
- $series_v['data'][$data_k] = $data_v;
- }
- $stat_arr['series'][$series_k]['data'] = $series_v['data'];
- }
- //print_r($stat_arr); die;
- return json_encode($stat_arr);
- }
- /**
- * 计算环比
- *
- * @param array $updata
- * @param array $currentdata
- * @return string
- */
- function getHb($updata, $currentdata){
- if($updata != 0){
- $mtomrate = round(($currentdata - $updata)/$updata*100, 2).'%';
- } else {
- $mtomrate = '-';
- }
- return $mtomrate;
- }
- /**
- * 计算同比
- *
- * @param array $updata
- * @param array $currentdata
- * @return string
- */
- function getTb($updata, $currentdata){
- if($updata != 0){
- $ytoyrate = round(($currentdata - $updata)/$updata*100, 2).'%';
- } else {
- $ytoyrate = '-';
- }
- return $ytoyrate;
- }
- /**
- * 地图统计图
- *
- * @param array $stat_arr
- * @return string
- */
- function getStatData_Map($stat_arr){
- //$color_arr = array('#f63a3a','#ff5858','#ff9191','#ffc3c3','#ffd5d5');
- $color_arr = array('#fd0b07','#ff9191','#f7ba17','#fef406','#25aae2');
- $stat_arrnew = array();
- foreach ($stat_arr as $k=>$v){
- $stat_arrnew[] = array('cha'=>$v['cha'],'name'=>$v['name'],'des'=>$v['des'],'color'=>$color_arr[$v['level']]);
- }
- return json_encode($stat_arrnew);
- }
- /**
- * 获得饼形图数据
- *
- * @param array $data
- * @return string
- */
- function getStatData_Pie($data){
- $stat_arr['chart']['type'] = 'pie';
- $stat_arr['credits']['enabled'] = false;
- $stat_arr['title']['text'] = $data['title'];
- $stat_arr['tooltip']['pointFormat'] = '{series.name}: <b>{point.y}</b>';
- $stat_arr['plotOptions']['pie'] = array(
- 'allowPointSelect'=>true,
- 'cursor'=>'pointer',
- 'dataLabels'=>array(
- 'enabled'=>$data['label_show'],
- 'color'=>'#000000',
- 'connectorColor'=>'#000000',
- 'format'=>'<b>{point.name}</b>: {point.percentage:.1f} %'
- )
- );
- $stat_arr['series'][0]['name'] = $data['name'];
- $stat_arr['series'][0]['data'] = array();
- foreach ($data['series'] as $k=>$v){
- $stat_arr['series'][0]['data'][] = array($v['p_name'],$v['allnum']);
- //phpfensi.com
- }
- //exit(json_encode($stat_arr));
- return json_encode($stat_arr);
- }
4.theline.php
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
- <!--引入ECharts文件-->
- <title>Echarts</title>
- <script src="js/echarts.common.min.js"></script>
- <script src="js/jquery.js"></script>
- <?php include('php/datehelper.php');include('php/statistics.php');?>
- <?php
- //获得系统年份
- $year_arr = getSystemYearArr();
- //获得系统月份
- $month_arr = getSystemMonthArr();
- //存储参数
- $search_arr = $_REQUEST;
- $search_arr =dealwithSearchTime($search_arr);
- //获得本月的周时间段
- $week_arr = getMonthWeekArr($search_arr['week']['current_year'],$search_arr['week']['current_month']);
- //天数
- if(!isset($_REQUEST['search_time'])){
- $_REQUEST['search_time'] = date('Y-m-d', time()-86400);
- }
- $search_time = $_REQUEST['search_time'];//搜索的时间
- //周
- if(!isset($_REQUEST['search_time_year'])){
- $_REQUEST['search_time_year'] = date('Y', time());
- }
- if(!isset($_REQUEST['search_time_month'])){
- $_REQUEST['search_time_month'] = date('m', time());
- }
- if(!isset($_REQUEST['search_time_week'])){
- $_REQUEST['search_time_week'] = implode('|', getWeek_SdateAndEdate(time()));
- }
- $current_year = $_REQUEST['search_time_year'];
- $current_month = $_REQUEST['search_time_month'];
- $current_week = $_REQUEST['search_time_week'];
- ?>
- <style>
- #search_type{float:left}
- #searchtype_day{float:left}
- #searchtype_week{float:left}
- #searchtype_month{float:left}
- </style>
- <select name="search_type" id="search_type">
- <option value="day">按照天统计</option>
- <option value="week">按照周统计</option>
- <option value="month">按照月统计</option>
- </select>
- <div class="w140" id="searchtype_day">
- <div class="input-group date" id="datetimepicker1">
- <input id="stime" class="form-control" type="text" value="<?php echo $search_time;?>" name="search_time">
- <span class="input-group-addon"><span class="glyphicon glyphicon-calendar"></span></span>
- </div>
- </div>
- <div id="searchtype_week" style="display:none;">
- <select name="search_time_year" id="searchweek_year">
- <?php foreach ($year_arr as $k=>$v){?>
- <option value="<?php echo $k;?>" <?php="" echo="" $current_year="=" $k?'selected':'';?="">><?php echo $v; ?></option>
- <?php } ?>
- </select>
- <select name="search_time_month" id="searchweek_mouth">
- <?php foreach ($month_arr as $k=>$v){?>
- <option value="<?php echo $k;?>" <?php="" echo="" $current_month="=" $k?'selected':'';?="">><?php echo $v; ?></option>
- <?php } ?>
- </select>
- <select name="search_time_week" id="searchweek_week">
- <?php foreach ($week_arr as $k=>$v){?>
- <option value="<?php echo $v['key'];?>" <?php="" echo="" $current_week="=" $v['key']?'selected':'';?=""> ><?php echo $v['val']; ?></option>
- <?php } ?>
- </select>
- </div>
- <div id="searchtype_month" style="display:none;">
- <select name="search_time_year" class="querySelect">
- <?php foreach ($year_arr as $k=>$v){?>
- <option value="<?php echo $k;?>" <?php="" echo="" $current_year="=" $k?'selected':'';?=""> ><?php echo $v; ?></option>
- <?php } ?>
- </select>
- <select name="search_time_month" class="querySelect">
- <?php foreach ($month_arr as $k=>$v){?>
- <option value="<?php echo $k;?>" <?php="" echo="" $current_month="=" $k?'selected':'';?="">><?php echo $v; ?></option>
- <?php } ?>
- </select>
- </div>
- <div id="line_chart" style="width:600px;height:400px;"></div>
- <?php $thearray=array(11,11,15,13,12,13,10);?>
- <script type="text/javascript">
- // 基于准备好的dom,初始化echarts实例
- var mylineChart=echarts.init(document.getElementById('line_chart'));
- option1 = {
- title: {
- text: '未来一周气温变化',
- subtext: '纯属虚构'
- },
- tooltip: {
- trigger: 'axis'
- },
- legend: {
- data:['最高气温','最低气温']
- },
- toolbox: {
- show: true,
- feature: {
- dataZoom: {},
- // dataView: {readOnly: false},
- magicType: {type: ['line', 'bar']},
- restore: {},
- saveAsImage: {}
- }
- },
- xAxis: {
- type: 'category',
- boundaryGap: false,
- data: ['周一','周二','周三','周四','周五','周六','周日']
- },
- yAxis: {
- type: 'value',
- axisLabel: {
- formatter: '{value} °C'
- }
- },
- series: [
- {
- name:'最高气温',
- type:'line',
- data:<?php echo(json_encode($thearray)); ?>,
- markPoint: {
- data: [
- {type: 'max', name: '最大值'},
- {type: 'min', name: '最小值'}
- ]
- },
- markLine: {
- data: [
- {type: 'average', name: '平均值'}
- ]
- }
- },
- {
- name:'最低气温',
- type:'line',
- data:[1, 4, 2, 5, 3, 2, 0],
- markPoint: {
- data: [
- {name: '周最低', value: -2, xAxis: 1, yAxis: -1.5}
- ]
- },
- markLine: {
- data: [
- {type: 'average', name: '平均值'}
- ]
- }
- }
- ]
- };
- // 使用刚指定的配置项和数据显示图表。
- mylineChart.setOption(option1);
- </script>
- <script>
- //展示搜索时间框
- function show_searchtime(){
- s_type = $("#search_type").val();
- $("[id^='searchtype_']").hide();
- $("#searchtype_"+s_type).show();
- }
- $(function(){
- show_searchtime();
- $("#search_type").change(function(){
- show_searchtime();
- });
- //更新周数组
- $("[name='search_time_month']").change(function(){
- var year = $("[name='search_time_year']").val();
- var month = $("[name='search_time_month']").val();
- $("[name='search_time_week']").emptyempty();
- $.getJSON('php/ajax.php',{y:year,m:month},function(data){
- if(data != null){
- for(var i = 0; i < data.length; i++) {
- $("[name='search_time_week']").append('<option value="'+data[i].key+'">'+data[i].val+'</option>');
- }
- }
- });
- });
- //更新年数组
- $("[name='search_time_year']").change(function(){
- var year = $("[name='search_time_year']").val();
- $("[name='search_time_week']").emptyempty();
- $("#searchweek_mouth option:first").prop("selected", 'selected');
- $.getJSON('php/ajax.php',{y:year},function(data){
- if(data != null){
- for(var i = 0; i < data.length; i++) {
- $("[name='search_time_week']").append('<option value="'+data[i].key+'">'+data[i].val+'</option>');
- }
- }
- });
- });
- });
- </script>
5.time_deal.php
- <?php
- //获取系统年份
- /**
- *
- * @return string[]
- */
- function getSystemYearArr(){
- $year_arr = array('2010'=>'2010','2011'=>'2011','2012'=>'2012','2013'=>'2013','2014'=>'2014','2015'=>'2015','2016'=>'2016','2017'=>'2017','2018'=>'2018','2019'=>'2019','2020'=>'2020');
- return $year_arr;
- }
- /**
- * 获得系统月份数组
- *
- * @return array
- */
- function getSystemMonthArr(){
- $month_arr = array('1'=>'01','2'=>'02','3'=>'03','4'=>'04','5'=>'05','6'=>'06','7'=>'07','8'=>'08','9'=>'09','10'=>'10','11'=>'11','12'=>'12');
- return $month_arr;
- }
- /**
- * 处理搜索时间
- */
- public function dealwithSearchTime($search_arr){
- //初始化时间
- //天
- if(!$search_arr['search_time']){
- $search_arr['search_time'] = date('Y-m-d', time()- 86400);
- }
- $search_arr['day']['search_time'] = strtotime($search_arr['search_time']);//搜索的时间
- //周
- if(!$search_arr['searchweek_year']){
- $search_arr['searchweek_year'] = date('Y', time());
- }
- if(!$search_arr['searchweek_month']){
- $search_arr['searchweek_month'] = date('m', time());
- }
- if(!$search_arr['searchweek_week']){
- $search_arr['searchweek_week'] = implode('|', getWeek_SdateAndEdate(time()));
- }
- $weekcurrent_year = $search_arr['searchweek_year'];
- $weekcurrent_month = $search_arr['searchweek_month'];
- $weekcurrent_week = $search_arr['searchweek_week'];
- $search_arr['week']['current_year'] = $weekcurrent_year;
- $search_arr['week']['current_month'] = $weekcurrent_month;
- $search_arr['week']['current_week'] = $weekcurrent_week;
- //月
- if(!$search_arr['searchmonth_year']){
- $search_arr['searchmonth_year'] = date('Y', time());
- }
- if(!$search_arr['searchmonth_month']){
- $search_arr['searchmonth_month'] = date('m', time());
- }
- $monthcurrent_year = $search_arr['searchmonth_year'];
- $monthcurrent_month = $search_arr['searchmonth_month'];
- $search_arr['month']['current_year'] = $monthcurrent_year;
- $search_arr['month']['current_month'] = $monthcurrent_month;
- return $search_arr;
- }
Tags: php月份查询
推荐文章
热门文章
最新评论文章
- 写给考虑创业的年轻程序员(10)
- PHP新手上路(一)(7)
- 惹恼程序员的十件事(5)
- PHP邮件发送例子,已测试成功(5)
- 致初学者:PHP比ASP优秀的七个理由(4)
- PHP会被淘汰吗?(4)
- PHP新手上路(四)(4)
- 如何去学习PHP?(2)
- 简单入门级php分页代码(2)
- php中邮箱email 电话等格式的验证(2)