@php
    use Illuminate\Support\Facades\DB;
    $areaWise   =   [];
    $grandsum   =   0;
@endphp
<table border="1" style="border: #0c0c0c 1px solid; background-color:#ffffff">
        <thead>
        <tr>
            <td colspan="6">
                <b>Product Sales Report</b>
            </td>

        </tr>
        <tr>
            <td colspan="2"><b>Period From:</b></td>
            <td>{{date('M-Y',strtotime($start_date))}}</td>
            <td colspan="2"><b>Period To:</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 style="background-color: #F9F9F9"><b>SKU</b></th>
        <th style="background-color: #F9F9F9"><b>Product</b></th>
        <th style="background-color: #F9F9F9"><b>Brand</b></th>
        <th style="background-color: #F9F9F9"><b>Range</b></th>
        @foreach($allareas as $area)
        <th style="background-color: #F9F9F9"><b>{{@$area->area_name}}</b></th>
        @endforeach
        <th style="background-color: #F9F9F9"><b>Overall</b></th>
    </tr>
    </thead>
    <tbody>
        @foreach($products as $product)
         @php
         $item_sum  =  0;
         @endphp
        <tr>
            <td>{{ @$product->item_sku }}</td>
            <td>{{ @$product->item_name }} </td>
            <td>{{ @$product->brand_name }} </td>
            <td>NA </td>
            @foreach($allareas as $area)
                @php
                    $item_id            =   $product->item_id;
                    $area_id            =   $area->id;
                    $total_qty_sold     =   0;
                     if(in_array($area_id,$inareas) && in_array($item_id,$inproducts) ){
                        $disttype     = '';
                        if($distributor_type_ids != ''){
                             $disttype     = "  order_contents_dist.distributor_type_id IN ($distributor_type_ids)  AND ";
                         }
                        $total_qty_sold     =   DB::table('orders_dist')
                                                 ->selectRaw("SUM(parent_qty_sold) as total_qty_sold")
                                                 ->join('order_contents_dist', function($join) use($item_id) {
                                                     $join->on('order_contents_dist.order_id', '=', 'orders_dist.id')
                                                     ->where('order_contents_dist.item_id', '=', $item_id)
                                                     ->where('order_contents_dist.item_status', '=', 1)
                                                     ->where('order_contents_dist.dispatch_status', '!=', 3);
                                                 })
                                                 ->whereRaw(" $disttype orders_dist.booking_area= '{$area_id}' AND DATE(orders_dist.completed_at) >= '{$start_date}' AND DATE(orders_dist.completed_at) <= '{$end_date}' AND lower(orders_dist.status)      =   'completed' ")
                                                 //->distinct('order_contents_dist.id')
                                                 ->first()->total_qty_sold;
                     }
                     $item_sum           =  $item_sum+$total_qty_sold;
                     $areaWise[$area_id] =  (int)@$areaWise[$area_id]+$total_qty_sold;
                @endphp
                <td> {{spencerRound(@(int)$total_qty_sold)}}</td>
            @endforeach
            <th><b>{{spencerRound(@$item_sum)}}</b></th>
        </tr>
        @endforeach
        <tr>
            <th colspan="4" style="background-color: #F9F9F9"><b>Total</b></th>
            @foreach($allareas as $area)
                @php
                    $grandsum  =  @$grandsum+@$areaWise[$area->id];
                @endphp
                <th style="background-color: #F9F9F9"><b>{{spencerRound(@$areaWise[$area->id])}}</b></th>
            @endforeach
            <th style="background-color: #F9F9F9"><b>{{spencerRound(@$grandsum)}}</b></th>
        </tr>
    </tbody>
</table>