BelongsToMany

class BelongsToMany extends Relation (View source)

Properties

protected Builder $query The Eloquent query builder instance. from Relation
protected Model $parent The parent model instance. from Relation
$related The related model instance. from Relation
static protected bool $constraints Indicates if the relation is adding constraints. from Relation
protected string $table The intermediate table for the relation.
protected string $foreignKey The foreign key of the parent model.
protected string $otherKey The associated key of the relation.
protected string $relationName The "name" of the relationship.
protected array $pivotColumns The pivot table columns to retrieve.
protected array $pivotWheres Any pivot table restrictions.

Methods

void __construct(Builder $query, Model $parent, string $table, string $foreignKey, string $otherKey, string $relationName = null)

Create a new has many relationship instance.
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
void touch()

Touch all of the related models for the relationship.
int rawUpdate(array $attributes = array())

Run a raw update against the base query.

 from Relation
Builder getRelationCountQuery(Builder $query, Builder $parent)

Add the constraints for a relationship count query.
static mixed noConstraints(Closure $callback)

Run a callback with constraints disabled on the relation.

 from Relation
array getKeys(array $models, string $key = null)

Get all of the primary keys for an array of models.

 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
Model getParent()

Get the parent model of the relation.

 from Relation
string getQualifiedParentKeyName()

Get the fully qualified parent key name.

 from Relation
Model getRelated()

Get the related model of the relation.

 from Relation
string createdAt()

Get the name of the "created at" column.

 from Relation
string updatedAt()

Get the name of the "updated at" column.

 from Relation
string relatedUpdatedAt()

Get the name of the related model's "updated at" column.

 from Relation
string wrap(string $value)

Wrap the given value with the parent query's grammar.

 from Relation
mixed __call(string $method, array $parameters)

Handle dynamic method calls to the relationship.

 from Relation
BelongsToMany wherePivot(string $column, string $operator = null, mixed $value = null, string $boolean = 'and')

Set a where clause for a pivot table column.
BelongsToMany orWherePivot(string $column, string $operator = null, mixed $value = null)

Set an or where clause for a pivot table column.
mixed first(array $columns = array('*'))

Execute the query and get the first result.
Model|BelongsToMany firstOrFail(array $columns = array('*'))

Execute the query and get the first result or throw an exception.
Collection get(array $columns = array('*'))

Execute the query as a "select" statement.
Paginator paginate(int $perPage = null, array $columns = array('*'))

Get a paginator for the "select" statement.
void hydratePivotRelation(array $models)

Hydrate the pivot table relationship on the models.
array cleanPivotAttributes(Model $model)

Get the pivot attributes from a model.
Builder getRelationCountQueryForSelfJoin(Builder $query, Builder $parent)

Add the constraints for a relationship count query on the same table.
string getRelationCountHash()

Get a relationship join table hash.
BelongsToMany getSelectColumns(array $columns = array('*'))

Set the select clause for the relation query.
array getAliasedPivotColumns()

Get the pivot columns for the relation.
bool hasPivotColumn(string $column)

Determine whether the given column is defined as a pivot column.
$this setJoin(Builder|null $query = null)

Set the join clause for the relation query.
$this setWhere()

Set the where clause for the relation query.
array buildDictionary(Collection $results)

Build model dictionary keyed by the relation's foreign key.
array getRelatedIds()

Get all of the IDs for the related models.
Model save(Model $model, array $joining = array(), bool $touch = true)

Save a new model and attach it to the parent model.
array saveMany(array $models, array $joinings = array())

Save an array of new models and attach them to the parent model.
Model create(array $attributes, array $joining = array(), bool $touch = true)

Create a new instance of the related model.
Model createMany(array $records, array $joinings = array())

Create an array of new instances of the related models.
array sync(array $ids, bool $detaching = true)

Sync the intermediate tables with a list of IDs or collection of models.
array formatSyncList(array $records)

Format the sync list so that it is keyed by ID.
array attachNew(array $records, array $current, bool $touch = true)

Attach all of the IDs that aren't in the current array.
void updateExistingPivot(mixed $id, array $attributes, bool $touch = true)

Update an existing pivot record on the table.
void attach(mixed $id, array $attributes = array(), bool $touch = true)

Attach a model to the parent.
array createAttachRecords(array $ids, array $attributes)

Create an array of records to insert into the pivot table.
array attacher(int $key, mixed $value, array $attributes, bool $timed)

Create a full attachment record payload.
array getAttachId(mixed $key, mixed $value, array $attributes)

Get the attach record ID and extra attributes.
array createAttachRecord(int $id, bool $timed)

Create a new pivot attachment record.
array setTimestampsOnAttach(array $record, bool $exists = false)

Set the creation and update timestamps on an attach record.
int detach(int|array $ids = array(), bool $touch = true)

Detach models from the relationship.
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.
Builder newPivotQuery()

Create a new query builder for the pivot table.
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.
Pivot newPivot(array $attributes = array(), bool $exists = false)

Create a new pivot model instance.
Pivot newExistingPivot(array $attributes = array())

