qimall/addons/BusinessCard/backend/controllers/DefaultController.php

<?php

namespace addons\BusinessCard\backend\controllers;

use addons\BusinessCard\common\models\BusinessCardStatistics;
use Yii;

class DefaultController extends BaseController
{   

    /**
     * 数据概况，排行榜
     * 
     * @author hpei
     * @return mixed
     */
    public function actionIndex() {
        if (Yii::$app->request->isAjax && Yii::$app->request->isGet) {
            $where = [['=', 'mall_id', $this->mall_id]];
            $select = ['sum(card_num) card_num', 'sum(browse_num) browse_num'];
            $allData = BusinessCardStatistics::getList($where, $select, 'mall_id');
            $list['allData'] = $allData[0];
            return $this->success('success', $list);
        }
        return $this->render('index');
    }

    /**
     * 图表数据
     * 
     * @param int date 天数 defalut 7
     * @author hpei
     * @return array
     */
    public function actionChart() {
        $list = [];
        if (Yii::$app->request->isAjax && Yii::$app->request->isGet) {
            $date = Yii::$app->request->get('date');
            $date = $date == '' ? 7 : $date;
            $start_time = strtotime("-$date day 0:0:0");
            $start_time += 86400;
            $end_time = $start_time + ($date * 86400) - 1;
            $where = [['>=', 'created_at', $start_time], ['<=', 'created_at', $end_time], ['=', 'mall_id', $this->mall_id]];
            $list = BusinessCardStatistics::getList($where, ['card_num', 'browse_num', 'created_at']);
            $data['date'] = [];
            $user_views = [];//浏览量
            $card_num = [];//名片总数
            //初始化统计
            for ($i = $start_time; $i < $end_time; $i += 86400) {
                $data['date'][] = date('Y-m-d', $i);
                array_push($user_views, 0);
                array_push($card_num, 0);
            }
            if (!empty($list)) {
                foreach ($list as $val) {
                    if (in_array(date('Y-m-d', $val['created_at']), $data['date'])) {
                        $index = array_search(date('Y-m-d', $val['created_at']), $data['date']);
                        $user_views[$index] += $val['browse_num'];
                        $card_num[$index] += $val['card_num'];
                    }
                }
            }
            $data['series'] = compact(['clue_num', 'user_views', 'card_num', 'order_num', 'order_money']);
        }
        return $this->success('操作成功', $data);
    }

    public function setData($users, $data, $s) {
        var_dump($data);
    }

}