Behavior for support relational data management.
- Insert related models from POST array.
- Pre-processing for new models via callback function.
- Delete related models from database which not exist in POST array.
- Skip related models which already exist in database with same attributes.
- Rollback database changes, if relational model save/delete error occurred.
- Support one-to-one and one-to-many relations.
With pre-processing you can set additional logic before create related models. For example, to add additional columns data to the junction table in a many-to-many relationship.
This behavior uses getters for relational attribute in owner model, such getters must return ActiveQuery object.
If you use string values in ON condition in ActiveQuery object, then this behavior will throw exception.
composer require notamedia/yii2-relationFor make works this behavior you need:
- Add all relational properties to rules as safe attribute.
- Declare getter for relational attribute.
- Put attribute or attribute with callback to relations property of behavior.
- All used models need to have only one primary key column.
<?php
class News extends \yii\db\ActiveRecord
{
public function rules()
{
return [
[['file'], 'safe']
];
}
public function getFile()
{
return $this->hasOne(File::class, ['id' => 'file_id']);
}
public function behaviors()
{
return [
[
'class' => \notamedia\relation\RelationBehavior::class,
'relations' => ['file']
]
];
}
public function transactions()
{
return [
$this->getScenario() => static::OP_ALL
];
}
}<?php
class News extends \yii\db\ActiveRecord
{
public function rules()
{
return [
[['images'], 'safe']
];
}
public function getImages()
{
return $this->hasMany(Image::class,
['news_id' => 'id']);
}
public function behaviors()
{
return [
[
'class' => \notamedia\relation\RelationBehavior::class,
'relations' => ['images']
]
];
}
public function transactions()
{
return [
$this->getScenario() => static::OP_ALL
];
}
}With via:
<?php
class News extends \yii\db\ActiveRecord
{
public function rules()
{
return [
[['categories'], 'safe']
];
}
public function getNewsHasCategories()
{
return $this->hasMany(NewsHasCategory::class, ['news_id' => 'id']);
}
public function getCategories()
{
return $this->hasMany(Category::class, ['id' => 'category_id'])
->via('newsHasCategories');
}
public function behaviors()
{
return [
[
'class' => \notamedia\relation\RelationBehavior::class,
'relations' => ['categories']
]
];
}
public function transactions()
{
return [
$this->getScenario() => static::OP_ALL
];
}
}With viaTable:
<?php
class News extends \yii\db\ActiveRecord
{
public function rules()
{
return [
[['categories', 'categories_type_archive'], 'safe']
];
}
public function getCategories()
{
return $this->hasMany(Category::class, ['id' => 'category_id'])
->viaTable('news_has_categories', ['news_id' => 'id']);
}
// with onCondition
public function getCategories_type_archive()
{
return $this->hasMany(Category::class, ['id' => 'category_id'])
->viaTable('news_has_categories', ['news_id' => 'id'], function($query) {
return $query->onCondition(['type' => 'archive']);
});
}
public function behaviors()
{
return [
[
'class' => \notamedia\relation\RelationBehavior::class,
'relations' => ['categories', 'categories_type_archive']
]
];
}
public function transactions()
{
return [
$this->getScenario() => static::OP_ALL
];
}
}<?php
class News extends \yii\db\ActiveRecord
{
public function rules()
{
return [
[['categories'], 'safe']
];
}
public function getNewsHasCategories()
{
return $this->hasMany(NewsHasCategory::class, ['news_id' => 'id']);
}
public function getCategories()
{
return $this->hasMany(Category::class, ['id' => 'category_id'])
->via('newsHasCategories');
}
public function behaviors()
{
$sortIndex = 1;
return [
[
'class' => \notamedia\relation\RelationBehavior::class,
'relations' => [
'categories' => function (NewsHasCategory $model) use (&$sortIndex) {
$model->sort = $sortIndex++;
return $model;
}
]
]
];
}
public function transactions()
{
return [
$this->getScenario() => static::OP_ALL
];
}
}
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent