{{$company->company_name}}

{{--
--}} {{-- {{$company->company_address}},
{{$company->city}}, Tanzania
--}} {{-- Mob: {{$company->compny_phone}}
Email: {{$company->company_email}}--}} {{--
--}}

FUEL PURCHASES REPORT {{ $date_range }}

@foreach(array_keys($fuel_goods_received_reports) as $index => $supplier)
Supplier: {{$supplier}}
Currency: Tanzanian Shilings (TZS)
Unit Of Measurement: Liters (Ltr)
@foreach($fuel_goods_received_reports[$supplier] as $index => $report) @if($report['cargo_type'] == 'TANKERS') @elseif($report['cargo_type'] == 'CONTAINERS') @elseif($report['cargo_type'] == 'LOOSE_CARGO') @elseif($report['cargo_type'] == 'DRY CARGO') @else @endif {{----}} @endforeach
S/N LPO LPO Date Vehicle Ordered Received Balance CAP Price Discount LPO Price EFD Diff Net Amount EFD Amount Diff Amount D.o.N
{{$total_items++}}{{$total_items++}}{{$total_items++}}{{$total_items++}}{{$total_items++}}{{$report['lpo_id']}} {{$report['lpo_date']}} {{$report['grn_date']}} - {{$report['truck']}} {{number_format($report['lpo_quantity'])}} {{number_format($report['received_quantity'])}} {{number_format($report['balance_quantity'])}} {{number_format($report['cap_price'],2)}} {{number_format(($report['cap_price'] - $report['lpo_price']),2)}} {{number_format($report['lpo_price'],2)}} {{number_format($report['setup_price'],2)}} ({{abs(($report['lpo_price'] - $report['setup_price']))}}) {{number_format($report['lpo_price'] * ($report['received_quantity'] ? $report['received_quantity'] : $report['lpo_quantity']),2)}} {{number_format(($report['received_quantity'] * $report['setup_price']),2)}} {{number_format(abs($report['received_quantity'] * ($report['lpo_price'] - $report['setup_price'])),2)}} {{$report['delivery_order_number']}}
Total {{number_format($total_quantity)}} {{number_format($total_received)}} {{number_format($total_balance)}} {{number_format($total_cap_price ,2)}} {{number_format($total_price,2)}} {{number_format($total_efd_price,2)}} {{number_format($total_net_amount,2)}} {{number_format($total_efd_amount)}} {{number_format($total_diff_amount)}}

@if($supplier_tankers_total_quantity >0) @endif @if($supplier_containers_total_quantity >0) @endif @if($supplier_loose_cargo_total_quantity >0) @endif @if($supplier_dry_cargo_total_quantity >0) @endif @if($supplier_uncategorized_cargo_total_quantity >0) @endif

