{{-- style="overflow-x: scroll"--}}
| SKU |
Product |
Brand |
{{-- Unit Type | --}}
@foreach($data['employees'] as $employee)
{{$employee->employee_first_name}} {{$employee->employee_last_name}} |
@endforeach
Total Sales |
@foreach($data['employees'] as $employee)
| Net Sales |
FOC QTY |
Gross Value |
Net Revenue |
@endforeach
Net Sales |
FOC QTY |
Gross Value |
Net Revenue |
@foreach($data['items'] as $item)
@php
$t_net_sale = 0;
$t_foc_qty = 0;
$t_gross_value = 0;
$t_net_revenue = 0;
// $unit = array_values(array_filter($data['data'], fn ($x) => $x->item_id == $item->item_id));
@endphp
| {{$item->item_sku}} |
{{$item->item_name}} |
{{$item->brand_name}} |
{{-- {{@$unit[0]->unit_name}} | --}}
@foreach($data['employees'] as $employee)
@php
$res = array_values(array_filter($data['data'], fn ($x) => $x->item_id == $item->item_id && $x->employee_id == $employee->employee_id));
$net_sale = (float)@$res[0]->net_sale;
$foc_qty = (float)@$res[0]->foc_qty;
$gross_value = (float)@$res[0]->gross_value;
$net_revenue = (float)@$res[0]->net_revenue;
$t_net_sale += $net_sale;
$t_foc_qty += $foc_qty;
$t_gross_value += $gross_value;
$t_net_revenue += $net_revenue;
@endphp
{{number_format($net_sale)}} |
{{number_format($foc_qty)}} |
{{number_format($gross_value,2)}} |
{{number_format($net_revenue,2)}} |
@endforeach
{{number_format($t_net_sale)}} |
{{number_format($t_foc_qty)}} |
{{number_format($t_gross_value,2)}} |
{{number_format($t_net_revenue,2)}} |
@endforeach