MorphToMany

class MorphToMany extends BelongsToMany (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. from BelongsToMany
protected string $foreignKey The foreign key of the parent model. from BelongsToMany
protected string $otherKey The associated key of the relation. from BelongsToMany
protected string $relationName The "name" of the relationship. from BelongsToMany
protected array $pivotColumns The pivot table columns to retrieve. from BelongsToMany
protected array $pivotWheres Any pivot table restrictions. from BelongsToMany
protected string $morphType The type of the polymorphic relation.
protected string $morphClass The class name of the morph type constraint.
protected bool $inverse Indicates if we are connecting the inverse of the relation.

Methods

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

Create a new has many relationship instance.

void addConstraints()

Set the base constraints on the relation query.

from BelongsToMany
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.

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

Match the eagerly loaded results to their parents.

from BelongsToMany
mixed getResults()

Get the results of the relationship.

from BelongsToMany
Collection getEager()

Get the relationship for eager loading.

from Relation
void touch()

Touch all of the related models for the relationship.

from BelongsToMany
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.

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

Set an or where clause for a pivot table column.

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

Execute the query and get the first result.

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

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

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

Execute the query as a "select" statement.

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

Get a paginator for the "select" statement.

from BelongsToMany
void hydratePivotRelation(array $models)

Hydrate the pivot table relationship on the models.

from BelongsToMany
array cleanPivotAttributes(Model $model)

Get the pivot attributes from a model.

from BelongsToMany
Builder getRelationCountQueryForSelfJoin(Builder $query, Builder $parent)

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

from BelongsToMany
string getRelationCountHash()

Get a relationship join table hash.

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

Set the select clause for the relation query.

from BelongsToMany
array getAliasedPivotColumns()

Get the pivot columns for the relation.

from BelongsToMany
bool hasPivotColumn(string $column)

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

from BelongsToMany
$this setJoin(Builder|null $query = null)

Set the join clause for the relation query.

from BelongsToMany
$this setWhere()

Set the where clause for the relation query.

array buildDictionary(Collection $results)

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

from BelongsToMany
array getRelatedIds()

Get all of the IDs for the related models.

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

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

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

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

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

Create a new instance of the related model.

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

Create an array of new instances of the related models.

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

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

from BelongsToMany
array formatSyncList(array $records)

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

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

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

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

Update an existing pivot record on the table.

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

Attach a model to the parent.

from BelongsToMany
array createAttachRecords(array $ids, array $attributes)

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

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

Create a full attachment record payload.

from BelongsToMany
array getAttachId(mixed $key, mixed $value, array $attributes)

Get the attach record ID and extra attributes.

from BelongsToMany
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.

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

Detach models from the relationship.

from BelongsToMany
void touchIfTouching()

If we're touching the parent model, touch.

from BelongsToMany
bool touchingParent()

Determine if we should touch the parent on sync.

from BelongsToMany
string guessInverseRelation()

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

from BelongsToMany
Builder newPivotQuery()

Create a new query builder for the pivot table.

Builder newPivotStatement()

Get a new plain query builder for the pivot table.

from BelongsToMany
Builder newPivotStatementForId(mixed $id)

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

from BelongsToMany
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.

from BelongsToMany
$this withPivot(mixed $columns)

Set the columns on the pivot table to retrieve.

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

Specify that the pivot table has creation and update timestamps.

from BelongsToMany
string getRelatedFreshUpdate()

Get the related model's updated at column name.

from BelongsToMany
string getHasCompareKey()

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

from BelongsToMany
string getForeignKey()

Get the fully qualified foreign key for the relation.

from BelongsToMany
string getOtherKey()

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

from BelongsToMany
string getTable()

Get the intermediate table for the relationship.

from BelongsToMany
string getRelationName()

Get the relationship name for the relationship.

from BelongsToMany
string getMorphType()

Get the foreign key "type" name.

string getMorphClass()

Get the class name of the parent model.

Details

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

Create a new has many relationship instance.

Parameters

Builder $query
Model $parent
string $name
string $table
string $foreignKey
string $otherKey
string $relationName
bool $inverse

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

string getMorphType()

Get the foreign key "type" name.

Return Value

string

string getMorphClass()

Get the class name of the parent model.

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/MorphToMany.html