PHP getStatData_LineLabels函数代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了PHP中getStatData_LineLabels函数的典型用法代码示例。如果您正苦于以下问题：PHP getStatData_LineLabels函数的具体用法？PHP getStatData_LineLabels怎么用？PHP getStatData_LineLabels使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。

在下文中一共展示了getStatData_LineLabels函数的14个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: storeflowOp

	/**
	 * 店铺流量统计
	 */
    public function storeflowOp() {
        $store_id = intval($_SESSION['store_id']);
        //确定统计分表名称
		$last_num = $store_id % 10; //获取店铺ID的末位数字
		$tablenum = ($t = intval(C('flowstat_tablenum'))) > 1 ? $t : 1; //处理流量统计记录表数量
		$flow_tablename = ($t = ($last_num % $tablenum)) > 0 ? "flowstat_$t" : 'flowstat';
		if(!$this->search_arr['search_type']){
			$this->search_arr['search_type'] = 'week';
		}
        $model = Model('stat');
        //获得搜索的开始时间和结束时间
		$searchtime_arr = $model->getStarttimeAndEndtime($this->search_arr);
		$where = array();
		$where['store_id'] = $store_id;
		$where['stattime'] = array('between',$searchtime_arr);
		$where['type'] = 'sum';

		$field = ' SUM(clicknum) as amount';
	    if($this->search_arr['search_type'] == 'week'){
			//构造横轴数据
	        for($i=1; $i<=7; $i++){
	            $tmp_weekarr = getSystemWeekArr();
				//横轴
				$stat_arr['xAxis']['categories'][] = $tmp_weekarr[$i];
				unset($tmp_weekarr);
				$statlist[$i] = 0;
			}
			$field .= ' ,WEEKDAY(FROM_UNIXTIME(stattime))+1 as timeval ';
		}
	    if($this->search_arr['search_type'] == 'month'){
			//计算横轴的最大量（由于每个月的天数不同）
			$dayofmonth = date('t',$searchtime_arr[0]);
		    //构造横轴数据
			for($i=1; $i<=$dayofmonth; $i++){
				//横轴
				$stat_arr['xAxis']['categories'][] = $i;
				$statlist[$i] = 0;
			}
			$field .= ' ,day(FROM_UNIXTIME(stattime)) as timeval ';
		}
		$statlist_tmp = $model->statByFlowstat($flow_tablename, $where, $field, 0, 0, 'timeval asc', 'timeval');
		if ($statlist_tmp){
    	    foreach((array)$statlist_tmp as $k=>$v){
    	        $statlist[$v['timeval']] = floatval($v['amount']);
    		}
		}
        //得到统计图数据
		$stat_arr['legend']['enabled'] = false;
		$stat_arr['series'][0]['name'] = '访问量';
		$stat_arr['series'][0]['data'] = array_values($statlist);
		$stat_arr['title'] = '店铺访问量统计';
        $stat_arr['yAxis'] = '访问次数';
		$stat_json = getStatData_LineLabels($stat_arr);
        Tpl::output('stat_json',$stat_json);
		self::profile_menu('storeflow');
		Tpl::showpage('stat.flow.store');
	}

开发者ID:noikiy，项目名称:ejia，代码行数:60，代码来源:statistics_flow.php

示例2: priceOp

 /**
  * 价格分布
  */
 public function priceOp()
 {
     if (!$this->search_arr['search_type']) {
         $this->search_arr['search_type'] = 'day';
     }
     $model = Model('stat');
     //获得搜索的开始时间和结束时间
     $searchtime_arr = $model->getStarttimeAndEndtime($this->search_arr);
     $where = array();
     $where['order_isvalid'] = 1;
     //计入统计的有效订单
     $where['order_add_time'] = array('between', $searchtime_arr);
     $gc_id_depth = $this->gc_arr[$this->choose_gcid]['depth'];
     if ($this->choose_gcid > 0) {
         $where['gc_parentid_' . $gc_id_depth] = $this->choose_gcid;
     }
     $field = '1';
     $pricerange_arr = ($t = trim(C('stat_pricerange'))) ? unserialize($t) : '';
     if ($pricerange_arr) {
         $goodsnum_stat_arr['series'][0]['name'] = '下单商品数';
         $orderamount_stat_arr['series'][0]['name'] = '下单金额';
         //设置价格区间最后一项，最后一项只有开始值没有结束值
         $pricerange_count = count($pricerange_arr);
         if ($pricerange_arr[$pricerange_count - 1]['e']) {
             $pricerange_arr[$pricerange_count]['s'] = $pricerange_arr[$pricerange_count - 1]['e'] + 1;
             $pricerange_arr[$pricerange_count]['e'] = '';
         }
         foreach ((array) $pricerange_arr as $k => $v) {
             $v['s'] = intval($v['s']);
             $v['e'] = intval($v['e']);
             //构造查询字段
             if ($v['e']) {
                 $field .= " ,SUM(IF(goods_pay_price/goods_num > {$v['s']} and goods_pay_price/goods_num <= {$v['e']},goods_num,0)) as goodsnum_{$k}";
                 $field .= " ,SUM(IF(goods_pay_price/goods_num > {$v['s']} and goods_pay_price/goods_num <= {$v['e']},goods_pay_price,0)) as orderamount_{$k}";
             } else {
                 //由于最后一个区间没有结束值，所以需要单独构造sql
                 $field .= " ,SUM(IF(goods_pay_price/goods_num > {$v['s']},goods_num,0)) as goodsnum_{$k}";
                 $field .= " ,SUM(IF(goods_pay_price/goods_num > {$v['s']},goods_pay_price,0)) as orderamount_{$k}";
             }
         }
         $ordergooods_list = $model->getoneByStatordergoods($where, $field);
         if ($ordergooods_list) {
             foreach ((array) $pricerange_arr as $k => $v) {
                 //横轴
                 if ($v['e']) {
                     $goodsnum_stat_arr['xAxis']['categories'][] = $v['s'] . '-' . $v['e'];
                     $orderamount_stat_arr['xAxis']['categories'][] = $v['s'] . '-' . $v['e'];
                 } else {
                     $goodsnum_stat_arr['xAxis']['categories'][] = $v['s'] . '以上';
                     $orderamount_stat_arr['xAxis']['categories'][] = $v['s'] . '以上';
                 }
                 //统计图数据
                 $goodsnum_stat_arr['series'][0]['data'][$k] = 0;
                 $orderamount_stat_arr['series'][0]['data'][$k] = 0;
                 if ($ordergooods_list['goodsnum_' . $k]) {
                     $goodsnum_stat_arr['series'][0]['data'][$k] = intval($ordergooods_list['goodsnum_' . $k]);
                 }
                 if ($ordergooods_list['orderamount_' . $k]) {
                     $orderamount_stat_arr['series'][0]['data'][$k] = intval($ordergooods_list['orderamount_' . $k]);
                 }
             }
         }
         //得到统计图数据
         $goodsnum_stat_arr['legend']['enabled'] = false;
         $goodsnum_stat_arr['title'] = '行业价格下单商品数';
         $goodsnum_stat_arr['yAxis'] = '';
         $orderamount_stat_arr['legend']['enabled'] = false;
         $orderamount_stat_arr['title'] = '行业价格下单金额';
         $orderamount_stat_arr['yAxis'] = '';
         $goodsnum_stat_json = getStatData_LineLabels($goodsnum_stat_arr);
         $orderamount_stat_json = getStatData_LineLabels($orderamount_stat_arr);
     } else {
         $goodsnum_stat_json = '';
         $orderamount_stat_json = '';
     }
     Tpl::output('goodsnum_stat_json', $goodsnum_stat_json);
     Tpl::output('orderamount_stat_json', $orderamount_stat_json);
     Tpl::output('top_link', $this->sublink($this->links, 'price'));
     Tpl::showpage('stat.industry.price');
 }

