<?php
include "include.php";
if ($posting) {
if (!$page['is_admin']) {
$_POST["user_id"] = $_SESSION["user_id"];
}
format_post_nulls("type_id, priorityID");
db_query("UPDATE helpdesk_tickets SET \n\t\tcreated_user = {$_POST["user_id"]},\n\t\ttitle = '{$_POST["title"]}',\n\t\tdescription = '{$_POST["description"]}',\n\t\ttype_id = {$_POST["type_id"]},\n\t\tdepartmentID = {$_POST["departmentID"]},\n\t\tpriorityID = {$_POST["priorityID"]}\n\t\tWHERE id = " . $_GET["id"]);
url_change("ticket.php?id=" . $_GET["id"]);
}
echo drawTop();
$t = db_grab("SELECT created_user, title, description, type_id, departmentID, priorityID FROM helpdesk_tickets t WHERE t.id = " . $_GET["id"]);
$form = new intranet_form();
if ($page['is_admin']) {
$form->addUser("user_id", "Posted By", $t["created_user"], false);
}
$form->addRow("itext", "Problem", "title", $t["title"], "", true);
if ($page['is_admin']) {
$form->addRow("select", "Priority", "priorityID", "SELECT id, description FROM helpdesk_tickets_priorities", $t["priorityID"]);
} else {
$form->addRow("select", "Priority", "priorityID", "SELECT id, description FROM helpdesk_tickets_priorities WHERE is_admin = 0", $t["priorityID"]);
}
$form->addRow("select", "Department", "departmentID", "SELECT departmentID, shortName FROM departments WHERE isHelpdesk = 1", $t["departmentID"], true, 50, "updateTypes(this.value)");
$form->addRow("select", "Type", "type_id", "SELECT id, description FROM helpdesk_tickets_types WHERE departmentID = " . $t["departmentID"] . " ORDER BY description", $t["type_id"]);
$form->addRow("textarea", "Description", "description", $t["description"], "", true);
$form->addRow("submit", "save changes");
$form->draw("Edit Ticket");
echo drawBottom();
<?php
include "include.php";
if ($posting) {
$user_id = $page['is_admin'] ? $_POST["user_id"] : $_SESSION["user_id"];
format_post_nulls("type_id");
$id = db_query("INSERT INTO helpdesk_tickets (\r\n \tcreated_user,\r\n \ttype_id,\r\n\t\tpriorityID,\r\n\t\tdepartmentID,\r\n\t\tdescription,\r\n\t\tstatusID,\r\n\t\tipAddress,\r\n\t\tcreated_date,\r\n\t\tupdated_date,\r\n\t\ttitle\r\n\t) VALUES (\r\n\t\t" . $user_id . ",\r\n\t\t" . $_POST["type_id"] . ",\r\n\t\t'" . $_POST["priorityID"] . "',\r\n\t\t'" . $_POST["departmentID"] . "',\r\n\t\t'" . $_POST["description"] . "',\r\n\t\t1,\r\n\t\t'{$_SERVER["REMOTE_ADDR"]}',\r\n\t\tGETDATE(),\r\n\t\tGETDATE(),\r\n\t\t'" . $_POST["title"] . "'\r\n );");
//$r = db_grab("SELECT MAX(id) id FROM helpdesk_tickets");
//todo - email mohammed for critical
emailITTicket($id, 'new');
//special for carla
url_change('ticket.php?id=' . $id);
}
echo drawTop();
echo drawMessage($helpdeskStatus, "center");
?>
<script language="javascript">
<!--
function updateTypes(departmentID) {
var types = new Array(3, 8);
<?php
$types = db_query("SELECT id, departmentID, description FROM helpdesk_tickets_types ORDER BY departmentID, description");
$options = array();
while ($t = db_fetch($types)) {
$options[$t["departmentID"]][] = '"' . $t["id"] . '|' . $t["description"] . '"';
}
while (list($key, $value) = each($options)) {
?>
types[<?php
echo $key;
<?php
$pageIsPublic = true;
include '../include.php';
if ($posting) {
$_POST['email'] = format_email($_POST['email']);
$_POST['phone'] = format_phone($_POST['phone']);
format_post_nulls('departmentID, officeID');
//create request
//todo ~ check whether staff already exists -- forward to password reset
if ($id = db_grab('SELECT id FROM users WHERE email = "' . $_POST['email'] . '" AND is_active = 1')) {
url_change('account_exists.php');
} elseif (getOption('requests') && ($id = db_grab('SELECT id FROM users_requests WHERE email = "' . $_POST['email'] . '"'))) {
db_save('users_requests', $id);
emailAdmins('Repeat Account Request', $_POST['firstname'] . ' ' . $_POST['lastname'] . ' is ' . draw_link(url_base() . '/staff/add_edit.php?requestID=' . $id, 're-requesting an account'));
} else {
if (getOption('requests')) {
$id = db_save('users_requests');
//if (getOption('channels')) db_checkboxes('email_prefs', 'requests_to_channels_prefs', 'request_id', 'channel_id', $id);
$subject = 'New User Request';
$link = url_base() . '/staff/add_edit.php?requestID=' . $id;
} else {
$id = db_save('users');
if (getOption('channels')) {
db_checkboxes('email_prefs', 'users_to_channels_prefs', 'user_id', 'channel_id', $id);
}
$subject = 'New User Registration';
$link = url_base() . '/staff/add_edit.php?id=' . $id;
emailInvite($id);
}
//prepare email
