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

@section('content')
    <style>
        .report-container {
            justify-content: space-between;
            margin-bottom: 7px;
        }

        .report-info {
            text-align: left;
            font-weight: bold;
        }

        .report-info .report-date {
            font-size: 1px;
            color: #2c3e50;
        }

        .report-info .print-time {
            font-size: 1px;
            color: #7f8c8d;
        }

        .report-title h4 {
            font-weight: bold;
            /* text-align: right; */
            margin: 0;
            font-size: 16px;
        }


        .report-info {

            font-weight: bold;
            /* margin-top: 10px; */
            /* margin-bottom: 20px; */
            font-size: 12px;
        }

        .report-info .report-date {
            display: block;
            font-size: 14px;
            color: #000000;
        }

        .report-info .print-time {
            display: block;
            font-size: 12px;
            color: #000000;
            margin-top: 10px;
        }

        table {
            width: 100%;
            border-collapse: collapse;
            margin-bottom: 20px;
        }

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

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

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

        .numeric {
            text-align: right;
        }

        .section-header {
            background-color: #d9d9d9;
            font-weight: bold;
        }

        .grand-total-row td {
            text-align: right;
            font-weight: bold;
            background-color: #ffcccc;
        }
    </style>

    <table class="table_main">
        <thead>

            <tr>
                <th>S.N</th>
                <th>AGENT NAME</th>
                <th>BRANCH</th>
                <th>OFFICE</th>
                <th>CONTACTS NO</th>
                <th>NO OF PARCELS</th>
                <th>TOTAL SALES(TZS)</th>
            </tr>
        </thead>
        <tbody>
            @php
                $grandTotalParcels = 0;
                $grandTotalSales = 0;
                function renderSection($data, $title, &$grandTotalParcels, &$grandTotalSales)
                {
                    if (!empty($data['with_parcels'])) {
                        echo "<tr class='section-header'><td colspan='9'>" .
                            strtoupper($title) .
                            ' - SALES</td></tr>';
                        $sectionTotalParcels = 0;
                        $sectionTotalSales = 0;
                        foreach ($data['with_parcels'] as $index => $agent) {
                            echo "<tr>
                <td style='width: 5%'>" .
                                htmlspecialchars($index + 1) .
                                "</td>
                <td>" .
                                htmlspecialchars(strtoupper($agent->agent_name)) .
                                "</td>
                <td>" .
                                htmlspecialchars($agent->branch_name) .
                                "</td>
                <td>" .
                                htmlspecialchars($agent->office_name) .
                                "</td>
                                <td>" .
                                htmlspecialchars($agent->agent_contacts) .
                                "</td>
                <td class='numeric'>" .
                                number_format($agent->total_parcels_count, 0) .
                                "</td>
                <td class='numeric'>" .
                                number_format($agent->total_agent_sales, 0) .
                                "</td>
                               
            </tr>";

                            $sectionTotalParcels += $agent->total_parcels_count;
                            $sectionTotalSales += $agent->total_agent_sales;
                        }

                        echo "<tr class='total-row'>
            <td colspan='5'>" .
                            strtoupper($title) .
                            " TOTAL</td>
            <td class='numeric'>" .
                            number_format($sectionTotalParcels, 0) .
                            "</td>
            <td class='numeric'>" .
                            number_format($sectionTotalSales, 0) .
                            "</td>
                           
                             
                            
        </tr>";

                        $grandTotalParcels += $sectionTotalParcels;
                        $grandTotalSales += $sectionTotalSales;
                    } else {
                    }

                    if (!empty($data['without_parcels'])) {
                        echo "<tr class='section-header'><td colspan='9'>" .
                            strtoupper($title) .
                            '- NO SALES</td></tr>';

                        foreach ($data['without_parcels'] as $index => $agent) {
                            echo "<tr>
                <td style='width: 5%'>" .
                                htmlspecialchars($index + 1) .
                                "</td>
                <td>" .
                                htmlspecialchars(strtoupper($agent->agent_name)) .
                                "</td>
                <td>" .
                                htmlspecialchars($agent->branch_name) .
                                "</td>
                <td>" .
                                htmlspecialchars($agent->office_name ?? 'N/A') .
                                "</td>
                                  <td>" .
                                htmlspecialchars($agent->agent_contacts) .
                                "</td>
                <td class='numeric'>0</td>
                <td class='numeric'>0</td>
               
            </tr>";
                        }
                    } else {
                        echo "<tr class='section-header'><td colspan='6'>" .
                            strtoupper($title) .
                            ' - NO SALES</td></tr>';
                        echo "<tr>
            <td colspan='6'>No data available</td>
        </tr>";
                    }
                }

                renderSection($darData, 'Dar es Saalam', $grandTotalParcels, $grandTotalSales);
                renderSection($moroData, 'Morogoro', $grandTotalParcels, $grandTotalSales);
                renderSection($upcountryData, 'Upcountry Branches', $grandTotalParcels, $grandTotalSales);
            @endphp
            @if ($grandTotalParcels > 0 || $grandTotalSales > 0)
                <tr class="grand-total-row">
                    <td colspan="5">GROUND TOTAL</td>
                    <td class="numeric">{{ number_format($grandTotalParcels, 0) }}</td>
                    <td class="numeric">{{ number_format($grandTotalSales, 0) }}</td>
                   
                </tr>
            @endif
        </tbody>
    </table>
@endsection