Guriddo » Topic: jqgrid set grouped values into sumary row

jqgrid set grouped values into sumary row

Guriddo
jqgrid set grouped values into sumary row

This topic has 0 replies, 1 voice, and was last updated 13 years ago by renata.

Creator

Topic

August 9, 2013 at 6:23 pm #81172

renata

Participant

In my grid below i have 2 levels of grouping

enter image description here

and my grid is

<div class="sfcode">colModel:[<br />
{name:&#39;szGroupAccType&#39;,index:&#39;szGroupAccType&#39;},<br />
{name:&#39;szAccTypeId&#39;,index:&#39;szAccTypeId&#39;},<br />
{name:&#39;szAccNm&#39;,index:&#39;szAccNm&#39;, width:500,<br />
formatter: function (cellValue, options, rowObject, actions) {<br />
if (options.rowId === "") {<br />
var names = [], data, i, l, item;<br />
if (options.rowId === "" &#038;& typeof actions === "undefined") {<br />
<br />
data = $(this).jqGrid("getGridParam", "data");<br />
//here to set accounts on total<br />
}<br />
return cellValue;<br />
} else {<br />
return &#39;<span style="display:inline-block;left:25px;position:relative;">&#39; +<br />
cellValue;<br />
}<br />
},<br />
summaryType:&#39;count&#39;, summaryTpl : &#39;Total ({0}) &#39;},<br />
{name:&#39;Balance&#39;,index:&#39;Balance&#39;,align:&#39;right&#39;,formatter: numberFormatter, sorttype:"float", summaryType:&#39;sum&#39;, formatoptions:{thousandsSeparator:","}},<br />
{name:&#39;szAccCode&#39;,index:&#39;szAccCode&#39;, hidden:true}<br />
],<br />
grouping:true,<br />
groupingView : {<br />
groupField : [&#39;szGroupAccType&#39;, &#39;szAccTypeId&#39;],<br />
groupSummary : [true, true],<br />
groupColumnShow : [false, false],<br />
groupText : [&#39;<b>{0}</b>&#39;, &#39;{0}&#39;],<br />
groupCollapse : false,<br />
groupOrder: [&#39;asc&#39;, &#39;asc&#39;],<br />
showSummaryOnHide: true<br />
},</span></div>

<div class="sfcode">colModel:[

{name:'szGroupAccType',index:'szGroupAccType'},

{name:'szAccTypeId',index:'szAccTypeId'},

{name:'szAccNm',index:'szAccNm', width:500,

formatter: function (cellValue, options, rowObject, actions) {

if (options.rowId === "") {

var names = [], data, i, l, item;

if (options.rowId === "" && typeof actions === "undefined") {

data = $(this).jqGrid("getGridParam", "data");

//here to set accounts on total

}

return cellValue;

} else {

return '' +

cellValue;

}

},

summaryType:'count', summaryTpl : 'Total ({0}) '},

{name:'Balance',index:'Balance',align:'right',formatter: numberFormatter, sorttype:"float", summaryType:'sum', formatoptions:{thousandsSeparator:","}},

{name:'szAccCode',index:'szAccCode', hidden:true}

],

grouping:true,

groupingView : {

groupField : ['szGroupAccType', 'szAccTypeId'],

groupSummary : [true, true],

groupColumnShow : [false, false],

groupText : ['{0}', '{0}'],

groupCollapse : false,

groupOrder: ['asc', 'asc'],

showSummaryOnHide: true

},</div>

<div class="sfcode"><p>i hv problem with this line</p><br />
<pre><div class="sfcode">data = $(this).jqGrid("getGridParam", "data");<br />
</div>

<div class="sfcode">i hv problem with this line

<pre><div class="sfcode">data = $(this).jqGrid("getGridParam", "data");

</div>

i've checked with firebug and var data is empty. Could you tell me where i did wrong? I'm trying to change total (in yellow) to Aktiva Tetap (110-...Bank dollar, 120- ... Bank rupiah) and total in grey with Asset (Aktiva Tetap (110-...Bank dollar, 120- ... Bank rupiah)) and so on.

Thanks in advance

You must be logged in to reply to this topic.

Stay connected with us in your favorite flavor!

jqgrid set grouped values into sumary row

Search Forum

Recent Replies

Forum Statistics

UserOnline