@extends('layouts.master')
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.25/css/jquery.dataTables.min.css">
<style>
    .card-body {
    flex: 1 1 auto;
    min-height: 1px;
    padding: 0.75rem!important;
}
ul {
    list-style: none;
    padding: 0;
}

li {
    margin-bottom: 10px;
}
</style>
@section('content')
<div class="container-fluid">
    <div class="row justify-content-center">
        <div class="col-xl-12 col-md-12 mb-4">
            <div class="card">
                <div class="card-header text-white bg-primary align-items-center d-flex" style="justify-content: space-between;"><strong>Total Visitors List</strong><button class="btn btn-sm btn-success" id="btnExport">Export to Excel</button></div>
                <div class="card-body">
                    <form action="{{ route('reports') }}" method="GET">
                        <div class="form-row">
                          <div class="form-group col-md-4">
                            <label for="Name"><strong>Date</strong></label>
                            <input type="date" style="border: solid 1px" class="form-control" placeholder="date" name="date" id="date" value="{{ request('date') }}">
                          </div>
                          <!--<div class="form-group col-md-6">-->
                          <!--  <label for="mobnumber"><strong>Pass ID</strong></label>-->
                          <!--  <input type="number" style="border: solid 1px" class="form-control" name="passid" id="passid" placeholder="Enter Pass id" value="{{ request('passid') }}">-->
                          <!--</div>-->
                          <div class="form-group col-md-4">
                            <label for="status"><strong>Status</strong></label>
                              <select class="form-control" name="status" id="status" style="border: solid 1px">
                                  <option value="">Select Status</option>
                                  <option value="In" @if(request('status') == "In") selected @endif>Entry</option>
                                  <option value="Out" @if(request('status') == "Out") selected @endif>Exit</option>
                              </select>
                          </div>
                          <div class="form-group col-md-4">
                            <button type="submit" class="btn btn-primary" style="margin-top: 8%;"><i class="fa fa-filter" aria-hidden="true"></i> Search</button>
                          </div>
                          <!--<div class="form-group col-md-6">-->
                          <!--  <label for="oraganization"> <strong>Oraganization</strong> </label>-->
                          <!--  <input type="text" style="border: solid 1px" class="form-control" name="oraganization" id="oraganization" placeholder="Enter oraganization" value="{{ request('oraganization') }}">-->
                          <!--</div>-->
                        </div>
                        
                    </form>
                </div>
            </div>
        </div>
    </div>
    <table id="departmentTable" class="table table-bordered">
        <thead>
            <tr>
                <th scope="col">Id</th>
                <th scope="col">Name</th>
                <th scope="col">Pass ID</th>
                <th scope="col">Mobile Number</th>
                <th scope="col">Date</th>
                <th scope="col">In Time</th>
                <th scope="col">Out Time</th>
                <th scope="col">Oragnization</th>
            </tr>
        </thead>
        @if(count($visitors) > 0)
            @php
                $id = 1; // Initialize ID counter
            @endphp
            @foreach($visitors as $visitor)
                <tbody>
                    <tr>
                        <th>{{$id}}</th>
                        <th>{{$visitor->name}}</th>
                        <th>{{$visitor->pass_id}}</th>
                        <th>{{$visitor->mobile}}</th>
                        <th>{{ substr($visitor->entry_datetime, 0, 10) }}</th>
                        <th>{{$visitor->entry_datetime}}</th>
                        <th>{{$visitor->exit_datetime}}</th>
                        <th>{{$visitor->organization}}</th>
                    </tr>
                </tbody>
            @php
            $id++; // Initialize ID counter
            @endphp
            @endforeach
        @else
            <p>No Record Found</p>
        @endif
    </table>
    {!! $visitors->links() !!}
    
    <strong>Total Count : {!! $visitors->total() !!}</strong> 
</div>
@endsection

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="https://cdn.datatables.net/1.10.25/js/jquery.dataTables.min.js" defer></script>

<script>
    // $(document).ready(function() {
    //     $('#departmentTable').DataTable({
    //         "searching": false,
    //         "paging": true,
    //         "lengthMenu": [10, 25, 50, 75, 100],
    //     });
    // });
    
    $(document).ready(function () {
        $("#btnExport").click(function () {
            let table = document.getElementsByTagName("table");
            TableToExcel.convert(table[0], {
                name: `datewise.xlsx`,
                sheet: {
                    name: 'datewise'
                }
            });
        });
    });
</script>
</script>