Uploaded Document
|
S. No |
Document Type |
Title |
File |
Uploaded By |
Uploaded At |
@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)
{{$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))}} |
@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)
{{$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))}} |
@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)
{{$loop->iteration}} |
LC/MOL Signed Copy |
{{$LcMolDoc->title}} |
View |
@if($LcMolDoc->created_by == 'candidate')
Candidate |
@else
@php $user_name = App\Models\User::where('id', $LcMolDoc->created_by)->select('name')->first(); @endphp
{{$user_name->name}} |
@endif
{{date('d M, Y', strtotime($LcMolDoc->created_at))}} |
@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)
{{$loop->iteration}} |
LC/MOL 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))}} |
@endforeach @endif
@if(!empty($getRequiredDoc)) @foreach($getRequiredDoc as $requiredDoc)
{{$loop->iteration}} |
@php $doc = App\Models\DocumentMaster::where('id', $requiredDoc->document_id)->select('document_title')->first(); @endphp
{{@$doc->document_title}} |
{{$requiredDoc->document_title}} |
View |
@if($requiredDoc->created_by == 'HR')
@php $user_name = App\Models\User::where('id', $requiredDoc->organisation_id)->select('name')->first(); @endphp
{{$user_name->name}} |
@else
Candidate |
@endif
{{date('d M, Y', strtotime($requiredDoc->doc_upload_date))}} |
@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)
{{$loop->iteration}} |
Offer Letter |
{{$value}} |
@foreach ($document_file as $key1 => $value1)
@if($key1 == $key)
View
@endif
@endforeach
|
@php $user_name = App\Models\User::where('id', $results_data->organisation_id)->select('name')->first(); @endphp
{{$user_name->name}} |
{{date('d M, Y', strtotime($results_data->created_at))}} |
@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))
# |
Resume |
|
View |
{{$results_data1->manager_name}} |
{{date('d M, Y', strtotime($results_data1->created_at))}} |
@endif
Status History
|
S No. |
Process |
Status |
By |
Date |
@php
$SendProLcMol = App\Models\EidDocument::where('candidate_id', $candidate_id)->select('created_by', 'created_at')->orderBy('id', 'desc')->first(); @endphp
@if(!empty($SendProLcMol))
1 |
EID Document |
Uploaded |
@php $user_name = App\Models\User::where('id', $SendProLcMol->created_by)->select('name')->first();@endphp
{{$user_name->name}} |
{{date('d M, Y', strtotime($SendProLcMol->created_at))}} |
@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))
1 |
EID Process |
Sent To PRO |
@php $user_name = App\Models\User::where('id', $SendProLcMol->request_send_by)->select('name')->first();@endphp
{{$user_name->name}} |
{{date('d M, Y', strtotime($SendProLcMol->created_at))}} |
@endif
@php $SendProLcMol = App\Models\MedicalReport::where('candidate_id', $candidate_id)->select('created_by', 'created_at')->orderBy('id', 'desc')->first(); @endphp
@if(!empty($SendProLcMol))
1 |
Medical Reports |
Uploaded |
@php $user_name = App\Models\User::where('id', $SendProLcMol->created_by)->select('name')->first();@endphp
{{$user_name->name}} |
{{date('d M, Y', strtotime($SendProLcMol->created_at))}} |
@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))
1 |
Medical Test Appointment
Date: {{date('d M, Y, H:i', strtotime($SendProLcMol->appointment_time))}}
Place: {{$SendProLcMol->place}} |
Sent |
@php $user_name = App\Models\User::where('id', $SendProLcMol->created_by)->select('name')->first();@endphp
{{$user_name->name}} |
{{date('d M, Y', strtotime($SendProLcMol->created_at))}} |
@endif
@php $SendProLcMol = App\Models\VisaDocument::where('candidate_id', $candidate_id)->select('created_by', 'created_at')->orderBy('id', 'desc')->first(); @endphp
@if(!empty($SendProLcMol))
1 |
eVisa Documents |
Uploaded |
@php $user_name = App\Models\User::where('id', $SendProLcMol->created_by)->select('name')->first();@endphp
{{$user_name->name}} |
{{date('d M, Y', strtotime($SendProLcMol->created_at))}} |
@endif
@php $SendProLcMol = App\Models\SendProEvisaProcessing::where('candidate_id', $candidate_id)->select('created_by', 'created_at')->orderBy('id', 'desc')->first();@endphp
@if(!empty($SendProLcMol))
1 |
Sent PRO to eVisa Processing |
Sent |
@php $user_name = App\Models\User::where('id', $SendProLcMol->created_by)->select('name')->first();@endphp
{{$user_name->name}} |
{{date('d M, Y', strtotime($SendProLcMol->created_at))}} |
@endif
@php $SendProLcMol = App\Models\SignedLcMolDoc::where('candidate_id', $candidate_id)->select('created_by', 'created_at')->orderBy('id', 'desc')->first();@endphp
@if(!empty($SendProLcMol))
1 |
LC/MOL signed copy |
Uploaded |
@if($SendProLcMol->created_by == 'candidate')
Candidate |
@else
@php $user_name = App\Models\User::where('id', $SendProLcMol->created_by)->select('name')->first();@endphp
{{$user_name->name}} |
@endif
{{date('d M, Y', strtotime($SendProLcMol->created_at))}} |
@endif
@php $SendProLcMol = App\Models\LcMolDoc::where('candidate_id', $candidate_id)->select('created_by', 'created_at')->orderBy('id', 'desc')->first(); @endphp
@if(!empty($SendProLcMol))
1 |
LC/MOL documents |
Uploaded |
@php $user_name = App\Models\User::where('id', $SendProLcMol->created_by)->select('name')->first();@endphp
{{$user_name->name}} |
{{date('d M, Y', strtotime($SendProLcMol->created_at))}} |
@endif
@php $SendProLcMol = App\Models\SendProLcMol::where('candidate_id', $candidate_id)->select('request_send_by', 'created_at')->first(); @endphp
@if(!empty($SendProLcMol))
1 |
Sent for LC/MOL process |
Sent |
@php $user_name = App\Models\User::where('id', $SendProLcMol->request_send_by)->select('name')->first();@endphp
{{$user_name->name}} |
{{date('d M, Y', strtotime($SendProLcMol->created_at))}} |
@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))
1 |
eVisa |
@if($SendVisaApproval->visa_approved_reject_status == 1)
Approved |
@else
Rejected |
@endif
@php $user_name = App\Models\User::where('id', $SendVisaApproval->manager_id)->select('name')->first();@endphp
{{@$user_name->name}} |
@if($SendVisaApproval->visa_approved_reject_status == 1)
{{date('d M, Y', strtotime($SendVisaApproval->visa_approved_date))}} |
@else
{{date('d M, Y', strtotime($SendVisaApproval->visa_rejected_date))}} |
@endif
@endif
@php $SendVisaApproval = App\Models\SendVisaApproval::where('candidate_id', $candidate_id)->select('organisation_id', 'created_at')->first(); @endphp
@if(!empty($SendVisaApproval))
1 |
Sent for eVisa approvals |
Sent |
@php $user_name = App\Models\User::where('id', $SendVisaApproval->organisation_id)->select('name')->first();@endphp
{{$user_name->name}} |
{{date('d M, Y', strtotime($SendVisaApproval->created_at))}} |
@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))
1 |
Offer Letter Signed Copy |
Uploaded |
@if($sign_doc->created_by == 'HR')
@php $user_name = App\Models\User::where('id', $sign_doc->organisation_id)->select('name')->first();@endphp
{{$user_name->name}} |
@else
Candidate |
@endif
{{date('d M, Y', strtotime($sign_doc->doc_upload_date))}} |
@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)
1 |
Offer Letter |
@if($offer_letter_status->status == 1) Accepted
@else Rejected @endif |
Candidate |
{{date('d M, Y', strtotime($offer_letter_status->updated_at))}} |
@endif @endif