@foreach($projects as $project) @endforeach
Project ID Project Name Designer Client Name Client Contact Email Budget Source Property Type Address Project Start Status
{{ $project->project_no }} {{ $project->name ?? '' }} {{ $project->designer->name ?? '' }} {{ $project->client_title ?? '' }}{{ $project->client_name }} {{ $project->country_code ?? '' }}{{ str_replace("-", "",$project->contact_number) }} {{ $project->email ?? '-' }} {{ $project->budget ?? '-' }} {{ $project->masterSource->name ?? '-' }} {{ $project->propertyType->name ?? '-' }} {{ $project->road_no ?? '-' }} {{ $project->block_no ?? '-' }} {{ $project->road_name ?? '-' }} {{ $project->residence ?? '-' }} {{ $project->country_name ?? '-' }} {{ $project->postal_code ?? '-' }} {{ $project->project_start ?? '-' }} @php if ($project->status == 'void') { echo 'Void'; } else { $handover = \App\Models\Handover::where('project_id', $project->project_id)->first(); $agreement = null; $quotation = \App\Models\Quotation::where('project_id', $project->id)->first(); if ($quotation) { $agreement = \App\Models\Agreement::where('quotation_id', $quotation->id)->first(); } if ($agreement) { if ($handover) { echo 'Complete'; } else { echo 'Agreement'; } } else { echo 'Quotation'; } } @endphp