@php
    // The excel is built from this html by the phpspreadsheet html reader, which
    // only understands inline css, so every colour is written on the cell itself.
    $navy = '#1F3864';
    $blue = '#2E75B6';
    $orange = '#C55A11';
    $green = '#548235';

    $band = '#DCE6F1';
    $zebra = '#F2F6FC';

    $line = '#B4C6E7';

    $headBase = 'color: #FFFFFF; font-weight: bold; text-align: center; vertical-align: center; word-wrap: break-word; border: 1px solid #FFFFFF;';
    $cellBase = 'vertical-align: center; border: 1px solid ' . $line . ';';

    $totalCount = count($reportData);

    // Actual minus factual, so a positive balance is still owed and a negative one
    // was overpaid - the two cases are coloured apart to be readable at a glance.
    $diffStyle = function ($value) {
        if (round($value, 2) > 0) {
            return 'color: #C00000; background-color: #FDE9E9; font-weight: bold;';
        }

        if (round($value, 2) < 0) {
            return 'color: #1E6B34; background-color: #E8F6EC; font-weight: bold;';
        }

        return 'color: #808080;';
    };
@endphp
<table>
    <thead>
        <tr>
            <td colspan="14"
                style="background-color: {{ $navy }}; color: #FFFFFF; font-weight: bold; font-size: 15px; text-align: center; vertical-align: center;">
                {{ $organization->name ?? '' }} - Balance Report
            </td>
        </tr>
        <tr>
            <td colspan="14"
                style="background-color: {{ $band }}; color: {{ $navy }}; font-weight: bold; text-align: center; vertical-align: center;">
                Month: {{ $month_name }} &nbsp;&nbsp;|&nbsp;&nbsp; Records: {{ $totalCount }}
                &nbsp;&nbsp;|&nbsp;&nbsp; Generated On: {{ now()->format('d-M-Y h:i A') }}
            </td>
        </tr>
        <tr>
            <th style="background-color: {{ $navy }}; {{ $headBase }}">S.No</th>
            <th style="background-color: {{ $navy }}; {{ $headBase }}">{{ trans('common/common.month') }}</th>
            <th style="background-color: {{ $navy }}; {{ $headBase }}">{{ trans('master/master.employee_code') }}</th>
            <th style="background-color: {{ $navy }}; {{ $headBase }}">{{ trans('master/master.employee_name') }}</th>
            <th style="background-color: {{ $navy }}; {{ $headBase }}">{{ trans('master/master.department') }}</th>
            <th style="background-color: {{ $navy }}; {{ $headBase }}">{{ trans('master/master.designation') }}</th>
            <th style="background-color: {{ $blue }}; {{ $headBase }}">Actual OT Hours</th>
            <th style="background-color: {{ $blue }}; {{ $headBase }}">Fact OT Hours</th>
            <th style="background-color: {{ $blue }}; {{ $headBase }}">OT Hours Difference</th>
            <th style="background-color: {{ $orange }}; {{ $headBase }}">Actual OT Amount</th>
            <th style="background-color: {{ $orange }}; {{ $headBase }}">Fact OT Amount (Double OT)</th>
            <th style="background-color: {{ $orange }}; {{ $headBase }}">OT Amount Difference</th>
            <th style="background-color: {{ $green }}; {{ $headBase }}">Actual Salary</th>
            <th style="background-color: {{ $green }}; {{ $headBase }}">Factual Salary</th>
        </tr>
    </thead>
    <tbody>
        @php
            $totalActualOtHours = $totalFactOtHours = $totalOtHoursDifference = 0;
            $totalActualOtAmount = $totalFactOtAmount = 0;
            $totalActualSalary = $totalFactualSalary = $totalSalaryDifference = 0;
        @endphp
        @forelse ($reportData as $row)
            @php
                $totalActualOtHours += $row->actual_ot_hours;
                $totalFactOtHours += $row->fact_ot_hours;
                $totalOtHoursDifference += $row->ot_hours_difference;
                $totalActualOtAmount += $row->actual_ot_amount;
                $totalFactOtAmount += $row->fact_ot_amount;
                $totalActualSalary += $row->actual_salary;
                $totalFactualSalary += $row->factual_salary;
                $totalSalaryDifference += $row->salary_difference;

                $rowBg = $loop->iteration % 2 == 0 ? 'background-color: ' . $zebra . ';' : '';
            @endphp
            <tr>
                <td style="{{ $cellBase }} {{ $rowBg }} text-align: center;">{{ $loop->iteration }}</td>
                <td style="{{ $cellBase }} {{ $rowBg }} text-align: center;">{{ $row->month }}</td>
                <td style="{{ $cellBase }} {{ $rowBg }} font-weight: bold; text-align: left;">{{ $row->employee_code }}</td>
                <td style="{{ $cellBase }} {{ $rowBg }}">{{ $row->employee_name }}</td>
                <td style="{{ $cellBase }} {{ $rowBg }}">{{ $row->department }}</td>
                <td style="{{ $cellBase }} {{ $rowBg }}">{{ $row->designation }}</td>
                <td style="{{ $cellBase }} {{ $rowBg }} text-align: right;">{{ number_format($row->actual_ot_hours, 2, '.', '') }}</td>
                <td style="{{ $cellBase }} {{ $rowBg }} text-align: right;">{{ number_format($row->fact_ot_hours, 2, '.', '') }}</td>
                <td style="{{ $cellBase }} text-align: right; {{ $diffStyle($row->ot_hours_difference) }}">{{ number_format($row->ot_hours_difference, 2, '.', '') }}</td>
                <td style="{{ $cellBase }} {{ $rowBg }} text-align: right;">{{ round($row->actual_ot_amount) }}</td>
                <td style="{{ $cellBase }} {{ $rowBg }} text-align: right;">{{ round($row->fact_ot_amount) }}</td>
                <td style="{{ $cellBase }} text-align: right; {{ $diffStyle($row->salary_difference) }}">{{ round($row->salary_difference) }}</td>
                <td style="{{ $cellBase }} {{ $rowBg }} text-align: right;">{{ round($row->actual_salary) }}</td>
                <td style="{{ $cellBase }} {{ $rowBg }} text-align: right;">{{ round($row->factual_salary) }}</td>
            </tr>
        @empty
            <tr>
                <td colspan="14" style="{{ $cellBase }} color: #C00000; text-align: center;">No record found</td>
            </tr>
        @endforelse
    </tbody>
  
</table>