function _buildQuery() { $db =& JFactory::getDBO(); $query = ' SELECT id, word, description, published, access, language FROM #__fsf_glossary '; $where = array(); if ($this->lists['search']) { $where[] = '(LOWER( word ) LIKE ' . $db->Quote('%' . FSFJ3Helper::getEscaped($db, $this->lists['search'], true) . '%', false) . ')'; } if ($this->lists['order'] == 'word') { $order = ' ORDER BY word ' . $this->lists['order_Dir']; } else { $order = ' ORDER BY ' . $this->lists['order'] . ' ' . $this->lists['order_Dir'] . ', word'; } if ($this->lists['ispublished'] > -1) { $where[] = 'published = ' . $this->lists['ispublished']; } if (FSFAdminHelper::Is16()) { FSFAdminHelper::LA_GetFilterState(); if (FSFAdminHelper::$filter_lang) { $where[] = "language = '" . FSFJ3Helper::getEscaped($db, FSFAdminHelper::$filter_lang) . "'"; } if (FSFAdminHelper::$filter_access) { $where[] = "access = '" . FSFJ3Helper::getEscaped($db, FSFAdminHelper::$filter_access) . "'"; } } $where = count($where) ? ' WHERE ' . implode(' AND ', $where) : ''; $query .= $where . $order; return $query; }
function _buildQuery() { $db =& JFactory::getDBO(); $query = ' SELECT f.id as id, question, answer, f.ordering as ordering, f.published as published, c.title as title, f.featured, f.access, f.language FROM #__fsf_faq_faq as f LEFT JOIN #__fsf_faq_cat as c '; $query .= ' ON f.faq_cat_id = c.id '; $where = array(); if ($this->lists['search']) { $where[] = '(LOWER( question ) LIKE ' . $db->Quote('%' . FSFJ3Helper::getEscaped($db, $this->lists['search'], true) . '%', false) . ')'; } if ($this->lists['order'] == "fsf_filter_access") { $this->lists['order'] = "f.access"; } if ($this->lists['order'] == "fsf_filter_language") { $this->lists['order'] = "f.language"; } if ($this->lists['order'] == 'f.ordering') { $order = ' ORDER BY f.ordering ' . $this->lists['order_Dir']; } else { $order = ' ORDER BY ' . $this->lists['order'] . ' ' . $this->lists['order_Dir'] . ', f.ordering'; } if ($this->lists['faq_cat_id'] > 0) { $where[] = 'faq_cat_id = ' . $this->lists['faq_cat_id']; } if ($this->lists['ispublished'] > -1) { $where[] = 'f.published = ' . $this->lists['ispublished']; } if (FSFAdminHelper::Is16()) { FSFAdminHelper::LA_GetFilterState(); if (FSFAdminHelper::$filter_lang) { $where[] = "f.language = '" . FSFJ3Helper::getEscaped($db, FSFAdminHelper::$filter_lang) . "'"; } if (FSFAdminHelper::$filter_access) { $where[] = "f.access = '" . FSFJ3Helper::getEscaped($db, FSFAdminHelper::$filter_access) . "'"; } } $where = count($where) ? ' WHERE ' . implode(' AND ', $where) : ''; $query .= $where . $order; return $query; }
static function LA_Filter($nolangs = false) { if (!FSFAdminHelper::Is16()) { return; } if (empty(FSFAdminHelper::$access_levels)) { FSFAdminHelper::LoadAccessLevels(); } if (!$nolangs && empty(FSFAdminHelper::$langs)) { FSFAdminHelper::LoadLanguages(); } if (empty(FSFAdminHelper::$filter_lang)) { FSFAdminHelper::LA_GetFilterState(); } $options = FSFAdminHelper::$access_levels; array_unshift($options, JHtml::_('select.option', 0, JText::_('JOPTION_SELECT_ACCESS'))); echo JHTML::_('select.genericlist', $options, 'fsf_filter_access', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'value', 'text', FSFAdminHelper::$filter_access); if (!$nolangs) { $options = FSFAdminHelper::$langs; array_unshift($options, JHtml::_('select.option', '', JText::_('JOPTION_SELECT_LANGUAGE'))); echo JHTML::_('select.genericlist', $options, 'fsf_filter_language', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'value', 'text', FSFAdminHelper::$filter_lang); } }