/** * Method to build the query ORDER BY segment * * @access protected * @subpackage Yireo * @param null * @return string */ protected function buildQueryOrderBy() { if (YireoHelper::isJoomla15()) { $default_ordering = 'ordering'; } else { $default_ordering = 'lft, rgt'; } $orderby = $this->params->get('cat_orderby', $default_ordering); if ($orderby == 'alpha') { $this->addOrderBy('`category`.`title` ASC'); } elseif ($orderby == 'ralpha') { $this->addOrderBy('`category`.`title` DESC'); } else { if ($orderby == 'ordering') { $orderby = $default_ordering; } $this->addOrderBy('`category`.' . $orderby); } return parent::buildQueryOrderBy(); }
/** * Method to build the query ORDER BY segment * * @access protected * @subpackage Yireo * @param null * @return string */ protected function buildQueryOrderBy() { $ordering = $this->params->get('orderby'); switch ($ordering) { case 'alpha': $orderby = 'item.title ASC'; break; case 'ralpha': $orderby = 'item.title DESC'; break; case 'date': $orderby = 'item.created DESC, item.modified DESC'; break; case 'rdate': $orderby = 'item.created ASC, item.modified ASC'; break; case 'random': $orderby = 'RAND()'; break; case 'rorder': $orderby = 'item.ordering DESC'; break; default: $orderby = 'item.ordering'; break; } $this->addOrderby($orderby); return parent::buildQueryOrderBy(); }