/home/kueuepay/public_html/app/Http/Controllers/Admin/DashboardController.php
<?php

namespace App\Http\Controllers\Admin;

use Exception;
use App\Models\User;
use App\Models\Transaction;
use Illuminate\Http\Request;
use App\Models\SupportTicket;
use App\Http\Helpers\Response;
use App\Constants\PaymentGatewayConst;
use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\Auth;
use App\Constants\SupportTicketConst;
use App\Models\Admin\PaymentGateway;

class DashboardController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $page_title = "Dashboard";

        //user data

        $total_users     = (User::toBase()->count() == 0) ? 1 : User::toBase()->count();
        $unverified_user = User::toBase()->where('email_verified',0)->count();
        $active_user     = User::toBase()->where('status',true)->count();
        $banned_user     = User::toBase()->where('status',false)->count();
        $user_percent    = (($active_user * 100 ) / $total_users);

        if ($user_percent > 100) {
            $user_percent = 100;
        }

        //Add Money

        $total_add_money     = (Transaction::where('type',PaymentGatewayConst::TYPEADDMONEY)->toBase()->count() == 0) ? 1 : Transaction::where('type',PaymentGatewayConst::TYPEADDMONEY)->toBase()->count();
        $success_add_money         = Transaction::where('type',PaymentGatewayConst::TYPEADDMONEY)->where('status',PaymentGatewayConst::STATUSSUCCESS)->toBase()->count();
        $pending_add_money   = Transaction::where('type',PaymentGatewayConst::TYPEADDMONEY)->where('status',PaymentGatewayConst::STATUSPENDING)->toBase()->count();
        $add_money_percent    = (($success_add_money * 100 ) / $total_add_money);

        if ($add_money_percent > 100) {
            $add_money_percent = 100;
        }

        //transafer money

        $total_transfer_money     = (Transaction::where('type',PaymentGatewayConst::TYPETRANSFERMONEY)->toBase()->count() == 0) ? 1 : Transaction::where('type',PaymentGatewayConst::TYPETRANSFERMONEY)->toBase()->count();
        $success_transfer_money         = Transaction::where('type',PaymentGatewayConst::TYPETRANSFERMONEY)->where('status',PaymentGatewayConst::STATUSSUCCESS)->toBase()->count();
        $pending_transfer_money   = Transaction::where('type',PaymentGatewayConst::TYPETRANSFERMONEY)->where('status',PaymentGatewayConst::STATUSPENDING)->toBase()->count();
        $transfer_money_percent    = (($success_transfer_money * 100 ) / $total_transfer_money);

        if ($transfer_money_percent > 100) {
            $transfer_money_percent = 100;
        }

        //payment

        $total_card_payments     = (Transaction::where('type',PaymentGatewayConst::CARD_PAYMENT)->toBase()->count() == 0) ? 1 : Transaction::where('type',PaymentGatewayConst::CARD_PAYMENT)->toBase()->count();
        $success_card_payments         = Transaction::where('type',PaymentGatewayConst::CARD_PAYMENT)->where('status',PaymentGatewayConst::STATUSSUCCESS)->toBase()->count();
        $pending_card_payments   = Transaction::where('type',PaymentGatewayConst::CARD_PAYMENT)->where('status',PaymentGatewayConst::STATUSPENDING)->toBase()->count();
        $card_payments_percent    = (($success_card_payments * 100 ) / $total_card_payments);

        if ($card_payments_percent > 100) {
            $card_payments_percent = 100;
        }

        //payment

        $total_payment_gateways     = (PaymentGateway::where('status',true)->toBase()->count() == 0) ? 1 : PaymentGateway::where('status',true)->toBase()->count();
        $automatic_gateways         = PaymentGateway::where('type',PaymentGatewayConst::AUTOMATIC)->where('status',true)->toBase()->count();
        $manual_gateways            = PaymentGateway::where('type',PaymentGatewayConst::MANUAL)->where('status',true)->toBase()->count();
        $payment_gateways_percent    = (($automatic_gateways * 100 ) / $total_payment_gateways);

        if ($payment_gateways_percent > 100) {
            $payment_gateways_percent = 100;
        }

        $start = strtotime(date('Y-m-01'));
        $end = strtotime(date('Y-m-31'));


        $pending_data  = [];
        $complete_data  = [];
        $month_day  = [];

        while ($start <= $end) {
            $start_date = date('Y-m-d', $start);
            
            
            $pending = Transaction::where('status', PaymentGatewayConst::STATUSPENDING)->whereDate('created_at',$start_date)->count();
            $complete = Transaction::whereDate('created_at',$start_date)
                                        ->where('status', PaymentGatewayConst::STATUSSUCCESS)
                                        ->count();
            
            $pending_data[]     = $pending;
            $complete_data[]    = $complete;
            $month_day[]        = date('Y-m-d', $start);
            $start              = strtotime('+1 day',$start);
        }
        // Chart one
        $chart_one_data = [
            'pending_data'      => $pending_data,
            'complete_data'     => $complete_data,
            
        ];

        //support ticket

        $total_ticket       = (SupportTicket::toBase()->count() == 0) ? 1 : SupportTicket::toBase()->count();
        $active_ticket      = SupportTicket::toBase()->where('status',SupportTicketConst::ACTIVE)->count();
        $pending_ticket     = SupportTicket::toBase()->where('status',SupportTicketConst::PENDING)->count();

        if($pending_ticket == 0 && $active_ticket != 0){
            $percent_ticket = 100;
        }elseif($pending_ticket == 0 && $active_ticket == 0){
         $percent_ticket = 0;
        }else{
           $percent_ticket = ($active_ticket / ($active_ticket + $pending_ticket)) * 100;
        }
        
        $user_chart = [$active_user, $banned_user,$unverified_user,$total_users];



        $data                                   = [
            'total_users'                       => $total_users,
            'unverified_user'                   => $unverified_user,
            'active_user'                       => $active_user,
            'user_percent'                      => $user_percent,

            'total_add_money'                   => $total_add_money,
            'success_add_money'                 => $success_add_money,
            'pending_add_money'                 => $pending_add_money,
            'add_money_percent'                 => $add_money_percent,

            'total_transfer_money'              => $total_transfer_money,
            'success_transfer_money'            => $success_transfer_money,
            'pending_transfer_money'            => $pending_transfer_money,
            'transfer_money_percent'            => $transfer_money_percent,

            'total_card_payments'               => $total_card_payments,
            'success_card_payments'             => $success_card_payments,
            'pending_card_payments'             => $pending_card_payments,
            'card_payments_percent'             => $card_payments_percent,

            'total_payment_gateways'            => $total_payment_gateways,
            'automatic_gateways'                => $automatic_gateways,
            'manual_gateways'                   => $manual_gateways,
            'payment_gateways_percent'          => $payment_gateways_percent,

            'total_ticket'                      => $total_ticket,
            'active_ticket'                     => $active_ticket,
            'pending_ticket'                    => $pending_ticket,
            'percent_ticket'                    => $percent_ticket,

            'user_chart_data'                   => $user_chart,
            'chart_one_data'                    => $chart_one_data,
            'month_day'                         => $month_day,
            'total_user_count'                  => User::all()->count(),
            'total_add_money_count'             => Transaction::where('type',PaymentGatewayConst::TYPEADDMONEY)->count(),
            'total_transfer_money_count'        => Transaction::where('type',PaymentGatewayConst::TYPETRANSFERMONEY)->count(),
            'total_card_payments_count'         => Transaction::where('type',PaymentGatewayConst::CARD_PAYMENT)->count(),
            'total_support_ticket_count'        => SupportTicket::all()->count(),

        ];


        $transactions         = Transaction::where('type',PaymentGatewayConst::CARD_PAYMENT)->latest()->take(5)->get();
        return view('admin.sections.dashboard.index',compact(
            'page_title',
            'transactions',
            'data',
        ));
    }

    /**
     * Logout Admin From Dashboard
     * @return view
     */
    public function logout(Request $request) {

        $admin = auth()->user();
        pusher_unsubscribe("admin", $admin->id);

        try{
            $admin->update([
                'last_logged_out'   => now(),
                'login_status'      => false,
            ]);
        }catch(Exception $e) {
            // Handle Error
        }

        Auth::guard()->logout();
        $request->session()->invalidate();
        $request->session()->regenerateToken();

        return redirect()->route('admin.login');
    }

    /**
     * Function for clear admin notification
     */
    public function notificationsClear() {
        $admin = auth()->user();

        if(!$admin) {
            return false;
        }

        try{
            $admin->update([
                'notification_clear_at'     => now(),
            ]);
        }catch(Exception $e) {
            $error = ['error' => ['Something went wrong! Please try again.']];
            return Response::error($error,null,404);
        }

        $success = ['success' => ['Notifications clear successfully!']];
        return Response::success($success,null,200);
    }
}
Save Card
top

Save Your Card for Quick and Easy Future Payments Online

Simplify your payment experience by securely saving your card on our platform. After your initial transaction, you can choose to store your card details safely for future use. This feature eliminates the need to re-enter your payment information each time, making checkouts faster while keeping your data secure with advanced encryption and robust security measures.

  • Navigate to the “Save Card” section.
  • Click on “Add Card.”
  • Choose your preferred setup method.
  • Your card is now saved for future payments.
img