function WorkspaceAssociation::getTrackedEntitiesForListing

File

core/modules/workspaces/src/WorkspaceAssociation.php, line 163

Class

WorkspaceAssociation

Provides a class for CRUD operations on workspace associations.

Namespace

Code

public function getTrackedEntitiesForListing($workspace_id, ?int $pager_id = NULL, int|false $limit = 50) : array {
    $query = $this->database
        ->select(static::TABLE);
    if ($limit !== FALSE) {
        $query = $query->extend(PagerSelectExtender::class)
            ->limit($limit);
        if ($pager_id) {
            $query->element($pager_id);
        }
    }
    $query->fields(static::TABLE, [
        'target_entity_type_id',
        'target_entity_id',
        'target_entity_id_string',
        'target_entity_revision_id',
    ]);
    $query->orderBy('target_entity_type_id', 'ASC')
        ->orderBy('target_entity_revision_id', 'DESC')
        ->condition('workspace', $workspace_id);
    $tracked_revisions = [];
    foreach ($query->execute() as $record) {
        $target_id = $record->{static::getIdField($record->target_entity_type_id)};
        $tracked_revisions[$record->target_entity_type_id][$record->target_entity_revision_id] = $target_id;
    }
    return $tracked_revisions;
}