实现简单的按天数,按星期按月份搜索的框框

搜索时候展示数据的统计图,主要展示图形的效果
<?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));
	}
	return $week_arr;
}
<?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;
    }
<?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']);
	}
	//exit(json_encode($stat_arr));
	return json_encode($stat_arr);
}
<!DOCTYPE>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<!--引入ECharts文件-->
<title>Echarts</title>
<script src="js/echarts.common.min.js"></script>
</head>
<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>
<body>
   <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']").empty();
		$.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']").empty();
		$("#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>
</body>
</html>
<?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;
    }


代码技巧