function views_handler_relationship_node_term_data::query in Views (for Drupal 7) 6.3
Same name and namespace in other branches
- 6.2 modules/taxonomy/views_handler_relationship_node_term_data.inc \views_handler_relationship_node_term_data::query()
- 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 44 - Views' relationship handlers.
Class
- views_handler_relationship_node_term_data
- Relationship handler to return the taxonomy terms of nodes.
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 td.*, tn.vid AS revision FROM {term_data} td INNER JOIN {term_node} tn ON tn.tid = td.tid WHERE td.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);
}