protected function addJoin($type, $table, $join_condition, $langcode)
{
$arguments = array();
if ($langcode) {
$placeholder = ':langcode' . $this->sqlQuery->nextPlaceholder();
$join_condition .= ' AND %alias.langcode = ' . $placeholder;
$arguments[$placeholder] = $langcode;
}
return $this->sqlQuery->addJoin($type, $table, NULL, $join_condition, $arguments);
}
protected function addJoin($type, $table, $join_condition, $langcode)
{
$arguments = array();
if ($langcode) {
$entity_type_id = $this->sqlQuery->getMetaData('entity_type');
$entity_type = $this->entityManager->getDefinition($entity_type_id);
// Only the data table follows the entity language key, dedicated field
// tables have an hard-coded 'langcode' column.
$langcode_key = $entity_type->getDataTable() == $table ? $entity_type->getKey('langcode') : 'langcode';
$placeholder = ':langcode' . $this->sqlQuery->nextPlaceholder();
$join_condition .= ' AND %alias.' . $langcode_key . ' = ' . $placeholder;
$arguments[$placeholder] = $langcode;
}
return $this->sqlQuery->addJoin($type, $table, NULL, $join_condition, $arguments);
}
/**
* Builds the SQL for the join this object represents.
*
* @param \Drupal\Core\Database\Query\SelectInterface $select_query
* The select query object.
* @param string $table
* The base table to join.
* @param \Drupal\views\Plugin\views\query\QueryPluginBase $view_query
* The source views query.
*/
public function buildJoin($select_query, $table, $view_query)
{
if (empty($this->configuration['table formula'])) {
$right_table = "{" . $this->table . "}";
} else {
$right_table = $this->configuration['table formula'];
}
// Add our join condition, using a subquery on the left instead of a field.
$condition = "({$this->left_query}) = {$table['alias']}.{$this->field}";
$arguments = array();
// Tack on the extra.
// This is just copied verbatim from the parent class, which itself has a
// bug: https://www.drupal.org/node/1118100.
if (isset($this->extra)) {
if (is_array($this->extra)) {
$extras = array();
foreach ($this->extra as $info) {
// Figure out the table name. Remember, only use aliases provided
// if at all possible.
$join_table = '';
if (!array_key_exists('table', $info)) {
$join_table = $table['alias'] . '.';
} elseif (isset($info['table'])) {
$join_table = $info['table'] . '.';
}
$placeholder = ':views_join_condition_' . $select_query->nextPlaceholder();
if (is_array($info['value'])) {
$operator = !empty($info['operator']) ? $info['operator'] : 'IN';
// Transform from IN() notation to = notation if just one value.
if (count($info['value']) == 1) {
$info['value'] = array_shift($info['value']);
$operator = $operator == 'NOT IN' ? '!=' : '=';
}
} else {
$operator = !empty($info['operator']) ? $info['operator'] : '=';
}
$extras[] = "{$join_table}{$info['field']} {$operator} {$placeholder}";
$arguments[$placeholder] = $info['value'];
}
if ($extras) {
if (count($extras) == 1) {
$condition .= ' AND ' . array_shift($extras);
} else {
$condition .= ' AND (' . implode(' ' . $this->extraOperator . ' ', $extras) . ')';
}
}
} elseif ($this->extra && is_string($this->extra)) {
$condition .= " AND ({$this->extra})";
}
}
$select_query->addJoin($this->type, $right_table, $table['alias'], $condition, $arguments);
}
public function addJoin($type, $table, $alias = NULL, $condition = NULL, $arguments = array())
{
return $this->query->addJoin($type, $table, $alias, $condition, $arguments);
}