开发者ID:ff00x0，项目名称:shopnc，代码行数:83，代码来源:stat_industry.php

示例3: priceOp

	/**
	 * 价格销量统计
	 */
	public function priceOp(){
	    if(!$this->search_arr['search_type']){
			$this->search_arr['search_type'] = 'day';
		}
		$model = Model('stat');
		//获得搜索的开始时间和结束时间
		$searchtime_arr = $model->getStarttimeAndEndtime($this->search_arr);
		$where = array();
		$where['store_id'] = $_SESSION['store_id'];
		$where['order_isvalid'] = 1;//计入统计的有效订单
		$where['order_add_time'] = array('between',$searchtime_arr);
		//商品分类
		if ($this->choose_gcid > 0){
		    //获得分类深度
		    $depth = $this->gc_arr[$this->choose_gcid]['depth'];
		    $where['gc_parentid_'.$depth] = $this->choose_gcid;
		}
		$field = '1';
		$pricerange = Model('store_extend')->getfby_store_id($_SESSION['store_id'],'pricerange');
		$pricerange_arr = $pricerange?unserialize($pricerange):array();
		if ($pricerange_arr){
		    $stat_arr['series'][0]['name'] = '下单量';
		    //设置价格区间最后一项，最后一项只有开始值没有结束值
		    $pricerange_count = count($pricerange_arr);
		    if ($pricerange_arr[$pricerange_count-1]['e']){
		        $pricerange_arr[$pricerange_count]['s'] = $pricerange_arr[$pricerange_count-1]['e'] + 1;
		        $pricerange_arr[$pricerange_count]['e'] = '';
		    }
			foreach ((array)$pricerange_arr as $k=>$v){
			    $v['s'] = intval($v['s']);
			    $v['e'] = intval($v['e']);
			    //构造查询字段
			    if ($v['e']){
			        $field .= " ,SUM(IF(goods_pay_price/goods_num > {$v['s']} and goods_pay_price/goods_num <= {$v['e']},goods_num,0)) as goodsnum_{$k}";
			    } else {
			        $field .= " ,SUM(IF(goods_pay_price/goods_num > {$v['s']},goods_num,0)) as goodsnum_{$k}";
			    }
			}
			$ordergooods_list = $model->getoneByStatordergoods($where, $field);
			if($ordergooods_list){
			    foreach ((array)$pricerange_arr as $k=>$v){
			        //横轴
			        if ($v['e']){
			            $stat_arr['xAxis']['categories'][] = $v['s'].'-'.$v['e'];
			        } else {
			            $stat_arr['xAxis']['categories'][] = $v['s'].'以上';
			        }
			        //统计图数据
			        if ($ordergooods_list['goodsnum_'.$k]){
			            $stat_arr['series'][0]['data'][] = intval($ordergooods_list['goodsnum_'.$k]);
			        } else {
			            $stat_arr['series'][0]['data'][] = 0;
			        }
			    }
			}
			//得到统计图数据
    		$stat_arr['title'] = '价格销量分布';
    		$stat_arr['legend']['enabled'] = false;
            $stat_arr['yAxis'] = '销量';
    		$pricerange_statjson = getStatData_LineLabels($stat_arr);
		} else {
		    $pricerange_statjson = '';
		}

		Tpl::output('statjson',$pricerange_statjson);
	    self::profile_menu('price');
	    Tpl::showpage('stat.goods.price');
	}

开发者ID:noikiy，项目名称:ejia，代码行数:71，代码来源:statistics_goods.php

示例4: promotiontrendOp


//.........这里部分代码省略.........
     $model = Model('stat');
     $where = array();
     $searchtime_arr = explode('|', $_GET['t']);
     $where['add_time'] = array('between', $searchtime_arr);
     //$where['order_state'] = array(array('neq',ORDER_STATE_CANCEL),array('neq',ORDER_STATE_NEW),'and');
     $where['order_state'] = array('neq', ORDER_STATE_NEW);
     //去除未支付订单
     $where['refund_state'] = array('exp', "!(order_state = '" . ORDER_STATE_CANCEL . "' and refund_state = 0)");
     //没有参与退款的取消订单，不记录到统计中
     $where['payment_code'] = array('exp', "!(order.payment_code='offline' and order_state <> '" . ORDER_STATE_SUCCESS . "')");
     //货到付款订单，订单成功之后才计入统计
     $where['goods_type'] = array('in', array(2, 3, 4));
     $field = ' goods_type';
     switch ($this->search_arr['stattype']) {
         case 'orderamount':
             $field .= " ,SUM(goods_pay_price) as orderamount";
             $caption = '下单金额';
             break;
         case 'goodsnum':
             $field .= " ,SUM(goods_num) as goodsnum";
             $caption = '下单商品数';
             break;
         default:
             $field .= " ,count(DISTINCT order.order_id) as ordernum";
             $caption = '下单量';
             break;
     }
     if ($this->search_arr['search_type'] == 'day') {
         //构造横轴数据
         for ($i = 0; $i < 24; $i++) {
             //横轴
             $stat_arr['xAxis']['categories'][] = "{$i}";
             foreach ($goodstype_arr as $k => $v) {
                 $statlist[$k][$i] = 0;
             }
         }
         $field .= ' ,HOUR(FROM_UNIXTIME(add_time)) as timeval ';
     }
     if ($this->search_arr['search_type'] == 'week') {
         //构造横轴数据
         for ($i = 1; $i <= 7; $i++) {
             $tmp_weekarr = getSystemWeekArr();
             //横轴
             $stat_arr['xAxis']['categories'][] = $tmp_weekarr[$i];
             unset($tmp_weekarr);
             foreach ($goodstype_arr as $k => $v) {
                 $statlist[$k][$i] = 0;
             }
         }
         $field .= ' ,WEEKDAY(FROM_UNIXTIME(add_time))+1 as timeval ';
     }
     if ($this->search_arr['search_type'] == 'month') {
         //计算横轴的最大量（由于每个月的天数不同）
         $dayofmonth = date('t', $searchtime_arr[0]);
         //构造横轴数据
         for ($i = 1; $i <= $dayofmonth; $i++) {
             //横轴
             $stat_arr['xAxis']['categories'][] = $i;
             foreach ($goodstype_arr as $k => $v) {
                 $statlist[$k][$i] = 0;
             }
         }
         $field .= ' ,day(FROM_UNIXTIME(add_time)) as timeval ';
     }
     //查询数据
     $statlist_tmp = $model->statByOrderGoods($where, $field, 0, '', 'timeval', 'goods_type,timeval');
     //整理统计数组
     if ($statlist_tmp) {
         foreach ($statlist_tmp as $k => $v) {
             //将数据按照不同的促销方式分组
             foreach ($goodstype_arr as $t_k => $t_v) {
                 if ($t_k == $v['goods_type']) {
                     switch ($this->search_arr['stattype']) {
                         case 'orderamount':
                             $statlist[$t_k][$v['timeval']] = round($v[$this->search_arr['stattype']], 2);
                             break;
                         case 'goodsnum':
                             $statlist[$t_k][$v['timeval']] = intval($v[$this->search_arr['stattype']]);
                             break;
                         default:
                             $statlist[$t_k][$v['timeval']] = intval($v[$this->search_arr['stattype']]);
                             break;
                     }
                 }
             }
         }
     }
     foreach ($goodstype_arr as $k => $v) {
         $tmp = array();
         $tmp['name'] = $v;
         $tmp['data'] = array_values($statlist[$k]);
         $stat_arr['series'][] = $tmp;
     }
     //得到统计图数据
     $stat_arr['title'] = $caption . '统计';
     $stat_arr['yAxis'] = $caption;
     $stat_json = getStatData_LineLabels($stat_arr);
     Tpl::output('stat_json', $stat_json);
     Tpl::showpage('stat.linelabels', 'null_layout');
 }

