{{-- resources/views/exports/monthly_sales_report.blade.php --}}
@php
    $monthsArray = [
        "January", "February", "March", "April", "May", "June",
        "July", "August", "September", "October", "November", "December"
    ];

    $reportSubTitle = '';
    if ($filters['month'] != 12 && isset($monthsArray[$filters['month']])) {
        $reportSubTitle = 'FOR ' . strtoupper($monthsArray[$filters['month']]) . ', ' . $filters['year'];
    } else {
        $reportSubTitle = 'FOR THE YEAR ' . $filters['year'];
    }

    $grandTotalSales = 0;
@endphp

<table style="width: 100%; border-collapse: collapse;">
    <thead>
        <tr>
            <th colspan="{{ $filters['month'] != 12 ? 4 : 2 }}" style="background-color: #0069d9; color: #fff; border: 1px solid #ccc; padding: 12px; text-align:center; font-size: 20px; font-weight: bold;">
                MONTHLY SALES ANALYSIS REPORT
            </th>
        </tr>
        <tr>
             <th colspan="{{ $filters['month'] != 12 ? 4 : 2 }}" style="background-color: #0069d9; color: #fff; border: 1px solid #ccc; padding: 8px; text-align:center; font-size: 16px;">
                {{ $reportSubTitle }}
            </th>
        </tr>

        @if ($filters['month'] != 12) {{-- Specific Month View --}}
            <tr>
                <th style="background-color: #e8ad18; color: #fff; border: 1px solid #ccc; padding: 8px; text-align: left; font-size: 14px; font-weight: bold;">S/N</th>
                <th style="background-color: #e8ad18; color: #fff; border: 1px solid #ccc; padding: 8px; text-align: left; font-size: 14px; font-weight: bold;">MONTH OF SALE</th>
                <th style="background-color: #e8ad18; color: #fff; border: 1px solid #ccc; padding: 8px; text-align: left; font-size: 14px; font-weight: bold;">DATE OF SALE</th>
                <th style="background-color: #e8ad18; color: #fff; border: 1px solid #ccc; padding: 8px; text-align: right; font-size: 14px; font-weight: bold;">TOTAL DAILY SALE</th>
            </tr>
        @else {{-- All Months View --}}
            <tr>
                <th style="background-color: #e8ad18; color: #fff; border: 1px solid #ccc; padding: 8px; text-align: left; font-size: 14px; font-weight: bold;">MONTH</th>
                <th style="background-color: #e8ad18; color: #fff; border: 1px solid #ccc; padding: 8px; text-align: right; font-size: 14px; font-weight: bold;">TOTAL MONTHLY SALE</th>
            </tr>
        @endif
    </thead>
    <tbody>
        @if ($filters['month'] != 12) {{-- Specific Month View --}}
            @php
                $currentMonthName = isset($monthsArray[$filters['month']]) ? $monthsArray[$filters['month']] : 'N/A';
            @endphp
            @forelse($salesData as $index => $item)
                @php
                    // For sales, 'amount' is the direct sale amount
                    $dailySale = $item->amount ?? 0;
                    $grandTotalSales += $dailySale;
                @endphp
                <tr>
                    <td style="border: 1px solid #ccc; padding: 7px; font-size: 13px;">{{ $loop->iteration }}</td>
                    <td style="border: 1px solid #ccc; padding: 7px; font-size: 13px;">{{ $currentMonthName }}</td>
                    <td style="border: 1px solid #ccc; padding: 7px; font-size: 13px;">{{ \Carbon\Carbon::parse($item->date)->format('Y-m-d') }}</td>
                    <td style="border: 1px solid #ccc; padding: 7px; text-align: right; font-size: 13px;">{{ number_format($dailySale, 0) }}</td>
                </tr>
            @empty
                <tr>
                    <td colspan="4" style="border: 1px solid #ccc; padding: 7px; text-align: center; font-size: 13px;">No sales data available for this month.</td>
                </tr>
            @endforelse
            @if(count($salesData) > 0)
            <tr style="background-color: #f2f2f2;">
                <td colspan="3" style="border: 1px solid #ccc; padding: 8px; text-align: right; font-size: 14px; font-weight: bold;">Total Sales for {{ $currentMonthName }}:</td>
                <td style="border: 1px solid #ccc; padding: 8px; text-align: right; font-size: 14px; font-weight: bold;">{{ number_format($grandTotalSales, 0) }}</td>
            </tr>
            @endif
        @else
            @php
                $monthlySalesStructured = [];
                $monthKeysForLoop = [
                    'jansales' => 'January', 'febsales' => 'February', 'marsales' => 'March',
                    'aprsales' => 'April', 'maysales' => 'May', 'junsales' => 'June',
                    'julsales' => 'July', 'augsales' => 'August', 'sepsales' => 'September',
                    'octsales' => 'October', 'novsales' => 'November', 'decsales' => 'December',
                ];
                foreach($monthKeysForLoop as $key => $name) {
                    if (isset($salesData[$key]) && (float)$salesData[$key] != 0) {
                        $monthlySalesStructured[] = ['name' => $name, 'sale' => (float)$salesData[$key]];
                    }
                }
                $grandTotalSales = isset($salesData['totalsales']) ? (float)$salesData['totalsales'] : 0;
            @endphp

            @if(empty($monthlySalesStructured))
                 <tr>
                    <td colspan="2" style="border: 1px solid #ccc; padding: 7px; text-align: center; font-size: 13px;">No sales data available for the year {{ $filters['year'] }}.</td>
                </tr>
            @else
                @foreach($monthlySalesStructured as $data)
                    <tr>
                        <td style="border: 1px solid #ccc; padding: 7px; font-size: 13px;">{{ $data['name'] }}</td>
                        <td style="border: 1px solid #ccc; padding: 7px; text-align: right; font-size: 13px;">{{ number_format($data['sale'], 0) }}</td>
                    </tr>
                @endforeach
            @endif

            <tr style="background-color: #f2f2f2;">
                <td style="border: 1px solid #ccc; padding: 8px; text-align: right; font-size: 14px; font-weight: bold;">Grand Total Yearly Sales:</td>
                <td style="border: 1px solid #ccc; padding: 8px; text-align: right; font-size: 14px; font-weight: bold;">{{ number_format($grandTotalSales, 0) }}</td>
            </tr>
        @endif
    </tbody>
</table>