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



@php

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

                </ol>
            </nav>
        </div>
        <div class="ms-auto">
            <div class="btn-group">
                @if (Auth::user()->can('users.all'))
                  <a href="{{ route('all.user') }} " class="btn btn-primary px-5">All Users </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"> All 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> fullnames </th>
                                            <th> email </th>
                                            <th> phone_number </th>
                                            <th> country </th>
                                            <th> ce_zone </th>
                                            <th> ministry/church </th>
                                            <th> category </th>
                                            <th> timestamp </th>
                                            <th> email_verification_status </th>
                                            <th> user_subscription_status </th>
                                            <th> actions </th>
                                            
                                        </tr>
                                    </thead><!-- end thead -->


                                    <tbody>


                                        

                                      
                                        @foreach($users as $key => $user)


                                        @php
                                        $UserSubscription = $user->subscriptions()
                                            ->where('status', 'active')
                                            ->where('end_date', '>', now())
                                            ->where('id', '!=', 6)
                                            ->latest()
                                            ->first();
                                        @endphp

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


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

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

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


                                           
                                            <td> {{ $user->created_at->format('Y F jS - h:ia') }}</td>
                                            <td>
                                                @if($user->email_verified_at != null)
                                                    <span class="badge rounded-pill bg-primary">verified</span>
                                                @else
                                                    <span class="badge rounded-pill bg-secondary">unverified</span>
                                                @endif
                                            </td>
                                            

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


                                            <td>
                                                @if (Auth::user()->can('users.edit'))
                                                    <a href="{{ route('edit.user',$user->id) }}" class="btn btn-info px-5">Edit </a>  
                                                 @endif 

                                                 @if (Auth::user()->can('users.delete'))
                                                   <a href="{{ route('delete.user',$user->id) }}" class="btn btn-danger px-5" id="delete" > Delete </a>  
                                                 @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