@extends('layouts.pdf-layout')
@section('letter_title')
<div class="report-container">
    <div class="report-title" style="margin-top: -5px">
        <h4><strong>{{ strtoupper($letter_title) }}</strong></h4><br>
    </div>
</div>
<div class="report-info">
    <span class="report-date" style="font-size: 12px">REPORT DATE: <strong>{{ $selectedDateRange }}</strong> </span><br>
    <span class="print-time" style="font-size: 12px">PRINTED AT: <strong> {{ $print_time }}</strong></span>
</div> </h4>
@endsection

@section('content')
<style>
    table {
        width: 100%;
        border-collapse: collapse;
        font-size: 10px;
    }
    th, td {
        border: 1px solid #000;
        padding: 4px;
        text-align: center;
    }
    th {
        background-color: #f2f2f2;
    }
    .route-column {
        text-align: left;
        font-weight: bold;
    }
    .total-row {
        font-weight: bold;
        background-color: #e6ffe6;
    }
    .numeric {
        text-align: right;
    }
</style>

<table>
    <thead>
        <tr>
            <th>ROUTE</th>
            @foreach($allAgents as $agentId => $agentName)
                <th>{{ strtoupper($agentName) }}</th>
            @endforeach
            <th>TOTAL</th>
        </tr>
    </thead>
    <tbody>
        @php
            $columnTotals = array_fill_keys(array_keys($allAgents), 0);
            $grandTotal = 0;
        @endphp
        @foreach($routes as $route => $data)
            <tr>
                <td class="route-column">{{ $route }}</td>
                @foreach($allAgents as $agentId => $agentName)
                    <td class="numeric">
                        @if(isset($data['agents'][$agentId]))
                            {{ number_format($data['agents'][$agentId]['total_rate'], 2) }}
                            @php
                                $columnTotals[$agentId] += $data['agents'][$agentId]['total_rate'];
                            @endphp
                        @else
                            -
                        @endif
                    </td>
                @endforeach
                <td class="numeric">{{ number_format($data['total_rate'], 2) }}</td>
                @php
                    $grandTotal += $data['total_rate'];
                @endphp
            </tr>
        @endforeach
    </tbody>
    <tfoot>
        <tr class="total-row text-bold">
            <td>TOTAL</td>
            @foreach($allAgents as $agentId => $agentName)
                <td class="numeric">{{ number_format($columnTotals[$agentId], 2) }}</td>
            @endforeach
            <td class="numeric">{{ number_format($grandTotal, 2) }}</td>
        </tr>
    </tfoot>
</table>


@endsection