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')); }