@include('layouts.header')

<div class="container">
        <div class="card">
            <div class="col-8" id="checkbox-wrapper">
                <label>Filter By Location</label>
                    <input type="checkbox" class="filter-checkbox"  value="AMSC"/> Chennai
                    <input type="checkbox" class="filter-checkbox"  value="AMSV"/>  Vellore
                    <a href="{{ url('dashboard')}}" target="_self" class="btn btn-info" style="float:right">Back</a>
            </div>
        </div>
            <h1>October - 2025</h1>
                <table class="table table-striped" id="newjoinee">
                    <thead>
                        <tr>
                            <th>S.No</th>
                            <th>Employee code</th>
                            <th>Employee Name</th>
                            <th>Departtment</th>
                            <th>Designation</th>
                            <th>Date of Joining</th>
                        </tr>
                    </thead>
                        <tbody>
                        @foreach($ret as $row)
                        <tr><td>{{ $loop->iteration }} </td>
                            <td>{{$row->EmployeeCode}}</td>
                            <td>{{ $row->EmployeeName}}</td>
                            <td>{{ $row->dept}}</td>
                            <td>{{ $row->designation}}</td>
                            <td>   {{ \Carbon\Carbon::parse($row->DateOfJoining)->format('d-M-Y') }}
                        </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 = $("#newjoinee").DataTable();
        $('#checkbox-wrapper').on('change', '.filter-checkbox', function() {
            var selectedLocations = [];
            
            // Collect values of the checked checkboxes (locations)
            $('.filter-checkbox:checked').each(function() {
                selectedLocations.push($(this).val());
            });

            // If locations are selected, apply filter using a regex for the Empcode (column 1)
            if (selectedLocations.length > 0) {
                var filterString = selectedLocations.join('|'); // Join selected locations
                // Apply regex filter on the location column (in this case, assuming it's column 1 - Empcode)
                dataTable.column(1).search('(' + filterString + ')', true, false).draw(); 
            } else {
                // If no locations are selected, show all rows
                dataTable.column(1).search('').draw();
            }
        });

    });
</script>
@include('layouts.footer')