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