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])]); }
public function indexAction($id, $offset = 0) { $category = new \modules\classfied\models\Classfied_categories(); $jobs = new \modules\classfied\models\Classfied_jobs(); $category->classfied_category_id = $id; $jobs->classfied_category_id = $id; $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_category', ['item' => $category->get(), 'jobs' => $jobs->get(), 'pagination' => $this->Pagination->generate(['url' => Uri_helper::url('classfied_category/index/' . $id), 'total' => $jobs->get(true), 'limit' => $jobs->_limit, 'offset' => $jobs->_offset])]); }
public function indexAction() { $jobs = new \modules\classfied\models\Classfied_jobs(); $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'; $jobs->_limit = 6; $jobs->spotlight = 1; $spotlighted = $jobs->get(); $jobs->spotlight = null; // $jobs = new \modules\classfied\models\Classfied_jobs(); // $jobs->is_active = 1; // $jobs->_select = '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'; // $jobs->_limit = 6; $latest_added = $jobs->get(); // $jobs = new \modules\classfied\models\Classfied_jobs(); // $jobs->is_active = 1; // $jobs->_select = '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 = null; $jobs->_order_by['(SELECT COUNT(*) FROM classfied_job_applications WHERE classfied_job_applications.classfied_job_id = classfied_jobs.classfied_job_id)'] = 'DESC'; // $jobs->_limit = 6; $most_applied = $jobs->get(); return $this->render('classfied_home', ['spotlighted' => $spotlighted, 'latest_added' => $latest_added, 'most_applied' => $most_applied]); }
public function indexAction() { $model = new \modules\classfied\models\Classfied_jobs(); $model->set('classfied_type_id', $this->input->post('classfied_type_id')); $model->set('classfied_category_id', $this->input->post('classfied_category_id')); $model->set('title', $this->input->post('title')); $model->set('description', $this->input->post('description')); $model->set('company', $this->input->post('company')); $model->set('classfied_city_id', $this->input->post('classfied_city_id')); $model->set('classfied_area_id', $this->input->post('classfied_area_id')); $model->set('classfied_country_id', $this->input->post('classfied_country_id')); $model->set('url', $this->input->post('url')); $model->set('poster_email', $this->input->post('poster_email')); $model->set('salary_from', $this->input->post('salary_from')); $model->set('salary_to', $this->input->post('salary_to')); $model->set('classfied_currency_id', $this->input->post('classfied_currency_id')); $model->set('is_hidden_num', $this->input->post('is_hidden_num') ? 1 : 0); $model->set('phone_num', $this->input->post('phone_num')); $model->set('classfied_experience_id', $this->input->post('classfied_experience_id')); $model->set('candidate_location', $this->input->post('candidate_location')); $categories = Form_helper::queryToDropdown('classfied_categories', 'classfied_category_id', 'name'); $types = Form_helper::queryToDropdown('classfied_types', 'classfied_type_id', 'name'); // $cities = Form_helper::queryToDropdown('classfied_cities', 'classfied_city_id', 'name'); $cities = ['' => $this->language->phrase('select_city')]; $experiences = Form_helper::queryToDropdown('classfied_experience', 'classfied_experience_id', 'name'); $currenies = Form_helper::queryToDropdown('classfied_currencies', 'classfied_currency_id', 'name', ['' => $this->language->phrase('select_currency')]); // $areas = Form_helper::queryToDropdown('classfied_areas', 'classfied_area_id', 'name'); $areas = ['' => $this->language->phrase('select_area')]; $countries = Form_helper::queryToDropdown('classfied_countries', 'classfied_country_id', 'name', ['' => $this->language->phrase('select_country')]); if ($model->validate()) { if ($this->input->post('confirm') == 1) { $model->set('classfied_type_id', $this->input->post('classfied_type_id')); $model->set('classfied_category_id', $this->input->post('classfied_category_id')); $model->set('title', $this->input->post('title')); $model->set('description', $this->input->post('description')); $model->set('company', $this->input->post('company')); $model->set('classfied_city_id', $this->input->post('classfied_city_id')); $model->set('classfied_country_id', $this->input->post('classfied_country_id')); $model->set('classfied_area_id', $this->input->post('classfied_area_id')); $model->set('url', $this->input->post('url')); $model->set('poster_email', $this->input->post('poster_email')); $model->set('salary_from', $this->input->post('salary_from')); $model->set('salary_to', $this->input->post('salary_to')); $model->set('classfied_currency_id', $this->input->post('classfied_currency_id')); $model->set('is_hidden_num', $this->input->post('is_hidden_num')); $model->set('phone_num', $this->input->post('phone_num')); $model->set('classfied_experience_id', $this->input->post('classfied_experience_id')); $model->set('candidate_location', $this->input->post('candidate_location')); $model->set('created_on', date("Y-m-d")); if ($model->save()) { return $this->render('classfied_thankyou'); } else { return Brightery::error404(); } } $categories = $categories[$this->input->post('classfied_category_id')]; $types = $types[$this->input->post('classfied_type_id')]; $experiences = $experiences[$this->input->post('classfied_experience_id')]; $currenies = $currenies[$this->input->post('classfied_currency_id')]; $cities = Form_helper::queryToDropdown('classfied_cities', 'classfied_city_id', 'name', null, 'WHERE classfied_city_id= "' . $this->input->post('classfied_city_id') . '"')[$this->input->post('classfied_city_id')]; $areas = Form_helper::queryToDropdown('classfied_areas', 'classfied_area_id', 'name', null, 'WHERE classfied_area_id= "' . $this->input->post('classfied_area_id') . '"')[$this->input->post('classfied_area_id')]; $countries = $countries[$this->input->post('classfied_country_id')]; // $candidate = Form_helper::queryToDropdown('countries', 'classfied_country_id', 'name', null, 'WHERE classfied_country_id= "' . $this->input->post('condidate_location') . '"')[$this->input->post('condidate_location')]; return $this->render('classfied_review_job', ['categories' => $categories, 'cities' => $cities, 'types' => $types, 'experiences' => $experiences, 'currenies' => $currenies, 'areas' => $areas, 'countries' => $countries]); } else { return $this->render('classfied_post_job', ['categories' => $categories, 'cities' => $cities, 'types' => $types, 'experiences' => $experiences, 'currenies' => $currenies, 'areas' => $areas, 'countries' => $countries]); } }
public function approveAction($id = false) { if (!$id) { return Brightery::error404(); } echo 'iuui'; $classfied = new \modules\classfied\models\Classfied_jobs(null); $classfied->where('classfied_job_id', $id); $classfied->set('is_active', '1'); if ($classfied->save()) { Uri_helper::redirect("management/classfied_jobs"); } }