关系模型过滤搜索


Yii, relation model filter search

我正在与使用相关模型列的CGridView过滤作斗争,我有两个模型Cars和color,所以Colour has_many Car和Car belongs_to color。来自相关模型的网格列显示良好,我只是无法过滤它。mysql出错

Column not found: 1054 Unknown column 'carName'

颜色模型 HAS_MANY - Cars

我从Car模型中取消了变量$carName,所以这个模型可以看到它。

public $carName;
public function rules()
{
   return array(
          array('id, carName, colourName', 'safe', 'on'=>'search'),
               )
}
public function relations()
{
    return array(
                'CarsObj'=>array(self::HAS_MANY, 'Cars', 'colourID')
    );
}
public function search()
{ 
    $criteria=new CDbCriteria;
    $criteria->with = "CarsObj";
    $criteria->compare('carName', $this->carName, true);
    $criteria->compare('id',$this->id);
    $criteria->compare('colourName',$this->colourName,true);

    return new CActiveDataProvider($this, array(
        'criteria'=>$criteria,
    ));
}

汽车模型 BELONGS_TO - color

public function relations()
{ 
 return array( 
   'ColourObj'=>array(self::BELONGS_TO, 'Colour', 'colourID')
 );
}

CGridView,我使用颜色模型搜索作为我的数据提供者

 $model = new Colour('search');
 $data = $model->search(); 
 $this->widget('zii.widgets.grid.CGridView', array(
           'dataProvider'=>$data
           ,'filter'=>$model 
           ,'pager'=>array('header'=>'')  
           ,'columns'=>array( //related model column
                    'id',
                     'colourName',
                      array(
                            'header' => 'carName',
                            'type' => 'raw', 
                            'name' => 'carName',
                            'value' => function($data, $row) { //$data is item of DataProvider, $row is number of row (starts from 0)
                                $carNames= CHtml::listData((array)$data->ColourObj, 'id', 'carName');
                                return implode(', ', $carNames);
                            }
                            )

默认CActiveRecord使用延迟加载。您需要将属性设置为true。当您使用with时,设置表别名也是一个很好的做法。

public function search(){ 
    $criteria=new CDbCriteria;
    $criteria->together = true;
    $criteria->with = 'CarsObj';
    $criteria->compare('CarsObj.carName',$this->carName,true);
    $criteria->compare('t.id',$this->id);
    $criteria->compare('t.colourName',$this->colourName,true);
    return new CActiveDataProvider($this, array(
        'criteria'=>$criteria,
    ));
}

试试这个

public function search(){

$criteria=new CDbCriteria;
$criteria->with = "CarsObj";
$criteria->compare('CarsObj.carName', $this->carName, true);
$criteria->compare('id',$this->id);
$criteria->compare('colourName',$this->colourName,true);

return new CActiveDataProvider($this, array(
    'criteria'=>$criteria,
));

}