PHP getStatData_Column2D函数代码示例

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

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

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

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

示例1: hotOp

	/**
	 * 行业排行
	 */
	public function hotOp(){
	    $datanum = 30;
	    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);
		$where['store_id'] = array('neq',$_SESSION['store_id']);
		$gc_id_depth = $this->gc_arr[$this->choose_gcid]['depth'];
		if ($this->choose_gcid > 0){
		    $where['gc_parentid_'.$gc_id_depth] = $this->choose_gcid;
		}
		/**
		 * 商品排行
		 */
		$goods_stat_arr = array();
	    //构造横轴数据
		for($i=1; $i<=$datanum; $i++){
		    //数据
		    $goods_stat_arr['series'][0]['data'][] = array('name'=>'','y'=>0);
			//横轴
			$goods_stat_arr['xAxis']['categories'][] = "$i";
		}
        $field = 'goods_id,goods_name,SUM(goods_num) as goodsnum';
		$goods_list = $model->statByStatordergoods($where, $field, 0, $datanum, 'goodsnum desc,goods_id asc', 'goods_id');
		foreach ((array)$goods_list as $k=>$v){
		    $goods_stat_arr['series'][0]['data'][$k] = array('name'=>strval($v['goods_name']),'y'=>floatval($v['goodsnum']));
		}
		//得到统计图数据
		$goods_stat_arr['series'][0]['name'] = '下单商品数';
		$goods_stat_arr['title'] = "行业商品{$datanum}强";
		$goods_stat_arr['legend']['enabled'] = false;
        $goods_stat_arr['yAxis'] = '下单商品数';
		$goods_statjson = getStatData_Column2D($goods_stat_arr);

		Tpl::output('goods_statjson',$goods_statjson);
		Tpl::output('goods_list',$goods_list);
        self::profile_menu('hot');
        Tpl::showpage('stat.industry.hot');
	}

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

示例2: goodsflowOp

	/**
	 * 商品流量统计
	 */
    public function goodsflowOp() {
        $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'] = 'goods';

		$field = ' goods_id,SUM(clicknum) as amount';
		$stat_arr = array();
        //构造横轴数据
        for($i=1; $i<=30; $i++){
			//横轴
			$stat_arr['xAxis']['categories'][] = $i;
			$stat_arr['series'][0]['data'][] = array('name'=>'','y'=>0);
		}
		$statlist_tmp = $model->statByFlowstat($flow_tablename, $where, $field, 0, 30, 'amount desc,goods_id asc', 'goods_id');
		if ($statlist_tmp){
		    $goodsid_arr = array();
    	    foreach((array)$statlist_tmp as $k=>$v){
    	        $goodsid_arr[] = $v['goods_id'];
    		}
    		//查询相应商品
		    $goods_list_tmp = $model->statByGoods(array('goods_id'=>array('in',$goodsid_arr)), $field = 'goods_name,goods_id');
		    foreach ((array)$goods_list_tmp as $k=>$v){
		        $goods_list[$v['goods_id']] = $v;
		    }
		    foreach((array)$statlist_tmp as $k=>$v){
		        $v['goods_name'] = $goods_list[$v['goods_id']];
		        $v['amount'] = floatval($v['amount']);
		        $statlist[] = $v;
		        $stat_arr['series'][0]['data'][$k] = array('name'=>strval($goods_list[$v['goods_id']]['goods_name']),'y'=>floatval($v['amount']));
		    }
		}
        //得到统计图数据
		$stat_arr['legend']['enabled'] = false;
		$stat_arr['series'][0]['name'] = '访问量';
		$stat_arr['title'] = '商品访问量TOP30';
        $stat_arr['yAxis'] = '访问次数';
		$stat_json = getStatData_Column2D($stat_arr);
        Tpl::output('stat_json',$stat_json);
		self::profile_menu('goodsflow');
		Tpl::showpage('stat.flow.goods');
	}

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

