/**
* Logs a user out of SiT
*
* @author Paul Heaney
* @param string $sessionid - The session ID to log out of
* @return Array - Status
*/
function logout($sessionid)
{
$status = new SoapStatus();
if (validate_session($sessionid)) {
session_id($sessionid);
session_start();
// End the session, remove the cookie and destroy all data registered with the session
$_SESSION['auth'] = FALSE;
$_SESSION['portalauth'] = FALSE;
$_SESSION = array();
session_unset();
session_destroy();
if (isset($_COOKIE[session_name()])) {
setcookie(session_name(), '', time() - 42000, '/');
}
} else {
$status->set_error('session_not_valid');
}
return array('status' => $status->getSOAPArray());
}
/**
* Lists a set of incidents
* @author Paul Heaney
* @param string $sessionid - the sessionid
* @param int $owner - List incidents of this owner (0 for all)
* @param int $status - 0 for ALL, 1 for all Active, 2 for all open
* @return Array - array of incidents[] Status
*/
function list_incidents($sessionid, $owner = 0, $status = 1)
{
global $sit;
$status = new SoapStatus();
$incidents = array();
if (!empty($sessionid) and validate_session($sessionid)) {
if (user_permission($sit[2], 6)) {
/*
* SELECT i.*, uTOwner.realname AS townerName FROM `users` AS uo, `incidents` AS i LEFT JOIN `users` AS uTOwner ON uTOwner.id = i.towner WHERE i.owner = uo.id
*/
$sql = "SELECT i.*, uOwner.realname AS ownerName, uTOwner.realname AS townerName, p.name AS priorityName, ";
$sql .= "s.name AS skill, ist.name AS statusNameInternal, ist.ext_name AS statusNameExternal ";
$sql .= "FROM `{$GLOBALS['dbIncidentStatus']}` AS ist, `{$GLOBALS['dbUsers']}` AS uOwner, `{$GLOBALS['dbPriority']}` AS p, ";
$sql .= "`{$GLOBALS['dbIncidents']}` AS i LEFT JOIN `{$GLOBALS['dbUsers']}` AS uTOwner ON uTOwner.id = i.towner ";
$sql .= "LEFT JOIN `{$GLOBALS['dbSoftware']}` AS s ON s.id = i.softwareid ";
$sql .= " WHERE i.owner = uOwner.id AND i.priority = p.id AND i.status = ist.id ";
if ($owner > 0) {
$sql .= "AND (i.owner = {$owner} OR i.towner = {$owner}) ";
}
switch ($status) {
case 1:
$sql .= "AND i.status = " . STATUS_ACTIVE . " ";
break;
case 2:
$sql .= "AND (i.status != " . STATUS_CLOSED . " AND i.status != " . STATUS_UNASSIGNED . ") ";
break;
}
debug_log("SQL: {$sql}");
$result = mysql_query($sql);
if (mysql_error()) {
trigger_error(mysql_error(), E_USER_WARNING);
}
if (mysql_num_rows($result) > 0) {
while ($obj = mysql_fetch_object($result)) {
$incident = new Incident();
$incident->incidentid = $obj->id;
$incident->title = $obj->title;
$incident->owner = $obj->ownerName;
$incident->ownerid = $obj->owner;
$incident->towner = $obj->townerName;
$incident->townerid = $obj->towner;
$incident->priority = $obj->priorityName;
$incident->priorityid = $obj->priority;
$incident->currentstatusid = $obj->status;
$incident->currentstatusinternal = $GLOBALS[$obj->statusNameInternal];
$incident->currentstatusexternal = $GLOBALS[$obj->statusNameExternal];
$incident->skill = $obj->skill;
$incident->skillid = $obj->softwareid;
$incident->maintenanceid = $obj->maintenanceid;
$incident->servicelevel = $obj->servicelevel;
$incidents[] = $incident;
}
}
} else {
$status->set_error('no_access');
}
} else {
$status->set_error('session_not_valid');
}
return array('incidents' => $incidents, 'status' => $status->getSOAPArray());
}
