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"]) {