if (!$r) {
$r = "NULL";
} elseif ($r == 1) {
$r = 2;
}
db_query("UPDATE helpdesk_tickets SET ownerID = {$_GET["newOwner"]}, statusID = {$r}, updated_date = GETDATE(), updated_user = {$_SESSION["user_id"]} WHERE id = " . $_GET["ticketID"]);
if ($_GET["newOwner"] != "NULL") {
emailITticket($_GET["ticketID"], "assign");
}
} elseif (isset($_GET["newStatus"])) {
if (empty($_GET["newStatus"])) {
$_GET["newStatus"] = "NULL";
}
if ($_GET["newStatus"] == 9) {
db_query("UPDATE helpdesk_tickets SET closed_date = GETDATE() WHERE id = " . $_GET["ticketID"]);
emailITticket($_GET["ticketID"], "closed");
}
db_query("UPDATE helpdesk_tickets SET statusID = {$_GET["newStatus"]}, updated_date = GETDATE(), updated_user = {$_SESSION["user_id"]} WHERE id = " . $_GET["ticketID"]);
} elseif (isset($_GET["newPriority"])) {
db_query("UPDATE helpdesk_tickets SET priorityID = {$_GET["newPriority"]}, updated_date = GETDATE(), updated_user = {$_SESSION["user_id"]} WHERE id = " . $_GET["ticketID"]);
//email mohammed for critical
} elseif (isset($_GET["newDepartment"])) {
db_query("UPDATE helpdesk_tickets SET departmentID = {$_GET["newDepartment"]}, updated_date = GETDATE(), updated_user = {$_SESSION["user_id"]} WHERE id = " . $_GET["ticketID"]);
} elseif (isset($_GET["newType"])) {
if (empty($_GET["newType"])) {
$_GET["newType"] = "NULL";
}
db_query("UPDATE helpdesk_tickets SET type_id = {$_GET["newType"]}, updated_date = GETDATE(), updated_user = {$_SESSION["user_id"]} WHERE id = " . $_GET["ticketID"]);
} elseif (isset($_GET["newTime"])) {
if (empty($_GET["newTime"])) {
$_GET["newTime"] = 0;
created_user,
created_date,
message,
is_admin
) VALUES (
' . $_GET["id"] . ',
' . $_SESSION["user_id"] . ',
GETDATE(),
\'' . $_POST["message"] . '\',
' . $followupAdmin . '
)');
//email and exit
if ($followupAdmin) {
emailITticket($_GET["id"], "followupadmin");
} else {
emailITticket($_GET["id"], "followup");
}
url_change();
}
echo drawTop();
echo drawMessage($helpdeskStatus, "center");
//populate dropdowns
$timeSpentOptions = array(0 => 0, 15 => 15, 30 => 30, 45 => 45, 60 => 60, 75 => 75, 90 => 90, 105 => 105, 120 => "Two Hours", 180 => "Three Hours", 240 => "Four Hours", 300 => "Five Hours", 360 => "Six Hours", 420 => "Seven Hours", 480 => "Eight Hours", 540 => "Nine Hours", 600 => "10 Hours", 660 => "11 Hours", 720 => "12 Hours", 780 => "13 Hours", 940 => "14 Hours", 1000 => "15 Hours", 1060 => "16 Hours");
if (!$r["timeSpent"]) {
$r["timeSpent"] = 0;
}
if (!isset($timeSpentOptions[$r["timeSpent"]])) {
$timeSpentOptions[$r["timeSpent"]] = $r["timeSpent"];
sort($timeSpentOptions);
}
if ($r["ownerID"] && !$r["is_activeOwner"]) {
