@if(!empty($result)) @foreach($result as $results_data)

Candidate Name	{{$results_data->candidate_name}}	Candidate Position	{{$results_data->position_name}}
Candidate Email	{{$results_data->candidate_email}}	Candidate Gender	{{$results_data->candidate_gender}}
Candidate Salary	{{$results_data->candidate_salary}}	Candidate Mobile No.	{{$results_data->candidate_mobile}}
Manager Name	{{$results_data->manager_name}}	HR Email	{{$results_data->hr_email}}

@endforeach @endif

@php $LcMolDocs = App\Models\MedicalReport::where('candidate_id', $candidate_id)->select('title', 'file_name', 'created_by', 'created_at')->get(); @endphp @if(!empty($LcMolDocs)) @foreach($LcMolDocs as $LcMolDoc) @endforeach @endif @php $LcMolDocs = App\Models\VisaDocument::where('candidate_id', $candidate_id)->select('title', 'file_name', 'created_by', 'created_at')->get(); @endphp @if(!empty($LcMolDocs)) @foreach($LcMolDocs as $LcMolDoc) @endforeach @endif @php $SLcMolDocs = App\Models\SignedLcMolDoc::where('candidate_id', $candidate_id)->select('title', 'file_name', 'created_by', 'created_at')->get(); @endphp @if(!empty($SLcMolDocs)) @foreach($SLcMolDocs as $LcMolDoc) @if($LcMolDoc->created_by == 'candidate') @else @php $user_name = App\Models\User::where('id', $LcMolDoc->created_by)->select('name')->first(); @endphp @endif @endforeach @endif @php $LcMolDocs1 = App\Models\LcMolDoc::where('candidate_id', $candidate_id)->select('title', 'file_name', 'created_by', 'created_at')->get(); @endphp @if(!empty($LcMolDocs1)) @foreach($LcMolDocs1 as $LcMolDoc) @php $user_name = App\Models\User::where('id', $LcMolDoc->created_by)->select('name')->first(); @endphp @endforeach @endif @if(!empty($getRequiredDoc)) @foreach($getRequiredDoc as $requiredDoc) @php $doc = App\Models\DocumentMaster::where('id', $requiredDoc->document_id)->select('document_title')->first(); @endphp @if($requiredDoc->created_by == 'HR') @php $user_name = App\Models\User::where('id', $requiredDoc->organisation_id)->select('name')->first(); @endphp @else @endif @endforeach @endif @php $results_data = App\Models\SendOfferLettersToCandidate::where('candidate_id', $candidate_id)->select('organisation_id', 'document_title', 'document_file', 'created_at')->first(); @endphp @if(!empty($results_data->organisation_id)) @php $document_title = json_decode($results_data->document_title); $document_file = json_decode($results_data->document_file); @endphp @foreach ($document_title as $key => $value) @php $user_name = App\Models\User::where('id', $results_data->organisation_id)->select('name')->first(); @endphp @endforeach @endif @php $results_data1 = App\Models\SendHrRequest::where('id', $candidate_id)->select('candidate_resume', 'manager_name', 'created_at')->first(); @endphp @if(!empty($results_data1->candidate_resume)) @endif

