Title: [SOLVED]How can i appendRow in groupFormatter?
Post by: dayaners on July 26, 2016, 07:31:11 AM
Can someone help me? I need to show the sum of each group. im Trying to do this: $(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'.
Title: Re: How can i appendRow in groupFormatter?
Post by: stworthy on July 27, 2016, 05:59:10 PM
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 $('#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
})
}
}
})
Title: Re: [SOLVED]How can i appendRow in groupFormatter?
Post by: dayaners on August 03, 2016, 10:02:57 AM
Thanks it works fine for me
Title: Re: [SOLVED]How can i appendRow in groupFormatter?
Post by: cekone on October 25, 2018, 02:26:27 AM
what is the code to make the sum of the tagihan_sisa column ??? Here is my 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>
Title: Re: [SOLVED]How can i appendRow in groupFormatter?
Post by: cekone on November 03, 2018, 01:09:46 PM
Ok, it's solved ;)
|