Динамические атрибуты для товаров (используем EAV в Yii)

/**
 * This is the model class for table "{{shop_attribute}}".
 *
 * The followings are the available columns in table '{{shop_attribute}}':
 * @property integer $id
 * @property integer $type_id
 * @property integer $sort
 * @property string $alias
 * @property string $title
 * @property integer $inshort
 * 
 * @property ShopType $type
 * @property ShopAttributeValue[] $attribute_values
 */
class ShopAttribute extends CActiveRecord
{    
    /**
     * Returns the static model of the specified AR class.
     * @param string $className active record class name.
     * @return ShopAttribute the static model class
     */
    public static function model($className=__CLASS__)
    {
        return parent::model($className);
    }
 
    /**
     * @return string the associated database table name
     */
    public function tableName()
    {
        return '{{shop_attribute}}';
    }
 
    /**
     * @return array validation rules for model attributes.
     */
    public function rules()
    {
        return array(
            array('alias, title, type_id', 'required'),
            array('sort, inshort', 'numerical', 'integerOnly'=>true),
            array('alias, title', 'length', 'max'=>255),
            array('type_id', 'numerical', 'integerOnly'=>true),
            array('id, type_id, alias, title, inshort', 'safe', 'on'=>'search'),
        );
    }
 
    /**
     * @return array relational rules.
     */
    public function relations()
    {
        return array(
            'type' => array(self::BELONGS_TO, 'ShopType', 'type_id'),
            'attribute_values' => array(self::HAS_MANY, 'ShopAttributeValue', 'attribute_id'),
        );
    }
 
    /**
     * @return array customized attribute labels (name=>label)
     */
    public function attributeLabels()
    {
        return array(
            'id'=>'ID',
            'type_id'=>'Тип товаров',
            'sort'=>'Позиция',
            'alias'=>'URL',
            'title'=>'Атрибут',
            'inshort'=>'Отображать в списке товаров',
        );
    }
 
    /**
     * Retrieves a list of models based on the current search/filter conditions.
     * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
     */
    public function search()
    {
        $criteria=new CDbCriteria;
 
        $criteria->compare('t.id', $this->id);
        $criteria->compare('t.type_id', $this->type_id, true);
        $criteria->compare('t.sort', $this->sort, true);
        $criteria->compare('t.alias', $this->alias, true);
        $criteria->compare('t.title', $this->title, true);
        $criteria->compare('t.inshort', $this->inshort);
 
        return new CActiveDataProvider($this, array(
            'criteria'=>$criteria,
        ));
    }
 
    /** scope
     * @param $type_id
     * @return ShopAttribute
     */
    public function type($type_id)
    {
        $this->getDbCriteria()->mergeWith(array(
            'condition' => 't.type_id=:type',
            'params'=>array(':type'=>$type_id),
        ));
        return $this;
    }
 
    protected function beforeDelete()
    {
        if (parent::beforeDelete())
        {
            foreach ($this->attribute_values as $value)
                $value->delete(); 
 
            return true;
        }         
 
        return false;
    }
}

/**
 * This is the model class for table "{{shop_attribute_value}}".
 *
 * The followings are the available columns in table '{{shop_attribute_value}}':
 * @property integer $id
 * @property integer $product_id
 * @property integer $attribute_id
 * @property string $value
 * 
 * @property ShopProduct $product
 * @property ShopAttribute $attribute
 */
class ShopAttributeValue extends CActiveRecord
{
    /**
     * Returns the static model of the specified AR class.
     * @param string $className active record class name.
     * @return ShopAttributeValue the static model class
     */
    public static function model($className=__CLASS__)
    {
        return parent::model($className);
    }
 
    /**
     * @return string the associated database table name
     */
    public function tableName()
    {
        return '{{shop_attribute_value}}';
    }
 
    /**
     * @return array validation rules for model attributes.
     */
    public function rules()
    {
        return array(
            array('product_id, attribute_id', 'required'),
            array('product_id, attribute_id', 'numerical', 'integerOnly'=>true),
            array('value', 'length', 'max'=>255),
            // Please remove those attributes that should not be searched.
            array('id, product_id, attribute_id, value', 'safe', 'on'=>'search'),
        );
    }
 
    /**
     * @return array relational rules.
     */
    public function relations()
    {
        return array(
            'product'=>array(self::BELONGS_TO, 'ShopProduct', 'product_id'),
            'attribute'=>array(self::BELONGS_TO, 'ShopAttribute', 'attribute_id'),
        );
    }
 
    /**
     * @return array customized attribute labels (name=>label)
     */
    public function attributeLabels()
    {
        return array(
            'id' => 'ID',
            'product_id' => 'Product',
            'attribute_id' => 'Attribute',
            'value' => 'Value',
        );
    }
 
