@extends('admin.admin_dashboard')
@section('admin')



@php

    /* LOGICS */

    
    

    //payments TABLE
    $payments = App\Models\Payment::orderBy('id', 'DESC')->get();

    



     //payments in Espees
    $espees = App\Models\Payment::where('currency', 'ESPEES')->get();
    
     //payments in USD
    $usd =  App\Models\Payment::where('currency', 'usd')->get();


    //payments in GBP
    $gbp =  App\Models\Payment::where('currency', 'gbp')->get();


     //payments in EUR
    $eur =  App\Models\Payment::where('currency', 'eur')->get();

     //payments in CAD
    $cad =  App\Models\Payment::where('currency', 'cad')->get();

     //payments in ZAR
    $zar =  App\Models\Payment::where('currency', 'zar')->get();

     //payments in ngn
    $ngn =  App\Models\Payment::where('currency', 'ngn')->get();


    //payments in Voucher
    $voucher =  App\Models\Payment::where('currency', 'Espees-Voucher')->get();

    
    //users
    $users = App\Models\User::where('role', 'user')->where('status', 1)->latest()->get();



    
    //Total subscription 
   
     $totalSubscriptions = App\Models\Subscription::where('status', 'active')->latest()->get();
   

    //Active subscription
     $activeSubscriptions = App\Models\Subscription::where('status', 'active')
     ->where('end_date', '>', now()) 
     ->count();
                                                   

     //Purchases - E-Book
     $purchases = App\Models\Purchase::where('status', 'active')->latest()->get();


     //Purchases - Print Copies
     $uniqueOrders = App\Models\Order::where('status', 'active')->distinct('payment_id')->count('payment_id');



      //Purchases - Print Copies - Pending
      $pendingUniqueOrders = App\Models\Order::where('status', 'active')->where('order_status', 'pending')->distinct('payment_id')->count('payment_id');


      //Purchases - Print Copies - Processing
      $processingUniqueOrders = App\Models\Order::where('status', 'active')->where('order_status', 'processing')->distinct('payment_id')->count('payment_id');


      
     $adminProfile = Auth::user();



                
