public function NodeTermData::query in Zircon Profile 8
Same name and namespace in other branches
- 8.0 core/modules/taxonomy/src/Plugin/views/relationship/NodeTermData.php \Drupal\taxonomy\Plugin\views\relationship\NodeTermData::query()
Called to implement a relationship in a query.
Overrides RelationshipPluginBase::query
File
- core/
modules/ taxonomy/ src/ Plugin/ views/ relationship/ NodeTermData.php, line 116 - Contains \Drupal\taxonomy\Plugin\views\relationship\NodeTermData.
Class
- NodeTermData
- Relationship handler to return the taxonomy terms of nodes.
Namespace
Drupal\taxonomy\Plugin\views\relationshipCode
public function query() {
$this
->ensureMyTable();
$def = $this->definition;
$def['table'] = 'taxonomy_term_field_data';
if (!array_filter($this->options['vids'])) {
$taxonomy_index = $this->query
->addTable('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->tableAlias;
$def['left_field'] = 'nid';
$def['field'] = 'nid';
$def['type'] = empty($this->options['required']) ? 'LEFT' : 'INNER';
$def['adjusted'] = TRUE;
$query = db_select('taxonomy_term_field_data', 'td');
$query
->addJoin($def['type'], 'taxonomy_index', 'tn', 'tn.tid = td.tid');
$query
->condition('td.vid', array_filter($this->options['vids']), 'IN');
$query
->addTag('term_access');
$query
->fields('td');
$query
->fields('tn', array(
'nid',
));
$def['table formula'] = $query;
}
$join = \Drupal::service('plugin.manager.views.join')
->createInstance('standard', $def);
// use a short alias for this:
$alias = $def['table'] . '_' . $this->table;
$this->alias = $this->query
->addRelationship($alias, $join, 'taxonomy_term_field_data', $this->relationship);
}