shequ/application/admin/controller/exam/Dashboard.php

<?php

namespace app\admin\controller\exam;

use addons\exam\enum\CommonStatus;
use addons\exam\enum\RoomSignupStatus;
use addons\exam\model\UserModel;
use app\admin\model\exam\GradeModel;
use app\admin\model\exam\PaperModel;
use app\admin\model\exam\QuestionModel;
use app\admin\model\exam\RoomGradeModel;
use app\admin\model\exam\RoomModel;
use app\admin\model\exam\RoomSignupModel;
use app\common\controller\Backend;
use fast\Date;

/**
 * 控制台
 * @icon   fa fa-dashboard
 * @remark 用于展示当前系统中的统计数据、统计报表及重要实时数据
 */
class Dashboard extends Backend
{

    /**
     * 查看
     */
    public function index()
    {
        try {
            \think\Db::execute("SET @@sql_mode='';");
        } catch (\Exception $e) {

        }

        $column     = [];
        $start_time = Date::unixtime('day', -6);
        $end_time   = Date::unixtime('day', 0, 'end');
        $join_list  = UserModel::where('jointime', 'between time', [$start_time, $end_time])
            ->field('jointime, status, COUNT(*) AS nums, DATE_FORMAT(FROM_UNIXTIME(jointime), "%Y-%m-%d") AS join_date')
            ->group('join_date')
            ->select();

        for ($time = $start_time; $time <= $end_time;) {
            $column[] = date("Y-m-d", $time);
            $time     += 86400;
        }
        $user_list = array_fill_keys($column, 0);
        foreach ($join_list as $k => $v) {
            $user_list[$v['join_date']] = $v['nums'];
        }

        $today_time = Date::unixtime('day', 0, 'begin');
        $this->view->assign([
            // 用户总数
            'total_user_count'              => UserModel::count(),
            // 今日新增用户数
            'today_user_count'              => UserModel::where('createtime', '>', $today_time)->count(),
            // 总题数
            'total_question_count'          => QuestionModel::where('status', CommonStatus::NORMAL)->count(),
            // 总试卷数
            'total_paper_count'             => PaperModel::where('status', CommonStatus::NORMAL)->count(),
            // 总考场数
            'total_room_count'              => RoomModel::where('status', CommonStatus::NORMAL)->count(),
            // 总参与考试次数
            'total_exam_user_count'         => GradeModel::count(),
            // 今日参与考试次数
            'today_exam_user_count'         => GradeModel::where('createtime', '>', $today_time)->count(),
            // 总参与考场考试次数
            'total_room_user_count'         => RoomGradeModel::count(),
            // 今日参与考场考试次数
            'today_room_user_count'         => RoomGradeModel::where('createtime', '>', $today_time)->count(),
            // 待处理报名数量
            'total_wait_apply_signup_count' => RoomSignupModel::where('status', RoomSignupStatus::WAIT)->count(),
        ]);

        $this->assignconfig('column', array_keys($user_list));
        $this->assignconfig('user_data', array_values($user_list));

        return $this->view->fetch();
    }

}