public function IndexNameDepth::query in Views Taxonomy Term Name Depth 8.3
Same name and namespace in other branches
- 8.6 src/Plugin/views/argument/IndexNameDepth.php \Drupal\views_taxonomy_term_name_depth\Plugin\views\argument\IndexNameDepth::query()
- 8 src/Plugin/views/argument/IndexNameDepth.php \Drupal\views_taxonomy_term_name_depth\Plugin\views\argument\IndexNameDepth::query()
- 7.x src/Plugin/views/argument/IndexNameDepth.php \Drupal\views_taxonomy_term_name_depth\Plugin\views\argument\IndexNameDepth::query()
@inheritdoc
Overrides ArgumentPluginBase::query
File
- src/
Plugin/ views/ argument/ IndexNameDepth.php, line 134
Class
- IndexNameDepth
- Argument handler for taxonomy terms with depth.
Namespace
Drupal\views_taxonomy_term_name_depth\Plugin\views\argumentCode
public function query($group_by = FALSE) {
$this
->ensureMyTable();
if (!empty($this->options['break_phrase'])) {
$break = static::breakString($this->argument);
if ($break->value === array(
-1,
)) {
return FALSE;
}
$operator = count($break->value) > 1 ? 'IN' : '=';
$tids = $break->value;
}
else {
$operator = "=";
$tids = $this->argument;
}
// Now build the subqueries.
if (is_string($tids)) {
if (\Drupal::service('module_handler')
->moduleExists('pathauto')) {
$query = $this->database
->select('taxonomy_term_field_data', 't')
->fields('t', array(
'tid',
'name',
));
// Filter by vocabulary ID if one or more are provided.
if (!empty($this->options['vocabularies'])) {
$query
->condition('t.vid', $this->options['vocabularies'], 'IN');
}
$results = $query
->execute()
->fetchAll(\PDO::FETCH_OBJ);
// Iterate results.
foreach ($results as $row) {
// Service container for alias cleaner.
$alias = \Drupal::service('pathauto.alias_cleaner');
if ($alias
->cleanString($row->name) == $alias
->cleanString($tids)) {
$tids = $row->tid;
}
}
}
else {
// Replaces "-" with space if exist.
$argument = str_replace('-', ' ', $tids);
$query = $this->database
->select('taxonomy_term_field_data', 't')
->fields('t', array(
'tid',
'name',
));
// Filter by vocabulary ID if one or more are provided.
if (!empty($this->options['vocabularies'])) {
$query
->condition('t.vid', $this->options['vocabularies'], 'IN');
}
$query
->condition('t.name', $argument, '=');
$results = $query
->execute()
->fetchAll(\PDO::FETCH_OBJ);
// Iterate results
foreach ($results as $row) {
$tids = $row->tid;
}
}
}
$subquery = db_select('taxonomy_index', 'tn');
$subquery
->addField('tn', 'nid');
$where = db_or()
->condition('tn.tid', $tids, $operator);
$last = "tn";
if ($this->options['depth'] > 0) {
$subquery
->leftJoin('taxonomy_term_hierarchy', 'th', "th.tid = tn.tid");
$last = "th";
foreach (range(1, abs($this->options['depth'])) as $count) {
$subquery
->leftJoin('taxonomy_term_hierarchy', "th{$count}", "{$last}.parent = th{$count}.tid");
$where
->condition("th{$count}.tid", $tids, $operator);
$last = "th{$count}";
}
}
elseif ($this->options['depth'] < 0) {
foreach (range(1, abs($this->options['depth'])) as $count) {
$subquery
->leftJoin('taxonomy_term_hierarchy', "th{$count}", "{$last}.tid = th{$count}.parent");
$where
->condition("th{$count}.tid", $tids, $operator);
$last = "th{$count}";
}
}
$subquery
->condition($where);
$this->query
->addWhere(0, "{$this->tableAlias}.{$this->realField}", $subquery, 'IN');
}