BuildsSelects::orderByRaw() - Code Metrics - Inspection of "Converted Eloquent features" - LaravelFreelancerNL/laravel-arangodb - Measure and Improve Code Quality continuously with Scrutinizer

Failed Conditions

Push — refactor/improve-static-analys... ( ba8000...c6edde )

by Bas

created 2023-12-25 12:22 UTC

BuildsSelects::orderByRaw() B

↳ Parent: BuildsSelects

Complexity

Conditions	7
Paths	8

Size

Total Lines	20
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	7
eloc	10
c	1
b	0
f	0
nc	8
nop	2
dl	0
loc	20
rs	8.8333

<?php

declare(strict_types=1);

namespace LaravelFreelancerNL\Aranguent\Query\Concerns;

use Exception;
use Illuminate\Database\Query\Builder as IlluminateQueryBuilder;
use Illuminate\Database\Query\Expression;
use InvalidArgumentException;
use LaravelFreelancerNL\Aranguent\Query\Grammar;

/**
 * @method isQueryable(mixed $column)
 */
trait BuildsSelects
{
    /**
     * Set the table which the query is targeting.
     *
     * @param \Closure|IlluminateQueryBuilder|string $table
     * @param string|null $as
     * @return IlluminateQueryBuilder
     */
    public function from($table, $as = null)
    {
        if ($this->isQueryable($table)) {
            return $this->fromSub($table, $as);
            return $this->/** @scrutinizer ignore-call */ fromSub($table, $as);
        }
        $this->registerTableAlias($table, $as);
               registerTableAlias($table, $as);

        $this->from = $table;


        return $this;

    }

    /**
     * Set the columns to be selected.
     *
     * @param array<mixed>|mixed $columns
     * @return IlluminateQueryBuilder
     * @throws Exception
     */
    public function select($columns = ['*']): IlluminateQueryBuilder
    {
        $this->columns = [];

        $this->bindings['select'] = [];


        $columns = is_array($columns) ? $columns : func_get_args();

        foreach ($columns as $as => $column) {
            if (is_string($as) && $this->isQueryable($column)) {
                $this->selectSub($column, $as);
                continue;
            }

            $this->addColumns([$as => $column]);
        }

        return $this;

    }

    /**
     * Add a subselect expression to the query.
     *
     * @param \Closure|\Illuminate\Database\Query\Builder|\Illuminate\Database\Eloquent\Builder|string $query
     * @param string $as
     * @return $this
     *
     * @throws \InvalidArgumentException
     * @throws Exception
     */
    public function selectSub($query, $as)
    {
        [$query] = $this->createSub($query, true);
        [$query] = $this->createSub($query, true);

        $this->set($as, new Expression($query), 'postIterationVariables');
               set($as, new Expression($query), 'postIterationVariables');

        $this->addColumns([$as]);

        return $this;
    }

    /**
     * Add a new select column to the query.
     *
     * @param array|mixed $column
     * @return $this
     */
    public function addSelect($column)
    {
        $columns = is_array($column) ? $column : func_get_args();

        $this->addColumns($columns);

        return $this;
    }

    /**
     * @param array<mixed> $columns
     */
    protected function addColumns(array $columns): void
    {
        foreach ($columns as $as => $column) {
            if (is_string($as) && $this->isQueryable($column)) {
                if (is_null($this->columns)) {
                    $this->select($this->from . '.*');
                }

                $this->selectSub($column, $as);

                continue;
            }

            if (is_string($as)) {
                $this->columns[$as] = $column;


                continue;
            }

            $this->columns[] = $column;
        }
    }

    /**
     * Add an "order by" clause to the query.
     *
     * @param \Closure|\Illuminate\Database\Query\Builder|\Illuminate\Database\Eloquent\Builder|\Illuminate\Contracts\Database\Query\Expression|string $column
     * @param string $direction
     * @return $this
     *
     * @throws \InvalidArgumentException
     */
    public function orderBy($column, $direction = 'asc')
    {
        if ($this->isQueryable($column)) {
            [$query, $bindings] = $this->createSub($column);

            $column = new Expression('(' . $query . ')');

            $this->addBinding($bindings, $this->unions ? 'unionOrder' : 'order');
                   addBinding($bindings, $this->unions ? 'unionOrder' : 'order');
        }

        $direction = strtoupper($direction);

        if (!in_array($direction, ['ASC', 'DESC'], true)) {
            throw new InvalidArgumentException('Order direction must be "asc" or "desc".');
        }

        $this->{$this->unions ? 'unionOrders' : 'orders'}[] = [
            'column' => $column,
            'direction' => $direction,
        ];

        return $this;
    }

    public function orderByRaw($sql, $bindings = [])
    {
        $type = 'Raw';

        $sql = new Expression($sql);

        $this->{$this->unions ? 'unionOrders' : 'orders'}[] = compact('type', 'sql');

        if (!isset($this->bindings[$this->unions ? 'unionOrders' : 'orders'])) {
            $this->bindings[$this->unions ? 'unionOrders' : 'orders'] = $bindings;


            return $this;
        }

        $this->bindings[$this->unions ? 'unionOrders' : 'orders'] = array_merge(
            $this->bindings[$this->unions ? 'unionOrders' : 'orders'],
            $bindings
        );

        return $this;
    }

    /**
     * Put the query's results in random order.
     *
     * @param string $seed
     * @return $this
     */
    public function inRandomOrder($seed = '')
    {
        assert($this->grammar instanceof Grammar);

        // ArangoDB's random function doesn't accept a seed.
        unset($seed);

        return $this->orderByRaw($this->grammar->compileRandom());
    }

    /**
     * Add a union statement to the query.
     *
     * @param  \Closure|\Illuminate\Database\Query\Builder|\Illuminate\Database\Eloquent\Builder  $query
     * @param  bool  $all
     * @return $this
     */
    public function union($query, $all = false)
    {
        if ($query instanceof \Closure) {
            $query($query = $this->newQuery());
            $query($query = $this->/** @scrutinizer ignore-call */ newQuery());
        }
        $this->importBindings($query);
               importBindings($query);
        $this->unions[] = compact('query', 'all');


        return $this;
    }
}


LaravelFreelancerNL / laravel-arangodb

Push — refactor/improve-static-analys... ( ba8000...c6edde )

BuildsSelects::orderByRaw() B

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like