function views_handler_relationship_node_term_data::query in Views (for Drupal 7) 6.2

Same name and namespace in other branches

1. 6.3 modules/taxonomy/views_handler_relationship_node_term_data.inc \views_handler_relationship_node_term_data::query()
2. 7.3 modules/taxonomy/views_handler_relationship_node_term_data.inc \views_handler_relationship_node_term_data::query()

Called to implement a relationship in a query.

Overrides views_handler_relationship::query

File

modules/taxonomy/views_handler_relationship_node_term_data.inc, line 38

Views' relationship handlers.

Class

views_handler_relationship_node_term_data

@file Views' relationship handlers.

Code

function query() {
  $this
    ->ensure_my_table();
  $def = $this->definition;
  $def['table'] = 'term_data';
  if (!empty($this->options['required']) || !array_filter($this->options['vids'])) {
    $term_node = $this->query
      ->add_table('term_node', $this->relationship);
    $def['left_table'] = $term_node;
    $def['left_field'] = 'tid';
    $def['field'] = 'tid';
    if (!empty($this->options['required'])) {
      $def['type'] = 'INNER';
    }
  }
  else {

    // If the join is optional, join a subselect that will emulate term_data table instead
    $def['left_table'] = $this->table_alias;
    $def['left_field'] = 'vid';
    $def['field'] = 'revision';

    // fapi ensures vids are safe here.
    $vids = implode(', ', array_filter($this->options['vids']));
    $def['table formula'] = "(SELECT t.*, tn.vid AS revision FROM {term_data} t INNER JOIN {term_node} tn ON tn.tid = t.tid WHERE t.vid IN ({$vids}))";
  }
  $join = new views_join();
  $join->definition = $def;
  $join
    ->construct();
  $join->adjusted = TRUE;

  // use a short alias for this:
  $alias = $def['table'] . '_' . $this->table;
  $this->alias = $this->query
    ->add_relationship($alias, $join, 'term_data', $this->relationship);
}