开发者ID:noikiy，项目名称:haifenbao，代码行数:101，代码来源:stat_marketing.php

示例5: generalOp

 /**
  * 促销分析
  */
 public function generalOp()
 {
     $model = Model('stat');
     //统计的日期0点
     $stat_time = strtotime(date('Y-m-d', time())) - 86400;
     /*
      * 近30天
      */
     $stime = $stat_time - 86400 * 29;
     //30天前
     $etime = $stat_time + 86400 - 1;
     //昨天23:59
     $statnew_arr = array();
     //查询订单表下单量、下单金额、下单客户数
     $where = array();
     $where['order_isvalid'] = 1;
     //计入统计的有效订单
     $where['store_id'] = $_SESSION['store_id'];
     $where['order_add_time'] = array('between', array($stime, $etime));
     $field = ' COUNT(*) as ordernum, SUM(order_amount) as orderamount, COUNT(DISTINCT buyer_id) as ordermembernum, AVG(order_amount) as avgorderamount ';
     $stat_order = $model->getoneByStatorder($where, $field);
     $statnew_arr['ordernum'] = ($t = $stat_order['ordernum']) ? $t : 0;
     $statnew_arr['orderamount'] = ncPriceFormat(($t = $stat_order['orderamount']) ? $t : 0);
     $statnew_arr['ordermembernum'] = ($t = $stat_order['ordermembernum']) > 0 ? $t : 0;
     $statnew_arr['avgorderamount'] = ncPriceFormat(($t = $stat_order['avgorderamount']) ? $t : 0);
     unset($stat_order);
     //下单高峰期
     $where = array();
     $where['order_isvalid'] = 1;
     //计入统计的有效订单
     $where['store_id'] = $_SESSION['store_id'];
     $where['order_add_time'] = array('between', array($stime, $etime));
     $field = ' HOUR(FROM_UNIXTIME(order_add_time)) as hourval,COUNT(*) as ordernum ';
     $orderlist = $model->statByStatorder($where, $field, 0, 0, 'ordernum desc,hourval asc', 'hourval');
     foreach ((array) $orderlist as $k => $v) {
         if ($k < 2) {
             //取前两个订单量高的时间段
             if (!$statnew_arr['hothour']) {
                 $statnew_arr['hothour'] = $v['hourval'] . ":00~" . ($v['hourval'] + 1) . ":00";
             } else {
                 $statnew_arr['hothour'] .= "，" . ($v['hourval'] . ":00~" . ($v['hourval'] + 1) . ":00");
             }
         }
     }
     unset($orderlist);
     //查询订单商品表下单商品数
     $where = array();
     $where['order_isvalid'] = 1;
     //计入统计的有效订单
     $where['store_id'] = $_SESSION['store_id'];
     $where['order_add_time'] = array('between', array($stime, $etime));
     $field = ' SUM(goods_num) as ordergoodsnum, AVG(goods_pay_price/goods_num) as avggoodsprice ';
     $stat_ordergoods = $model->getoneByStatordergoods($where, $field);
     $statnew_arr['ordergoodsnum'] = ($t = $stat_ordergoods['ordergoodsnum']) ? $t : 0;
     $statnew_arr['avggoodsprice'] = ncPriceFormat(($t = $stat_ordergoods['avggoodsprice']) ? $t : 0);
     unset($stat_ordergoods);
     //商品总数、收藏量
     $goods_list = $model->statByGoods(array('store_id' => $_SESSION['store_id'], 'is_virtual' => 0), 'COUNT(*) as goodsnum, SUM(goods_collect) as gcollectnum');
     $statnew_arr['goodsnum'] = ($t = $goods_list[0]['goodsnum']) > 0 ? $t : 0;
     $statnew_arr['gcollectnum'] = ($t = $goods_list[0]['gcollectnum']) > 0 ? $t : 0;
     //店铺收藏量
     $store_list = $model->getoneByStore(array('store_id' => $_SESSION['store_id']), 'store_collect');
     $statnew_arr['store_collect'] = ($t = $store_list['store_collect']) > 0 ? $t : 0;
     /*
      * 销售走势
      */
     //构造横轴数据
     for ($i = $stime; $i < $etime; $i += 86400) {
         //当前数据的时间
         $timetext = date('n', $i) . '-' . date('j', $i);
         //统计图数据
         $stat_list[$timetext] = 0;
         //横轴
         $stat_arr['xAxis']['categories'][] = $timetext;
     }
     $where = array();
     $where['order_isvalid'] = 1;
     //计入统计的有效订单
     $where['store_id'] = $_SESSION['store_id'];
     $where['order_add_time'] = array('between', array($stime, $etime));
     $field = ' order_add_time,SUM(order_amount) as orderamount,MONTH(FROM_UNIXTIME(order_add_time)) as monthval,DAY(FROM_UNIXTIME(order_add_time)) as dayval ';
     $stat_order = $model->statByStatorder($where, $field, 0, 0, '', 'monthval,dayval');
     if ($stat_order) {
         foreach ($stat_order as $k => $v) {
             $stat_list[$v['monthval'] . '-' . $v['dayval']] = floatval($v['orderamount']);
         }
     }
     $stat_arr['legend']['enabled'] = false;
     $stat_arr['series'][0]['name'] = '下单金额';
     $stat_arr['series'][0]['data'] = array_values($stat_list);
     //得到统计图数据
     $stat_arr['title'] = '最近30天销售走势';
     $stat_arr['yAxis'] = '下单金额';
     $stattoday_json = getStatData_LineLabels($stat_arr);
     unset($stat_arr);
     /*
      * 7日内商品销售TOP30
//.........这里部分代码省略.........

开发者ID:mengtaolin，项目名称:shopping，代码行数:101，代码来源:statistics_general.php

示例6: newmemberOp


//.........这里部分代码省略.........
         $count_arr['seartime'] = strtotime($this->search_arr['month']['current_year'] . '-' . $this->search_arr['month']['current_month'] . "-01") . '|' . $etime;
         $up_month = date('m', $stime);
         $curr_month = date('m', $etime);
         //计算横轴的最大量（由于每个月的天数不同）
         $up_dayofmonth = date('t', $stime);
         $curr_dayofmonth = date('t', $etime);
         $x_max = $up_dayofmonth > $curr_dayofmonth ? $up_dayofmonth : $curr_dayofmonth;
         //构造横轴数据
         for ($i = 1; $i <= $x_max; $i++) {
             //统计图数据
             $up_arr[$i] = 0;
             $curr_arr[$i] = 0;
             //统计表数据
             $currlist_arr[$i]['timetext'] = $i;
             //方便搜索会员列表，计算开始时间和结束时间
             $currlist_arr[$i]['stime'] = strtotime($this->search_arr['month']['current_year'] . '-' . $this->search_arr['month']['current_month'] . "-01") + ($i - 1) * 86400;
             $currlist_arr[$i]['etime'] = $currlist_arr[$i]['stime'] + 86400 - 1;
             $uplist_arr[$i]['val'] = 0;
             $currlist_arr[$i]['val'] = 0;
             //横轴
             $stat_arr['xAxis']['categories'][] = $i;
             unset($tmp_montharr);
         }
         $where['member_time'] = array('between', array($stime, $etime));
         $field .= ',MONTH(FROM_UNIXTIME(member_time)) as monthval,day(FROM_UNIXTIME(member_time)) as dayval ';
         $memberlist = $model->statByMember($where, $field, 0, '', 'MONTH(FROM_UNIXTIME(member_time)),day(FROM_UNIXTIME(member_time))');
         if ($memberlist) {
             foreach ($memberlist as $k => $v) {
                 if ($up_month == $v['monthval']) {
                     $up_arr[$v['dayval']] = intval($v['allnum']);
                     $uplist_arr[$v['dayval']]['val'] = intval($v['allnum']);
                     $count_arr['up'] += intval($v['allnum']);
                 }
                 if ($curr_month == $v['monthval']) {
                     $curr_arr[$v['dayval']] = intval($v['allnum']);
                     $currlist_arr[$v['dayval']]['val'] = intval($v['allnum']);
                     $count_arr['curr'] += intval($v['allnum']);
                 }
             }
         }
         $stat_arr['series'][0]['name'] = '上月';
         $stat_arr['series'][0]['data'] = array_values($up_arr);
         $stat_arr['series'][1]['name'] = '本月';
         $stat_arr['series'][1]['data'] = array_values($curr_arr);
         //统计数据标题
         $statlist['headertitle'] = array('日期', '上月', '本月', '同比');
         Tpl::output('actionurl', 'index.php?act=stat_member&op=newmember&search_type=month&searchmonth_year=' . $this->search_arr['month']['current_year'] . '&searchmonth_month=' . $this->search_arr['month']['current_month']);
     }
     //计算同比
     foreach ((array) $currlist_arr as $k => $v) {
         $tmp = array();
         $tmp['timetext'] = $v['timetext'];
         $tmp['seartime'] = $v['stime'] . '|' . $v['etime'];
         $tmp['currentdata'] = $v['val'];
         $tmp['updata'] = $uplist_arr[$k]['val'];
         $tmp['tbrate'] = getTb($tmp['updata'], $tmp['currentdata']);
         $statlist['data'][] = $tmp;
     }
     //计算总结同比
     $count_arr['tbrate'] = getTb($count_arr['up'], $count_arr['curr']);
     //导出Excel
     if ($_GET['exporttype'] == 'excel') {
         //导出Excel
         import('libraries.excel');
         $excel_obj = new Excel();
         $excel_data = array();
         //设置样式
         $excel_obj->setStyle(array('id' => 's_title', 'Font' => array('FontName' => '宋体', 'Size' => '12', 'Bold' => '1')));
         //header
         foreach ($statlist['headertitle'] as $v) {
             $excel_data[0][] = array('styleid' => 's_title', 'data' => $v);
         }
         //data
         foreach ($statlist['data'] as $k => $v) {
             $excel_data[$k + 1][] = array('data' => $v['timetext']);
             $excel_data[$k + 1][] = array('format' => 'Number', 'data' => $v['updata']);
             $excel_data[$k + 1][] = array('format' => 'Number', 'data' => $v['currentdata']);
             $excel_data[$k + 1][] = array('data' => $v['tbrate']);
         }
         $excel_data[count($statlist['data']) + 1][] = array('data' => '总计');
         $excel_data[count($statlist['data']) + 1][] = array('format' => 'Number', 'data' => $count_arr['up']);
         $excel_data[count($statlist['data']) + 1][] = array('format' => 'Number', 'data' => $count_arr['curr']);
         $excel_data[count($statlist['data']) + 1][] = array('data' => $count_arr['tbrate']);
         $excel_data = $excel_obj->charset($excel_data, CHARSET);
         $excel_obj->addArray($excel_data);
         $excel_obj->addWorksheet($excel_obj->charset('新增会员统计', CHARSET));
         $excel_obj->generateXML($excel_obj->charset('新增会员统计', CHARSET) . date('Y-m-d-H', time()));
         exit;
     } else {
         //得到统计图数据
         $stat_arr['title'] = '新增会员统计';
         $stat_arr['yAxis'] = '新增会员数';
         $stat_json = getStatData_LineLabels($stat_arr);
         Tpl::output('stat_json', $stat_json);
         Tpl::output('statlist', $statlist);
         Tpl::output('count_arr', $count_arr);
         Tpl::output('top_link', $this->sublink($this->links, 'newmember'));
         Tpl::showpage('stat.newmember');
     }
 }

开发者ID:norain2050，项目名称:xingkang，代码行数:101，代码来源:stat_member.php

示例7: refundOp

 /**
  * 退款统计
  */
 public function refundOp()
 {
     $where = array();
     if (!$this->search_arr['search_type']) {
         $this->search_arr['search_type'] = 'day';
     }
     $model = Model('stat');
     //获得搜索的开始时间和结束时间
     $searchtime_arr = $model->getStarttimeAndEndtime($this->search_arr);
     $field = ' SUM(refund_amount) as amount ';
     if ($this->search_arr['search_type'] == 'day') {
         //构造横轴数据
         for ($i = 0; $i < 24; $i++) {
             $stat_arr['xAxis']['categories'][] = "{$i}";
             $statlist[$i] = 0;
         }
         $field .= ' ,HOUR(FROM_UNIXTIME(add_time)) as timeval ';
     }
     if ($this->search_arr['search_type'] == 'week') {
         //构造横轴数据
         for ($i = 1; $i <= 7; $i++) {
             $tmp_weekarr = getSystemWeekArr();
             //横轴
             $stat_arr['xAxis']['categories'][] = $tmp_weekarr[$i];
             unset($tmp_weekarr);
             $statlist[$i] = 0;
         }
         $field .= ' ,WEEKDAY(FROM_UNIXTIME(add_time))+1 as timeval ';
     }
     if ($this->search_arr['search_type'] == 'month') {
         //计算横轴的最大量（由于每个月的天数不同）
         $dayofmonth = date('t', $searchtime_arr[0]);
         //构造横轴数据
         for ($i = 1; $i <= $dayofmonth; $i++) {
             //横轴
             $stat_arr['xAxis']['categories'][] = $i;
             $statlist[$i] = 0;
         }
         $field .= ' ,day(FROM_UNIXTIME(add_time)) as timeval ';
     }
     $where = array();
     $where['add_time'] = array('between', $searchtime_arr);
     $statlist_tmp = $model->statByRefundreturn($where, $field, 0, 0, 'timeval asc', 'timeval');
     if ($statlist_tmp) {
         foreach ((array) $statlist_tmp as $k => $v) {
             $statlist[$v['timeval']] = floatval($v['amount']);
         }
     }
     //得到统计图数据
     $stat_arr['legend']['enabled'] = false;
     $stat_arr['series'][0]['name'] = '退款金额';
     $stat_arr['series'][0]['data'] = array_values($statlist);
     $stat_arr['title'] = '退款金额统计';
     $stat_arr['yAxis'] = '金额';
     $stat_json = getStatData_LineLabels($stat_arr);
     Tpl::output('stat_json', $stat_json);
     Tpl::output('searchtime', implode('|', $searchtime_arr));
     Tpl::output('top_link', $this->sublink($this->links, 'refund'));
     Tpl::showpage('stat.aftersale.refund');
 }

开发者ID:noikiy，项目名称:shopnc-minion，代码行数:63，代码来源:stat_aftersale.php

示例8: generalOp


//.........这里部分代码省略.........
     $stat_member = $model->getoneByMember($where, $field);
     $statnew_arr['membernum'] = ($t = $stat_member['membernum']) ? $t : 0;
     unset($stat_member);
     //新增店铺
     $where = array();
     $where['store_time'] = array('between', array($stime, $etime));
     $field = ' COUNT(*) as newstore ';
     $stat_store = $model->getoneByStore($where, $field);
     $statnew_arr['newstore'] = ($t = $stat_store['newstore']) ? $t : 0;
     unset($stat_store);
     //店铺总数
     $where = array();
     $field = ' COUNT(*) as storenum ';
     $stat_store = $model->getoneByStore($where, $field);
     $statnew_arr['storenum'] = ($t = $stat_store['storenum']) ? $t : 0;
     unset($stat_store);
     //新增商品，商品总数
     $goods_list = $model->statByGoods(array('is_virtual' => 0), "COUNT(*) as goodsnum, SUM(IF(goods_addtime>={$stime} and goods_addtime<={$etime},1,0)) as newgoods");
     $statnew_arr['goodsnum'] = ($t = $goods_list[0]['goodsnum']) > 0 ? $t : 0;
     $statnew_arr['newgoods'] = ($t = $goods_list[0]['newgoods']) > 0 ? $t : 0;
     /*
      * 昨日销售走势
      */
     //构造横轴数据
     for ($i = 0; $i < 24; $i++) {
         //统计图数据
         $curr_arr[$i] = 0;
         //今天
         $up_arr[$i] = 0;
         //昨天
         //横轴
         $stat_arr['xAxis']['categories'][] = "{$i}";
     }
     $stime = $stat_time - 86400;
     //昨天0点
     $etime = $stat_time + 86400 - 1;
     //今天24点
     $yesterday_day = @date('d', $stime);
     //昨天日期
     $today_day = @date('d', $etime);
     //今天日期
     $where = array();
     $where['order_isvalid'] = 1;
     //计入统计的有效订单
     $where['order_add_time'] = array('between', array($stime, $etime));
     $field = ' SUM(order_amount) as orderamount,DAY(FROM_UNIXTIME(order_add_time)) as dayval,HOUR(FROM_UNIXTIME(order_add_time)) as hourval ';
     $stat_order = $model->statByStatorder($where, $field, 0, 0, '', 'dayval,hourval');
     if ($stat_order) {
         foreach ($stat_order as $k => $v) {
             if ($today_day == $v['dayval']) {
                 $curr_arr[$v['hourval']] = intval($v['orderamount']);
             }
             if ($yesterday_day == $v['dayval']) {
                 $up_arr[$v['hourval']] = intval($v['orderamount']);
             }
         }
     }
     $stat_arr['series'][0]['name'] = '昨天';
     $stat_arr['series'][0]['data'] = array_values($up_arr);
     $stat_arr['series'][1]['name'] = '今天';
     $stat_arr['series'][1]['data'] = array_values($curr_arr);
     //得到统计图数据
     $stat_arr['title'] = date('Y-m-d', $stat_time) . '销售走势';
     $stat_arr['yAxis'] = '销售额';
     $stattoday_json = getStatData_LineLabels($stat_arr);
     unset($stat_arr);
     /*
      * 7日内店铺销售TOP30
      */
     $stime = $stat_time - 86400 * 6;
     //7天前0点
     $etime = $stat_time + 86400 - 1;
     //今天24点
     $where = array();
     $where['order_isvalid'] = 1;
     //计入统计的有效订单
     $where['order_add_time'] = array('between', array($stime, $etime));
     $field = ' SUM(order_amount) as orderamount, store_id, store_name ';
     $storetop30_arr = $model->statByStatorder($where, $field, 0, 0, 'orderamount desc', 'store_id');
     /*
      * 7日内商品销售TOP30
      */
     $stime = $stat_time - 86400 * 6;
     //7天前0点
     $etime = $stat_time + 86400 - 1;
     //今天24点
     $where = array();
     $where['order_isvalid'] = 1;
     //计入统计的有效订单
     $where['order_add_time'] = array('between', array($stime, $etime));
     $field = ' sum(goods_num) as ordergoodsnum, goods_id, goods_name ';
     $goodstop30_arr = $model->statByStatordergoods($where, $field, 0, 30, 'ordergoodsnum desc', 'goods_id');
     Tpl::output('goodstop30_arr', $goodstop30_arr);
     Tpl::output('storetop30_arr', $storetop30_arr);
     Tpl::output('stattoday_json', $stattoday_json);
     Tpl::output('statnew_arr', $statnew_arr);
     Tpl::output('stat_time', $stat_time);
     Tpl::output('top_link', $this->sublink($this->links, 'general'));
     Tpl::showpage('stat.general.index');
 }

