/** * * @param type $reqid * @return type */ public function requisitionhistoryreportdetail_CVManagementGrid($reqid) { $sort_order = 'DESC'; $sort_field = 'c.uploadedon'; $perPage = 100; $pageNo = 1; $searchData = ''; $where = ''; $searchQuery = 'c.requisition_id = ' . $reqid; $searchArray = array(); $data = array(); $tableFields = array('candidate_name' => 'Candidate Name', 'cand_resume' => 'Resume', 'shortlisted_status' => 'CV-Shortlisted Status', 'cand_status' => 'Candidate Status', 'createdby' => 'Uploaded By', 'createdon' => 'Uploaded On', 'shortlistedby' => 'Shortlisted By', 'shortlistedon' => 'Shortlisted On'); $cand_model = new Default_Model_Candidatedetails(); $tablecontent = $cand_model->getCandidatesHistory($sort_order, $sort_field, $pageNo, $perPage, $searchQuery); $dataTmp = array('sort' => $sort_order, 'by' => $sort_field, 'pageNo' => $pageNo, 'perPage' => $perPage, 'tablecontent' => $tablecontent, 'tableheader' => $tableFields); return $dataTmp; }