function _buildQuery() { $db = JFactory::getDBO(); $query = ' SELECT k.id, k.title, k.body, k.ordering, k.published, c.title as cattitle, f.filecount, k.rating, k.ratingdetail, k.allprods, k.created, k.modified, k.views, k.access, k.language FROM #__fss_kb_art as k LEFT JOIN #__fss_kb_cat as c '; $query .= ' ON k.kb_cat_id = c.id '; $query .= ' LEFT JOIN (SELECT count(*) as filecount, kb_art_id FROM #__fss_kb_attach GROUP BY kb_art_id) as f ON k.id = f.kb_art_id '; $where = array(); if ($this->lists['search']) { $where[] = '(LOWER( k.title ) LIKE ' . $db->Quote('%' . FSSJ3Helper::getEscaped($db, $this->lists['search'], true) . '%', false) . ')'; } if ($this->lists['order'] == 'k.ordering') { $order = ' ORDER BY k.ordering ' . $this->lists['order_Dir']; } else { $order = ' ORDER BY ' . $this->lists['order'] . ' ' . $this->lists['order_Dir'] . ', k.ordering'; } if ($this->lists['kb_cat_id'] > 0) { $where[] = 'kb_cat_id = ' . $this->lists['kb_cat_id']; } if ($this->lists['prod_id'] > 0) { $where[] = "allprods = 1 OR k.id IN (SELECT kb_art_id FROM #__fss_kb_art_prod WHERE prod_id = '{$this->lists['prod_id']}')"; } if ($this->lists['ispublished'] > -1) { $where[] = 'k.published = ' . $this->lists['ispublished']; } FSSAdminHelper::LA_GetFilterState(); if (FSSAdminHelper::$filter_lang) { $where[] = "k.language = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_lang) . "'"; } if (FSSAdminHelper::$filter_access) { $where[] = "k.access = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_access) . "'"; } $where = count($where) ? ' WHERE ' . implode(' AND ', $where) : ''; $query .= $where . $order; return $query; }
function _buildQuery() { $db = JFactory::getDBO(); $query = ' SELECT c.id, c.title, c.ordering, c.published, c.description, c.image, c.parcatid, pc.title as parcattitle, c.access, c.language FROM #__fss_kb_cat as c '; $query .= " LEFT JOIN #__fss_kb_cat as pc on c.parcatid = pc.id "; $where = array(); if ($this->lists['search']) { $where[] = '(LOWER( c.title ) LIKE ' . $db->Quote('%' . FSSJ3Helper::getEscaped($db, $this->lists['search'], true) . '%', false) . ')'; } if ($this->lists['order'] == 'c.ordering') { $order = ' ORDER BY c.ordering ' . $this->lists['order_Dir']; } else { $order = ' ORDER BY ' . $this->lists['order'] . ' ' . $this->lists['order_Dir'] . ', c.ordering'; } if ($this->lists['ispublished'] > -1) { $where[] = 'c.published = ' . $this->lists['ispublished']; } FSSAdminHelper::LA_GetFilterState(); if (FSSAdminHelper::$filter_lang) { $where[] = "c.language = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_lang) . "'"; } if (FSSAdminHelper::$filter_access) { $where[] = "c.access = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_access) . "'"; } $where = count($where) ? ' WHERE ' . implode(' AND ', $where) : ''; $query .= $where . $order; return $query; }
function _buildQuery() { $db = JFactory::getDBO(); $query = ' SELECT * FROM #__fss_faq_cat '; $where = array(); if ($this->lists['search']) { $where[] = '(LOWER( title ) LIKE ' . $db->Quote('%' . FSSJ3Helper::getEscaped($db, $this->lists['search'], true) . '%', false) . ')'; } if ($this->lists['order'] == 'ordering') { $order = ' ORDER BY ordering ' . $this->lists['order_Dir']; } else { $order = ' ORDER BY ' . $this->lists['order'] . ' ' . $this->lists['order_Dir'] . ', ordering'; } if ($this->lists['ispublished'] > -1) { $where[] = 'published = ' . $this->lists['ispublished']; } FSSAdminHelper::LA_GetFilterState(); if (FSSAdminHelper::$filter_lang) { $where[] = "language = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_lang) . "'"; } if (FSSAdminHelper::$filter_access) { $where[] = "access = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_access) . "'"; } $where = count($where) ? ' WHERE ' . implode(' AND ', $where) : ''; $query .= $where . $order; return $query; }
function _buildQuery() { $db = JFactory::getDBO(); $query = ' SELECT c.id, c.title, c.ordering as ordering, c.published, c.description, c.image, c.inkb, c.insupport, c.intest, c.access, c.translation, c.category, c.subcat FROM #__fss_prod as c '; $where = array(); if ($this->lists['search']) { $where[] = '(LOWER( title ) LIKE ' . $db->Quote('%' . FSSJ3Helper::getEscaped($db, $this->lists['search'], true) . '%', false) . ')'; } if ($this->lists['order'] == 'c.ordering') { $order = ' ORDER BY c.ordering ' . $this->lists['order_Dir']; } else { $order = ' ORDER BY ' . $this->lists['order'] . ' ' . $this->lists['order_Dir'] . ', c.ordering'; } if ($this->lists['ispublished'] > -1) { $where[] = 'published = ' . $this->lists['ispublished']; } FSSAdminHelper::LA_GetFilterState(); /*if (FSSAdminHelper::$filter_lang) $where[] = "language = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_lang) . "'";*/ if (FSSAdminHelper::$filter_access) { $where[] = "access = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_access) . "'"; } $where = count($where) ? ' WHERE ' . implode(' AND ', $where) : ''; $query .= $where . $order; return $query; }
function _buildQuery() { $db = JFactory::getDBO(); $query = ' SELECT a.*, u.name, u.username FROM #__fss_announce as a '; $query .= ' LEFT JOIN #__users as u ON a.author = u.id '; $where = array(); if ($this->lists['search']) { $where[] = '(LOWER( title ) LIKE ' . $db->Quote('%' . FSSJ3Helper::getEscaped($db, $this->lists['search'], true) . '%', false) . ')'; } $order = ""; if ($this->lists['order']) { $order = ' ORDER BY ' . $this->lists['order'] . ' ' . $this->lists['order_Dir']; } if ($this->lists['ispublished'] > -1) { $where[] = 'published = ' . $this->lists['ispublished']; } FSSAdminHelper::LA_GetFilterState(); if (FSSAdminHelper::$filter_lang) { $where[] = "language = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_lang) . "'"; } if (FSSAdminHelper::$filter_access) { $where[] = "access = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$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 #__fss_faq_faq as f LEFT JOIN #__fss_faq_cat as c '; $query .= ' ON f.faq_cat_id = c.id '; $where = array(); if ($this->lists['search']) { $where[] = '(LOWER( question ) LIKE ' . $db->Quote('%' . FSSJ3Helper::getEscaped($db, $this->lists['search'], true) . '%', false) . ')'; } 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']; } FSSAdminHelper::LA_GetFilterState(); if (FSSAdminHelper::$filter_lang) { $where[] = "f.language = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_lang) . "'"; } if (FSSAdminHelper::$filter_access) { $where[] = "f.access = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_access) . "'"; } $where = count($where) ? ' WHERE ' . implode(' AND ', $where) : ''; $query .= $where . $order; //echo $query . "<br>"; return $query; }
static function LA_Filter($nolangs = false) { if (empty(FSSAdminHelper::$access_levels)) { FSSAdminHelper::LoadAccessLevels(); } if (!$nolangs && empty(FSSAdminHelper::$langs)) { FSSAdminHelper::LoadLanguages(); } if (empty(FSSAdminHelper::$filter_lang)) { FSSAdminHelper::LA_GetFilterState(); } $options = FSSAdminHelper::$access_levels; array_unshift($options, JHtml::_('select.option', 0, JText::_('JOPTION_SELECT_ACCESS'))); echo JHTML::_('select.genericlist', $options, 'fss_filter_access', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'value', 'text', FSSAdminHelper::$filter_access); if (!$nolangs) { $options = FSSAdminHelper::$langs; array_unshift($options, JHtml::_('select.option', '', JText::_('JOPTION_SELECT_LANGUAGE'))); echo JHTML::_('select.genericlist', $options, 'fss_filter_language', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'value', 'text', FSSAdminHelper::$filter_lang); } }