开发者ID:flying3615，项目名称:chuniang，代码行数:101，代码来源:stat_general.php

示例9: promotiontrendOp


//.........这里部分代码省略.........
     $goodstype_arr = array(2 => '抢购', 3 => '限时折扣', 4 => '优惠套装');
     $model = Model('stat');
     $where = array();
     $searchtime_arr_tmp = explode('|', $this->search_arr['t']);
     foreach ((array) $searchtime_arr_tmp as $k => $v) {
         $searchtime_arr[] = intval($v);
     }
     $where['order_isvalid'] = 1;
     //计入统计的有效订单
     $where['order_add_time'] = array('between', $searchtime_arr);
     $where['goods_type'] = array('in', array(2, 3, 4));
     $field = ' goods_type';
     switch ($this->search_arr['stattype']) {
         case 'orderamount':
             $field .= " ,SUM(goods_pay_price) as orderamount";
             $caption = '下单金额';
             break;
         case 'goodsnum':
             $field .= " ,SUM(goods_num) as goodsnum";
             $caption = '下单商品数';
             break;
         default:
             $field .= " ,count(DISTINCT order_id) as ordernum";
             $caption = '下单量';
             break;
     }
     if ($this->search_arr['search_type'] == 'day') {
         //构造横轴数据
         for ($i = 0; $i < 24; $i++) {
             //横轴
             $stat_arr['xAxis']['categories'][] = "{$i}";
             foreach ($goodstype_arr as $k => $v) {
                 $statlist[$k][$i] = 0;
             }
         }
         $field .= ' ,HOUR(FROM_UNIXTIME(order_add_time)) as timeval ';
     }
     if ($this->search_arr['search_type'] == 'week') {
         //构造横轴数据
         for ($i = 1; $i <= 7; $i++) {
             $tmp_weekarr = getSystemWeekArr();
             //横轴
             $stat_arr['xAxis']['categories'][] = $tmp_weekarr[$i];
             unset($tmp_weekarr);
             foreach ($goodstype_arr as $k => $v) {
                 $statlist[$k][$i] = 0;
             }
         }
         $field .= ' ,WEEKDAY(FROM_UNIXTIME(order_add_time))+1 as timeval ';
     }
     if ($this->search_arr['search_type'] == 'month') {
         //计算横轴的最大量（由于每个月的天数不同）
         $dayofmonth = date('t', $searchtime_arr[0]);
         //构造横轴数据
         for ($i = 1; $i <= $dayofmonth; $i++) {
             //横轴
             $stat_arr['xAxis']['categories'][] = $i;
             foreach ($goodstype_arr as $k => $v) {
                 $statlist[$k][$i] = 0;
             }
         }
         $field .= ' ,day(FROM_UNIXTIME(order_add_time)) as timeval ';
     }
     //查询数据
     $statlist_tmp = $model->statByStatordergoods($where, $field, 0, 0, 'timeval', 'goods_type,timeval');
     //整理统计数组
     if ($statlist_tmp) {
         foreach ($statlist_tmp as $k => $v) {
             //将数据按照不同的促销方式分组
             foreach ($goodstype_arr as $t_k => $t_v) {
                 if ($t_k == $v['goods_type']) {
                     switch ($this->search_arr['stattype']) {
                         case 'orderamount':
                             $statlist[$t_k][$v['timeval']] = round($v[$this->search_arr['stattype']], 2);
                             break;
                         case 'goodsnum':
                             $statlist[$t_k][$v['timeval']] = intval($v[$this->search_arr['stattype']]);
                             break;
                         default:
                             $statlist[$t_k][$v['timeval']] = intval($v[$this->search_arr['stattype']]);
                             break;
                     }
                 }
             }
         }
     }
     foreach ($goodstype_arr as $k => $v) {
         $tmp = array();
         $tmp['name'] = $v;
         $tmp['data'] = array_values($statlist[$k]);
         $stat_arr['series'][] = $tmp;
     }
     //得到统计图数据
     $stat_arr['title'] = $caption . '统计';
     $stat_arr['yAxis'] = $caption;
     $stat_json = getStatData_LineLabels($stat_arr);
     Tpl::output('stat_json', $stat_json);
     Tpl::output('stattype', $_GET['stattype']);
     Tpl::showpage('stat.linelabels', 'null_layout');
 }

