@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 ?? 'N/A' }}</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> </h4>

@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;
        }

        .grand-total {
            background-color: #f7c6c7;
            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="2">ROUTE</th>
                <th colspan="{{ count($servicePoints) }}">COLLECTION POINTS</th>
                <th rowspan="2">TOTAL BY ROUTE</th>
            </tr>
            <tr style="white-space: nowrap; overflow: hidden; text-overflow: ellipsis;">
                @foreach ($servicePoints as $point)
                    <th>{{ strtoupper($point) }}</th>
                @endforeach
            </tr>
        </thead>
        <tbody>
            @php
                $grandTotal = 0;
                $servicePointTotals = array_fill_keys($servicePoints, 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 ($servicePoints as $servicePoint)
                            @php
                                $servicePointTotal = $data['servicePoints'][$servicePoint]['total_rate'] ?? 0;
                                $servicePointTotals[$servicePoint] += $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
                        <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 ($servicePoints as $servicePoint)
                    <td style="text-align: right">
                        @php
                            $total = $servicePointTotals[$servicePoint];
                        @endphp
                        @if ($total > 0)
                            {{ floor($total) == $total ? number_format($total, 0) : number_format($total, 2) }}
                        @else
                            -
                        @endif
                    </td>
                @endforeach
                <td style="text-align: right">
                    {{ floor($grandTotal) == $grandTotal ? number_format($grandTotal, 0) : number_format($grandTotal, 2) }}
                </td>
            </tr>
        </tfoot>
    </table>   
    
@endsection