[Sivanthi]

In the cgridview add following lines

'columns'=>array(
		................
		array(
		'name'=>'column name',
		'type'=>'text',
		'footer'=>$model->getTotals($model->search()->getKeys()),
		),
		..................
		),

we are passing currently displayed primary keys as parameter to getTotals function [in array format]


kindly create a function in model like below

public function getTotals($ids)
	{
		$ids = implode(",",$ids);
		
		$connection=Yii::app()->db;
		$command=$connection->createCommand("SELECT SUM(columnname)
											FROM `tablename` where id in ($ids)");
		return "Total Rs: ".$amount = $command->queryScalar();
	}

Attached File(s)

•  footer with sum.png (8.39K)
  Number of downloads: 73

[savoo]

nice

[seenivasan]

Dear Friend

Let us have a model :Wage.

And we are having a field days.

admin.php

.......other columns......
array(
	'name'=>'days',
	'footer'=>"Total: ".$model->fetchTotalDays($model->search()->getKeys()),
		),
........other columns......

The model function in Wage.php

public function fetchTotalDays($keys)
{
	$wages=self::model()->findAllByPk($keys);
	$days=0;
	foreach($wages as $wage)
		$days+=$wage->days;
	return $days;
}	

Actually CActiveDataProvider::getKeys is wrapper around protected function CActiveDataProvider::fetchKeys.
CActiveDataProvider::fetchKeys get primaryKeys in array from CActiveDataProvider::getData.

Instead of using CActiveDataProvider::getKeys,we can use CActiveDataProvider::getData.

the column declaration in admin.php.

array(
	'name'=>'days',
	'footer'=>"Total: ".$model->fetchTotalDays($model->search()->getData()),
		),

The utility function in the model.

public function fetchTotalDays($records)
{
	$days=0;
	foreach($records as $record)
		$days+=$record->days;
	return $days;
}	

Regards.

[softark]

/* Moved from "General Discussion for Yii 1.1.x" to "Tips, Snippets and Tutorials" */