RWACha-API/application/admin/controller/Dashboard.php

<?php

namespace app\admin\controller;

use app\admin\model\Admin;
use app\admin\model\User;
use app\admin\model\OfflineRechargeRecord;
use app\common\model\OfflineRechargeRecordModel;
use app\common\model\OfflineWithdrawRecordModel;
use app\admin\model\LedgerTokenChange;
use app\common\controller\Backend;
use app\common\model\Attachment;
use fast\Date;
use think\Db;

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

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

        }
        $column = [];
        $starttime = Date::unixtime('day', -6);
        $endtime = Date::unixtime('day', 0, 'end');
        $today_time = strtotime(date('Y-m-d'));
        $yestoday_date = [$today_time - 86400, $today_time];
        $joinlist = Db("user")->where('create_time', 'between time', [$starttime, $endtime])
            ->field('create_time, COUNT(*) AS nums, DATE_FORMAT(FROM_UNIXTIME(create_time), "%Y-%m-%d") AS join_date')
            ->group('join_date')
            ->select();
        for ($time = $starttime; $time <= $endtime;) {
            $column[] = date("Y-m-d", $time);
            $time += 86400;
        }
        $userlist = array_fill_keys($column, 0);
        foreach ($joinlist as $k => $v) {
            $userlist[$v['join_date']] = $v['nums'];
        }

        $month_date = date('Y-m-') . '1';
        $this->view->assign([
            'totaluser'         => User::count(),
            'validuser'         => User::where('effective_time', '>', 0)->count(),
            'totaladmin'        => Admin::count(),
            'totalcategory'     => \app\common\model\Category::count(),
            'todayusersignup'   => User::whereTime('create_time', 'today')->count(),
            'threednu'          => User::whereTime('create_time', '-3 days')->count(),
            'sevendnu'          => User::whereTime('create_time', '-7 days')->count(),
            'yestoday_usdt'     => OfflineRechargeRecord::whereBetween('create_time', $yestoday_date)->where('status', OfflineRechargeRecordModel::StatusSuccess)->sum('amount'),
            'yestoday_usdt_num' => OfflineRechargeRecord::whereBetween('create_time', $yestoday_date)->where('status', OfflineRechargeRecordModel::StatusSuccess)->count(),

            'yestoday_out'      => OfflineWithdrawRecordModel::whereBetween('create_time', $yestoday_date)->sum('amount'),
            'yestoday_out_num'  => OfflineWithdrawRecordModel::whereBetween('create_time', $yestoday_date)->count(),

            'all_in_usdt'       => OfflineRechargeRecord::where('status', OfflineRechargeRecordModel::StatusSuccess)->sum('amount'),
            'all_in_usdt_num'   => OfflineRechargeRecord::where('status', OfflineRechargeRecordModel::StatusSuccess)->count(),

            'all_out_usdt'      => OfflineWithdrawRecordModel::where('status', 'in', [2,4])->sum('real_amount'),
            //'all_in-out'         => OfflineRechargeRecord::where('status', 'in', [2,4])->count(),

            'month_in_usdt'     => OfflineRechargeRecord::where('create_time', '>', strtotime($month_date))->where('status', OfflineRechargeRecordModel::StatusSuccess)->sum('amount'),
            'attachmentsize'    => 0,
            'picturenums'       => 0,
            'picturesize'       => 0,
//            'attachmentnums'    => Attachment::count(),
//            'attachmentsize'    => Attachment::sum('filesize'),
//            'picturenums'       => Attachment::where('mimetype', 'like', 'image/%')->count(),
//            'picturesize'       => Attachment::where('mimetype', 'like', 'image/%')->sum('filesize'),
        ]);

        $this->assignconfig('column', array_keys($userlist));
        $this->assignconfig('userdata', array_values($userlist));

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

}