Quantum\Libraries\Database\Statements\Join

Complexity

Total Complexity

8

Size/Duplication

Total Lines	84
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	leftJoin()	0	4	1
A	joinTo()	0	17	2
A	rightJoin()	0	4	1
A	join()	0	3	1
A	innerJoin()	0	3	1
A	joinThrough()	0	17	2

<?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.4.0
 */
namespace Quantum\Libraries\Database\Statements;

use Quantum\Libraries\Database\IdiormPatch;
use Quantum\Mvc\QtModel;

/**
 * Trait Join
 * @package Quantum\Libraries\Database\Statements
 */
Trait Join
{
    /**
     * Adds a simple JOIN source to the query
     * @inheritDoc
     */
    public function join(string $table, array $constraint, string $tableAlias = null): object
    {
        return $this->ormObject->join($table, $constraint, $tableAlias);
    }

    /**
     * Adds an INNER JOIN source to the query
     * @inheritDoc
     */
    public function innerJoin(string $table, array $constraint, ?string $tableAlias = null): object
    {
        return $this->ormObject->inner_join($table, $constraint, $tableAlias);
    }

    /**
     * Adds an LEFT JOIN source to the query
     * @inheritDoc
     */
    public function leftJoin(string $table, array $constraint, ?string $tableAlias = null): object
    {
        $this->ormPatch = IdiormPatch::getInstance()->setOrmObject($this->ormObject);

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

        return $this->ormPatch->left_join($table, $constraint, $tableAlias);
    }

    /**
     * Adds an RIGHT JOIN source to the query
     * @inheritDoc
     */
    public function rightJoin(string $table, array $constraint, ?string $tableAlias = null): object
    {
        $this->ormPatch = IdiormPatch::getInstance()->setOrmObject($this->ormObject);

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

        return $this->ormPatch->right_join($table, $constraint, $tableAlias);
    }

    /**
     * Joins two models
     * @inheritDoc
     */
    public function joinTo(QtModel $model, bool $switch = true): object
    {
        $resultObject = $this->ormObject->join($model->table,
            [
                $model->table . '.' . $model->foreignKeys[$this->table],
                '=',
                $this->table . '.' . $this->idColumn
            ]
        );

        if ($switch) {
            $this->table = $model->table;

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

            $this->idColumn = $model->idColumn;

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

            $this->foreignKeys = $model->foreignKeys;

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

        }

        return $resultObject;
    }

    /**
     * Joins through connector model
     * @inheritDoc
     */
    public function joinThrough(QtModel $model, bool $switch = true): object
    {
        $resultObject = $this->ormObject->join($model->table,
            [
                $model->table . '.' . $model->idColumn,
                '=',
                $this->table . '.' . $this->foreignKeys[$model->table]
            ]
        );

        if ($switch) {
            $this->table = $model->table;

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

            $this->idColumn = $model->idColumn;

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

            $this->foreignKeys = $model->foreignKeys;

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

        }

        return $resultObject;
    }

}