Blame view

application/admin/controller/exam/Dashboard.php 5.96 KB
2db47680   hexiaodong   chore: 初始提交 php 遗...
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
  <?php

  

  namespace app\admin\controller\exam;

  

  use addons\exam\enum\CommonStatus;

  use addons\exam\enum\PayStatus;

  use addons\exam\enum\RoomSignupStatus;

  use addons\exam\model\UserInfoModel;

  use addons\exam\model\UserModel;

  use app\admin\model\exam\GradeModel;

  use app\admin\model\exam\MemberOrderModel;

  use app\admin\model\exam\PaperModel;

  use app\admin\model\exam\PaperOrderModel;

  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', -30);

          $end_time   = Date::unixtime('day', 0, 'end');

          // $user_join_list    = UserModel::where('createtime', 'between time', [$start_time, $end_time])

          //     ->field('createtime, status, COUNT(*) AS nums, DATE_FORMAT(FROM_UNIXTIME(createtime), "%Y-%m-%d") AS join_date')

          //     ->group('join_date')

          //     ->select();

          $paper_order_list  = PaperOrderModel::where('pay_time', 'between time', [$start_time, $end_time])

              ->where('status', PayStatus::PAID)

              ->field('pay_time, status, SUM(pay_money) as income, DATE_FORMAT(FROM_UNIXTIME(pay_time), "%Y-%m-%d") AS pay_date')

              ->group('pay_date')

              ->select();

          $member_order_list = MemberOrderModel::where('pay_time', 'between time', [$start_time, $end_time])

              ->where('status', PayStatus::PAID)

              ->field('pay_time, status, SUM(pay_money) as income, DATE_FORMAT(FROM_UNIXTIME(pay_time), "%Y-%m-%d") AS pay_date')

              ->group('pay_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 ($user_join_list as $v) {

          //     $user_list[$v['join_date']] = $v['nums'];

          // }

  

          $paper_income_list = array_fill_keys($column, 0);

          foreach ($paper_order_list as $v) {

              $paper_income_list[$v['pay_date']] = $v['income'];

          }

  

          $member_income_list = array_fill_keys($column, 0);

          foreach ($member_order_list as $v) {

              $member_income_list[$v['pay_date']] = $v['income'];

          }

  

          $today_time = Date::unixtime('day', 0, 'begin');

          $data       = [

              // 用户总数

              '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(),

              // 总会员开通人数

              'today_member_order_count'      => MemberOrderModel::where('status', PayStatus::PAID)->count(),

              // 总有效会员

              'total_member_count'            => UserInfoModel::where('expire_time', '>', $today_time)->count(),

              // 今日会员开通收入

              'today_member_pay_money'        => MemberOrderModel::where('pay_time', '>', $today_time)->sum('pay_money'),

              // 总会员开通收入

              'total_member_pay_money'        => MemberOrderModel::where('status', PayStatus::PAID)->sum('pay_money'),

              // 今日付费考试收入

              'today_paper_pay_money'         => PaperOrderModel::where('pay_time', '>', $today_time)->sum('pay_money'),

              // 总付费考试收入

              'total_paper_pay_money'         => PaperOrderModel::where('status', PayStatus::PAID)->sum('pay_money'),

          ];

  

          $data['today_member_pay_money'] = $data['today_member_pay_money'] ?? 0;

          $data['total_member_pay_money'] = $data['total_member_pay_money'] ?? 0;

          $data['today_paper_pay_money']  = $data['today_paper_pay_money'] ?? 0;

          $data['total_paper_pay_money']  = $data['total_paper_pay_money'] ?? 0;

  

          // 总收入

          $data['today_income'] = $data['today_member_pay_money'] + $data['today_paper_pay_money'];

          $data['total_income'] = $data['total_member_pay_money'] + $data['total_paper_pay_money'];

  

          $this->view->assign($data);

          $this->assignconfig('column', array_keys($member_income_list));

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

          $this->assignconfig('paper_income_data', array_values($paper_income_list));

          $this->assignconfig('member_income_data', array_values($member_income_list));

  

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

      }

  

  }