我想显示我的属性列表(id、名称、价格、折扣)和不是属性的(total_price)列。
当我使用这个代码时,它显示了数据表,但我不能在(total_price)列中搜索或排序
有人能帮我吗?
<?php $this->widget('zii.widgets.grid.CGridView', array(
'id'=>'product-grid',
'dataProvider'=>$model->search(),
'filter'=>$model,
'columns'=>array(
'id',
'name',
array(
'header' =>'Price',
'name'=>'price',
'value'=>'$data->price',
),
array(
'header' =>'Discount',
'name'=>'discount',
'value'=>'$data->discount',
),
array(
'header' =>'total price',// total price doesn't save in Data Base
'name'=>'total_price',
'value'=>'total_price - (total_price * $data->discount/100)',
),
array(
'class'=>'CButtonColumn',
),
),
))
?>
你可以在$model->search()方法上这样:
$criteria=new CDbCriteria;
$criteria->select = "t.*, t.price - (t.price * t.discount/100) as total_price";
// EDITED: Added for Sort:
$sort = new CSort();
$sort->attributes = array(
'defaultOrder'=>'name ASC',
'total_price'=>array(
'asc'=>'total_price ASC',
'desc'=>'total_price DESC',
),
'*', // Add order in the other fields.
);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
'sort'=>$sort, // Added to sort.
);
并在"产品"模型类上创建一个非持久性属性:
public $total_price;
最后,将"total_price"放在rules()上,数组中有("fe","on"=>"search"),类似于以下内容:
array('id, name, price, discount, total_price', 'safe', 'on'=>'search'),