示例3: hotgoodsOp

	/**
	 * 热卖商品
	 */
	public function hotgoodsOp(){
	    $topnum = 30;

	    if(!$this->search_arr['search_type']){
			$this->search_arr['search_type'] = 'day';
		}
		$model = Model('stat');
		//获得搜索的开始时间和结束时间
		$searchtime_arr = $model->getStarttimeAndEndtime($this->search_arr);
		$model = Model('stat');
		$where = array();
		$where['store_id'] = $_SESSION['store_id'];
		$where['order_isvalid'] = 1;//计入统计的有效订单
		$where['order_add_time'] = array('between',$searchtime_arr);

		//查询销量top
	    //构造横轴数据
		for($i=1; $i<=$topnum; $i++){
		    //数据
		    $stat_arr['series'][0]['data'][] = array('name'=>'','y'=>0);
			//横轴
			$stat_arr['xAxis']['categories'][] = "$i";
		}
		$field = ' goods_id,goods_name,SUM(goods_num) as goodsnum ';
		$orderby = 'goodsnum desc,goods_id';
		$statlist = array();
		$statlist['goodsnum'] = $model->statByStatordergoods($where, $field, 0, $topnum, $orderby, 'goods_id');
		foreach ((array)$statlist['goodsnum'] as $k=>$v){
		    $stat_arr['series'][0]['data'][$k] = array('name'=>strval($v['goods_name']),'y'=>intval($v['goodsnum']));
		}
		$stat_arr['series'][0]['name'] = '下单商品数';
		$stat_arr['legend']['enabled'] = false;
		//得到统计图数据
		$stat_arr['title'] = '热卖商品TOP'.$topnum;
        $stat_arr['yAxis'] = '下单商品数';
		$stat_json['goodsnum'] = getStatData_Column2D($stat_arr);
		unset($stat_arr);


		//查询下单金额top
		//构造横轴数据
		for($i=1; $i<=$topnum; $i++){
		    //数据
		    $stat_arr['series'][0]['data'][] = array('name'=>'','y'=>0);
			//横轴
			$stat_arr['xAxis']['categories'][] = "$i";
		}
		$field = ' goods_id,goods_name,SUM(goods_pay_price) as orderamount ';
		$orderby = 'orderamount desc,goods_id';
		$statlist['orderamount'] = $model->statByStatordergoods($where, $field, 0, $topnum, $orderby, 'goods_id');
		foreach ((array)$statlist['orderamount'] as $k=>$v){
		    $stat_arr['series'][0]['data'][$k] = array('name'=>strval($v['goods_name']),'y'=>floatval($v['orderamount']));
		}
		$stat_arr['series'][0]['name'] = '下单金额';
		$stat_arr['legend']['enabled'] = false;
		//得到统计图数据
		$stat_arr['title'] = '热卖商品TOP'.$topnum;
        $stat_arr['yAxis'] = '下单金额';
		$stat_json['orderamount'] = getStatData_Column2D($stat_arr);
		Tpl::output('stat_json',$stat_json);
		Tpl::output('statlist',$statlist);
	    self::profile_menu('hotgoods');
	    Tpl::showpage('stat.goods.hotgoods');
	}

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

