hallo semuanya, saya mau tanya, gimana caranya ambil value yg da diselect …as… di cdbcriteria biar valuenya bisa dimasukkin ke cgridview
ini coding di controlernya :
$criteria->select='month(date) as bulan, year(date) as tahun,count(id) as id,sum(price) as price';
$criteria->addCondition('date >= :to and date <= :from');
$criteria->params=array(
':to'=>$date[0],
':from'=>$date[1],
);
$criteria->group='tahun,bulan';
trus valuenya dimasukkin ke view :
$this->widget('zii.widgets.grid.CGridView',array(
'id'=>'batch-report-grid',
'dataProvider'=>$dataProvider,
'columns'=>array(
array(
'name'=>'Date',
'value'=>'',-->//taro valuenya ke sini
),
array(
'name'=>'Jumlah Batch',
//'type'=>'raw',
'value'=>'$data->id',
),
'price',
),
));
array(
'name'=>'Date',
'value'=>'',-->//masukkin value yg month(date) as bulan & value yg year(date) as tahun
),
tolong dibantu…
thanks