$county_name = empty($county) ? $jobs->county : $county->name;
$county_var_name = $county ? $county->var_name : $jobs->county;
$smarty->assign('county', $county_name);
$smarty->assign('county_url', $country_var_name . "/" . $state_var_name . "/" . $county_var_name . "/");
$city = City::find_by_code($jobs->country, $jobs->state_province, $jobs->county, $jobs->city);
$city_name = empty($city) ? $jobs->city : $city->name;
$city_var_name = empty($city) ? $jobs->city : $city->var_name;
$smarty->assign('city', $city_name);
$smarty->assign('city_url', $country_var_name . "/" . $state_var_name . "/" . $county_var_name . "/" . $city_var_name . "/");
//educations
$educations = Education::find_by_id($jobs->fk_education_id);
$education_name = !empty($educations) ? $educations->education_name : format_lang('not_provided');
$smarty->assign('education_var_name', $educations->var_name);
$smarty->assign('education', $education_name);
//career
$careers = CareerDegree::find_by_id($jobs->fk_career_id);
$smarty->assign('careers', $careers);
$career_name = $careers ? $careers->career_name : format_lang('not_provided');
$smarty->assign('career_var_name', $careers->var_name);
$smarty->assign('career', $career_name);
//experience
$experiences = Experience::find_by_id($jobs->fk_experience_id);
$smarty->assign('experiences', $experiences);
$experience_name = !empty($experiences) ? $experiences->experience_name : format_lang('not_provided');
$smarty->assign('experience_var_name', $experiences->var_name);
$smarty->assign('experience', $experience_name);
$smarty->assign('spotlight', $jobs->spotlight);
if (!empty($jobs->job_salary) && !empty($jobs->salaryfreq)) {
$job_salary = $jobs->job_salary . format_lang('per') . $jobs->salaryfreq;
} else {
$job_salary = format_lang('not_provided');
}
}
//city
$_SESSION['loc']['citycode'] = $_SESSION['loc']['citycode'] != '' ? $_SESSION['loc']['citycode'] : "";
}
}
//end of location
$educations = Education::find_all();
if (is_array($educations) and !empty($educations)) {
$education_t = array();
foreach ($educations as $education) {
$education_t[$education->id] = $education->education_name;
}
$smarty->assign('education', $education_t);
}
$careers = CareerDegree::find_all();
if (is_array($careers) and !empty($careers)) {
$career_t = array();
foreach ($careers as $career) {
$career_t[$career->id] = $career->career_name;
}
$smarty->assign('career', $career_t);
}
$experiences = Experience::find_all();
if (is_array($experiences) and !empty($experiences)) {
$experience_t = array();
foreach ($experiences as $experience) {
$experience_t[$experience->id] = $experience->experience_name;
}
$smarty->assign('experience', $experience_t);
}
$str_date_d = date("d", strtotime($cv_details->start_date));
$str_date_m = date("m", strtotime($cv_details->start_date));
$str_date_y = date("Y", strtotime($cv_details->start_date));
$smarty->assign('str_date', strftime(DATE_FORMAT, strtotime($str_date)));
}
$position = $cv_details->positions;
$smarty->assign('position', $position);
//recent job details
$rjt = $cv_details->recent_job_title;
$smarty->assign('rjt', $rjt);
$re = $cv_details->recent_employer;
$smarty->assign('re', $re);
$categories = Category::find_by_id($cv_details->recent_industry_work);
$riw = $categories ? $categories->cat_name : format_lang('none');
$smarty->assign('riw', $riw);
$careers = CareerDegree::find_by_id($cv_details->recent_career_level);
$rcl = $careers ? $careers->career_name : format_lang('none');
$smarty->assign('careers', $rcl);
//what are you looking for
$ljt = $cv_details->look_job_title;
$smarty->assign('ljt', $ljt);
$ljt2 = $cv_details->look_job_title2;
$smarty->assign('ljt2', $ljt2);
$sql = " SELECT * FROM " . TBL_CV_CAT . " WHERE cv_id=" . $id;
$cv_cat = $db->query($sql);
$cv_cat_array = array();
while ($row = $db->fetch_object($cv_cat)) {
$categories = Category::find_by_id($row->category_id);
$cv_cat_array[] = $categories->cat_name;
}
$smarty->assign('li', join("<br />", $cv_cat_array));
}
}
if (isset($_GET['action']) && $_GET['action'] == "delete" && isset($_GET['id'])) {
$career_degree = new CareerDegree();
$career_degree->id = (int) $_GET['id'];
if ($career_degree->delete()) {
$session->message("CareerDegree deleted ");
redirect_to($_SERVER['PHP_SELF'] . "?#" . $_GET['id']);
die;
} else {
$message = join("<br />", $career_degree->errors);
}
}
if (isset($_GET['action']) && $_GET['action'] == "add") {
if (isset($_POST['bt_add'])) {
$add_new = new CareerDegree();
$add_new->career_name = $_POST['txt_career_name'];
$add_new->var_name = $add_new->mod_write_check($_POST['txt_career_name']);
$add_new->is_active = $_POST['txt_is_active'];
if ($add_new->save()) {
$session->message("New Career Degree added.");
redirect_to($_SERVER['PHP_SELF']);
die;
} else {
$message = join("<br />", $add_new->errors);
}
}
}
$delete_message = "Are you sure you wont to delete this CareerDegree name";
$career_degree = CareerDegree::find_all();
$manage_lists = array();
$str_date = strftime(DATE_FORMAT, strtotime($str_date));
}
$smarty->assign('str_date', $str_date);
$position = $cv_details->positions;
$smarty->assign('position', $position);
//recent job details
$rjt = $cv_details->recent_job_title;
$smarty->assign('rjt', $rjt);
$re = $cv_details->recent_employer;
$smarty->assign('re', $re);
$cat = empty($cv_details->recent_industry_work) ? 0 : $cv_details->recent_industry_work;
$categories = Category::find_by_id($cat);
$riw = $categories ? $categories->cat_name : format_lang('none');
$smarty->assign('riw', $riw);
$cl = empty($cv_details->recent_career_level) ? 0 : $cv_details->recent_career_level;
$careers = CareerDegree::find_by_id($cl);
$rcl = $careers ? $careers->career_name : format_lang('none');
$smarty->assign('careers', $rcl);
//what are you looking for
$ljt = $cv_details->look_job_title;
$smarty->assign('ljt', $ljt);
$ljt2 = $cv_details->look_job_title2;
$smarty->assign('ljt2', $ljt2);
$sql = " SELECT * FROM " . TBL_CV_CAT . " WHERE cv_id=" . $id;
$cv_cat = $db->query($sql);
$cv_cat_array = array();
while ($row = $db->fetch_object($cv_cat)) {
$categories = Category::find_by_id($row->category_id);
$cv_cat_array[] = $categories->cat_name;
}
$smarty->assign('li', join("<br />", $cv_cat_array));