示例4: rankOp

 /**
  * 行业排行
  */
 public function rankOp()
 {
     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;
     }
     /**
      * 商品排行
      */
     $goods_stat_arr = array();
     //构造横轴数据
     for ($i = 1; $i <= 50; $i++) {
         //数据
         $goods_stat_arr['series'][0]['data'][] = array('name' => '', 'y' => 0);
         //横轴
         $goods_stat_arr['xAxis']['categories'][] = "{$i}";
     }
     $field = 'goods_id,goods_name,SUM(goods_num) as goodsnum';
     $goods_list = $model->statByStatordergoods($where, $field, 0, 50, 'goodsnum desc,goods_id asc', 'goods_id');
     foreach ((array) $goods_list as $k => $v) {
         $goods_stat_arr['series'][0]['data'][$k] = array('name' => strval($v['goods_name']), 'y' => floatval($v['goodsnum']));
     }
     //得到统计图数据
     $goods_stat_arr['series'][0]['name'] = '下单商品数';
     $goods_stat_arr['title'] = "行业商品50强";
     $goods_stat_arr['legend']['enabled'] = false;
     $goods_stat_arr['yAxis'] = '下单商品数';
     $goods_statjson = getStatData_Column2D($goods_stat_arr);
     /**
      * 店铺排行
      */
     $store_stat_arr = array();
     //构造横轴数据
     for ($i = 1; $i <= 30; $i++) {
         //数据
         $store_stat_arr['series'][0]['data'][] = array('name' => '', 'y' => 0);
         //横轴
         $store_stat_arr['xAxis']['categories'][] = "{$i}";
     }
     $field = 'store_id,store_name,COUNT(DISTINCT order_id) as ordernum';
     $store_list = $model->statByStatordergoods($where, $field, 0, 30, 'ordernum desc,store_id asc', 'store_id');
     foreach ((array) $store_list as $k => $v) {
         $store_stat_arr['series'][0]['data'][$k] = array('name' => strval($v['store_name']), 'y' => floatval($v['ordernum']));
     }
     //得到统计图数据
     $store_stat_arr['series'][0]['name'] = '下单量';
     $store_stat_arr['title'] = "行业店铺30强";
     $store_stat_arr['legend']['enabled'] = false;
     $store_stat_arr['yAxis'] = '下单量';
     $store_statjson = getStatData_Column2D($store_stat_arr);
     Tpl::output('goods_statjson', $goods_statjson);
     Tpl::output('goods_list', $goods_list);
     Tpl::output('store_statjson', $store_statjson);
     Tpl::output('store_list', $store_list);
     Tpl::output('top_link', $this->sublink($this->links, 'rank'));
     Tpl::showpage('stat.industry.rank');
 }

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

示例5: hotgoods_listOp

 /**
  * 热卖商品列表
  */
 public function hotgoods_listOp()
 {
     $model = Model('stat');
     switch ($_GET['type']) {
         case 'goodsnum':
             $sort_text = '下单量';
             break;
         default:
             $_GET['type'] = 'orderamount';
             $sort_text = '下单金额';
             break;
     }
     //构造横轴数据
     for ($i = 1; $i <= 50; $i++) {
         //数据
         $stat_arr['series'][0]['data'][] = array('name' => '', 'y' => 0);
         //横轴
         $stat_arr['xAxis']['categories'][] = "{$i}";
     }
     $where = array();
     $where['order_isvalid'] = 1;
     //计入统计的有效订单
     $searchtime_arr_tmp = explode('|', $this->search_arr['t']);
     foreach ((array) $searchtime_arr_tmp as $k => $v) {
         $searchtime_arr[] = intval($v);
     }
     $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 = ' goods_id,goods_name ';
     switch ($_GET['type']) {
         case 'goodsnum':
             $field .= ' ,SUM(goods_num) as goodsnum ';
             $orderby = 'goodsnum desc';
             break;
         default:
             $_GET['type'] = 'orderamount';
             $field .= ' ,SUM(goods_pay_price) as orderamount ';
             $orderby = 'orderamount desc';
             break;
     }
     $orderby .= ',goods_id';
     $statlist = $model->statByStatordergoods($where, $field, 0, 50, $orderby, 'goods_id');
     foreach ((array) $statlist as $k => $v) {
         switch ($_GET['type']) {
             case 'goodsnum':
                 $stat_arr['series'][0]['data'][$k] = array('name' => strval($v['goods_name']), 'y' => intval($v[$_GET['type']]));
                 break;
             case 'orderamount':
                 $stat_arr['series'][0]['data'][$k] = array('name' => strval($v['goods_name']), 'y' => floatval($v[$_GET['type']]));
                 break;
         }
         $statlist[$k]['sort'] = $k + 1;
     }
     $stat_arr['series'][0]['name'] = $sort_text;
     $stat_arr['legend']['enabled'] = false;
     //得到统计图数据
     $stat_arr['title'] = '热卖商品TOP50';
     $stat_arr['yAxis'] = $sort_text;
     $stat_json = getStatData_Column2D($stat_arr);
     Tpl::output('stat_json', $stat_json);
     Tpl::output('statlist', $statlist);
     Tpl::output('sort_text', $sort_text);
     Tpl::output('stat_field', $_GET['type']);
     Tpl::showpage('stat.goods.hotgoods.list', 'null_layout');
 }

