JoinClause.php

Go to the documentation of this file.

<?php
 
namespace Elgg\Database\Clauses;
 
use Doctrine\DBAL\Query\Expression\CompositeExpression;
use Elgg\Database\QueryBuilder;
 
class JoinClause extends Clause {
 
    public $joined_table;
 
    public $joined_alias;
 
    public $condition;
 
    public $join_type;
 
    public function __construct($joined_table, $joined_alias = null, $condition = null, $join_type = 'inner') {
        $this->joined_table = $joined_table;
        $this->joined_alias = $joined_alias;
        $this->condition = $condition;
        $this->join_type = $join_type;
    }
 
    public function prepare(QueryBuilder $qb, $table_alias = null) {
        $joined_alias = $this->joined_alias;
        if (!isset($joined_alias)) {
            $joined_alias = $qb->getNextJoinAlias();
        }
 
        $condition = $this->condition;
        if ($this->isCallable($condition)) {
            $condition = $this->callJoin($condition, $qb, $joined_alias, $table_alias);
        } else if ($condition === null) {
            $condition = true;
        }
 
        switch (strtolower($this->join_type ?? '')) {
            case 'left':
                $qb->leftJoin($table_alias, $this->joined_table, $joined_alias, $condition);
                break;
 
            case 'right':
                $qb->rightJoin($table_alias, $this->joined_table, $joined_alias, $condition);
                break;
 
            default:
                $qb->join($table_alias, $this->joined_table, $joined_alias, $condition);
                break;
        }
 
        return $joined_alias;
    }
}