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



@php

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

   
    
    //payments in USD and currency
    //$usds =  App\Models\Payment::where('currency', 'usd')->orderBy('id', 'DESC')->get();
    $usds = App\Models\Payment::whereIn('currency', ['usd', 'eur', 'cad', 'gbp', 'ngn', 'zar'])
    ->orderBy('id', 'DESC')
    ->get();



          

@endphp




<div class="page-content">
  
    <!--breadcrumb-->
    <div class="page-breadcrumb d-none d-sm-flex align-items-center mb-3"> 
        <div class="ps-3">
            <nav aria-label="breadcrumb">
                <ol class="breadcrumb mb-0 p-0">

                    <li class="breadcrumb-item">
                        <a href="{{ route('admin.dashboard') }}"> <i class="bx bx-home-alt"> </i> </a>
                    </li>

                    <li class="breadcrumb-item active" aria-current="page">Currency  Payments </li>

                </ol>
            </nav>
        </div>
        <div class="ms-auto">
            <div class="btn-group">

                @if (Auth::user()->can('payment.all'))
                   <a href="{{ route('all.payment') }}" class="btn btn-primary px-5">All Payments </a>  
              @endif
           
            </div>
        </div>
    </div>
    <!--end breadcrumb-->




   
        <div class="container-fluid">
            
           

           

           <!--Latest Payments Starts -->
           <div class="row">

            <div class="col-xl-12">
                <div class="card">
                    <div class="card-body">
                       

                        <h4 class="card-title mb-4"> Currency  Payments </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($usds 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 -->

          

          




             



              






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




</div>




@endsection