Trait Illuminate\Database\Eloquent\Concerns\QueriesRelationships


					
	public

has<TRelatedModel is Model>(
	Relation<TRelatedModel, *, *>|string $relation,
	string $operator = '>=',
	int $count = 1,
	string $boolean = 'and',
	(Closure(Builder<TRelatedModel>): mixed)|null $callback = null,
): $this

Add a relationship count / exists condition to the query.

Throws

RuntimeException

#


					
	protected

hasNested(
	string $relations,
	string $operator = '>=',
	int $count = 1,
	string $boolean = 'and',
	(Closure(Builder<*>): mixed)|null $callback = null,
): $this

Add nested relationship count / exists conditions to the query.

Sets up recursive call to whereHas until we finish the nested relation.

#


					
	public

orHas(Relation<*, *, *>|string $relation, string $operator = '>=', int $count = 1): $this

Add a relationship count / exists condition to the query with an "or".

#


					
	public

doesntHave<TRelatedModel is Model>(
	Relation<TRelatedModel, *, *>|string $relation,
	string $boolean = 'and',
	(Closure(Builder<TRelatedModel>): mixed)|null $callback = null,
): $this

Add a relationship count / exists condition to the query.

#


					
	public

orDoesntHave(Relation<*, *, *>|string $relation): $this

Add a relationship count / exists condition to the query with an "or".

#


					
	public

whereHas<TRelatedModel is Model>(
	Relation<TRelatedModel, *, *>|string $relation,
	(Closure(Builder<TRelatedModel>): mixed)|null $callback = null,
	string $operator = '>=',
	int $count = 1,
): $this

Add a relationship count / exists condition to the query with where clauses.

#


					
	public

withWhereHas(
	string $relation,
	(Closure(Builder<*>|Relation<*, *, *>): mixed)|null $callback = null,
	string $operator = '>=',
	int $count = 1,
): $this

Add a relationship count / exists condition to the query with where clauses.

Also load the relationship with the same condition.

#


					
	public

orWhereHas<TRelatedModel is Model>(
	Relation<TRelatedModel, *, *>|string $relation,
	(Closure(Builder<TRelatedModel>): mixed)|null $callback = null,
	string $operator = '>=',
	int $count = 1,
): $this

Add a relationship count / exists condition to the query with where clauses and an "or".

#


					
	public

whereDoesntHave<TRelatedModel is Model>(
	Relation<TRelatedModel, *, *>|string $relation,
	(Closure(Builder<TRelatedModel>): mixed)|null $callback = null,
): $this

Add a relationship count / exists condition to the query with where clauses.

#


					
	public

orWhereDoesntHave<TRelatedModel is Model>(
	Relation<TRelatedModel, *, *>|string $relation,
	(Closure(Builder<TRelatedModel>): mixed)|null $callback = null,
): $this

Add a relationship count / exists condition to the query with where clauses and an "or".

#


					
	public

hasMorph<TRelatedModel is Model>(
	MorphTo<TRelatedModel, *>|string $relation,
	string|array<int, string> $types,
	string $operator = '>=',
	int $count = 1,
	string $boolean = 'and',
	(Closure(Builder<TRelatedModel>, string): mixed)|null $callback = null,
): $this

Add a polymorphic relationship count / exists condition to the query.

#


					
	protected

getBelongsToRelation<TRelatedModel is Model, TDeclaringModel is Model>(
	MorphTo<*, TDeclaringModel> $relation,
	class-string<TRelatedModel> $type,
): BelongsTo<TRelatedModel, TDeclaringModel>

Get the BelongsTo relationship for a single polymorphic type.

#


					
	public

orHasMorph(
	MorphTo<*, *>|string $relation,
	string|array<int, string> $types,
	string $operator = '>=',
	int $count = 1,
): $this

Add a polymorphic relationship count / exists condition to the query with an "or".

#


					
	public

doesntHaveMorph<TRelatedModel is Model>(
	MorphTo<TRelatedModel, *>|string $relation,
	string|array<int, string> $types,
	string $boolean = 'and',
	(Closure(Builder<TRelatedModel>, string): mixed)|null $callback = null,
): $this