Uploaded Document
S. No	Document Type	Title	File	Uploaded By	Uploaded At
{{$loop->iteration}}	Medical Test Report	{{$LcMolDoc->title}}	View	@php $user_name = App\Models\User::where('id', $LcMolDoc->created_by)->select('name')->first(); @endphp {{$user_name->name}}	{{date('d M, Y', strtotime($LcMolDoc->created_at))}}
{{$loop->iteration}}	eVisa Document	{{$LcMolDoc->title}}	View	@php $user_name = App\Models\User::where('id', $LcMolDoc->created_by)->select('name')->first();@endphp {{$user_name->name}}	{{date('d M, Y', strtotime($LcMolDoc->created_at))}}
{{$loop->iteration}}	LC/MOL Signed Copy	{{$LcMolDoc->title}}	View	Candidate	{{$user_name->name}}	{{date('d M, Y', strtotime($LcMolDoc->created_at))}}
{{$loop->iteration}}	LC/MOL Document	{{$LcMolDoc->title}}	View	{{$user_name->name}}	{{date('d M, Y', strtotime($LcMolDoc->created_at))}}
{{$loop->iteration}}	{{@$doc->document_title}}	{{$requiredDoc->document_title}}	View	{{$user_name->name}}	Candidate	{{date('d M, Y', strtotime($requiredDoc->doc_upload_date))}}
{{$loop->iteration}}	Offer Letter	{{$value}}	@foreach ($document_file as $key1 => $value1) @if($key1 == $key) View @endif @endforeach	{{$user_name->name}}	{{date('d M, Y', strtotime($results_data->created_at))}}
#	Resume		View	{{$results_data1->manager_name}}	{{date('d M, Y', strtotime($results_data1->created_at))}}

@php $SendProLcMol = App\Models\EidDocument::where('candidate_id', $candidate_id)->select('created_by', 'created_at')->orderBy('id', 'desc')->first(); @endphp @if(!empty($SendProLcMol)) @php $user_name = App\Models\User::where('id', $SendProLcMol->created_by)->select('name')->first();@endphp @endif @php $SendProLcMol = App\Models\EidProcesse::where('candidate_id', $candidate_id)->select('request_send_by', 'created_at')->orderBy('id', 'desc')->first();@endphp @if(!empty($SendProLcMol)) @php $user_name = App\Models\User::where('id', $SendProLcMol->request_send_by)->select('name')->first();@endphp @endif @php $SendProLcMol = App\Models\MedicalReport::where('candidate_id', $candidate_id)->select('created_by', 'created_at')->orderBy('id', 'desc')->first(); @endphp @if(!empty($SendProLcMol)) @php $user_name = App\Models\User::where('id', $SendProLcMol->created_by)->select('name')->first();@endphp @endif @php $SendProLcMol = App\Models\MedicalAppointment::where('candidate_id', $candidate_id)->select('created_by', 'created_at', 'place', 'appointment_time')->orderBy('id', 'desc')->first(); @endphp @if(!empty($SendProLcMol)) @php $user_name = App\Models\User::where('id', $SendProLcMol->created_by)->select('name')->first();@endphp @endif @php $SendProLcMol = App\Models\VisaDocument::where('candidate_id', $candidate_id)->select('created_by', 'created_at')->orderBy('id', 'desc')->first(); @endphp @if(!empty($SendProLcMol)) @php $user_name = App\Models\User::where('id', $SendProLcMol->created_by)->select('name')->first();@endphp @endif @php $SendProLcMol = App\Models\SendProEvisaProcessing::where('candidate_id', $candidate_id)->select('created_by', 'created_at')->orderBy('id', 'desc')->first();@endphp @if(!empty($SendProLcMol)) @php $user_name = App\Models\User::where('id', $SendProLcMol->created_by)->select('name')->first();@endphp @endif @php $SendProLcMol = App\Models\SignedLcMolDoc::where('candidate_id', $candidate_id)->select('created_by', 'created_at')->orderBy('id', 'desc')->first();@endphp @if(!empty($SendProLcMol)) @if($SendProLcMol->created_by == 'candidate') @else @php $user_name = App\Models\User::where('id', $SendProLcMol->created_by)->select('name')->first();@endphp @endif @endif @php $SendProLcMol = App\Models\LcMolDoc::where('candidate_id', $candidate_id)->select('created_by', 'created_at')->orderBy('id', 'desc')->first(); @endphp @if(!empty($SendProLcMol)) @php $user_name = App\Models\User::where('id', $SendProLcMol->created_by)->select('name')->first();@endphp @endif @php $SendProLcMol = App\Models\SendProLcMol::where('candidate_id', $candidate_id)->select('request_send_by', 'created_at')->first(); @endphp @if(!empty($SendProLcMol)) @php $user_name = App\Models\User::where('id', $SendProLcMol->request_send_by)->select('name')->first();@endphp @endif @php $SendVisaApproval = App\Models\SendVisaApproval::where('candidate_id', $candidate_id)->where('visa_approved_reject_status', '!=', 0)->select('manager_id', 'visa_approved_date', 'visa_rejected_date', 'visa_approved_reject_status')->first(); @endphp @if(!empty($SendVisaApproval)) @if($SendVisaApproval->visa_approved_reject_status == 1) @else @endif @php $user_name = App\Models\User::where('id', $SendVisaApproval->manager_id)->select('name')->first();@endphp @if($SendVisaApproval->visa_approved_reject_status == 1) @else @endif @endif @php $SendVisaApproval = App\Models\SendVisaApproval::where('candidate_id', $candidate_id)->select('organisation_id', 'created_at')->first(); @endphp @if(!empty($SendVisaApproval)) @php $user_name = App\Models\User::where('id', $SendVisaApproval->organisation_id)->select('name')->first();@endphp @endif @php $sign_doc = App\Models\CandidateRequiredDocument::where('candidate_id', $candidate_id)->where('document_id', 6)->select('doc_upload_date', 'created_by', 'organisation_id')->first(); @endphp @if(!empty($sign_doc)) @if($sign_doc->created_by == 'HR') @php $user_name = App\Models\User::where('id', $sign_doc->organisation_id)->select('name')->first();@endphp @else @endif @endif @php $offer_letter_status = App\Models\SendOfferLettersToCandidate::where('candidate_id', $candidate_id)->select('status', 'updated_at')->first(); @endphp @if($offer_letter_status) @if($offer_letter_status->status != 0) @endif @endif

