function Select::addJoin

File

core/lib/Drupal/Core/Database/Query/Select.php, line 633

Class

Select

Query builder for SELECT statements.

Namespace

Code

public function addJoin($type, $table, $alias = NULL, $condition = NULL, $arguments = []) {
  if (empty($alias)) {
    if ($table instanceof SelectInterface) {
      $alias = 'subquery';
    }
    else {
      $alias = $table;
    }
  }
  $alias_candidate = $alias;
  $count = 2;
  while (!empty($this->tables[$alias_candidate])) {
    $alias_candidate = $alias . '_' . $count++;
  }
  $alias = $alias_candidate;
  if (is_string($condition)) {
    $condition = str_replace('%alias', $alias, $condition);
  }
  $this->tables[$alias] = [
    'join type' => $type,
    'table' => $table,
    'alias' => $alias,
    'condition' => $condition,
    'arguments' => $arguments,
  ];
  return $alias;
}