/**
* Method to build the query WHERE segment
*
* @access protected
* @param null
* @return string
*/
protected function buildQueryWhere()
{
$category_id = (int) $this->getFilter('category_id');
if ($category_id > 0) {
$this->addWhere('item.id IN (SELECT `id` FROM `#__simplelists_categories` WHERE `category_id`=' . $category_id . ')');
}
$link_type = $this->getFilter('link_type');
if (!empty($link_type)) {
$this->addWhere('item.link_type =' . $this->_db->Quote($link_type));
}
return parent::buildQueryWhere();
}
/**
* Method to build the query WHERE segment
*
* @access protected
* @param null
* @return string
*/
protected function buildQueryWhere()
{
$this->addWhere('plugin.type = "plugin"');
$this->addWhere('plugin.folder = "simplelistslink"');
return parent::buildQueryWhere();
}
/**
* Method to build the query WHERE segment
*
* @access protected
* @param null
* @return string
*/
protected function buildQueryWhere()
{
if (YireoHelper::isJoomla15()) {
$this->addWhere('`category`.`section`="com_simplelists"');
} else {
$this->addWhere('`category`.`extension`="com_simplelists"');
}
if ($this->_parent_id > 0) {
$this->addWhere('`category`.`parent_id`=' . (int) $this->_parent_id);
}
return parent::buildQueryWhere();
}
/**
* Method to build the query WHERE segment
*
* @access protected
* @param null
* @return string
*/
protected function buildQueryWhere()
{
$this->addWhere('category.published = 1');
// Apply the category-filter
$category_id = (int) $this->getId();
if ($category_id > 0) {
$this->addWhere('relation.category_id = ' . $category_id);
}
// Apply the character-filter
if ($this->getState('no_char_filter') != 1) {
$character = JRequest::getCmd('char');
if (!empty($character) && preg_match('/^([a-z]{1})$/', $character)) {
$this->addWhere('item.title LIKE ' . $this->_db->Quote($character . '%'));
}
}
return parent::buildQueryWhere();
}