控制器内容

    1. /**  
    2. * 订单分析，数据统计
    3. * author：咔咔
    4. * time:2018.7.4
    5. * @access public 
    6. */  
    7.     public function goodsanalysis(){
    8.     //获得展示类型
    9.         if($_GET['time_type']){
    10.             $time_type = $_GET['time_type'];
    11.         }else{
    12.             $time_type = 'day';
    13.         }
    14.         //获得月份
    15.         if($_GET['month']){
    16.             $month = $_GET['month'];
    17.         }else{
    18.             $month = date("m",time());
    19.         }
    20.         // 获取到当前的年份  2018
    21.         $years_time =date("Y",time()) ;
    22.         // 视图传过来的月份，跟当前年份拼接  string(7) "2018-07"
    23.         $oldtime = $years_time."-".$month;
    25.         /*
    26.             array(3) {
    27.                   //当月第一天的时间戳
    28.                   [0] => int(1530374400)
    29.                   //当月最后一天的时间戳
    30.                   [1] => int(1532966400)
    31.                   //当月的天数
    32.                   [2] => int(30)
    33.                 }
    34.         */
    35.         $time_interval = $this->getMonth($oldtime);
    37.         $data = array();
    38.         if($time_type=='day'){
    39.             // 循环每月的天数
    40.             for ($x=0; $x<=$time_interval['2']; $x++) {
    41.                 // 从第一天到最后一天的时间戳
    42.                 $time = $time_interval['0']+(86400*$x);
    43.                 // 将第一天到最后一天的时间戳格式化 在视图底部输出日期
    44.                 $data['time'][$x]=date("m/d",$time);
    45.                 // 统计订单的查询条件
    46.                 $where['is_pay'] = 1;
    47.                 // $where['refund'] = 1;
    48.                 $where['ctime'] =  array(array('EGT',$time),array('ELT',($time+86400)),'AND');
    49.                 // 订单的所有数量
    50.                 $data['sales_sum'][$x]=M('goodsorder')->where($where)->count();
    51.                 // 订单的总价
    52.                 $data['saleroom'][$x]=M('goodsorder')->where($where)->sum('price');
    53.                 // 当没有订单的时候总价为0
    54.                 if($data['saleroom'][$x]==NULL){
    55.                     $data['saleroom'][$x]=0;
    56.                 }
    57.             }
    58.         }else{
    59.             for ($x=1; $x<=12; $x++) {
    60.                 $time  = $years_time."-".$x;
    61.                 $time_interval = $this->getMonth($time);
    62.                 $data['time'][$x]=$x."月";
    63.                 $where['is_pay'] = 1;
    64.                 // $where['refund'] = 1;
    65.                 $where['ctime'] =  array(array('EGT',$time_interval[0]),array('ELT',$time_interval[1]),'AND');
    66.                 $data['sales_sum'][$x]=M('goodsorder')->where($where)->count();
    67.                 $data['saleroom'][$x]=M('goodsorder')->where($where)->sum('price');
    68.                 if($data['saleroom'][$x]==NULL){
    69.                     $data['saleroom'][$x]=0;
    70.                 }
    71.             }
    72.         }
    73.         //将time 拼接字符串
    74.         // 将当月的所有天数转换为字符串
    75.         $time_str ="";
    76.         foreach($data['time'] as $k=>$v){
    77.             $time_str=$time_str."_".$v ;
    78.         }
    79.         // 截取第一个-
    80.         $time_str = substr($time_str,1);
    82.         //将销量拼接字符串
    83.         $sales_sum_str ="";
    84.         foreach($data['sales_sum'] as $k=>$v){
    85.             $sales_sum_str=$sales_sum_str."_".$v ;
    86.         }
    87.         $sales_sum_str = substr($sales_sum_str,1);
    88.         //将销售额拼接数组
    89.         $saleroom_str ="";
    90.         foreach($data['saleroom'] as $k=>$v){
    91.             $saleroom_str=$saleroom_str."_".$v ;
    92.         }
    93.         $saleroom_str = substr($saleroom_str,1);
    94.         $data['max_count'] =max($data['sales_sum']);
    95.         $data['max_salessum'] =max($data['saleroom']);
    96.         $data['saleroom'] = $saleroom_str;
    97.         $data['time'] =$time_str;
    98.         $data['sales_sum'] = $sales_sum_str;
    100.         $this->assign('data',$data);
    102.         $this->display();
    103.     } 
    106. /**  
    107. * 时间
    108. * author：咔咔
    109. * time:2018.7.4
    110. * param string $data 当前的年份跟月份
    111. */  
    112.     //获取月初和月末的时间戳
    113.     function getMonth($date){
    114.         // 获取到当月的第一天时间戳
    115.         $firstday = date("Y-m-01",strtotime($date));
    116.         // string(10) "2018-07-31" 获取到当月的最后天
    117.         $lastday = date("Y-m-d",strtotime("$firstday +1 month -1 day"));
    118.         // 将第一天转为时间戳
    119.         $firstday = strtotime($date);
    120.         // 最后一天转为时间戳
    121.         $lastday = strtotime($lastday);
    122.         // 获取当月天数
    123.         $day_sum = (($lastday - $firstday)/86400);
    125.         return array($firstday,$lastday,$day_sum);
    126.     }

    修改过得html内容

    1. <!DOCTYPE html>
    2. <html lang="en">
    3. <head>
    4.     <meta charset="UTF-8">
    5.     <title>Document</title>
    6. </head>
    7. <body>
    8.     <style type="text/css">
    9.     .pagination{
    10.         padding: 10px 0;
    11.     }
    12.     .pagination *{
    13.         margin-right:3px;
    14.         padding: 5px 10px;
    15.     }
    16.     .pagination a{
    17.         border:1px solid #337ab7;
    18.         border-radius: 3px;
    19.     }
    20.     .sousuo {
    21.         width: 263px;
    22.     }
    23.     .nr {
    24.         font-size: 10px;
    25.         color: #3F3F3F;
    26.     }
    27.     .tabledown{
    28.         width:10%;
    29.         margin-bottom:25px;
    30.         display:inline-block;
    31.     }
    32.     .tabletype{
    33.         display:inline-block;
    34.         margin-right:5px;
    35.     }
    36.     .tabletypeleft{
    37.         margin-left:20px;
    38.     }
    40. </style>
    41. <div class="mod">
    42.         <!-- 数据分析select -->
    43.         <div class="tabletype">报表类型</div>
    44.         <div class="tabledown">
    45.             <select name="" class="form-control" id="styleselect">
    46.                 <option value="day" select>日报表</option>
    47.                 <option value="years">月报表</option>
    48.             </select>
    49.         </div>
    50.         <div class="tabletype tabletypeleft">时间</div>
    51.         <div class="tabledown"   id="month_div">
    52.             <select name="" class="form-control" id="month">
    53.                 <for start="1" end="13" name="i">
    54.                     <option value="{$i}">{$i}月</option>
    55.                 </for>
    56.             </select>
    57.         </div>
    58.             <div class="tabledown"  style="display:none" id="years_div">
    59.                 <select name="" class="form-control" id="years_sum">
    60.                         <option value="2018" select >2018年</option>
    62.                 </select>
    63.             </div>
    64.             <!-- Bootstrap 的搜索按钮 -->
    65.             <button class="btn btn-primary"  id="sales_report"><i class="icon-search"></i></button>
    66.         <!-- ！！数据分析select -->
    68.             <br class="table-responsive">
    69.             <input type="hidden" name="field＿name" id="max_count"  value={$data['max_count']}>
    70.             <input type="hidden" name="field＿name" id="max_salessum" value={$data['max_salessum']}>
    71.             <input type="hidden" name="field＿name" id="saleroom" value={$data['saleroom']}>
    72.             <input type="hidden" name="field＿name" id="time" value={$data['time']}>
    73.             <input type="hidden" name="field＿name" id="sales_sum" value={$data['sales_sum']}>
    75.             <div id="container" style="height: 500px"></div>
    76.            <script type="text/javascript" src="http://echarts.baidu.com/gallery/vendors/echarts/echarts.min.js"></script>
    77.        <script type="text/javascript" src="http://echarts.baidu.com/gallery/vendors/echarts-gl/echarts-gl.min.js"></script>
    78.        <script type="text/javascript" src="http://echarts.baidu.com/gallery/vendors/echarts-stat/ecStat.min.js"></script>
    79.        <script type="text/javascript" src="http://echarts.baidu.com/gallery/vendors/echarts/extension/dataTool.min.js"></script>
    80.        <script type="text/javascript" src="http://echarts.baidu.com/gallery/vendors/echarts/map/js/china.js"></script>
    81.        <script type="text/javascript" src="http://echarts.baidu.com/gallery/vendors/echarts/map/js/world.js"></script>
    82.        <script type="text/javascript" src="http://api.map.baidu.com/api?v=2.0&ak=ZUONbpqGBsYGXNIYHicvbAbM"></script>
    83.        <script type="text/javascript" src="http://echarts.baidu.com/gallery/vendors/echarts/extension/bmap.min.js"></script>
    84.        <script type="text/javascript" src="http://echarts.baidu.com/gallery/vendors/simplex.js"></script>
    85.        <script type="text/javascript">
    86. var dom = document.getElementById("container");
    87. var myChart = echarts.init(dom);
    88. var app = {};
    89. //定义参数
    90.  var max_count=parseInt(document.getElementById("max_count").value)+parseInt(20);
    91.  var max_salessum=parseInt(document.getElementById("max_salessum").value)+parseInt(50);
    92.  var saleroom=document.getElementById("saleroom").value;
    93.  var time=document.getElementById("time").value;
    94.  var sales_sum=document.getElementById("sales_sum").value;
    95. option = null;
    96.  var data_time = time.split("_");
    97.  var data_sales_sum = sales_sum.split("_");
    98.  var data_saleroom = saleroom.split("_");
    99. app.title = '折柱混合';
    101. option = {
    102.     tooltip: {
    103.         trigger: 'axis',
    104.         axisPointer: {
    105.             type: 'cross',
    106.             crossStyle: {
    107.                 color: '#999'
    108.             }
    109.         }
    110.     },
    111.     toolbox: {
    112.         feature: {
    113.             dataView: {show: true, readOnly: false},
    114.             magicType: {show: true, type: ['line', 'bar']},
    115.             restore: {show: true},
    116.             saveAsImage: {show: true}
    117.         }
    118.     },
    119.     legend: {
    120.         data:[,'销售数量','销售总额']
    121.     },
    122.     xAxis: [
    123.         {
    124.             type: 'category',
    125.             data: data_time,
    126.             axisPointer: {
    127.                 type: 'shadow'
    128.             }
    129.         }
    130.     ],
    131.     yAxis: [
    132.         {
    133.             type: 'value',
    134.             name: '数量',
    135.             min: 0,
    136.             max: max_count,
    137.             interval: Math.ceil(max_count/5),
    138.             axisLabel: {
    139.                 formatter: '{value} 件'
    140.             }
    141.         },
    142.         {
    143.             type: 'value',
    144.             name: '总额',
    145.             min: 0,
    146.             max: max_salessum,
    147.             interval: Math.ceil(max_salessum/5),
    148.             axisLabel: {
    149.                 formatter: '{value} 元'
    150.             }
    151.         }
    152.     ],
    153.     series: [
    155.         {
    156.             name:'销售数量',
    157.             type:'bar',
    158.             data:data_sales_sum
    159.         },
    160.         {
    161.             name:'销售总额',
    162.             type:'line',
    163.             yAxisIndex: 1,
    164.             data:data_saleroom
    165.         }
    166.     ]
    167. };
    168. ;
    169. if (option && typeof option === "object") {
    170.     myChart.setOption(option, true);
    171. }
    172. $("#styleselect").change(function(){
    173.     var opt=$("#styleselect").val();
    174.     if(opt=="day"){
    175.         $("#years_div").attr("style","display:none;");
    176.         $("#month_div").attr("style","display:inline-block;");
    177.     }else{
    178.         $("#years_div").attr("style","display:inline-block;");
    179.         $("#month_div").attr("style","display:none;");
    180.     }
    181. });
    182.  $("#sales_report").click(function(){
    183.      var time_type = $("#styleselect").val();
    184.      if(time_type =="day"){
    185.        var   month =  $("#month").val();
    186.      }
    187.      window.location.href="index.php?s=/addon/WeiuidStore/web/analysis/time_type/"+time_type+"/month/"+month;
    188.  })
    189.        </script>
    190.         </div>
    191.     </div>
    192. </div>
    193. </body>
    194. </html>

    本身自带的html文件

    1. <extend name="./App/Common/View/default/Base/common.html" />
    2. <block name="main_content">
    3. <include file="./App/Common/View/default/Public/crumb.html" />
    4. <style type="text/css">
    5.     .pagination{
    6.         padding: 10px 0;
    7.     }
    8.     .pagination *{
    9.         margin-right:3px;
    10.         padding: 5px 10px;
    11.     }
    12.     .pagination a{
    13.         border:1px solid #337ab7;
    14.         border-radius: 3px;
    15.     }
    16.     .sousuo {
    17.         width: 263px;
    18.     }
    19.     .nr {
    20.         font-size: 10px;
    21.         color: #3F3F3F;
    22.     }
    23.     .tabledown{
    24.         width:10%;
    25.         margin-bottom:25px;
    26.         display:inline-block;
    27.     }
    28.     .tabletype{
    29.         display:inline-block;
    30.         margin-right:5px;
    31.     }
    32.     .tabletypeleft{
    33.         margin-left:20px;
    34.     }
    36. </style>
    37. <div class="mod">
    38.     <div class="mod-head">
    39.         <h3>
    40.             <include file="./App/Common/View/default/Public/nav.html" />
    41.         </h3>
    42.     </div>
    43.     <div class="mod-body tab-content">
    44.         <if condition="$tip">
    45.         <div class="alert alert-info tip" role="alert">{$tip}</div>
    46.         </if>
    47.         <include file="./App/Common/View/default/Public/search.html" />
    48.         <div class="tab-pane active" id="list">
    49.             <if condition="$subnav">
    50.             <ul class="nav nav-tabs">
    51.                 <volist name="subnav" id="vo">
    52.                 <li role="presentation" class="{$vo.class}"><a href="{$vo.url}">{$vo.title}</a></li>
    53.                 </volist>
    54.             </ul> 
    55.             <br>
    56.             </if>
    58.             <br>
    59.         <!-- 数据分析select -->
    60.         <div class="tabletype">报表类型</div>
    61.         <div class="tabledown">
    62.             <select name="" class="form-control" id="styleselect">
    63.                 <option value="day" select>日报表</option>
    64.                 <option value="years">月报表</option>
    65.             </select>
    66.         </div>
    67.         <div class="tabletype tabletypeleft">时间</div>
    68.         <div class="tabledown"   id="month_div">
    69.             <select name="" class="form-control" id="month">
    70.                 <for start="1" end="13" name="i">
    71.                     <option value="{$i}">{$i}月</option>
    72.                 </for>
    73.             </select>
    74.         </div>
    75.             <div class="tabledown"  style="display:none" id="years_div">
    76.                 <select name="" class="form-control" id="years_sum">
    77.                         <option value="2018" select >2018年</option>
    79.                 </select>
    80.             </div>
    81.             <button class="btn btn-primary"  id="sales_report"><i class="icon-search"></i></button>
    82.         <!-- ！！数据分析select -->
    84.             <br class="table-responsive">
    85.             <input type="hidden" name="field＿name" id="max_count"  value={$data['max_count']}>
    86.             <input type="hidden" name="field＿name" id="max_salessum" value={$data['max_salessum']}>
    87.             <input type="hidden" name="field＿name" id="saleroom" value={$data['saleroom']}>
    88.             <input type="hidden" name="field＿name" id="time" value={$data['time']}>
    89.             <input type="hidden" name="field＿name" id="sales_sum" value={$data['sales_sum']}>
    91.             <div id="container" style="height: 500px"></div>
    92.            <script type="text/javascript" src="http://echarts.baidu.com/gallery/vendors/echarts/echarts.min.js"></script>
    93.        <script type="text/javascript" src="http://echarts.baidu.com/gallery/vendors/echarts-gl/echarts-gl.min.js"></script>
    94.        <script type="text/javascript" src="http://echarts.baidu.com/gallery/vendors/echarts-stat/ecStat.min.js"></script>
    95.        <script type="text/javascript" src="http://echarts.baidu.com/gallery/vendors/echarts/extension/dataTool.min.js"></script>
    96.        <script type="text/javascript" src="http://echarts.baidu.com/gallery/vendors/echarts/map/js/china.js"></script>
    97.        <script type="text/javascript" src="http://echarts.baidu.com/gallery/vendors/echarts/map/js/world.js"></script>
    98.        <script type="text/javascript" src="http://api.map.baidu.com/api?v=2.0&ak=ZUONbpqGBsYGXNIYHicvbAbM"></script>
    99.        <script type="text/javascript" src="http://echarts.baidu.com/gallery/vendors/echarts/extension/bmap.min.js"></script>
    100.        <script type="text/javascript" src="http://echarts.baidu.com/gallery/vendors/simplex.js"></script>
    101.        <script type="text/javascript">
    102. var dom = document.getElementById("container");
    103. var myChart = echarts.init(dom);
    104. var app = {};
    105. //定义参数
    106.  var max_count=parseInt(document.getElementById("max_count").value)+parseInt(20);
    107.  var max_salessum=parseInt(document.getElementById("max_salessum").value)+parseInt(50);
    108.  var saleroom=document.getElementById("saleroom").value;
    109.  var time=document.getElementById("time").value;
    110.  var sales_sum=document.getElementById("sales_sum").value;
    111. option = null;
    112.  var data_time = time.split("_");
    113.  var data_sales_sum = sales_sum.split("_");
    114.  var data_saleroom = saleroom.split("_");
    115. app.title = '折柱混合';
    117. option = {
    118.     tooltip: {
    119.         trigger: 'axis',
    120.         axisPointer: {
    121.             type: 'cross',
    122.             crossStyle: {
    123.                 color: '#999'
    124.             }
    125.         }
    126.     },
    127.     toolbox: {
    128.         feature: {
    129.             dataView: {show: true, readOnly: false},
    130.             magicType: {show: true, type: ['line', 'bar']},
    131.             restore: {show: true},
    132.             saveAsImage: {show: true}
    133.         }
    134.     },
    135.     legend: {
    136.         data:[,'销售数量','销售总额']
    137.     },
    138.     xAxis: [
    139.         {
    140.             type: 'category',
    141.             data: data_time,
    142.             axisPointer: {
    143.                 type: 'shadow'
    144.             }
    145.         }
    146.     ],
    147.     yAxis: [
    148.         {
    149.             type: 'value',
    150.             name: '数量',
    151.             min: 0,
    152.             max: max_count,
    153.             interval: Math.ceil(max_count/5),
    154.             axisLabel: {
    155.                 formatter: '{value} 件'
    156.             }
    157.         },
    158.         {
    159.             type: 'value',
    160.             name: '总额',
    161.             min: 0,
    162.             max: max_salessum,
    163.             interval: Math.ceil(max_salessum/5),
    164.             axisLabel: {
    165.                 formatter: '{value} 元'
    166.             }
    167.         }
    168.     ],
    169.     series: [
    171.         {
    172.             name:'销售数量',
    173.             type:'bar',
    174.             data:data_sales_sum
    175.         },
    176.         {
    177.             name:'销售总额',
    178.             type:'line',
    179.             yAxisIndex: 1,
    180.             data:data_saleroom
    181.         }
    182.     ]
    183. };
    184. ;
    185. if (option && typeof option === "object") {
    186.     myChart.setOption(option, true);
    187. }
    188. $("#styleselect").change(function(){
    189.     var opt=$("#styleselect").val();
    190.     if(opt=="day"){
    191.         $("#years_div").attr("style","display:none;");
    192.         $("#month_div").attr("style","display:inline-block;");
    193.     }else{
    194.         $("#years_div").attr("style","display:inline-block;");
    195.         $("#month_div").attr("style","display:none;");
    196.     }
    197. });
    198.  $("#sales_report").click(function(){
    199.      var time_type = $("#styleselect").val();
    200.      if(time_type =="day"){
    201.        var   month =  $("#month").val();
    202.      }
    203.      window.location.href="index.php?s=/addon/WeiuidStore/web/analysis/time_type/"+time_type+"/month/"+month;
    204.  })
    205.        </script>
    206.         </div>
    207.     </div>
    208. </div>
    209. </block>