public function MenuLinkContentStorage::getMenuLinkIdsWithPendingRevisions in Drupal 10

Same name and namespace in other branches

1. 8 core/modules/menu_link_content/src/MenuLinkContentStorage.php \Drupal\menu_link_content\MenuLinkContentStorage::getMenuLinkIdsWithPendingRevisions()
2. 9 core/modules/menu_link_content/src/MenuLinkContentStorage.php \Drupal\menu_link_content\MenuLinkContentStorage::getMenuLinkIdsWithPendingRevisions()

Gets a list of menu link IDs with pending revisions.

@internal

Return value

int[] An array of menu link IDs which have pending revisions, keyed by their revision IDs.

Overrides MenuLinkContentStorageInterface::getMenuLinkIdsWithPendingRevisions

File

core/modules/menu_link_content/src/MenuLinkContentStorage.php, line 15

Class

MenuLinkContentStorage

Storage handler for menu_link_content entities.

Namespace

Drupal\menu_link_content

Code

public function getMenuLinkIdsWithPendingRevisions() {
  $table_mapping = $this
    ->getTableMapping();
  $id_field = $table_mapping
    ->getColumnNames($this->entityType
    ->getKey('id'))['value'];
  $revision_field = $table_mapping
    ->getColumnNames($this->entityType
    ->getKey('revision'))['value'];
  $rta_field = $table_mapping
    ->getColumnNames($this->entityType
    ->getKey('revision_translation_affected'))['value'];
  $langcode_field = $table_mapping
    ->getColumnNames($this->entityType
    ->getKey('langcode'))['value'];
  $revision_default_field = $table_mapping
    ->getColumnNames($this->entityType
    ->getRevisionMetadataKey('revision_default'))['value'];
  $query = $this->database
    ->select($this
    ->getRevisionDataTable(), 'mlfr');
  $query
    ->fields('mlfr', [
    $id_field,
  ]);
  $query
    ->addExpression("MAX([mlfr].[{$revision_field}])", $revision_field);
  $query
    ->join($this
    ->getRevisionTable(), 'mlr', "[mlfr].[{$revision_field}] = [mlr].[{$revision_field}] AND [mlr].[{$revision_default_field}] = 0");
  $inner_select = $this->database
    ->select($this
    ->getRevisionDataTable(), 't');
  $inner_select
    ->condition("t.{$rta_field}", '1');
  $inner_select
    ->fields('t', [
    $id_field,
    $langcode_field,
  ]);
  $inner_select
    ->addExpression("MAX([t].[{$revision_field}])", $revision_field);
  $inner_select
    ->groupBy("t.{$id_field}")
    ->groupBy("t.{$langcode_field}");
  $query
    ->join($inner_select, 'mr', "[mlfr].[{$revision_field}] = [mr].[{$revision_field}] AND [mlfr].[{$langcode_field}] = [mr].[{$langcode_field}]");
  $query
    ->groupBy("mlfr.{$id_field}");
  return $query
    ->execute()
    ->fetchAllKeyed(1, 0);
}