Yii把CGridView文本框换成下拉框

作者：袖梨 2022-06-25

默认情况下CGridView会生成一个文本框，但是这并不友好，用户往往希望知道有什么可选的，特别是数据库里存的是数字id的时候，我们希望将数字转换为可读的文本，这时候只需要修改一下表头的"filter"属性就行了，比如：

 代码如下 复制代码

widget('zii.widgets.grid.CGridView', array(
    'id'=>'business-grid',
    'dataProvider'=>$dataProvider,
    'filter'=> Business::model(),
    'columns'=>array(
        'business_id',
        'name',
        'package_id'=> array(
            'name' => 'package_id',
            'value' => '$data->package->package_title',
            'filter'=> CHtml::listData(Packages::model()->findAll(array('order'=>'package_title')), 'package_id', 'package_title')
        ),
        'user_id'=>array(
            'name' => 'user_id',
            'value' => '$data->user->name',
            'filter'=> CHtml::listData(Users::model()->findAll(array('order'=>'firstname')), 'id', 'name')
        ),
        'categories' => array(
            'name' => 'categories',
            'value' => '$data->returnAllCategories(", ",false);',
            'filter'=> CHtml::listData(Categories::model()->findAll(array('order'=>'category')), 'cat_id', 'category')
        ),
        'keywords' => array(
            'header' => 'Keywords',
            'value' => '$data->returnAllKeywords(", ",false);',
        ),
        'links'=>array(
            'header'=>'Manage',
            'type'=>'raw',
            'value'=>'CHtml::link(CHtml::image(Yii::app()->request->baseUrl."/images/admin/approve.png","Approve"), array("approve","id"=>$data->business_id,"item"=>"business"),array("class"=>"approve-link","title"=>"Approve Business"))." ".
                      CHtml::link(CHtml::image(Yii::app()->request->baseUrl."/images/admin/reject.png","Reject"), array("reject","id"=>$data->business_id,"item"=>"business"),array("class"=>"reject-link","title"=>"Reject Business"))',
        ),
 
    ),
));



生成type下拉框可以这么写：

 代码如下 复制代码
'type'=>array(
            'name' => 'type',
            'filter'=>$model->getTypeOptions(),
        ),

'type'=>array(
            'name' => 'type',
            'filter'=>$model->getTypeOptions(),
        ),

相关文章

精彩推荐