@php
    use Illuminate\Support\Facades\DB;
    $areaWise           =   [];
    $awt_target_arr     =   [];
    $dt_sys_target_arr  =   [];
    $dt_cus_target_arr  =   [];
    $gawt_target        =   0;
    $gdt_sys_target     =   0;
    $gdt_cus_target     =   0;
@endphp
<table border="1" style="border: #0c0c0c 1px solid; background-color:#ffffff">
    <thead>
    <tr>
        <td colspan="6">
            <b>Product Zonal Target Overview Report</b>
        </td>

    </tr>
    <tr>
        <td colspan="2"><b>Month:</b></td>
        <td>{{date('M-Y',strtotime($start_date))}}</td>
    </tr>
    </thead>
</table>
<table border="1" style="border: #0c0c0c 1px solid; background-color:#ffffff">
    <thead>
    <tr>
        <th rowspan="2" style="background-color: #F9F9F9"><b>SKU</b></th>
        <th rowspan="2" style="background-color: #F9F9F9"><b>Product</b></th>
        <th rowspan="2" style="background-color: #F9F9F9"><b>Brand</b></th>
        <th rowspan="2" style="background-color: #F9F9F9"><b>Unit</b></th>
        @foreach($areas as $area)
            <th colspan="3" style="background-color: #F9F9F9;text-align: center"><b>{{@$area->area_name}}</b></th>
        @endforeach
        <th colspan="3" style="background-color: #F9F9F9;text-align: center"><b>Overall</b></th>
    </tr>
    <tr>
        @foreach($areas as $area)
            <th style="background-color: #F9F9F9"><b>Zonal Targets</b></th>
            <th style="background-color: #F9F9F9"><b>System Targets</b></th>
            <th style="background-color: #F9F9F9"><b>Revised Target</b></th>
        @endforeach
        <th style="background-color: #F9F9F9"><b>Zonal Targets</b></th>
        <th style="background-color: #F9F9F9"><b>System Targets</b></th>
        <th style="background-color: #F9F9F9"><b>Revised Target</b></th>
    </tr>
    </thead>
    <tbody>
    @foreach($products as $product)
        @php
        $awt_target         =   0;
        $dt_sys_target      =   0;
        $dt_cus_target      =   0;
        @endphp
        <tr>
            <td>{{ @$product->item_sku }}</td>
            <td>{{ @$product->item_name }} </td>
            <td>{{ @$product->brand_name }} </td>
            <td>{{ @$product->unit_name }} </td>
            @foreach($areas as $area)
                @php
                $awt      =   array_values(array_filter($awts, fn ($x) => $x->item_id == $product->item_id && $x->area_id == $area->id));
                $dt       =   array_values(array_filter($dts, fn ($x) => $x->item_id == $product->item_id && $x->area_id == $area->id));

                @$awt_target                     +=   @$awt[0]->target;
                @$dt_sys_target                  +=   @$dt[0]->system_targets;
                @$dt_cus_target                  +=   @$dt[0]->custom_targets;
                @$awt_target_arr[$area->id]      +=   @$awt[0]->target;;
                @$dt_sys_target_arr[$area->id]   +=   @$dt[0]->system_targets;
                @$dt_cus_target_arr[$area->id]   +=   @$dt[0]->custom_targets;


                @$gawt_target                    +=   @$awt[0]->target;
                @$gdt_sys_target                 +=   @$dt[0]->system_targets;
                @$gdt_cus_target                 +=   @$dt[0]->custom_targets;

                @endphp
                <td> {{spencerRound(@$awt[0]->target)}}</td>
                <td> {{spencerRound(@$dt[0]->system_targets)}}</td>
                <td> {{spencerRound(@$dt[0]->custom_targets)}}</td>
            @endforeach
            <th><b>{{spencerRound($awt_target)}}</b></th>
            <th><b>{{spencerRound($dt_sys_target)}}</b></th>
            <th><b>{{spencerRound($dt_cus_target)}}</b></th>
        </tr>
    @endforeach
    <tr>
        <th colspan="4" style="background-color: #F9F9F9"><b>Total</b></th>
        @foreach($areas as $area)
            <th style="background-color: #F9F9F9"><b>{{spencerRound(@$awt_target_arr[$area->id])}}</b></th>
            <th style="background-color: #F9F9F9"><b>{{spencerRound(@$dt_sys_target_arr[$area->id])}}</b></th>
            <th style="background-color: #F9F9F9"><b>{{spencerRound(@$dt_cus_target_arr[$area->id])}}</b></th>
        @endforeach
        <th style="background-color: #F9F9F9"><b>{{spencerRound(@$gawt_target)}}</b></th>
        <th style="background-color: #F9F9F9"><b>{{spencerRound(@$gdt_sys_target)}}</b></th>
        <th style="background-color: #F9F9F9"><b>{{spencerRound(@$gdt_cus_target)}}</b></th>
    </tr>
    </tbody>
</table>