@php
    error_reporting(0);
    function spencer_number_format($val){
        return $val;
    }
@endphp

<table border="1" style="border: #0c0c0c 1px solid; background-color:#ffffff">
        <thead>
        <tr>
            @if($report_type== 'RegionWise')
                <td colspan="6">
                    <b>Area Sales Trend Summary</b>
                </td>
            @elseif($report_type== 'ProductWise')
                <td colspan="4">
                    <b>Product Sales Trend Report</b>
                </td>
                <td colspan="2"><b>Product:</b></td>

                <td colspan="2">
                    <b>
                        @foreach($product_info as $product_info1)
                        {{$product_info1->item_name}}({{$product_info1->item_sku}}),
                        @endforeach
                    </b>
                </td>
            @endif
        </tr>
        <tr>
            <td></td>
            <td colspan="3"><b>Period From:</b></td>
            <td><b>{{date('M-Y',strtotime($start_date))}}</b></td>
        </tr>
        <tr>
            <td></td>
            <td colspan="3"><b>Period To:</b></td>
            <td><b>{{date('M-Y',strtotime($end_date))}}</b></td>
        </tr>
        </thead>
</table>
<table border="1" style="border: #0c0c0c 1px solid; background-color:#ffffff">
    <thead>
    <tr>
        <th style="background-color: #F9F9F9"><b>Dist Name</b></th>
        <th style="background-color: #F9F9F9"><b>Town</b></th>
        @foreach($mnth_list as $month)
            <th style="background-color: #F9F9F9"><b>{{date('F-Y',strtotime("{$month['year']}-{$month['month']}-1"))}}</b></th>
        @endforeach
        <th style="background-color: #F9F9F9"><b>Total</b></th>
    </tr>
    </thead>
    <tbody>
        <tr>
        <td style="background-color: #F9F9F9" colspan="2"><b>Territory {{$pre_terr_name}} Total </b></td>
        @foreach($mnth_list as $month)
            @php
                $ym           =      $month['year']."-".$month['month'];
                $terr_total   +=     $terriwise[$pre_terr_id][$ym];
            @endphp
            <td style="background-color: #F9F9F9"><b>{{spencer_number_format($terriwise[$pre_terr_id][$ym])}}</b></td>
        @endforeach
        <td style="background-color: #F9F9F9"><b>{{spencer_number_format($terr_total)}}</b></td>
    </tr>
    <tr>
        <td style="background-color: #F9F9F9" colspan="2"><b>Area {{$pre_area_name}} Total </b></td>
        @foreach($mnth_list as $month)
            @php
                $ym           =      $month['year']."-".$month['month'];
                $area_total   +=     $areawise[$pre_area_id][$ym];
            @endphp
            <td style="background-color: #F9F9F9"><b>{{spencer_number_format($areawise[$pre_area_id][$ym])}}</b></td>
        @endforeach
        <td style="background-color: #F9F9F9"><b>{{spencer_number_format($area_total)}}</b></td>
    </tr>
    <tr>
        <td style="background-color: #F9F9F9" colspan="2"><b>GRAND TOTAL </b></td>
        @foreach($mnth_list as $month)
            @php
                $ym    =      $month['year']."-".$month['month'];
            @endphp
            <td style="background-color: #F9F9F9"><b>{{spencer_number_format($monthwise[$ym])}}</b></td>
        @endforeach
        <td style="background-color: #F9F9F9"><b>{{spencer_number_format($grand_total)}}</b></td>
    </tr>
    </tbody>
</table>
<table border="1" style="border: #0c0c0c 1px solid; background-color:#ffffff">
    <thead>
        <tr><td></td><td></td><td></td></tr>
        <tr><td></td><td></td><td></td></tr>
        <tr><td></td><td></td><td></td></tr>
        @foreach($regions_data as $region)
            <tr>
                <th style="background-color: #F9F9F9" colspan="2"><b>{{$region->region_name}} Total </b></th>
                <th style="background-color: #F9F9F9"><b>{{spencer_number_format($region->total_sale)}}</b></th>
            </tr>
        @endforeach
        <tr><td></td><td></td><td></td></tr>
        <tr><td></td><td></td><td></td></tr>
        <tr>
            <th style="background-color: #F9F9F9" colspan="2"><b>National </b></th>
            <th style="background-color: #F9F9F9"><b>{{spencer_number_format($national[0]->total_sale)}}</b></th>
        </tr>
    </thead>
</table>