protected function _buildQueryOrder(KDatabaseQuery $query)
{
$state = $this->_state;
$direction = strtoupper($this->_state->direction);
$element = $this->getService('com://admin/cck.model.elements')->slug(str_replace('_', '-', $state->sort))->getItem();
if ($state->sort) {
$query->order('cck.cck_element_id = ' . $element->id, null);
$query->order('cck.value', $direction);
}
}
protected function _buildQueryOrder(KDatabaseQuery $query)
{
$sort = $this->_state->sort;
$direction = strtoupper($this->_state->direction);
if ($sort) {
$query->order($this->getTable()->mapColumns($sort), $direction);
}
if (array_key_exists('ordering', $this->getTable()->getColumns())) {
$query->order('category.title, tbl.ordering', 'ASC');
}
}
protected function _buildQueryOrder(KDatabaseQuery $query)
{
//We need to write a proper sort function first.
//$query->order('tbl.lft', 'ASC');
$query->order('path_ordering', 'ASC');
$order = $this->_state->order;
$direction = strtoupper($this->_state->direction);
if ($order) {
$query->order($order, $direction);
}
}
protected function _buildQueryOrder(KDatabaseQuery $query)
{
if ($this->_state->distinct && !empty($this->_state->column)) {
$query->order('package', 'asc');
} else {
parent::_buildQueryOrder($query);
}
}
protected function _buildQueryOrder(KDatabaseQuery $query)
{
$state = $this->_state;
$direction = strtoupper($state->direction);
if (is_bool($state->featured) && $state->featured == true) {
if ($this->_state->sort == 'ordering') {
$query->order('featured_ordering', $direction);
} else {
$query->order($this->_state->sort, $direction)->order('featured_ordering', 'ASC');
}
} else {
if ($this->_state->sort == 'ordering') {
$query->order('section_title', 'ASC')->order('category_title', 'ASC')->order('ordering', $direction);
} else {
$query->order($this->_state->sort, $direction)->order('section_title', 'ASC')->order('category_title', 'ASC')->order('ordering', 'ASC');
}
}
}
protected function _buildQueryOrder(KDatabaseQuery $query)
{
$nooku = KFactory::get('admin::com.nooku.model.nooku');
// Assemble the clause pieces
$order = $this->getState('order', 'tbl.table_name');
$direction = strtoupper($this->getState('direction', 'ASC'));
// Assemble the clause
switch ($order) {
case 'table_name':
$query->order('tbl.table_name', $direction);
$query->order('tbl.row_id', $direction);
$query->order('tbl.original', 'DESC');
break;
default:
if ($order) {
$query->order($order, $direction);
}
break;
}
}
protected function _buildQueryOrder(KDatabaseQuery $query)
{
$sort = $this->_state->sort ? $this->_state->sort : 'category';
$direction = strtoupper($this->_state->direction);
switch ($sort) {
case 'random':
$query->order('RAND()', 'ASC');
break;
case '0':
$query->order('tbl.sticky', 'DESC');
$query->order('tbl.ordering', 'ASC');
break;
case 'category':
$query->order('category', $direction);
$query->order('tbl.ordering', 'ASC');
break;
default:
$query->order($this->getTable()->mapColumns($sort), $direction);
}
}
protected function _buildQueryOrder(KDatabaseQuery $query)
{
$query->order('reference', 'ASC');
}
/**
* Builds a generic ORDER BY clasue based on the model's state
*/
protected function _buildQueryOrder(KDatabaseQuery $query)
{
$order = $this->getState('order');
$direction = strtoupper($this->getState('direction'));
if ($order) {
$query->order($order, $direction);
}
if (in_array('ordering', $this->getTable()->getColumns())) {
$query->order('ordering', 'ASC');
}
}
protected function _buildQueryOrder(KDatabaseQuery $query)
{
$query->order('tbl.name', 'ASC');
}
protected function _buildQueryOrder(KDatabaseQuery $query)
{
$query->order('tbl.revision', 'desc');
}
protected function _buildQueryOrder(KDatabaseQuery $query)
{
$sort = $this->_state->sort;
$direction = strtoupper($this->_state->direction);
if ($sort) {
$column = $this->getTable()->mapColumns($sort);
if (array_key_exists($column, $this->getTable()->getColumns())) {
$query->order($column, $direction);
}
}
}
protected function _buildQueryOrder(KDatabaseQuery $query)
{
$query->order('tbl.created', 'DESC');
}
protected function _buildQueryOrder(KDatabaseQuery $query)
{
if(!$this->_state->isUnique()) {
$query->order('tbl.lft', 'ASC');
}
}
protected function _buildQueryOrder(KDatabaseQuery $query)
{
$sort = $this->_state->sort;
$direction = strtoupper($this->_state->direction);
if (!$sort) {
//@TODO we no longer need this CONCAT part
//$query->select("CONCAT(tbl.path, tbl.ninjaboard_forum_id, '/') AS path_ordering");
$query->order('path_sort', 'asc');
} elseif ($sort) {
//Our model don't support DESC yet
//$query->order($sort, $direction);
$query->order($sort, 'asc');
}
}
protected function _buildQueryOrder(KDatabaseQuery $query)
{
$sort = $this->_state->sort;
$direction = strtoupper($this->_state->direction);
if ( $sort) {
$query->order($this->getTable()->mapColumns($sort), $direction);
}
if (empty($sort))
{
if ($this->_state->section == 'com_content'){
$query->order('sections.ordering','ASC');
}
}
$query->order('ordering', 'ASC');
}
/**
* @param KDatabaseQuery $query
*/
protected function _buildQueryOrder(KDatabaseQuery $query)
{
$sort = 'path';
$direction = 'ASC';
// If we are fetching the immediate children of a category we can sort however we want
if ($this->_state->level == 1 && !is_null($this->_state->parent_id) && $this->_state->sort !== 'custom') {
$sort = $this->_state->sort;
$direction = $this->_state->direction;
} elseif ($this->getTable()->hasBehavior('orderable') && in_array($this->_state->sort, array('title', 'created_on', 'custom'))) {
$sort = 'order_path';
}
$query->order($sort, $direction);
}
/**
* Builds a generic ORDER BY clasue based on the model's state
*/
protected function _buildQueryOrder(KDatabaseQuery $query)
{
$query->order('tbl.ordering', 'ASC')->order('title', 'ASC');
}
