Complete Candidate Details

Candidate Basic Info
@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}} ViewCandidate {{$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 UploadedCandidate {{$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 eVisaApprovedRejected{{@$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))}}