@php
    use Illuminate\Support\Facades\DB;
    $terrWise           =   [];
    $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 Territorial 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>
        <th rowspan="2" style="background-color: #F9F9F9"><b>Zonal Targets</b></th>
        @foreach($terrs as $terr)
            <th colspan="2" style="background-color: #F9F9F9;text-align: center"><b>{{@$terr->territory_name}}</b></th>
        @endforeach
        <th colspan="2" style="background-color: #F9F9F9;text-align: center"><b>Overall</b></th>
    </tr>
    <tr>
        @foreach($terrs as $terr)
            <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>System Targets</b></th>
        <th style="background-color: #F9F9F9"><b>Revised Target</b></th>
    </tr>
    </thead>
    <tbody>
    @foreach($products as $product)
        @php
        $dt_sys_target      =   0;
        $dt_cus_target      =   0;
        $awt                =   array_values(array_filter($awts, fn ($x) => $x->item_id == $product->item_id && $x->area_id == $area_id));
        @$gawt_target       +=   @$awt[0]->target;
        @endphp
        <tr>
            <td>{{ @$product->item_sku }}</td>
            <td>{{ @$product->item_name }} </td>
            <td>{{ @$product->brand_name }} </td>
            <td>{{ @$product->unit_name }} </td>
            <td>{{ @$awt[0]->target }} </td>
            @foreach($terrs as $terr)
                @php
                $dt       =   array_values(array_filter($dts, fn ($x) => $x->item_id == $product->item_id && $x->area_id == $area_id  && $x->territory_id == $terr->id));

                @$dt_sys_target                  +=   @$dt[0]->system_targets;
                @$dt_cus_target                  +=   @$dt[0]->custom_targets;
                @$dt_sys_target_arr[$terr->id]   +=   @$dt[0]->system_targets;
                @$dt_cus_target_arr[$terr->id]   +=   @$dt[0]->custom_targets;
                @$gdt_sys_target                 +=   @$dt[0]->system_targets;
                @$gdt_cus_target                 +=   @$dt[0]->custom_targets;

                @endphp
                <td> {{spencerRound(@$dt[0]->system_targets)}}</td>
                <td> {{spencerRound(@$dt[0]->custom_targets)}}</td>
            @endforeach
            <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>
        <th style="background-color: #F9F9F9"><b>{{spencerRound(@$gawt_target)}}</b></th>
        @foreach($terrs as $terr)
            <th style="background-color: #F9F9F9"><b>{{spencerRound(@$dt_sys_target_arr[$terr->id])}}</b></th>
            <th style="background-color: #F9F9F9"><b>{{spencerRound(@$dt_cus_target_arr[$terr->id])}}</b></th>
        @endforeach
        <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>