static function getDataList($sort, $key, $query, $translate = false) { if (!array_key_exists($key, self::$data_lists)) { $db = JFactory::getDBO(); //echo $query."<br>"; $db->setQuery($query); self::$data_lists[$key]['s'] = $db->loadObjectList(); self::$data_lists[$key]['i'] = array(); if ($translate) { FSS_Translate_Helper::Tr(self::$data_lists[$key]['s']); } foreach (self::$data_lists[$key]['s'] as $item) { self::$data_lists[$key]['i'][$item->id] = $item; } } if ($sort) { self::$data_lists[$key]['s']; } return self::$data_lists[$key]['i']; }
echo FSSRoute::_(''); // FIX LINK ?> " method="post" style="margin: 0px;"> <input type="hidden" name="what" value="statuschange"> <input type="hidden" name="new_status" value="<?php echo $this->ticket['sid']; ?> "> <select id='new_pri' name='new_pri' class="input-medium" style="margin: 0px; color: <?php echo $this->ticket['pcolor']; ?> " onchange="jQuery('#pri_change').submit();"> <?php FSS_Translate_Helper::Tr($this->pris); ?> <?php foreach ($this->pris as $pri) { ?> <option value='<?php echo $pri['id']; ?> ' style='color: <?php echo $pri['color']; ?> ' <?php if ($pri['id'] == $this->ticket['pid']) { echo "selected='selected'"; } ?>
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); }
function getFilters() { $html = array(); $db = JFactory::getDBO(); $document = JFactory::getDocument(); foreach ($this->filter as $filter) { if (isset($filter->type) && $filter->type == "daterange") { FSS_Helper::StylesAndJS(array('calendar')); $to = FSS_Input::getString("{$filter->name}_to", $this->getDateRangeTo($filter)); $from = FSS_Input::getString("{$filter->name}_from", $this->getDateRangeFrom($filter)); $html[] = "<div class='control-group'>"; $html[] = "<label class='control-label' for='{$filter->name}_from'>" . JText::_('FSS_FROM') . "</label>"; $html[] = "<div class='controls'>"; $html[] = "<input type='text' name='{$filter->name}_from' id='{$filter->name}_from' onclick=\"setSens_{$filter->name}('{$filter->name}_to', 'max');\">"; $html[] = "</div>"; $html[] = "</div>"; $html[] = "<div class='control-group'>"; $html[] = "<label class='control-label' for='{$filter->name}_to'>" . JText::_('FSS_TILL') . "</label>"; $html[] = "<div class='controls'>"; $html[] = "<input type='text' name='{$filter->name}_to' id='{$filter->name}_to' onclick=\"setSens_{$filter->name}('{$filter->name}_from', 'min');\">"; $html[] = "</div>"; $html[] = "</div>"; FSS_Translate_Helper::CalenderLocale(); $js = "\n\t\t\t\t\tvar cal_{$filter->name};\n\t\t\t\t\t\n\t\t\t\t\tjQuery(document).ready( function () {\n\t\t\t\t\t cal_{$filter->name} = new dhtmlXCalendarObject(['{$filter->name}_from', '{$filter->name}_to'], 'omega');\n\t\t\t\t\t\tcal_{$filter->name}.setDate('{$from}');\n\t\t\t\t\t\tcal_{$filter->name}.hideTime();\n\t\t\t\t\t\t// init values\n\t\t\t\t\t\tvar t = new Date();\n\t\t\t\t\t\tjQuery('#{$filter->name}_from').val('{$from}');\n\t\t\t\t\t\tjQuery('#{$filter->name}_to').val('{$to}');\n\t\t\t\t\t\t\n\t\t\t\t\t\tcal_{$filter->name}.attachEvent('onClick', function(d) {\n\t\t\t\t\t\t\tdocument.report_params.submit();\n\t\t\t\t\t\t});\n\n\t\t\t\t\t\tcal_{$filter->name}.loadUserLanguage('" . FSS_Translate_Helper::CalenderLocaleCode() . "');\n\t\t\t\t\t});\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\tfunction setSens_{$filter->name}(id, k) {\n\t\t\t\t\t\t// update range\n\t\t\t\t\t\tif (k == 'min') {\n\t\t\t\t\t\t\tcal_{$filter->name}.setSensitiveRange(jQuery('#'+id).val(), null);\n\t\t\t\t\t\t} else {\n\t\t\t\t\t\t\tcal_{$filter->name}.setSensitiveRange(null, jQuery('#'+id).val());\n\t\t\t\t\t\t}\n\t\t\t\t\t}\n\t\t\t\t\t"; $document->addScriptDeclaration($js); } elseif (isset($filter->type) && $filter->type == "date") { FSS_Helper::StylesAndJS(array('calendar')); FSS_Translate_Helper::CalenderLocale(); $to = FSS_Input::getString("{$filter->name}", $this->getDateRangeTo($filter)); $html[] = "<div class='control-group'>"; $html[] = "<label class='control-label' for='{$filter->name}'>" . JText::_($filter->title) . "</label>"; $html[] = "<div class='controls'>"; $html[] = "<input type='text' name='{$filter->name}' id='{$filter->name}' >"; $html[] = "</div>"; $html[] = "</div>"; $js = "\n\t\t\t\t\tvar cal_{$filter->name};\n\t\t\t\t\t\n\t\t\t\t\tjQuery(document).ready( function () {\n\t\t\t\t\t cal_{$filter->name} = new dhtmlXCalendarObject(['{$filter->name}'], 'omega');\n\t\t\t\t\t\tcal_{$filter->name}.setDate('{$from}');\n\t\t\t\t\t\tcal_{$filter->name}.hideTime();\n\t\t\t\t\t\t// init values\n\t\t\t\t\t\tvar t = new Date();\n\t\t\t\t\t\tjQuery('#{$filter->name}').val('{$to}');\n\t\t\t\t\t\t\n\t\t\t\t\t\tcal_{$filter->name}.attachEvent('onClick', function(d) {\n\t\t\t\t\t\t\tdocument.report_params.submit();\n\t\t\t\t\t\t});\n\t\t\t\t\t\tcal_{$filter->name}.loadUserLanguage('" . FSS_Translate_Helper::CalenderLocaleCode() . "');\n\n\t\t\t\t\t});\n\t\t\t\t\t"; $document->addScriptDeclaration($js); } else { if ($filter->type == "lookup") { // need to lookup the values from the db $qry = "SELECT {$filter->key} as `key`, {$filter->display} as display"; if (!empty($filter->translate)) { $qry .= ", translation "; } $qry .= " FROM {$filter->table}"; if (isset($filter->published) && $filter->published) { $qry .= " WHERE published = 1 "; } $qry .= " GROUP BY {$filter->order}"; $db->setQuery($qry); $data = $db->loadObjectList(); // translate any lookups for the display field if (!empty($filter->translate)) { FSS_Translate_Helper::Tr($data); $display = $filter->display; foreach ($data as &$item) { if (isset($item->{$display})) { $item->display = $item->{$display}; } } } $values = array(); $values[] = JHTML::_('select.option', '', JText::_($filter->header), 'key', 'display'); $values = array_merge($values, $data); $value = FSS_Input::getString('filter_' . $filter->name, isset($filter->default) ? $filter->default : ''); $html[] = "<div class='control-group'>"; $html[] = "<label class='control-label'>" . JText::_($filter->title) . "</label>"; $html[] = "<div class='controls'>"; $html[] = JHTML::_('select.genericlist', $values, 'filter_' . $filter->name, ' onchange="document.report_params.submit( );"', 'key', 'display', $value); $html[] = "</div>"; $html[] = "</div>"; } else { if ($filter->type == "datepresets") { $value = FSS_Input::getString('filter_' . $filter->name, isset($filter->default) ? $filter->default : ''); $html[] = "<div class='control-group'>"; $html[] = "<label class='control-label'>" . JText::_($filter->title) . "</label>"; $html[] = "<div class='controls'>"; $html[] = JHTML::_('select.genericlist', $filter->select, 'filter_' . $filter->name, ' fsjfield="' . $filter->title . '" onchange="fsj_datepreset(this);"', 'key', 'display', $value); $html[] = "</div>"; $html[] = "</div>"; } else { $value = FSS_Input::getString('filter_' . $filter->name, isset($filter->default) ? $filter->default : ''); $html[] = "<div class='control-group'>"; $html[] = "<label class='control-label'>" . JText::_($filter->title) . "</label>"; $html[] = "<div class='controls'>"; $html[] = JHTML::_('select.genericlist', $filter->select, 'filter_' . $filter->name, ' onchange="document.report_params.submit( );"', 'key', 'display', $value); $html[] = "</div>"; $html[] = "</div>"; } } } } foreach ($this->group as $group) { $html[] = "<div class='control-group'>"; $html[] = "<label class='control-label'>" . JText::_($group->title) . "</label>"; $html[] = "<div class='controls'>"; //$html[] = "<div style='float:left;padding:3px;height:60px;'>"; //if (isset($group->title)) // $html[] = "<div style='margin-top: 5px;margin-bottom: 6px;margin-left:3px;'><span class='label'>".$group->title . "</span></div>"; if ($group->type == "dategroup") { $value = FSS_Input::getString('group_' . $group->name, 'day'); $html[] = JHTML::_('select.genericlist', $group->select, 'group_' . $group->name, ' onchange="document.report_params.submit( );"', 'key', 'display', $value); } $html[] = "</div>"; $html[] = "</div>"; } return implode($html); }
} ?> <?php if (!FSS_Settings::get('support_next_prod_click')) { ?> <input class='btn btn-primary' type='submit' id='pickdept' value='<?php echo JText::_("NEXT"); ?> '> <?php } ?> </p> <?php FSS_Translate_Helper::Tr($this->depts); ?> <div id='dept_search_res' class="dept_search_res" style="clear:both;"> <?php include JPATH_SITE . DS . 'components' . DS . 'com_fss' . DS . 'views' . DS . 'ticket' . DS . 'tmpl' . DS . 'open_searchdept.php'; ?> </div> <p> <?php if ($this->prodid > 0) { ?> <?php if (FSS_Input::getInt('admincreate') > 0) { ?>
function GetItemData($itemids = null) { $db = JFactory::getDBO(); $qry = "SELECT {$this->field_id}, {$this->field_title}, translation FROM {$this->table} WHERE intest = 1 AND published = 1"; if ($itemids) { $ids = array(); foreach ($itemids as $id) { $ids[] = FSSJ3Helper::getEscaped($db, $id); } $qry .= " AND {$this->field_id} IN (" . implode(", ", $ids) . ")"; } $qry .= " ORDER BY ordering "; $db->setQuery($qry); $this->itemdata = $db->loadAssocList($this->field_id); FSS_Translate_Helper::Tr($this->itemdata); }
function &getAppliesTo() { $db = JFactory::getDBO(); $kbartid = FSS_Input::getInt('kbartid'); $query = "SELECT p.* FROM #__fss_kb_art_prod as ap LEFT JOIN #__fss_prod as p ON ap.prod_id = p.id WHERE p.published = 1 AND p.inkb = 1 AND ap.kb_art_id = " . FSSJ3Helper::getEscaped($db, $kbartid); $query .= ' AND p.access IN (' . implode(',', JFactory::getUser()->getAuthorisedViewLevels()) . ')'; $db->setQuery($query); $rows = $db->loadAssocList(); FSS_Translate_Helper::Tr($rows); if ($this->_art['allprods'] > 0) { $allprod = array(); $allprod['title'] = JText::_("ALL_PRODUCTS"); $rows[] = $allprod; } return $rows; }
function display($tpl = null) { $mainframe = JFactory::getApplication(); $aparams = $mainframe->getPageParameters('com_fss'); $this->template = $aparams->get('template'); if ($this->template == "") { $this->template = "grid"; } $this->show_desc = $aparams->get('show_desc'); $this->mainwidth = $aparams->get('mainwidth'); $this->maincolums = $aparams->get('maincolums'); if ($this->maincolums == 0 || $this->maincolums == "") { $this->maincolums = 3; } $this->hideicons = $aparams->get('hideicons'); $this->imagewidth = $aparams->get('imagewidth'); if ($this->imagewidth == 0 || $this->imagewidth == "") { $this->imagewidth = 128; } $this->imageheight = $aparams->get('imageheight'); if ($this->imageheight == 0 || $this->imageheight == "") { $this->imageheight = 128; } $this->border = $aparams->get('border'); $this->info_top = $aparams->get('info_top'); $this->info_well = $aparams->get('info_well'); if ($this->info_top === null) { $this->info_top = 1; } if ($this->info_well === null) { $this->info_well = 1; } $db = JFactory::getDBO(); $query = 'SELECT * FROM #__menu'; $db->setQuery($query); $this->joomlamenus = $db->loadAssocList('id'); // work out permissions, and if to show admin or not $showadmin = false; $showgroups = false; if (FSS_Permission::AnyAdmin()) { $showadmin = true; } if (FSS_Permission::AdminGroups()) { $showgroups = true; } $this->showadmin = $showadmin; if ($showadmin) { $this->getSupportOverView(); } $query = 'SELECT * FROM #__fss_main_menu '; $where = array(); if (!$showadmin) { $where[] = 'itemtype != 9'; } if (!$showgroups) { $where[] = 'itemtype != 10'; } // add language and access to query where $where[] = 'language in (' . $db->Quote(JFactory::getLanguage()->getTag()) . ',' . $db->Quote('*') . ')'; $user = JFactory::getUser(); $where[] = 'access IN (' . implode(',', $user->getAuthorisedViewLevels()) . ')'; $where[] = "published = 1"; if (count($where) > 0) { $query .= " WHERE " . implode(" AND ", $where); } $query .= " ORDER BY ordering"; $db->setQuery($query); $this->menus = $db->loadAssocList('id'); FSS_Translate_Helper::Tr($this->menus); $this->ValidateMenuLinks(); parent::display(); }
function getDepartments() { // if data hasn't already been obtained, load it if (empty($this->_departments)) { $query = $this->_buildDeptQuery(); if (FSS_Settings::get('support_advanced_department') == 1) { $this->_db->setQuery($query, $this->getState('limitstart'), $this->getState('limit_prod')); } else { $this->_db->setQuery($query); } $this->_departments = $this->_db->loadAssocList(); FSS_Translate_Helper::Tr($this->_departments); } return $this->_departments; }
function displayAllProducts() { $this->products = $this->get('Products'); if (!is_array($this->products)) { $this->products = array(); } FSS_Translate_Helper::Tr($this->products); $this->showresult = 1; $mainframe = JFactory::getApplication(); $pathway = $mainframe->getPathway(); if (FSS_Helper::NeedBaseBreadcrumb($pathway, array('view' => 'test'))) { $pathway->addItem(JText::_('TESTIMONIALS'), FSSRoute::_('index.php?option=com_fss&view=test')); } if (FSS_Settings::get('test_allow_no_product')) { $noproduct = array(); $noproduct['id'] = 0; $noproduct['title'] = JText::_('GENERAL_TESTIMONIALS'); $noproduct['description'] = ''; $noproduct['image'] = '/components/com_fss/assets/images/generaltests.png'; $this->products = array_merge(array($noproduct), $this->products); } if ($this->test_show_prod_mode != "list") { $idlist = array(); if (count($this->products) > 0) { foreach ($this->products as &$prod) { $prod['comments'] = array(); $idlist[] = $prod['id']; } } // not in normal list mode, get comments for each product $this->comments->itemid = $idlist; $this->comments->GetComments(); foreach ($this->comments->_data as &$data) { if ($data['itemid'] > 0) { $this->products[$data['itemid']]['comments'][] = $data; } } } parent::display(); }
static function &GetAllCustomFields($values = true) { $values = true; $db = JFactory::getDBO(); if (empty(FSSCF::$allfields)) { // get a list of all available fields $qry = "SELECT * FROM #__fss_field as f WHERE f.published = 1 AND f.ident = 0 "; $qry .= " ORDER BY f.grouping, f.ordering "; $db->setQuery($qry); $rows = $db->loadAssocList("id"); FSS_Translate_Helper::Tr($rows); $indexes = array(); if (count($rows) > 0) { foreach ($rows as $index => &$row) { $indexes[] = FSSJ3Helper::getEscaped($db, $index); } } if ($values) { $indexlist = implode(",", $indexes); if (count($indexes) == 0) { $indexlist = "0"; } $qry = "SELECT * FROM #__fss_field_values WHERE field_id IN ({$indexlist})"; $db->setQuery($qry); $values = $db->loadAssocList(); if (count($values) > 0) { foreach ($values as &$value) { $field_id = $value['field_id']; $rows[$field_id]['values'][] = $value['value']; if ($value['data']) { $rows[$field_id]['values'][] = 'plugindata=' . $value['data']; } } } } FSSCF::$allfields = $rows; } return FSSCF::$allfields; }
require JModuleHelper::getLayoutPath('mod_fss_catprods', 'faqcat'); } else { if ($listtype == 'kbprod') { $query = "SELECT * FROM #__fss_prod"; $where = array(); $where[] = "published = 1"; $where[] = "inkb = 1"; $user = JFactory::getUser(); $where[] = 'access IN (' . implode(',', $user->getAuthorisedViewLevels()) . ')'; if (count($where) > 0) { $query .= " WHERE " . implode(" AND ", $where); } $query .= " ORDER BY ordering"; $db->setQuery($query); $rows = $db->loadAssocList(); FSS_Translate_Helper::Tr($rows); require JModuleHelper::getLayoutPath('mod_fss_catprods', 'kbprod'); } else { if ($listtype == 'kbcats') { $prodid = $params->get('prodid'); if ($prodid == -1) { $prodid = FSS_Input::getInt('prodid'); } if ($prodid > 0) { $qry1 = "SELECT a.kb_cat_id FROM #__fss_kb_art as a LEFT JOIN #__fss_kb_art_prod as p ON a.id = p.kb_art_id WHERE p.prod_id = '" . FSSJ3Helper::getEscaped($db, $prodid) . "' AND published = 1 GROUP BY a.kb_cat_id"; $qry2 = "SELECT a.kb_cat_id FROM #__fss_kb_art as a WHERE a.allprods = '1' AND published = 1 GROUP BY a.kb_cat_id"; $query = "({$qry1}) UNION ({$qry2})"; $db->setQuery($query); $rows = $db->loadAssocList('kb_cat_id'); $catids = array(); foreach ($rows as &$rows) {
static function HelpText($ident, $return = false) { if (empty(self::$help_texts)) { $db = JFactory::getDBO(); $qry = "SELECT * FROM #__fss_help_text WHERE published = 1"; $db->setquery($qry); self::$help_texts = $db->loadObjectList("identifier"); FSS_Translate_Helper::Tr(self::$help_texts); } if (!array_key_exists($ident, self::$help_texts)) { return ""; } if ($return) { return self::$help_texts[$ident]->message; } echo self::$help_texts[$ident]->message; }
<a href='<?php echo strpos($tab->link, 'index.php') === FALSE ? $tab->link : FSSRoute::_($tab->link); ?> '> <?php echo $tab->tabname; ?> </a> </li> <?php } ?> <?php $nottabs = FSS_Ticket_Helper::GetStatuss("own_tab", true); FSS_Translate_Helper::Tr($nottabs); $showother = count($nottabs) > 0; if ($showother || !FSS_Settings::get('support_tabs_allopen') || !FSS_Settings::get('support_tabs_allclosed') || !FSS_Settings::get('support_tabs_all')) { ?> <!-- <li class="dropdown"> <a class="dropdown-toggle" data-toggle="dropdown" href="#" onclick="return false;"> <?php echo JText::_('OTHER'); ?> <b class="caret bottom-up"></b> </a> <ul class="dropdown-menu bottom-up pull-left"> <?php foreach ($nottabs as $tab) {
**/ defined('_JEXEC') or die; require_once JPATH_SITE . DS . 'components' . DS . 'com_fss' . DS . 'helper' . DS . 'translate.php'; require_once JPATH_SITE . DS . 'components' . DS . 'com_fss' . DS . 'helper' . DS . 'support_tickets.php'; require_once JPATH_SITE . DS . 'components' . DS . 'com_fss' . DS . 'helper' . DS . 'support_source.php'; ?> <?php echo FSS_Helper::PageSubTitle("<a href='" . FSSRoute::_('index.php?option=com_fss&view=admin_support') . "'><img src='" . JURI::root(true) . "/components/com_fss/assets/images/support/support_24.png'> " . JText::_("SUPPORT_TICKETS") . "</a>", false); ?> <ul> <?php FSS_Ticket_Helper::GetStatusList(); $counts = SupportTickets::getTicketCount(); FSS_Translate_Helper::Tr(FSS_Ticket_Helper::$status_list); foreach (FSS_Ticket_Helper::$status_list as $status) { if ($status->def_archive) { continue; } if ($status->is_closed) { continue; } if (!array_key_exists($status->id, $counts)) { continue; } if ($counts[$status->id] < 1) { continue; } echo "<li>" . $status->title . ": <b>" . $counts[$status->id] . "</b> - <a href='" . FSSRoute::_('index.php?option=com_fss&view=admin_support&tickets=' . $status->id) . "'>" . JText::_("VIEW_NOW") . "</a></li>"; }
<select name="support_default_priority"> <option value="" <?php if ($this->settings['support_default_priority'] == 0) { echo " SELECTED"; } ?> ><?php echo JText::_('support_default_priority_default'); ?> </option> <?php $db = JFactory::getDBO(); $qry = "SELECT * FROM #__fss_ticket_pri ORDER BY ordering"; $db->setQuery($qry); $pris = $db->loadObjectList(); FSS_Translate_Helper::Tr($pris); foreach ($pris as $pri) { ?> <option value="<?php echo $pri->id; ?> " <?php if ($this->settings['support_default_priority'] == $pri->id) { echo " SELECTED"; } ?> ><?php echo $pri->title; ?> </option> <?php