Код: Выделить всё
public $s_catalog;
public $s_model;
public $s_year;
public function relations()
{
return array(
'catalog'=>array(self::MANY_MANY, 'Catalog',
'tbl_prod_cat(product_id, catalog_id)'),
'r_year'=>array(self::HAS_MANY, 'Year', 'prod_id'),
'r_models'=>array(self::HAS_MANY, 'ModProd', 'mod_prod_id'),
'product_c'=>array(self::HAS_MANY, 'Connect', 'product_id'),
);
}
public function UserSearch()
{
$criteria=new CDbCriteria;
$criteria->with = array(
'r_year'=>array(
'together'=>true,
'select'=>'year',
),
'r_models'=>array(
'together'=>true,
'select'=>'model_id',
),
'product_c'=>array(
'together'=>true,
'select'=>'catalog_id',
),
);
$criteria->compare('year',$this->s_year);
$criteria->compare('model_id', $this->s_model);
$criteria->compare('catalog_id', $this->s_catalog);
$criteria->compare('original', $this->original);
return new CActiveDataProvider(get_class($this), array(
'pagination'=>array(
'pageSize'=> 10,
),
'criteria'=>$criteria,
));
}
$this->widget('zii.widgets.CListView', array(
'dataProvider'=>$model->UserSearch(),
'itemView'=>'_search',
));