@extends('admin.layout')
@section('title', 'RatingReport')
@section('header')
    <!-- DataTable CSS -->
    <link rel="stylesheet" type="text/css" href="{{ asset('/assets') }}/css/datatable/dataTables.bootstrap5.min.css">
    <link rel="stylesheet" type="text/css" href="{{ asset('/assets') }}/css/datatable/responsive.bootstrap.min.css">
    <link rel="stylesheet" type="text/css" href="{{ asset('/assets') }}/css/datatable/buttons.dataTables.min.css">
@endsection
@section('content')
    <div class="container-fluid page-wrapper">
      
         <div class="row mb-3">
    <div class="col-6">
        <h3 class="page-top-heading">Rating Report</h3>
    </div>
    <div class="col-6 text-end">
        <button id="exportExcelBtn" class="btn btn-success">
            <i class="fa fa-file-excel"></i> Export Excel
        </button>
    </div>
</div>
        <div class="row mt-4">
      
      </div>
      
        <!-- Table Row -->
        <div class="row mt-4">
            <div class="col-lg-12">
                <div class="card datatable-card">
                    <div class="card-body">
                        <table id="data-table" class="table nowrap align-middle" style="width:100%">
                            <thead>
                                <tr>
                                    <th>SN</th>
                                     <th>Created at</th>
                                    <th>Phone Number</th>
                                    <th>USER ID</th>
                                     <th>Name</th>
                                    <th>BUSINESS NAME</th>
                                    <th>RATING</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach ($users as $user)
                                    <tr>
                                        <td>{{ $loop->iteration }}</td>
                                        <td>{{ $user->created_at}}</td>
                                        <td>{{ $user->phone_number }}</td>
                                        <td>{{ $user->user_id }}</td>
                                        <td>{{ $user->name ?? '-' }}</td>
                                        <td>{{ $user->business_name ?? '-' }}</td>
                                        <td>{{ $user->rating ?? '-' }} stars</td>
                                      
      </tr>
  
  @endforeach
</tbody>
                          
                        </table>
                    </div>
                </div>
            </div>
        </div>

    
    </div>

    <!-- end container fluid -->
    <script>
      function setDeleteId(button) {
        var deleteId = button.getAttribute('data-user-id');
        document.getElementById('delete_id').value = deleteId;
      }
    </script>
@endsection
@section('footer')
    <!-- JQuery CDN -->
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"
        integrity="sha256-/xUj+3OJU5yExlq6GSYGSHk7tPXikynS7ogEvDej/m4=" crossorigin="anonymous"></script>
   <script src="https://cdn.sheetjs.com/xlsx-latest/package/dist/xlsx.full.min.js"></script>
 <script>
document.getElementById('exportExcelBtn').addEventListener('click', function() {
    // Select the table
    var table = document.getElementById('data-table');
    // Convert HTML table to worksheet
    var wb = XLSX.utils.table_to_book(table, { sheet: "RatingReport" });
    // Download Excel file
    XLSX.writeFile(wb, "rating_report.xlsx");
});
</script>
<script>
    function setBlockId(el) {
      document.getElementById('block_user_id').value = el.getAttribute('data-user-id');
    }
  
    function setUnblockId(el) {
      document.getElementById('unblock_user_id').value = el.getAttribute('data-user-id');
    }
  </script>
  
    <!-- Datatable JS -->
    <script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/dataTables.bootstrap5.min.js"></script>
    <script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/datatables.init.js"></script>
    <script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/dataTables.responsive.min.js"></script>
    <script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/jquery.dataTables.min.js"></script>
    <script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/dataTables.buttons.min.js"></script>
    <script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/buttons.html5.min.js"></script>
    <script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/buttons.print.min.js"></script>
    <script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/jszip.min.js"></script>
    <script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/pdfmake.min.js"></script>
    <script type="text/javascript" src="{{ asset('/assets') }}/js/datatable/vfs_fonts.js"></script>
@endsection