如何使用CGridView使CSqldataprovider列可排序？

Question

如何使用CGridView使CSqldataprovider列可排序(单击列标题)。

在控制器中

    $sql = "select id ,name, address
            from User
            where city = 'ABC' ";
    $rawData = Yii::app()->db->createCommand($sql);
    return $allMovies = new CSqlDataProvider($rawData, array(
        'keyField' => 'id',
        'sort'=>array(
            'attributes'=>array(
            'id', 'name', 'address',
          ),
        ),
        'pagination' => array(
                'pageSize' => 10,
            ),
    ));

在望

 $this->widget('zii.widgets.grid.CGridView', array(
    'id' => 'all_movies',
    'dataProvider' => $allMoviesStats,
    'columns' => array(
            'id',
            'name', 
            'address',
            'city'
      )
    )
);?>

它带来了错误

 "error":{"code":99,"text":"Property \"CGridView.sort\" is not defined.

Answer 1

您需要为CDbCriteria和排序类创建对象，并尝试按下面的方式使用，并为您的需求更改代码。

public function search()
{
    $criteria=new CDbCriteria;
    $criteria->condition="active=1";
    if($this->name=="Enter Country Name" || $this->name=='') {
        $this->name='';
    } else {
        $this->name=$this->name;
    }
    $criteria->compare('name',$this->name,true);
    $sort = new CSort;
    $sort->defaultOrder = 'id DESC';
    $sort->attributes = array(          
        'name' => array(
            'asc'   =>'name',
            'desc'  =>'name DESC',
        ),
        ...
        ... // attributes to sort
    );
    return new CActiveDataProvider('Country', array( //Country is nothing but you model class name
        'criteria'  =>$criteria,
        'sort'       => $sort,
        'pagination'=>array('pageSize'=> 10),
    ));
}