@extends('layouts.app')

    @section('styles')

    @endsection

        @section('content')

                        <!-- PAGE-HEADER -->
                        <div class="page-header">
                            <h1 class="page-title">Dashboard </h1>
                            <div>
                                <ol class="breadcrumb">
                                    <li class="breadcrumb-item"><a href="javascript:void(0)">Home</a></li>
                                    <li class="breadcrumb-item active" aria-current="page">Dashboard </li>
                                </ol>
                            </div>
                        </div>
                        <!-- PAGE-HEADER END -->

                        <!-- ROW-1 -->
                        <div class="row">
                            <div class="col-lg-12 col-md-12 col-sm-12 col-xl-12">
                                <div class="row">

                                <div style="cursor:pointer;"  class="col-sm-12 col-md-6 col-lg-6 col-xl-3">
                                <div class="card bg-primary img-card box-primary-shadow">
                                    <div class="card-body">
                                    <a href="{{ route('banner') }}">
                                        <div class="d-flex">
                                            <div class="text-white">

                                            @php
       $banners_count = DB::select(DB::raw("SELECT * from banners"));
    
   @endphp
                                                <h2 class="mb-0 number-font counter"> {{count($banners_count)}}</h2>
                                                <p class="text-white mb-0 ">Total Banner</p>
                                            </div>
                                            <div class="ms-auto"> <i class="fa fa-flag text-white fs-30 me-2 mt-2"></i> </div>
                                        </div>
</a>
                                    </div>
                                </div>
                            </div>


                          


                            @php
       $offers_count = DB::select(DB::raw("SELECT * from offers"));
    
   @endphp

                             
   <div style="cursor:pointer;"  class="col-sm-12 col-md-6 col-lg-6 col-xl-3">
                                <div class="card bg-primary img-card box-primary-shadow">
                                    <div class="card-body">
                                        <a href="{{ route('offers') }}">
                                        <div class="d-flex">
                                            <div class="text-white">
                                                <h2 class="mb-0 number-font counter">{{count($offers_count)}}</h2>
                                                <p class="text-white mb-0">Total Offers</p>
                                            </div>
                                            <div class="ms-auto"> <i class="fa fa-gift  text-white fs-30 me-2 mt-2"></i> </div>
                                        </div>
                                        </a>
                                    </div>
                                </div>
                            </div>
         
                            
                            

                                </div>
                            </div>
                        </div>
                        <!-- ROW-1 END -->









                        <div class="row row-sm">
                    

                        <div class="col-lg-12">
                                <div class="card">
                                    <div class="card-header">
                                        <h3 class="card-title">Contact Form Details</h3>
                                    </div>
                        <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-bordered text-nowrap border-bottom" id="basic-datatable">
                            <thead>
                                <tr>
                                    <th class="wd-2p border-bottom-0">SL</th>
                                    <th class="wd-2p border-bottom-0">Name</th>
                                    <th class="wd-2p border-bottom-0">Email</th>
                                 
                                    <th class="wd-40p border-bottom-0">subject</th>

                                    <th class="wd-40p border-bottom-0">Comment</th>
                                    <th class="wd-40p border-bottom-0">Date</th>
                                    <th class="wd-18p border-bottom-0">Action</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($show['contact'] as $item)
                                <tr>
                                <td class="text-nowrap align-middle">{{$loop->iteration}}</td>
                                    <td class="text-nowrap align-middle">{{$item->first_name}} {{$item->last_name}}</td>
                                    <td class="text-nowrap align-middle">{{ $item->email }}</td>
                                    <td class="text-nowrap align-middle">{{ $item->subject }}</td>
                                    <td class="text-nowrap align-middle">{{ $item->comment }}</td>
                                    <td class="text-nowrap align-middle">{{ date_format($item->created_at,"d-m-Y")  }}</td>
                                    <td class="text-nowrap align-middle">
                                        <div class="btn-list">
                                            <a  id="{{$item->id}}" class="btn  deleteIcon  btn-sm btn-danger item-delete" href="#" >
                                                <span class="fe fe-trash-2"> </span>
                                            </a>
                                          
                                        </div>
                                    </td>
                                </tr>
                                @empty
                                <tr>
                                    <td  style="text-align: center;" colspan="6">No  data found</td>
                                </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
                        </div>

</div>
</div>
                        

                       
                        <!-- ROW-2 -->
                      
                        <!-- ROW-2 END -->

                        <!-- ROW-3 -->

                        <!-- ROW-3 END -->

                        <!-- ROW-4 -->
                    
                        <!-- ROW-4 END -->

        @endsection

    @section('scripts')

      <!-- DATA TABLE JS-->
      <script src="{{asset('assets/plugins/datatable/js/jquery.dataTables.min.js')}}"></script>
    <script src="{{asset('assets/plugins/datatable/js/dataTables.bootstrap5.js')}}"></script>
    <script src="{{asset('assets/plugins/datatable/js/dataTables.buttons.min.js')}}"></script>
    <script src="{{asset('assets/plugins/datatable/js/buttons.bootstrap5.min.js')}}"></script>
    <script src="{{asset('assets/plugins/datatable/js/jszip.min.js')}}"></script>
    <script src="{{asset('assets/plugins/datatable/pdfmake/pdfmake.min.js')}}"></script>
    <script src="{{asset('assets/plugins/datatable/pdfmake/vfs_fonts.js')}}"></script>
    <script src="{{asset('assets/plugins/datatable/js/buttons.html5.min.js')}}"></script>
    <script src="{{asset('assets/plugins/datatable/js/buttons.print.min.js')}}"></script>
    <script src="{{asset('assets/plugins/datatable/js/buttons.colVis.min.js')}}"></script>
    <script src="{{asset('assets/plugins/datatable/dataTables.responsive.min.js')}}"></script>
    <script src="{{asset('assets/plugins/datatable/responsive.bootstrap5.min.js')}}"></script>
    <script src="{{asset('assets/js/table-data.js')}}"></script>

    <script src="//cdn.jsdelivr.net/npm/sweetalert2@11"></script>

<script>

$(document).on('click', '.deleteIcon', function(e) {
        e.preventDefault();
        let id = $(this).attr('id');
        let csrf = '{{ csrf_token() }}';
        Swal.fire({
          title: 'Are you sure?',
          text: "You won't be able to revert this!",
          icon: 'warning',
          showCancelButton: true,
          confirmButtonColor: '#3085d6',
          cancelButtonColor: '#d33',
          confirmButtonText: 'Yes, delete it!'
        }).then((result) => {
          if (result.isConfirmed) {
            $.ajax({
              url: '{{ route('contact_delete') }}',
              method: 'delete',
              data: {
                id: id,
                _token: csrf
              },
              success: function(response) {
                console.log(response);
                Swal.fire(
                  'Deleted!',
                  'Your file has been deleted.',
                  'success'
                ).then(function(){
                location.reload();
                });
                fetchAllgallery();
              }
            });
          }
        })
      });
</script>
    @endsection