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 |
protected Model | $related | The related model instance. | from Relation |
static protected bool | $constraints | Indicates if the relation is adding constraints. | from Relation |
static protected array | $morphMap | An array to map class names to their morph names in database. | 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 for where clauses. | from BelongsToMany |
protected array | $pivotWhereIns | Any pivot table restrictions for whereIn clauses. | from BelongsToMany |
protected string | $pivotCreatedAt | The custom pivot table column for the created_at timestamp. | from BelongsToMany |
protected string | $pivotUpdatedAt | The custom pivot table column for the updated_at timestamp. | from BelongsToMany |
static protected int | $selfJoinCount | The count of self joins. | 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 morph to 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 = []) Run a raw update against the base query. | from Relation |
Builder | getRelationCountQuery(Builder $query, Builder $parent) Add the constraints for a relationship count query. | from Relation |
Builder | getRelationQuery(Builder $query, Builder $parent, array|mixed $columns = ['*']) 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 BelongsToMany |
string | updatedAt() Get the name of the "updated at" column. | from BelongsToMany |
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 |
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 |
mixed | __call(string $method, array $parameters) Handle dynamic method calls to the relationship. | from Relation |
void | __clone() Force a clone of the underlying query builder when cloning. | 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 | wherePivotIn(string $column, mixed $values, string $boolean = 'and', bool $not = false) Set a "where in" 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 |
BelongsToMany | orWherePivotIn(string $column, mixed $values) Set an "or where in" clause for a pivot table column. | from BelongsToMany |
mixed | first(array $columns = ['*']) Execute the query and get the first result. | from BelongsToMany |
Model|BelongsToMany | firstOrFail(array $columns = ['*']) Execute the query and get the first result or throw an exception. | from BelongsToMany |
Collection | get(array $columns = ['*']) Execute the query as a "select" statement. | from BelongsToMany |
LengthAwarePaginator | paginate(int $perPage = null, array $columns = ['*'], string $pageName = 'page', int|null $page = null) Get a paginator for the "select" statement. | from BelongsToMany |
Paginator | simplePaginate(int $perPage = null, array $columns = ['*'], string $pageName = 'page') Paginate the given query into a simple paginator. | from BelongsToMany |
bool | chunk(int $count, callable $callback) Chunk the results of the query. | 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 | getRelationQueryForSelfJoin(Builder $query, Builder $parent, array|mixed $columns = ['*']) Add the constraints for a relationship query on the same table. | from BelongsToMany |
string | getRelationCountHash() Get a relationship join table hash. | from BelongsToMany |
BelongsToMany | getSelectColumns(array $columns = ['*']) 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 |
Collection | getRelatedIds() Get all of the IDs for the related models. | from BelongsToMany |
Model | save(Model $model, array $joining = [], bool $touch = true) Save a new model and attach it to the parent model. | from BelongsToMany |
array | saveMany(Collection|array $models, array $joinings = []) Save an array of new models and attach them to the parent model. | from BelongsToMany |
Model|Collection|null | find(mixed $id, array $columns = ['*']) Find a related model by its primary key. | from BelongsToMany |
Collection | findMany(mixed $ids, array $columns = ['*']) Find multiple related models by their primary keys. | from BelongsToMany |
Model|Collection | findOrFail(mixed $id, array $columns = ['*']) Find a related model by its primary key or throw an exception. | from BelongsToMany |
Collection|Model | findOrNew(mixed $id, array $columns = ['*']) Find a related model by its primary key or return new instance of the related model. | from BelongsToMany |
Model | firstOrNew(array $attributes) Get the first related model record matching the attributes or instantiate it. | from BelongsToMany |
Model | firstOrCreate(array $attributes, array $joining = [], bool $touch = true) Get the first related record matching the attributes or create it. | from BelongsToMany |
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. | from BelongsToMany |
Model | create(array $attributes, array $joining = [], bool $touch = true) Create a new instance of the related model. | from BelongsToMany |
array | createMany(array $records, array $joinings = []) Create an array of new instances of the related models. | from BelongsToMany |
array | syncWithoutDetaching(Collection|array $ids) Sync the intermediate tables with a list of IDs without detaching. | from BelongsToMany |
array | sync(Collection|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 |
int | updateExistingPivot(mixed $id, array $attributes, bool $touch = true) Update an existing pivot record on the table. | from BelongsToMany |
void | attach(mixed $id, array $attributes = [], 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(mixed $ids = [], 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 = [], bool $exists = false) Create a new pivot model instance. | |
Pivot | newExistingPivot(array $attributes = []) Create a new existing pivot model instance. | from BelongsToMany |
$this | withPivot(array|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 morph to 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.
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 getRelationCountQuery(Builder $query, Builder $parent)
Add the constraints for a relationship count query.
Builder getRelationQuery(Builder $query, Builder $parent, array|mixed $columns = ['*'])
Add the constraints for a relationship count query.
static mixed noConstraints(Closure $callback)
Run a callback with constraints disabled on the relation.
protected array getKeys(array $models, string $key = null)
Get all of the primary keys for an array of models.
Builder getQuery()
Get the underlying query for the relation.
Builder getBaseQuery()
Get the base query builder driving the Eloquent builder.
Model getParent()
Get the parent model of the relation.
string getQualifiedParentKeyName()
Get the fully qualified parent key name.
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.
string wrap(string $value)
Wrap the given value with the parent query's grammar.
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.
mixed __call(string $method, array $parameters)
Handle dynamic method calls to the relationship.
void __clone()
Force a clone of the underlying query builder when cloning.
BelongsToMany wherePivot(string $column, string $operator = null, mixed $value = null, string $boolean = 'and')
Set a where clause for a pivot table column.
BelongsToMany wherePivotIn(string $column, mixed $values, string $boolean = 'and', bool $not = false)
Set a "where in" 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.
BelongsToMany orWherePivotIn(string $column, mixed $values)
Set an "or where in" clause for a pivot table column.
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.
Collection get(array $columns = ['*'])
Execute the query as a "select" statement.
LengthAwarePaginator paginate(int $perPage = null, array $columns = ['*'], string $pageName = 'page', int|null $page = null)
Get a paginator for the "select" statement.
Paginator simplePaginate(int $perPage = null, array $columns = ['*'], string $pageName = 'page')
Paginate the given query into a simple paginator.
bool chunk(int $count, callable $callback)
Chunk the results of the query.
protected void hydratePivotRelation(array $models)
Hydrate the pivot table relationship on the models.
protected array cleanPivotAttributes(Model $model)
Get the pivot attributes from a model.
Builder getRelationQueryForSelfJoin(Builder $query, Builder $parent, array|mixed $columns = ['*'])
Add the constraints for a relationship query on the same table.
string getRelationCountHash()
Get a relationship join table hash.
protected BelongsToMany getSelectColumns(array $columns = ['*'])
Set the select clause for the relation query.
protected array getAliasedPivotColumns()
Get the pivot columns for the relation.
protected bool hasPivotColumn(string $column)
Determine whether the given column is defined as a pivot column.
protected $this setJoin(Builder|null $query = null)
Set the join clause for the relation query.
protected $this setWhere()
Set the where clause for the relation query.
protected array buildDictionary(Collection $results)
Build model dictionary keyed by the relation's foreign key.
Collection getRelatedIds()
Get all of the IDs for the related models.
Model save(Model $model, array $joining = [], bool $touch = true)
Save a new model and attach it to the parent model.
array saveMany(Collection|array $models, array $joinings = [])
Save an array of new models and attach them to the parent model.
Model|Collection|null find(mixed $id, array $columns = ['*'])
Find a related model by its primary key.
Collection findMany(mixed $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.
Collection|Model findOrNew(mixed $id, array $columns = ['*'])
Find a related model by its primary key or return new instance of the related model.
Model firstOrNew(array $attributes)
Get the first related model record matching the attributes or instantiate it.
Model firstOrCreate(array $attributes, 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 create(array $attributes, array $joining = [], bool $touch = true)
Create a new instance of the related model.
array createMany(array $records, array $joinings = [])
Create an array of new instances of the related models.
array syncWithoutDetaching(Collection|array $ids)
Sync the intermediate tables with a list of IDs without detaching.
array sync(Collection|array $ids, bool $detaching = true)
Sync the intermediate tables with a list of IDs or collection of models.
protected array formatSyncList(array $records)
Format the sync list so that it is keyed by ID.
protected array attachNew(array $records, array $current, bool $touch = true)
Attach all of the IDs that aren't in the current array.
int updateExistingPivot(mixed $id, array $attributes, bool $touch = true)
Update an existing pivot record on the table.
void attach(mixed $id, array $attributes = [], bool $touch = true)
Attach a model to the parent.
protected array createAttachRecords(array $ids, array $attributes)
Create an array of records to insert into the pivot table.
protected array attacher(int $key, mixed $value, array $attributes, bool $timed)
Create a full attachment record payload.
protected array getAttachId(mixed $key, mixed $value, array $attributes)
Get the attach record ID and extra attributes.
protected array createAttachRecord(int $id, bool $timed)
Create a new pivot attachment record.
protected array setTimestampsOnAttach(array $record, bool $exists = false)
Set the creation and update timestamps on an attach record.
int detach(mixed $ids = [], bool $touch = true)
Detach models from the relationship.
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.
protected 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 = [], bool $exists = false)
Create a new pivot model instance.
Pivot newExistingPivot(array $attributes = [])
Create a new existing pivot model instance.
$this withPivot(array|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.
string getMorphType()
Get the foreign key "type" name.
string getMorphClass()
Get the class name of the parent model.
© Taylor Otwell
Licensed under the MIT License.
Laravel is a trademark of Taylor Otwell.
https://laravel.com/api/5.3/Illuminate/Database/Eloquent/Relations/MorphToMany.html