function SqlContentEntityStorage::countFieldData

File

core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php, line 1735

Class

SqlContentEntityStorage

A content entity database storage implementation.

Namespace

Code

public function countFieldData($storage_definition, $as_bool = FALSE) {
    // Ensure that the table mapping is instantiated with the passed-in field
    // storage definition.
    $storage_definitions = $this->fieldStorageDefinitions;
    $storage_definitions[$storage_definition->getName()] = $storage_definition;
    $table_mapping = $this->getTableMapping($storage_definitions);
    if ($table_mapping->requiresDedicatedTableStorage($storage_definition)) {
        $is_deleted = $storage_definition->isDeleted();
        if ($this->entityType
            ->isRevisionable()) {
            $table_name = $table_mapping->getDedicatedRevisionTableName($storage_definition, $is_deleted);
        }
        else {
            $table_name = $table_mapping->getDedicatedDataTableName($storage_definition, $is_deleted);
        }
        $query = $this->database
            ->select($table_name, 't');
        $or = $query->orConditionGroup();
        foreach ($storage_definition->getColumns() as $column_name => $data) {
            $or->isNotNull($table_mapping->getFieldColumnName($storage_definition, $column_name));
        }
        $query->condition($or);
        if (!$as_bool) {
            $query->fields('t', [
                'entity_id',
            ])
                ->distinct(TRUE);
        }
    }
    elseif ($table_mapping->allowsSharedTableStorage($storage_definition)) {
        // Ascertain the table this field is mapped too.
        $field_name = $storage_definition->getName();
        $table_name = $table_mapping->getFieldTableName($field_name);
        $query = $this->database
            ->select($table_name, 't');
        $or = $query->orConditionGroup();
        foreach (array_keys($storage_definition->getColumns()) as $property_name) {
            $or->isNotNull($table_mapping->getFieldColumnName($storage_definition, $property_name));
        }
        $query->condition($or);
        if (!$as_bool) {
            $query->fields('t', [
                $this->idKey,
            ])
                ->distinct(TRUE);
        }
    }
    // @todo Find a way to count field data also for fields having custom
    //   storage. See https://www.drupal.org/node/2337753.
    $count = 0;
    if (isset($query)) {
        // If we are performing the query just to check if the field has data
        // limit the number of rows.
        if ($as_bool) {
            $query->range(0, 1)
                ->addExpression('1');
        }
        else {
            // Otherwise count the number of rows.
            $query = $query->countQuery();
        }
        $count = $query->execute()
            ->fetchField();
    }
    return $as_bool ? (bool) $count : (int) $count;
}