@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>
        <td colspan="6">
            <b>Company Sales Trend Summary</b>
        </td>
    </tr>
    <tr>
        <td colspan="2"><b>Period From:</b></td>
        <td><b>{{date('M-Y',strtotime($start_date))}}</b></td>
    </tr>
    <tr>
        <td colspan="2"><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 ID</b></th>
        <th style="background-color: #F9F9F9"><b>Dist Name</b></th>
        <th style="background-color: #F9F9F9"><b>Region</b></th>
        <th style="background-color: #F9F9F9"><b>Area</b></th>
        <th style="background-color: #F9F9F9"><b>Territory</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"></td>
        <td style="background-color: #F9F9F9" colspan="4"><b>Area {{$pre_area_name}} Total </b></td>
        @foreach($mnth_list as $month)
            @php
                $ym           =      $month['year']."-".$month['month'];
                $terr_total   +=     $terriwise[$pre_area_id][$ym];
            @endphp
            <td style="background-color: #F9F9F9"><b>{{spencer_number_format($terriwise[$pre_area_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="6"><b>Region {{$pre_region_name}} Total </b></td>
        @foreach($mnth_list as $month)
            @php
                $ym           =      $month['year']."-".$month['month'];
                $area_total   +=     $areawise[$pre_region_id][$ym];
            @endphp
            <td style="background-color: #F9F9F9"><b>{{spencer_number_format($areawise[$pre_region_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="6"><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>