@include('layouts.header')

<div class="container-fluid">
    <div class="row">
         @if(session('role') == 2)
         <a href="{{ url('arate') }}" target="_self" class="btn btn-default">Attrition Rate</a>
         @endif
        <div class="section-title">Present Employees</div>
         <p class="txt"> Last Update :31 May,2025</p>
        <div class="shape" id="dropdown-wrapper">
            <label for="locationFilter">Filter By </label>
              <select id="locationFilter" class="custom-select filter-dropdown">
                <option value="">Branch </option>
                <option value="AMSC">CHENNAI</option>
                <option value="AMSV">VELLORE</option>
            </select>
            
            <select id="dept" class="custom-select">
                <option value="">Process</option>
                        @foreach($departments as $dept)
                        <option value="{{ $dept->dept_name }}">{{ $dept->dept_name }}</option>
                        @endforeach
            </select>
        </div>
   
    <table class="table table-striped" id="example_table">
            <thead>
             <tr>
                <th>SI No</th>
                <th>Employee ID</th>
                <th>Name</th>
                <th>Gender</th>
                <th>Department</th>
                <th>Designation</th>
                <th>DOJ</th>
                <th>Allzone Exp</th>
                <th>Reporting</th>
            </tr>
        </thead>
         <tbody>
             @foreach ($employees as $sn => $employee)
              <tr>
                <td>{{ $sn + 1 }}</td>
                <td>{{ $employee->EmployeeCode }}</td>
                <td>{{ $employee->EmployeeName }}</td>
                <td>{{ $employee->Gender }}</td>
                <td>{{ $employee->dept_name }}</td>
                <td>{{ $employee->Designation }}</td>
                <td>{{ \Carbon\Carbon::parse($employee->DateOfJoining)->format('d-M-Y') }}
                     @php $dateOfJoining = \Carbon\Carbon::parse($employee->DateOfJoining);
                                    $exp = $dateOfJoining->diff(\Carbon\Carbon::now()); 
                                    $yy = $exp->y; $mm = $exp->m;$dd= $exp->d;
                            @endphp
                 <td>{{ $yy }}yrs{{$mm}}m{{$dd}}d</td>
                 <td>{{ $employee->ManagerName }}</td>
            </tr>
        @endforeach
    </tbody>
   </table>
</div>  
</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 = $("#example_table").DataTable();

    $('#dropdown-wrapper').on('change', '.filter-dropdown', function() {
        var selectedLocation = $(this).val(); // Get selected value from the dropdown
     
        // Apply filter using regex for the Empcode (column 1)
        if (selectedLocation) {
            // Match EmployeeCode starting with selectedLocation (e.g., AMSC in AMSC123)
            dataTable.column(1).search('^' + selectedLocation, true, false).draw(); 
        } else {
            dataTable.column(1).search('').draw();
        }
    });
    
    // Department dropdown filter
            $('#dept').on('change', function() {
                    var dept = $(this).val();
                    dataTable.column(4).search(dept).draw();
                });
            });
</script>
@include('layouts.footer')