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




@php


/*
     use Carbon\Carbon;

     $subscriptions = App\Models\Subscription::where('status', 'active')
     ->where('created_at', '>', Carbon::parse('2025-06-30')->endOfDay())
     ->where(function ($query) {
        $query->whereHas('payment', function ($q) {
            $q->where('coupon', 'LWFS');
        })
        ->orWhere(function ($q) {
            $q->whereHas('user', function ($u) {
                $u->where('zone', 'LWFS');
            })->whereHas('payment', function ($p) {
                $p->whereNull('coupon');
            });
        });
    })
    ->latest()
    ->get();

    */



use Carbon\Carbon;

$subscriptions = App\Models\Payment::with(['subscription', 'user'])
    ->where('purpose', 'subscription')
    ->where(function ($query) {
        $query->where(function ($q) {
            $q->where('coupon', 'LWFS')
            ->where('created_at', '>', Carbon::parse('2025-06-30')->endOfDay());
        })->orWhere(function ($q) {
            $q->whereNull('coupon')
            ->where('created_at', '>', Carbon::parse('2025-06-30')->endOfDay())
              ->whereHas('user', function ($u) {
                  $u->where('zone', 'LWFS');
              });
        });
    })
    ->latest()
    ->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"> Subscriptions </li>

                </ol>
            </nav>
        </div>
        <div class="ms-auto">
            <div class="btn-group">
                @if (Auth::user()->can('lwfs.commission')) 
                     <a href="{{ route('lwfs.commission') }}" class="btn btn-primary px-5"> Commissions </a>  
                @endif 
            </div>
        </div>
    </div>
    <!--end breadcrumb-->




    

        <div class="container-fluid">
            
           

           

           <!--Subscription Starts -->
           <div class="row">

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

                        <h4 class="card-title mb-4"> LWFS Subscriptions </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> Fullname </th>
                                        <th> Subscription_Amount </th>
                                        <th> Subscription_Name </th>
                                        <th> Subscription_Date </th>
                                        <th> Subscription_Duration </th>
                                       
                                       
                                           
                                    </tr>
                                </thead><!-- end thead -->


                                <tbody>

                                  
                                    @foreach($subscriptions as $key => $subscription)
                                    @if($subscription->user)

                                    <tr>

                                        <td> {{ $key+1 }} </td>
                                        <td> {{ $subscription->user->title }} {{ $subscription->user->firstname }} {{ $subscription->user->surname }} </td>
                                        <td> {{ $subscription->total_amount }} {{ $subscription->currency }} </td>
                                        <td> {{ $subscription->subscription->subscription_name }} </td>
                                        <td> {{ \Carbon\Carbon::parse($subscription->subscription->start_date)->format('Y F jS - h:ia') }}</td> 
                                        <td> {{ $subscription->subscription->subscription_duration }} </td>
                                      
                                         
                                        
                                    </tr>
                                     <!-- end -->

                                     @endif

                                     @endforeach

                                     


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

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

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

          

          




             



              






        </div>
        
   




</div>




@endsection