BelongsToMany
class BelongsToMany extends Relation (View source)
Traits
Properties
| static protected array | $macros | The registered string macros. |
from Macroable |
| protected Builder | $query | The Eloquent query builder instance. |
from Relation |
| protected Model | $parent | The parent model instance. |
from Relation |
| protected Model | $related | The related model instance. |
from Relation |
| protected bool | $eagerKeysWereEmpty | Indicates whether the eagerly loaded relation should implicitly return an empty collection. |
from Relation |
| static protected bool | $constraints | Indicates if the relation is adding constraints. |
from Relation |
| static array | $morphMap | An array to map class names to their morph names in the database. |
from Relation |
| static protected bool | $requireMorphMap | Prevents morph relationships without a morph map. |
from Relation |
| static protected int | $selfJoinCount | The count of self joins. |
from Relation |
| protected string | $table | The intermediate table for the relation. |
|
| protected string | $foreignPivotKey | The foreign key of the parent model. |
|
| protected string | $relatedPivotKey | The associated key of the relation. |
|
| protected string | $parentKey | The key name of the parent model. |
|
| protected string | $relatedKey | The key name of the related model. |
|
| protected string | $relationName | The "name" of the relationship. |
|
| protected array | $pivotColumns | The pivot table columns to retrieve. |
|
| protected array | $pivotWheres | Any pivot table restrictions for where clauses. |
|
| protected array | $pivotWhereIns | Any pivot table restrictions for whereIn clauses. |
|
| protected array | $pivotWhereNulls | Any pivot table restrictions for whereNull clauses. |
|
| protected array | $pivotValues | The default values for the pivot columns. |
|
| bool | $withTimestamps | Indicates if timestamps are available on the pivot table. |
|
| protected string | $pivotCreatedAt | The custom pivot table column for the created_at timestamp. |
|
| protected string | $pivotUpdatedAt | The custom pivot table column for the updated_at timestamp. |
|
| protected string | $using | The class name of the custom pivot model to use for the relationship. |
|
| protected string | $accessor | The name of the accessor to use for the "pivot" relationship. |
Methods
| mixed | forwardCallTo(mixed $object, string $method, array $parameters) Forward a method call to the given object. |
from ForwardsCalls |
| mixed | forwardDecoratedCallTo(mixed $object, string $method, array $parameters) Forward a method call to the given object, returning $this if the forwarded call returned itself. |
from ForwardsCalls |
| static void | throwBadMethodCallException(string $method) Throw a bad method call exception for the given method. |
from ForwardsCalls |
| static void | macro(string $name, object|callable $macro) Register a custom macro. |
from Macroable |
| static void | mixin(object $mixin, bool $replace = true) Mix another object into the class. |
from Macroable |
| static bool | hasMacro(string $name) Checks if macro is registered. |
from Macroable |
| static void | flushMacros() Flush the existing macros. |
from Macroable |
| static mixed | __callStatic(string $method, array $parameters) Dynamically handle calls to the class. |
from Macroable |
| mixed | __call(string $method, array $parameters) Dynamically handle calls to the class. |
from Macroable |
| void | __construct(Builder $query, Model $parent, string $table, string $foreignPivotKey, string $relatedPivotKey, string $parentKey, string $relatedKey, string|null $relationName = null) Create a new belongs to many relationship instance. |
|
| static mixed | noConstraints(Closure $callback) Run a callback with constraints disabled on the relation. |
from Relation |
| void | addConstraints() Set the base constraints on the relation query. |
|
| void | addEagerConstraints(array $models) Set the constraints for an eager load of the relation. |
|
| array | initRelation(array $models, string $relation) Initialize the relation on a set of models. |
|
| array | match(array $models, Collection $results, string $relation) Match the eagerly loaded results to their parents. |
|
| mixed | getResults() Get the results of the relationship. |
|
| Collection | getEager() Get the relationship for eager loading. |
from Relation |
| Model | sole(array|string $columns = ['*']) Execute the query and get the first result if it's the sole matching record. |
from Relation |
| Collection | get(array $columns = ['*']) Execute the query as a "select" statement. |
|
| void | touch() Touch all of the related models for the relationship. |
|
| int | rawUpdate(array $attributes = []) Run a raw update against the base query. |
from Relation |
| Builder | getRelationExistenceCountQuery(Builder $query, Builder $parentQuery) Add the constraints for a relationship count query. |
from Relation |
| Builder | getRelationExistenceQuery(Builder $query, Builder $parentQuery, array|mixed $columns = ['*']) Add the constraints for a relationship query. |
|
| string | getRelationCountHash(bool $incrementJoinCount = true) Get a relationship join table hash. |
from Relation |
| array | getKeys(array $models, string|null $key = null) Get all of the primary keys for an array of models. |
from Relation |
| Builder | getRelationQuery() Get the query builder that will contain the relationship constraints. |
from Relation |
| Builder | getQuery() Get the underlying query for the relation. |
from Relation |
| Builder | getBaseQuery() Get the base query builder driving the Eloquent builder. |
from Relation |
| Builder | toBase() Get a base query builder instance. |
from Relation |
| Model | getParent() Get the parent model of the relation. |
from Relation |
| string | getQualifiedParentKeyName() Get the fully qualified parent key name for the relation. |
|
| Model | getRelated() Get the related model of the relation. |
from Relation |
| string | createdAt() Get the name of the "created at" column. |
|
| string | updatedAt() Get the name of the "updated at" column. |
|
| string | relatedUpdatedAt() Get the name of the related model's "updated at" column. |
from Relation |
| void | whereInEager(string $whereIn, string $key, array $modelKeys, Builder $query = null) Add a whereIn eager constraint for the given set of model keys to be loaded. |
from Relation |
| string | whereInMethod(Model $model, string $key) Get the name of the "where in" method for eager loading. |
from Relation |
| static void | requireMorphMap(bool $requireMorphMap = true) Prevent polymorphic relationships from being used without model mappings. |
from Relation |
| static bool | requiresMorphMap() Determine if polymorphic relationships require explicit model mapping. |
from Relation |
| static array | enforceMorphMap(array $map, bool $merge = true) Define the morph map for polymorphic relations and require all morphed models to be explicitly mapped. |
from Relation |
| static array | morphMap(array $map = null, bool $merge = true) Set or get the morph map for polymorphic relations. |
from Relation |
| static array|null | buildMorphMapFromModels(array $models = null) Builds a table-keyed array from model class names. |
from Relation |
| static string|null | getMorphedModel(string $alias) Get the model associated with a custom polymorphic type. |
from Relation |
| void | __clone() Force a clone of the underlying query builder when cloning. |
from Relation |
| mixed | getDictionaryKey(mixed $attribute) Get a dictionary key attribute - casting it to a string if necessary. |
from InteractsWithDictionary |
| array | toggle(mixed $ids, bool $touch = true) Toggles a model (or models) from the parent. |
from InteractsWithPivotTable |
| array | syncWithoutDetaching(Collection|Model|array $ids) Sync the intermediate tables with a list of IDs without detaching. |
from InteractsWithPivotTable |
| array | sync(Collection|Model|array $ids, bool $detaching = true) Sync the intermediate tables with a list of IDs or collection of models. |
from InteractsWithPivotTable |
| array | syncWithPivotValues(Collection|Model|array $ids, array $values, bool $detaching = true) Sync the intermediate tables with a list of IDs or collection of models with the given pivot values. |
from InteractsWithPivotTable |
| array | formatRecordsList(array $records) Format the sync / toggle record list so that it is keyed by ID. |
from InteractsWithPivotTable |
| array | attachNew(array $records, array $current, bool $touch = true) Attach all of the records that aren't in the given current records. |
from InteractsWithPivotTable |
| int | updateExistingPivot(mixed $id, array $attributes, bool $touch = true) Update an existing pivot record on the table. |
from InteractsWithPivotTable |
| int | updateExistingPivotUsingCustomClass(mixed $id, array $attributes, bool $touch) Update an existing pivot record on the table via a custom class. |
from InteractsWithPivotTable |
| void | attach(mixed $id, array $attributes = [], bool $touch = true) Attach a model to the parent. |
from InteractsWithPivotTable |
| void | attachUsingCustomClass(mixed $id, array $attributes) Attach a model to the parent using a custom class. |
from InteractsWithPivotTable |
| array | formatAttachRecords(array $ids, array $attributes) Create an array of records to insert into the pivot table. |
from InteractsWithPivotTable |
| array | formatAttachRecord(int $key, mixed $value, array $attributes, bool $hasTimestamps) Create a full attachment record payload. |
from InteractsWithPivotTable |
| array | extractAttachIdAndAttributes(mixed $key, mixed $value, array $attributes) Get the attach record ID and extra attributes. |
from InteractsWithPivotTable |
| array | baseAttachRecord(int $id, bool $timed) Create a new pivot attachment record. |
from InteractsWithPivotTable |
| array | addTimestampsToAttachment(array $record, bool $exists = false) Set the creation and update timestamps on an attach record. |
from InteractsWithPivotTable |
| bool | hasPivotColumn(string $column) Determine whether the given column is defined as a pivot column. |
from InteractsWithPivotTable |
| int | detach(mixed $ids = null, bool $touch = true) Detach models from the relationship. |
from InteractsWithPivotTable |
| int | detachUsingCustomClass(mixed $ids) Detach models from the relationship using a custom class. |
from InteractsWithPivotTable |
| Collection | getCurrentlyAttachedPivots() Get the pivot models that are currently attached. |
from InteractsWithPivotTable |
| Pivot | newPivot(array $attributes = [], bool $exists = false) Create a new pivot model instance. |
from InteractsWithPivotTable |
| Pivot | newExistingPivot(array $attributes = []) Create a new existing pivot model instance. |
from InteractsWithPivotTable |
| Builder | newPivotStatement() Get a new plain query builder for the pivot table. |
from InteractsWithPivotTable |
| Builder | newPivotStatementForId(mixed $id) Get a new pivot statement for a given "other" ID. |
from InteractsWithPivotTable |
| Builder | newPivotQuery() Create a new query builder for the pivot table. |
from InteractsWithPivotTable |
| $this | withPivot(array|mixed $columns) Set the columns on the pivot table to retrieve. |
from InteractsWithPivotTable |
| array | parseIds(mixed $value) Get all of the IDs from the given mixed value. |
from InteractsWithPivotTable |
| mixed | parseId(mixed $value) Get the ID from the given mixed value. |
from InteractsWithPivotTable |
| array | castKeys(array $keys) Cast the given keys to integers if they are numeric and string otherwise. |
from InteractsWithPivotTable |
| mixed | castKey(mixed $key) Cast the given key to convert to primary key type. |
from InteractsWithPivotTable |
| array | castAttributes(array $attributes) Cast the given pivot attributes. |
from InteractsWithPivotTable |
| mixed | getTypeSwapValue(string $type, mixed $value) Converts a given value to a given type value. |
from InteractsWithPivotTable |
| string | resolveTableName(string $table) Attempt to resolve the intermediate table name from the given string. |
|
| $this | performJoin(Builder|null $query = null) Set the join clause for the relation query. |
|
| $this | addWhereConstraints() Set the where clause for the relation query. |
|
| array | buildDictionary(Collection $results) Build model dictionary keyed by the relation's foreign key. |
|
| string | getPivotClass() Get the class being used for pivot models. |
|
| $this | using(string $class) Specify the custom pivot model to use for the relationship. |
|
| $this | as(string $accessor) Specify the custom pivot accessor to use for the relationship. |
|
| $this | wherePivot(string $column, mixed $operator = null, mixed $value = null, string $boolean = 'and') Set a where clause for a pivot table column. |
|
| $this | wherePivotBetween(string $column, array $values, string $boolean = 'and', bool $not = false) Set a "where between" clause for a pivot table column. |
|
| $this | orWherePivotBetween(string $column, array $values) Set a "or where between" clause for a pivot table column. |
|
| $this | wherePivotNotBetween(string $column, array $values, string $boolean = 'and') Set a "where pivot not between" clause for a pivot table column. |
|
| $this | orWherePivotNotBetween(string $column, array $values) Set a "or where not between" clause for a pivot table column. |
|
| $this | wherePivotIn(string $column, mixed $values, string $boolean = 'and', bool $not = false) Set a "where in" clause for a pivot table column. |
|
| $this | orWherePivot(string $column, mixed $operator = null, mixed $value = null) Set an "or where" clause for a pivot table column. |
|
| $this | withPivotValue(string|array $column, mixed $value = null) Set a where clause for a pivot table column. |
|
| $this | orWherePivotIn(string $column, mixed $values) Set an "or where in" clause for a pivot table column. |
|
| $this | wherePivotNotIn(string $column, mixed $values, string $boolean = 'and') Set a "where not in" clause for a pivot table column. |
|
| $this | orWherePivotNotIn(string $column, mixed $values) Set an "or where not in" clause for a pivot table column. |
|
| $this | wherePivotNull(string $column, string $boolean = 'and', bool $not = false) Set a "where null" clause for a pivot table column. |
|
| $this | wherePivotNotNull(string $column, string $boolean = 'and') Set a "where not null" clause for a pivot table column. |
|
| $this | orWherePivotNull(string $column, bool $not = false) Set a "or where null" clause for a pivot table column. |
|
| $this | orWherePivotNotNull(string $column) Set a "or where not null" clause for a pivot table column. |
|
| $this | orderByPivot(string $column, string $direction = 'asc') Add an "order by" clause for a pivot table column. |
|
| Collection|Model | findOrNew(mixed $id, array $columns = ['*']) Find a related model by its primary key or return a new instance of the related model. |
|
| Model | firstOrNew(array $attributes = [], array $values = []) Get the first related model record matching the attributes or instantiate it. |
|
| Model | firstOrCreate(array $attributes = [], array $values = [], array $joining = [], bool $touch = true) Get the first related record matching the attributes or create it. |
|
| Model | updateOrCreate(array $attributes, array $values = [], array $joining = [], bool $touch = true) Create or update a related record matching the attributes, and fill it with values. |
|
| Model|Collection|null | find(mixed $id, array $columns = ['*']) Find a related model by its primary key. |
|
| Collection | findMany(Arrayable|array $ids, array $columns = ['*']) Find multiple related models by their primary keys. |
|
| Model|Collection | findOrFail(mixed $id, array $columns = ['*']) Find a related model by its primary key or throw an exception. |
|
| Model|Collection|mixed | findOr(mixed $id, Closure|array $columns = ['*'], Closure $callback = null) Find a related model by its primary key or call a callback. |
|
| Model|BelongsToMany | firstWhere(Closure|string|array $column, mixed $operator = null, mixed $value = null, string $boolean = 'and') Add a basic where clause to the query, and return the first result. |
|
| mixed | first(array $columns = ['*']) Execute the query and get the first result. |
|
| Model|BelongsToMany | firstOrFail(array $columns = ['*']) Execute the query and get the first result or throw an exception. |
|
| Model|BelongsToMany|mixed | firstOr(Closure|array $columns = ['*'], Closure $callback = null) Execute the query and get the first result or call a callback. |
|
| array | shouldSelect(array $columns = ['*']) Get the select columns for the relation query. |
|
| array | aliasedPivotColumns() Get the pivot columns for the relation. |
|
| LengthAwarePaginator | paginate(int|null $perPage = null, array $columns = ['*'], string $pageName = 'page', int|null $page = null) Get a paginator for the "select" statement. |
|
| Paginator | simplePaginate(int|null $perPage = null, array $columns = ['*'], string $pageName = 'page', int|null $page = null) Paginate the given query into a simple paginator. |
|
| CursorPaginator | cursorPaginate(int|null $perPage = null, array $columns = ['*'], string $cursorName = 'cursor', string|null $cursor = null) Paginate the given query into a cursor paginator. |
|
| bool | chunk(int $count, callable $callback) Chunk the results of the query. |
|
| bool | chunkById(int $count, callable $callback, string|null $column = null, string|null $alias = null) Chunk the results of a query by comparing numeric IDs. |
|
| bool | each(callable $callback, int $count = 1000) Execute a callback over each item while chunking. |
|
| LazyCollection | lazy(int $chunkSize = 1000) Query lazily, by chunks of the given size. |
|
| LazyCollection | lazyById(int $chunkSize = 1000, string|null $column = null, string|null $alias = null) Query lazily, by chunking the results of a query by comparing IDs. |
|
| LazyCollection | cursor() Get a lazy collection for the given query. |
|
| Builder | prepareQueryBuilder() Prepare the query builder for query execution. |
|
| void | hydratePivotRelation(array $models) Hydrate the pivot table relationship on the models. |
|
| array | migratePivotAttributes(Model $model) Get the pivot attributes from a model. |
|
| void | touchIfTouching() If we're touching the parent model, touch. |
|
| bool | touchingParent() Determine if we should touch the parent on sync. |
|
| string | guessInverseRelation() Attempt to guess the name of the inverse of the relation. |
|
| Collection | allRelatedIds() Get all of the IDs for the related models. |
|
| Model | save(Model $model, array $pivotAttributes = [], bool $touch = true) Save a new model and attach it to the parent model. |
|
| Model | saveQuietly(Model $model, array $pivotAttributes = [], bool $touch = true) Save a new model without raising any events and attach it to the parent model. |
|
| array | saveMany(Collection|array $models, array $pivotAttributes = []) Save an array of new models and attach them to the parent model. |
|
| array | saveManyQuietly(Collection|array $models, array $pivotAttributes = []) Save an array of new models without raising any events and attach them to the parent model. |
|
| Model | create(array $attributes = [], array $joining = [], bool $touch = true) Create a new instance of the related model. |
|
| array | createMany(iterable $records, array $joinings = []) Create an array of new instances of the related models. |
|
| Builder | getRelationExistenceQueryForSelfJoin(Builder $query, Builder $parentQuery, array|mixed $columns = ['*']) Add the constraints for a relationship query on the same table. |
|
| string | getExistenceCompareKey() Get the key for comparing against the parent key in "has" query. |
|
| $this | withTimestamps(mixed $createdAt = null, mixed $updatedAt = null) Specify that the pivot table has creation and update timestamps. |
|
| string | getForeignPivotKeyName() Get the foreign key for the relation. |
|
| string | getQualifiedForeignPivotKeyName() Get the fully qualified foreign key for the relation. |
|
| string | getRelatedPivotKeyName() Get the "related key" for the relation. |
|
| string | getQualifiedRelatedPivotKeyName() Get the fully qualified "related key" for the relation. |
|
| string | getParentKeyName() Get the parent key for the relationship. |
|
| string | getRelatedKeyName() Get the related key for the relationship. |
|
| string | getQualifiedRelatedKeyName() Get the fully qualified related key name for the relation. |
|
| string | getTable() Get the intermediate table for the relationship. |
|
| string | getRelationName() Get the relationship name for the relationship. |
|
| string | getPivotAccessor() Get the name of the pivot accessor for this relationship. |
|
| array | getPivotColumns() Get the pivot columns for this relationship. |
|
| string | qualifyPivotColumn(string $column) Qualify the given column name by the pivot table. |
Details
protected mixed forwardCallTo(mixed $object, string $method, array $parameters)
Forward a method call to the given object.
protected mixed forwardDecoratedCallTo(mixed $object, string $method, array $parameters)
Forward a method call to the given object, returning $this if the forwarded call returned itself.
static protected void throwBadMethodCallException(string $method)
Throw a bad method call exception for the given method.
static void macro(string $name, object|callable $macro)
Register a custom macro.
static void mixin(object $mixin, bool $replace = true)
Mix another object into the class.
static bool hasMacro(string $name)
Checks if macro is registered.
static void flushMacros()
Flush the existing macros.
static mixed __callStatic(string $method, array $parameters)
Dynamically handle calls to the class.
mixed __call(string $method, array $parameters)
Dynamically handle calls to the class.
void __construct(Builder $query, Model $parent, string $table, string $foreignPivotKey, string $relatedPivotKey, string $parentKey, string $relatedKey, string|null $relationName = null)
Create a new belongs to many relationship instance.
static mixed noConstraints(Closure $callback)
Run a callback with constraints disabled on the relation.
void addConstraints()
Set the base constraints on the relation query.
void addEagerConstraints(array $models)
Set the constraints for an eager load of the relation.
array initRelation(array $models, string $relation)
Initialize the relation on a set of models.
array match(array $models, Collection $results, string $relation)
Match the eagerly loaded results to their parents.
mixed getResults()
Get the results of the relationship.
Collection getEager()
Get the relationship for eager loading.
Model sole(array|string $columns = ['*'])
Execute the query and get the first result if it's the sole matching record.
Collection get(array $columns = ['*'])
Execute the query as a "select" statement.
void touch()
Touch all of the related models for the relationship.
E.g.: Touch all roles associated with this user.
int rawUpdate(array $attributes = [])
Run a raw update against the base query.
Builder getRelationExistenceCountQuery(Builder $query, Builder $parentQuery)
Add the constraints for a relationship count query.
Builder getRelationExistenceQuery(Builder $query, Builder $parentQuery, array|mixed $columns = ['*'])
Add the constraints for a relationship query.
string getRelationCountHash(bool $incrementJoinCount = true)
Get a relationship join table hash.
protected array getKeys(array $models, string|null $key = null)
Get all of the primary keys for an array of models.
protected Builder getRelationQuery()
Get the query builder that will contain the relationship constraints.
Builder getQuery()
Get the underlying query for the relation.
Builder getBaseQuery()
Get the base query builder driving the Eloquent builder.
Builder toBase()
Get a base query builder instance.
Model getParent()
Get the parent model of the relation.
string getQualifiedParentKeyName()
Get the fully qualified parent key name for the relation.
Model getRelated()
Get the related model of the relation.
string createdAt()
Get the name of the "created at" column.
string updatedAt()
Get the name of the "updated at" column.
string relatedUpdatedAt()
Get the name of the related model's "updated at" column.
protected void whereInEager(string $whereIn, string $key, array $modelKeys, Builder $query = null)
Add a whereIn eager constraint for the given set of model keys to be loaded.
protected string whereInMethod(Model $model, string $key)
Get the name of the "where in" method for eager loading.
static void requireMorphMap(bool $requireMorphMap = true)
Prevent polymorphic relationships from being used without model mappings.
static bool requiresMorphMap()
Determine if polymorphic relationships require explicit model mapping.
static array enforceMorphMap(array $map, bool $merge = true)
Define the morph map for polymorphic relations and require all morphed models to be explicitly mapped.
static array morphMap(array $map = null, bool $merge = true)
Set or get the morph map for polymorphic relations.
static protected array|null buildMorphMapFromModels(array $models = null)
Builds a table-keyed array from model class names.
static string|null getMorphedModel(string $alias)
Get the model associated with a custom polymorphic type.
void __clone()
Force a clone of the underlying query builder when cloning.
protected mixed getDictionaryKey(mixed $attribute)
Get a dictionary key attribute - casting it to a string if necessary.
array toggle(mixed $ids, bool $touch = true)
Toggles a model (or models) from the parent.
Each existing model is detached, and non existing ones are attached.
array syncWithoutDetaching(Collection|Model|array $ids)
Sync the intermediate tables with a list of IDs without detaching.
array sync(Collection|Model|array $ids, bool $detaching = true)
Sync the intermediate tables with a list of IDs or collection of models.
array syncWithPivotValues(Collection|Model|array $ids, array $values, bool $detaching = true)
Sync the intermediate tables with a list of IDs or collection of models with the given pivot values.
protected array formatRecordsList(array $records)
Format the sync / toggle record list so that it is keyed by ID.
protected array attachNew(array $records, array $current, bool $touch = true)
Attach all of the records that aren't in the given current records.
int updateExistingPivot(mixed $id, array $attributes, bool $touch = true)
Update an existing pivot record on the table.
protected int updateExistingPivotUsingCustomClass(mixed $id, array $attributes, bool $touch)
Update an existing pivot record on the table via a custom class.
void attach(mixed $id, array $attributes = [], bool $touch = true)
Attach a model to the parent.
protected void attachUsingCustomClass(mixed $id, array $attributes)
Attach a model to the parent using a custom class.
protected array formatAttachRecords(array $ids, array $attributes)
Create an array of records to insert into the pivot table.
protected array formatAttachRecord(int $key, mixed $value, array $attributes, bool $hasTimestamps)
Create a full attachment record payload.
protected array extractAttachIdAndAttributes(mixed $key, mixed $value, array $attributes)
Get the attach record ID and extra attributes.
protected array baseAttachRecord(int $id, bool $timed)
Create a new pivot attachment record.
protected array addTimestampsToAttachment(array $record, bool $exists = false)
Set the creation and update timestamps on an attach record.
bool hasPivotColumn(string $column)
Determine whether the given column is defined as a pivot column.
int detach(mixed $ids = null, bool $touch = true)
Detach models from the relationship.
protected int detachUsingCustomClass(mixed $ids)
Detach models from the relationship using a custom class.
protected Collection getCurrentlyAttachedPivots()
Get the pivot models that are currently attached.
Pivot newPivot(array $attributes = [], bool $exists = false)
Create a new pivot model instance.
Pivot newExistingPivot(array $attributes = [])
Create a new existing pivot model instance.
Builder newPivotStatement()
Get a new plain query builder for the pivot table.
Builder newPivotStatementForId(mixed $id)
Get a new pivot statement for a given "other" ID.
Builder newPivotQuery()
Create a new query builder for the pivot table.
$this withPivot(array|mixed $columns)
Set the columns on the pivot table to retrieve.
protected array parseIds(mixed $value)
Get all of the IDs from the given mixed value.
protected mixed parseId(mixed $value)
Get the ID from the given mixed value.
protected array castKeys(array $keys)
Cast the given keys to integers if they are numeric and string otherwise.
protected mixed castKey(mixed $key)
Cast the given key to convert to primary key type.
protected array castAttributes(array $attributes)
Cast the given pivot attributes.
protected mixed getTypeSwapValue(string $type, mixed $value)
Converts a given value to a given type value.
protected string resolveTableName(string $table)
Attempt to resolve the intermediate table name from the given string.
protected $this performJoin(Builder|null $query = null)
Set the join clause for the relation query.
protected $this addWhereConstraints()
Set the where clause for the relation query.
protected array buildDictionary(Collection $results)
Build model dictionary keyed by the relation's foreign key.
string getPivotClass()
Get the class being used for pivot models.
$this using(string $class)
Specify the custom pivot model to use for the relationship.
$this as(string $accessor)
Specify the custom pivot accessor to use for the relationship.
$this wherePivot(string $column, mixed $operator = null, mixed $value = null, string $boolean = 'and')
Set a where clause for a pivot table column.
$this wherePivotBetween(string $column, array $values, string $boolean = 'and', bool $not = false)
Set a "where between" clause for a pivot table column.
$this orWherePivotBetween(string $column, array $values)
Set a "or where between" clause for a pivot table column.
$this wherePivotNotBetween(string $column, array $values, string $boolean = 'and')
Set a "where pivot not between" clause for a pivot table column.
$this orWherePivotNotBetween(string $column, array $values)
Set a "or where not between" clause for a pivot table column.
$this wherePivotIn(string $column, mixed $values, string $boolean = 'and', bool $not = false)
Set a "where in" clause for a pivot table column.
$this orWherePivot(string $column, mixed $operator = null, mixed $value = null)
Set an "or where" clause for a pivot table column.
$this withPivotValue(string|array $column, mixed $value = null)
Set a where clause for a pivot table column.
In addition, new pivot records will receive this value.
$this orWherePivotIn(string $column, mixed $values)
Set an "or where in" clause for a pivot table column.
$this wherePivotNotIn(string $column, mixed $values, string $boolean = 'and')
Set a "where not in" clause for a pivot table column.
$this orWherePivotNotIn(string $column, mixed $values)
Set an "or where not in" clause for a pivot table column.
$this wherePivotNull(string $column, string $boolean = 'and', bool $not = false)
Set a "where null" clause for a pivot table column.
$this wherePivotNotNull(string $column, string $boolean = 'and')
Set a "where not null" clause for a pivot table column.
$this orWherePivotNull(string $column, bool $not = false)
Set a "or where null" clause for a pivot table column.
$this orWherePivotNotNull(string $column)
Set a "or where not null" clause for a pivot table column.
$this orderByPivot(string $column, string $direction = 'asc')
Add an "order by" clause for a pivot table column.
Collection|Model findOrNew(mixed $id, array $columns = ['*'])
Find a related model by its primary key or return a new instance of the related model.
Model firstOrNew(array $attributes = [], array $values = [])
Get the first related model record matching the attributes or instantiate it.
Model firstOrCreate(array $attributes = [], array $values = [], array $joining = [], bool $touch = true)
Get the first related record matching the attributes or create it.
Model updateOrCreate(array $attributes, array $values = [], array $joining = [], bool $touch = true)
Create or update a related record matching the attributes, and fill it with values.
Model|Collection|null find(mixed $id, array $columns = ['*'])
Find a related model by its primary key.
Collection findMany(Arrayable|array $ids, array $columns = ['*'])
Find multiple related models by their primary keys.
Model|Collection findOrFail(mixed $id, array $columns = ['*'])
Find a related model by its primary key or throw an exception.
Model|Collection|mixed findOr(mixed $id, Closure|array $columns = ['*'], Closure $callback = null)
Find a related model by its primary key or call a callback.
Model|BelongsToMany firstWhere(Closure|string|array $column, mixed $operator = null, mixed $value = null, string $boolean = 'and')
Add a basic where clause to the query, and return the first result.
mixed first(array $columns = ['*'])
Execute the query and get the first result.
Model|BelongsToMany firstOrFail(array $columns = ['*'])
Execute the query and get the first result or throw an exception.
Model|BelongsToMany|mixed firstOr(Closure|array $columns = ['*'], Closure $callback = null)
Execute the query and get the first result or call a callback.
protected array shouldSelect(array $columns = ['*'])
Get the select columns for the relation query.
protected array aliasedPivotColumns()
Get the pivot columns for the relation.
"pivot_" is prefixed at each column for easy removal later.
LengthAwarePaginator paginate(int|null $perPage = null, array $columns = ['*'], string $pageName = 'page', int|null $page = null)
Get a paginator for the "select" statement.
Paginator simplePaginate(int|null $perPage = null, array $columns = ['*'], string $pageName = 'page', int|null $page = null)
Paginate the given query into a simple paginator.
CursorPaginator cursorPaginate(int|null $perPage = null, array $columns = ['*'], string $cursorName = 'cursor', string|null $cursor = null)
Paginate the given query into a cursor paginator.
bool chunk(int $count, callable $callback)
Chunk the results of the query.
bool chunkById(int $count, callable $callback, string|null $column = null, string|null $alias = null)
Chunk the results of a query by comparing numeric IDs.
bool each(callable $callback, int $count = 1000)
Execute a callback over each item while chunking.
LazyCollection lazy(int $chunkSize = 1000)
Query lazily, by chunks of the given size.
LazyCollection lazyById(int $chunkSize = 1000, string|null $column = null, string|null $alias = null)
Query lazily, by chunking the results of a query by comparing IDs.
LazyCollection cursor()
Get a lazy collection for the given query.
protected Builder prepareQueryBuilder()
Prepare the query builder for query execution.
protected void hydratePivotRelation(array $models)
Hydrate the pivot table relationship on the models.
protected array migratePivotAttributes(Model $model)
Get the pivot attributes from a model.
void touchIfTouching()
If we're touching the parent model, touch.
protected bool touchingParent()
Determine if we should touch the parent on sync.
protected string guessInverseRelation()
Attempt to guess the name of the inverse of the relation.
Collection allRelatedIds()
Get all of the IDs for the related models.
Model save(Model $model, array $pivotAttributes = [], bool $touch = true)
Save a new model and attach it to the parent model.
Model saveQuietly(Model $model, array $pivotAttributes = [], bool $touch = true)
Save a new model without raising any events and attach it to the parent model.
array saveMany(Collection|array $models, array $pivotAttributes = [])
Save an array of new models and attach them to the parent model.
array saveManyQuietly(Collection|array $models, array $pivotAttributes = [])
Save an array of new models without raising any events and attach them to the parent model.
Model create(array $attributes = [], array $joining = [], bool $touch = true)
Create a new instance of the related model.
array createMany(iterable $records, array $joinings = [])
Create an array of new instances of the related models.
Builder getRelationExistenceQueryForSelfJoin(Builder $query, Builder $parentQuery, array|mixed $columns = ['*'])
Add the constraints for a relationship query on the same table.
string getExistenceCompareKey()
Get the key for comparing against the parent key in "has" query.
$this withTimestamps(mixed $createdAt = null, mixed $updatedAt = null)
Specify that the pivot table has creation and update timestamps.
string getForeignPivotKeyName()
Get the foreign key for the relation.
string getQualifiedForeignPivotKeyName()
Get the fully qualified foreign key for the relation.
string getRelatedPivotKeyName()
Get the "related key" for the relation.
string getQualifiedRelatedPivotKeyName()
Get the fully qualified "related key" for the relation.
string getParentKeyName()
Get the parent key for the relationship.
string getRelatedKeyName()
Get the related key for the relationship.
string getQualifiedRelatedKeyName()
Get the fully qualified related key name for the relation.
string getTable()
Get the intermediate table for the relationship.
string getRelationName()
Get the relationship name for the relationship.
string getPivotAccessor()
Get the name of the pivot accessor for this relationship.
array getPivotColumns()
Get the pivot columns for this relationship.
string qualifyPivotColumn(string $column)
Qualify the given column name by the pivot table.
© Taylor Otwell
Licensed under the MIT License.
Laravel is a trademark of Taylor Otwell.
https://laravel.com/api/10.x/Illuminate/Database/Eloquent/Relations/BelongsToMany.html