@php
    $groupData = collect($finalHeaders)->groupBy('type');
@endphp

<thead>
    <tr>
        <th>S.No.</th>

        {{-- Static Headers --}}
        @foreach ($groupData->get('headers', []) as $sequence)
            @php
                $val = explode('...', $sequence['value']);
                $label = $sequence['alias'] ?? ($val[1] ?? $val[0]);
            @endphp
            <th>{{ $label }}</th>
        @endforeach

        {{-- Dynamic Monthly Data --}}
        @foreach ($monthData as $m)
            {{-- Attendance & Leave Types --}}
            @foreach ($groupData->get('att_summary', collect())->merge($groupData->get('leave_types', collect())) as $sequence)
                @php
                    $val = explode('...', $sequence['value']);
                    $label = $sequence['alias'] ?? ($val[1] ?? $val[0]);
                @endphp
                <th>{{ $label }}</th>
            @endforeach

            {{-- Rate (if enabled) --}}
            @if ($templateData->rate == '1')
                @foreach ($groupData->get('components', []) as $sequence)
                    @php
                        $val = explode('...', $sequence['value']);
                        $label = $sequence['alias'] ?? ($val[1] ?? $val[0]);
                    @endphp
                    @if (($sequence['calculationType'] ?? null) == 'PaidDays')
                        <th class="bg-datehead5">{{ $label }} (Rate)</th>
                    @endif
                @endforeach
            @endif

            {{-- Salary + Arrear --}}
            @foreach ($groupData->get('components', []) as $sequence)
                @php
                    $val = explode('...', $sequence['value']);
                    $label = $sequence['alias'] ?? ($val[1] ?? $val[0]);
                @endphp
                <th class="bg-datehead">{{ $label }} (Salary)</th>
                @if ($templateData->arrear == '1')
                    <th class="bg-datehead">{{ $label }} (Arrear)</th>
                @endif
            @endforeach

            {{-- Summary Fields --}}
            @foreach ($groupData->get('summary', []) as $sequence)
                @php
                    $val = explode('...', $sequence['value']);
                    $label = $sequence['alias'] ?? ($val[1] ?? $val[0]);
                @endphp
                <th class="bg-datehead">{{ $label }}</th>
            @endforeach
        @endforeach
    </tr>
</thead>

