{{-- 
<div id="section2">

<div class="table-responsive-xl">
    <table class="table table-bordered" style="border: 1px solid;">
        
        <thead>
            <tr  >
                <th colspan="12" class="text-center" ><h2 >Comparative Analysis Report</h2></th>
            </tr>
            <tr>
                @foreach ($groupedComparativeReport as $insurerName => $locations)
        <thead >
            
            <tr>
                
                <th colspan="12"  scope="col" style="font-weight: bold">  {{ $insurerName }}</th>
            </tr>
            <tr>
                @foreach ($locations as $location)

                        <th colspan="12"  scope="col" class="text-center">{{ strtoupper($location->insurer_name) }}</th>
                    </tr>

        </thead>
       
        <thead>
            <tr>
                <th colspan="3" scope="colgroup" class="text-center">Previous Year {{now()->startOfYear()->subYear()->format('Y')}}</th>
                <th colspan="3" scope="colgroup" class="text-center">Current Year {{now()->format('Y')}}</th>
                <th colspan="3" scope="colgroup" class="text-center">Variance</th>
            </tr>
            <tr>
                <th scope="col">Count</th>
                <th scope="col">Total Sum Insured</th>
                <th scope="col">Total Premium</th>
                <th scope="col">Count</th>
                <th scope="col">Total Sum Insured</th>
                <th scope="col">Total Premium</th>
                <th scope="col">Count</th>
                <th scope="col">Total Sum Insured</th>
                <th scope="col">Total Premium</th>
            </tr>
        </thead>
      
        <tbody>
            
         
             <tr>
               
                <td>{{ number_format($location->last_year_certificate_type_count) }}</td>
            <td>{{ number_format($location->last_year_total_sum_insured_sum,2) }}</td>
            <td>{{ number_format($location->last_year_total_premium_sum,2) }}</td>
            <td>{{ number_format($location->current_year_certificate_type_count) }}</td>
            <td>{{ number_format($location->current_year_total_sum_insured_sum,2) }}</td>
            <td>{{ number_format($location->current_year_total_premium_sum,2) }}</td>
            <td>{{ number_format($location->variance_certificate_type_count) }}</td>
            <td>{{ number_format($location->variance_total_sum_insured,2) }}</td>
            <td>{{ number_format($location->variance_total_premium_sum,2) }}</td>
            </tr> 
            
            @endforeach
        </tbody>
        @endforeach
    </table>
   
</div>
</div>

<br>
<br>
<br> --}}


<div id="section3">
    {{-- Grand Total --}}
    <div class="table-responsive-xl">
        <table class="table table-bordered" style="border: 0.5px solid;">

            <thead>
                <tr>
                    <th colspan="10" class="text-center">
                        <h2>Grand Total Per Location</h2>
                    </th>
                </tr>
                <tr>
                    <th colspan="1" scope="colgroup" class="text-center"></th>
                    <th colspan="3" scope="colgroup" class="text-center">Previous Year
                        {{ now()->startOfYear()->subYear()->format('Y') }}</th>
                    <th colspan="3" scope="colgroup" class="text-center">Current Year {{ now()->format('Y') }}</th>
                    <th colspan="3" scope="colgroup" class="text-center">Variance</th>
                </tr>
                <tr>
                    <th scope="col">Location</th>
                    <th scope="col">Count</th>
                    <th scope="col">Total Sum Insured</th>
                    <th scope="col">Total Premium</th>
                    <th scope="col">Count</th>
                    <th scope="col">Total Sum Insured</th>
                    <th scope="col">Total Premium</th>
                    <th scope="col">Count</th>
                    <th scope="col">Total Sum Insured</th>
                    <th scope="col">Total Premium</th>
                </tr>
            </thead>
            <tbody>
                @foreach ($perLocation as $location)
                    <tr>
                        <td colspan="1"> <strong>{{ $location->location_description }}</strong> </td>
                        <td>{{ number_format($location->last_year_certificate_type_count) }}</td>
                        <td>{{ number_format($location->last_year_total_sum_insured_sum, 2) }}</td>
                        <td>{{ number_format($location->last_year_total_premium_sum, 2) }}</td>
                        <td>{{ number_format($location->current_year_certificate_type_count) }}</td>
                        <td>{{ number_format($location->current_year_total_sum_insured_sum, 2) }}</td>
                        <td>{{ number_format($location->current_year_total_premium_sum, 2) }}</td>
                        <td>{{ number_format($location->variance_certificate_type_count) }}</td>
                        <td>{{ number_format($location->variance_total_sum_insured, 2) }}</td>
                        <td>{{ number_format($location->variance_total_premium_sum, 2) }}</td>

                    </tr>



            </tbody>
            @endforeach
            <tr class="bg-danger text-white">
                @foreach ($grandTotal as $grandTotal)
                @endforeach
                <td colspan="1"> <b>Grand Total</b> </td>
                <td>{{ number_format($grandTotal->grandtotal_last_year_certificate_type_count) }}</td>
                <td>{{ number_format($grandTotal->grandtotal_last_year_total_sum_insured_sum, 2) }}</td>
                <td>{{ number_format($grandTotal->grandtotal_last_year_total_premium_sum, 2) }}</td>
                <td>{{ number_format($grandTotal->grandtotal_current_year_certificate_type_count) }}</td>
                <td>{{ number_format($grandTotal->grandtotal_current_year_total_sum_insured_sum, 2) }}</td>
                <td>{{ number_format($grandTotal->grandtotal_current_year_total_premium_sum, 2) }}</td>
                <td>{{ number_format($grandTotal->grandtotal_variance_certificate_type_count) }}</td>
                <td>{{ number_format($grandTotal->grandtotal_variance_total_sum_insured, 2) }}</td>
                <td>{{ number_format($grandTotal->grandtotal_variance_total_premium_sum, 2) }}</td>
            </tr>
        </table>
    </div>
</div>


{{-- @foreach ($data as $item)


        <div class="col">
            <div class="card">
                <div class="card-body">
                    <h2 class="text-center mb-4">{{ $item->location_description }} </h2>
                  
                    <div class="row">
                        <div class="col-md-6">
                            <h4> As of Year 2024 </h4>
                            <hr>
                            <h5 class="ms-2 mt-2">Policy Count: {{ number_format($item->COI) }}</h5>
                            <h5 class="ms-2 mt-2">Premium: {{ number_format($item->SUM_COI, 2) }}</h5>
                        </div>
                        <div class="col-md-6">
                            <h4> Today </h4>
                            <hr>
                            <h5 class="ms-2 mt-2">Policy Count: {{ number_format($item->perDayTransaction) }}</h5>
                            <h5 class="ms-2 mt-2">Premium: {{ number_format($item->perDayPremium, 2) }}</h5>
                        </div>
                    </div>
                </div>
                <button class="btn btn-primary" onclick="openDetail('{{ $item->location_description }}')">View
                    Detailed Report</button>
            </div>
        </div>

        @endforeach --}}