class QueryAggregate in Drupal 8
Same name in this branch
- 8 core/modules/workspaces/src/EntityQuery/QueryAggregate.php \Drupal\workspaces\EntityQuery\QueryAggregate
- 8 core/lib/Drupal/Core/Entity/Query/Sql/QueryAggregate.php \Drupal\Core\Entity\Query\Sql\QueryAggregate
Same name and namespace in other branches
- 9 core/lib/Drupal/Core/Entity/Query/Sql/QueryAggregate.php \Drupal\Core\Entity\Query\Sql\QueryAggregate
- 10 core/lib/Drupal/Core/Entity/Query/Sql/QueryAggregate.php \Drupal\Core\Entity\Query\Sql\QueryAggregate
The SQL storage entity query aggregate class.
Hierarchy
- class \Drupal\Core\Entity\Query\QueryBase implements QueryInterface
- class \Drupal\Core\Entity\Query\Sql\Query implements QueryInterface
- class \Drupal\Core\Entity\Query\Sql\QueryAggregate implements QueryAggregateInterface
- class \Drupal\Core\Entity\Query\Sql\Query implements QueryInterface
Expanded class hierarchy of QueryAggregate
1 file declares its use of QueryAggregate
- QueryAggregate.php in core/
modules/ workspaces/ src/ EntityQuery/ QueryAggregate.php
3 string references to 'QueryAggregate'
- PgsqlQueryFactory::getAggregate in core/
modules/ workspaces/ src/ EntityQuery/ PgsqlQueryFactory.php - Instantiates an aggregation query object for a given entity type.
- QueryFactory::getAggregate in core/
modules/ workspaces/ src/ EntityQuery/ QueryFactory.php - Instantiates an aggregation query object for a given entity type.
- QueryFactory::getAggregate in core/
lib/ Drupal/ Core/ Entity/ Query/ Sql/ QueryFactory.php - Instantiates an aggregation query object for a given entity type.
File
- core/
lib/ Drupal/ Core/ Entity/ Query/ Sql/ QueryAggregate.php, line 10
Namespace
Drupal\Core\Entity\Query\SqlView source
class QueryAggregate extends Query implements QueryAggregateInterface {
/**
* Stores the sql expressions used to build the sql query.
*
* @var array
* An array of expressions.
*/
protected $sqlExpressions = [];
/**
* {@inheritdoc}
*/
public function execute() {
return $this
->prepare()
->addAggregate()
->compile()
->compileAggregate()
->addGroupBy()
->addSort()
->addSortAggregate()
->finish()
->result();
}
/**
* {@inheritdoc}
*/
public function prepare() {
parent::prepare();
// Throw away the id fields.
$this->sqlFields = [];
return $this;
}
/**
* {@inheritdoc}
*/
public function conditionAggregateGroupFactory($conjunction = 'AND') {
$class = static::getClass($this->namespaces, 'ConditionAggregate');
return new $class($conjunction, $this, $this->namespaces);
}
/**
* {@inheritdoc}
*/
public function existsAggregate($field, $function, $langcode = NULL) {
return $this->conditionAggregate
->exists($field, $function, $langcode);
}
/**
* {@inheritdoc}
*/
public function notExistsAggregate($field, $function, $langcode = NULL) {
return $this->conditionAggregate
->notExists($field, $function, $langcode);
}
/**
* Adds the aggregations to the query.
*
* @return $this
* Returns the called object.
*/
protected function addAggregate() {
if ($this->aggregate) {
foreach ($this->aggregate as $aggregate) {
$sql_field = $this
->getSqlField($aggregate['field'], $aggregate['langcode']);
$this->sqlExpressions[$aggregate['alias']] = $aggregate['function'] . "({$sql_field})";
}
}
return $this;
}
/**
* Builds the aggregation conditions part of the query.
*
* @return $this
* Returns the called object.
*/
protected function compileAggregate() {
$this->conditionAggregate
->compile($this->sqlQuery);
return $this;
}
/**
* Adds the groupby values to the actual query.
*
* @return $this
* Returns the called object.
*/
protected function addGroupBy() {
foreach ($this->groupBy as $group_by) {
$field = $group_by['field'];
$sql_field = $this
->getSqlField($field, $group_by['langcode']);
$this->sqlGroupBy[$sql_field] = $sql_field;
list($table, $real_sql_field) = explode('.', $sql_field);
$this->sqlFields[$sql_field] = [
$table,
$real_sql_field,
$this
->createSqlAlias($field, $real_sql_field),
];
}
return $this;
}
/**
* Builds the aggregation sort part of the query.
*
* @return $this
* Returns the called object.
*/
protected function addSortAggregate() {
if (!$this->count) {
foreach ($this->sortAggregate as $alias => $sort) {
$this->sqlQuery
->orderBy($alias, $sort['direction']);
}
}
return $this;
}
/**
* Overrides \Drupal\Core\Entity\Query\Sql\Query::finish().
*
* Adds the sql expressions to the query.
*/
protected function finish() {
foreach ($this->sqlExpressions as $alias => $expression) {
$this->sqlQuery
->addExpression($expression, $alias);
}
return parent::finish();
}
/**
* Builds a sql alias as expected in the result.
*
* @param string $field
* The field as passed in by the caller.
* @param string $sql_field
* The sql field as returned by getSqlField.
*
* @return string
* The SQL alias expected in the return value. The dots in $sql_field are
* replaced with underscores and if a default fallback to .value happened,
* the _value is stripped.
*/
public function createSqlAlias($field, $sql_field) {
$alias = str_replace('.', '_', $sql_field);
// If the alias contains of field_*_value remove the _value at the end.
if (substr($alias, 0, 6) === 'field_' && substr($field, -6) !== '_value' && substr($alias, -6) === '_value') {
$alias = substr($alias, 0, -6);
}
return $alias;
}
/**
* Overrides \Drupal\Core\Entity\Query\Sql\Query::result().
*
* @return array|int
* Returns the aggregated result, or a number if it's a count query.
*/
protected function result() {
if ($this->count) {
return parent::result();
}
$return = [];
foreach ($this->sqlQuery
->execute() as $row) {
$return[] = (array) $row;
}
return $return;
}
}
Members
Name | Modifiers | Type | Description | Overrides |
---|---|---|---|---|
Query:: |
protected | property | ||
Query:: |
protected | property | An array of fields keyed by the field alias. | |
Query:: |
protected | property | An array of strings added as to the group by, keyed by the string to avoid duplicates. | |
Query:: |
protected | property | The build sql select query. | |
Query:: |
protected | property | The Tables object for this query. | |
Query:: |
protected | function | Adds the sort to the build query. | |
Query:: |
protected | function | Compiles the conditions. | |
Query:: |
protected | function | Constructs a select expression for a given field and language. | |
Query:: |
public | function | Gets the Tables object for this query. | |
Query:: |
protected | function | Determines whether the query requires GROUP BY and ORDER BY MIN/MAX. | |
Query:: |
public | function |
Implements the magic __clone method. Overrides QueryBase:: |
|
Query:: |
public | function |
Constructs a query object. Overrides QueryBase:: |
|
Query:: |
public | function | Implements the magic __toString method. | |
QueryAggregate:: |
protected | property | Stores the sql expressions used to build the sql query. | |
QueryAggregate:: |
protected | function | Adds the aggregations to the query. | |
QueryAggregate:: |
protected | function | Adds the groupby values to the actual query. | |
QueryAggregate:: |
protected | function | Builds the aggregation sort part of the query. | |
QueryAggregate:: |
protected | function | Builds the aggregation conditions part of the query. | |
QueryAggregate:: |
public | function |
Creates an object holding a group of conditions. Overrides QueryAggregateInterface:: |
|
QueryAggregate:: |
public | function | Builds a sql alias as expected in the result. | |
QueryAggregate:: |
public | function |
Execute the query. Overrides Query:: |
|
QueryAggregate:: |
public | function |
Queries for the existence of a field. Overrides QueryAggregateInterface:: |
|
QueryAggregate:: |
protected | function |
Overrides \Drupal\Core\Entity\Query\Sql\Query::finish(). Overrides Query:: |
|
QueryAggregate:: |
public | function |
Queries for the nonexistence of a field. Overrides QueryAggregateInterface:: |
|
QueryAggregate:: |
public | function |
Prepares the basic query with proper metadata/tags and base fields. Overrides Query:: |
1 |
QueryAggregate:: |
protected | function |
Overrides \Drupal\Core\Entity\Query\Sql\Query::result(). Overrides Query:: |
|
QueryBase:: |
protected | property | Whether access check is requested or not. Defaults to TRUE. | |
QueryBase:: |
protected | property | The list of aggregate expressions. | |
QueryBase:: |
protected | property | Flag indicating whether to query the current revision or all revisions. | |
QueryBase:: |
protected | property | The query metadata for alter purposes. | |
QueryBase:: |
protected | property | The query tags. | |
QueryBase:: |
protected | property | Conditions. | 1 |
QueryBase:: |
protected | property | Aggregate Conditions | |
QueryBase:: |
protected | property | TRUE if this is a count query, FALSE if it isn't. | |
QueryBase:: |
protected | property | Information about the entity type. | 1 |
QueryBase:: |
protected | property | The entity type this query runs against. | |
QueryBase:: |
protected | property | The list of columns to group on. | |
QueryBase:: |
protected | property | Flag indicating whether to query the latest revision. | |
QueryBase:: |
protected | property | List of potential namespaces of the classes belonging to this query. | |
QueryBase:: |
protected | property | The query pager data. | |
QueryBase:: |
protected | property | The query range. | |
QueryBase:: |
protected | property | The list of sorts. | |
QueryBase:: |
protected | property | The list of sorts over the aggregate results. | |
QueryBase:: |
public | function |
Overrides QueryInterface:: |
|
QueryBase:: |
public | function |
Adds additional metadata to the query. Overrides AlterableInterface:: |
|
QueryBase:: |
public | function |
Adds a tag to a query. Overrides AlterableInterface:: |
|
QueryBase:: |
public | function | ||
QueryBase:: |
public | function |
Queries all the revisions. Overrides QueryInterface:: |
|
QueryBase:: |
public | function |
Creates a new group of conditions ANDed together. Overrides QueryInterface:: |
|
QueryBase:: |
public | function |
Add a condition to the query or a condition group. Overrides QueryInterface:: |
1 |
QueryBase:: |
public | function | ||
QueryBase:: |
protected | function | Creates an object holding a group of conditions. | |
QueryBase:: |
public | function |
Makes this a count query. Overrides QueryInterface:: |
|
QueryBase:: |
public | function |
Queries the current revision. Overrides QueryInterface:: |
|
QueryBase:: |
public | function |
Queries for a non-empty value on a field. Overrides QueryInterface:: |
|
QueryBase:: |
protected | function | Generates an alias for a field and its aggregated function. | |
QueryBase:: |
public static | function | Finds a class in a list of namespaces. | |
QueryBase:: |
public | function |
Gets the ID of the entity type for this query. Overrides QueryInterface:: |
|
QueryBase:: |
public | function |
Retrieves a given piece of metadata. Overrides AlterableInterface:: |
|
QueryBase:: |
public static | function | Gets a list of namespaces of the ancestors of a class. | |
QueryBase:: |
public | function | ||
QueryBase:: |
public | function |
Determines if a given query has all specified tags. Overrides AlterableInterface:: |
|
QueryBase:: |
public | function |
Determines if a given query has any specified tag. Overrides AlterableInterface:: |
|
QueryBase:: |
public | function |
Determines if a given query has a given tag. Overrides AlterableInterface:: |
|
QueryBase:: |
protected | function | Gets the total number of results and initialize a pager for the query. | |
QueryBase:: |
public | function |
Queries the latest revision. Overrides QueryInterface:: |
|
QueryBase:: |
public | function |
Queries for an empty field. Overrides QueryInterface:: |
|
QueryBase:: |
public | function |
Creates a new group of conditions ORed together. Overrides QueryInterface:: |
|
QueryBase:: |
public | function |
Enables a pager for the query. Overrides QueryInterface:: |
|
QueryBase:: |
public | function |
Overrides QueryInterface:: |
|
QueryBase:: |
public | function |
Overrides QueryInterface:: |
|
QueryBase:: |
public | function | ||
QueryBase:: |
public | function |
Enables sortable tables for this query. Overrides QueryInterface:: |