function getReturnViewOptions($current)
{
$statuss = SupportHelper::getStatuss();
$temp = new stdClass();
$temp->id = "closed";
$temp->title = JText::_("Closed");
$statuss[] = $temp;
$temp = new stdClass();
$temp->id = "allopen";
$temp->title = JText::_("ALL_OPEN");
$statuss[] = $temp;
$temp = new stdClass();
$temp->id = "all";
$temp->title = JText::_("All");
$statuss[] = $temp;
$output[] = "<option value=''>" . JText::_('SHOW_CURRENT_TICKET') . "</option>";
$output[] = "<optgroup label='" . JText::_('SHOW_TICKET_LIST') . ":'>";
$selected = "";
if ($current == "list_current") {
$selected = "selected";
}
$output[] = "<option value='list_current' {$selected}>" . JText::_('LIST') . ": " . JText::_('CURRENT_TICKETS_STATUS') . "</option>";
foreach ($statuss as $status) {
$selected = "";
if ($current == "list_" . $status->id) {
$selected = "selected";
}
$output[] = "<option value='list_" . $status->id . "' {$selected}>" . JText::_('LIST') . ": " . $status->title . "</option>";
}
$output[] = "</optgroup>";
$output[] = "<optgroup label='" . JText::_('SHOW_NEWEST_TICKET') . ":'>";
$selected = "";
if ($current == "new_current") {
$selected = "selected";
}
$output[] = "<option value='new_current' {$selected}>" . JText::_('NEWEST') . ": " . JText::_('CURRENT_TICKETS_STATUS') . "</option>";
foreach ($statuss as $status) {
$selected = "";
if ($current == "new_" . $status->id) {
$selected = "selected";
}
$output[] = "<option value='new_" . $status->id . "' {$selected}>" . JText::_('NEWEST') . ": " . $status->title . "</option>";
}
$output[] = "</optgroup>";
$output[] = "<optgroup label='" . JText::_('SHOW_OLDEST_TICKET') . ":'>";
$selected = "";
if ($current == "old_current") {
$selected = "selected";
}
$output[] = "<option value='old_current' {$selected}>" . JText::_('OLDEST') . ": " . JText::_('CURRENT_TICKETS_STATUS') . "</option>";
foreach ($statuss as $status) {
$selected = "";
if ($current == "old_" . $status->id) {
$selected = "selected";
}
$output[] = "<option value='old_" . $status->id . "' {$selected}>" . JText::_('OLDEST') . ": " . $status->title . "</option>";
}
$output[] = "</optgroup>";
return implode($output);
}
function ticket_status_id()
{
// update status in ticket
// redirect if the config is set to
$ticketid = FSS_Input::getInt('ticketid');
$ticket_status_id = FSS_Input::getInt('ticket_status_id');
if ($ticketid < 1) {
exit;
}
if ($ticket_status_id < 1) {
exit;
}
$link = FSSRoute::_('index.php?option=com_fss&view=admin_support&layout=ticket&ticketid=' . $ticketid, false);
// check permission for new status
$statuss = SupportHelper::getStatuss();
$new_status = $statuss[$ticket_status_id];
if ($new_status->is_closed && !$this->view->can_Close()) {
JFactory::getApplication()->redirect($link);
exit;
}
$ticket = new SupportTicket();
if ($ticket->Load($ticketid)) {
$old_st = $ticket->getStatus();
$ticket->updateStatus($ticket_status_id);
$new_st = $ticket->getStatus();
// if we have closed the ticket, and return on close is set, then we should do a redirect dependant on the setting
if ($new_st->is_closed && SupportUsers::getSetting("return_on_close")) {
$link = SupportHelper::parseRedirectType($old_st->id, SupportUsers::getSetting("return_on_close"));
}
if ($new_st->is_closed && !$old_st->is_closed) {
// SEND CLOSED EMAIL HERE!
if (!FSS_Settings::get('support_email_on_close_no_dropdown')) {
FSS_EMail::Admin_Close($ticket, $ticket->title, '', array());
}
}
}
JFactory::getApplication()->redirect($link);
exit;
}
FSS_Table::ColStart("tr_status");
?>
<th style="vertical-align: middle"><?php
echo JText::_("STATUS");
?>
</th>
<td>
<?php
if ($this->can_ChangeTicket()) {
?>
<form id='status_form' action="<?php
echo FSSRoute::_('index.php?option=com_fss&view=admin_support&task=update.ticket_status_id&ticketid=' . $this->ticket->id);
?>
" method="post" style="margin: 0px;">
<?php
$statuss = SupportHelper::getStatuss();
?>
<select id='ticket_status_id' name='ticket_status_id' class="input-medium select-color" style="margin: 0px; color: <?php
echo FSS_Helper::escape($this->ticket->scolor);
?>
" onchange="jQuery('#status_form').submit();">
<?php
foreach ($statuss as $status) {
?>
<?php
if (!$this->can_Close() && $status->is_closed) {
continue;
}
?>
<option value='<?php
echo $status->id;
function loadPDC()
{
$this->products = SupportHelper::getProducts();
$this->departments = SupportHelper::getDepartments();
$this->categories = SupportHelper::getCategories();
$prods = array();
$prods[] = JHTML::_('select.option', '0', JText::_("SELECT_PRODUCT"), 'id', 'title');
$prods = array_merge($prods, $this->products);
$this->products_select = JHTML::_('select.genericlist', $prods, 'prodid', 'class="input-medium" size="1" onchange="document.mainform.submit( );"', 'id', 'title', $this->prodid);
$depts = array();
$depts[] = JHTML::_('select.option', '0', JText::_("SELECT_DEPARTMENT"), 'id', 'title');
$depts = array_merge($depts, $this->departments);
$this->departments_select = JHTML::_('select.genericlist', $depts, 'deptid', 'class="input-medium" size="1" onchange="document.mainform.submit( );"', 'id', 'title', $this->deptid);
$cats = array();
$cats[] = JHTML::_('select.option', '0', JText::_("SELECT_CATEGORY"), 'id', 'title');
$cats = array_merge($cats, $this->categories);
$this->categories_select = JHTML::_('select.genericlist', $cats, 'catid', 'class="input-medium" size="1" onchange="document.mainform.submit( );"', 'id', 'title', $this->catid);
$modes = array();
$modes[] = JHTML::_('select.option', '0', JText::_("VIEW_TICKETS"), 'id', 'title');
$modes[] = JHTML::_('select.option', '1', JText::_("ASSIGN_TICKETS"), 'id', 'title');
$this->mode_select = JHTML::_('select.genericlist', $modes, 'mode', 'class="input-medium" size="1" onchange="document.mainform.submit( );"', 'id', 'title', $this->mode);
$this->statuss = SupportHelper::getStatuss();
FSS_Translate_Helper::Tr($this->statuss);
$this->status_select = JHTML::_('select.genericlist', $this->statuss, 'status', 'class="input-medium hide" size="1" onchange="document.mainform.submit( );" id="cur_status"', 'id', 'title', $this->status);
$this->status_obj = FSS_Ticket_Helper::GetStatusByID($this->status);
FSS_Translate_Helper::TrSingle($this->status_obj);
}
static function forUser(&$parser, $ticket, $custom_fields = null)
{
$parser->Clear();
if ($ticket) {
// overwrite status of ticket when combined
$statuss = SupportHelper::getStatuss(false);
FSS_Translate_Helper::Tr($statuss);
$cur_status = $statuss[$ticket->ticket_status_id];
if ($cur_status->combine_with > 0) {
$new_status = $statuss[$cur_status->combine_with];
$ticket->color = $new_status->color;
$ticket->status = $new_status->title;
if ($new_status->userdisp) {
$ticket->status = $new_status->userdisp;
}
$ticket->ticket_status_id = $new_status->id;
} else {
if ($cur_status->userdisp) {
$ticket->status = $cur_status->userdisp;
}
}
}
self::core($parser, $ticket, $custom_fields);
if ($ticket) {
// TODO TODO TODO :
//$title = $ticket->getTitle();
$title = self::parseTitle($ticket->title, $ticket->id);
//$title = $ticket->title;
$parser->SetVar('link', FSSRoute::_('index.php?option=com_fss&view=ticket&layout=view&ticketid=' . $ticket->id));
$parser->SetVar('subject', "<a href='" . FSSRoute::_('index.php?option=com_fss&view=ticket&layout=view&ticketid=' . $ticket->id) . "'>" . $title . "</a>");
$parser->SetVar('subject_text', $title);
$style = "";
//$trhl = " onmouseover='highlightticket({$ticket->id})' onmouseout='unhighlightticket({$ticket->id})' ";
$trhl = " ";
// no longer highlighting tickets!
if (FSS_Settings::get('support_entire_row')) {
$style .= "cursor: pointer;";
$trhl .= " onclick='window.location=\"" . FSSRoute::_('index.php?option=com_fss&view=ticket&layout=view&ticketid=' . $ticket->id) . "\"' ";
}
$trhl .= " style='{$style}' ";
$parser->SetVar('trhl', $trhl);
$parser->SetVar('class', static::$rowclass . " ticket_{$ticket->id}");
if (static::$rowclass == "odd") {
static::$rowclass = "even";
} else {
static::$rowclass = "odd";
}
}
$parser->SetVar("hidehandler", FSS_Settings::get('support_hide_handler') > 0);
$parser->SetVar("multiuser", $parser->multiuser);
}
<label class="control-label"><?php
echo JText::_("STATUS");
?>
</label>
<div class="controls">
<select name="batch_status">
<option value=""><?php
echo JText::_('UNCHANGED');
?>
</option>
<optgroup label="<?php
echo JText::_('NEW_STATUS_');
?>
">
<?php
$status_list = SupportHelper::getStatuss();
foreach ($status_list as $status) {
echo "<option value='{$status->id}' style='color: {$status->color};'>{$status->title}</option>";
}
?>
</optgroup>
<?php
if (FSS_Settings::get('support_delete')) {
?>
<optgroup label="<?php
echo JText::_('DELETE_TICKET');
?>
:">
<option value='delete' style='color: red;'><?php
function FixTicketStatus()
{
$statuss = SupportHelper::getStatuss(false);
$cur_status = $statuss[$this->ticket['ticket_status_id']];
if ($cur_status->combine_with > 0) {
$new_status = $statuss[$cur_status->combine_with];
$this->ticket['scolor'] = $new_status->color;
$this->ticket['status'] = $new_status->title;
if ($new_status->userdisp) {
$this->ticket['status'] = $new_status->userdisp;
}
$this->ticket['ticket_status_id'] = $new_status->id;
} else {
if ($cur_status->userdisp) {
$this->ticket['status'] = $cur_status->userdisp;
}
}
}
static function &ParseTemplate($template, &$ticket, $subject, $body, $ishtml, $foruser = false)
{
$handler = self::GetHandler($ticket['admin_id'], $template['tmpl']);
$custrec = self::GetUser($ticket['user_id']);
$subject = trim(str_ireplace("re:", "", $subject));
$vars[] = self::BuildVar('subject', $subject);
$body = FSS_Helper::ParseBBCode($body, null, false, false, $foruser);
$body = str_replace("<", "XXXLTXXX", $body);
$body = str_replace(">", "XXXGTXXX", $body);
$vars[] = self::BuildVar('body', $body);
$vars[] = self::BuildVar('reference', $ticket['reference']);
$vars[] = self::BuildVar('password', $ticket['password']);
foreach (self::$extra_vars as $key => $value) {
$vars[] = self::BuildVar($key, $value);
}
if ($ticket['user_id'] == 0) {
$vars[] = self::BuildVar('user_name', $ticket['unregname']);
$vars[] = self::BuildVar('user_username', JText::_("UNREGISTERED"));
$vars[] = self::BuildVar('user_email', $ticket['email']);
} else {
$vars[] = self::BuildVar('user_name', $custrec['name']);
$vars[] = self::BuildVar('user_username', $custrec['username']);
$vars[] = self::BuildVar('user_email', $custrec['email']);
}
$vars[] = self::BuildVar('handler_name', $handler['name']);
$vars[] = self::BuildVar('handler_username', $handler['username']);
$vars[] = self::BuildVar('handler_email', $handler['email']);
$vars[] = self::BuildVar('ticket_id', $ticket['id']);
if ($foruser) {
$statuss = SupportHelper::getStatuss(false);
$status = $statuss[$ticket['ticket_status_id']];
if ($status->combine_with > 0) {
$status = $statuss[$status->combine_with];
}
FSS_Translate_Helper::TrO($status);
$text = $status->title;
if ($status->userdisp) {
$text = $status->userdisp;
}
$vars[] = self::BuildVar('status', $text);
} else {
$vars[] = self::BuildVar('status', self::GetStatus($ticket['ticket_status_id']));
}
$vars[] = self::BuildVar('priority', self::GetPriority($ticket['ticket_pri_id']));
$vars[] = self::BuildVar('category', self::GetCategory($ticket['ticket_cat_id']));
$vars[] = self::BuildVar('department', self::GetDepartment($ticket['ticket_dept_id']));
$vars[] = self::BuildVar('department_desc', strip_tags(self::GetDepartment($ticket['ticket_dept_id'], 'description')));
$vars[] = self::BuildVar('department_desc_html', self::GetDepartment($ticket['ticket_dept_id'], 'description'));
$vars[] = self::BuildVar('product', self::GetProduct($ticket['prod_id']));
$vars[] = self::BuildVar('product_desc', strip_tags(self::GetProduct($ticket['prod_id'], 'description')));
$vars[] = self::BuildVar('product_desc_html', self::GetProduct($ticket['prod_id'], 'description'));
if (strpos($template['body'], "{messagehistory}") > 0) {
$messages = self::GetMessageHist($ticket['id']);
$text = self::ParseMessageRows($messages, $ishtml, $foruser);
$vars[] = self::BuildVar('messagehistory', $text);
}
$uri = JURI::getInstance();
$baseUrl = FSS_Settings::get('support_email_no_domain') ? "" : $uri->toString(array('scheme', 'host', 'port'));
if (in_array(FSS_Settings::get('support_unreg_type'), array(0, 1))) {
$vars[] = self::BuildVar('haspassword', 1);
} else {
$vars[] = self::BuildVar('haspassword', 0);
}
// choose which user link to generate
if ($ticket['user_id'] < 1) {
// unregistered user
$url = 'index.php?option=com_fss&t=' . $ticket['id'] . "&p=" . $ticket['password'];
if (FSS_Settings::get('support_email_link_unreg') > 0) {
// add fixed item id if needed
$url .= "&Itemid=" . FSS_Settings::get('support_email_link_unreg');
}
$vars[] = self::BuildVar('ticket_link', $baseUrl . JRoute::_($url, false));
} else {
// registered user
$url = 'index.php?option=com_fss&view=ticket&layout=view&ticketid=' . $ticket['id'];
if (FSS_Settings::get('support_email_include_autologin')) {
$url .= "&login={login_code}";
}
if (FSS_Settings::get('support_email_link_reg') > 0) {
// add fixed item id if needed
$url .= "&Itemid=" . FSS_Settings::get('support_email_link_reg');
}
$vars[] = self::BuildVar('ticket_link', $baseUrl . JRoute::_($url, false));
}
// ticket admin link
$url = 'index.php?option=com_fss&view=admin_support&layout=ticket&ticketid=' . $ticket['id'];
if (FSS_Settings::get('support_email_link_admin') > 0) {
// add fixed item id if needed
$url .= "&Itemid=" . FSS_Settings::get('support_email_link_admin');
}
$vars[] = self::BuildVar('admin_link', $baseUrl . JRoute::_($url, false));
// email pending link
$url = 'index.php?option=com_fss&view=admin_support&layout=emails';
if (FSS_Settings::get('support_email_link_pending') > 0) {
// add fixed item id if needed
$url .= "&Itemid=" . FSS_Settings::get('support_email_link_pending');
}
$vars[] = self::BuildVar('email_pending_link', $baseUrl . JRoute::_($url, false));
$vars[] = self::BuildVar('websitetitle', FSS_Helper::getSiteName());
// need to add the tickets custom fields to the output here
$fields = FSSCF::GetAllCustomFields(true);
$values = FSSCF::GetTicketValues($ticket['id'], $ticket);
foreach ($fields as $fid => &$field) {
$name = "custom_" . $fid;
$value = "";
if (array_key_exists($fid, $values)) {
$value = (string) $values[$fid]['value'];
}
$fieldvalues = array();
$fieldvalues[0]['field_id'] = $fid;
$fieldvalues[0]['value'] = $value;
// only do area output processing if we are in html mode
if ($field['type'] != "area" || $ishtml) {
$newvalue = FSSCF::FieldOutput($field, $fieldvalues, '');
if ($newvalue) {
$value = $newvalue;
}
}
$vars[] = self::BuildVar($name, $value);
$vars[] = self::BuildVar("custom_" . $field['alias'], $value);
}
$email['subject'] = self::ParseText($template['subject'], $vars);
$email['body'] = self::ParseText($template['body'], $vars);
self::$last_vars = $vars;
if ($template['ishtml']) {
$email['body'] = FSS_Helper::MaxLineLength($email['body']);
} else {
$email['body'] = str_replace("<br />", "\n", $email['body']);
$email['body'] = html_entity_decode($email['body']);
$email['body'] = preg_replace_callback("/(&#[0-9]+;)/", array("FSS_Helper", "email_decode_utf8"), $email['body']);
$email['body'] = strip_tags($email['body']);
}
$email['body'] = str_replace("XXXLTXXX", "<", $email['body']);
$email['body'] = str_replace("XXXGTXXX", ">", $email['body']);
return $email;
}
function getStatus()
{
$statuss = SupportHelper::getStatuss(false);
return $statuss[$this->ticket_status_id];
}
function &getTickets()
{
$db = JFactory::getDBO();
$user = JFactory::getUser();
$userid = $user->get('id');
$uidlist = $this->getUIDS($userid);
$tidlist = $this->getTIDS($userid);
$query = "SELECT t.*, s.title as status, s.color, u.name, au.name as assigned, u.email as useremail, u.username as username, au.email as handleremail, au.username as handlerusername, ";
$query .= " dept.title as department, cat.title as category, prod.title as product, pri.title as priority, pri.color as pricolor, ";
$query .= " grp.groupname as groupname, grp.id as group_id ";
$query .= " , pri.translation as ptl, dept.translation as dtr, s.translation as str, cat.translation as ctr, prod.translation as prtr";
$query .= " FROM #__fss_ticket_ticket as t ";
$query .= " LEFT JOIN #__fss_ticket_status as s ON t.ticket_status_id = s.id ";
$query .= " LEFT JOIN #__users as u ON t.user_id = u.id ";
$query .= " LEFT JOIN #__users as au ON t.admin_id = au.id ";
$query .= " LEFT JOIN #__fss_ticket_dept as dept ON t.ticket_dept_id = dept.id ";
$query .= " LEFT JOIN #__fss_ticket_cat as cat ON t.ticket_cat_id = cat.id ";
$query .= " LEFT JOIN #__fss_prod as prod ON t.prod_id = prod.id ";
$query .= " LEFT JOIN #__fss_ticket_pri as pri ON t.ticket_pri_id = pri.id ";
$query .= " LEFT JOIN (SELECT group_id, user_id FROM #__fss_ticket_group_members GROUP BY user_id) as mem ON t.user_id = mem.user_id ";
$query .= " LEFT JOIN #__fss_ticket_group as grp ON grp.id = mem.group_id ";
// add product, department and category
$query .= " WHERE ( t.user_id IN (" . implode(", ", $uidlist) . ") OR t.id IN (" . implode(", ", $tidlist) . ") ) ";
$query .= " AND " . SupportSource::user_list_sql();
$tickets = FSS_Input::getCmd('tickets', 'open');
if (FSS_Settings::get('support_simple_userlist_tabs')) {
$tickets = "all";
}
if (FSS_Input::getCmd('search_all')) {
$tickets = "";
}
if ($tickets == 'open') {
$allopen = FSS_Ticket_Helper::GetStatusIDs("is_closed", true);
// tickets that arent closed
$query .= " AND ticket_status_id IN ( " . implode(", ", $allopen) . ") ";
}
if ($tickets == 'closed') {
$allopen = FSS_Ticket_Helper::GetStatusIDs("is_closed");
// remove the archived tickets from the list to deal with
$def_archive = FSS_Ticket_Helper::GetStatusID('def_archive');
foreach ($allopen as $offset => $value) {
if ($value == $def_archive) {
unset($allopen[$offset]);
}
}
// tickets that are closed
$query .= " AND ticket_status_id IN ( " . implode(", ", $allopen) . ") ";
} else {
if ($tickets > 0) {
$statuss = SupportHelper::getStatuss(false);
$status_list = array();
$status_list[] = (int) $tickets;
foreach ($statuss as $status) {
if ($status->combine_with == (int) $tickets) {
$status_list[] = $status->id;
}
}
$query .= " AND ticket_status_id IN (" . implode(", ", $status_list) . ")";
}
}
$search = FSS_Input::getString('search');
if ($search != "") {
FSS_Helper::AllowCache();
// We have the nearly full query here, so use it to get a list of ticket ids
$db->setQuery($query);
$recs = $db->loadObjectList();
$ids = array();
$ids[] = 0;
foreach ($recs as $rec) {
$ids[] = $rec->id;
}
$mode = "";
if (FSS_Helper::contains($search, array('*', '+', '-', '<', '>', '(', ')', '~', '"'))) {
$mode = "IN BOOLEAN MODE";
}
$msgsrch = "SELECT ticket_ticket_id FROM #__fss_ticket_messages WHERE ticket_ticket_id IN (" . implode(", ", $ids) . ") AND admin < 3 AND ";
$msgsrch .= " MATCH (body) AGAINST ('" . $db->escape($search) . "' {$mode}) ";
$db->setQuery($msgsrch);
$results = $db->loadObjectList();
$ids = array();
$ids[] = 0;
foreach ($results as $rec) {
$ids[] = $rec->ticket_ticket_id;
}
// search custom fields that are set to be searched
$fields = FSSCF::GetAllCustomFields(true);
foreach ($fields as $field) {
if (!$field["basicsearch"]) {
continue;
}
if ($field['permissions'] > 1 && $field['permissions'] < 5) {
continue;
}
$fieldid = $field['id'];
if ($field['type'] == "checkbox") {
if ($search == "1") {
$search = "on";
} else {
$search = "";
}
}
if ($field['peruser']) {
continue;
}
if ($field['type'] == "plugin") {
// try to do a plugin based search
$data = array();
foreach ($field['values'] as $item) {
list($key, $value) = explode("=", $item, 2);
$data[$key] = $value;
}
if (array_key_exists("plugin", $data)) {
$plugins = FSSCF::get_plugins();
if (array_key_exists($data['plugin'], $plugins)) {
$po = $plugins[$data['plugin']];
if (method_exists($po, "Search")) {
$res = $po->Search($data['plugindata'], $search, false, false);
if ($res !== false) {
foreach ($res as $item) {
$ids[] = (int) $item->ticket_id;
}
continue;
}
}
}
}
}
$qry = "SELECT ticket_id FROM #__fss_ticket_field WHERE field_id = '" . FSSJ3Helper::getEscaped($db, $fieldid) . "' AND value LIKE '%" . FSSJ3Helper::getEscaped($db, $search) . "%'";
$db->setQuery($qry);
$data = $db->loadObjectList();
foreach ($data as $item) {
$id = (int) $item->ticket_id;
if ($id > 0) {
$ids[] = $id;
}
}
}
//"MATCH (question, answer) AGAINST ('" . $db->escape($search) . "')"
$query .= " AND ( t.id IN (" . implode(", ", $ids) . ") OR MATCH (t.title) AGAINST ('" . $db->escape($search) . "' {$mode}) OR t.reference LIKE '%" . $db->escape($search) . "%' ) ";
}
$order = FSS_Input::getCmd('order');
$order_dir = FSS_Input::getCmd('order_dir', 'asc');
$order_dir_allowed = array('asc', 'desc');
if (!in_array($order_dir, $order_dir_allowed)) {
$order_dir = 'asc';
}
$order_allowed = array('t.title', 'lastupdate', 'status', 'assigned', 'lastupdate', 'u.name');
if (!in_array($order, $order_allowed)) {
$order = '';
}
if ($order != "") {
$query .= " ORDER BY {$order} {$order_dir}";
} else {
$query .= " ORDER BY lastupdate DESC ";
}
$mainframe = JFactory::getApplication();
$limit = $mainframe->getUserStateFromRequest('global.list.limit_ticket', 'limit', FSS_Settings::Get('ticket_per_page'), 'int');
$limitstart = FSS_Input::getInt('limitstart');
$limitstart = $limit != 0 ? floor($limitstart / $limit) * $limit : 0;
$db->setQuery($query);
$db->query();
//echo $query . "<br>";
$count = $db->getNumRows();
$result['pagination'] = new JPaginationJs($count, $limitstart, $limit);
$db->setQuery($query, $limitstart, $limit);
$result['tickets'] = $db->loadObjectList();
foreach ($result['tickets'] as &$ticket) {
$fields = FSSCF::GetCustomFields($ticket->id, $ticket->prod_id, $ticket->ticket_dept_id);
$values = FSSCF::GetTicketValues($ticket->id, $ticket);
$ticket->fields = array();
foreach ($fields as &$field) {
$ticket->fields[$field['id']] = array();
$ticket->fields[$field['id']]['name'] = $field['description'];
$ticket->fields[$field['id']]['value'] = '';
if (isset($values[$field['id']])) {
$ticket->fields[$field['id']]['value'] = $values[$field['id']]['value'];
}
}
}
return $result;
}
function displayTicketList()
{
$this->getDBTime();
// load in data for search forms
$this->handlers = SupportUsers::getHandlers(false, false);
$this->products = SupportHelper::getProducts();
$this->statuss = SupportHelper::getStatuss();
$this->departments = SupportHelper::getDepartments();
$this->categories = SupportHelper::getCategories();
$this->priorities = SupportHelper::getPriorities();
$this->ticketgroups = SupportHelper::getTicketGroups();
$this->taglist = SupportHelper::getTags();
// load extra data for the list of tickets we have
$this->ticket_list->loadTags();
$this->ticket_list->loadAttachments();
$this->ticket_list->loadGroups();
$this->ticket_list->loadLockedUsers();
$this->ticket_list->loadCustomFields();
if (FSS_Settings::get('support_show_msg_counts')) {
$this->ticket_list->loadMessageCounts();
}
// load in custom fields
$this->customfields = FSSCF::GetAllCustomFields(true);
// set the list of tickets to this->tickets
$this->tickets = $this->ticket_list->tickets;
$session = JFactory::getSession();
$preview = FSS_Input::getInt('preview');
if ($preview == -1) {
$preview = "";
$session->clear('preview');
}
if ($preview == 1 || $session->Get('preview') == 1) {
$this->enablePreview();
}
if ($this->refresh == 2) {
include $this->snippet(JPATH_SITE . DS . 'components' . DS . 'com_fss' . DS . 'views' . DS . 'admin_support' . DS . 'snippet' . DS . '_ticket_list.php');
return;
} elseif ($this->refresh) {
ob_start();
include $this->snippet(JPATH_SITE . DS . 'components' . DS . 'com_fss' . DS . 'views' . DS . 'admin_support' . DS . 'snippet' . DS . '_ticket_list.php');
$contents = ob_get_clean();
$output = array();
$output['count'] = $this->count;
$output['tickets'] = $contents;
header("Content-Type: application/json");
echo json_encode($output);
return;
}
return $this->_display();
}
</td>
</tr>
<tr>
<td width="135" align="right" class="key">
<label for="section">
<?php
echo JText::_("Combine for users with");
?>
:
</label>
</td>
<td>
<select name="combine_with">
<option value="0">Dont Combine</option>
<?php
foreach (SupportHelper::getStatuss() as $status) {
?>
<?php
if ($status->id == $this->ticketstatus->id) {
continue;
}
?>
<option value="<?php
echo $status->id;
?>
" <?php
if ($this->ticketstatus->combine_with == $status->id) {
echo "selected";
}
?>
><?php
