public function viewCandidateProfile($candidate_id)
{
//Hashids::getDefaultConnection();
$decoded = Hashids::decode($candidate_id);
//return count($decoded);
//code for displaying full profle with bio, educations detals, experience details and so
$candidate = Candidate::find($decoded)->first();
//return $candidate;
$info = CandidateInfo::where('candidate_id', $decoded)->first();
//$edu = CandidateEduDetails::where('candidate_id', $decoded)->get();
$edu = CandidateEduDetails::where('candidate_id', $decoded)->join('master_exams', 'candidate_edu_details.exam_id', '=', 'master_exams.id')->join('master_boards', 'candidate_edu_details.board_id', '=', 'master_boards.id')->join('master_subjects', 'candidate_edu_details.subject_id', '=', 'master_subjects.id')->select('master_exams.name as exam_name', 'master_exams.exam_category', 'candidate_edu_details.specialization', 'candidate_edu_details.pass_year', 'candidate_edu_details.percentage', 'master_boards.name as board_name', 'master_subjects.name as subject_name')->get();
//::join('candidates', 'candidate_infos.candidate_id', '=', 'candidates.id')
$lang = CandidateLanguageInfo::where('candidate_id', $decoded)->get();
$exp = CandidateExpDetails::where('candidate_id', $decoded)->join('master_industry_types', 'candidate_experience_details.industry_id', '=', 'master_industry_types.id')->join('master_subjects', 'candidate_experience_details.experience_id', '=', 'master_subjects.id')->select('master_subjects.name as exp_type', 'master_industry_types.name as sector', 'candidate_experience_details.post_held', 'candidate_experience_details.year_experience', 'candidate_experience_details.salary', 'candidate_experience_details.employers_name')->orderBy('candidate_experience_details.id', 'DESC')->get();
return view('admin.applications.profile', compact('candidate', 'info', 'edu', 'lang', 'exp'));
}
public static function check_candidate($id)
{
$candidate = Candidate::find($id);
$info = CandidateInfo::where('candidate_id', $id)->count();
$edu = CandidateEduDetails::where('candidate_id', $id)->count();
$lang = CandidateLanguageInfo::where('candidate_id', $id)->count();
if ($info == 0 || $edu == 0 || $lang == 0) {
return false;
} else {
return true;
}
}