开发者ID:xuxuecheng，项目名称:shopnc，代码行数:74，代码来源:stat_goods.php

示例6: analyzeOp

 /**
  * 会员分析
  */
 public function analyzeOp()
 {
     if (!$this->search_arr['search_type']) {
         $this->search_arr['search_type'] = 'day';
     }
     $model = Model('stat');
     //构造横轴数据
     for ($i = 1; $i <= 15; $i++) {
         //横轴
         $stat_arr['xAxis']['categories'][] = $i;
     }
     $stat_arr['title'] = '买家排行Top15';
     $stat_arr['legend']['enabled'] = false;
     //获得搜索的开始时间和结束时间
     $searchtime_arr = $model->getStarttimeAndEndtime($this->search_arr);
     $where = array();
     $where['statm_time'] = array('between', $searchtime_arr);
     //下单量
     $where['statm_ordernum'] = array('gt', 0);
     $field = ' statm_memberid, statm_membername, sum(statm_ordernum) as ordernum ';
     $ordernum_listtop15 = $model->statByStatmember($where, $field, 0, 15, 'ordernum desc,statm_memberid desc', 'statm_memberid');
     $stat_ordernum_arr = $stat_arr;
     $stat_ordernum_arr['series'][0]['name'] = '下单量';
     $stat_ordernum_arr['series'][0]['data'] = array();
     for ($i = 0; $i < 15; $i++) {
         $stat_ordernum_arr['series'][0]['data'][] = array('name' => strval($ordernum_listtop15[$i]['statm_membername']), 'y' => intval($ordernum_listtop15[$i]['ordernum']));
     }
     $stat_ordernum_arr['yAxis'] = '下单量';
     $statordernum_json = getStatData_Column2D($stat_ordernum_arr);
     unset($stat_ordernum_arr);
     Tpl::output('statordernum_json', $statordernum_json);
     Tpl::output('ordernum_listtop15', $ordernum_listtop15);
     //下单商品件数
     $where['statm_goodsnum'] = array('gt', 0);
     $field = ' statm_memberid, statm_membername, sum(statm_goodsnum) as goodsnum ';
     $goodsnum_listtop15 = $model->statByStatmember($where, $field, 0, 15, 'goodsnum desc,statm_memberid desc', 'statm_memberid');
     $stat_goodsnum_arr = $stat_arr;
     $stat_goodsnum_arr['series'][0]['name'] = '下单商品件数';
     $stat_goodsnum_arr['series'][0]['data'] = array();
     for ($i = 0; $i < 15; $i++) {
         $stat_goodsnum_arr['series'][0]['data'][] = array('name' => strval($goodsnum_listtop15[$i]['statm_membername']), 'y' => intval($goodsnum_listtop15[$i]['goodsnum']));
     }
     $stat_goodsnum_arr['yAxis'] = '下单商品件数';
     $statgoodsnum_json = getStatData_Column2D($stat_goodsnum_arr);
     unset($stat_goodsnum_arr);
     Tpl::output('statgoodsnum_json', $statgoodsnum_json);
     Tpl::output('goodsnum_listtop15', $goodsnum_listtop15);
     //下单金额
     $where['statm_orderamount'] = array('gt', 0);
     $field = ' statm_memberid, statm_membername, sum(statm_orderamount) as orderamount ';
     $orderamount_listtop15 = $model->statByStatmember($where, $field, 0, 15, 'orderamount desc,statm_memberid desc', 'statm_memberid');
     $stat_orderamount_arr = $stat_arr;
     $stat_orderamount_arr['series'][0]['name'] = '下单金额';
     $stat_orderamount_arr['series'][0]['data'] = array();
     for ($i = 0; $i < 15; $i++) {
         $stat_orderamount_arr['series'][0]['data'][] = array('name' => strval($orderamount_listtop15[$i]['statm_membername']), 'y' => floatval($orderamount_listtop15[$i]['orderamount']));
     }
     $stat_orderamount_arr['yAxis'] = '下单金额';
     $statorderamount_json = getStatData_Column2D($stat_orderamount_arr);
     unset($stat_orderamount_arr);
     Tpl::output('statorderamount_json', $statorderamount_json);
     Tpl::output('orderamount_listtop15', $orderamount_listtop15);
     Tpl::output('searchtime', implode('|', $searchtime_arr));
     Tpl::output('top_link', $this->sublink($this->links, 'analyze'));
     Tpl::showpage('stat.memberanalyze');
 }

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

