Архитектура баз данных EAV(Enity-Attribute-Value, Сущность-Атрибут-Значение)
"repositories": [
{
"type": "git",
"url": "https://github.com/mirocow/yii2-eav.git"
}
]
and then
php composer.phar require --prefer-dist "mirocow/yii2-eav" "*"
php ./yii migrate/up -p=@mirocow/eav/migrations
or
php ./yii migrate/up -p=@vendor/mirocow/yii2-eav/src/migrations
and then add messages settings
'i18n' => [
'translations' => [
'app*' => [
'class' => 'yii\i18n\PhpMessageSource',
//'basePath' => '@app/messages',
//'sourceLanguage' => 'en-US',
'fileMap' => [
'app' => 'app.php',
'app/error' => 'error.php',
],
],
'eav' => [
'class' => 'yii\i18n\PhpMessageSource',
'basePath' => '@mirocow/eav/messages',
],
],
]
class Product extends \yii\db\ActiveRecord
{
public function rules()
{
return [
[['name'], 'string', 'max' => 255], // Product field
[['c1'], 'required'], // Attribute field
[['c1'], 'string', 'max' => 255], // Attribute field
];
}
public function behaviors()
{
return [
'eav' => [
'class' => \mirocow\eav\EavBehavior::className(),
// это модель для таблицы object_attribute_value
'valueClass' => \mirocow\eav\models\EavAttributeValue::className(),
]
];
}
/**
* @return \yii\db\ActiveQuery
*/
public function getEavAttributes()
{
return \mirocow\eav\models\EavAttribute::find()
->joinWith('entity')
->where([
'categoryId' => $this->categories[0]->id,
'entityModel' => $this::className()
]);
}
}
class Product extends \yii\db\ActiveRecord
{
public function rules()
{
return [
[['name'], 'string', 'max' => 255], // Product field
[['c1'], 'required'], // Attribute field
[['c1'], 'string', 'max' => 255], // Attribute field
];
}
public function behaviors()
{
return [
'eav' => [
'class' => \mirocow\eav\EavBehavior::className(),
// это модель для таблицы object_attribute_value
'valueClass' => \mirocow\eav\models\EavAttributeValue::className(),
]
];
}
/**
* @return \yii\db\ActiveQuery
*/
public function getEavAttributes($attributes = [])
{
return \mirocow\eav\models\EavAttribute::find()
->joinWith('entity')
->where([
//'categoryId' => $this->categories[0]->id,
'entityModel' => $this::className()
])
->orderBy(['order' => SORT_ASC]);
}
}
Insert this code for create widget or load all EAV inputs fields for model
fo load selected field
<?=$form->field($model,'test5', ['class' => '\mirocow\eav\widgets\ActiveField'])->eavInput(); ?>
or for load all fields
<?php
foreach($model->getEavAttributes()->all() as $attr) {
echo $form->field($model, $attr->name, ['class' => '\mirocow\eav\widgets\ActiveField'])->eavInput();
}
?>
or add sorted
<?php
foreach($model->getEavAttributes()->orderBy(['order' => SORT_ASC])->all() as $attr) {
echo $form->field($model, $attr->name, ['class' => '\mirocow\eav\widgets\ActiveField'])->eavInput();
}
?>
<?php
foreach($model->getEavAttributes(['entityId' => 8, 'typeId' => 3])->all() as $attr) {
echo $form->field($model, $attr->name, ['class' => '\mirocow\eav\widgets\ActiveField'])->eavInput();
}
?>
<p>
Encode
<?php
foreach($model->getEavAttributes()->all() as $attr) {
print_r($model[$attr->name]['value']);
}
?>
</p>
<p>
String
<?php
foreach($model->getEavAttributes()->all() as $attr){
echo $model[$attr->name];
}
?>
$attr = new mirocow\eav\models\EavAttribute();
$attr->attributes = [
'entityId' => 1, // Category ID
'typeId' => 1, // ID type from eav_attribute_type
'name' => 'packing', // service name field
'label' => 'Packing', // label text for form
'defaultValue' => '10 kg', // default value
'entityModel' => Product::className(), // work model
'required' => false // add rule "required field"
];
$attr->save();
$attr->attributes = [
'entityId' => 1, // Category ID
'typeId' => 1, // ID type from eav_attribute_type
'name' => 'color', // service name field
'label' => 'Color', // label text for form
'defaultValue' => 'white', // default value
'entityModel' => Product::className(), // work model
'required' => false // add rule "required field"
];
$attr->save();
$model = Product::find()->where(['id' => 1])->one();
$model->color = "blue";
$model->packing = "12 kg";
$model->save();
In main config file:
$modules = [
...,
'eav' => [
'class' => 'mirocow\eav\Module',
],
];
<?= \mirocow\eav\admin\widgets\Fields::widget([
'model' => $model,
'categoryId' => $model->id,
'entityName' => 'Продукт',
'entityModel' => 'app\models\Product',
])?>