JoinClause.php

Go to the documentation of this file.

<?php

namespace Elgg\Database\Clauses;

use Closure;
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;
    }
}