@php
    if (!function_exists('complianceRegisterExcelFormatTime')) {
        function complianceRegisterExcelFormatTime($time)
        {
            return $time && $time != '00:00:00' ? date('H:i', strtotime($time)) : '-';
        }
    }
    if (!function_exists('complianceRegisterExcelFormatHours')) {
        function complianceRegisterExcelFormatHours($time)
        {
            return $time && $time != '00:00:00' ? substr($time, 0, 5) : '-';
        }
    }

    $dayColumnCount = count($dateArr);
    $summaryColumns = ['WO', 'HD', 'EL', 'CL', 'SL', 'OL'];
    $totalColumns = 1 + $dayColumnCount + count($summaryColumns);

    $orgAddressParts = [];
    if ($organization->address) {
        foreach (['line_1', 'line_2', 'line_3', 'postal_code'] as $addressField) {
            if (!empty($organization->address->{$addressField})) {
                $orgAddressParts[] = $organization->address->{$addressField};
            }
        }
    }

    // Palette
    $bandDark = 'background-color:#2F5597;color:#FFFFFF;';
    $bandLight = 'background-color:#D9E2F3;color:#1F3864;';
    $headerFill = 'background-color:#BDD7EE;';
    $labelFill = 'background-color:#DDEBF7;';
    $empBandFill = 'background-color:#F2F2F2;';
    $summaryFill = 'background-color:#E2EFDA;';
    $weekOffFill = 'background-color:#FFF2CC;';
    $holidayFill = 'background-color:#FCE4D6;';
    $border = 'border:1px solid #B7B7B7;';
@endphp

