public function getAppliedJobs($user_id, $status_id, $job_ids = [], $with_banned_jobs = false)
{
try {
$applied_jobs = CompanyApplyJob::with('job_details', 'job_details.company', 'user_details')->where('user_id', '=', $user_id)->where('status', '=', $status_id);
if ($with_banned_jobs) {
$applied_jobs->whereNotIn('job_id', $job_ids);
}
return $applied_jobs->get()->toArray();
} catch (Exception $e) {
return Response::json(['error' => $e->getMessage()]);
}
}
public function getJobApplicantById($applicant_id)
{
try {
return CompanyApplyJob::with(['job_details', 'job_details.company', 'job_details.job_skills', 'job_details.job_skills.skill', 'user_details', 'user_details.skills', 'user_details.skills.skill', 'user_details.jobs' => function ($query) {
$query->orderBy('work_to', 'desc');
}, 'user_details.jobs.documents', 'user_details.jobs.documents.file', 'user_details.studies' => function ($query) {
$query->orderBy('study_to', 'desc');
}, 'user_details.studies.documents', 'user_details.studies.documents.file', 'user_details.profile_image_detail', 'user_details.profile_cover_detail'])->where('id', '=', $applicant_id)->first()->toArray();
} catch (Exception $e) {
return Response::json(['error' => $e->getMessage()]);
}
}
