public function applications_suspended()
{
$results = CandidateInfo::join('candidates', 'candidate_infos.candidate_id', '=', 'candidates.id')->where('candidates.verified_status', 'Halted')->select('candidates.id', 'candidate_infos.fullname', 'candidate_infos.index_card_no as index_card_no', 'candidate_infos.sex as sex', 'candidate_infos.address as address')->get();
return view($this->content . 'applications.suspended', compact('results'));
}
public function applications_recieved()
{
$results = CandidateInfo::join('candidates', 'candidate_infos.candidate_id', '=', 'candidates.id')->where('candidates.verified_status', 'Not Verified')->where('candidate_infos.index_card_no', '!=', 'NULL')->orWhere('candidate_infos.index_card_no', '!=', '')->get();
return view($this->content . 'applications.recieved', compact('results'));
}
