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

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

↳ Parent: HasOneOrManyThrough

Complexity

Conditions	3
Paths	2

Size

Total Lines	10
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	3
eloc	5
nc	2
nop	1
dl	0
loc	10
rs	10
c	1
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::performJoin() A last analyzed 2024-09-07 13:32 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

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