@foreach($projects as $project) @php $company = 'N/A'; if ($project->quotation && isset($project->quotation->company) && $project->quotation->company) { $company = $project->quotation->company->name; } $nextVisit = $project->visitSchedules ->where('status', '!=', 'done') ->sortBy('visit_date') ->first(); $nextVisitDate = $nextVisit ? $nextVisit->visit_date : 'N/A'; $expiryDate = \Carbon\Carbon::parse($project->date)->addYear()->format('Y-m-d'); $pendingVisits = $project->visitSchedules ->whereIn('status', ['pending', 'upcoming']) ->count(); @endphp @endforeach

ID	Company	Category	Start Date	Expiry Date	Total Visits	Pending Visits	Next Visit Date	Status
{{ $project->id }}	{{ $company }}	{{ strtoupper($project->category) }}	{{ \Carbon\Carbon::parse($project->date)->format('Y-m-d') }}	{{ $expiryDate }}	{{ $project->visits ?? 0 }}	{{ $pendingVisits }}	{{ $nextVisitDate }}	{{ $project->status ?? 'Active' }}