@php // Group applications by job category (same as PDF) $groupedApplications = $applications->groupBy(function ($app) { return $app->jobVacancy->category->name ?? 'Uncategorized'; }); $statusCounts = [ 'pending' => $applications->where('status', 'pending')->count(), 'approved' => $applications->where('status', 'approved')->count(), 'rejected' => $applications->where('status', 'rejected')->count(), 'under_review' => $applications->where('status', 'under_review')->count(), ]; @endphp @forelse ($groupedApplications as $category => $applicationGroup) @foreach ($applicationGroup as $index => $application) @endforeach @empty @endforelse @if ($applications->count() > 0) @endif

{{ $title }}
Generated on: {{ $generated_at }} Date Range: {{ $filters['dateRange'] ?? 'All Dates' }} | Status: {{ $filters['status'] ?? 'All' }} | Category: {{ $filters['category'] ?? 'All' }}
#	Applicant Name	Contact	Job Title	Company	Category	Salary	Applied Date	Status
Summary: Total Applications: {{ $applications->count() }} | Pending: {{ $statusCounts['pending'] }} | Approved: {{ $statusCounts['approved'] }} | Rejected: {{ $statusCounts['rejected'] }} | Under Review: {{ $statusCounts['under_review'] }}
{{ $category }} ({{ $applicationGroup->count() }} applications)
{{ $index + 1 }}	{{ $application->jobSeeker->user->name ?? 'N/A' }} {{ $application->jobSeeker->user->email ?? 'N/A' }}	{{ $application->jobSeeker->user->telephone ?? 'N/A' }} {{ $application->jobSeeker->user->address ?? 'N/A' }}	{{ $application->jobVacancy->title ?? 'N/A' }}	{{ $application->jobVacancy->employer->user->name ?? 'N/A' }}	{{ $application->jobVacancy->category->name ?? 'N/A' }}	₱{{ number_format($application->jobVacancy->salary_range_from ?? 0, 0) }} - ₱{{ number_format($application->jobVacancy->salary_range_to ?? 0, 0) }}	{{ $application->created_at->format('M d, Y') }}	@php $statusColor = match ($application->status) { 'approved' => '#d1fae5', 'rejected' => '#fee2e2', 'under_review' => '#e0e7ff', default => '#fef3c7', }; @endphp {{ ucfirst(str_replace('_', ' ', $application->status)) }}
No job applications found for the selected filters.
Total Applications: {{ $applications->count() }}