function MenuLinkContentStorage::getMenuLinkIdsWithPendingRevisions
Same name in other branches
- 9 core/modules/menu_link_content/src/MenuLinkContentStorage.php \Drupal\menu_link_content\MenuLinkContentStorage::getMenuLinkIdsWithPendingRevisions()
- 8.9.x core/modules/menu_link_content/src/MenuLinkContentStorage.php \Drupal\menu_link_content\MenuLinkContentStorage::getMenuLinkIdsWithPendingRevisions()
- 10 core/modules/menu_link_content/src/MenuLinkContentStorage.php \Drupal\menu_link_content\MenuLinkContentStorage::getMenuLinkIdsWithPendingRevisions()
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_contentCode
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);
}
Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.