NN2022100801/app/Http/Controllers/Admins/HomeController.php

<?php

namespace App\Http\Controllers\Admins;

use App\Modes\Advertising;
use App\Modes\Upgrade;
use App\Modes\User;
use App\Modes\UserWithdraw;
use Illuminate\Http\Request;
use App\Http\Controllers\Controller;

class HomeController extends Controller
{
    /**
     * @author lyh
     * @date 2019/4/3
     * @modify_author lyh
     * @modify 2019-4-26 11:18:52-确认已区分系统管理员与地区管理员权限
     * @description
     * 当前代理人数(人)
     * 当前广告业务总笔数(笔)
     * 今日注册用户数(人)
     * 当前代理总额(元)
     * 当前广告业务总额(元)
     * 2019-4-26 11:18:52 确认已区分系统管理员与地区管理员权限
     */
    public function statistics(Request $request)
    {
        // 代理人数
        $user = User::whereIsFrontend(1)->whereIn('level', [6, 7])->where('province', '!=', 0);
        if (\Auth::user()->is_super == 3) {
            $user = $user->whereIn('id', getIds());
        }
        $userNum = $user->count('id');

        // 当前广告业务总笔数
        $adver = Advertising::whereIn('status', [3, 9]);
        if (\Auth::user()->is_super == 3) {
            $adver = $adver->whereIn('uid', getIds());
        }
        $adverNum = $adver->count('id');

        //当前代理总额
        $upgrade = Upgrade::whereStatus(3);
        if (\Auth::user()->is_super == 3) {
            $upgrade = $upgrade->whereIn('uid', getIds());
        }
        $proxyNum = $upgrade->sum('money');
        
        //当前广告业务总额
        $adver = Advertising::whereIn('status', [3, 9]);
        if (\Auth::user()->is_super == 3) {
            $adver = $adver->whereIn('uid', getIds());
        }
        $currentAdver = $adver->sum('total_price');

        return showJsonSucc(1001, [
            'userNum' => $userNum,
            'adverNum' => $adverNum,
            'todayUser' => User::getRegByInToday(), // 今日注册用户数
            'proxyMoney' => $proxyNum,
            'currentAdver' => $currentAdver
        ]);
    }

    /**
     * 升级提醒
     * @author lyh
     * @date 2019/4/3
     * @modify_author lyh
     * @modify 2019-4-26 11:23:14-确认已区分系统管理员与地区管理员权限
     * @return \Illuminate\Contracts\Routing\ResponseFactory|\Symfony\Component\HttpFoundation\Response
     * @description
     */
    public function upgrade()
    {
        $where = [
            ['status', '=', 2]
        ];
        $res = Upgrade::getList($where);
        return showJsonSucc(1001, $res);
    }

    /**
     * 提现申请记录
     * @author lyh
     * @date 2019/4/3
     * @modify_author lyh
     * @modify 2019-4-26 11:22:27-确认已区分系统管理员与地区管理员权限
     * @description
     */
    public function withdraw()
    {
        $where = [
            ['uw.status', '=', 0]
        ];
        $res = UserWithdraw::getList($where);
        return showJsonSucc(1001, $res);
    }
}