trait TaxonomyIndexDepthQueryTrait

Same name in other branches
  1. 9 core/modules/taxonomy/src/TaxonomyIndexDepthQueryTrait.php \Drupal\taxonomy\TaxonomyIndexDepthQueryTrait
  2. 11.x core/modules/taxonomy/src/TaxonomyIndexDepthQueryTrait.php \Drupal\taxonomy\TaxonomyIndexDepthQueryTrait

Builds a performant depth subquery and adds it as a join to the query.

This is performant because:

  • It creates multiple queries on taxonomy_index with inner joins to taxonomy_term__parent. These queries are combined together into a subquery using unions to select all the node IDs with the terms in the hierarchy.
  • It joins the resulting query to the main views query using an INNER JOIN.

For example, if the $tids value is '718' and depth is configured to 2, the resulting JOIN to node_field_data will be:


INNER JOIN (SELECT tn.nid AS nid
FROM
taxonomy_index tn
WHERE tn.tid = '718' UNION SELECT tn.nid AS nid
FROM
taxonomy_index tn
INNER JOIN taxonomy_term__parent th ON tn.tid = th.entity_id
INNER JOIN taxonomy_term__parent th1 ON th.parent_target_id = th1.entity_id
WHERE th1.entity_id = '718' UNION SELECT tn.nid AS nid
FROM
taxonomy_index tn
INNER JOIN taxonomy_term__parent th ON tn.tid = th.entity_id
INNER JOIN taxonomy_term__parent th1 ON th.parent_target_id = th1.entity_id
INNER JOIN taxonomy_term__parent th2 ON th1.parent_target_id = th2.entity_id
WHERE th2.entity_id = '718') taxonomy_index_depth ON node_field_data.nid = taxonomy_index_depth.nid

Hierarchy

2 files declare their use of TaxonomyIndexDepthQueryTrait
IndexTidDepth.php in core/modules/taxonomy/src/Plugin/views/argument/IndexTidDepth.php
TaxonomyIndexTidDepth.php in core/modules/taxonomy/src/Plugin/views/filter/TaxonomyIndexTidDepth.php

File

core/modules/taxonomy/src/TaxonomyIndexDepthQueryTrait.php, line 36

Namespace

Drupal\taxonomy
View source 
trait TaxonomyIndexDepthQueryTrait {
    
    /**
     * Builds a performant depth subquery and adds it as a join to the query.
     *
     * @param string|array $tids
     *   The terms ID(s) to do a depth search for.
     */
    protected function addSubQueryJoin($tids) : void {
        $connection = $this->query
            ->getConnection();
        $operator = is_array($tids) ? 'IN' : '=';
        // Create the depth 0 subquery.
        $subquery = $connection->select('taxonomy_index', 'tn');
        $subquery->addField('tn', 'nid');
        $subquery->condition('tn.tid', $tids, $operator);
        if ($this->options['depth'] !== 0) {
            // Set $left_field and $right_field depending on whether we are traversing
            // up or down the hierarchy.
            if ($this->options['depth'] > 0) {
                $left_field = 'parent_target_id';
                $right_field = 'entity_id';
            }
            else {
                $left_field = 'entity_id';
                $right_field = 'parent_target_id';
            }
            // Traverse the hierarchy to check the child or parent terms.
            foreach (range(1, abs($this->options['depth'])) as $count) {
                $union_query = $connection->select('taxonomy_index', 'tn');
                $union_query->addField('tn', 'nid');
                $left_join = "[tn].[tid]";
                if ($this->options['depth'] > 0) {
                    $union_query->join('taxonomy_term__parent', "th", "{$left_join} = [th].[entity_id]");
                    $left_join = "[th].[{$left_field}]";
                }
                foreach (range(1, $count) as $inner_count) {
                    $union_query->join('taxonomy_term__parent', "th{$inner_count}", "{$left_join} = [th{$inner_count}].[{$right_field}]");
                    $left_join = "[th{$inner_count}].[{$left_field}]";
                }
                $union_query->condition("th{$inner_count}.entity_id", $tids, $operator);
                $subquery->union($union_query);
            }
        }
        // Add the subquery as a join.
        $definition['left_table'] = $this->tableAlias;
        $definition['left_field'] = $this->realField;
        $definition['field'] = 'nid';
        $definition['type'] = 'INNER';
        $definition['adjusted'] = TRUE;
        $definition['table formula'] = $subquery;
        $join = Views::pluginManager('join')->createInstance('standard', $definition);
        // There is no $base as we are joining to a query.
        $this->query
            ->addRelationship('taxonomy_index_depth', $join, NULL, $this->relationship);
    }

}

Members

Title Modifiers Object type Summary
TaxonomyIndexDepthQueryTrait::addSubQueryJoin protected function Builds a performant depth subquery and adds it as a join to the query.

Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.