@extends('admin.layout.master')
@section('content')
    <div class="page-body">
        <div class="container-fluid">
           <div class="page-title">
                <div class="row">
                     <div class="col-12">
                      @if(session('message'))
                      <ol class="breadcrumb">
                        <li class="breadcrumb-item text-success">{{session('message')}}</li>
                      </ol>
                      @endif
                    </div>
                </div>
            </div>
      </div>
          <!-- Container-fluid starts-->
        <div class="container-fluid">
            <div class="row">
                <div class="col-md-12">
                    <div class="card">
                      <div class="card-header pb-0 card-no-border">
                        <span><h4>User Details</h4></span><span style="float:right"><button onclick="exportToExcel()">Download Excel</button></span>
                      </div>
                      <div class="card-body">
                        <div class="table-responsive">
                          <table class="display" id="basic-9">
                            <thead>
                              <tr>
                                <th>Id</th>
                                <th>Name</th>
                                <th>Mobile</th>
                                <th>Driving License</th>
                                <th>Aadhaar no</th>
                                <th>Token</th>
                                @if(session('AdminDetail')->role == 0 || checkStatus('subAdminEdit') == 'on')
                                <th>Action</th>
                                <th>Status</th>
                               @endif
                              </tr>
                            </thead>
                            <tbody>
                              @foreach($user as $key=>$value)
                              <tr>
                                <td>{{$key+1}}</td>
                                <td>{{$value->name}}</td>
                                <td>{{$value->mobile}}</td>
                                <td>{{$value->dl}}</td>
                                <td>{{$value->aadhar_no}}</td>
                                <td>{{$value->id}}</td>
                                @if(session('AdminDetail')->role == 0 || checkStatus('subAdminEdit') == 'on')
                                <td> 
                                  <ul class="action"> 
                                    <li class="edit"> <a href="{{route('user-edit',['id'=>$value->id])}}"><i class="icon-pencil-alt"></i>Edit</a></li>
                                 </ul>
                                </td>
                                <td>
                                    <input type="hidden" name="id" value="{{$value->id}}">
                                    <select name="change" id="change{{$value->id}}" onchange="checkAndSubmit('{{$value->id}}')">
                                      <option value="3" @if($value->status == 3) selected @endif>Done</option>
                                      <option value="1" @if($value->status == 1) selected @endif>Pending</option>
                                    </select>
                                  
                                </td>
                              
                                @endif
                              </tr>
                              @endforeach
                            </tbody>
                            <tfoot>
                              <tr>
                                <th>Id</th>
                                <th>Name</th>
                                <th>Mobile</th>
                                <th>Driving License</th>
                                <th>Aadhaar no</th>
                                <th>Token</th>
                                @if(session('AdminDetail')->role == 0 || checkStatus('subAdminEdit') == 'on')
                                <th>Action</th>
                                <th>Status</th>
                             
                                @endif
                              </tr>
                            </tfoot>
                          </table>
                        </div>
                      </div>
                    </div>
                </div>
         
            
            </div>
            <form name="changeUser" id="changeUser" action="{{route('update-status')}}" method="post">
              @csrf
              <input type="hidden" name="userId" id="userId">
              <input type="hidden" name="status" id="status">
            </form>
        </div>
    </div>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.16.9/xlsx.full.min.js"></script>
    <script>
      function checkAndSubmit(id){
        // alert (id);
        var result = confirm('Are you sure you want to proceed?');

        // Check the result of the confirmation dialog
        if (result) {
            $('#userId').val(id);
            var status = $('#change'+id).val();
            $('#status').val(status);
            $('#changeUser').submit();
            
            // Code to execute if user clicked OK
        } else {
            window.location.reload();
            // Code to execute if user clicked Cancel or closed the dialog
        }
      }
      function exportToExcel() {
        // Select the table element
        var table = document.getElementById('basic-9');

          // Exclude the last row (footer) from the table
        var rows = table.rows;
        var num_rows = rows.length - 1; // Exclude the last row
        var data = [];
        for (var i = 0; i < num_rows; i++) {
          data.push([]);
          for (var j = 0; j < rows[i].cells.length; j++) {
            data[i].push(rows[i].cells[j].innerText);
          }
        }

        // Create a workbook
        var ws = XLSX.utils.aoa_to_sheet(data);
        var wb = XLSX.utils.book_new();
        XLSX.utils.book_append_sheet(wb, ws, 'Sheet1');

        // Save the workbook as an Excel file
        XLSX.writeFile(wb, 'user_details.xlsx');
      }
    </script>
@endsection