123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172 |
- <?php
- namespace app\api\controller;
- use think\facade\Lang;
- class Statisticsgeneral extends MobileSeller
- {
- public function initialize()
- {
- parent::initialize();
- include_once root_path() . 'extend/mall/statistics.php';
- Lang::load(base_path() . 'home/lang/' . config('lang.default_lang') . '/statistics.lang.php');
- }
-
- public function index()
- {
- $stat_model = model('stat');
-
- $stat_time = strtotime(date('Y-m-d', TIMESTAMP)) - 86400;
-
- $stime = $stat_time - (86400 * 29);
- $etime = $stat_time + 86400 - 1;
- $statnew_arr = array();
-
- $where = array();
- $where[] = array('order_isvalid', '=', 1);
- $where[] = array('store_id', '=', session('store_id'));
- $where[] = array('order_add_time', '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 = $stat_model->getoneByStatorder($where, $field);
- $statnew_arr['ordernum'] = ($t = $stat_order['ordernum']) ? $t : 0;
- $statnew_arr['orderamount'] = ds_price_format(($t = $stat_order['orderamount']) ? $t : (0));
- $statnew_arr['ordermembernum'] = ($t = $stat_order['ordermembernum']) > 0 ? $t : 0;
- $statnew_arr['avgorderamount'] = ds_price_format(($t = $stat_order['avgorderamount']) ? $t : (0));
- unset($stat_order);
-
- $where = array();
- $where[] = array('order_isvalid', '=', 1);
- $where[] = array('store_id', '=', session('store_id'));
- $where[] = array('order_add_time', 'between', array($stime, $etime));
- $field = ' HOUR(FROM_UNIXTIME(order_add_time)) as hourval,COUNT(*) as ordernum ';
- $orderlist = $stat_model->statByStatorder($where, $field, 0, 0, 'ordernum desc,hourval asc', 'hourval');
- foreach ((array)$orderlist as $k => $v) {
- if ($k < 2) {
- if (!isset($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[] = array('order_isvalid', '=', 1);
- $where[] = array('store_id', '=', session('store_id'));
- $where[] = array('order_add_time', 'between', array($stime, $etime));
- $field = ' SUM(goods_num) as ordergoodsnum, AVG(goods_pay_price/goods_num) as avggoodsprice ';
- $stat_ordergoods = $stat_model->getoneByStatordergoods($where, $field);
- $statnew_arr['ordergoodsnum'] = ($t = $stat_ordergoods['ordergoodsnum']) ? $t : 0;
- $statnew_arr['avggoodsprice'] = ds_price_format(($t = $stat_ordergoods['avggoodsprice']) ? $t : (0));
- unset($stat_ordergoods);
-
- $goods_list = $stat_model->statByGoods(array('store_id' => session('store_id')), '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 = $stat_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[] = array('order_isvalid', '=', 1);
- $where[] = array('store_id', '=', session('store_id'));
- $where[] = array('order_add_time', '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 = $stat_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'] = lang('place_order_amount');
- $stat_arr['series'][0]['data'] = array_values($stat_list);
-
- $stat_arr['title'] = lang('sales_trends_last_days');
- $stat_arr['yAxis'] = lang('place_order_amount');
- $stattoday_json = getStatData_LineLabels($stat_arr);
- unset($stat_arr);
-
- $stime = $stat_time - 86400 * 6;
- $etime = $stat_time + 86400 - 1;
- $where = array();
- $where[] = array('order_isvalid', '=', 1);
- $where[] = array('store_id', '=', session('store_id'));
- $where[] = array('order_add_time', 'between', array($stime, $etime));
- $field = ' sum(goods_num) as ordergoodsnum, goods_id, goods_name ';
- $goodstop30_arr = $stat_model->statByStatordergoods($where, $field, 0, 30, 'ordergoodsnum desc', 'goods_id');
- $result = array(
- 'goodstop30_arr' => $goodstop30_arr,
- 'stattoday_json' => $stattoday_json,
- 'statnew_arr' => $statnew_arr,
- 'stat_time' => $stat_time,
- );
- ds_json_encode(10000, '', $result);
- }
- }
|