@php
    use Illuminate\Support\Carbon;
@endphp
<div class="table-responsive">
    <table id="dataTableExample" class="table">
        <thead>
            <tr>
                <th>Sl #</th>
                <th>Employee ID</th>
                <th>Name</th>
                <th>Country PF</th>
                <th>Employee FNPF Rate</th>
                <th>Employer FNPF Rate</th>
                <th>Base Salary</th>
                <th>Total Earning</th>
                {{-- <th>Employee Additional Contribution Rate</th>
                <th>Employer Additional Contribution Rate</th> --}}
                <th>FNPF Deduction</th>
                <th>Start Date</th>
                <th>End Date</th>

                {{-- <th>Check-in time</th>
                <th>Check-out time</th>
                <th>Status</th>
            </tr> --}}
        </thead>
        {{-- <tbody>
            @foreach ($employees as $employee)
                <tr>
                    <td>{{ $loop->iteration }}</td>
                    <td>
                        {{ optional($employee)->employee_id ?? '-' }}
                    </td>
                    <td>
                        {{ optional($employee)->first_name ?? 'No data' }}
                        {{ optional($employee)->last_name ?? 'No data' }}
                    </td>
                    <td>
                        {{ optional($employee->country)->fnpf ?? 'No data' }}
                    </td>
                    <td>
                        {{ optional($employee->providentfund)->employer_rate ?? 'No data' }}
                    </td>
                    <td>{{ optional($employee->providentfund)->user_rate ?? 'No data' }}</td>
                    <td>{{ optional($employee->payroll()->latest()->first())->base_salary ?? 'No data' }}</td>
                    <td>{{ optional($employee->payroll()->latest()->first())->total_earnings ?? 'No data' }}</td>
                   
                    <td>{{ optional($employee->payroll()->latest()->first())->fnpf_deduction ?? 'No data' }}</td>
                    <td>{{ optional($employee->payroll()->latest()->first())->start_date ?? 'No data' }}</td>
                    <td>{{ optional($employee->payroll()->latest()->first())->end_date ?? 'No data' }}</td>
                  
                </tr>
            @endforeach
        </tbody> --}}
        <tbody>
            @foreach ($payrolls as $payroll)
                <tr>
                    <td>{{ $loop->iteration }}</td>
                    <td>{{ $payroll->user->employee_id ?? '-' }}</td>
                    <td>
                        {{ $payroll->user->first_name ?? 'No data' }}
                        {{ $payroll->user->last_name ?? 'No data' }}
                    </td>
                    <td>{{ $payroll->user->country->fnpf ?? 'No data' }}</td>
                    <td>{{ $payroll->user->providentfund->employer_rate ?? 'No data' }}</td>
                    <td>{{ $payroll->user->providentfund->user_rate ?? 'No data' }}</td>
                    <td>{{ $payroll->base_salary ?? 'No data' }}</td>
                    <td>{{ $payroll->total_earnings ?? 'No data' }}</td>
                    <td>{{ $payroll->fnpf_deduction ?? 'No data' }}</td>
                    <td>{{ $payroll->start_date ?? 'No data' }}</td>
                    <td>{{ $payroll->end_date ?? 'No data' }}</td>
                </tr>
            @endforeach
        </tbody>
        
    </table>
</div>