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;
}