Ordered Received Balance CAP Price Discount LPO Price EFD Diff Net Amount EFD Amount Discount Amount
Tankers {{number_format($supplier_tankers_total_quantity)}} {{number_format($supplier_tankers_total_received)}} {{number_format($supplier_tankers_total_balance)}} {{number_format($supplier_tankers_total_cap_price/$tanker_count,2)}} {{number_format($supplier_tankers_total_discount/$tanker_count,2)}} {{number_format($supplier_tankers_total_price/$tanker_count,2)}} {{number_format($supplier_tankers_total_efd_price/$tanker_count,2)}} {{number_format($supplier_tankers_total_diff_price/$tanker_count,2)}} {{number_format($supplier_tankers_total_net_amount,2)}} {{ number_format($supplier_tankers_total_efd_amount,2) }} {{ number_format($supplier_tankers_total_diff_amount,2) }}
Containers {{number_format($supplier_containers_total_quantity)}} {{number_format($supplier_containers_total_received)}} {{number_format($supplier_containers_total_balance)}} {{number_format($supplier_containers_total_cap_price/$container_count,2)}} {{number_format($supplier_containers_total_discount/$container_count,2)}} {{number_format($supplier_containers_total_price/$container_count,2)}} {{number_format($supplier_containers_total_efd_price/$container_count,2)}} {{number_format($supplier_containers_total_diff_price/$container_count,2)}} {{number_format($supplier_containers_total_net_amount,2)}} {{ number_format($supplier_containers_total_efd_amount,2) }} {{ number_format($supplier_containers_total_diff_amount,2) }}
Loose Cargo {{number_format($supplier_loose_cargo_total_quantity)}} {{number_format($supplier_loose_cargo_total_received)}} {{number_format($supplier_loose_cargo_total_balance)}} {{number_format($supplier_loose_cargo_total_cap_price/$loose_cargo_count,2)}} {{number_format($supplier_loose_cargo_total_discount/$loose_cargo_count,2)}} {{number_format($supplier_loose_cargo_total_price/$loose_cargo_count,2)}} {{number_format($supplier_loose_cargo_total_efd_price/$loose_cargo_count,2)}} {{number_format($supplier_loose_cargo_total_diff_price/$loose_cargo_count,2)}} {{number_format($supplier_loose_cargo_total_net_amount,2)}} {{ number_format($supplier_loose_cargo_total_efd_amount,2) }} {{ number_format($supplier_loose_cargo_total_diff_amount,2) }}
Dry Cargo {{number_format($supplier_dry_cargo_total_quantity)}} {{number_format($supplier_dry_cargo_total_received)}} {{number_format($supplier_dry_cargo_total_balance)}} {{number_format($supplier_dry_cargo_total_cap_price/$dry_cargo_count,2)}} {{number_format($supplier_dry_cargo_total_discount/$dry_cargo_count,2)}} {{number_format($supplier_dry_cargo_total_price/$dry_cargo_count,2)}} {{number_format($supplier_dry_cargo_total_efd_price/$dry_cargo_count,2)}} {{number_format($supplier_dry_cargo_total_diff_price/$dry_cargo_count,2)}} {{number_format($supplier_dry_cargo_total_net_amount,2)}} {{ number_format($supplier_dry_cargo_total_efd_amount,2) }} {{ number_format($supplier_dry_cargo_total_diff_amount,2) }}
Un defined {{number_format($supplier_uncategorized_cargo_total_quantity)}} {{number_format($supplier_uncategorized_cargo_total_received)}} {{number_format($supplier_uncategorized_cargo_total_balance)}} {{number_format($supplier_uncategorized_cargo_total_cap_price/$uncategorized_cargo_count,2)}} {{number_format($supplier_uncategorized_cargo_total_discount/$uncategorized_cargo_count,2)}} {{number_format($supplier_uncategorized_cargo_total_price/$uncategorized_cargo_count,2)}} {{number_format($supplier_uncategorized_cargo_total_efd_price/$uncategorized_cargo_count,2)}} {{number_format($supplier_uncategorized_cargo_total_diff_price/$uncategorized_cargo_count,2)}} {{number_format($supplier_uncategorized_cargo_total_net_amount,2)}} {{ number_format($supplier_uncategorized_cargo_total_efd_amount,2) }} {{ number_format($supplier_uncategorized_cargo_total_diff_amount,2) }}
Grand Total {{number_format($supplier_tankers_total_quantity + $supplier_containers_total_quantity + $supplier_loose_cargo_total_quantity + $supplier_dry_cargo_total_quantity + $supplier_uncategorized_cargo_total_quantity)}} {{number_format($supplier_tankers_total_received + $supplier_containers_total_received + $supplier_loose_cargo_total_received + $supplier_dry_cargo_total_received + $supplier_uncategorized_cargo_total_received)}} {{number_format($supplier_tankers_total_balance + $supplier_containers_total_balance + $supplier_loose_cargo_total_balance + $supplier_dry_cargo_total_balance + $supplier_uncategorized_cargo_total_balance)}} {{number_format(($supplier_tankers_total_net_amount + $supplier_containers_total_net_amount + $supplier_loose_cargo_total_net_amount + $supplier_dry_cargo_total_net_amount + $supplier_uncategorized_cargo_total_net_amount),2)}} {{number_format(($supplier_tankers_total_efd_amount + $supplier_containers_total_efd_amount + $supplier_loose_cargo_total_efd_amount + $supplier_dry_cargo_total_efd_amount + $supplier_uncategorized_cargo_total_efd_amount),2)}} {{number_format(($supplier_tankers_total_diff_amount + $supplier_containers_total_diff_amount + $supplier_loose_cargo_total_diff_amount + $supplier_dry_cargo_total_diff_amount + $supplier_uncategorized_cargo_total_diff_amount),2)}}
@endforeach