public function views_handler_filter_term_node_tid_depth_join::query in Views (for Drupal 7) 7.3

Add this filter to the query.

Due to the nature of fapi, the value and the operator have an unintended level of indirection. You will find them in $this->operator and $this->value respectively.

Overrides views_handler_filter_in_operator::query

File

modules/taxonomy/views_handler_filter_term_node_tid_depth_join.inc, line 55

Definition of views_handler_filter_term_node_tid_depth_join.

Class

views_handler_filter_term_node_tid_depth_join

Filter handler for taxonomy terms with depth.

Code

public function query() {

  // If no filter values are present, then do nothing.
  if (count($this->value) == 0) {
    return;
  }
  elseif (count($this->value) == 1) {

    // Somethis $this->value is an array with a single element so convert it.
    if (is_array($this->value)) {
      $this->value = current($this->value);
    }
    $operator = '=';
  }
  else {
    $operator = 'IN';

    // " IN ("
    // . implode(', ', array_fill(0, sizeof($this->value), '%d'))
    // . ")";
  }

  // The normal use of ensure_my_table() here breaks Views.
  // So instead we trick the filter into using the alias of the base table.
  // See http://drupal.org/node/271833
  // If a relationship is set, we must use the alias it provides.
  if (!empty($this->relationship)) {
    $this->table_alias = $this->relationship;
  }
  elseif (isset($this->query->table_queue[$this->query->base_table]['alias'])) {
    $this->table_alias = $this->query->table_queue[$this->query->base_table]['alias'];
  }
  else {
    return;
  }

  // The tids variable can be an integer or an array of integers.
  $tids = is_array($this->value) ? $this->value : array(
    $this->value,
  );
  if ($this->options['depth'] > 0) {

    // When the depth is positive search the children.
    foreach ($tids as $tid) {

      // The term must be loaded to get vid for use in taxonomy_get_tree().
      if ($term = taxonomy_term_load($tid)) {

        // For every tid argument find all the children down to the depth set
        // in the options and save the tids for the condition.
        $tree = taxonomy_get_tree($term->vid, $term->tid, (int) $this->options['depth']);
        $tids = array_merge($tids, array_map('_taxonomy_get_tid_from_term', $tree));
      }
    }
  }
  elseif ($this->options['depth'] < 0) {

    // When the depth is negative search the parents.
    foreach ($tids as $tid) {

      // For every tid argument find all the parents up to the depth set
      // in the options and add the tids into the array. Since there is
      // no taxonomy function to get all parents with a depth limit it
      // is done here building a multidimensional array.
      if ($term = taxonomy_term_load($tid)) {

        // A variable is needed to track the current depth level.
        $n = 0;

        // Initialise our depth based parents array with the leaf term.
        $parents[$n--][] = $term;
        while ($n >= $this->options['depth']) {

          // At each depth find the parents of the current terms.
          // It is important to note that it is possible for a term to have
          // multiple parents so get the parents of every parent and so on.
          $parents[$n] = array();
          foreach ($parents[$n + 1] as $term) {
            $parents[$n] += taxonomy_get_parents($term->tid);
          }

          // Save all the tids for the condition.
          $tids = array_merge($tids, array_map('_taxonomy_get_tid_from_term', $parents[$n]));
          $n--;
        }
      }
    }
  }

  // Check the size of the array and set the operator accordingly.
  if (count($tids) > 1) {
    $operator = 'IN';
  }
  else {
    $tids = current($tids);
    $operator = '=';
  }

  // Join on taxonomy index table.
  $join = new views_join();
  $join->table = 'taxonomy_index';
  $join->field = 'nid';
  $join->left_table = $this->table_alias;
  $join->left_field = $this->real_field;
  $join->type = 'INNER';
  $join->extra = array(
    array(
      'field' => 'tid',
      'value' => $tids,
      'operator' => $operator,
    ),
  );
  $taxonomy_index_alias = $this->query
    ->add_relationship('taxonomy_index', $join, 'node');
}