<tbody>
    <tr>

        {{-- Static Header Fields --}}
        <td></td>
        @foreach ($groupData->get('headers', []) as $sequence)
            <td></td>
        @endforeach

        {{-- Monthly Dynamic Data --}}
        @foreach ($monthData as $m)
            {{-- Attendance + Leave Types --}}
            @foreach ($groupData->get('att_summary', []) as $sequence)
                <td class="bg-datehead">{{ App\Helpers\GeneralHelper::formatDate($m) }}</td>
            @endforeach

            @foreach ($groupData->get('leave_types', []) as $sequence)
                <td class="bg-datehead">{{ App\Helpers\GeneralHelper::formatDate($m) }}</td>
            @endforeach

            {{-- Salary + Arrear --}}
            @foreach ($groupData->get('components', []) as $sequence)
                <td class="bg-datehead">{{ App\Helpers\GeneralHelper::formatDate($m) }}</td>
                <td class="bg-datehead">{{ App\Helpers\GeneralHelper::formatDate($m) }}</td>
                @if ($templateData->arrear == '1')
                    <td class="bg-datehead">{{ App\Helpers\GeneralHelper::formatDate($m) }}</td>
                @endif
            @endforeach

            {{-- Summary Fields --}}
            @foreach ($groupData->get('summary', []) as $sequence)
                <td class="bg-datehead">{{ App\Helpers\GeneralHelper::formatDate($m) }}</td>
            @endforeach
        @endforeach
    </tr>
    @php
        $componentTotal = [];
    @endphp

    @foreach ($employeeData as $emp)
        @php $data = $emp['record']; @endphp
        <tr>
            <td>{{ $loop->iteration }}</td>

            {{-- Static Header Fields --}}
            @foreach ($groupData->get('headers', []) as $sequence)
                @php $val = explode('...', $sequence['value'])[0]; @endphp
                <td>
                    @if (in_array($val, ['department', 'designation', 'workstation', 'category', 'contractor', 'state', 'shift']))
                        {{ @$data->employee->{$val}->name }}
                    @elseif ($val == 'locations')
                        {{ @$data->employee->{$val}->pluck('name')->implode(',') }}
                    @else
                        {{ ucwords(@$data->employee->{$val}) }}
                    @endif
                </td>
            @endforeach

            {{-- Monthly Dynamic Data --}}
            @foreach ($monthData as $m)
                {{-- Attendance + Leave Types --}}
                @foreach ($groupData->get('att_summary', []) as $sequence)
                    @php
                        $key = explode('...', $sequence['value'])[0];
                        $val = @$emp['items'][$m]['attendance_info'][$key] ?? 0;
                    @endphp
                    <td>{{ $val }}</td>
                @endforeach

                @foreach ($groupData->get('leave_types', []) as $sequence)
                    @php
                        $key = explode('...', $sequence['value'])[0];
                        $val = @$emp['items'][$m]['leave_info'][$key] ?? 0;
                    @endphp
                    <td>{{ $val }}</td>
                @endforeach

                {{-- Rate --}}
                @if ($templateData->rate == '1')
                    @foreach ($groupData->get('components', []) as $sequence)
                        @php
                            $compId = explode('...', $sequence['value'])[0];
                            $rate = 0;
                            $logs = @$emp['items'][$m]['salary_info']->slipLogs ?? [];

                            foreach ($logs as $log) {
                                if ($log->type_id == $compId) {
                                    $rate = round($log->actual_salary, 2);
                                    break;
                                }
                            }
                        @endphp
                        @if (($sequence['calculationType'] ?? null) == 'PaidDays')
                            <td class="bg-datehead">{{ $rate }}</td>
                        @endif
                    @endforeach
                @endif

                {{-- Salary + Arrear --}}
                @foreach ($groupData->get('components', []) as $sequence)
                    @php
                        $compId = explode('...', $sequence['value'])[0];
                        $salary = $arrear = 0;
                        $logs = @$emp['items'][$m]['salary_info']->slipLogs ?? [];

                        foreach ($logs as $log) {
                            if ($log->type_id == $compId) {
                                $salary = round($log->calculate_salary, 2);
                                $arrear = round($log->arrear_salary, 2);
                                $componentTotal[$m][$compId] = ($componentTotal[$m][$compId] ?? 0) + $salary;
                                break;
                            }
                        }
                    @endphp
                    <td class="bg-datehead">{{ $salary }}</td>
                    @if ($templateData->arrear == '1')
                        <td class="bg-datehead">{{ $arrear }}</td>
                    @endif
                @endforeach

                {{-- Summary Fields --}}
                @foreach ($groupData->get('summary', []) as $sequence)
                    @php
                        $key = explode('...', $sequence['value'])[0];
                        $val = @$emp['summary'][$key] ?? 0;
                    @endphp
                    <td class="bg-datehead">{{ $val }}</td>
                @endforeach
            @endforeach
        </tr>
    @endforeach
</tbody>

<tfoot>
    <tr>
        <th>Total:</th>

        {{-- Empty placeholders for static headers --}}
        @foreach ($groupData->get('headers', []) as $sequence)
            <th></th>
        @endforeach

        {{-- Monthly Dynamic Totals --}}
        @foreach ($monthData as $m)
            {{-- Attendance + Leave --}}
            @foreach ($groupData->get('att_summary', []) as $sequence)
                <th></th>
            @endforeach
            @foreach ($groupData->get('leave_types', []) as $sequence)
                <th></th>
            @endforeach

            {{-- Rate (not totaled) --}}
            @if ($templateData->rate == '1')
                @foreach ($groupData->get('components', []) as $sequence)
                    @if (($sequence['calculationType'] ?? null) == 'PaidDays')
                        <th class="bg-datehead"></th>
                    @endif
                @endforeach
            @endif

            {{-- Salary + Arrear Totals --}}
            @foreach ($groupData->get('components', []) as $sequence)
                @php
                    $compId = explode('...', $sequence['value'])[0];
                    $totalSalary = $componentTotal[$m][$compId] ?? 0;
                    $totalArrear = 0;
                    if ($templateData->arrear == '1') {
                        foreach ($employeeData as $emp) {
                            $logs = @$emp['items'][$m]['salary_info']->slipLogs ?? [];
                            foreach ($logs as $log) {
                                if ($log->type_id == $compId) {
                                    $totalArrear += round($log->arrear_salary, 2);
                                    break;
                                }
                            }
                        }
                    }
                @endphp
                <th class="bg-datehead">{{ $totalSalary }}</th>
                @if ($templateData->arrear == '1')
                    <th class="bg-datehead">{{ $totalArrear }}</th>
                @endif
            @endforeach

            {{-- Summary Totals --}}
            @foreach ($groupData->get('summary', []) as $sequence)
                @php
                    $key = explode('...', $sequence['value'])[0];
                    $summaryTotal = 0;
                    foreach ($employeeData as $emp) {
                        $summaryTotal += @$emp['summary'][$key] ?? 0;
                    }
                @endphp
                <th class="bg-datehead">{{ $summaryTotal }}</th>
            @endforeach
        @endforeach
    </tr>
</tfoot>