[SOLVED]How can i appendRow in groupFormatter?

[dayaners]

Can someone help me?

I need to show the sum of each group. im Trying to do this:

Code:

 $(dg).datagrid({
        method: "POST",
        url: "app/retorno.php",
        queryParams: {requisicao: 'percent',compet: compet,ap:title},
        singleSelect:true,
        collapsible:true,
        fitColumns:true,
        showFooter: true,
        view:groupview,
        groupField:'NOME_UB',
        groupFormatter:function(values,rows){
            var total_unidade_benef = 0;
            var total_unidade_acomp = 0;
            var total_unidade_nao_acomp = 0;
            for (var i = 0; i < rows.length; i++) {
              total_unidade_benef =  total_unidade_benef + parseInt(rows[i].TOTAL_GERAL);
              total_unidade_acomp =  total_unidade_acomp + parseInt(rows[i].TOTAL_ACOMP);
              total_unidade_nao_acomp =  total_unidade_nao_acomp + parseInt(rows[i].TOTAL_NAO_ACOMP);
            }
            
           /* $(dg).datagrid('appendRow',{
              COD_AREA: 'TOTAL UNIDADE',
              TOTAL_GERAL:total_unidade_benef,
              TOTAL_ACOMP:total_unidade_acomp,
              PERCENT_ACOMP:'',
              TOTAL_NAO_ACOMP:total_unidade_nao_acomp,
              PERCENT_NAO_ACOMP:''
            });*/
            return values;
        },
        groupStyler:function(value,rows){ // deixar a linha com nome da unidade azul //#337ab7
          return 'background-color:#769dbe;color:white';
        },
        rowStyler: function(index,row){// pintar a linha dos sem equipe de 'vermelho'
              if(row.COD_AREA == ''){
                return 'background-color:#f9d7d8;color:black;';
              }
        },
        onLoadSuccess:function(){ // deixar os collapse fechado exceto o primeiro
          var gcount = $(this).datagrid('options').view.groups.length;
          for(var i=1; i<gcount; i++){
            $(this).datagrid('collapseGroup', i);
          }
        },
        width:'98%',
        height:'500',
        columns:colunas
      });

But im getting this message: 'Uncaught RangeError: Maximum call stack size exceeded'.

[stworthy]

Please append sum values after loaded data successfully. Make sure to download the newest 'datagrid-groupview.js' file from http://www.jeasyui.com/extension/datagridview.php

Code:

$('#dg').datagrid({
	view: groupview,
	onLoadSuccess: function(){
		var groups = $(this).datagrid('groups');
		for(var i=0; i<groups.length; i++){
			var group = groups[i];
			var unitcost = 0;
			$.map(group.rows, function(row){
				unitcost += row.unitcost;
			});
			$(this).datagrid('appendRow', {
				productid: group.value,
				unitcost: unitcost
			})
		}
	}
})

[dayaners]

Thanks it works fine for me

[cekone]

what is the code to make the sum of the tagihan_sisa column

Here is my code :

Code:

<table id="dg_income_rekap" class="easyui-datagrid" url="income_rekap/rekap" toolbar="#toolbar_income_rekap" pagination="true" remoteSort="false" remoteFilter="true" pageSize="20" pageList="[20,40,80,100]" rownumbers="true" fitColumns="true" singleSelect="true" showFooter="true" striped="true" fit="true"
      data-options="
      collapsible:true,
      view:groupview,
      groupField:'kelompok',
      groupFormatter:function(value,rows,row){
                    return value + ' (' + rows.length + ' Periode)' + '  Rp.' 
      }">
      <thead>
        <tr>
          <th field="periode" width="525" halign="center" align="left" sortable="true">Periode</th>
          <th field="tagihan" width="150" halign="center" align="right" formatter="rupiah" sortable="true">Tagihan</th>
          <th field="potongan" width="150" halign="center" align="right" formatter="rupiah" sortable="true">Potongan</th>
          <th field="ticket" width="150" halign="center" align="right" formatter="rupiah" sortable="true">Ticket</th>
          <th field="tagihan_sisa" width="150" halign="center" align="right" formatter="rupiah" sortable="true">Sisa Tagihan</th>
        </tr>
      </thead>
</table>

[cekone]

Ok, it's solved