LaravelFreelancerNL\Aranguent\Query\Concerns\CompilesJoins

Complexity

Total Complexity

5

Size/Duplication

Total Lines	62
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	compileCrossJoin()	0	7	1
A	compileInnerJoin()	0	9	1
A	compileJoins()	0	8	2
A	compileLeftJoin()	0	22	1

<?php

namespace LaravelFreelancerNL\Aranguent\Query\Concerns;

use LaravelFreelancerNL\Aranguent\Query\Builder;
use LaravelFreelancerNL\FluentAQL\QueryBuilder;

trait CompilesJoins
{
    /**
     * Compile the "join" portions of the query.
     *
     * @param Builder $builder
     * @param array   $joins
     *
     * @return string
     */
    protected function compileJoins(Builder $builder, $joins)
    {
        foreach ($joins as $join) {
            $compileMethod = 'compile' . ucfirst($join->type) . 'Join';
            $builder = $this->$compileMethod($builder, $join);
        }

        return $builder;
    }

    protected function compileInnerJoin(Builder $builder, $join)
    {
        $table = $join->table;
        $alias = $this->generateTableAlias($table);

It seems like generateTableAlias() must be provided by classes using this trait. How about adding it as abstract method to this trait?

        $this->registerTableAlias($table, $alias);

It seems like registerTableAlias() must be provided by classes using this trait. How about adding it as abstract method to this trait?

        $builder->aqb = $builder->aqb->for($alias, $table)
            ->filter($this->compileWheresToArray($join));

It seems like compileWheresToArray() must be provided by classes using this trait. How about adding it as abstract method to this trait?

        return $builder;
    }

    protected function compileLeftJoin(Builder $builder, $join)
    {
        $table = $join->table;
        $alias = $this->generateTableAlias($table);
        $this->registerTableAlias($table, $alias);

        $resultsToJoin = (new QueryBuilder())
            ->for($alias, $table)
            ->filter($this->compileWheresToArray($join))
            ->return($alias);

        $builder->aqb = $builder->aqb->let($table, $resultsToJoin)
            ->for(
                $alias,
                $builder->aqb->if(
                    [$builder->aqb->length($table), '>', 0],
                    $table,
                    '[]'
                )
            );

        return $builder;
    }

    protected function compileCrossJoin(Builder $builder, $join)
    {
        $table = $join->table;
        $alias = $this->generateTableAlias($table);
        $builder->aqb = $builder->aqb->for($alias, $table);

        return $builder;
    }
}