monster_menus-9.0.x-dev/src/Plugin/views/argument/MMTreeChildren.php

<?php

namespace Drupal\monster_menus\Plugin\views\argument;

use Drupal\Core\Database\Connection;
use Drupal\views\Plugin\views\argument\ArgumentPluginBase;
use Drupal\views\Plugin\views\join\JoinPluginBase;
use Drupal\views\Plugin\ViewsHandlerManager;
use Symfony\Component\DependencyInjection\ContainerInterface;

/**
 * Argument handler for an MM Tree entity and all of its children.
 *
 * @ingroup views_argument_handlers
 *
 * @ViewsArgument("mm_tree_children")
 */
class MMTreeChildren extends ArgumentPluginBase {

  /** @var ViewsHandlerManager $joinManager */
  protected $joinManager;

  /**
   * The database connection.
   *
   * @var Connection
   */
  protected $database;

  /**
   * Constructs an MMTreeChildren object.
   *
   * @param ViewsHandlerManager $join_manager
   *   The views plugin join manager.
   * @param Connection $database
   *   The database connection.
   */
  public function __construct(array $configuration, $plugin_id, $plugin_definition, ViewsHandlerManager $join_manager, Connection $database) {
    parent::__construct($configuration, $plugin_id, $plugin_definition);
    $this->joinManager = $join_manager;
    $this->database = $database;
  }

  /**
   * {@inheritdoc}
   */
  public static function create(ContainerInterface $container, array $configuration, $plugin_id, $plugin_definition) {
    return new static(
      $configuration,
      $plugin_id,
      $plugin_definition,
      $container->get('plugin.manager.views.join'),
      $container->get('database')
    );
  }

  /**
   * @inheritdoc
   */
  public function query($group_by = FALSE) {
    $this->ensureMyTable();
    $sub_query = $this->database->select('mm_tree_parents', 'p')
      ->fields('p', ['mmtid'])
      ->condition('parent', $this->argument)
      ->union(
        $this->database->select('mm_tree', 't')
          ->fields('t', ['mmtid'])
          ->condition('mmtid', $this->argument)
      );
    $definition = [
      'field' => 'mmtid',
      'table formula' => $sub_query,
      'left_table' => 'mm_tree',
      'left_field' => 'mmtid',
      'type' => 'INNER',
    ];
    /** @var JoinPluginBase $join */
    $join = $this->joinManager->createInstance('standard', $definition);
    $this->query->addRelationship('mm_tree_children_subquery', $join, NULL, $this->relationship);
  }

}