Add a polymorphic relationship count / exists condition to the query.

#


					
	public

orDoesntHaveMorph(MorphTo<*, *>|string $relation, string|array<int, string> $types): $this

Add a polymorphic relationship count / exists condition to the query with an "or".

#


					
	public

whereHasMorph<TRelatedModel is Model>(
	MorphTo<TRelatedModel, *>|string $relation,
	string|array<int, string> $types,
	(Closure(Builder<TRelatedModel>, string): mixed)|null $callback = null,
	string $operator = '>=',
	int $count = 1,
): $this

Add a polymorphic relationship count / exists condition to the query with where clauses.

#


					
	public

orWhereHasMorph<TRelatedModel is Model>(
	MorphTo<TRelatedModel, *>|string $relation,
	string|array<int, string> $types,
	(Closure(Builder<TRelatedModel>, string): mixed)|null $callback = null,
	string $operator = '>=',
	int $count = 1,
): $this

Add a polymorphic relationship count / exists condition to the query with where clauses and an "or".

#


					
	public

whereDoesntHaveMorph<TRelatedModel is Model>(
	MorphTo<TRelatedModel, *>|string $relation,
	string|array<int, string> $types,
	(Closure(Builder<TRelatedModel>, string): mixed)|null $callback = null,
): $this

Add a polymorphic relationship count / exists condition to the query with where clauses.

#


					
	public

orWhereDoesntHaveMorph<TRelatedModel is Model>(
	MorphTo<TRelatedModel, *>|string $relation,
	string|array<int, string> $types,
	(Closure(Builder<TRelatedModel>, string): mixed)|null $callback = null,
): $this

Add a polymorphic relationship count / exists condition to the query with where clauses and an "or".

#


					
	public

whereRelation<TRelatedModel is Model>(
	Relation<TRelatedModel, *, *>|string $relation,
	(Closure(Builder<TRelatedModel>): mixed)|string|array|Expression $column,
	mixed $operator = null,
	mixed $value = null,
): $this

Add a basic where clause to a relationship query.

#


					
	public

withWhereRelation(
	Relation<*, *, *>|string $relation,
	Closure|string|array|Expression $column,
	mixed $operator = null,
	mixed $value = null,
): $this

Add a basic where clause to a relationship query and eager-load the relationship with the same conditions.

#


					
	public

orWhereRelation<TRelatedModel is Model>(
	Relation<TRelatedModel, *, *>|string $relation,
	(Closure(Builder<TRelatedModel>): mixed)|string|array|Expression $column,
	mixed $operator = null,
	mixed $value = null,
): $this

Add an "or where" clause to a relationship query.

#


					
	public

whereDoesntHaveRelation<TRelatedModel is Model>(
	Relation<TRelatedModel, *, *>|string $relation,
	(Closure(Builder<TRelatedModel>): mixed)|string|array|Expression $column,
	mixed $operator = null,
	mixed $value = null,
): $this

Add a basic count / exists condition to a relationship query.

#


					
	public

orWhereDoesntHaveRelation<TRelatedModel is Model>(
	Relation<TRelatedModel, *, *>|string $relation,
	(Closure(Builder<TRelatedModel>): mixed)|string|array|Expression $column,
	mixed $operator = null,
	mixed $value = null,
): $this

Add an "or where" clause to a relationship query.

#


					
	public

whereMorphRelation<TRelatedModel is Model>(
	MorphTo<TRelatedModel, *>|string $relation,
	string|array<int, string> $types,
	(Closure(Builder<TRelatedModel>): mixed)|string|array|Expression $column,
	mixed $operator = null,
	mixed $value = null,
): $this

Add a polymorphic relationship condition to the query with a where clause.

#


					
	public

orWhereMorphRelation<TRelatedModel is Model>(
	MorphTo<TRelatedModel, *>|string $relation,
	string|array<int, string> $types,
	(Closure(Builder<TRelatedModel>): mixed)|string|array|Expression $column,
	mixed $operator = null,
	mixed $value = null,
): $this

Add a polymorphic relationship condition to the query with an "or where" clause.

