/**
* Build the order part from the query.
*
* The first arg is the field to be ordered and the $order
* arg is the correspondent order (ASC|DESC)
*
* If the $reset is set to true, all previous order should be removed
*
* @param string $field
* @param string $order
* @param bool $reset
* @return Bvb_Grid_Source_Doctrine
*/
public function buildQueryOrder($field, $order, $reset = false)
{
if ($reset) {
$this->_query->removeDqlQueryPart('orderby');
}
$this->_query->addOrderBy($field . ' ' . $order);
return $this;
}
protected function tryToSortWithForeignColumn(Doctrine_Query $query, array $sort)
{
$table = $this->getDmModule()->getTable();
if ('integer' === dmArray::get($table->getColumnDefinition($sort[0]), 'type')) {
if ($table->isI18nColumn($sort[0])) {
$query->addOrderBy(sprintf('%s.%s %s', $query->getJoinAliasForRelationAlias($table->getComponentName(), 'Translation'), $sort[0], $sort[1]));
// Success, skip default sorting by local column
return;
} elseif ($relation = $table->getRelationHolder()->getLocalByColumnName($sort[0])) {
if ($relation instanceof Doctrine_Relation_LocalKey && ($foreignTable = $relation->getTable()) instanceof dmDoctrineTable) {
if (($foreignColumn = $foreignTable->getIdentifierColumnName()) != 'id') {
if (!($joinAlias = $query->getJoinAliasForRelationAlias($table->getComponentName(), $relation->getAlias()))) {
$query->leftJoin(sprintf('%s.%s %s', $query->getRootAlias(), $relation->getAlias(), $relation->getAlias()));
$joinAlias = $relation->getAlias();
if ($foreignTable->isI18nColumn($foreignColumn)) {
$query->leftJoin(sprintf('%s.%s %s', $joinAlias, 'Translation', $joinAlias . 'Translation'));
}
}
if ($foreignTable->isI18nColumn($foreignColumn)) {
$query->addOrderBy(sprintf('%s.%s %s', $joinAlias . 'Translation', $foreignColumn, $sort[1]));
} else {
$query->addOrderBy(sprintf('%s.%s %s', $joinAlias, $foreignColumn, $sort[1]));
}
// Success, skip default sorting by local column
return;
}
}
}
} elseif ($table->isI18nColumn($sort[0])) {
$query->addOrderBy(sprintf('%s.%s %s', $query->getJoinAliasForRelationAlias($table->getComponentName(), 'Translation'), $sort[0], $sort[1]));
// Success, skip default sorting by local column
return;
}
if ($table->hasField($sort[0])) {
$query->addOrderBy($sort[0] . ' ' . $sort[1]);
}
}
/**
* hookOrderBy
* builds DQL query orderby part from given parameter array
*
* @param array $params an array containing all fields which the built query
* should be ordered by
* @return boolean whether or not the hooking was successful
*/
public function hookOrderby($params)
{
if (!is_array($params)) {
return false;
}
foreach ($params as $name) {
$e = explode(' ', $name);
$order = 'ASC';
if (count($e) > 1) {
$order = $e[1] == 'DESC' ? 'DESC' : 'ASC';
}
$e = explode('.', $e[0]);
if (count($e) == 2) {
list($alias, $column) = $e;
$map = $this->query->getAliasDeclaration($alias);
$table = $map['table'];
if ($def = $table->getDefinitionOf($column)) {
$this->query->addOrderBy($alias . '.' . $column . ' ' . $order);
}
}
}
return true;
}
/**
* Add sort to Doctrine_Query.
*
* @param Doctrine_Query $q
* @param string $fld
* @param string $dir
*/
protected function rec_query_add_sort(Doctrine_Query $q, $fld, $dir)
{
$q->addOrderBy("{$fld} {$dir}");
}
/**
* Adds orderby option to the query on the <field_name>
*
* @param Doctrine_Query $q
*/
private function addOrderByPositionOption(Doctrine_Query $q, $table_alias = 't', $filed_name = 'position')
{
$q->addOrderBy($table_alias . '.' . $filed_name);
}
protected function addSortQuery(Doctrine_Query $query)
{
$sort = $this->getSort();
if ($sort) {
$query->addOrderBy(sprintf("%s %s", $sort[0], $sort[1]));
}
}
/**
* Handle custom sorters
*
* @param Doctrine_Query $q
* @param string $fld
* @param string $dir
*/
protected function rec_query_add_sort(Doctrine_Query $q, $fld, $dir)
{
if ($fld == 'cre_username') {
$q->addOrderBy("cu.user_username {$dir}");
} elseif ($fld == 'upd_username') {
$q->addOrderBy("uu.user_username {$dir}");
} else {
parent::rec_query_add_sort($q, $fld, $dir);
}
}
/**
* Add sort query
*
* @param Doctrine_Query $q
* @return void
*/
protected function addSortQuery($q)
{
$q->addOrderBy('root_id, lft');
}
