/**
* 价格区间统计
*/
public function pricerangeOp()
{
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);
//商品分类
if ($this->choose_gcid > 0) {
//获得分类深度
$depth = $this->gc_arr[$this->choose_gcid]['depth'];
$where['gc_parentid_' . $depth] = $this->choose_gcid;
}
$field = '1';
$pricerange_arr = ($t = trim(C('stat_pricerange'))) ? 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(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 = uk86_getStatData_LineLabels($stat_arr);
} else {
$pricerange_statjson = '';
}
Tpl::output('pricerange_statjson', $pricerange_statjson);
Tpl::output('searchtime', implode('|', $searchtime_arr));
Tpl::output('top_link', $this->sublink($this->links, 'pricerange'));
Tpl::showpage('stat.goods.prange');
}
/**
* 店铺流量统计
*/
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 = uk86_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 = uk86_getStatData_LineLabels($stat_arr);
Tpl::output('stat_json', $stat_json);
self::profile_menu('storeflow');
Tpl::showpage('stat.flow.store');
}
/**
* 促销分析
*/
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'] = uk86_ncPriceFormat(($t = $stat_order['orderamount']) ? $t : 0);
$statnew_arr['ordermembernum'] = ($t = $stat_order['ordermembernum']) > 0 ? $t : 0;
$statnew_arr['avgorderamount'] = uk86_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'] = uk86_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 = uk86_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['store_id'] = $_SESSION['store_id'];
$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');
/**
* 7日内同行热卖商品
*/
$where = array();
$where['order_isvalid'] = 1;
//计入统计的有效订单
$where['order_add_time'] = array('between', array($stime, $etime));
$where['store_id'] = array('neq', $_SESSION['store_id']);
if (!uk86_checkPlatformStore()) {
//如果不是平台店铺，则查询店铺经营类目的同行数据
//查询店铺经营类目
$store_bindclass = Model('store_bind_class')->getStoreBindClassList(array('store_id' => $_SESSION['store_id']));
$goodsclassid_arr = array();
foreach ((array) $store_bindclass as $k => $v) {
if (intval($v['class_3']) > 0) {
$goodsclassid_arr[3][] = intval($v['class_3']);
} elseif (intval($v['class_2']) > 0) {
$goodsclassid_arr[2][] = intval($v['class_2']);
} elseif (intval($v['class_1']) > 0) {
$goodsclassid_arr[1][] = intval($v['class_1']);
}
}
//拼接商品分类条件
if ($goodsclassid_arr) {
ksort($goodsclassid_arr);
$gc_parentidwhere_keyarr = array();
$gc_parentidwhere_arr = array();
foreach ((array) $goodsclassid_arr as $k => $v) {
$gc_parentidwhere_keyarr[] = 'gc_parentid_' . $k;
$gc_parentidwhere_arr[] = array('in', $goodsclassid_arr[$k]);
}
if (count($gc_parentidwhere_keyarr) == 1) {
$where[$gc_parentidwhere_keyarr[0]] = $gc_parentidwhere_arr[0];
} else {
$gc_parentidwhere_arr['_multi'] = '1';
$where[implode('|', $gc_parentidwhere_keyarr)] = $gc_parentidwhere_arr;
}
}
}
$field = ' sum(goods_num) as ordergoodsnum, goods_id, goods_name ';
$othergoodstop30_arr = $model->statByStatordergoods($where, $field, 0, 30, 'ordergoodsnum desc', 'goods_id');
Tpl::output('goodstop30_arr', $goodstop30_arr);
Tpl::output('othergoodstop30_arr', $othergoodstop30_arr);
Tpl::output('stattoday_json', $stattoday_json);
Tpl::output('statnew_arr', $statnew_arr);
Tpl::output('stat_time', $stat_time);
Tpl::showpage('stat.general.index');
}
/**
* 促销分析
*/
public function generalOp()
{
$model = Model('stat');
//统计的日期0点
$stat_time = strtotime(date('Y-m-d', time())) - 86400;
/*
* 昨日最新情报
*/
$stime = $stat_time;
$etime = $stat_time + 86400 - 1;
$statnew_arr = array();
//查询订单表下单量、下单金额、下单客户数、平均客单价
$where = array();
$where['order_isvalid'] = 1;
//计入统计的有效订单
$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 orderavg ';
$stat_order = $model->getoneByStatorder($where, $field);
$statnew_arr['ordernum'] = ($t = $stat_order['ordernum']) ? $t : 0;
$statnew_arr['orderamount'] = uk86_ncPriceFormat(($t = $stat_order['orderamount']) ? $t : 0);
$statnew_arr['ordermembernum'] = ($t = $stat_order['ordermembernum']) ? $t : 0;
$statnew_arr['orderavg'] = uk86_ncPriceFormat(($t = $stat_order['orderavg']) ? $t : 0);
unset($stat_order);
//查询订单商品表下单商品数
$where = array();
$where['order_isvalid'] = 1;
//计入统计的有效订单
$where['order_add_time'] = array('between', array($stime, $etime));
$field = ' SUM(goods_num) as ordergoodsnum,AVG(goods_pay_price/goods_num) as priceavg ';
$stat_ordergoods = $model->getoneByStatordergoods($where, $field);
$statnew_arr['ordergoodsnum'] = ($t = $stat_ordergoods['ordergoodsnum']) ? $t : 0;
$statnew_arr['priceavg'] = uk86_ncPriceFormat(($t = $stat_ordergoods['priceavg']) ? $t : 0);
unset($stat_ordergoods);
//新增会员数
$where = array();
$where['member_time'] = array('between', array($stime, $etime));
$field = ' COUNT(*) as newmember ';
$stat_member = $model->getoneByMember($where, $field);
$statnew_arr['newmember'] = ($t = $stat_member['newmember']) ? $t : 0;
unset($stat_member);
//会员总数
$where = array();
$field = ' COUNT(*) as membernum ';
$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 = uk86_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');
}
/**
* 价格分布
*/
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 = 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'] . '以上';
}
//统计图数据
$stat_arr['series'][0]['data'][$k] = ($t = intval($ordergooods_list['goodsnum_' . $k])) ? $t : 0;
}
}
//得到统计图数据
$stat_arr['legend']['enabled'] = false;
$stat_arr['title'] = '行业价格下单商品数';
$stat_arr['yAxis'] = '';
$stat_json = uk86_getStatData_LineLabels($stat_arr);
} else {
$stat_json = '';
}
Tpl::output('stat_json', $stat_json);
self::profile_menu('price');
Tpl::showpage('stat.industry.price');
}
/**
* 购买分析
*/
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['store_id'] = $_SESSION['store_id'];
$where['order_isvalid'] = 1;
//计入统计的有效订单
$where['order_add_time'] = array('between', $searchtime_arr);
$field = '1';
$pricerange = Model('store_extend')->getfby_store_id($_SESSION['store_id'], 'orderpricerange');
$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(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 = uk86_getStatData_LineLabels($stat_arr);
} else {
$guestprice_statjson = '';
}
unset($stat_arr);
//购买时段分布
$where = array();
$where['store_id'] = $_SESSION['store_id'];
$where['order_isvalid'] = 1;
//计入统计的有效订单
$where['order_add_time'] = array('between', $searchtime_arr);
$field = ' HOUR(FROM_UNIXTIME(order_add_time)) as hourval,COUNT(*) as ordernum ';
$orderlist = $model->statByStatorder($where, $field, 0, 0, 'hourval asc', 'hourval');
$stat_arr = array();
$stat_arr['series'][0]['name'] = '下单量';
//构造横轴坐标
for ($i = 0; $i < 24; $i++) {
//横轴
$stat_arr['xAxis']['categories'][] = $i;
$stat_arr['series'][0]['data'][$i] = 0;
}
foreach ((array) $orderlist as $k => $v) {
//统计图数据
$stat_arr['series'][0]['data'][$v['hourval']] = intval($v['ordernum']);
}
//得到统计图数据
$stat_arr['title'] = '购买时段分布';
$stat_arr['legend']['enabled'] = false;
$stat_arr['yAxis'] = '下单量';
$hour_statjson = uk86_getStatData_LineLabels($stat_arr);
Tpl::output('hour_statjson', $hour_statjson);
Tpl::output('guestprice_statjson', $guestprice_statjson);
self::profile_menu('buying');
Tpl::showpage('stat.sale.buying');
}
/**
* 销售走势
*/
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 = uk86_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 = $model->statByStatorder($where, $field, 0, '', 'timeval', 'timeval');
//整理统计数组
$storename = '';
if ($statlist_tmp) {
foreach ($statlist_tmp as $k => $v) {
$storename = $v['store_name'];
foreach ($stat_arr as $t_k => $t_v) {
if ($k == 'orderamount') {
$statlist[$t_k][$v['timeval']] = round($v[$t_k], 2);
} else {
$statlist[$t_k][$v['timeval']] = intval($v[$t_k]);
}
}
}
}
foreach ($stat_arr as $k => $v) {
$stat_arr[$k]['legend']['enabled'] = false;
switch ($k) {
case 'orderamount':
$caption = '下单金额';
break;
case 'ordernum':
$caption = '下单量';
break;
default:
$caption = '下单会员数';
break;
}
$stat_arr[$k]['series'][0]['name'] = $caption;
$stat_arr[$k]['series'][0]['data'] = array_values($statlist[$k]);
$stat_arr[$k]['title'] = $caption . '走势';
$stat_arr[$k]['yAxis'] = $caption;
//得到统计图数据
$stat_json[$k] = uk86_getStatData_LineLabels($stat_arr[$k]);
}
Tpl::output('storename', $storename);
Tpl::output('stat_json', $stat_json);
Tpl::showpage('stat.store.salestrends', 'null_layout');
}
/**
* 订单走势
*/
public function sale_trendOp()
{
$model = Model('stat');
//存储参数
$this->search_arr = $_REQUEST;
//默认统计当前数据
if (!$this->search_arr['search_type']) {
$this->search_arr['search_type'] = 'day';
}
$where = array();
if (trim($_GET['order_state']) != '') {
$where['order_state'] = trim($_GET['order_state']);
}
if (trim($_GET['store_name']) != '') {
$where['store_name'] = array('like', '%' . trim($_GET['store_name']) . '%');
}
$stattype = trim($_GET['type']);
if ($stattype == 'ordernum') {
$field = ' COUNT(*) as ordernum ';
$stat_arr['title'] = '订单量统计';
$stat_arr['yAxis'] = '订单量';
} else {
$stattype = 'orderamount';
$field = ' SUM(order_amount) as orderamount ';
$stat_arr['title'] = '订单销售额统计';
$stat_arr['yAxis'] = '订单销售额';
}
$searchtime_arr_tmp = explode('|', $this->search_arr['t']);
foreach ((array) $searchtime_arr_tmp as $k => $v) {
$searchtime_arr[] = intval($v);
}
if ($this->search_arr['search_type'] == 'day') {
//构造横轴数据
for ($i = 0; $i < 24; $i++) {
//统计图数据
$curr_arr[$i] = 0;
//今天
$up_arr[$i] = 0;
//昨天
//统计表数据
$currlist_arr[$i]['timetext'] = $i;
$uplist_arr[$i]['val'] = 0;
$currlist_arr[$i]['val'] = 0;
//横轴
$stat_arr['xAxis']['categories'][] = "{$i}";
}
$today_day = @date('d', $searchtime_arr[1]);
//今天日期
$yesterday_day = @date('d', $searchtime_arr[0]);
//昨天日期
$where['order_add_time'] = array('between', $searchtime_arr);
$field .= ' ,DAY(FROM_UNIXTIME(order_add_time)) as dayval,HOUR(FROM_UNIXTIME(order_add_time)) as hourval ';
$orderlist = $model->statByStatorder($where, $field, 0, 0, '', 'dayval,hourval');
foreach ((array) $orderlist as $k => $v) {
if ($today_day == $v['dayval']) {
$curr_arr[$v['hourval']] = intval($v[$stattype]);
$currlist_arr[$v['hourval']]['val'] = $v[$stattype];
}
if ($yesterday_day == $v['dayval']) {
$up_arr[$v['hourval']] = intval($v[$stattype]);
$uplist_arr[$v['hourval']]['val'] = $v[$stattype];
}
}
$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);
}
if ($this->search_arr['search_type'] == 'week') {
$up_week = @date('W', $searchtime_arr[0]);
//上周
$curr_week = @date('W', $searchtime_arr[1]);
//本周
//构造横轴数据
for ($i = 1; $i <= 7; $i++) {
//统计图数据
$up_arr[$i] = 0;
$curr_arr[$i] = 0;
$tmp_weekarr = uk86_getSystemWeekArr();
//统计表数据
$uplist_arr[$i]['timetext'] = $tmp_weekarr[$i];
$currlist_arr[$i]['timetext'] = $tmp_weekarr[$i];
$uplist_arr[$i]['val'] = 0;
$currlist_arr[$i]['val'] = 0;
//横轴
$stat_arr['xAxis']['categories'][] = $tmp_weekarr[$i];
unset($tmp_weekarr);
}
$where['order_add_time'] = array('between', $searchtime_arr);
$field .= ',WEEKOFYEAR(FROM_UNIXTIME(order_add_time)) as weekval,WEEKDAY(FROM_UNIXTIME(order_add_time))+1 as dayofweekval ';
$orderlist = $model->statByStatorder($where, $field, 0, 0, '', 'weekval,dayofweekval');
foreach ((array) $orderlist as $k => $v) {
if ($up_week == $v['weekval']) {
$up_arr[$v['dayofweekval']] = intval($v[$stattype]);
$uplist_arr[$v['dayofweekval']]['val'] = intval($v[$stattype]);
}
if ($curr_week == $v['weekval']) {
$curr_arr[$v['dayofweekval']] = intval($v[$stattype]);
$currlist_arr[$v['dayofweekval']]['val'] = intval($v[$stattype]);
}
}
$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);
}
if ($this->search_arr['search_type'] == 'month') {
$up_month = date('m', $searchtime_arr[0]);
$curr_month = date('m', $searchtime_arr[1]);
//计算横轴的最大量（由于每个月的天数不同）
$up_dayofmonth = date('t', $searchtime_arr[0]);
$curr_dayofmonth = date('t', $searchtime_arr[1]);
$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;
$uplist_arr[$i]['val'] = 0;
$currlist_arr[$i]['val'] = 0;
//横轴
$stat_arr['xAxis']['categories'][] = $i;
}
$where['order_add_time'] = array('between', array($searchtime_arr[0], $searchtime_arr[1]));
$field .= ',MONTH(FROM_UNIXTIME(order_add_time)) as monthval,day(FROM_UNIXTIME(order_add_time)) as dayval ';
$orderlist = $model->statByStatorder($where, $field, 0, 0, '', 'monthval,dayval');
foreach ($orderlist as $k => $v) {
if ($up_month == $v['monthval']) {
$up_arr[$v['dayval']] = intval($v[$stattype]);
$uplist_arr[$v['dayval']]['val'] = intval($v[$stattype]);
}
if ($curr_month == $v['monthval']) {
$curr_arr[$v['dayval']] = intval($v[$stattype]);
$currlist_arr[$v['dayval']]['val'] = intval($v[$stattype]);
}
}
$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_json = uk86_getStatData_LineLabels($stat_arr);
Tpl::output('stat_json', $stat_json);
Tpl::output('stattype', $stattype);
Tpl::showpage('stat.linelabels', 'null_layout');
}
/**
* 退款统计
*/
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 = uk86_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 = uk86_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');
}
/**
* 购买分析
*/
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 = uk86_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;
}
}
//计算期间各个频次的下单客户数占总数比例
foreach ($stattimes_arr as $k => $v) {
$stattimes_arr[$k]['rate'] = round(intval($v['num']) / count($member_arr) * 100, 2);
}
}
//购买时段分布
$where = array();
$where['order_isvalid'] = 1;
//计入统计的有效订单
$where['order_add_time'] = array('between', $searchtime_arr);
$field = ' HOUR(FROM_UNIXTIME(order_add_time)) as hourval,COUNT(*) as ordernum ';
$orderlist = $model->statByStatorder($where, $field, 0, 0, 'hourval asc', 'hourval');
$stat_arr = array();
$stat_arr['series'][0]['name'] = '下单量';
//构造横轴坐标
for ($i = 0; $i < 24; $i++) {
//横轴
$stat_arr['xAxis']['categories'][] = $i;
$stat_arr['series'][0]['data'][$i] = 0;
}
foreach ((array) $orderlist as $k => $v) {
//统计图数据
$stat_arr['series'][0]['data'][$v['hourval']] = intval($v['ordernum']);
}
//得到统计图数据
$stat_arr['title'] = '购买时段分布';
$stat_arr['legend']['enabled'] = false;
$stat_arr['yAxis'] = '下单量';
$hour_statjson = uk86_getStatData_LineLabels($stat_arr);
Tpl::output('hour_statjson', $hour_statjson);
Tpl::output('stattimes_arr', $stattimes_arr);
Tpl::output('guestprice_statjson', $guestprice_statjson);
Tpl::output('top_link', $this->sublink($this->links, 'buying'));
Tpl::showpage('stat.buying');
}
/**
* 促销销售趋势分析
*/
public function 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 = uk86_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 = uk86_getStatData_LineLabels($stat_arr);
Tpl::output('stat_json', $stat_json);
Tpl::output('stattype', $_GET['stattype']);
Tpl::showpage('stat.linelabels', 'null_layout');
}
