/** * Order the result by the given column * * @param string $columnOrAlias The column or column alias to order by * @param int $dir The sort direction or null to use default direction * * @return $this Fluent interface */ public function order($columnOrAlias, $dir = null) { $this->requireColumn($columnOrAlias); $this->orderColumns[$columnOrAlias] = $columnOrAlias; if ($this->isCustomvar($columnOrAlias)) { $columnOrAlias = $this->getCustomvarColumnName($columnOrAlias); } elseif ($this->hasAliasName($columnOrAlias)) { $columnOrAlias = $this->aliasToColumnName($columnOrAlias); } else { Logger::info('Can\'t order by column ' . $columnOrAlias); return $this; } return parent::order($columnOrAlias, $dir); }
/** * Order the result by the given alias * * @param string $alias The column alias to order by * @param int $dir The sort direction or null to use the default direction * * @return $this */ public function order($alias, $dir = null) { $this->requireColumn($alias); if ($this->isCustomvar($alias)) { $column = $this->getCustomvarColumnName($alias); } elseif ($this->hasAliasName($alias)) { $column = $this->aliasToColumnName($alias); $table = $this->aliasToTableName($alias); if (isset($this->caseInsensitiveColumns[$table][$alias])) { $column = 'LOWER(' . $column . ')'; } } else { Logger::info('Can\'t order by column ' . $alias); return $this; } $this->orderColumns[] = $alias; return parent::order($column, $dir); }