public function update_comment($ticket_id, $comment) { $DB_data = $this->load->database('default', TRUE); $data = array('comment' => $comment); $DB_data->where(array('ticket_id' => $ticket_id))->insert(NEW_TICKETS, $data); if ($DB_data->affected_rows() > 0) { trigger_solr_update(); } }
function change_user_staff_status($user_id, $is_staff) { $success = false; $DB_data = $this->load->database('default', TRUE); $is_staff_numeric = $is_staff ? 1 : 0; $DB_data->where('site_id', $this->site_id)->where('network_id', $user_id)->update('user_mappings', array('is_staff' => $is_staff_numeric)); if ($DB_data->affected_rows() > 0) { $success = true; trigger_solr_update(); } return $success; }
public function update_equipment_location($equipment_type, $equipment_id, $location_id) { $DB_data = $this->load->database('default', TRUE); $table = "locations"; $success = false; $locatable_types = $this->get_equipment_types($this->site_id); $locatable_identifier = make_equipment_identifier($equipment_type, $equipment_id); $new_info = array('location_id' => $location_id); $new_info['updater_id'] = $this->user_id; $new_info['locatable_type_id'] = $locatable_types[$equipment_type]['id']; $new_info['locatable_id'] = $equipment_id; $new_info['locatable_identifier'] = $locatable_identifier; $test_query = $DB_data->get_where($table, array('locatable_identifier' => $locatable_identifier), 1); if ($test_query && $test_query->num_rows() > 0) { //already exists, update $id = $test_query->row()->id; $DB_data->where('id', $id)->update($table, $new_info); if ($DB_data->affected_rows() > 0) { $success = true; } } else { //doesn't exist, make it $new_info['created_at'] = date('Y-m-d H:i:s'); $new_info['creator_id'] = $this->user_id; $DB_data->insert($table, $new_info); if ($DB_data->affected_rows() > 0) { $success = true; } } trigger_solr_update(); return $success; }