HasOneOrManyThrough::getRelationExistenceQuery() - Code Metrics - staudenmeir/eloquent-json-relations - Measure and Improve Code Quality continuously with Scrutinizer

HasOneOrManyThrough::getRelationExistenceQuery() A
last analyzed 2024-09-07 13:32 UTC

↳ Parent: HasOneOrManyThrough

Complexity

Conditions	3
Paths	3

Size

Total Lines	18
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	0

Metric	Value
cc	3
eloc	10
nc	3
nop	3
dl	0
loc	18
rs	9.9332
c	2
b	0
f	0

<?php

namespace Staudenmeir\EloquentJsonRelations\Relations\Postgres;

use Illuminate\Database\Eloquent\Builder;

trait HasOneOrManyThrough
{
    use IsPostgresRelation;

    /**
     * Set the join clause on the query.
     *
     * @param \Illuminate\Database\Eloquent\Builder|null $query
     * @return void
     */
    protected function performJoin(?Builder $query = null)
    {
        $query = $query ?: $this->query;

        $farKey = $this->jsonColumn($query, $this->throughParent, $this->getQualifiedFarKeyName(), $this->secondLocalKey);
        $farKey = $this->jsonColumn($query, $this->throughParent, $this->/** @scrutinizer ignore-call */ getQualifiedFarKeyName(), $this->secondLocalKey);

        $query->join($this->throughParent->getTable(), $this->getQualifiedParentKeyName(), '=', $farKey);
        $query->join($this->throughParent->getTable(), $this->/** @scrutinizer ignore-call */ getQualifiedParentKeyName(), '=', $farKey);

        if ($this->throughParentSoftDeletes()) {
        if ($this->/** @scrutinizer ignore-call */ throughParentSoftDeletes()) {
            $query->whereNull($this->throughParent->getQualifiedDeletedAtColumn());
        }
    }

    /**
     * Add the constraints for a relationship query.
     *
     * @param \Illuminate\Database\Eloquent\Builder $query
     * @param \Illuminate\Database\Eloquent\Builder $parentQuery
     * @param array|mixed $columns
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function getRelationExistenceQuery(Builder $query, Builder $parentQuery, $columns = ['*'])
    {
        if ($parentQuery->getQuery()->from === $query->getQuery()->from) {
            return $this->getRelationExistenceQueryForSelfRelation($query, $parentQuery, $columns);
        }

        if ($parentQuery->getQuery()->from === $this->throughParent->getTable()) {
            return $this->getRelationExistenceQueryForThroughSelfRelation($query, $parentQuery, $columns);
        }

        $this->performJoin($query);

        $firstKey = $this->jsonColumn($query, $this->farParent, $this->getQualifiedFirstKeyName(), $this->localKey);
        $firstKey = $this->jsonColumn($query, $this->farParent, $this->/** @scrutinizer ignore-call */ getQualifiedFirstKeyName(), $this->localKey);

        return $query->select($columns)->whereColumn(

            $this->getQualifiedLocalKeyName(),
                   getQualifiedLocalKeyName(),
            '=',
            $firstKey
            /** @scrutinizer ignore-type */ $firstKey
        );
    }

    /**
     * Add the constraints for a relationship query on the same table.
     *
     * @param \Illuminate\Database\Eloquent\Builder $query
     * @param \Illuminate\Database\Eloquent\Builder $parentQuery
     * @param array|mixed $columns
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function getRelationExistenceQueryForSelfRelation(Builder $query, Builder $parentQuery, $columns = ['*'])
    {
        $query->from($query->getModel()->getTable().' as '.$hash = $this->getRelationCountHash());
        $query->from($query->getModel()->getTable().' as '.$hash = $this->/** @scrutinizer ignore-call */ getRelationCountHash());

        $farKey = $this->jsonColumn($query, $this->throughParent, $hash.'.'.$this->secondKey, $this->secondLocalKey);

        $query->join($this->throughParent->getTable(), $this->getQualifiedParentKeyName(), '=', $farKey);

        $query->getModel()->setTable($hash);

        $firstKey = $this->jsonColumn($query, $this->farParent, $this->getQualifiedFirstKeyName(), $this->localKey);

        return $query->select($columns)->whereColumn(

            $parentQuery->getQuery()->from.'.'.$this->localKey,
            /** @scrutinizer ignore-type */ $parentQuery->getQuery()->from.'.'.$this->localKey,
            '=',
            $firstKey
            /** @scrutinizer ignore-type */ $firstKey
        );
    }

    /**
     * Add the constraints for a relationship query on the same table as the through parent.
     *
     * @param \Illuminate\Database\Eloquent\Builder $query
     * @param \Illuminate\Database\Eloquent\Builder $parentQuery
     * @param array|mixed $columns
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function getRelationExistenceQueryForThroughSelfRelation(Builder $query, Builder $parentQuery, $columns = ['*'])
    {
        $table = $this->throughParent->getTable().' as '.$hash = $this->getRelationCountHash();

        $farKey = $this->jsonColumn($query, $this->throughParent, $this->getQualifiedFarKeyName(), $this->secondLocalKey);

        $query->join($table, $hash.'.'.$this->secondLocalKey, '=', $farKey);

        if ($this->throughParentSoftDeletes()) {
            $query->whereNull($hash.'.'.$this->throughParent->getDeletedAtColumn());
        }

        $firstKey = $this->jsonColumn($query, $this->farParent, $hash.'.'.$this->firstKey, $this->localKey);

        return $query->select($columns)->whereColumn(

            $parentQuery->getQuery()->from.'.'.$this->localKey,
            /** @scrutinizer ignore-type */ $parentQuery->getQuery()->from.'.'.$this->localKey,
            '=',
            $firstKey
            /** @scrutinizer ignore-type */ $firstKey
        );
    }
}


staudenmeir / eloquent-json-relations

HasOneOrManyThrough::getRelationExistenceQuery() A last analyzed 2024-09-07 13:32 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

HasOneOrManyThrough::getRelationExistenceQuery() A
last analyzed 2024-09-07 13:32 UTC