<?php
require_once "../initialise_files.php";
include_once "sessioninc.php";
$smarty->assign('action', $_GET['action']);
$smarty->assign('id', (int) $_GET['id']);
if (isset($_GET['action']) && $_GET['action'] == "edit" && isset($_GET['id'])) {
$id = (int) $_GET['id'];
$jt_name = JobStatus::find_by_id($id);
$jt_name2 = $jt_name->status_name;
$smarty->assign('jt_name2', $jt_name2);
$smarty->assign('is_active', $jt_name->is_active);
if (isset($_GET['bt_update'])) {
$job_status = new JobStatus();
$job_status->id = (int) $_GET['id'];
$job_status->status_name = $_GET['txt_name'];
$job_status->is_active = $_GET['txt_active'];
$job_status->var_name = $jt_name->mod_write_check($_GET['txt_name'], $jt_name->var_name);
if ($job_status->save()) {
$session->message("Job Status updated ");
redirect_to($_SERVER['PHP_SELF'] . "?#" . $_GET['id']);
die;
} else {
$message = join("<br />", $job_status->errors);
}
}
}
if (isset($_GET['action']) && $_GET['action'] == "delete" && isset($_GET['id'])) {
$job_status = new JobStatus();
$job_status->id = (int) $_GET['id'];
if ($job_status->delete()) {
//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));
//job states
$js = empty($cv_details->look_job_status) ? 0 : $cv_details->look_job_status;
$job_status = JobStatus::find_by_id($js);
$ljs = $job_status ? $job_status->status_name : format_lang('none');
$smarty->assign('ljs', $ljs);
//job type
$job_t = empty($cv_details->look_job_type) ? 0 : $cv_details->look_job_type;
$job_type_arr = JobType::find_by_id($job_t);
//print_r( $job_type_arr);
$job_types = $job_type_arr ? $job_type_arr->type_name : format_lang('none');
$smarty->assign('job_type', $job_types);
//where do you wont to work
//country
$country_arry = Country::find_by_code($cv_details->country);
$country_var_name = $country_arry->var_name;
$country_name = $country_arry->name;
$smarty->assign('country', $country_name);
//states
$sql = $select . $from . $where . $group_by . $order . $limit;
//echo $sql;
$result = $db->query($sql);
$num_rows = $db->num_rows($result);
if ($num_rows > 0) {
$manage_list = array();
$i = 1;
while ($rows = $db->fetch_object($result)) {
$employee = Employee::find_by_id($rows->fk_employee_id);
$manage_list[$i]['id'] = $rows->id;
$manage_list[$i]['employee_name'] = $employee->full_name();
$manage_list[$i]['employee_id'] = $rows->fk_employee_id;
$manage_list[$i]['cv_title'] = $rows->cv_title;
$manage_list[$i]['look_job_title'] = $rows->look_job_title;
$manage_list[$i]['look_job_title2'] = $rows->look_job_title2;
$status = JobStatus::find_by_id($rows->look_job_status);
$status_name = $status->status_name;
$manage_list[$i]['look_job_status'] = $status_name;
$manage_list[$i]['recent_job_title'] = $rows->recent_job_title;
//$manage_list[$i]['city']= $rows->city;
$manage_list[$i]['modified_at'] = strftime(DATE_FORMAT, strtotime($rows->modified_at));
//locations
//country
$country_arry = Country::find_by_code($rows->country);
$country_var_name = $country_arry->var_name;
$country_name = $country_arry->name;
//states
$state = StateProvince::find_by_code($rows->country, $rows->state_province);
$state_name = empty($state) ? $rows->state_province : $state->name;
//county
$county = County::find_by_code($rows->country, $rows->state_province, $rows->county);
