if ($total_post <= 0) {
             $session->message('<div class="error">' . format_lang('total_jobpost') . '</strong></div>');
             redirect_to(BASE_URL . "employer/credits/");
             die;
         }
     }
 }
 //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();
 $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);
     $cat_added->save();
 }
 if ($status_added && $cat_added && $type_added) {
     if (FREE_SITE == "N") {
         if ($spotlight == "spotlight") {
             $employer->update_spotlight_job_post();
         } else {
             $employer->update_job_post();
         }
     }
     unset($_SESSION['add_job']);
     $message = "<div class='success'>" . format_lang('success', 'updateJob') . "</div>";
     destroy_my_session();
 } else {
     $message = "<div class='error'>" . format_lang('error', 'updateJob') . "</div>";