Omatech\Enigma\Database\Eloquent\Builder

Complexity

Total Complexity

10

Size/Duplication

Total Lines	95
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	orWhere()	0	20	4
A	where()	0	20	4
A	findByHash()	0	14	2

<?php

namespace Omatech\Enigma\Database\Eloquent;

use Closure;
use Omatech\Enigma\Enigma;

/**
 * @mixin \Illuminate\Database\Query\Builder
 * @method whereRaw($sql, $bindings = [], $boolean = 'and')
 */
class Builder extends \Illuminate\Database\Eloquent\Builder
{
    /**
     * Add a basic where clause to the query.
     *
     * @param Closure|string|array $column
     * @param mixed $operator
     * @param mixed $value
     * @param string $boolean
     * @return \Illuminate\Database\Eloquent\Builder
     * @throws \ParagonIE\CipherSweet\Exception\BlindIndexNameCollisionException
     * @throws \ParagonIE\CipherSweet\Exception\BlindIndexNotFoundException
     * @throws \ParagonIE\CipherSweet\Exception\CryptoOperationException
     * @throws \SodiumException
     */
    public function where($column, $operator = null, $value = null, $boolean = 'and'): \Illuminate\Database\Eloquent\Builder
    {
        $enigma = (array) $this->model->getEnigmaEncryptable();

        if (
            ! $column instanceof Closure &&
            in_array($column, $enigma, true) !== false
        ) {
            [$value, $operator] = $this->query->prepareValueAndOperator(
                $value,
                $operator,
                func_num_args() === 2
            );

            if ($value) {
                return $this->findByHash($column, $value);
            }
        }

        return parent::where($column, $operator, $value, $boolean);
    }

    /**
     * Add an "or where" clause to the query.
     *
     * @param \Closure|array|string $column
     * @param mixed $operator
     * @param mixed $value
     * @return \Illuminate\Database\Eloquent\Builder
     * @throws \ParagonIE\CipherSweet\Exception\BlindIndexNameCollisionException
     * @throws \ParagonIE\CipherSweet\Exception\BlindIndexNotFoundException
     * @throws \ParagonIE\CipherSweet\Exception\CryptoOperationException
     * @throws \SodiumException
     */
    public function orWhere($column, $operator = null, $value = null): \Illuminate\Database\Eloquent\Builder
    {
        $enigma = (array) $this->model->getEnigmaEncryptable();

        if (
            ! $column instanceof Closure &&
            in_array($column, $enigma, true) !== false
        ) {
            [$value, $operator] = $this->query->prepareValueAndOperator(
                $value,
                $operator,
                func_num_args() === 2
            );

            if ($value) {
                return $this->findByHash($column, $value, 'or');
            }
        }

        return parent::orWhere($column, $operator, $value);
    }

    /**
     * @param $column
     * @param $value
     * @param string $boolean
     * @return Builder
     * @throws \ParagonIE\CipherSweet\Exception\BlindIndexNameCollisionException
     * @throws \ParagonIE\CipherSweet\Exception\BlindIndexNotFoundException
     * @throws \ParagonIE\CipherSweet\Exception\CryptoOperationException
     * @throws \SodiumException
     */
    private function findByHash($column, $value, $boolean = 'and'): self
    {
        $ids = (new Enigma)
            ->searchAsModel($this->getModel(), $column, $value);

        $closure = function (self $query) use ($ids) {
            $query->whereRaw("{$this->model->getTable()}.id IN ($ids)");
        };

        $boolean === 'and'
            ? $this->where($closure)
            : $this->orWhere($closure);

        return $this;
    }
}