Recca0120\Repository\Concerns\QueriesRelationships

Complexity

Total Complexity

12

Size/Duplication

Total Lines	175
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Test Coverage

Coverage

100%

Importance

Changes

0

12 Methods

Rating	Name	Duplication	Size	Complexity
A	has()	0	6	1
A	orHas()	0	6	1
A	doesntHave()	0	6	1
A	whereHas()	0	6	1
A	orWhereHas()	0	6	1
A	whereDoesntHave()	0	6	1
A	withCount()	0	6	1
A	withMax()	0	6	1
A	withMin()	0	6	1
A	withSum()	0	6	1
A	withAvg()	0	4	1
A	mergeConstraintsFrom()	0	6	1

<?php

namespace Recca0120\Repository\Concerns;

use Closure;
use Illuminate\Database\Eloquent\Builder;
use Recca0120\Repository\Method;

trait QueriesRelationships
{
    /**
     * Add a relationship count / exists condition to the query.
     *
     * @param string $relation
     * @param string $operator
     * @param int $count
     * @param string $boolean
     * @param \Closure|null $callback
     * @return $this
     */
    public function has($relation, $operator = '>=', $count = 1, $boolean = 'and', Closure $callback = null)
    {
        $this->methods[] = new Method(__FUNCTION__, [$relation, $operator, $count, $boolean, $callback]);

The property methods does not exist. Did you maybe forget to declare it?

        return $this;
    }

    /**
     * Add a relationship count / exists condition to the query with an "or".
     *
     * @param string $relation
     * @param string $operator
     * @param int $count
     * @return $this
     */
    public function orHas($relation, $operator = '>=', $count = 1)
    {
        $this->methods[] = new Method(__FUNCTION__, [$relation, $operator, $count]);

        return $this;
    }

    /**
     * Add a relationship count / exists condition to the query.
     *
     * @param string $relation
     * @param string $boolean
     * @param \Closure|null $callback
     * @return $this
     */
    public function doesntHave($relation, $boolean = 'and', Closure $callback = null)
    {
        $this->methods[] = new Method(__FUNCTION__, [$relation, $boolean, $callback]);

        return $this;
    }

    /**
     * Add a relationship count / exists condition to the query with where clauses.
     *
     * @param string $relation
     * @param \Closure|null $callback
     * @param string $operator
     * @param int $count
     * @return $this
     */
    public function whereHas($relation, Closure $callback = null, $operator = '>=', $count = 1)
    {
        $this->methods[] = new Method(__FUNCTION__, [$relation, $callback, $operator, $count]);

        return $this;
    }

    /**
     * Add a relationship count / exists condition to the query with where clauses and an "or".
     *
     * @param string $relation
     * @param \Closure|null $callback
     * @param string $operator
     * @param int $count
     * @return $this
     */
    public function orWhereHas($relation, Closure $callback = null, $operator = '>=', $count = 1)
    {
        $this->methods[] = new Method(__FUNCTION__, [$relation, $callback, $operator, $count]);

        return $this;
    }

    /**
     * Add a relationship count / exists condition to the query with where clauses.
     *
     * @param string $relation
     * @param \Closure|null $callback
     * @return $this
     */
    public function whereDoesntHave($relation, Closure $callback = null)
    {
        $this->methods[] = new Method(__FUNCTION__, [$relation, $callback]);

        return $this;
    }

    /**
     * Add subselect queries to count the relations.
     *
     * @param mixed $relations
     * @return $this
     */
    public function withCount($relations)
    {
        $this->methods[] = new Method(__FUNCTION__, [$relations]);

        return $this;
    }

    /**
     * Add subselect queries to include the max of the relation's column.
     *
     * @param string|array $relation
     * @param string $column
     * @return $this
     */
    public function withMax($relation, $column)
    {
        $this->methods[] = new Method(__FUNCTION__, [$relation, $column]);

        return $this;
    }

    /**
     * Add subselect queries to include the min of the relation's column.
     *
     * @param string|array $relation
     * @param string $column
     * @return $this
     */
    public function withMin($relation, $column)
    {
        $this->methods[] = new Method(__FUNCTION__, [$relation, $column]);

        return $this;
    }

    /**
     * Add subselect queries to include the sum of the relation's column.
     *
     * @param string|array $relation
     * @param string $column
     * @return $this
     */
    public function withSum($relation, $column)
    {
        $this->methods[] = new Method(__FUNCTION__, [$relation, $column]);

        return $this;
    }

    /**
     * Add subselect queries to include the average of the relation's column.
     *
     * @param string|array $relation
     * @param string $column
     * @return $this
     */
    public function withAvg($relation, $column)
    {
        return $this->withAggregate($relation, $column, 'avg');

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

    }

    /**
     * Merge the where constraints from another query to the current query.
     *
     * @param \Illuminate\Database\Eloquent\Builder $from
     * @return $this
     */
    public function mergeConstraintsFrom(Builder $from)
    {
        $this->methods[] = new Method(__FUNCTION__, [$from]);

        return $this;
    }
}