php實現(xiàn)按天數(shù)、星期、月份查詢的搜索框

當前位置：首頁 > 范文|應用文 > IT技術專欄 > 網(wǎng)絡編程

來源：易賢網(wǎng) 閱讀：1278 次日期：2016-08-25 15:16:17

溫馨提示：易賢網(wǎng)小編為您整理了“php實現(xiàn)按天數(shù)、星期、月份查詢的搜索框”,方便廣大網(wǎng)友查閱！

本文實例為大家分享了php實現(xiàn)按天數(shù)、星期、月份查詢的搜索框，搜索時候展示數(shù)據(jù)的統(tǒng)計圖，主要展示圖形的效果，供大家參考，具體內容如下

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;

/**

* 獲得系統(tǒng)某月的周數(shù)組，第一周不足的需要補足

* @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;

}

2.datehelper.php

<?php

//獲得系統(tǒng)年份數(shù)組

/**

* @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;

}

/**

* 獲得系統(tǒng)月份數(shù)組

* @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;

}

/**

* 獲得系統(tǒng)周數(shù)組

* @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;

}

/**

* 獲得系統(tǒng)某月的周數(shù)組，第一周不足的需要補足

* @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;

}

/**

* 查詢每月的周數(shù)組

function getweekofmonth(){

$year = $_GET['y'];

$month = $_GET['m'];

$week_arr = getMonthWeekArr($year, $month);

echo json_encode($week_arr);

die;

}

3.statistics.php

<?php

/**

* 統(tǒng)計

* @abstract

* @copyright 格里西,2016

* @author liujun

* @version Id:statics v1.0 2016/2/5

/**

* 獲得折線圖統(tǒng)計圖數(shù)據(jù)

* param $statarr 圖表需要的設置項

* @return string

function getStatData_LineLabels($stat_arr){

//圖表區(qū)、圖形區(qū)和通用圖表配置選項

$stat_arr['chart']['type'] = 'line';

//圖表序列顏色數(shù)組

$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統(tǒng)計圖數(shù)據(jù)

* @param array $stat_arr

* @return string

function getStatData_Column2D($stat_arr){

//圖表區(qū)、圖形區(qū)和通用圖表配置選項

$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;

}

//柱形的顏色數(shù)組

$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統(tǒng)計圖數(shù)據(jù)

* @param array $stat_arr

* @return string

function getStatData_Basicbar($stat_arr){

//圖表區(qū)、圖形區(qū)和通用圖表配置選項

$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;

}

//柱形的顏色數(shù)組

$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);

}

/**

* 計算環(huán)比

* @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;

}

/**

* 地圖統(tǒng)計圖

* @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);

}

/**

* 獲得餅形圖數(shù)據(jù)

* @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);

}

4.theline.php

<!DOCTYPE>

<html>

<head>

<title>Echarts</title>

</head>

<?php include('php/datehelper.php');include('php/statistics.php');?>

<?php

//獲得系統(tǒng)年份

$year_arr = getSystemYearArr();

//獲得系統(tǒng)月份

$month_arr = getSystemMonthArr();

//存儲參數(shù)

$search_arr = $_REQUEST;

$search_arr =dealwithSearchTime($search_arr);

//獲得本月的周時間段

$week_arr = getMonthWeekArr($search_arr['week']['current_year'],$search_arr['week']['current_month']);

//天數(shù)

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>

<input id="stime" class="form-control" type="text" value="<?php echo $search_time;?>" name="search_time">

</div>

<?php foreach ($year_arr as $k=>$v){?>

<?php } ?>

</select>

<?php foreach ($month_arr as $k=>$v){?>

<?php } ?>

</select>

<?php foreach ($week_arr as $k=>$v){?>

<?php } ?>

</select>

</div>

<?php foreach ($year_arr as $k=>$v){?>

<?php } ?>

</select>

<?php foreach ($month_arr as $k=>$v){?>

<?php } ?>

</select>

</div>

<?php $thearray=array(11,11,15,13,12,13,10);?>

// 基于準備好的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: '平均值'}

]

}

]

};

// 使用剛指定的配置項和數(shù)據(jù)顯示圖表。

mylineChart.setOption(option1);

</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();

});

//更新周數(shù)組

$("[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>');

}

});

//更新年數(shù)組

$("[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>

5.time_deal.php

<?php

//獲取系統(tǒng)年份

/**

* @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;

}

/**

* 獲得系統(tǒng)月份數(shù)組

* @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){