首页 / 网页编程 / PHP / 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））;}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;}