MenuLinkContentStorage.php in Drupal 9

Namespace

Drupal\menu_link_content

File

core/modules/menu_link_content/src/MenuLinkContentStorage.php

<?php

namespace Drupal\menu_link_content;

use Drupal\Core\Entity\Sql\SqlContentEntityStorage;

/**
 * Storage handler for menu_link_content entities.
 */
class MenuLinkContentStorage extends SqlContentEntityStorage implements MenuLinkContentStorageInterface {

  /**
   * {@inheritdoc}
   */
  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);
  }

}

Classes

Name	Description
MenuLinkContentStorage	Storage handler for menu_link_content entities.