$smartyvalues['id'] = $id; $smartyvalues['tid'] = $tid; $smartyvalues['c'] = $c; $status = $data['status']; $closedcheck = get_query_val("tblticketstatuses", "id", array("title" => $status, "showactive" => "0")); $smartyvalues['stillopen'] = !$closedcheck ? true : false; $feedbackcheck = get_query_val("tblticketfeedback", "id", array("ticketid" => $id)); $smartyvalues['feedbackdone'] = $feedbackcheck; $date = $data['date']; $smartyvalues['opened'] = date("l, jS F Y H:ia", strtotime($date)); $lastreply = get_query_val("tblticketreplies", "date", array("tid" => $id), "id", "DESC"); if (!$lastreply) { $lastreply = $date; } $smartyvalues['lastreply'] = date("l, jS F Y H:ia", strtotime($lastreply)); $duration = getLastReplyTime($date, $lastreply); $smartyvalues['duration'] = $duration; $ratings = array(); $i = 1; while ($i <= 10) { $ratings[] = $i; ++$i; } $smartyvalues['ratings'] = $ratings; $staffinvolved = array(); $result = select_query("tblticketreplies", "DISTINCT admin", array("tid" => $id)); while ($data = mysql_fetch_array($result)) { if (trim($data[0])) { $staffinvolved[get_query_val("tbladmins", "id", "CONCAT(firstname,' ',lastname)='" . db_escape_string($data[0]) . "'")] = $data[0]; } }
$tags = json_encode($tags); $csrfToken = generate_token("plain"); $jsheadoutput = "<script type=\"text/javascript\">\nvar ticketid = '" . $id . "';\nvar userid = '" . $pauserid . "';\nvar ticketTags = " . $tags . ";\nvar csrfToken = '" . $csrfToken . "';\nvar langdelreplysure = \"" . $_ADMINLANG['support']['delreplysure'] . "\";\nvar langdelticketsure = \"" . $_ADMINLANG['support']['delticketsure'] . "\";\nvar langdelnotesure = \"" . $_ADMINLANG['support']['delnotesure'] . "\";\nvar langloading = \"" . $_ADMINLANG['global']['loading'] . "\";\nvar langstatuschanged = \"" . $_ADMINLANG['support']['statuschanged'] . "\";\nvar langstillsubmit = \"" . $_ADMINLANG['support']['stillsubmit'] . "\";\n</script>\n<script type=\"text/javascript\" src=\"../includes/jscript/admintickets.js\"></script>"; $aInt->addHeadOutput($jsheadoutput); $smartyvalues['infobox'] = $infobox; $smartyvalues['ticketid'] = $id; $smartyvalues['deptid'] = $deptid; $smartyvalues['tid'] = $tid; $smartyvalues['subject'] = $title; $smartyvalues['status'] = $tstatus; $smartyvalues['userid'] = $pauserid; $smartyvalues['contactid'] = $pacontactid; $smartyvalues['clientname'] = $clientname; $smartyvalues['contactname'] = $contactname; $smartyvalues['clientgroupcolour'] = $clientgroupcolour; $smartyvalues['lastreply'] = getLastReplyTime($lastreply); $smartyvalues['priority'] = $urgency; $smartyvalues['flag'] = $flag; $smartyvalues['cc'] = $cc; $smartyvalues['staffinvolved'] = $staffinvolved; $smartyvalues['deleteperm'] = checkPermission("Delete Ticket", true); $result = select_query("tbladmins", "firstname,lastname,signature", array("id" => $_SESSION['adminid'])); $data = mysql_fetch_array($result); $signature = $data['signature']; $smartyvalues['signature'] = $signature; $smartyvalues['predefinedreplies'] = genPredefinedRepliesList(0); $smartyvalues['clientnotes'] = array(); $result = select_query("tblnotes", "tblnotes.*,(SELECT CONCAT(firstname,' ',lastname) FROM tbladmins WHERE tbladmins.id=tblnotes.adminid) AS adminuser", array("userid" => $pauserid, "sticky" => "1"), "modified", "DESC"); while ($data = mysql_fetch_assoc($result)) { $data['created'] = fromMySQLDate($data['created'], 1); $data['modified'] = fromMySQLDate($data['modified'], 1);