You are viewing revision #1 of this wiki article.
This is the latest version of this article.
GridView show sum of columns in footer
`PHP
use yii\grid\DataColumn;
/**
- Sum of all the values in the column
@author shiv / class TSumColumn extends DataColumn { public function getDataCellValue($model, $key, $index) {
$value = parent::getDataCellValue($model, $key, $index); if ( is_numeric($value)) { $this->footer += $value; } return $value;} }
`
Now you have to enable footer in GridView
echo GridView::widget([
'dataProvider' => $dataProvider,
'filterModel' => $searchModel,
'showFooter' => true,
Also change the coulmn class
[
'class' => TSumColumn::class,
'attribute' => 'amount'
],
You would see the total in footer of the grid. you can apply this to multiple columns if need
User Contributed Notes
Leave a comment
If you have any questions, please ask in the forum instead.
Join the conversation to share a note.