sum total in footer

International Bulgarian
1

Привет на всички?

от скоро разглеждам yii, но не мога да намеря лесен начин да си направя view, което да показва сумата на дадена колона отдолу.

Намерих начин:

в контролера:

public function search2()

{


	// Warning: Please modify the following code to remove attributes that


	// should not be searched.





	$criteria=new CDbCriteria;





	$criteria->compare('id',$this->id);


	$criteria->compare('kod',$this->kod,true);


	$criteria->compare('name',$this->name,true);


	$criteria->compare('matrix',$this->matrix,true);


	$criteria->compare('teglo',$this->teglo);


	$criteria->compare('grupa',$this->grupa,true);


	$criteria->select = 'kod,name,sum(teglo) as teglo';

$criteria->group = ‘kod’;

	return new CActiveDataProvider(get_class($this), array(


		'criteria'=>$criteria,


	));


}

public function totals()

{

$criteria=new CDbCriteria;


$criteria->select='SUM(teglo) as teglo';


return $this->commandBuilder->createFindCommand($this->getTableSchema(),$criteria)->queryScalar();

}

във view:

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

'id'=>'opisdetailsall-grid',


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


'filter'=>$model,


'columns'=>array(


	


	'kod',


	'name',


	


	array(


	name=>'teglo',


	footer=>$model->totals(),





	),


	


),

));