<table>
    <tr>
        <td colspan="{{ $totalColumns }}"
            style="{{ $bandDark }}{{ $border }}font-weight:bold;font-size:16px;text-align:center;">
            {{ $organization->name }}
        </td>
    </tr>
    @if (!empty($orgAddressParts))
        <tr>
            <td colspan="{{ $totalColumns }}"
                style="{{ $bandLight }}{{ $border }}font-size:10px;text-align:center;">
                {{ implode(', ', $orgAddressParts) }}
            </td>
        </tr>
    @endif
    <tr>
        <td colspan="{{ $totalColumns }}"
            style="{{ $bandDark }}{{ $border }}font-weight:bold;font-size:12px;text-align:center;">
            Attendance Register for the month of {{ $monthYearLabel }}
        </td>
    </tr>
    <tr>
        <td colspan="{{ $totalColumns }}" style="border:none;font-size:4px;">&nbsp;</td>
    </tr>

    {{-- Column header --}}
    <tr>
        <td rowspan="2" style="{{ $headerFill }}{{ $border }}font-weight:bold;text-align:center;vertical-align:middle;">
            &nbsp;
        </td>
        @foreach ($dateArr as $date)
            <td style="{{ $headerFill }}{{ $border }}font-weight:bold;text-align:center;">
                {{ date('d', strtotime($date)) }}
            </td>
        @endforeach
        @foreach ($summaryColumns as $summaryLabel)
            <td rowspan="2"
                style="{{ $headerFill }}{{ $border }}font-weight:bold;text-align:center;vertical-align:middle;">
                {{ $summaryLabel }}
            </td>
        @endforeach
    </tr>
    <tr>
        @foreach ($dateArr as $date)
            <td style="{{ $headerFill }}{{ $border }}font-size:7px;text-align:center;">
                {{ date('D', strtotime($date)) }}
            </td>
        @endforeach
    </tr>

    @foreach ($employeeSummary as $employee)
        @php
            $atSummary = $employee->registerAttSummary;
            $woHo = $employee->woHoCounts;
            $leaveCounts = $employee->registerLeaveCounts;

            $summaryValues = [
                @$woHo['total_week_off'] ?: 0,
                @$woHo['total_holiday'] ?: 0,
                @$leaveCounts['EL'] ?: 0,
                @$leaveCounts['CL'] ?: 0,
                @$leaveCounts['SL'] ?: 0,
                @$leaveCounts['OL'] ?: 0,
            ];
        @endphp

        {{-- Employee identity band --}}
        <tr>
            <td colspan="{{ $totalColumns }}" style="{{ $empBandFill }}{{ $border }}font-weight:bold;font-size:9px;">
                PayCode: {{ $employee->employee_code }} &nbsp;&nbsp;|&nbsp;&nbsp;
                Cardno: {{ $employee->card_no ?: $employee->employee_code }} &nbsp;&nbsp;|&nbsp;&nbsp;
                Name: {{ $employee->name }} &nbsp;&nbsp;|&nbsp;&nbsp;
                Shift: {{ @$employee->shift->name }} &nbsp;&nbsp;|&nbsp;&nbsp;
                Desig: {{ @$employee->designation->name }} &nbsp;&nbsp;|&nbsp;&nbsp;
                Paid Days: {{ @$employee->vwAttendanceSummary->total_pay_days }} &nbsp;&nbsp;|&nbsp;&nbsp;
                Present Days: {{ @$employee->vwAttendanceSummary->total_present }}
            </td>
        </tr>

        {{-- 1. In Time --}}
        <tr>
            <td style="{{ $labelFill }}{{ $border }}font-weight:bold;font-size:7px;text-align:center;">In Time</td>
            @foreach ($dateArr as $date)
                @php
                    $a = $atSummary[$date] ?? null;
                    $isWeekOff = $a && $a->on_duty == 2;
                    $isHoliday = $a && $a->on_duty == 3 && $a->is_week_off == 0;
                    $hideTime = $isWeekOff || $isHoliday;
                    $cellFill = $isWeekOff ? $weekOffFill : ($isHoliday ? $holidayFill : '');
                @endphp
                <td style="{{ $cellFill }}{{ $border }}text-align:center;">
                    {{ $a && !$hideTime ? complianceRegisterExcelFormatTime($a->in_time) : '-' }}
                </td>
            @endforeach
            @foreach ($summaryColumns as $index => $summaryLabel)
                <td rowspan="4" style="{{ $summaryFill }}{{ $border }}font-weight:bold;text-align:center;vertical-align:middle;">
                    {{ $summaryValues[$index] }}
                </td>
            @endforeach
        </tr>

        {{-- 2. Out Time --}}
        <tr>
            <td style="{{ $labelFill }}{{ $border }}font-weight:bold;font-size:7px;text-align:center;">Out Time</td>
            @foreach ($dateArr as $date)
                @php
                    $a = $atSummary[$date] ?? null;
                    $isWeekOff = $a && $a->on_duty == 2;
                    $isHoliday = $a && $a->on_duty == 3 && $a->is_week_off == 0;
                    $hideTime = $isWeekOff || $isHoliday;
                    $cellFill = $isWeekOff ? $weekOffFill : ($isHoliday ? $holidayFill : '');
                    $outTime = $a ? ($a->fact_out_time ?: $a->out_time) : null;
                @endphp
                <td style="{{ $cellFill }}{{ $border }}text-align:center;">
                    {{ $a && !$hideTime ? complianceRegisterExcelFormatTime($outTime) : '-' }}
                </td>
            @endforeach
        </tr>

        {{-- 3. Total Working Hours --}}
        <tr>
            <td style="{{ $labelFill }}{{ $border }}font-weight:bold;font-size:7px;text-align:center;">Work Hrs</td>
            @foreach ($dateArr as $date)
                @php
                    $a = $atSummary[$date] ?? null;
                    $isWeekOff = $a && $a->on_duty == 2;
                    $isHoliday = $a && $a->on_duty == 3 && $a->is_week_off == 0;
                    $hideTime = $isWeekOff || $isHoliday;
                    $cellFill = $isWeekOff ? $weekOffFill : ($isHoliday ? $holidayFill : '');
                @endphp
                <td style="{{ $cellFill }}{{ $border }}text-align:center;">
                    {{ $a && !$hideTime ? complianceRegisterExcelFormatHours($a->fact_working_hour) : '-' }}
                </td>
            @endforeach
        </tr>

        {{-- 4. Attendance Status --}}
        <tr>
            <td style="{{ $labelFill }}{{ $border }}font-weight:bold;font-size:7px;text-align:center;">Status</td>
            @foreach ($dateArr as $date)
                @php
                    $a = $atSummary[$date] ?? null;
                    $statusLabel = '-';
                    $isWeekOff = false;
                    $isHoliday = false;
                    if ($a) {
                        if ($a->on_duty == 2) {
                            $statusLabel = 'WO';
                            $isWeekOff = true;
                        } elseif ($a->on_duty == 3 && $a->is_week_off == 0) {
                            $statusLabel = 'H';
                            $isHoliday = true;
                        } else {
                            $statusLabel = $a->status ?: '-';
                        }
                    }
                    $cellFill = $isWeekOff ? $weekOffFill : ($isHoliday ? $holidayFill : '');
                @endphp
                <td style="{{ $cellFill }}{{ $border }}font-weight:bold;text-align:center;">
                    {{ $statusLabel }}
                </td>
            @endforeach
        </tr>

        {{-- Spacer / divider between employees --}}
        <tr>
            <td colspan="{{ $totalColumns }}" style="{{ $bandDark }}font-size:3px;border:none;">&nbsp;</td>
        </tr>
    @endforeach
</table>