Yii2 Customized Row's total in footer Kartik v ( display total of row values in footer)

Question

I want to display total of row vaules in footer.

I have tried several ways but doesn't show proper result.

Any help will be highly appriciated.

I am using kartik grid.

I have tried this Yii2: Kartik Gridview sum of a column in footer

but doesn't work in my case.

$gridColumns = [
    [
        'class' => 'kartik\grid\SerialColumn',
        'contentOptions' => ['class' => 'kartik-sheet-style'],
        'width' => '36px',
        'header' => '',
        'headerOptions' => ['class' => 'kartik-sheet-style']
    ],
    [ 
        'attribute' => 'vno',
        'footer'=>'Total'
    ],

    [
        'attribute' => 'fliters',
        'label' => 'Total Fuel Consumption Liters',
        'footer'=> true   // Here i want to display the sum of column filer ( Note : the value in grid of filter is a sum(fuel_liters)  )
    ],
    [
        'attribute' => 'fuel_rate',
        'label' => 'Fuel Rate (Per Ltr.)',
        'pageSummary'=>true,
        'footer'=>true      // Here i want to display the sum of column fuel_rate ( Note : the value in grid of filter is a sum(fuel_rate)  )
    ],
    [
        'attribute' => 'famt',
        'label' => 'Total Fuel Consumption Amount',
         'pageSummary'=>true,
        'footer'=>true  // Here i want to display the sum of column fuel_amount ( Note : the value in grid of filter is a sum(fuel_amount)  )
    ],
];

echo GridView::widget([
    'dataProvider'=> $dataProvider,
    'filterModel' => $searchModel,
    'columns' => $gridColumns,
    'showPageSummary' => true
]);

So far I manage to print total in footer

Im my Controller i have wriiten this

 $total_ltrs = FuelConsumption::find()->sum('fuel_liters');
            $total_amt  = FuelConsumption::find()->sum('fuel_amount');
            $total_rate = FuelConsumption::find()->sum('fuel_rate');


            return $this->render('petrol-report', [
                    'total_ltrs' => $total_ltrs,
                    'total_amt' => $total_amt,
                    'total_rate' => $total_rate,
                    'model' => $model,
                    'searchModel' => $searchModel,
                    'dataProvider' => $dataProvider,
            ]);

And passed 'footer'=>$total_ltrs 'footer'=>$total_rate and 'footer'=>$total_amt Respectively in all footers.

Now when i do search throgh From Date and TO Date the result is dislaying in grid as per filter.

But the Result of Total in footer keeps unchanged. I want to do some of only those rows which are in grid.

Can anybody help me on this ??

[Try this.](http://demos.krajee.com/grid#formula-column-usage) — Insane Skull, Aug 04 '16 at 11:15
@Insane Skull : yes.. but Formula Column is for columns.. In my case there will ne N numbers of rows.. so how can i manage ? Pls help — vijay nathji, Aug 04 '16 at 11:19

e-frank · Answer 1 · 2016-08-06T07:28:36.810

1

in your GridView, enable showFooter
in your column, set the footer text

now you will need a function to return your sum and set is a the footer's text.

GridView::widget([
    'dataProvider' => $dataProvider,
    'filterModel'  => $searchModel,
    'showFooter' => true,
    'columns'      => [
        [
            'class' => '\common\grid\CheckboxColumn'
        ],

        [
            'attribute' => 'myfield1',
            'footer' => 'my footer'
        ],

    ],
]);

if you want a function, use a static helper:

class MyHelper {
    public static function footer() { time(); }
}

        'footer' => MyHelper::footer()

edited Aug 06 '16 at 07:28

answered Aug 04 '16 at 14:30

e-frank

739
11
21

'footer' => function { my code; } i can't use any function here... its gving an error like trim.:( – vijay nathji Aug 05 '16 at 04:02
1

if you want a function, try a static helper: class MyHelper { public static function footer() { return time(); } } ... 'footer' => MyHelper::footer() – e-frank Aug 06 '16 at 07:24

Yii2 Customized Row's total in footer Kartik v ( display total of row values in footer)

1 Answers1