ViewsData::getViewsData

public ViewsData::getViewsData()

public function getViewsData() {
  $data = [];

  $data['content_revision_tracker']['table']['group'] = $this->t('Content moderation (tracker)');

  $data['content_revision_tracker']['entity_type'] = [
    'title' => $this->t('Entity type'),
    'field' => [
      'id' => 'standard',
    ],
    'filter' => [
      'id' => 'string',
    ],
    'argument' => [
      'id' => 'string',
    ],
    'sort' => [
      'id' => 'standard',
    ],
  ];

  $data['content_revision_tracker']['entity_id'] = [
    'title' => $this->t('Entity ID'),
    'field' => [
      'id' => 'standard',
    ],
    'filter' => [
      'id' => 'numeric',
    ],
    'argument' => [
      'id' => 'numeric',
    ],
    'sort' => [
      'id' => 'standard',
    ],
  ];

  $data['content_revision_tracker']['langcode'] = [
    'title' => $this->t('Entity language'),
    'field' => [
      'id' => 'standard',
    ],
    'filter' => [
      'id' => 'language',
    ],
    'argument' => [
      'id' => 'language',
    ],
    'sort' => [
      'id' => 'standard',
    ],
  ];

  $data['content_revision_tracker']['revision_id'] = [
    'title' => $this->t('Latest revision ID'),
    'field' => [
      'id' => 'standard',
    ],
    'filter' => [
      'id' => 'numeric',
    ],
    'argument' => [
      'id' => 'numeric',
    ],
    'sort' => [
      'id' => 'standard',
    ],
  ];

  $entity_types_with_moderation = array_filter($this->entityTypeManager->getDefinitions(), function(EntityTypeInterface $type) {
    return $this->moderationInformation->canModerateEntitiesOfEntityType($type);
  });

  // Add a join for each entity type to the content_revision_tracker table.
  foreach ($entity_types_with_moderation as $entity_type_id => $entity_type) {
    /** @var \Drupal\views\EntityViewsDataInterface $views_data */
    // We need the views_data handler in order to get the table name later.
    if ($this->entityTypeManager->hasHandler($entity_type_id, 'views_data') && $views_data = $this->entityTypeManager->getHandler($entity_type_id, 'views_data')) {
      // Add a join from the entity base table to the revision tracker table.
      $base_table = $views_data->getViewsTableForEntityType($entity_type);
      $data['content_revision_tracker']['table']['join'][$base_table] = [
        'left_field' => $entity_type->getKey('id'),
        'field' => 'entity_id',
        'extra' => [
          [
            'field' => 'entity_type',
            'value' => $entity_type_id,
          ],
        ],
      ];

      // Some entity types might not be translatable.
      if ($entity_type->hasKey('langcode')) {
        $data['content_revision_tracker']['table']['join'][$base_table]['extra'][] = [
          'field' => 'langcode',
          'left_field' => $entity_type->getKey('langcode'),
          'operation' => '=',
        ];
      }

      // Add a relationship between the revision tracker table to the latest
      // revision on the entity revision table.
      $data['content_revision_tracker']['latest_revision__' . $entity_type_id] = [
        'title' => $this->t('@label latest revision', ['@label' => $entity_type->getLabel()]),
        'group' => $this->t('@label revision', ['@label' => $entity_type->getLabel()]),
        'relationship' => [
          'id' => 'standard',
          'label' => $this->t('@label latest revision', ['@label' => $entity_type->getLabel()]),
          'base' => $this->getRevisionViewsTableForEntityType($entity_type),
          'base field' => $entity_type->getKey('revision'),
          'relationship field' => 'revision_id',
          'extra' => [
            [
              'left_field' => 'entity_type',
              'value' => $entity_type_id,
            ],
          ],
        ],
      ];

      // Some entity types might not be translatable.
      if ($entity_type->hasKey('langcode')) {
        $data['content_revision_tracker']['latest_revision__' . $entity_type_id]['relationship']['extra'][] = [
          'left_field' => 'langcode',
          'field' => $entity_type->getKey('langcode'),
          'operation' => '=',
        ];
      }
    }
  }

  // Provides a relationship from moderated entity to its moderation state
  // entity.
  $content_moderation_state_entity_type = \Drupal::entityTypeManager()->getDefinition('content_moderation_state');
  $content_moderation_state_entity_base_table = $content_moderation_state_entity_type->getDataTable() ? : $content_moderation_state_entity_type->getBaseTable();
  $content_moderation_state_entity_revision_base_table = $content_moderation_state_entity_type->getRevisionDataTable() ? : $content_moderation_state_entity_type->getRevisionTable();
  foreach ($entity_types_with_moderation as $entity_type_id => $entity_type) {
    $table = $entity_type->getDataTable() ? : $entity_type->getBaseTable();

    $data[$table]['moderation_state'] = [
      'title' => t('Moderation state'),
      'relationship' => [
        'id' => 'standard',
        'label' => $this->t('@label moderation state', ['@label' => $entity_type->getLabel()]),
        'base' => $content_moderation_state_entity_base_table,
        'base field' => 'content_entity_id',
        'relationship field' => $entity_type->getKey('id'),
        'join_extra' => [
          [
            'field' => 'content_entity_type_id',
            'value' => $entity_type_id,
          ],
          [
            'field' => 'content_entity_revision_id',
            'left_field' => $entity_type->getKey('revision'),
          ],
        ],
      ],
    ];

    $revision_table = $entity_type->getRevisionDataTable() ? : $entity_type->getRevisionTable();
    $data[$revision_table]['moderation_state'] = [
      'title' => t('Moderation state'),
      'relationship' => [
        'id' => 'standard',
        'label' => $this->t('@label moderation state', ['@label' => $entity_type->getLabel()]),
        'base' => $content_moderation_state_entity_revision_base_table,
        'base field' => 'content_entity_revision_id',
        'relationship field' => $entity_type->getKey('revision'),
        'join_extra' => [
          [
            'field' => 'content_entity_type_id',
            'value' => $entity_type_id,
          ],
        ],
      ],
    ];
  }

  return $data;
}