Bluz\Db\Query\Select::getSQLForJoins PHP Method

getSQLForJoins() protected method

Generate SQL string for JOINs
protected getSQLForJoins ( string $fromAlias ) : string
$fromAlias string alias of table
return string
    protected function getSQLForJoins($fromAlias)
    {
        $sql = '';
        if (isset($this->sqlParts['join'][$fromAlias])) {
            foreach ($this->sqlParts['join'][$fromAlias] as $join) {
                $sql .= ' ' . strtoupper($join['joinType']) . " JOIN " . $join['joinTable'] . ' ' . $join['joinAlias'] . " ON " . (string) $join['joinCondition'];
                $sql .= $this->getSQLForJoins($join['joinAlias']);
            }
        }
        return $sql;
    }