#


					
	public

whereMorphDoesntHaveRelation<TRelatedModel is Model>(
	MorphTo<TRelatedModel, *>|string $relation,
	string|array<int, string> $types,
	(Closure(Builder<TRelatedModel>): mixed)|string|array|Expression $column,
	mixed $operator = null,
	mixed $value = null,
): $this

Add a polymorphic relationship condition to the query with a doesn't have clause.

#


					
	public

orWhereMorphDoesntHaveRelation<TRelatedModel is Model>(
	MorphTo<TRelatedModel, *>|string $relation,
	string|array<int, string> $types,
	(Closure(Builder<TRelatedModel>): mixed)|string|array|Expression $column,
	mixed $operator = null,
	mixed $value = null,
): $this

Add a polymorphic relationship condition to the query with an "or doesn't have" clause.

#


					
	public

whereMorphedTo(MorphTo<*, *>|string $relation, Model|iterable<int, Model>|string|null $model, $boolean = 'and'): $this

Add a morph-to relationship condition to the query.

#


					
	public

whereNotMorphedTo(MorphTo<*, *>|string $relation, Model|iterable<int, Model>|string $model, $boolean = 'and'): $this

Add a not morph-to relationship condition to the query.

#


					
	public

orWhereMorphedTo(MorphTo<*, *>|string $relation, Model|iterable<int, Model>|string|null $model): $this

Add a morph-to relationship condition to the query with an "or where" clause.

#


					
	public

orWhereNotMorphedTo(MorphTo<*, *>|string $relation, Model|iterable<int, Model>|string $model): $this

Add a not morph-to relationship condition to the query with an "or where" clause.

#


					
	public

whereBelongsTo(
	Model|Collection<int, Model> $related,
	string|null $relationshipName = null,
	string $boolean = 'and',
): $this

Add a "belongs to" relationship where clause to the query.

Throws

Illuminate\Database\Eloquent\RelationNotFoundException

#


					
	public

orWhereBelongsTo(Model $related, string|null $relationshipName = null): $this

Add a "BelongsTo" relationship with an "or where" clause to the query.

Throws

RuntimeException

#


					
	public

withAggregate(mixed $relations, Expression|string $column, string $function = null): $this

Add subselect queries to include an aggregate value for a relationship.

#


					
	protected

getRelationHashedColumn(string $column, Relation<*, *, *> $relation): string

Get the relation hashed column name for the given column and relation.

#


					
	public

withCount(mixed $relations): $this

Add subselect queries to count the relations.

#


					
	public

withMax(string|array $relation, Expression|string $column): $this

Add subselect queries to include the max of the relation's column.

#


					
	public

withMin(string|array $relation, Expression|string $column): $this

Add subselect queries to include the min of the relation's column.

#


					
	public

withSum(string|array $relation, Expression|string $column): $this

Add subselect queries to include the sum of the relation's column.

#


					
	public

withAvg(string|array $relation, Expression|string $column): $this

Add subselect queries to include the average of the relation's column.

#


					
	public

withExists(string|array $relation): $this

Add subselect queries to include the existence of related models.

#


					
	protected

addHasWhere(Builder<*> $hasQuery, Relation<*, *, *> $relation, string $operator, int $count, string $boolean): $this

Add the "has" condition where clause to the query.

#


					
	public

mergeConstraintsFrom(Builder<*> $from): $this

Merge the where constraints from another query to the current query.

#


					
	protected

requalifyWhereTables(array $wheres, string $from, string $to): array

Updates the table name for any columns with a new qualified name.

#


					
	protected

addWhereCountQuery(Builder $query, string $operator = '>=', int $count = 1, string $boolean = 'and'): $this

Add a sub-query count clause to this query.

#


					
	protected

getRelationWithoutConstraints(string $relation): Relation<*, *, *>

Get the "has relation" base query instance.

#


					
	protected

canUseExistsForExistenceCheck(string $operator, int $count): bool

Check if we can run an "exists" query to optimize performance.

#

Namespaces

Traits

Trait Illuminate\Database\Eloquent\Concerns\QueriesRelationships

Throws

Throws

Throws