@endphp



  {{-- display only to admin with active status --}}
  @if ($adminProfile && $adminProfile->role === 'admin' && $adminProfile->status === '1')



                <div class="page-content">

                    <div class="container-fluid">
                        
                        <!-- start page title -->
                        <div class="row">
                            <div class="col-12">
                                <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                                    <h4 class="mb-sm-0">Admin Dashboard</h4>

                                    <div class="page-title-right">
                                        <ol class="breadcrumb m-0">
                                            <li class="breadcrumb-item"><a href="javascript: void(0);"> LoveWorld Books E-Library</a></li>
                                            <li class="breadcrumb-item active">Dashboard</li>
                                        </ol>
                                    </div>

                                </div>
                            </div>
                        </div>
                        <!-- end page title -->

                        <div class="row">

                         @if (Auth::user()->can('users.all')) 
                            
                         <div class="col-xl-3 col-md-6">
                                <a href="{{ route('all.user') }}">
                                <div class="card">
                                    <div class="card-body">
                                        <div class="d-flex">

                                            <div class="flex-grow-1">
                                                <p class="text-truncate font-size-14 mb-2">Total Users</p>
                                                <h4 class="mb-2"> {{ count($users) }} </h4>
                                                <p class="text-muted mb-0"><span class="text-success fw-bold font-size-14 me-2">  </span>  </p>
                                            </div>

                                            <div class="avatar-sm">
                                                <span class="avatar-title bg-light text-primary rounded-3">
                                                    <i class="ri-user-3-line font-size-24"></i>  
                                                </span>
                                            </div>

                                        </div>                                              
                                    </div><!-- end cardbody -->
                                </div><!-- end card -->
                              </a>
                            </div><!-- end col -->

                          @endif


                          @if (Auth::user()->can('payment.espees')) 

                            <div class="col-xl-3 col-md-6">
                                <a href="{{ route('espees.payment') }}">
                                <div class="card">
                                    <div class="card-body">
                                        <div class="d-flex">
                                            <div class="flex-grow-1">
                                                <p class="text-truncate font-size-14 mb-2"> Espees Payments  </p>
                                                <h5 class="mb-2"> {{ $espees->sum('total_amount') }} ESPEES   </h5>
                                                <p class="text-muted mb-0"> <span class="text-danger fw-bold font-size-12 me-2">  </span> </p>
                                            </div>
                                            <div class="avatar-sm">
                                                <span class="avatar-title bg-light text-success rounded-3">
                                                    <i class="mdi mdi-currency-usd font-size-24"></i>  
                                                </span>
                                            </div>
                                        </div>                                              
                                    </div><!-- end cardbody -->
                                </div><!-- end card -->
                                </a>
                            </div><!-- end col -->

                         @endif


                         @if (Auth::user()->can('payment.usd')) 

                            <div class="col-xl-3 col-md-6">
                                <a href="{{ route('usd.payment') }}">
                                <div class="card">
                                    <div class="card-body">
                                        <div class="d-flex">
                                            <div class="flex-grow-1">
                                                <p class="text-truncate font-size-14 mb-2"> USD Payments  </p>
                                                <h5 class="mb-2">  {{ $usd->sum('total_amount') }}  USD    </h5>
                                                <p class="text-muted mb-0"> <span class="text-danger fw-bold font-size-12 me-2">  </span> </p>
                                            </div>
                                            <div class="avatar-sm">
                                                <span class="avatar-title bg-light text-success rounded-3">
                                                    <i class="mdi mdi-currency-usd font-size-24"></i>  
                                                </span>
                                            </div>
                                        </div>                                              
                                    </div><!-- end cardbody -->
                                </div><!-- end card -->
                               </a>
                            </div><!-- end col -->

                        @endif




                        @if (Auth::user()->can('payment.usd')) 

                            <div class="col-xl-3 col-md-6">
                                <a href="{{ route('usd.payment') }}">
                                <div class="card">
                                    <div class="card-body">
                                        <div class="d-flex">
                                            <div class="flex-grow-1">
                                                <p class="text-truncate font-size-14 mb-2"> GBP Payments  </p>
                                                <h5 class="mb-2">  {{ $gbp->sum('total_amount') }}  GBP    </h5>
                                                <p class="text-muted mb-0"> <span class="text-danger fw-bold font-size-12 me-2">  </span> </p>
                                            </div>
                                            <div class="avatar-sm">
                                                <span class="avatar-title bg-light text-success rounded-3">
                                                    <i class="mdi mdi-currency-usd font-size-24"></i>  
                                                </span>
                                            </div>
                                        </div>                                              
                                    </div><!-- end cardbody -->
                                </div><!-- end card -->
                               </a>
                            </div><!-- end col -->

                        @endif



                        @if (Auth::user()->can('payment.usd')) 

                            <div class="col-xl-3 col-md-6">
                                <a href="{{ route('usd.payment') }}">
                                <div class="card">
                                    <div class="card-body">
                                        <div class="d-flex">
                                            <div class="flex-grow-1">
                                                <p class="text-truncate font-size-14 mb-2"> CAD Payments  </p>
                                                <h5 class="mb-2">  {{ $cad->sum('total_amount') }}  CAD   </h5>
                                                <p class="text-muted mb-0"> <span class="text-danger fw-bold font-size-12 me-2">  </span> </p>
                                            </div>
                                            <div class="avatar-sm">
                                                <span class="avatar-title bg-light text-success rounded-3">
                                                    <i class="mdi mdi-currency-usd font-size-24"></i>  
                                                </span>
                                            </div>
                                        </div>                                              
                                    </div><!-- end cardbody -->
                                </div><!-- end card -->
                               </a>
                            </div><!-- end col -->

                        @endif


                         @if (Auth::user()->can('payment.usd')) 

                            <div class="col-xl-3 col-md-6">
                                <a href="{{ route('usd.payment') }}">
                                <div class="card">
                                    <div class="card-body">
                                        <div class="d-flex">
                                            <div class="flex-grow-1">
                                                <p class="text-truncate font-size-14 mb-2"> EUR Payments  </p>
                                                <h5 class="mb-2">  {{ $eur->sum('total_amount') }}  EUR   </h5>
                                                <p class="text-muted mb-0"> <span class="text-danger fw-bold font-size-12 me-2">  </span> </p>
                                            </div>
                                            <div class="avatar-sm">
                                                <span class="avatar-title bg-light text-success rounded-3">
                                                    <i class="mdi mdi-currency-usd font-size-24"></i>  
                                                </span>
                                            </div>
                                        </div>                                              
                                    </div><!-- end cardbody -->
                                </div><!-- end card -->
                               </a>
                            </div><!-- end col -->

                        @endif


                         @if (Auth::user()->can('payment.usd')) 

                            <div class="col-xl-3 col-md-6">
                                <a href="{{ route('usd.payment') }}">
                                <div class="card">
                                    <div class="card-body">
                                        <div class="d-flex">
                                            <div class="flex-grow-1">
                                                <p class="text-truncate font-size-14 mb-2"> ZAR Payments  </p>
                                                <h5 class="mb-2">  {{ $zar->sum('total_amount') }}  ZAR  </h5>
                                                <p class="text-muted mb-0"> <span class="text-danger fw-bold font-size-12 me-2">  </span> </p>
                                            </div>
                                            <div class="avatar-sm">
                                                <span class="avatar-title bg-light text-success rounded-3">
                                                    <i class="mdi mdi-currency-usd font-size-24"></i>  
                                                </span>
                                            </div>
                                        </div>                                              
                                    </div><!-- end cardbody -->
                                </div><!-- end card -->
                               </a>
                            </div><!-- end col -->

                        @endif


                         @if (Auth::user()->can('payment.usd')) 

                            <div class="col-xl-3 col-md-6">
                                <a href="{{ route('usd.payment') }}">
                                <div class="card">
                                    <div class="card-body">
                                        <div class="d-flex">
                                            <div class="flex-grow-1">
                                                <p class="text-truncate font-size-14 mb-2"> NGN Payments  </p>
                                                <h5 class="mb-2">  {{ $ngn->sum('total_amount') }}  NGN  </h5>
                                                <p class="text-muted mb-0"> <span class="text-danger fw-bold font-size-12 me-2">  </span> </p>
                                            </div>
                                            <div class="avatar-sm">
                                                <span class="avatar-title bg-light text-success rounded-3">
                                                    <i class="mdi mdi-currency-usd font-size-24"></i>  
                                                </span>
                                            </div>
                                        </div>                                              
                                    </div><!-- end cardbody -->
                                </div><!-- end card -->
                               </a>
                            </div><!-- end col -->

                        @endif


                        @if (Auth::user()->can('payment.redemption.voucher')) 

                            <div class="col-xl-3 col-md-6">
                                <a href="{{ route('voucher.payment') }}">
                                <div class="card">
                                    <div class="card-body">
                                        <div class="d-flex">
                                            <div class="flex-grow-1">
                                                <p class="text-truncate font-size-14 mb-2"> Voucher Redeemed  </p>
                                                <h5 class="mb-2">  {{ $voucher->count() }} Vouchers  </h5>
                                                <p class="text-muted mb-0"> <span class="text-danger fw-bold font-size-12 me-2">  </span> </p>
                                            </div>
                                            <div class="avatar-sm">
                                                <span class="avatar-title bg-light text-success rounded-3">
                                                    <i class="mdi mdi-currency-usd font-size-24"></i>  
                                                </span>
                                            </div>
                                        </div>                                              
                                    </div><!-- end cardbody -->
                                </div><!-- end card -->
                                </a>
                            </div><!-- end col -->

                        @endif



                        @if (Auth::user()->can('subscriptions.all')) 
                          
                          <div class="col-xl-3 col-md-6">
                            <a href="{{ route('all.subscription') }}">
                                
                                <div class="card">
                                    <div class="card-body">
                                        <div class="d-flex">
                                            <div class="flex-grow-1">
                                                <p class="text-truncate font-size-14 mb-2"> 
                                                    Total Subscriptions       
                                                 </p>

                                                <h4 class="mb-2">  
                                                    {{ count($totalSubscriptions) }}   
                                                 </h4>
                                               
                                                    <p class="text-muted mb-0"> <span class="text-success fw-bold font-size-14 me-2">  </span>  </p>
                                            </div>

                                            <div class="avatar-sm">
                                                <span class="avatar-title bg-light text-success rounded-3">
                                                    <i class="mdi mdi-currency-btc font-size-24"></i>  
                                                </span>
                                            </div>
                                            
                                        </div>                                            
                                    </div><!-- end cardbody -->
                                </div><!-- end card -->

                               </a>
                            </div><!-- end col -->
                            
                        @endif 



                         @if (Auth::user()->can('subscriptions.active')) 
                          
                          <div class="col-xl-3 col-md-6">
                            <a href="{{ route('active.subscription') }}">
                                
                                <div class="card">
                                    <div class="card-body">
                                        <div class="d-flex">
                                            <div class="flex-grow-1">
                                                <p class="text-truncate font-size-14 mb-2"> 
                                                    Active Subscriptions   
                                                 </p>

                                                <h4 class="mb-2">   
                                                    {{ $activeSubscriptions }} 
                                                 </h4>
                                               
                                                 <p class="text-muted mb-0"> <span class="text-success fw-bold font-size-14 me-2">  </span>  </p>
                                            </div>

                                            <div class="avatar-sm">
                                                <span class="avatar-title bg-light text-success rounded-3">
                                                    <i class="mdi mdi-currency-btc font-size-24"></i>  
                                                </span>
                                            </div>
                                            
                                        </div>                                            
                                    </div><!-- end cardbody -->
                                </div><!-- end card -->

                                </a>
                            </div><!-- end col -->
                        @endif 



                        @if (Auth::user()->can('purchases.all'))

                            <div class="col-xl-3 col-md-6">
                                <a href="{{ route('all.purchase') }}">
                                <div class="card">
                                    <div class="card-body">
                                        <div class="d-flex">
                                            <div class="flex-grow-1">
                                                <p class="text-truncate font-size-14 mb-2">  E-Book Purchases  </p>
                                                <h4 class="mb-2"> {{ count($purchases) }}  </h4>
                                                <p class="text-muted mb-0"><span class="text-success fw-bold font-size-12 me-2"> </span>   </p>
                                            </div>
                                            <div class="avatar-sm">
                                                <span class="avatar-title bg-light text-primary rounded-3">
                                                    <i class="ri-shopping-cart-2-line font-size-24"></i>  
                                                </span>
                                            </div>
                                        </div>                                              
                                    </div><!-- end cardbody -->
                                </div><!-- end card -->
                               </a>
                            </div><!-- end col -->

                        @endif


                        @if (Auth::user()->can('orders.all'))

                            <div class="col-xl-3 col-md-6">
                                <a href="{{ route('all.order') }}">

                                <div class="card">
                                    <div class="card-body">
                                        <div class="d-flex">
                                            <div class="flex-grow-1">
                                                <p class="text-truncate font-size-14 mb-2"> Total Orders  </p>
                                                <h4 class="mb-2"> {{ $uniqueOrders }}  </h4>
                                                <p class="text-muted mb-0"><span class="text-success fw-bold font-size-12 me-2"> </span>   </p>
                                            </div>

                                            <div class="avatar-sm">
                                                <span class="avatar-title bg-light text-primary rounded-3">
                                                    <i class="ri-shopping-cart-2-line font-size-24"></i>  
                                                </span>
                                            </div>
                                        </div>                                              
                                    </div><!-- end cardbody -->
                                </div><!-- end card --> 
                                </a>            
                            </div><!-- end col -->
                        @endif


                        @if (Auth::user()->can('orders.pending'))

                            <div class="col-xl-3 col-md-6">
                              <a href="{{ route('pending.order') }}">
                               
                                <div class="card">
                                    <div class="card-body">
                                        <div class="d-flex">
                                            <div class="flex-grow-1">
                                                <p class="text-truncate font-size-14 mb-2"> 
                                                    Pending Orders
                                                </p>
                                                  
                                                <h4 class="mb-2">  
                                                     {{ $pendingUniqueOrders }}     
                                                </h4>
                                               
                                                <p class="text-muted mb-0"><span class="text-success fw-bold font-size-12 me-2"> </span>   </p>
                                            </div>

                                            <div class="avatar-sm">
                                                <span class="avatar-title bg-light text-primary rounded-3">
                                                    <i class="ri-shopping-cart-2-line font-size-24"></i>  
                                                </span>
                                            </div>
                                        </div>                                              
                                    </div><!-- end cardbody -->
                                </div><!-- end card -->
                               </a>
                            </div><!-- end col -->

                        @endif


                       @if (Auth::user()->can('orders.processing'))

                            <div class="col-xl-3 col-md-6">
                              <a href="{{ route('processing.order') }}">
                               
                                <div class="card">
                                    <div class="card-body">

                                        <div class="d-flex">
                                            <div class="flex-grow-1">

                                                <p class="text-truncate font-size-14 mb-2">  
                                                   Processing Orders
                                                 </p>
                                                  
                                                 <h4 class="mb-2">   
                                                       {{ $processingUniqueOrders }} 
                                                 </h4>
                                               
                                                <p class="text-muted mb-0"><span class="text-success fw-bold font-size-12 me-2"> </span>   </p>
                                            </div>

                                            <div class="avatar-sm">
                                                <span class="avatar-title bg-light text-primary rounded-3">
                                                    <i class="ri-shopping-cart-2-line font-size-24"></i>  
                                                </span>
                                            </div>
                                        </div>   
                                                                                   
                                    </div><!-- end cardbody -->
                                </div><!-- end card -->
                               </a>
                            </div><!-- end col -->

                        @endif

                        </div><!-- end row -->





                        <!-------------------------------------------------------------------->
                        <!-------------------------------------------------------------------->
                        <!-------------------------------------------------------------------->





                     

                      

                        <!--Latest Payments Starts -->
                        @if (Auth::user()->can('payment.all')) 
                        <div class="row">

                            <div class="col-xl-12">
                                <div class="card">
                                    <div class="card-body">
                                       
    
                                        <h4 class="card-title mb-4">Latest Transactions </h4>
    
                                        <div class="table-responsive">

                                           
                                                
                         
                                            <table id="datatable" class="table table-bordered dt-responsive nowrap" style="border-collapse: collapse; border-spacing: 0; width: 100%;">

                                           {{-- <table class="table table-centered mb-0 align-middle table-hover table-nowrap" > --}}
                                                
                                                <thead class="table-light">
                                                    <tr>
                                                        <th> s/n </th>
                                                        <th> user_fullname </th>
                                                        <th> total_amount </th>
                                                        <th> currency </th>
                                                        <th> payment_date </th>
                                                        <th> purpose </th>
                                                        <th> narration </th>
                                                        
                                                        <th> payment_gateway </th>
                                                        <th> status </th>
                                                        
                                                        <th> name </th>
                                                        <th> email </th>
                                                        <th> phone_no </th>

                                                        <th> tx_ref </th>
                                                        <th> payment_ref </th>
                                                    </tr>
                                                </thead><!-- end thead -->


                                                <tbody>

                                                  
                                                    @foreach($payments as $key => $payment)

                                                    <tr>
                                                        <td> {{ $key+1 }} </td>
                                                        <td> {{ $payment->user->title }} {{ $payment->user->firstname }} {{ $payment->user->surname }} </td>
                                                        <td> {{ $payment->total_amount }} </td>
                                                        <td> {{ strtolower($payment->currency) }} </td>
                                                        <td> {{ $payment->payment_date }}</td>
                                                        <td> {{ $payment->purpose }}</td>
                                                        <td> {{ $payment->narration }}</td>
                                                        
                                                        <td> {{ $payment->payment_gateway }}</td>
                                                        <td> {{ $payment->status }} </td>
                                                        
                                                        <td> {{ $payment->name }} </td>
                                                        <td> {{ $payment->email }} </td>
                                                        <td> {{ $payment->phone_number }} </td>

                                                        <td> {{ $payment->tx_ref }} </td>
                                                        <td> {{ $payment->payment_ref }} </td>
                                                    </tr>
                                                     <!-- end -->

                                                     @endforeach
                                                    
                                                    
                                                     
                                                </tbody><!-- end tbody -->
                                            </table> <!-- end table -->
                                        </div>

                                    </div><!-- end card -->
                                </div><!-- end card -->
                            </div>
                            <!-- end col -->

                        </div>
                        <!--Latest Payments ends --> <!-- end row -->
                        @endif




                           


                           






                    </div>
                    
                </div>
                <!-- End Page-content -->


{{-- display only to admin with INactive status --}}
  @elseif ($adminProfile && $adminProfile->role === 'admin' && $adminProfile->status === '0')
               
               


    <div class="container-fluid">
        <div class="row">
           
            <div class="col-sm-6">
                <div class="text-sm-end d-none d-sm-block">
                   
                    <h5 class="text-danger text-center my-5 py-5">  Admin Profile Not Activated. Contact Admin   </h5>
                   
                </div>
            </div>
        </div>
    </div>



  @endif






@endsection