One Hat Cyber Team

Your IP: 216.73.216.142
Server IP: 217.76.53.76
Server: Linux vmi1397931.contaboserver.net 5.4.0-105-generic #119-Ubuntu SMP Mon Mar 7 18:49:24 UTC 2022 x86_64
Server Software: Apache
PHP Version: 8.2.27
Buat File | Buat Folder
Dir : ~/www/wwwroot/ppt.com.ng/app/Http/Controllers/
View File Name : DashboardController.php

<?php

namespace App\Http\Controllers;

use Carbon\Carbon;
use App\Models\User;
use App\Models\Payment;
use App\Models\CardOwner;
use App\Models\Abuse;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use OTIFSolutions\ACLMenu\Models\UserRole;

class DashboardController extends Controller
{
    public function adminDashboard(){

        if (!auth()->user()->hasPermission('READ', env('ADMIN_ROUTE').'_'.\Session::get('current_permission')))
            return response()->json(['Errors' => ['Error' => 'Unauthorized Action']],422);

        $now = Carbon::now();
        $user = Auth::user();
        $localGovtUserIds = CardOwner::where('local_government_id',$user['local_government_id'])->pluck('id');
        return view('dashboard.dashboard',[
            'page' =>[
                'type' => 'dashboard'
            ],
            'adminCount' => User::where('user_role_id',2)->count(),
            'cardOwnersCount' => $user->card_owners()->count(),
            'abuseCount' => Abuse::whereIn('card_owner_id', $localGovtUserIds)->count(),
            'paidAmount' => Payment::where('status','Approved')->whereHas('cardOwners', function ($query) use ($localGovtUserIds) {
                $query->whereIn('card_owner_id', $localGovtUserIds);
            })->sum('amount'),
            'paidAmountMonth' => Payment::where('status','Approved')->whereHas('cardOwners', function ($query) use ($localGovtUserIds) {
                $query->whereIn('card_owner_id', $localGovtUserIds);
            })->whereMonth('payment_date',$now)->sum('amount'),
        ]);
    }
    
    public function naipDashboard(){

        if (!auth()->user()->hasPermission('READ', env('NAIP_MEMBER_ROUTE').'_'.\Session::get('current_permission')))
            return response()->json(['Errors' => ['Error' => 'Unauthorized Action']],422);

        $now = Carbon::now();
        $user = Auth::user();
        $localGovtUserIds = CardOwner::where('local_government_id',$user['local_government_id'])->pluck('id');
        return view('dashboard.dashboard_naip',[
            'page' =>[
                'type' => 'dashboard'
            ],
            'adminCount' => User::where('user_role_id',4)->count(),
            'cardOwnersCount' => $user->card_owners()->count(),
            'abuseCount' => Abuse::whereIn('card_owner_id', $localGovtUserIds)->count(),
            'paidAmount' => Payment::where('status','Approved')->whereHas('cardOwners', function ($query) use ($localGovtUserIds) {
                $query->whereIn('card_owner_id', $localGovtUserIds);
            })->sum('amount'),
            'paidAmountMonth' => Payment::where('status','Approved')->whereHas('cardOwners', function ($query) use ($localGovtUserIds) {
                $query->whereIn('card_owner_id', $localGovtUserIds);
            })->whereMonth('payment_date',$now)->sum('amount'),
        ]);
    }

    public function superDashboard(){

        if (!auth()->user()->hasPermission('READ', env('SUPER_ADMIN_ROUTE').'_'.\Session::get('current_permission')))
            return response()->json(['Errors' => ['Error' => 'Unauthorized Action']],422);

        $now = Carbon::now();
        return view('dashboard.super-dashboard',[
            'page' =>[
                'type' => 'dashboard'
            ],
            'adminCount' => User::where('user_role_id',2)->count(),
            'cardOwnersCount' => CardOwner::count(),
            'abuseCount' => Abuse::count(),
            'paidAmount' => Payment::where('status','Approved')->sum('amount'),
            'paidAmountMonth' => Payment::where('status','Approved')->whereMonth('payment_date',$now)->sum('amount'),
        ]);
    }
}