开发者ID:ff00x0，项目名称:shopnc，代码行数:101，代码来源:stat_marketing.php

示例10: saleOp


//.........这里部分代码省略.........
             $curr_arr[$i] = 0;
             //统计表数据
             $uplist_arr[$i]['timetext'] = $i;
             $currlist_arr[$i]['timetext'] = $i;
             $uplist_arr[$i]['val'] = 0;
             $currlist_arr[$i]['val'] = 0;
             //横轴
             $stat_arr['xAxis']['categories'][] = $i;
         }
         $where['add_time'] = array('between', array($stime, $etime));
         $field .= ',MONTH(FROM_UNIXTIME(add_time)) as monthval,day(FROM_UNIXTIME(add_time)) as dayval ';
         $memberlist = $model->getStoreSaleStatList($where, $field, 0, '', 0, 'monthval,dayval');
         if ($memberlist) {
             foreach ($memberlist as $k => $v) {
                 if ($up_month == $v['monthval']) {
                     $up_arr[$v['dayval']] = intval($v['allnum']);
                     $uplist_arr[$v['dayval']]['val'] = intval($v['allnum']);
                 }
                 if ($curr_month == $v['monthval']) {
                     $curr_arr[$v['dayval']] = intval($v['allnum']);
                     $currlist_arr[$v['dayval']]['val'] = intval($v['allnum']);
                 }
             }
         } elseif (trim($_GET['store_name']) != '') {
             Tpl::output('data_null', 'yes');
         }
         $stat_arr['series'][0]['name'] = '上月';
         $stat_arr['series'][0]['data'] = array_values($up_arr);
         $stat_arr['series'][1]['name'] = '本月';
         $stat_arr['series'][1]['data'] = array_values($curr_arr);
         Tpl::output('actionurl', 'index.php?act=stat_trade&op=sale&search_type=month&search_time_year=' . $current_year . '&search_time_month=' . $current_month);
     }
     //统计数据标题
     $statlist['headertitle'] = array('订单号', '买家', '店铺名称', '下单时间', '订单总额', '订单状态');
     //导出Excel
     if ($_GET['exporttype'] == 'excel') {
         //导出Excel
         import('libraries.excel');
         $excel_obj = new Excel();
         $excel_data = array();
         //设置样式
         $excel_obj->setStyle(array('id' => 's_title', 'Font' => array('FontName' => '宋体', 'Size' => '12', 'Bold' => '1')));
         //header
         foreach ($statlist['headertitle'] as $v) {
             $excel_data[0][] = array('styleid' => 's_title', 'data' => $v);
         }
         $order_all_list = $model->getStoreOrderList($where, false);
         //data
         foreach ($order_all_list as $k => $v) {
             $excel_data[$k + 1][] = array('data' => $v['order_sn']);
             $excel_data[$k + 1][] = array('data' => $v['buyer_name']);
             $excel_data[$k + 1][] = array('data' => $v['store_name']);
             $excel_data[$k + 1][] = array('data' => date('Y-m-d H:i:s', $v['add_time']));
             $excel_data[$k + 1][] = array('data' => number_format($v['order_amount'], 2));
             switch ($v['order_state']) {
                 case ORDER_STATE_CANCEL:
                     $excel_data[$k + 1][] = array('data' => '已取消');
                     break;
                 case ORDER_STATE_NEW:
                     $excel_data[$k + 1][] = array('data' => '待付款');
                     break;
                 case ORDER_STATE_PAY:
                     $excel_data[$k + 1][] = array('data' => '待发货');
                     break;
                 case ORDER_STATE_SEND:
                     $excel_data[$k + 1][] = array('data' => '待收货');
                     break;
                 case ORDER_STATE_SUCCESS:
                     $excel_data[$k + 1][] = array('data' => '交易完成');
                     break;
             }
         }
         $excel_data = $excel_obj->charset($excel_data, CHARSET);
         $excel_obj->addArray($excel_data);
         $excel_obj->addWorksheet($excel_obj->charset('订单统计', CHARSET));
         $excel_obj->generateXML($excel_obj->charset('订单统计', CHARSET) . date('Y-m-d-H', time()));
         exit;
     } else {
         $order_list = $model->getStoreOrderList($where);
         //得到统计图数据
         if (trim($_GET['stat_type']) == 'sale') {
             $stat_arr['title'] = '订单销售额统计';
             $stat_arr['yAxis'] = '订单销售额';
         } else {
             $stat_arr['title'] = '订单量统计';
             $stat_arr['yAxis'] = '订单量';
         }
         $stat_json = getStatData_LineLabels($stat_arr);
         //总数统计
         $amount = $model->getStoreSaleStatList($where, ' count(*) as allnum ');
         $sale = $model->getStoreSaleStatList($where, ' sum(order_amount) as allnum ');
         Tpl::output('sum_data', array($amount[0]['allnum'], $sale[0]['allnum']));
         Tpl::output('stat_json', $stat_json);
         Tpl::output('statlist', $statlist);
         Tpl::output('order_list', $order_list);
         Tpl::output('show_page', $model->showpage());
         Tpl::output('top_link', $this->sublink($this->links, 'sale'));
         Tpl::showpage('stat.sale');
     }
 }

