public function indexAction($offset = 0)
{
$query = $this->input->get('q');
$jobs = new \modules\classfied\models\Classfied_jobs();
$jobs->like('classfied_jobs.title', $query);
$jobs->is_active = 1;
$jobs->_select = 'classfied_jobs.classfied_job_id, classfied_jobs.title, classfied_jobs.created_on, classfied_jobs.company, `classfied_countries`.`image` as country_image, `locations`.`image` as location_image, `locations`.`name` as location_name, `classfied_countries`.`name` as country_name,`classfied_types`.`name` as type, `classfied_types`.`color`, (SELECT COUNT(*) FROM classfied_job_applications WHERE classfied_job_applications.classfied_job_id = classfied_jobs.classfied_job_id) as appicants';
$jobs->_joins = ['classfied_countries' => ['`classfied_countries`.`classfied_country_id`=`classfied_jobs`.`classfied_country_id`', 'left'], 'classfied_countries` `locations' => ['`locations`.`classfied_country_id`=`classfied_jobs`.`classfied_country_id`', 'left'], 'classfied_types' => ['`classfied_types`.`classfied_type_id`=`classfied_jobs`.`classfied_type_id`', 'left']];
$jobs->_order_by['classfied_jobs.classfied_job_id'] = 'DESC';
$this->load->library('pagination');
$jobs->_limit = $this->config->get('limit');
$jobs->_offset = $offset;
return $this->render('classfied_search', ['query' => $query, 'jobs' => $jobs->get(), 'pagination' => $this->pagination->generate(['url' => Uri_helper::url('classfied_search/index/'), 'postfix_url' => '?' . http_build_query($_GET), 'total' => $jobs->get(true), 'limit' => $jobs->_limit, 'offset' => $jobs->_offset])]);
}
