$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);
