{{--@foreach($projects as $project) @foreach($project->phases as $phase) @foreach($phase->payments as $payment) @endforeach @endforeach @endforeach--}} @foreach ($allDatas as $allData) @endforeach

Invoice Totals - {{$phaseType}}								Filtered Total
Phases completed								{{$count}}
To enable the table auto-filters: select Row 5 then press Ctrl+Shift+L
Office	Project #	Phases	Salesperson	Project Supervisor	Homeowner	Completed	Vendor Name	Invoice Number	Invoice Date	Invoice Amount
{{$project->office->OfficeName}}	{{$project->id}}	{{ optional($project->phases->first())->type->Name ?? '-' }}	{{($project->salesperson)?$project->salesperson->contactInfo->name:'Unassigned'}}	{{($project->supervisor)?$project->supervisor->contactInfo->name:'Unassigned'}}	{{$project->customer->LastName}} {{$project->customer->FirstName}}	{{$phase->CompletedDate}}	{{optional($phase->subcontractor)->BusinessName}}	{{$payment->InvoiceNumber}}	{{$payment->InvoiceDate}}	{{ AppHelper::formatPrice($payment->amount )}}
{{$allData['office_name']}}	{{$allData['project_id']}}	{{$allData['phase_type']}}	{{$allData['salesperson_name']}}	{{$allData['project_supervisor']}}	{{$allData['homeowner_name']}}	{{$allData['phase_completed_date']}}	{{$allData['phase_subcontractor']}}	{{$allData['payment_invoice_number']}}	{{$allData['payment_invoice_date']}}	{{$allData['payment_amount'] }}
								Total		{{ AppHelper::formatPrice($projects->sum(function($project) { return $project->phases->sum(function($phase) { return $phase->payments->sum('amount'); }); })) }}