示例7: class_saleOp


//.........这里部分代码省略.........
     $condition['order.add_time'] = array('between', array($stime, $etime));
     $condition['order.order_state'] = array('neq', ORDER_STATE_NEW);
     //去除未支付订单
     $condition['order.refund_state'] = array('exp', "!(order_state = '" . ORDER_STATE_CANCEL . "' and refund_state = 0)");
     //没有参与退款的取消订单，不记录到统计中
     $condition['order.payment_code'] = array('exp', "!(order.payment_code='offline' and order.order_state <> '" . ORDER_STATE_SUCCESS . "')");
     //货到付款订单，订单成功之后才计入统计
     if (trim($_GET['class_type']) == '' || trim($_GET['class_type']) == 'goods_class') {
         $type = 'goods';
         if (intval($_GET['cate_id']) > 0) {
             $condition['goods.gc_id'] = intval($_GET['cate_id']);
         }
         Tpl::output('chart_tip', '商品类目销售排名Top10');
     } else {
         $type = 'store';
         if (intval($_GET['store_class']) > 0) {
             $condition['store.sc_id'] = intval($_GET['store_class']);
         }
         Tpl::output('chart_tip', '店铺类目销售排名Top10');
     }
     $model = Model('stat');
     //导出Excel
     if ($_GET['exporttype'] == 'excel') {
         //获取数据
         $data_list = $model->getStoreTradeList($condition, $type);
         //导出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
         if (trim($_GET['class_type']) == '' || trim($_GET['class_type']) == 'goods_class') {
             $excel_data[0][] = array('styleid' => 's_title', 'data' => '商品名称');
             $excel_data[0][] = array('styleid' => 's_title', 'data' => '所属分类');
             $excel_data[0][] = array('styleid' => 's_title', 'data' => '店铺名称');
             $excel_data[0][] = array('styleid' => 's_title', 'data' => '下单单量');
             $excel_data[0][] = array('styleid' => 's_title', 'data' => '下单商品件数');
             $excel_data[0][] = array('styleid' => 's_title', 'data' => '下单金额');
         } else {
             $excel_data[0][] = array('styleid' => 's_title', 'data' => '店铺名称');
             $excel_data[0][] = array('styleid' => 's_title', 'data' => '所属分类');
             $excel_data[0][] = array('styleid' => 's_title', 'data' => '店主账号');
             $excel_data[0][] = array('styleid' => 's_title', 'data' => '下单单量');
             $excel_data[0][] = array('styleid' => 's_title', 'data' => '下单金额');
         }
         //data
         foreach ($data_list as $k => $v) {
             if (trim($_GET['class_type']) == '' || trim($_GET['class_type']) == 'goods_class') {
                 $excel_data[$k + 1][] = array('data' => $v['goods_name']);
                 $excel_data[$k + 1][] = array('data' => $v['gc_name']);
                 $excel_data[$k + 1][] = array('data' => $v['store_name']);
                 $excel_data[$k + 1][] = array('data' => $v['onum']);
                 $excel_data[$k + 1][] = array('data' => $v['gnum']);
                 $excel_data[$k + 1][] = array('data' => $v['pnum']);
             } else {
                 $excel_data[$k + 1][] = array('data' => $v['store_name']);
                 $excel_data[$k + 1][] = array('data' => $v['sc_name']);
                 $excel_data[$k + 1][] = array('data' => $v['member_name']);
                 $excel_data[$k + 1][] = array('data' => $v['onum']);
                 $excel_data[$k + 1][] = array('data' => $v['pnum']);
             }
         }
         $excel_data = $excel_obj->charset($excel_data, CHARSET);
         $excel_obj->addArray($excel_data);
         $excel_obj->addWorksheet($excel_obj->charset(trim($_GET['class_type']) == 'store_class' ? '店铺类目销售排名' : '商品类目销售排名', CHARSET));
         $excel_obj->generateXML($excel_obj->charset(trim($_GET['class_type']) == 'store_class' ? '店铺类目销售排名' : '商品类目销售排名', CHARSET) . date('Y-m-d-H', time()));
         exit;
     } else {
         $data_list = $model->getStoreTradeList($condition, $type, 10);
         Tpl::output('data_list', $data_list);
         $stat_arr['title'] = trim($_GET['class_type']) == 'store_class' ? '店铺类目销售排名' : '商品类目销售排名';
         $stat_arr['yAxis'] = '下单金额';
         $stat_arr['series'][0]['name'] = '下单金额';
         $stat_arr['series'][0]['data'] = array();
         for ($i = 0; $i < 15; $i++) {
             $stat_arr['series'][0]['data'][] = array('name' => strval($data_list[$i][trim($_GET['class_type']) == 'store_class' ? 'store_name' : 'goods_name']), 'y' => floatval($data_list[$i]['pnum']));
         }
         //构造横轴数据
         for ($i = 1; $i <= 15; $i++) {
             //横轴
             $stat_arr['xAxis']['categories'][] = $i;
         }
         $stat_arr['legend']['enabled'] = false;
         $stat_json = getStatData_Column2D($stat_arr);
         Tpl::output('stat_json', $stat_json);
         //店铺分类
         $model_store_class = Model('store_class');
         $parent_list = $model_store_class->getTreeClassList(2);
         if (is_array($parent_list)) {
             foreach ($parent_list as $k => $v) {
                 $parent_list[$k]['sc_name'] = str_repeat("&nbsp;", $v['deep'] * 2) . $v['sc_name'];
             }
         }
         Tpl::output('class_list', $parent_list);
         Tpl::output('goods_class', Model('goods_class')->getTreeClassList(1));
         Tpl::output('top_link', $this->sublink($this->links, 'class_sale'));
         Tpl::showpage('stat.classsale');
     }
 }

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