    /**
     * Retrieves a list of models based on the current search/filter conditions.
     * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
     */
    public function search()
    {
        $criteria=new CDbCriteria;
 
        $criteria->compare('t.id', $this->id);
        $criteria->compare('t.product_id', $this->product_id);
        $criteria->compare('t.attribute_id', $this->attribute_id);
        $criteria->compare('t.value', $this->value, true);
 
        return new CActiveDataProvider($this, array(
            'criteria'=>$criteria,
        ));
    }
}

$atts = ShopAttribute::model()->findAllByAttributed(array('type_id'=>$type_id));

$atts = ShopAttribute::model()->type($type_id)->findAll();

<?php
<?php
 
/**
 * This is the model class for table "{{shop_product}}".
 *
 * The followings are the available columns in table '{{shop_product}}':
 * @property integer $id
 * @property string $artikul
 * @property integer $type_id
 * @property integer $category_id
 * ...
 
 * @property ShopAttributeValue[] $inshort_attribute_values
 * @property ShopAttributeValue[] $all_attribute_values
 */
class ShopProduct extends CActiveRecord
{
    // ...
 
    /**
     * @return array relational rules.
     */
    public function relations()
    {
        return array(
            'type' => array(self::BELONGS_TO, 'ShopType', 'type_id'),
            'category' => array(self::BELONGS_TO, 'ShopCategory', 'category_id'),
            'inshort_attribute_values' => array(self::HAS_MANY, 'ShopAttributeValue', 'product_id',
                'condition'=>'attribute.inshort = 1',
                'order'=>'attribute.sort ASC',
                'with'=>'attribute',
            ),
            'all_attribute_values' => array(self::HAS_MANY, 'ShopAttributeValue', 'product_id',
                'order'=>'attribute.sort ASC',
                'with'=>'attribute',
            ),
        );
    }
 
    protected function beforeDelete()
    {
        if (parent::beforeDelete())
        {
            foreach ($this->all_attribute_values as $val)
                $$val->delete();
 
            return true;
        }
 
        return false;
    }
 
    private $_url;
 
    public function getUrl(){
 
        if (!$this->type || !$this->category)
            return '';
 
        if ($this->_url === null)
            $this->_url = Yii::app()->request->baseUrl . '/shop/' . $this->type->alias . '/' . $this->category->alias . '/' . $this->id;
 
        return $this->_url;
    }
}

<?php
<?php foreach ($product->all_attribute_values as $attrValue): ?>
    <?php if ($attrValue->value): ?>
        <p><?php echo CHtml::encode($attrValue->attribute->name); ?>: <?php echo CHtml::encode($attrValue->value); ?></p>
    <?php endif; ?>
<?php endforeach; ?>

<?php
<?php
 
$items = array();
 
foreach ($product->all_attribute_values as $attrValue)
{
    $items[] = array(
        'label'=>$attrValue->attribute->name,
        'value'=>$attrValue->value,
    );
}
 
$this->widget('zii.widgets.CDetailView', array(
    'data'=>$model,
    'attributes'=>array_merge(
        array(
            'artikul',
            array(
                'label'=>'Категория',
                'type'=>'html',
                'value'=>CHtml::link(CHtml::encode($model->category->title), $model->$model->category->url),
            ),
            'price'
        ),
        $items
    ),
));
?>

class ShopProduct extends CActiveRecord
{
    // ...
 
    public function getAttrsDetailViewList($autoVisible=true)
    {    
        $items = array();
 
        foreach ($this->all_attribute_values as $attrValue)
        {
            $items[] = array(
                'label'=>$attrValue->attribute->name,
                'value'=>$attrValue->value,
                'visible'=>$autoVisible ? $attrValue->value : 1,
            );
        }
 
        return $items;
    }
}

<?php
<?php $this->widget('zii.widgets.CDetailView', array(
    'data'=>$model,
    'attributes'=>array_merge(
        array(
            'artikul',
            array(
                'label'=>'Категория',
                'type'=>'html',
                'value'=>CHtml::link(CHtml::encode($model->category->title), $model->$model->category->url),
            ),
            'price'
        ),
        $model->getAttrsDetailViewList()
    ),
));
?>

public function actionAttributes($id)
{
    $product = $this->loadModel($id);
    $atts = ShopAttribute::model()->type($product->type_id)->findAll();
 
    // Строим массив полей    
    $items = array();    
    foreach ($attrs as $attr)
    {
        $items[$attr->alias] = array(
            'model'=>$attr,
            'value'=>'',
        }
    }
 
    // Заполняем текущими значениями  
    $attValues = $product->all_attribute_values;    
    foreach ($attValues as $attValue)
        $items[$attValue->attribute->alias]['value'] = $attValue->value;
 
 
    // Обновляем/добавляем значения при отправке формы
    if (isset($_POST['Attributes'])
    {
        // ...
    }
 
    // Передаём товар и массив полей в представление
    $this->render('attributes', array(
        'product'=>$product,
        'items'=>$items,
    ));
}