/** deleteing job types from job types table */
 $job_t = new Job2Type();
 $job_t->fk_job_id = $job_id;
 $job_t->delete_all_on_update();
 //add new job type
 if (is_array($_POST['txt_job_type']) && !empty($_POST['txt_job_type'])) {
     foreach ($_POST['txt_job_type'] as $key => $value) {
         $type_added = new Job2Type();
         $type_added->fk_job_id = (int) $job_id;
         $type_added->fk_job_type_id = (int) $value;
         //$type_added = Job2Type::make(  $job_id, $value );
         $type_added->save();
     }
 }
 /** deleting job status **/
 $job_s = new Job2Status();
 $job_s->fk_job_id = $job_id;
 $job_s->delete_all_on_update();
 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();
     }
 }
 /** deleting job status **/
 $job_c = new JobCategory();
 $job_c->job_id = $job_id;
 $job_c->delete_all_on_update();
 /**adding cat */
 foreach ($_POST['txt_category'] as $key => $value) {
     $cat_added = JobCategory::make($value, $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) {
         if ($job->spotlight == "Y") {
             $employer->update_spotlight_job_post();
         } else {
             $employer->update_job_post();
         }
     }
     redirect_to(BASE_URL . "employer/myjobs/");
 }
     }
 }
 $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();
         }
     }
     if ($status_added && $cat_added && $type_added) {
         if (FREE_SITE == "N") {
             if ($spotlight == "spotlight") {
                 $employer->update_spotlight_job_post();
             } else {