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

    @php
    /*
    //Old logic

        use Carbon\Carbon;

        // my zone
        $my_zone = auth()->user()->ce_zone;

        // subscription
        $subscriptions = App\Models\Payment::with(['subscription', 'user'])
            ->where('purpose', 'subscription')
            ->where(function ($query) use ($my_zone) {
                $query->where(function ($q) use ($my_zone) {
                    $q->whereNull('coupon')
                        ->where('created_at', '>', Carbon::parse('2025-06-30')->endOfDay())
                        ->whereHas('user', function ($u) use ($my_zone) {
                            $u->whereNull('referred_by')->whereNotNull('ce_zone')->where('ce_zone', $my_zone);
                        });
                });
            })
            ->latest()
            ->get();
        */

    @endphp




    @php
        use Carbon\Carbon;

        // my zone
        $my_zone = auth()->user()->ce_zone;

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

                    </ol>
                </nav>
            </div>
            <div class="ms-auto">
                <div class="btn-group">
                    @if (Auth::user()->can('zone.commission'))
                        <a href="{{ route('zone.commission') }}" class="btn btn-primary px-5"> Zone - 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"> {{ $my_zone }} - Users Subscriptions <span class="badge bg-info">
                                    {{ count($subscriptions) }} </span> </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> Zone </th>
                                            <th> Registered User 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->ce_zone }} </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