EntitySortByClause.php

Go to the documentation of this file.

<?php
 
namespace Elgg\Database\Clauses;
 
use Elgg\Database\AnnotationsTable;
use Elgg\Database\EntityTable;
use Elgg\Database\MetadataTable;
use Elgg\Database\QueryBuilder;
use Elgg\Database\RelationshipsTable;
use Elgg\Exceptions\DomainException;
 
class EntitySortByClause extends OrderByClause {
 
    public $property;
 
    public $signed;
 
    public $join_type;
 
    public $property_type;
    
    public $inverse_relationship;
    
    public $relationship_guid;
 
    public function prepare(QueryBuilder $qb, $table_alias = null) {
 
        if (!isset($this->property_type)) {
            if (in_array($this->property, \ElggEntity::PRIMARY_ATTR_NAMES)) {
                $this->property_type = 'attribute';
            } else {
                $this->property_type = 'metadata';
            }
        }
        
        // get correct base GUID column
        // default assumes the main table is 'entities'
        $from_column = 'guid';
        switch ($qb->getTableName()) {
            case AnnotationsTable::TABLE_NAME:
            case MetadataTable::TABLE_NAME:
                $from_column = 'entity_guid';
                break;
            case RelationshipsTable::TABLE_NAME:
                $from_column = 'guid_one';
                if ((bool) $this->inverse_relationship) {
                    $from_column = 'guid_two';
                }
                break;
        }
 
        switch ($this->property_type) {
            case 'metadata':
                $md_alias = $qb->joinMetadataTable($table_alias, $from_column, $this->property, $this->join_type);
                $column = "{$md_alias}.value";
                break;
 
            case 'attribute':
                if (!in_array($this->property, \ElggEntity::PRIMARY_ATTR_NAMES)) {
                    throw new DomainException("'{$this->property}' is not a valid entity attribute");
                }
                
                if ($qb->getTableName() !== EntityTable::TABLE_NAME) {
                    $e_alias = $qb->joinEntitiesTable($table_alias, $from_column, $this->join_type);
                } else {
                    $e_alias = $table_alias;
                }
                
                $column = "{$e_alias}.{$this->property}";
                break;
 
            case 'annotation':
                $an_alias = $qb->joinAnnotationTable($table_alias, $from_column, $this->property, $this->join_type);
                $column = "{$an_alias}.value";
                break;
 
            case 'relationship':
                if ($qb->getTableName() !== RelationshipsTable::TABLE_NAME) {
                    $inverse = (bool) $this->inverse_relationship;
                    $er_alias = $qb->joinRelationshipTable($table_alias, $from_column, $this->property, $inverse, $this->join_type);
                    if (!empty($this->relationship_guid)) {
                        $guid_column = $inverse ? 'guid_two' : 'guid_one';
                        $qb->andWhere($qb->compare("{$er_alias}.{$guid_column}", '=', $this->relationship_guid, ELGG_VALUE_GUID));
                    }
                } else {
                    $er_alias = $table_alias;
                }
                
                $column = "{$er_alias}.time_created";
                
                break;
 
            default:
                elgg_log("'{$this->property_type}' is not a valid entity property type. Sorting ignored.");
                return null;
        }
 
        if ($this->signed) {
            $column = "CAST({$column} AS SIGNED)";
        }
 
        $this->expr = $column;
 
        parent::prepare($qb, $table_alias);
    }
}