function WorkspacesAliasRepository::getBaseQuery

File

core/modules/workspaces/src/WorkspacesAliasRepository.php, line 35

Class

WorkspacesAliasRepository

Provides workspace-specific path alias lookup queries.

Namespace

Code

protected function getBaseQuery() {
  // Don't alter any queries if we're not in a workspace context.
  if (!$this->workspaceManager
    ->hasActiveWorkspace()) {
    return parent::getBaseQuery();
  }
  $active_workspace = $this->workspaceManager
    ->getActiveWorkspace();
  $query = $this->connection
    ->select('path_alias', 'base_table_2');
  $wa_join = $query->leftJoin('workspace_association', NULL, "%alias.target_entity_type_id = 'path_alias' AND %alias.target_entity_id = base_table_2.id AND %alias.workspace = :active_workspace_id", [
    ':active_workspace_id' => $active_workspace->id(),
  ]);
  $query->innerJoin('path_alias_revision', 'base_table', "%alias.revision_id = COALESCE({$wa_join}.target_entity_revision_id, base_table_2.revision_id)");
  return $query;
}