开发者ID:Maplecms，项目名称:shopnc-yhmall，代码行数:101，代码来源:stat_trade.php

示例11: buyingOp

 /**
  * 购买分析
  */
 public function buyingOp()
 {
     if (!$this->search_arr['search_type']) {
         $this->search_arr['search_type'] = 'day';
     }
     $model = Model('stat');
     //获得搜索的开始时间和结束时间
     $searchtime_arr = $model->getStarttimeAndEndtime($this->search_arr);
     /*
      * 客单价分布
      */
     $where = array();
     $where['order_isvalid'] = 1;
     //计入统计的有效订单
     $where['order_add_time'] = array('between', $searchtime_arr);
     $field = '1';
     $pricerange_arr = ($t = trim(C('stat_orderpricerange'))) ? unserialize($t) : '';
     if ($pricerange_arr) {
         $stat_arr['series'][0]['name'] = '下单量';
         //设置价格区间最后一项，最后一项只有开始值没有结束值
         $pricerange_count = count($pricerange_arr);
         if ($pricerange_arr[$pricerange_count - 1]['e']) {
             $pricerange_arr[$pricerange_count]['s'] = $pricerange_arr[$pricerange_count - 1]['e'] + 1;
             $pricerange_arr[$pricerange_count]['e'] = '';
         }
         foreach ((array) $pricerange_arr as $k => $v) {
             $v['s'] = intval($v['s']);
             $v['e'] = intval($v['e']);
             //构造查询字段
             if ($v['e']) {
                 $field .= " ,SUM(IF(order_amount > {$v['s']} and order_amount <= {$v['e']},1,0)) as ordernum_{$k}";
             } else {
                 $field .= " ,SUM(IF(order_amount > {$v['s']},1,0)) as ordernum_{$k}";
             }
         }
         $orderlist = $model->getoneByStatorder($where, $field);
         if ($orderlist) {
             foreach ((array) $pricerange_arr as $k => $v) {
                 //横轴
                 if ($v['e']) {
                     $stat_arr['xAxis']['categories'][] = $v['s'] . '-' . $v['e'];
                 } else {
                     $stat_arr['xAxis']['categories'][] = $v['s'] . '以上';
                 }
                 //统计图数据
                 if ($orderlist['ordernum_' . $k]) {
                     $stat_arr['series'][0]['data'][] = intval($orderlist['ordernum_' . $k]);
                 } else {
                     $stat_arr['series'][0]['data'][] = 0;
                 }
             }
         }
         //得到统计图数据
         $stat_arr['title'] = '客单价分布';
         $stat_arr['legend']['enabled'] = false;
         $stat_arr['yAxis'] = '下单量';
         $guestprice_statjson = getStatData_LineLabels($stat_arr);
     } else {
         $guestprice_statjson = '';
     }
     unset($stat_arr);
     /*
      * 购买频次分析
      */
     //统计期间会员下单量
     $where = array();
     $where['statm_time'] = array('between', $searchtime_arr);
     $where['statm_ordernum'] = array('gt', 0);
     $field = 'COUNT(*) as countnum';
     $countnum_arr = $model->getOneStatmember($where, $field);
     $countnum = intval($countnum_arr['countnum']);
     $member_arr = array();
     for ($i = 0; $i < $countnum; $i += 1000) {
         //由于数据库底层的限制，所以每次查询1000条
         $statmember_list = array();
         $statmember_list = $model->statByStatmember($where, 'statm_memberid,statm_ordernum', 0, $i . ',1000', 'statm_id');
         foreach ((array) $statmember_list as $k => $v) {
             $member_arr[$v['statm_memberid']] = intval($member_arr[$v['statm_memberid']]) + intval($v['statm_ordernum']);
         }
     }
     if ($member_arr) {
         //整理期间各个频次的下单客户数
         $stattimes_arr = array();
         for ($i = 1; $i <= 10; $i++) {
             $stattimes_arr[$i] = array('num' => 0, 'rate' => 0.0);
             if ($i >= 10) {
                 $stattimes_arr[$i]['text'] = '期间购买10次以上';
             } else {
                 $stattimes_arr[$i]['text'] = "期间购买{$i}次";
             }
         }
         foreach ($member_arr as $k => $v) {
             if ($v >= 10) {
                 $stattimes_arr[10]['num'] = intval($stattimes_arr[10]['num']) + 1;
             } else {
                 $stattimes_arr[$v]['num'] = intval($stattimes_arr[$v]['num']) + 1;
             }
//.........这里部分代码省略.........

开发者ID:noikiy，项目名称:cunkou，代码行数:101，代码来源:stat_member.php

示例12: storesales_trendsOp

 /**
  * 销售走势
  */
 public function storesales_trendsOp()
 {
     $storeid = intval($_GET['storeid']);
     if ($storeid <= 0) {
         Tpl::output('stat_error', '走势图加载错误');
         Tpl::showpage('stat.store.salestrends');
         exit;
     }
     if (!$_GET['search_type']) {
         $_GET['search_type'] = 'day';
     }
     $model = Model('stat');
     $where = array();
     $where['store_id'] = $storeid;
     $searchtime_arr_tmp = explode('|', $this->search_arr['t']);
     foreach ((array) $searchtime_arr_tmp as $k => $v) {
         $searchtime_arr[] = intval($v);
     }
     $where['order_isvalid'] = 1;
     //计入统计的有效订单
     $where['order_add_time'] = array('between', $searchtime_arr);
     $field = " store_id,store_name,SUM(order_amount) as orderamount, COUNT(*) as ordernum, COUNT(DISTINCT buyer_id) as membernum";
     $stat_arr = array('orderamount' => array(), 'ordernum' => array(), 'membernum' => array());
     $statlist = array();
     if ($_GET['search_type'] == 'day') {
         //构造横轴数据
         for ($i = 0; $i < 24; $i++) {
             //横轴
             foreach ($stat_arr as $k => $v) {
                 $stat_arr[$k]['xAxis']['categories'][] = "{$i}";
                 $statlist[$k][$i] = 0;
             }
         }
         $field .= ' ,HOUR(FROM_UNIXTIME(order_add_time)) as timeval ';
     }
     if ($_GET['search_type'] == 'week') {
         //构造横轴数据
         for ($i = 1; $i <= 7; $i++) {
             $tmp_weekarr = getSystemWeekArr();
             //横轴
             foreach ($stat_arr as $k => $v) {
                 $stat_arr[$k]['xAxis']['categories'][] = $tmp_weekarr[$i];
                 $statlist[$k][$i] = 0;
             }
             unset($tmp_weekarr);
         }
         $field .= ' ,WEEKDAY(FROM_UNIXTIME(order_add_time))+1 as timeval ';
     }
     if ($_GET['search_type'] == 'month') {
         //计算横轴的最大量（由于每个月的天数不同）
         $dayofmonth = date('t', $searchtime_arr[0]);
         //构造横轴数据
         for ($i = 1; $i <= $dayofmonth; $i++) {
             //横轴
             foreach ($stat_arr as $k => $v) {
                 $stat_arr[$k]['xAxis']['categories'][] = $i;
                 $statlist[$k][$i] = 0;
             }
         }
         $field .= ' ,day(FROM_UNIXTIME(order_add_time)) as timeval ';
     }
     //查询数据
     $statlist_tmp = $m

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

PHP getState函数代码示例发布时间：2022-05-15

PHP getStatData_Column2D函数代码示例发布时间：2022-05-15

theindianappguy/machine_learning_flutter

1 Ubuntu14.04下安装matlab2014a

1. 首先现在matlab2014a，http://pan.baidu.com/s/1pJGF5ov [Matlab2014a（密码：en52

阅读：547|2022-07-18

2 bradtraversy/iweather: Ionic 3 mobile we

bradtraversy/iweather: Ionic 3 mobile weather app

阅读：1650|2022-08-30

3 CVE-2020-27732

** REJECT ** DO NOT USE THIS CANDIDATE NUMBER. ConsultIDs: none. Reason: This ca

阅读：1573|2022-07-08

4 joaomh/curso-de-matlab

joaomh/curso-de-matlab

阅读：1211|2022-08-17

5 断牙刷新位置时间（断牙属性及刷新位置介绍

魔兽世界怀旧服已经开启两个多月了，但作为一个猎人玩家，抓到“断牙”，已经成为了一

阅读：1066|2022-11-06

6 rugk/mastodon-simplified-federation: Sim

rugk/mastodon-simplified-federation: Simplifies following and interacting with r

阅读：1134|2022-08-17

7 Tangshitao/Dense-Scene-Matching: Learnin

Tangshitao/Dense-Scene-Matching: Learning Camera Localization via Dense Scene Ma

阅读：821|2022-08-16

8 天的笔顺,讲述天的笔画,解说天的部首

天字笔顺怎么写?天字笔顺笔画顺序是什么?讲述天字的笔画顺序怎么写了解到好多的写字朋

阅读：467|2022-07-30

9 Respring是什么意思?没有越狱设备如何 Resp

相信不少果粉在对自己的设备进行某些操作时，都会碰到Respring，但这个 Respring 到底

阅读：388|2022-11-06

10 ccyrowski/cm-kernel: CyanogenMod Linux K

ccyrowski/cm-kernel: CyanogenMod Linux Kernel

阅读：746|2022-08-15

客服电话

电子邮件

PHP getStatData_LineLabels函数代码示例

示例1: storeflowOp

示例2: priceOp

示例3: priceOp

示例4: promotiontrendOp

示例5: generalOp

示例6: newmemberOp

示例7: refundOp

示例8: generalOp

示例9: promotiontrendOp

示例10: saleOp

示例11: buyingOp

示例12: storesales_trendsOp

请发表评论

全部评论

上一篇：

下一篇：

Ubuntu14.04下安装matlab2014a

bradtraversy/iweather: Ionic 3 mobile we

CVE-2020-27732

joaomh/curso-de-matlab

断牙刷新位置时间（断牙属性及刷新位置介绍

theindianappguy/machine_learning_flutter

切微信小程序前端制作-设备管理主界面

samaxes/minify-maven-plugin: Combine and

挨打的读音是什么？是āi dǎ还是ái dǎ？

nacika-ins/nanachibot: nanachibot is Rus

satoru-takeuchi/linux-in-practice

关于我们

产品与服务

解决方案

139-2527-9053