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