PHP implements a search box for querying by days, weeks, and months_php skills

WBOY
Release: 2016-05-16 19:53:36
Original
2237 people have browsed it

The example in this article shares with you the PHP search box that implements query by day, week, and month. The statistical graph of the data is displayed during the search. It mainly displays the effect of the graph for your reference. The specific content is as follows

1.ajax.php

<&#63;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;
}
Copy after login

2.datehelper.php

<&#63;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;
  }
Copy after login

3.statistics.php

<&#63;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']&#63;'':$stat_arr['colors'] = array('#058DC7', '#ED561B', '#8bbc21', '#0d233a');
  //去除版权信息
  $stat_arr['credits']['enabled'] = false;
  //导出功能选项
  $stat_arr['exporting']['enabled'] = false;
  //标题如果为字符串则使用默认样式
  is_string($stat_arr['title'])&#63;$stat_arr['title'] = array('text'=>"<b>{$stat_arr['title']}</b>",'x'=>-20):'';
  //子标题如果为字符串则使用默认样式
  is_string($stat_arr['subtitle'])&#63;$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'])&#63;$stat_arr['title'] = array('text'=>"<b>{$stat_arr['title']}</b>",'x'=>-20):'';
  //子标题如果为字符串则使用默认样式
  is_string($stat_arr['subtitle'])&#63;$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'])&#63;$stat_arr['title'] = array('text'=>"<b>{$stat_arr['title']}</b>",'x'=>-20):'';
  //子标题如果为字符串则使用默认样式
  is_string($stat_arr['subtitle'])&#63;$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);
}
Copy after login

4.theline.php

<!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>
<&#63;php include('php/datehelper.php');include('php/statistics.php');&#63;>
<&#63;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'];
     
&#63;>
<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="<&#63;php echo $search_time;&#63;>" 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">
          <&#63;php foreach ($year_arr as $k=>$v){&#63;>
          <option value="<&#63;php echo $k;&#63;>" <&#63;php echo $current_year == $k&#63;'selected':'';&#63;>><&#63;php echo $v; &#63;></option>
          <&#63;php } &#63;>
        </select>
        <select name="search_time_month" id="searchweek_mouth">
          <&#63;php foreach ($month_arr as $k=>$v){&#63;>
          <option value="<&#63;php echo $k;&#63;>" <&#63;php echo $current_month == $k&#63;'selected':'';&#63;>><&#63;php echo $v; &#63;></option>
          <&#63;php } &#63;>
        </select>
        <select name="search_time_week" id="searchweek_week">
          <&#63;php foreach ($week_arr as $k=>$v){&#63;>
          <option value="<&#63;php echo $v['key'];&#63;>" <&#63;php echo $current_week == $v['key']&#63;'selected':'';&#63;> ><&#63;php echo $v['val']; &#63;></option>
          <&#63;php } &#63;>
        </select>
       </div> 
     
      <div id="searchtype_month" style="display:none;">
          <select name="search_time_year" class="querySelect">
          <&#63;php foreach ($year_arr as $k=>$v){&#63;>
          <option value="<&#63;php echo $k;&#63;>" <&#63;php echo $current_year == $k&#63;'selected':'';&#63;> ><&#63;php echo $v; &#63;></option>
          <&#63;php } &#63;>
        </select>
        <select name="search_time_month" class="querySelect">
          <&#63;php foreach ($month_arr as $k=>$v){&#63;>
          <option value="<&#63;php echo $k;&#63;>" <&#63;php echo $current_month == $k&#63;'selected':'';&#63;>><&#63;php echo $v; &#63;></option>
          <&#63;php } &#63;>
        </select>
      </div> 
   <div id="line_chart" style="width:600px;height:400px;"></div>
   <&#63;php $thearray=array(11,11,15,13,12,13,10);&#63;>
   <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:<&#63;php echo(json_encode($thearray)); &#63;>,
      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>
Copy after login

5.time_deal.php

<&#63;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;
  }

Copy after login

The above is the entire content of this article, I hope it will be helpful to everyone’s study.

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!