NN2023021801/app/admin/controller/informational/Yesterdaydata.php

<?php


namespace app\admin\controller\informational;


use app\common\model\ShopCategory;
use app\admin\traits\Curd;
use app\common\controller\AdminController;
use EasyAdmin\annotation\ControllerAnnotation;
use EasyAdmin\annotation\NodeAnotation;
use think\App;
use think\facade\Db;
use think\Model;

/**
 * Class Admin
 * @package app\admin\controller\system
 * @ControllerAnnotation(title="昨日数据管理")
 */
class Yesterdaydata extends AdminController
{

    use Curd;

    public function __construct(App $app)
    {
        parent::__construct($app);
        $this->model = new ShopCategory();
    }

    /**
     * @NodeAnotation(title="后台数据列表")
     */
    public function index(){
        $res = [
            // 昨日数据
            'yesterday'=>sr_getcurtime(time()-86400, 'Y年-m月-d日'),
            'yesterday_register'=>Db::name('user')->whereDay('reg_time', 'yesterday')->count('id'),
            'yesterday_recharge'=>Db::name('payment')->whereIn('order_type', [4,5])->where('state', 6)->whereDay('creat_at', 'yesterday')->sum('total_fee'),
            'yesterday_withdraw'=>Db::name('withdraw_log')->where('status', 1)->whereDay('creat_at', 'yesterday')->sum('practical_money'),

            // 今日数据
            'today'=>sr_getcurtime(time(), 'Y年-m月-d日'),
            'today_register'=>Db::name('user')->whereDay('reg_time', 'today')->count('id'),
            'today_recharge'=>Db::name('payment')->whereIn('order_type', [4,5])->where('state', 6)->whereDay('creat_at', 'today')->sum('total_fee'),
            'today_withdraw'=>Db::name('withdraw_log')->where('status', 1)->whereDay('creat_at', 'today')->sum('practical_money'),

        ];

        $this->assign('res', $res);
        return $this->fetch();
    }



}