startTrans(); $update_job = " UPDATE jobs SET `status` = '1', `location_id` = '$location_id', `submitter` = '$submitter', `date_submitted` = '$current_date_time' WHERE id = '$current_job' "; $database->query($update_job); $result = common_location::get_details($location_id); $addres_nice = $result['address'].", ".$result['suburb'].", ".$result['state'].", ".$result['post_code']; /* $context_trig['foreign_id'] = $current_job; $context_trig['id'] = 428; $context_trig['direction'] = ""; common_triggers::initiate_workflow($context_trig); */ $context_trig['foreign_id'] = $current_job; $context_trig['id'] = 408; $context_trig['direction'] = ""; common_triggers::initiate_workflow($context_trig); $context_trig['foreign_id'] = $current_job; $context_trig['id'] = 429; $context_trig['direction'] = ""; common_triggers::initiate_workflow($context_trig); $context_trig['foreign_id'] = $current_job; $context_trig['id'] = 430; $context_trig['direction'] = ""; common_triggers::initiate_workflow($context_trig); /*$context_trig['foreign_id'] = $current_job; $context_trig['id'] = 366; $context_trig['direction'] = ""; common_triggers::initiate_workflow($context_trig);*/ $result = $database->completeTrans(); $status = ($result) ? true : false; $json = json_encode(array("status" => $status,"address" => $addres_nice)); echo $json; ?>