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(), ), |
|
