@include ('layouts.header')

<div class="container-fluid">
    
<div class="row">
        <a href="{{ url('left') }}" target="_self" class="btn btn-primary">Past</a>
        <b>Location</b>
            <select id="empCodeFilter" class="custom-select">
                <option value=''>ALL</option>
                <option value="AMSC">CHENNAI</option>
                <option value="AMSV">VELLORE</option>
            </select>
        <a href="{{ url('search')}}" target="_self" class="cancel">Back</a> 
         
            <label>Department</label>
                <select id="dept" class="custom-select">
                    <option value="">ALL</option>
                    @foreach($departments as $department)
                        <option value="{{ $department->dept_name }}">{{ $department->dept_name }}</option>
                    @endforeach
                </select>
        </div>
           
        <a href="{{ url('extract_form') }}" target="_self">Extraction for Exit Form</a>

        <table class="table table-bordered" id="exit_employee">
            <thead>
                <tr>
                    <th>#</th>
                    <th>Emp code</th>
                    <th>Emp Name</th>
                    <th>Department</th>
                    <th>Designation</th>
                    <th>Date Of Joining</th>
                    <th>Allzone Exp</th>
                    <th>Action</th>
                </tr>
            </thead>
            <tbody>
                @foreach($employees as $key => $employee)
                @php
                    $dj = $employee->DateOfJoining;
                    $currentDate = \Carbon\Carbon::now();
                    $diff = $currentDate->diff(\Carbon\Carbon::parse($dj));
                    $years = $diff->y;
                    $months = $diff->m;
                    $days = $diff->d;
                    $DOJ = \Carbon\Carbon::parse($dj)->format('d-M-Y');
                @endphp
                <tr>
                    <td>{{ $key + 1 }}</td>
                    <td>{{ $employee->EmployeeCode }}</td>
                    <td>{{ $employee->EmployeeName }}</td>
                    <td>{{ $employee->dept_name }}</td>
                    <td>{{ $employee->designation }}</td>
                    <td>{{ $DOJ }}</td>
                  
                    <td>{{ $years }} yrs, {{ $months }} mths, {{ $days }} ds</td>
                    <td>
                    <a href="{{ url('exit_form', ['exid' => $employee->EmployeeCode]) }}">Exit</a>
                         @if($years >= 1 && $years < 3)
                        <a href="{{ url('checklist1', ['exid' => $employee->EmployeeCode]) }}" class="btn btn-primary">CL 1</a>
                         @elseif($years >= 3)
                            <a href="{{ url('checklist3', ['exid' => $employee->EmployeeCode]) }}" class="btn btn-primary">CL 3</a>
                         @else
                            <a href="#" class="btn btn-light"></a>
                        @endif
                 </td>
             </tr>
                @endforeach
            </tbody>
        </table>
 </div>

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<link href="https://cdn.datatables.net/v/dt/dt-2.2.1/datatables.min.css" rel="stylesheet"> 
<script src="https://cdn.datatables.net/v/dt/dt-2.2.1/datatables.min.js"></script>

<script>
    $(document).ready(function() {
        var dataTable = $('#exit_employee').DataTable({
         /* "columnDefs": [{
                "targets": 0,
                "visible": false
            }],*/
            "order": [[6, 'desc']] // Ensure date column is sorted correctly
        });
        
        $('#empCodeFilter').on('change', function() {
            var empCode = $(this).val();
            if (empCode) {
                dataTable.column(1).search(empCode).draw();
            } else {
                dataTable.column(1).search('').draw();
            }
        });

        $('#dept').on('change', function() {
            var dept = $(this).val();
            dataTable.column(3).search(dept).draw();
        });     
    });

</script>

  @include('layouts.footer')