public function views_handler_relationship_node_term_data::query in Views (for Drupal 7) 7.3
Same name and namespace in other branches
- 6.3 modules/taxonomy/views_handler_relationship_node_term_data.inc \views_handler_relationship_node_term_data::query()
- 6.2 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 64 - Definition of views_handler_relationship_node_term_data.
Class
- views_handler_relationship_node_term_data
- Relationship handler to return the taxonomy terms of nodes.
Code
public function query() {
$this
->ensure_my_table();
$def = $this->definition;
$def['table'] = 'taxonomy_term_data';
if (!array_filter($this->options['vocabularies'])) {
$taxonomy_index = $this->query
->add_table('taxonomy_index', $this->relationship);
$def['left_table'] = $taxonomy_index;
$def['left_field'] = 'tid';
$def['field'] = 'tid';
$def['type'] = empty($this->options['required']) ? 'LEFT' : 'INNER';
}
else {
// If vocabularies are supplied join a subselect instead.
$def['left_table'] = $this->table_alias;
$def['left_field'] = 'nid';
$def['field'] = 'nid';
$def['type'] = empty($this->options['required']) ? 'LEFT' : 'INNER';
$query = db_select('taxonomy_term_data', 'td');
$query
->addJoin($def['type'], 'taxonomy_vocabulary', 'tv', 'td.vid = tv.vid');
$query
->addJoin($def['type'], 'taxonomy_index', 'tn', 'tn.tid = td.tid');
$query
->condition('tv.machine_name', array_filter($this->options['vocabularies']));
if (empty($this->query->options['disable_sql_rewrite'])) {
$query
->addTag('taxonomy_term_access');
}
$query
->fields('td');
$query
->fields('tn', array(
'nid',
));
$def['table formula'] = $query;
}
$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, 'taxonomy_term_data', $this->relationship);
}