Load Sheet

Distribution: {{$data['distributor']->distributor_name}}

Sales man:{{$data['salesman']->name}}

Load ID:{{$data['load_id']}}

Date: {{$data['date']}}

@php $total_issued_primary_qty = 0; $total_issued_secondary_qty = 0; @endphp @if($data['count']==3) @endif @if($data['count']==2) @endif @if($data['count']==1) @endif @if($data['count']==3) @endif @if($data['count']==2) @endif @if($data['count']==1) @endif @php $PTIQ = 0; $CTIQ = 0; $contentCountData = array(); for ($i=0; $i < $data['count']; $i++) { $object = new stdClass(); $object->parent_qty = 0; $object->child_qty = 0; $contentCountData[] = $object; } @endphp @if(collect($data['load'])->count()>0) @foreach($data['load'] as $key => $load) @if(collect($load->items)->count()>0) @foreach ($load->items as $item) @foreach ($item->content as $key => $content) @php $PTIQ = $PTIQ + $content->parent_qty; $CTIQ = $CTIQ + $content->child_qty; $contentCountData[$key]->parent_qty = $contentCountData[$key]->parent_qty + $content->parent_qty; $contentCountData[$key]->child_qty = $contentCountData[$key]->child_qty + $content->child_qty; @endphp @endforeach @endforeach @endif @endforeach @endif @foreach ($contentCountData as $contentCount) @endforeach

Code	Product's Name	Load 1		Load 2		Load 3		Load 1		Load 2		Load 1		Total Issued		Returns
		Ctn	Pcs/Box	Ctn	Pcs/Box	Ctn	Pcs/Box	Ctn	Pcs/Box	Ctn	Pcs/Box	Ctn	Pcs/Box	Ctn	Pcs/Box	Damage	Sellable
{{$load->brand_name}}
{{$item->item_sku}}	{{$item->item_name}}	{{$content->parent_qty}}	{{$content->child_qty}}	{{$item->total_primary_qty}}	{{$item->total_secondary_qty}}
Total:		{{ $contentCount->parent_qty }}	{{ $contentCount->child_qty }}	{{ $PTIQ }}	{{ $CTIQ }}

Gross Amount: {{ number_format($data['summary']->total_gross_amount, 2) }} T/O Amount: {{ number_format($data['summary']->total_trade_offer, 2) }} Trade Discount: {{ number_format($data['summary']->total_trade_discount, 2) }} Special Discount: {{ number_format($data['summary']->total_special_discount, 2) }} Booker Discount: {{ number_format($data['summary']->total_booker_discount, 2) }} Tax: {{ number_format($data['summary']->total_tax_amount, 2) }} Recovery: {{ number_format($data['summary']->total_recovery_amount, 2) }} Net Sales: {{ number_format($data['summary']->total_net_sale, 2) }} Extra Issuance Amount: {{ number_format($data['summary']->issued_total_price, 2) }}

Invoice Details

Distribution: {{$data['distributor']->distributor_name}}

Sales man:{{$data['salesman']->name}}

Load ID:{{$data['load_id']}}

Date: {{$data['date']}}

@foreach($data['invoices'] as $invoice) @php $retailer = [$invoice->retailer_name ? $invoice->retailer_name:'',$invoice->neighbourhood_name ? $invoice->neighbourhood_name:'',$invoice->retailer_owner ? $invoice->retailer_owner:'']; $retailer = collect(array_filter($retailer))->implode('/'); @endphp @endforeach

Invoice #	Shope Code	Retailer	Order Booker	Status	Total Units	Return	Sales	Total Amount
{{$invoice->invoice_number}}	{{$invoice->shop_code}}	{{$retailer}}	{{$invoice->order_booker_name}}	Open	{{number_format($invoice->ttl_units)}}			{{number_format($invoice->order_total,2)}}
Total					{{number_format(collect($data['invoices'])->sum('ttl_units'))}}			{{number_format(collect($data['invoices'])->sum('order_total'),2)}}

Load Sheet

Invalid load sheet