php - Yii2: Kartik Gridview sum of a column in footer

Question

I have installed the Kartik gridview extension, which is working fine.

But I couldn't find or missed it in the docs, how I can show the sum of a column in the footer.

This is my complete code in index.php

<?php 
        $gridColumns = [
    ['class' => 'yiigridSerialColumn'],
    'id',
    [
        //'attribute'=>'service_name',
        'attribute'=>'service_name',
        'value'=>'serviceName.services',                
    ],
    [
        'attribute'=>'room_category',
        'value'=>'roomCategory.room_category'
     ],
        'charges_cash',
        'charges_cashless',
    ['class' => 'yiigridActionColumn']
];

    echo ExportMenu::widget([
    'dataProvider' => $dataProvider,
    'columns' => $gridColumns,
    'fontAwesome' => true,
    'showPageSummary' => true,
    'dropdownOptions' => [
        'label' => 'Export All',
        'class' => 'btn btn-default'
    ]
]) 
        ?>
    </div></div>


    <?= GridView::widget([
        'dataProvider' => $dataProvider,
        'filterModel' => $searchModel,
        'columns' => [
            ['class' => 'yiigridSerialColumn'],

            'id',
            //'service_name',
            [
                //'attribute'=>'service_name',
                'attribute'=>'service_name',
                'value'=>'serviceName.services',

            ],
           // 'room_category',
            [
                'attribute'=>'room_category',
                'value'=>'roomCategory.room_category'
            ],
            'charges_cash',
            'charges_cashless',

            ['class' => 'yiigridActionColumn'],
        ],
         'showFooter' => true
    ]); ?>

</div>

Looking for some help on this one. Thanks.

Answer 1

I think you just need to add the page summary;

use kartikgridGridView;

// Create a panel layout for your GridView widget
echo GridView::widget([
    'dataProvider'=> $dataProvider,
    'filterModel' => $searchModel,
    'columns' => $gridColumns,
    'showPageSummary' => true
]);

Kartik describes it pretty well in the demo and plugin details.