示例8: rankOp


//.........这里部分代码省略.........
     $year_arr = getSystemYearArr();
     $month_arr = getSystemMonthArr();
     $week_arr = getMonthWeekArr($current_year, $current_month);
     Tpl::output('current_year', $current_year);
     Tpl::output('current_month', $current_month);
     Tpl::output('current_week', $current_week);
     Tpl::output('year_arr', $year_arr);
     Tpl::output('month_arr', $month_arr);
     Tpl::output('week_arr', $week_arr);
     $model = Model('stat');
     if ($_REQUEST['search_type'] == 'day') {
         $stime = $search_time;
         //昨天0点
         $etime = $search_time + 86400 - 1;
         //今天24点
         Tpl::output('actionurl', 'index.php?act=stat_store&op=rank&search_type=day&search_time=' . date('Y-m-d', $search_time));
     }
     if ($_REQUEST['search_type'] == 'week') {
         $current_weekarr = explode('|', $current_week);
         $stime = strtotime($current_weekarr[0]) - 86400 * 7;
         $etime = strtotime($current_weekarr[1]) + 86400 - 1;
         Tpl::output('actionurl', 'index.php?act=stat_store&op=rank&search_type=week&search_time_year=' . $current_year . '&search_time_month=' . $current_month . '&search_time_week=' . $current_week);
     }
     if ($_REQUEST['search_type'] == 'month') {
         $stime = strtotime($current_year . '-' . $current_month . "-01 0 month");
         $etime = getMonthLastDay($current_year, $current_month) + 86400 - 1;
         Tpl::output('actionurl', 'index.php?act=stat_store&op=rank&search_type=month&search_time_year=' . $current_year . '&search_time_month=' . $current_month);
     }
     $where['add_time'] = array('between', array($stime, $etime));
     $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', "!(payment_code='offline' and order_state <> '" . ORDER_STATE_SUCCESS . "')");
     //货到付款订单，订单成功之后才计入统计
     //得到统计图数据
     if (trim($_GET['stat_type']) == 'sale') {
         $store_list = $model->getStoreSaleRank($where, 'sale_amount');
         $statlist['headertitle'] = array('排名', '店铺名称', '销售额');
         $stat_arr['title'] = '店铺销售额排行Top15';
         $stat_arr['yAxis'] = '销售额';
         $stat_arr['series'][0]['name'] = '销售额';
     } else {
         $store_list = $model->getStoreSaleRank($where, 'sale_num');
         $statlist['headertitle'] = array('排名', '店铺名称', '订单量');
         $stat_arr['title'] = '店铺订单量排行Top15';
         $stat_arr['yAxis'] = '订单量';
         $stat_arr['series'][0]['name'] = '订单量';
     }
     //导出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 ($store_list as $k => $v) {
             $excel_data[$k + 1][] = array('data' => $k + 1);
             $excel_data[$k + 1][] = array('data' => $v['store_name']);
             $excel_data[$k + 1][] = array('data' => $v['allnum']);
         }
         $excel_data = $excel_obj->charset($excel_data, CHARSET);
         $excel_obj->addArray($excel_data);
         if (trim($_GET['stat_type']) == 'sale') {
             $excel_obj->addWorksheet($excel_obj->charset('店铺销售额排行Top15', CHARSET));
             $excel_obj->generateXML($excel_obj->charset('店铺销售额排行Top15', CHARSET) . date('Y-m-d-H', time()));
         } else {
             $excel_obj->addWorksheet($excel_obj->charset('店铺订单量排行Top15', CHARSET));
             $excel_obj->generateXML($excel_obj->charset('店铺订单量排行Top15', CHARSET) . date('Y-m-d-H', time()));
         }
         exit;
     } else {
         $stat_arr['series'][0]['data'] = array();
         for ($i = 0; $i < 15; $i++) {
             $stat_arr['series'][0]['data'][] = array('name' => strval($store_list[$i]['store_name']), 'y' => floatval($store_list[$i]['allnum']));
         }
         //构造横轴数据
         for ($i = 1; $i <= 15; $i++) {
             //横轴
             $stat_arr['xAxis']['categories'][] = $i;
         }
         $stat_arr['legend']['enabled'] = false;
         $stat_json = getStatData_Column2D($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('store_list', $store_list);
         Tpl::output('top_link', $this->sublink($this->links, 'rank'));
         Tpl::showpage('stat.storerank');
     }
 }

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

注：本文中的getStatData_Column2D函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有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 getStatData_LineLabels函数代码示例发布时间：2022-05-15

PHP getStat函数代码示例发布时间：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_Column2D函数代码示例

示例1: hotOp

示例2: goodsflowOp

示例3: hotgoodsOp

示例4: rankOp

示例5: hotgoods_listOp

示例6: analyzeOp

示例7: class_saleOp

示例8: rankOp

请发表评论

全部评论

上一篇：

下一篇：

Ubuntu14.04下安装matlab2014a

CVE-2020-27732

librespeed/speedtest: Self-hosted Speedt

avehtari/BDA_m_demos: Bayesian Data Anal

四维彩超怎么看性别？四维看男孩女孩诀窍

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