How to sum up the column data in CGridView

Yii 1.1 General Discussion
1

CGridView widget is great, powerful, I am wondering how to sum up one column to put into the footer, since it has default pagination, is there a way to set some parameter so the gridview can show the page sum and total sum at the footer cell ?

Currently , I pass the total sum to the view and put it in the footer, however I can not figure out how to do the page sum

2

if you want to put summary row on the footer maybe you can use template properties in cgridview :




$this->widget('zii.widgets.grid.CGridView', array(

	'id'=>'t-surat-grid',

	'dataProvider'=>$model->search(),

	'filter'=>$model,

	'columns'=>array(


        ....


        ,

	'summaryText'=>'total : {start} to {end} from {count}',

	'template'=>' {items} {summary} {pager}',  // use this

));

i hope it help… :mellow:

3

See here: http://www.yiiframework.com/forum/index.php?/topic/9636-cgridview-totals-or-summary-row/

4

That is what I am looking for, I am expecting that a new attribute can be put into CDataColumn, so it can calculate the total sum for that column with pagination and sorting

thanks

5

Hey Fastcrash, thank you for the tip. It is not what I am looking for, however I really appreciate your help

6

how did you sum the items in your grid view?