@extends('admin.admin_dashboard')
@section('admin')
    
    @php
    /*

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

        //users
        $users = App\Models\User::where('role', 'user')
            ->where('status', 1)
            ->whereNull('referred_by')
            ->whereNotNull('ce_zone')
            ->where('ce_zone', $my_zone)
            ->orderBy('ce_zone', 'asc')
            ->orderBy('id', 'asc')
            ->get();


    */
    @endphp





   @php


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

       //users
       $users = App\Models\User::where('role', 'user')
                                ->where('status', 1)
                                ->whereNull('referred_by')
                                ->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 </li>

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





        <div class="container-fluid">





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

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


                            <h4 class="card-title mb-4"> {{ $my_zone }} - Registered Users : <span class="badge bg-info">
                                    {{ count($users) }} </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> Email </th>
                                            <th> Sign-Up Date </th>
                                            <th> Subscription Status </th>


                                        </tr>
                                    </thead><!-- end thead -->


                                    <tbody>





                                        @foreach ($users as $key => $user)
                                            @php
                                                $UserSubscription = $user
                                                    ->subscriptions()
                                                    ->where('status', 'active')
                                                    ->where('end_date', '>', now())
                                                    ->latest()
                                                    ->first();
                                            @endphp

                                            <tr>
                                                <td> {{ $key + 1 }} </td>
                                                <td> {{ $user->ce_zone }} </td>
                                                <td> {{ $user->title }} {{ $user->firstname }} {{ $user->surname }} </td>

                                                <td> {{ $user->email }} </td>

                                            
                                                <td> {{ $user->created_at->format('Y F jS - h:ia') }}</td>


                                                <td>
                                                    @if ($UserSubscription)
                                                        <span class="badge bg-success"> Subscribed </span>
                                                    @else
                                                        <span class="badge bg-danger"> Unsubscribed </span>
                                                    @endif
                                                </td>








                                            </tr>
                                            <!-- end -->
                                        @endforeach



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

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

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



















        </div>


        <!-- End Page-content -->




    </div>
@endsection