Quantum\Libraries\Database\Adapters\Sleekdb\Statements\Join

Complexity

Total Complexity

14

Size/Duplication

Total Lines	102
Duplicated Lines	0 %

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	applyJoins()	0	4	2
B	applyJoin()	0	46	9
A	joinTo()	0	4	1
A	addJoin()	0	6	1
A	joinThrough()	0	4	1

<?php

/**
 * Quantum PHP Framework
 *
 * An open source software development framework for PHP
 *
 * @package Quantum
 * @author Arman Ag. <arman.ag@softberg.org>
 * @copyright Copyright (c) 2018 Softberg LLC (https://softberg.org)
 * @link http://quantum.softberg.org/
 * @since 2.9.5
 */

namespace Quantum\Libraries\Database\Adapters\Sleekdb\Statements;

use Quantum\Libraries\Database\Adapters\Sleekdb\SleekDbal;
use Quantum\Libraries\Database\Exceptions\ModelException;
use Quantum\Libraries\Database\Contracts\DbalInterface;
use SleekDB\QueryBuilder;
use Quantum\Mvc\QtModel;

/**
 * Trait Join
 * @package Quantum\Libraries\Database
 */
trait Join
{

    /**
     * @inheritDoc
     */
    public function joinTo(QtModel $model, bool $switch = true): DbalInterface
    {
        $this->addJoin(__FUNCTION__, $model, $switch);
        return $this;

The expression return $this returns the type Quantum\Libraries\Database\Adapters\Sleekdb\Statements\Join which is incompatible with the type-hinted return Quantum\Libraries\Database\Contracts\DbalInterface.

    }

    /**
     * @inheritDoc
     */
    public function joinThrough(QtModel $model, bool $switch = true): DbalInterface
    {
        $this->addJoin(__FUNCTION__, $model, $switch);
        return $this;

The expression return $this returns the type Quantum\Libraries\Database\Adapters\Sleekdb\Statements\Join which is incompatible with the type-hinted return Quantum\Libraries\Database\Contracts\DbalInterface.

    }

    /**
     * Adds join
     * @param string $type
     * @param QtModel $model
     * @param bool $switch
     */
    private function addJoin(string $type, QtModel $model, bool $switch = true)
    {
        $this->joins[] = [

The property joins does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

            'type' => $type,
            'model' => serialize($model),
            'switch' => $switch,
        ];
    }

    /**
     * Starts to apply joins
     * @throws ModelException
     */
    private function applyJoins()
    {
        if (isset($this->joins[0])) {
            $this->applyJoin($this->queryBuilder, $this, $this->joins[0]);
        }
    }

    /**
     * Apply the join to query builder
     * @param QueryBuilder $queryBuilder
     * @param SleekDbal $currentItem
     * @param array $nextItem
     * @param int $level
     * @return QueryBuilder
     * @throws ModelException
     */
    private function applyJoin(QueryBuilder $queryBuilder, SleekDbal $currentItem, array $nextItem, int $level = 1): QueryBuilder
    {
        $modelToJoin = unserialize($nextItem['model']);
        $switch = $nextItem['switch'];
        $joinType = $nextItem['type'];

        $queryBuilder->join(function ($item) use ($currentItem, $modelToJoin, $switch, $joinType, $level) {

            $newQueryBuilder = (new self($modelToJoin->table))->getOrmModel()->createQueryBuilder();

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

The call to Quantum\Libraries\Database\Adapters\Sleekdb\Statements\Join::__construct() has too many arguments starting with $modelToJoin->table.

            if ($joinType == self::JOINTO) {

The constant Quantum\Libraries\Database\Adapters\Sleekdb\Statements\Join::JOINTO was not found. Maybe you did not declare it correctly or list all dependencies?

                if (!isset($modelToJoin->foreignKeys[$currentItem->table])) {

The property $table is declared private in Quantum\Libraries\Database\Adapters\Sleekdb\SleekDbal. Since you implement __get, consider adding a @property or @property-read.

                    throw ModelException::wrongRelation(get_class($modelToJoin), $currentItem->table);
                }

                $newQueryBuilder->where([
                    $modelToJoin->foreignKeys[$currentItem->table],
                    '=',
                    $item[$currentItem->idColumn]

The property $idColumn is declared private in Quantum\Libraries\Database\Adapters\Sleekdb\SleekDbal. Since you implement __get, consider adding a @property or @property-read.

                ]);
            } else if ($joinType == self::JOINTHROUGH) {

The constant Quantum\Libraries\Database\Adapters\Sleekdb\Statements\Join::JOINTHROUGH was not found. Maybe you did not declare it correctly or list all dependencies?

                if (!isset($currentItem->foreignKeys[$modelToJoin->table])) {

The property $foreignKeys is declared private in Quantum\Libraries\Database\Adapters\Sleekdb\SleekDbal. Since you implement __get, consider adding a @property or @property-read.

                    throw ModelException::wrongRelation(get_class($modelToJoin), $currentItem->table);
                }

                $newQueryBuilder->where([
                    $modelToJoin->idColumn,
                    '=',
                    $item[$currentItem->foreignKeys[$modelToJoin->table]]
                ]);
            }

            if ($switch && isset($this->joins[$level])) {
                $sleekModel = new self($modelToJoin->table, $modelToJoin->idColumn, $modelToJoin->foreignKeys);
                $this->applyJoin($newQueryBuilder, $sleekModel, $this->joins[$level], ++$level);
            }

            return $newQueryBuilder;

        }, $modelToJoin->table);

        if (!$switch && isset($this->joins[$level])) {
            $this->applyJoin($queryBuilder, $currentItem, $this->joins[$level], ++$level);
        }

        return $queryBuilder;
    }
}