i have a question,
how to make a view like this,
3703
from my CGridView,
3704
this is my code :
<?php
$sum=Yii::app()->db->createCommand('SELECT SUM(penyusutan) FROM view_penyusutan_gol_per_tahun')->queryScalar();
$this->widget('zii.widgets.grid.CGridView', array(
'id'=>'twilayah-grid',
'dataProvider'=>$model->search(),
//'summaryText'=>'Jumlah Total : '. $sum,
'filter'=>$model,
'columns'=>array(
'thn_ang',
'kd_gol',
'ur_gol',
//'total',
//'footer'=>'Total: '.number_format($sum),
array(
'name'=>'penyusutan',
'value'=>'number_format($data->penyusutan,0,"",".")',
'htmlOptions'=>array('style'=>'text-align:right;'),
'footer'=>number_format($sum,0,"","."),
'footerHtmlOptions'=>array('style'=>'text-align:right;'),
'headerHtmlOptions'=>array('style'=>'text-align:right;'),
),
/*array(
'class'=>'CButtonColumn',
),*/
),
));
?>
thanks. . .