@php $numberSequence = 1; @endphp @foreach($invoices as $invoice) @php $totalPercentage = 0; $amount = 0; $amountReduce = 0; $agreementAmount = 0; $variationOrderAmount = 0; $salesCalculation = 0; $paymentReceivedAmount = 0; $agreement = \App\Models\Agreement::where('project_id', $invoice->project_id)->first(); $variationOrders = \App\Models\VariationOrder::where('project_id', $invoice->project_id)->get(); $projectPayments = \App\Models\ProjectPayment::where('project_id', $invoice->project_id)->get(); if ($agreement) { if ($agreement->status == 'draft') { if ($agreement->is_resubmit) { $agreementItem = \App\Models\AgreementItem::where('agreement_id', $agreement->id) ->where('revision', 'like', '%REV%') ->orderBy('created_at', 'desc')->first(); } else { $agreementItem = \App\Models\AgreementItem::where('agreement_id', $agreement->id) ->where('revision', 'like', '%EDIT%') ->orderBy('created_at', 'desc')->first(); } } else { $agreementItem = \App\Models\AgreementItem::where('agreement_id', $agreement->id) ->where('revision', 'like', '%REV%') ->orderBy('created_at', 'desc')->first(); } $agreementItemList = \App\Models\AgreementItemList::where('agreement_id', $agreement->id)->where('agreement_item_id', $agreementItem->id)->get(); if ($agreementItemList->count() > 0) { foreach ($agreementItemList as $key => $current) { if ($current->tier_level == 1 && $current->is_area != true) { $amount += $current->amount; $agreementAmount += $current->amount; } } } } if ($variationOrders->count() > 0) { foreach ($variationOrders as $variationOrder) { $variationOrderItem = \App\Models\VariationOrderItem::where('variation_order_id', $variationOrder->id) ->where('revision', 'like', '%REV%') ->orderBy('created_at', 'desc')->first(); $variationOrderItemList = \App\Models\VariationOrderItemList::where('variation_order_id', $variationOrder->id)->where('variation_order_item_id', $variationOrderItem->id)->get(); if ($variationOrderItemList->count() > 0) { foreach ($variationOrderItemList as $key => $current) { if ($current->tier_level == 1 && $current->is_area != true) { $amount += $current->amount; $variationOrderAmount += $current->amount; } } } } } if ($amount > 0) { if ($projectPayments->count() > 0) { foreach ($projectPayments as $key => $current) { $amountReduce += $current->amount; $paymentReceivedAmount += $current->amount; } } $totalPercentage = \App\Helpers\Helper::percentageCalculated($amountReduce, $amount); } $salesCalculation = $agreementAmount + $variationOrderAmount; @endphp @php $numberSequence++; @endphp @endforeach

No	Invoice ID	Project ID	Project Name	Sales			Payment Received
				Agreement	Variation	Total	Total	Percentage
{{ $numberSequence }}	{{ $invoice->running_no }}	{{ $invoice->project->project_no ?? '' }}	{{ $invoice->project->name ?? '' }}	${{number_format((float) $agreementAmount, 2, '.', ',')}}	${{number_format((float) $variationOrderAmount, 2, '.', ',')}}	${{number_format((float) $salesCalculation, 2, '.', ',')}}	${{number_format((float) $paymentReceivedAmount, 2, '.', ',')}}	{{$totalPercentage}}%