function classfied() { $cat_model = new \modules\classfied\models\Classfied_categories(); $cat_model->_select = "classfied_categories.*, (SELECT COUNT(*) FROM classfied_jobs WHERE classfied_jobs.classfied_category_id = classfied_categories.classfied_category_id) AS total_vacancies "; $cat_model->_order_by['category_order'] = 'ASC'; $country = new \modules\classfied\models\Classfied_countries(); $country->_select = "classfied_countries.*, (SELECT COUNT(*) FROM classfied_jobs WHERE classfied_jobs.classfied_country_id = classfied_countries.classfied_country_id) AS total_vacancies "; return ['categories' => $cat_model->get(), 'countries' => $country->get()]; }
public function manageAction($id = false) { $this->permission('manage'); if ($id) { $classfied = new \modules\classfied\models\Classfied_countries('edit'); $classfied->classfied_country_id = $id; } else { $classfied = new \modules\classfied\models\Classfied_countries('add'); } $classfied->set('name', $this->input->post('name')); if ($classfied->save()) { Uri_helper::redirect("management/classfied_countries"); } else { return $this->render('classfied_countries/manage', array('item' => $id ? $classfied->get() : null)); } }