@extends('layouts.pdf-layout')

@section('letter_title')
    <hr>
    <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>BRANCH: <strong>{{ $originBranchName ?? 'UPCOUNTRY' }}</strong></span><br>
        <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>
@endsection

@php
    $branchCodes = [
        'MOROGORO' => 'MORO',
        'DAR ES SALAAM' => 'DAR',
    ];

    $originBranchName = key($routes);
@endphp

@section('content')
    <style>
        table {
            width: 100%;
            border-collapse: collapse;
            margin-bottom: 0px;
        }

        th, td {
            border: 1px solid #000;
            padding: 8px;
            font-size: 10px;
        }

        th {
            background-color: #f2f2f2;
            text-align: center;
        }

        .total-row td {
            background-color: #e6ffe6;
            font-weight: bold;
        }

        .branch-header {
            background-color: #dde6f3;
            font-weight: bold;
        }

        .numeric {
            text-align: right;
        }

        .table_sub {
            width: 320px;
            margin-bottom: 5px;
            margin-top: 5px;
        }
    </style>

    <table class="table_main">
        <thead>
            <tr>
                <th rowspan="3">ROUTE</th>
                <th colspan="{{ array_sum(array_map('count', $branchServicePoints)) }}">COLLECTION POINTS</th>
                <th rowspan="3">TOTAL BY ROUTE</th>
            </tr>
            <tr>
                @foreach($branchServicePoints as $branchName => $servicePoints)
                    <th colspan="{{ count($servicePoints) }}" class="branch-header">{{ strtoupper($branchName) }}</th>
                @endforeach
            </tr>
            <tr>
                @foreach($branchServicePoints as $servicePoints)
                    @foreach($servicePoints as $point)
                        <th>{{ strtoupper($point) }}</th>
                    @endforeach
                @endforeach
            </tr>
        </thead>
        <tbody>
            @php
                $grandTotal = 0;
                $servicePointTotals = [];
                foreach($branchServicePoints as $branchPoints) {
                    foreach($branchPoints as $point) {
                        $servicePointTotals[$point] = 0;
                    }
                }
            @endphp
            @foreach ($routes as $originBranch => $destinations)
                @foreach ($destinations as $destinationBranch => $data)
                    @php
                        $routeTotal = $data['total_rate'] ?? 0;
                        $hasServicePoints = !empty($data['servicePoints']) && 
                            array_sum(array_column($data['servicePoints'], 'total_rate')) > 0;

                        if ($routeTotal <= 0 && !$hasServicePoints) {
                            continue;
                        }
                        $grandTotal += $routeTotal;
                        $originBranchCode = $branchCodes[$originBranch] ?? $originBranch;
                        $destinationBranchCode = $branchCodes[$destinationBranch] ?? $destinationBranch;
                    @endphp
                    <tr>
                        <td style="white-space: nowrap; overflow: hidden; text-overflow: ellipsis;">
                            {{ $originBranchCode }} - {{ $destinationBranchCode }}
                        </td>
                        @foreach($branchServicePoints as $branchPoints)
                            @foreach($branchPoints as $point)
                                @php
                                    $servicePointTotal = $data['servicePoints'][$point]['total_rate'] ?? 0;
                                    $servicePointTotals[$point] += $servicePointTotal;
                                @endphp
                                <td style="text-align: right">
                                    @if ($servicePointTotal > 0)
                                        {{ floor($servicePointTotal) == $servicePointTotal ? number_format($servicePointTotal, 0) : number_format($servicePointTotal, 2) }}
                                    @else
                                        -
                                    @endif
                                </td>
                            @endforeach
                        @endforeach
                        <td style="text-align: right">
                            {{ floor($routeTotal) == $routeTotal ? number_format($routeTotal, 0) : number_format($routeTotal, 2) }}
                        </td>
                    </tr>
                @endforeach
            @endforeach
        </tbody>
        <tfoot>
            <tr class="total-row">
                <td>TOTAL AMOUNT</td>
                @foreach($branchServicePoints as $branchPoints)
                    @foreach($branchPoints as $point)
                        <td style="text-align: right">
                            @php
                                $total = $servicePointTotals[$point];
                            @endphp
                            @if ($total > 0)
                                {{ floor($total) == $total ? number_format($total, 0) : number_format($total, 2) }}
                            @else
                                -
                            @endif
                        </td>
                    @endforeach
                @endforeach
                <td style="text-align: right">
                    {{ floor($grandTotal) == $grandTotal ? number_format($grandTotal, 0) : number_format($grandTotal, 2) }}
                </td>
            </tr>
        </tfoot>
    </table>
@endsection