function getCitiesByCountry($country_id = 1000) { $combosModel = new combosModel(); $cities = $combosModel->get_all_city($country_id); echo "\n \t<select id='cmb_city' name='cmb_city'>\n \t"; foreach ($cities as $city) { $city_id = $city[0]; if ($lang == 'ar') { $city_name = $city[2]; } else { $city_name = $city[1]; } echo "<option value='{$city_id}' >{$city_name}</option>"; } echo "</select>"; exit; }
public function edit() { //$id=$_SESSION['company']['id']; $id = 1; $companyModel = new companyModel(); $current_company = $companyModel->get_by_id($id); //$companys = $companyModel->get_all(); $combosModel = new combosModel(); $company_types = $combosModel->get_all_company_type(); $combosModel = new combosModel(); $countrys = $combosModel->get_all_country(); $combosModel = new combosModel(); $cities = $combosModel->get_all_city(1000); $combosModel = new combosModel(); $titles = $combosModel->get_all_title(); $business_fieldModel = new business_fieldModel(); $business_fields = $business_fieldModel->get_all(); $view = new viewModel('company_account'); $view->assign('company_types', $company_types); $view->assign('countrys', $countrys); $city_id = $_POST['cmb_city']; $view->assign('titles', $titles); $view->assign('business_fields', $business_fields); $view->assign('current_company', $current_company); //$view->assign('companys',$companys); }
public function admin_search() { if (isset($_POST['smt_search'])) { $keyword = $_POST['txt_text']; $business_field_id = $_POST['cmb_business_field']; $job_type_id = $_POST['cmb_job_type']; $country_id = $_POST['cmb_country']; $location = $_POST['txt_location']; $salary_from = $_POST['txt_salary_from']; $salary_to = $_POST['txt_salary_to']; $salary_currency_id = $_POST['cmb_salary_currency']; $gender_id = $_POST['cmb_gender']; $position_id = $_POST['cmb_position']; $where = '1=1'; if ($keyword != '') { $where = $where . " and (`jobs`.`name` like '%{$keyword}%' or `jobs`.`description` like '%{$keyword}%' or `jobs`.`computer_skills` like '%{$keyword}%' ) "; } if ($business_field_id != '1') { $where = $where . " and `jobs`.`business_field_id`='{$business_field_id}' "; } if ($job_type_id != '1') { $where = $where . " and `jobs`.`job_type_id`='{$job_type_id}' "; } if ($country_id != '1000') { $where = $where . " and `jobs`.`country_id`='{$country_id}' "; } if ($location != '') { $where = $where . " and `jobs`.`location` like '%{$location}%' "; } if ($salary_from != '') { $where = $where . " and `jobs`.`salary_from` >= {$salary_from} and `jobs`.`salary_currency_id`='{$salary_currency_id}' "; } if ($salary_to != '') { $where = $where . " and `jobs`.`salary_to` <= {$salary_to} and `jobs`.`salary_currency_id`='{$salary_currency_id}'"; } if ($gender_id != '1') { $where = $where . " and `jobs`.`gender_id`='{$gender_id}' "; } if ($position_id != '1') { $where = $where . " and `jobs`.`position_id`='{$position_id}' "; } $jobsModel = new jobsModel(); $search_jobs = $jobsModel->get_by_condition($where); $view = new viewModel('admin/job_search'); $view->assign('search_jobs', $search_jobs); } else { $companyModel = new companyModel(); $companys = $companyModel->get_all(); $business_fieldModel = new business_fieldModel(); $business_fields = $business_fieldModel->get_all(); $combosModel = new combosModel(); $countrys = $combosModel->get_all_country(); $combosModel = new combosModel(); $cities = $combosModel->get_all_city(1000); $combosModel = new combosModel(); $job_types = $combosModel->get_all_job_type(); $combosModel = new combosModel(); $currencys = $combosModel->get_all_currency(); $combosModel = new combosModel(); $grades = $combosModel->get_all_grade(); $combosModel = new combosModel(); $genders = $combosModel->get_all_gender(); $combosModel = new combosModel(); $positions = $combosModel->get_all_position(); $view = new viewModel('admin/job_search'); $view->assign('companys', $companys); $view->assign('business_fields', $business_fields); $view->assign('countrys', $countrys); $view->assign('cities', $cities); $view->assign('job_types', $job_types); $view->assign('currencys', $currencys); $view->assign('grades', $grades); $view->assign('genders', $genders); $view->assign('positions', $positions); } }