@php $sno = 1 @endphp @foreach ($applications as $application) @php $current_job = $application->applicant->employments->where('current',true)->first(); @endphp @endforeach

#	Application date	Intake	Programme	Center	Surname	Forenames	Exam no	Gender	Date of birth	Nationality	Academic qualification	Employer	Company position	Work address	Home addresses	Tel No	E-mail	Fees payment	Receipt number	Payment date	Applicant photo	Issue of student ID	Graduation	Graduation date	Remarks	Date of Death/ De reg/Withdrawal
{{ $sno++ }}	{{ date('Y-m-d H:i',strtotime($application->created_at)) }}	{{ $application->intake->name??'-' }}	{{ $application->programme->code??'-' }}	{{ $application->campus->name??'-' }}	{{ $application->applicant->surname }}	{{ $application->applicant->forenames }}	{{ $application->registration_number }}	{{ $application->applicant->gender }}	{{ $application->applicant->dob }}	{{ $application->applicant->nationality }}	{{ $application->applicant->education->first()->programme??"-" }}	{{ $current_job->employer??'-' }}	{{ $current_job->position??'-' }}	{{ $current_job?"$current_job->postal_code, $current_job->postal_address":'-' }}	{{ $application->applicant->postal_code.", ".$application->applicant->postal_address }}	{{ $application->applicant->phone }}	{{ $application->applicant->email }}								{{ $application->reason_for }}