@php
    use Illuminate\Support\Facades\DB;
    $monthWise           =   [];
    $target_target_arr     =   [];
    $netsale_target_arr  =   [];
    $achvment_target_arr  =   [];
    $gawt_target        =   0;
    $gdt_target     =   0;
    $gdt_cus_target     =   0;
    error_reporting(0);
@endphp
<table border="1" style="border: #0c0c0c 1px solid; background-color:#ffffff">
    <thead>
    <tr>
        <td colspan="6">
            <b>Distribution Sales Target Achievement Analysis</b>
        </td>

    </tr>
    <tr>
        <td colspan="2"><b>Start Month:</b></td>
        <td>{{date('M-Y',strtotime($start_date))}}</td>
        <td colspan="2"><b>End Month:</b></td>
        <td>{{date('M-Y',strtotime($end_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>Distributor ID</b></th>
        <th rowspan="2" style="background-color: #F9F9F9"><b>Distributor Name</b></th>
        <th rowspan="2" style="background-color: #F9F9F9"><b>City Name</b></th>
        <th rowspan="2" style="background-color: #F9F9F9"><b>Territory</b></th>
        <th rowspan="2" style="background-color: #F9F9F9"><b>TSM/TSO</b></th>
        <th rowspan="2" style="background-color: #F9F9F9"><b>Zone</b></th>
        <th rowspan="2" style="background-color: #F9F9F9"><b>Region</b></th>
        @foreach($months as $month)
            <th colspan="3" style="background-color: #F9F9F9;text-align: center"><b>{{date('M-Y',strtotime($month."-1"))}}</b></th>
        @endforeach
        <th colspan="3" style="background-color: #F9F9F9;text-align: center"><b>Overall</b></th>
    </tr>
    <tr>
        @foreach($months as $month)
            <th style="background-color: #F9F9F9"><b>Revised Targets</b></th>
            <th style="background-color: #F9F9F9"><b>Net Sale</b></th>
            <th style="background-color: #F9F9F9"><b>Ach%</b></th>
        @endforeach
        <th style="background-color: #F9F9F9"><b>Revised Targets</b></th>
        <th style="background-color: #F9F9F9"><b>Net Sale</b></th>
        <th style="background-color: #F9F9F9"><b>Ach%</b></th>
    </tr>
    </thead>
    <tbody>
    @foreach($distributors as $distributor)
        @php
        $target_target         =   0;
        $netsale_target        =   0;
        $achvment_target       =   0;
        @endphp
        <tr>
            <td>{{ $distributor->id }}</td>
            <td>{{ $distributor->distributor_name }}</td>
            <td>{{ $distributor->city_name }}</td>
            <td>{{ $distributor->territory_name }}</td>
            <td>{{ $distributor->tsm }}</td>
            <td>{{ $distributor->area_name }} </td>
            <td>{{ $distributor->region_name }} </td>
            @foreach($months as $month)
                @php
                    $netsale          =   array_values(array_filter($netsales, fn ($x) => $x->distributor_id == $distributor->id && $x->territory_id == $distributor->territory_id && $x->yearmonth == $month));
                    $target           =   array_values(array_filter($targets, fn ($x) => $x->distributor_id == $distributor->id && $x->territory_id == $distributor->territory_id && $x->yearmonth == $month));

                    $thisnetsale      =   (int)$netsale[0]->ttl_qty_sold;
                    $thistarget       =   (int)$target[0]->target;
                    if($thisnetsale == 0 || $thistarget == 0){
                        $achvment     = 0;
                    }else{
                        $achvment     =   (float)(($thisnetsale/$thistarget)*100);
                    }
                    $netsale_target                +=   $thisnetsale;
                    $target_target                 +=   $thistarget;
                    $netsale_target_arr[$month]    +=   $thisnetsale;
                    $target_target_arr[$month]     +=   $thistarget;


                    $gdt_target                     +=   $thisnetsale;
                    $gawt_target                    +=   $thistarget;
                    $gdt_cus_target                 +=   $achvment;

                @endphp
                <td> {{spencerRound($thistarget)}}</td>
                <td> {{spencerRound($thisnetsale)}}</td>
                <td style="text-align: right"> {{spencerRound($achvment)}}%</td>
            @endforeach
            @php
                if($netsale_target == 0 || $target_target == 0){
                    $achvment_target     = 0;
                }else{
                    $achvment_target     =   (float)(($netsale_target/$target_target)*100);
                }
            @endphp
            <th><b>{{spencerRound($target_target)}}</b></th>
            <th><b>{{spencerRound($netsale_target)}}</b></th>
            <th style="text-align: right"><b>{{spencerRound($achvment_target)}}%</b></th>
        </tr>
    @endforeach
    <tr>
        <th colspan="6" style="background-color: #F9F9F9"><b>Total</b></th>
        @foreach($months as $month)
            @php
                if($target_target_arr[$month] == 0 || $netsale_target_arr[$month] == 0){
                    $achvment_target_arr     = 0;
                }else{
                    $achvment_target_arr     =   (float)(($netsale_target_arr[$month]/$target_target_arr[$month])*100);
                }
            @endphp
            <th style="background-color: #F9F9F9"><b>{{spencerRound($target_target_arr[$month])}}</b></th>
            <th style="background-color: #F9F9F9"><b>{{spencerRound($netsale_target_arr[$month])}}</b></th>
            <th style="background-color: #F9F9F9;text-align: right"><b>{{spencerRound($achvment_target_arr)}}%</b></th>
        @endforeach
        @php
            if($gawt_target == 0 || $gdt_target == 0){
                $gdt_cus_target     =  0;
            }else{
                $gdt_cus_target     =  (float)(($gdt_target/$gawt_target)*100);
            }
        @endphp
        <th style="background-color: #F9F9F9"><b>{{spencerRound($gawt_target)}}</b></th>
        <th style="background-color: #F9F9F9"><b>{{spencerRound($gdt_target)}}</b></th>
        <th style="background-color: #F9F9F9;text-align: right"><b>{{spencerRound($gdt_cus_target)}}%</b></th>
    </tr>
    </tbody>
</table>