Quantum\Libraries\Database\Adapters\Idiorm\Statements\Criteria

Complexity

Total Complexity

19

Size/Duplication

Total Lines	115
Duplicated Lines	0 %

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	criteria()	0	8	2
A	having()	0	9	2
A	criterias()	0	11	4
A	isNotNull()	0	4	1
A	addCriteria()	0	8	5
A	isNull()	0	4	1
A	orCriteria()	0	22	4

<?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.7
 */

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

use Quantum\Libraries\Database\Exceptions\DatabaseException;
use Quantum\Libraries\Database\Contracts\DbalInterface;

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

    /**
     * @inheritDoc
     * @throws DatabaseException
     */
    public function criteria(string $column, string $operator, $value = null): DbalInterface
    {
        if (!key_exists($operator, $this->operators)) {
            throw DatabaseException::operatorNotSupported($operator);
        }

        $this->addCriteria($column, $operator, $value, $this->operators[$operator]);
        return $this;

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

    }

    /**
     * @inheritDoc
     * @throws DatabaseException
     */
    public function criterias(...$criterias): DbalInterface
    {
        foreach ($criterias as $criteria) {
            if (isset($criteria[0]) && is_array($criteria[0])) {
                $this->orCriteria($criteria);
            } else {
                $this->criteria(...$criteria);

The call to Quantum\Libraries\Database\Adapters\Idiorm\Statements\Criteria::criteria() has too few arguments starting with operator.

            }
        }

        return $this;

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

    }

    /**
     * @inheritDoc
     * @throws DatabaseException
     */
    public function having(string $column, string $operator, string $value = null): DbalInterface
    {
        if (!key_exists($operator, $this->operators)) {
            throw DatabaseException::operatorNotSupported($operator);
        }

        $func = $this->operators[$operator];
        $this->getOrmModel()->$func($column, $value);

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

        return $this;

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

    }

    /**
     * @inheritDoc
     * @throws DatabaseException
     */
    public function isNull(string $column): DbalInterface
    {
        $this->getOrmModel()->where_null($column);
        return $this;

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

    }

    /**
     * @inheritDoc
     * @throws DatabaseException
     */
    public function isNotNull(string $column): DbalInterface
    {
        $this->getOrmModel()->where_not_null($column);
        return $this;

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

    }

    /**
     * Adds Criteria
     * @param string $column
     * @param string $operator
     * @param mixed $value
     * @param string|null $func
     * @throws DatabaseException
     */
    protected function addCriteria(string $column, string $operator, $value, string $func = null)
    {
        if ($operator == '#=#') {
            $this->getOrmModel()->where_raw($column . ' = ' . $value);
        } else if (is_array($value) && count($value) == 1 && key($value) == 'fn') {
            $this->getOrmModel()->where_raw($column . ' ' . $operator . ' ' . $value['fn']);
        } else {
            $this->getOrmModel()->$func($column, $value);
        }
    }

    /**
     * Adds one or more OR criteria in brackets
     * @param array $orCriterias
     * @throws DatabaseException
     */
    protected function orCriteria(array $orCriterias)
    {
        $clause = '';
        $params = [];

        foreach ($orCriterias as $index => $criteria) {
            if ($index == 0) {
                $clause .= '(';
            }

            $clause .= '`' . $criteria[0] . '` ' . $criteria[1] . ' ?';

            if ($index == array_key_last($orCriterias)) {
                $clause .= ')';
            } else {
                $clause .= ' OR ';
            }

            $params[] = $criteria[2];
        }

        $this->getOrmModel()->where_raw($clause, $params);
    }
}