Create a new existing pivot model instance.
$this withPivot(mixed $columns)

Set the columns on the pivot table to retrieve.
BelongsToMany withTimestamps(mixed $createdAt = null, mixed $updatedAt = null)

Specify that the pivot table has creation and update timestamps.
string getRelatedFreshUpdate()

Get the related model's updated at column name.
string getHasCompareKey()

Get the key for comparing against the parent key in "has" query.
string getForeignKey()

Get the fully qualified foreign key for the relation.
string getOtherKey()

Get the fully qualified "other key" for the relation.
string getTable()

Get the intermediate table for the relationship.
string getRelationName()

Get the relationship name for the relationship.

Details

void __construct(Builder $query, Model $parent, string $table, string $foreignKey, string $otherKey, string $relationName = null)

Create a new has many relationship instance.

Parameters

Builder $query
Model $parent
string $table
string $foreignKey
string $otherKey
string $relationName

Return Value

void

void addConstraints()

Set the base constraints on the relation query.

Return Value

void

void addEagerConstraints(array $models)

Set the constraints for an eager load of the relation.

Parameters

array $models

Return Value

void

array initRelation(array $models, string $relation)

Initialize the relation on a set of models.

Parameters

array $models
string $relation

Return Value

array

array match(array $models, Collection $results, string $relation)

Match the eagerly loaded results to their parents.

Parameters

array $models
Collection $results
string $relation

Return Value

array

mixed getResults()

Get the results of the relationship.

Return Value

mixed

Collection getEager()

Get the relationship for eager loading.

Return Value

Collection

void touch()

Touch all of the related models for the relationship.

E.g.: Touch all roles associated with this user.

Return Value

void

int rawUpdate(array $attributes = array())

Run a raw update against the base query.

Parameters

array $attributes

Return Value

int

Builder getRelationCountQuery(Builder $query, Builder $parent)

Add the constraints for a relationship count query.

Parameters

Builder $query
Builder $parent

Return Value

Builder

static mixed noConstraints(Closure $callback)

Run a callback with constraints disabled on the relation.

Parameters

Closure $callback

Return Value

mixed

protected array getKeys(array $models, string $key = null)

Get all of the primary keys for an array of models.

Parameters

array $models
string $key

Return Value

array

Builder getQuery()

Get the underlying query for the relation.

Return Value

Builder

Builder getBaseQuery()

Get the base query builder driving the Eloquent builder.

Return Value

Builder

Model getParent()

Get the parent model of the relation.

Return Value

Model

string getQualifiedParentKeyName()

Get the fully qualified parent key name.

Return Value

string

Model getRelated()

Get the related model of the relation.

Return Value

Model

string createdAt()

Get the name of the "created at" column.

Return Value

string

string updatedAt()

Get the name of the "updated at" column.

Return Value

string

string relatedUpdatedAt()

Get the name of the related model's "updated at" column.

Return Value

string

string wrap(string $value)

Wrap the given value with the parent query's grammar.

Parameters

string $value

Return Value

string

mixed __call(string $method, array $parameters)

Handle dynamic method calls to the relationship.

Parameters

string $method
array $parameters

Return Value

mixed

BelongsToMany wherePivot(string $column, string $operator = null, mixed $value = null, string $boolean = 'and')

Set a where clause for a pivot table column.

Parameters

string $column
string $operator
mixed $value
string $boolean

Return Value

BelongsToMany

BelongsToMany orWherePivot(string $column, string $operator = null, mixed $value = null)

Set an or where clause for a pivot table column.

Parameters

string $column
string $operator
mixed $value

Return Value

BelongsToMany

mixed first(array $columns = array('*'))

Execute the query and get the first result.

Parameters

array $columns

Return Value

mixed

Model|BelongsToMany firstOrFail(array $columns = array('*'))

Execute the query and get the first result or throw an exception.

Parameters

array $columns

Return Value

Model|BelongsToMany

Exceptions

ModelNotFoundException

Collection get(array $columns = array('*'))

Execute the query as a "select" statement.

Parameters

array $columns

Return Value

Collection

Paginator paginate(int $perPage = null, array $columns = array('*'))

Get a paginator for the "select" statement.

Parameters

int $perPage
array $columns

Return Value

Paginator

protected void hydratePivotRelation(array $models)

Hydrate the pivot table relationship on the models.

Parameters

array $models

Return Value

void

protected array cleanPivotAttributes(Model $model)

Get the pivot attributes from a model.

Parameters

Model $model

Return Value

array

Builder getRelationCountQueryForSelfJoin(Builder $query, Builder $parent)

Add the constraints for a relationship count query on the same table.

Parameters

Builder $query
Builder $parent

Return Value

Builder

string getRelationCountHash()

Get a relationship join table hash.

Return Value

string

protected BelongsToMany getSelectColumns(array $columns = array('*'))

Set the select clause for the relation query.

Parameters

array $columns

Return Value

BelongsToMany

protected array getAliasedPivotColumns()

Get the pivot columns for the relation.

Return Value

array

