@extends('layouts.pdf-layout')

@section('letter_title')
    <hr>
    <div class="report-container">
        <div class="report-title">
            <h4>{{ strtoupper('UP COUNTRY LUGG & PARCEL REPORT') }}</h4>
        </div>
    </div>
@endsection

@section('content')
    @if (!empty($finalOutput))
        @php
            // Get all unique cities from the final output for header
            $allCities = [];
            foreach ($finalOutput as $dateData) {
                foreach ($dateData[1] as $cityData) {
                    $allCities[$cityData['city']] = true; // Unique cities
                }
            }
        @endphp

        <table class="table1" border="1" style="width: 100%; border-collapse: collapse;">
            <thead>
                <tr>
                    <th style="padding: 10px; text-align: left;">Day</th>
                    <th style="padding: 10px; text-align: left;">Date</th>
                    @foreach (array_keys($allCities) as $city)
                        <th style="padding: 10px; text-align: right;">{{ $city }}</th>
                    @endforeach
                </tr>
            </thead>
            <tbody>
                @foreach ($finalOutput as $dateData)
                    <tr>
                        <td style="padding: 10px;">
                            {{ (new DateTime($dateData[0]))->format('l') }} <!-- Display Actual Day Name -->
                        </td>
                        <td style="padding: 10px;">{{ $dateData[0] }}</td>
                        @foreach (array_keys($allCities) as $city)
                            @php
                                // Find city data for the current date
                                $cityData = collect($dateData[1])->firstWhere('city', $city);
                            @endphp
                            <td style="padding: 10px; text-align: right;">
                                @if ($cityData)
                                    {{ number_format($cityData['total_sales']) }} 
                                @else
                                    -
                                @endif
                            </td>
                        @endforeach
                    </tr>
                @endforeach
            </tbody>
        </table>
    @else
        <p>No data available for the selected date.</p>
    @endif
@endsection