eca-1.0.x-dev/modules/views/src/Plugin/Action/ViewsQuery.php
modules/views/src/Plugin/Action/ViewsQuery.php
<?php
namespace Drupal\eca_views\Plugin\Action;
use Drupal\Core\Access\AccessResult;
use Drupal\Core\Action\Attribute\Action;
use Drupal\Core\Entity\TranslatableInterface;
use Drupal\Core\Form\FormStateInterface;
use Drupal\Core\Session\AccountInterface;
use Drupal\Core\StringTranslation\TranslatableMarkup;
use Drupal\Core\TypedData\ListDataDefinition;
use Drupal\Core\TypedData\Plugin\DataType\ItemList;
use Drupal\eca\Attribute\EcaAction;
use Drupal\eca\Plugin\Action\ConfigurableActionBase;
use Drupal\eca\Plugin\ECA\PluginFormTrait;
use Drupal\views\Entity\View;
use Drupal\views\Plugin\views\display\DisplayPluginBase;
use Drupal\views\Plugin\views\query\Sql;
use Drupal\views\ViewExecutable;
/**
* Run views query.
*/
#[Action(
id: 'eca_views_query',
label: new TranslatableMarkup('Views: Execute query'),
)]
#[EcaAction(
description: new TranslatableMarkup('Use a View to execute a query and store the results in a token that contains an indexed list of the results. Despite the type of view that you use, always get the complete entities obtained by the view. You can access the entity properties using the token style.'),
version_introduced: '1.0.0',
)]
class ViewsQuery extends ConfigurableActionBase {
use PluginFormTrait;
/**
* The executable view.
*
* @var \Drupal\views\ViewExecutable
*/
protected ViewExecutable $view;
/**
* {@inheritdoc}
*/
public function calculateDependencies(): array {
return [
'config' => [
'views.view.' . $this->getViewId(),
],
];
}
/**
* {@inheritdoc}
*/
public function execute(mixed $object = NULL): void {
if (!$this->getDisplay() || !isset($this->view)) {
return;
}
$this->view->preExecute();
$this->view->execute();
$token_name = trim($this->configuration['token_name']);
if ($token_name === '') {
$token_name = implode(':', [
'eca',
'view',
$this->getViewId(),
$this->getDisplayId(),
]);
}
$entities = ItemList::createInstance(ListDataDefinition::create('entity'));
$entities->setValue($this->getEntities());
$this->tokenService->addTokenData($token_name, $entities);
}
/**
* {@inheritdoc}
*/
public function access($object, ?AccountInterface $account = NULL, $return_as_object = FALSE) {
$result = AccessResult::forbidden();
if (($display = $this->getDisplay()) && $display->access($account)) {
$result = AccessResult::allowed();
}
return $return_as_object ? $result : $result->isAllowed();
}
/**
* {@inheritdoc}
*/
public function defaultConfiguration(): array {
return [
'token_name' => '',
'view_id' => '',
'display_id' => 'default',
'arguments' => '',
] + parent::defaultConfiguration();
}
/**
* {@inheritdoc}
*/
public function buildConfigurationForm(array $form, FormStateInterface $form_state): array {
$views = [];
foreach (View::loadMultiple() as $view) {
if ($view->status()) {
$views[$view->id()] = $view->label();
}
}
$form['token_name'] = [
'#type' => 'textfield',
'#title' => $this->t('Name of token'),
'#default_value' => $this->configuration['token_name'],
'#description' => $this->t('Name of the token available after view execution. Contains an indexed list of elements that the view returns.'),
'#weight' => -60,
'#eca_token_reference' => TRUE,
];
$form['view_id'] = [
'#type' => 'select',
'#title' => $this->t('View'),
'#default_value' => $this->configuration['view_id'],
'#description' => $this->t('Select the view from the list. The view will always return a list of complete entities.'),
'#weight' => -50,
'#options' => $views,
'#required' => TRUE,
'#eca_token_select_option' => TRUE,
];
$form['display_id'] = [
'#type' => 'textfield',
'#title' => $this->t('Display'),
'#default_value' => $this->configuration['display_id'],
'#description' => $this->t('Write the view <code>display id</code> to execute. Set as default to use the default view configuration.'),
'#weight' => -40,
];
$form['arguments'] = [
'#type' => 'textfield',
'#title' => $this->t('Arguments'),
'#default_value' => $this->configuration['arguments'],
'#description' => $this->t('Provide the values for contextual filters in the same order as they are defined in the view. Separate multiple values with the <code>/</code> character.'),
'#maxlength' => 512,
'#weight' => -30,
];
return parent::buildConfigurationForm($form, $form_state);
}
/**
* {@inheritdoc}
*/
public function submitConfigurationForm(array &$form, FormStateInterface $form_state): void {
$this->configuration['token_name'] = $form_state->getValue('token_name');
$this->configuration['view_id'] = $form_state->getValue('view_id');
$this->configuration['display_id'] = $form_state->getValue('display_id');
$this->configuration['arguments'] = $form_state->getValue('arguments');
parent::submitConfigurationForm($form, $form_state);
}
/**
* Prepare and return display of given view with optional arguments applied.
*
* The view gets loaded, its executable set to $this->view and the given
* display being prepared with optional arguments.
*
* @return \Drupal\views\Plugin\views\display\DisplayPluginBase|null
* The view display ready for access check and execution, or NULL if either
* the view or display does not exist or the view is disabled.
*/
protected function getDisplay(): ?DisplayPluginBase {
$view_id = $this->getViewId();
if ($view_id === '') {
return NULL;
}
$view = View::load($view_id);
if (!$view || !$view->status()) {
return NULL;
}
$this->view = $view->getExecutable();
$display_id = $this->getDisplayId();
if ($display_id !== '') {
if (!$this->view->setDisplay($display_id)) {
return NULL;
}
}
else {
$this->view->initDisplay();
}
$args = [];
foreach (explode('/', $this->getArguments()) as $argument) {
if ($argument !== '') {
$args[] = $argument;
}
}
$this->view->setArguments($args);
return $this->view->getDisplay();
}
/**
* Get the configured view ID.
*
* @return string
* The view ID.
*/
protected function getViewId(): string {
$id = trim((string) $this->tokenService->replaceClear($this->configuration['view_id']));
if ($id === '_eca_token') {
$id = $this->getTokenValue('view_id', $id);
}
return $id;
}
/**
* Get the configured display ID.
*
* @return string
* The display ID.
*/
protected function getDisplayId(): string {
return trim((string) $this->tokenService->replaceClear($this->configuration['display_id']));
}
/**
* Get the configured Views arguments.
*
* @return string
* The arguments, multiple arguments are separated by "/".
*/
protected function getArguments(): string {
return trim((string) $this->tokenService->replaceClear($this->configuration['arguments']));
}
/**
* Extracts the entities out of the executed View query.
*
* @return \Drupal\Core\Entity\EntityInterface[]
* The extracted entities.
*/
protected function getEntities(): array {
$entities = [];
$view = $this->view;
foreach ($view->result as $row) {
$entity = $row->_entity;
// @phpstan-ignore-next-line
if ($entity === NULL) {
continue;
}
if (($view->query instanceof Sql) && ($entity instanceof TranslatableInterface) && $entity->isTranslatable()) {
// Try to find a field alias for the langcode.
// Assumption: translatable entities always
// have a langcode key.
$language_field = '';
$langcode_key = $entity->getEntityType()->getKey('langcode');
$base_table = $view->storage->get('base_table');
foreach ($view->query->fields as $field) {
if (
$field['field'] === $langcode_key && (
empty($field['base_table']) ||
$field['base_table'] === $base_table
)
) {
$language_field = $field['alias'];
break;
}
}
if (!$language_field) {
$language_field = $langcode_key;
}
if (isset($row->{$language_field})) {
$entity = $entity->getTranslation($row->{$language_field});
}
}
if (!in_array($entity, $entities, TRUE)) {
$entities[] = $entity;
}
}
return $entities;
}
/**
* Get all valid views.
*
* @todo Combine this with the same in eca_render.
*
* @see \Drupal\eca_render\Plugin\Action\Views::getAllValidViews()
*
* @return array
* An array of view IDs.
*/
public static function getAllValidViews(): array {
return array_map(fn($view) => $view->id(), array_filter(View::loadMultiple(), fn($view) => $view->status()));
}
}