Status History
S No.	Process	Status	By	Date
1	EID Document	Uploaded	{{$user_name->name}}	{{date('d M, Y', strtotime($SendProLcMol->created_at))}}
1	EID Process	Sent To PRO	{{$user_name->name}}	{{date('d M, Y', strtotime($SendProLcMol->created_at))}}
1	Medical Reports	Uploaded	{{$user_name->name}}	{{date('d M, Y', strtotime($SendProLcMol->created_at))}}
1	Medical Test Appointment Date: {{date('d M, Y, H:i', strtotime($SendProLcMol->appointment_time))}} Place: {{$SendProLcMol->place}}	Sent	{{$user_name->name}}	{{date('d M, Y', strtotime($SendProLcMol->created_at))}}
1	eVisa Documents	Uploaded	{{$user_name->name}}	{{date('d M, Y', strtotime($SendProLcMol->created_at))}}
1	Sent PRO to eVisa Processing	Sent	{{$user_name->name}}	{{date('d M, Y', strtotime($SendProLcMol->created_at))}}
1	LC/MOL signed copy	Uploaded	Candidate	{{$user_name->name}}	{{date('d M, Y', strtotime($SendProLcMol->created_at))}}
1	LC/MOL documents	Uploaded	{{$user_name->name}}	{{date('d M, Y', strtotime($SendProLcMol->created_at))}}
1	Sent for LC/MOL process	Sent	{{$user_name->name}}	{{date('d M, Y', strtotime($SendProLcMol->created_at))}}
1	eVisa	Approved	Rejected	{{@$user_name->name}}	{{date('d M, Y', strtotime($SendVisaApproval->visa_approved_date))}}	{{date('d M, Y', strtotime($SendVisaApproval->visa_rejected_date))}}
1	Sent for eVisa approvals	Sent	{{$user_name->name}}	{{date('d M, Y', strtotime($SendVisaApproval->created_at))}}
1	Offer Letter Signed Copy	Uploaded	{{$user_name->name}}	Candidate	{{date('d M, Y', strtotime($sign_doc->doc_upload_date))}}
1	Offer Letter	@if($offer_letter_status->status == 1) Accepted @else Rejected @endif	Candidate	{{date('d M, Y', strtotime($offer_letter_status->updated_at))}}