jQuery Grid Plugin - jqGrid - Topic: Summary row and colmodel options

OlegK on Summary row and colmodel options

Wed, 06 Apr 2011 19:26:28 +0300

I mean of course $("#list") instead of $("list"), where "list" is the id of the table element of jqGrid.

generalshiva on Summary row and colmodel options

Tue, 05 Apr 2011 12:42:45 +0300

what is "list" in the context???

OlegK on Summary row and colmodel options

Thu, 24 Feb 2011 20:21:17 +0200

Hi Lotte-Sara,

If you want calculate a sum from the cells in one column in the current page you can do this with respect of getCol methed

var sum = $("list").jqGrid('getCol','fldBedragNaKortingen',false,'sum');

Then with respect of

$("list").jqGrid('footerData','set',{fldArtikelcode:'Summary',fldBedragNaKortingen:sum});

you can place the sum in the footer.

Best regards
Oleg

lotjuh on Summary row and colmodel options

Thu, 24 Feb 2011 16:18:41 +0200

Hoi Tony,

It seems to me that the footerData method is basically the same as using userDataOnFooter because you have to feed it an array with name:value pairs. I don't want to calculate the totals myself, I want jqgrid to do this for me based on the given summaryType and summaryTpl in my colModel options. This is all done for you when grouping is enabled, but when grouping is disabled, these options are ignored.

'colModel'        : [
     { 'name': 'fldVerkoopOrderRegelID','index': 'fldVerkoopOrderRegelID', 'hidden': true },
     { 'name': 'fldArtikelcode',        'index': 'fldArtikelcode',      'width': 120, 'fixed': true,     'summaryTpl': '<stong>Totaal</strong>'
       'editable': true, 'formatter': $.unitTbookOrders.orderTypeFormatter },
     { 'name': 'fldOmschrijving',       'index': 'fldOmschrijving' },
     { 'name': 'fldAantalVerkocht',     'index': 'fldAantalVerkocht',   'width': 50, 'fixed': true, 'sorttype': 'float', 'formatter': 'number' },
     { 'name': 'fldVerkoopprijs',       'index': 'fldVerkoopprijs',     'width': 50, 'fixed': true, 'sorttype': 'float', 'formatter': 'number' },
     { 'name': 'fldRegelkorting',       'index': 'fldRegelkorting',     'width': 50, 'fixed': true, 'sorttype': 'float', 'formatter': 'number' },
     { 'name': 'fldBedragNaKortingen', 'index': 'fldBedragNaKortingen','width': 50, 'fixed': true,
       'sorttype': 'float', 'formatter': 'number', 'summaryType': 'sum' }
],

Regards,

Lotte-Sara Laan

tony on Summary row and colmodel options

Thu, 10 Feb 2011 18:48:30 +0200

Hello,

Some things happen as tey are defined, otherviese not.

To answer of your question - I think yes this is possible,

Just use the method footerData

http://www.trirand.com/jqgridw.....ki:methods

Regards

Tony

lotjuh on Summary row and colmodel options

Thu, 10 Feb 2011 17:20:38 +0200

Hi Tony,

I'm trying to get a summary row just as shown in your Demos -> Grouping -> Summary Footers example, but I don't want to use the grouping function.

I tried to add the summaryType and summaryTpl options to my colmodel columns, but it seems to ignore these option when grouping is not set to true.

Is there anyway to get the same result as in your example without enabling grouping and without using the userDataOnFooter option? If not, wouldn't it be a good idea to implement the summary footer for ungrouped rows the same as you've implemented for grouped rows?

Kind Regards,

Lotte-Sara