protected bool hasPivotColumn(string $column)

Determine whether the given column is defined as a pivot column.

Parameters

string $column

Return Value

bool

protected $this setJoin(Builder|null $query = null)

Set the join clause for the relation query.

Parameters

Builder|null $query

Return Value

$this

protected $this setWhere()

Set the where clause for the relation query.

Return Value

$this

protected array buildDictionary(Collection $results)

Build model dictionary keyed by the relation's foreign key.

Parameters

Collection $results

Return Value

array

array getRelatedIds()

Get all of the IDs for the related models.

Return Value

array

Model save(Model $model, array $joining = array(), bool $touch = true)

Save a new model and attach it to the parent model.

Parameters

Model $model
array $joining
bool $touch

Return Value

Model

array saveMany(array $models, array $joinings = array())

Save an array of new models and attach them to the parent model.

Parameters

array $models
array $joinings

Return Value

array

Model create(array $attributes, array $joining = array(), bool $touch = true)

Create a new instance of the related model.

Parameters

array $attributes
array $joining
bool $touch

Return Value

Model

Model createMany(array $records, array $joinings = array())

Create an array of new instances of the related models.

Parameters

array $records
array $joinings

Return Value

Model

array sync(array $ids, bool $detaching = true)

Sync the intermediate tables with a list of IDs or collection of models.

Parameters

array $ids
bool $detaching

Return Value

array

protected array formatSyncList(array $records)

Format the sync list so that it is keyed by ID.

Parameters

array $records

Return Value

array

protected array attachNew(array $records, array $current, bool $touch = true)

Attach all of the IDs that aren't in the current array.

Parameters

array $records
array $current
bool $touch

Return Value

array

void updateExistingPivot(mixed $id, array $attributes, bool $touch = true)

Update an existing pivot record on the table.

Parameters

mixed $id
array $attributes
bool $touch

Return Value

void

void attach(mixed $id, array $attributes = array(), bool $touch = true)

Attach a model to the parent.

Parameters

mixed $id
array $attributes
bool $touch

Return Value

void

protected array createAttachRecords(array $ids, array $attributes)

Create an array of records to insert into the pivot table.

Parameters

array $ids
array $attributes

Return Value

array

protected array attacher(int $key, mixed $value, array $attributes, bool $timed)

Create a full attachment record payload.

Parameters

int $key
mixed $value
array $attributes
bool $timed

Return Value

array

protected array getAttachId(mixed $key, mixed $value, array $attributes)

Get the attach record ID and extra attributes.

Parameters

mixed $key
mixed $value
array $attributes

Return Value

array

protected array createAttachRecord(int $id, bool $timed)

Create a new pivot attachment record.

Parameters

int $id
bool $timed

Return Value

array

protected array setTimestampsOnAttach(array $record, bool $exists = false)

Set the creation and update timestamps on an attach record.

Parameters

array $record
bool $exists

Return Value

array

int detach(int|array $ids = array(), bool $touch = true)

Detach models from the relationship.

Parameters

int|array $ids
bool $touch

Return Value

int

void touchIfTouching()

If we're touching the parent model, touch.

Return Value

void

protected bool touchingParent()

Determine if we should touch the parent on sync.

Return Value

bool

protected string guessInverseRelation()

Attempt to guess the name of the inverse of the relation.

Return Value

string

protected Builder newPivotQuery()

Create a new query builder for the pivot table.

Return Value

Builder

Builder newPivotStatement()

Get a new plain query builder for the pivot table.

Return Value

Builder

Builder newPivotStatementForId(mixed $id)

Get a new pivot statement for a given "other" ID.

Parameters

mixed $id

Return Value

Builder

Pivot newPivot(array $attributes = array(), bool $exists = false)

Create a new pivot model instance.

Parameters

array $attributes
bool $exists

Return Value

Pivot

Pivot newExistingPivot(array $attributes = array())

Create a new existing pivot model instance.

Parameters

array $attributes

Return Value

Pivot

$this withPivot(mixed $columns)

Set the columns on the pivot table to retrieve.

Parameters

mixed $columns

Return Value

$this

BelongsToMany withTimestamps(mixed $createdAt = null, mixed $updatedAt = null)

Specify that the pivot table has creation and update timestamps.

Parameters

mixed $createdAt
mixed $updatedAt

Return Value

BelongsToMany

string getRelatedFreshUpdate()

Get the related model's updated at column name.

Return Value

string

string getHasCompareKey()

Get the key for comparing against the parent key in "has" query.

Return Value

string

string getForeignKey()

Get the fully qualified foreign key for the relation.

Return Value

string

string getOtherKey()

Get the fully qualified "other key" for the relation.

Return Value

string

string getTable()

Get the intermediate table for the relationship.

Return Value

string

string getRelationName()

Get the relationship name for the relationship.

Return Value

string

© Taylor Otwell
Licensed under the MIT License.
Laravel is a trademark of Taylor Otwell.
https://laravel.com/api/4.2/Illuminate/Database/Eloquent/Relations/BelongsToMany.html