}
//add job to database
if ($job->save()) {
$new_job_id = $db->insert_id();
$jobcategory = new JobCategory();
######## GET CAT ID ###############
$jobcategory->job_id = (int) $job_id;
$cats = $jobcategory->get_cat_by_job_id();
foreach ($cats as $t) {
$cat_added = JobCategory::make($t->category_id, $new_job_id);
$cat_added->save();
}
################# JOB TYPE ##################
$job_type_ns = Job2Type::find_all_type_by_jobid($job_id);
foreach ($job_type_ns as $job_type) {
$type_added = new Job2Type();
$type_added->fk_job_id = (int) $new_job_id;
$type_added->fk_job_type_id = (int) $job_type->fk_job_type_id;
$type_added->save();
}
########## job_statu_id #######################
$job_statu_ns = Job2Status::find_by_job_id($job_id);
foreach ($job_statu_ns as $job_statuss) {
$status_added = Job2Status::make($new_job_id, $job_statuss->fk_job_status_id);
$status_added->save();
}
} else {
$session->message("Error cloning this job " . $db->mysql_db_error());
}
//update they job value
if (FREE_SITE == "N" || FREE_SITE == "0" || FREE_SITE == false) {
<?php
$job = new Job();
$job2type = new Job2Type();
$req = return_url();
$var_name = $req[1];
$jobs = $job->find_by_var_name($var_name);
$job_id = (int) $jobs->id;
if ($jobs && !empty($jobs)) {
$html_title = SITE_NAME . " - " . $jobs->job_title;
$meta_description = seo_words(subtrack_string($jobs->job_description, 250));
$meta_keywords = seo_words(subtrack_string($jobs->job_description, 150));
$id = (int) $jobs->id;
$jobs->update_views();
//job type
$type = Job2Type::find_all_type_by_jobid($id);
$type2 = array();
$i = 1;
foreach ($type as $job_type) {
$type_name = JobType::find_by_id($job_type->fk_job_type_id);
$type2[$i]['name'] = $type_name->type_name;
$type2[$i]['var_name'] = $type_name->var_name;
$i++;
}
$smarty->assign('jobtype', $type2);
$smarty->assign('var_name', $jobs->var_name);
$smarty->assign('job_ref', $jobs->job_ref);
$smarty->assign('job_title', $jobs->job_title);
$smarty->assign('job_description', $jobs->job_description);
$smarty->assign('job_postion', $jobs->job_postion);
//locations
$_SESSION['loc']['stateprovince'] = $job->state_province = stripHTMLTags($_POST['txtstateprovince']);
$_SESSION['loc']['country'] = $job->country = stripHTMLTags($_POST['txt_country']);
if (is_array($_POST['txt_category']) && !empty($_POST['txt_category'])) {
$category_selected = array();
foreach ($_POST['txt_category'] as $key => $value) {
$category_selected[] = $value;
}
}
$job->category = (int) sizeof($_POST['txt_category']);
$smarty->assign('category_selected', $category_selected);
//try to save data
if ($job->save()) {
$job_id = (int) $database->insert_id();
if (is_array($_POST['txt_job_type']) && !empty($_POST['txt_job_type'])) {
foreach ($_POST['txt_job_type'] as $key => $value) {
$type_added = Job2Type::make($job_id, $value);
$type_added->save();
}
}
if (is_array($_POST['txt_job_status']) && !empty($_POST['txt_job_status'])) {
foreach ($_POST['txt_job_status'] as $key => $value) {
$status_added = Job2Status::make($job_id, $value);
$status_added->save();
}
}
/**adding cat */
if (is_array($_POST['txt_category']) && !empty($_POST['txt_category'])) {
foreach ($_POST['txt_category'] as $key => $value) {
$cat_added = JobCategory::make($value, $job_id);
$cat_added->save();
}
