Problem MergeCells on Footer Datagrid

[noerone]

i don't know where my fault from merge cell on datagrid. can you help me.

Code:

$('#tbl-kartu-stok').datagrid({
                url:'<?=base_url()?>ks/c_kartu_stok/data_kartu_stok/<?=$nama?>',
                toolbar:'#toolbar',
                pagination: 'true',
                pageSize:'20',
                remoteFilter: 'true',
                rownumbers: 'true',
                showFooter:'true',
                singleSelect: 'true',
                columns:[[
                    {field:'kd_item',title:'Kode',width:70,halign:'center',align:'right', sortable:true},
                    {field:'nm_item',title:'Nama bahan',width:210,halign:'center',sortable:true},
                    {field:'satuan',title:'Satuan',width:120,halign:'center',align:'center',sortable:true},
                    {field:'stok',title:'Stok',width:80,sortable:true,halign:'center',align:'right', formatter: function(value,row,index){
                            return accounting.formatNumber(value);
                    }},
                    {field:'hpp',title:'HPP',width:110,sortable:true,halign:'center',align:'right', formatter: function(value,row,index){
                            return accounting.formatNumber(value);
                    }},
                    {field:'total',title:'Total',width:110,sortable:true,halign:'center',align:'right', formatter: function(value,row,index){
                            return accounting.formatNumber(value);
                    }},
                    {field:'c_date',title:'Create Date',width:150,halign:'center',align:'center',sortable:true},
                    {field:'m_date',title:'Modified Date',width:150,halign:'center',align:'center',sortable:true}
                ]]
            });

this for mergecells :

Code:

$('#tbl-kartu-stok').datagrid('mergeCells', {
                index: 1,
                field: 'nm_item',
                colspan: 2,
                type: 'footer'
            });

output :

[jarry]

Please notice that the row index starts with 0. Try this code instead.

Code:

$('#tbl-kartu-stok').datagrid('mergeCells', {
                index: 0,
                field: 'nm_item',
                colspan: 2,
                type: 'footer'
            });

[noerone]

Please notice that the row index starts with 0. Try this code instead.

Code:

$('#tbl-kartu-stok').datagrid('mergeCells', {
                index: 0,
                field: 'nm_item',
                colspan: 2,
                type: 'footer'
            });

I already tried it , but it does not change

[noerone]

I have 2 types of data output :

1.Data footer does not appear

Code:

{"total":10,"rows":[{"kd_item":"21","nm_item":"Bahan Sutera No.01","satuan":"m","stok":"4380","hpp":"21000","total":"91980000","c_date":"2015-11-12 20:47:51.514","m_date":"2015-11-12 23:24:41.624","b1":"10004","b2":null,"b3":null,"b4":null},{"kd_item":"16","nm_item":"bahan katun import","satuan":"m","stok":"9980","hpp":"17000","total":"169660000","c_date":"2015-10-29 08:48:03.761","m_date":"2015-11-02 23:53:43.262","b1":null,"b2":null,"b3":null,"b4":null},{"kd_item":"11","nm_item":"Bahan Kaos 20s","satuan":"m","stok":"9825","hpp":"9000","total":"88425000","c_date":"2015-10-29 08:48:03.014","m_date":"2015-11-13 21:26:37.976","b1":"30002","b2":null,"b3":null,"b4":null},{"kd_item":"10","nm_item":"Bahan Gamis","satuan":"m","stok":"9850","hpp":"18500","total":"182225000","c_date":"2015-10-29 08:48:03.013","m_date":"2015-11-13 22:34:56.104","b1":"20001","b2":null,"b3":null,"b4":null},{"kd_item":"9","nm_item":"Bahan Kaos 30s","satuan":"m","stok":"9785","hpp":"9000","total":"88065000","c_date":"2015-10-29 08:48:03.011","m_date":"2015-11-13 22:11:02.809","b1":"30001","b2":null,"b3":null,"b4":"10003"},{"kd_item":"8","nm_item":"Bahan baju Muslim 01","satuan":"m","stok":"9900","hpp":"21000","total":"207900000","c_date":"2015-10-29 08:48:02.98","m_date":"2015-11-06 00:02:25.7","b1":null,"b2":"30001","b3":null,"b4":""},{"kd_item":"6","nm_item":"Bahan Jeans Hitam","satuan":"m","stok":"9965","hpp":"23000","total":"229195000","c_date":"2015-10-29 08:47:45.954","m_date":"2015-11-06 00:28:33.372","b1":"30001","b2":null,"b3":null,"b4":null},{"kd_item":"5","nm_item":"Bahan batik","satuan":"m","stok":"9900","hpp":"15000","total":"148500000","c_date":"2015-10-29 08:47:45.926","m_date":"2015-11-15 00:13:48.643","b1":"10003","b2":"13","b3":null,"b4":null},{"kd_item":"2","nm_item":"bahan levis","satuan":"m","stok":"10000","hpp":"25000","total":"250000000","c_date":"2015-10-29 08:47:38.228","m_date":null,"b1":"","b2":null,"b3":null,"b4":null},{"kd_item":"1","nm_item":"bahan katun","satuan":"m","stok":"9935","hpp":"12000","total":"119220000","c_date":"2015-10-29 08:47:38.169","m_date":"2015-11-06 09:48:49.867","b1":"30001","b2":"20001","b3":"10003","b4":"10001"}],"footer":{"stok":93520,"nm_item":"Total Stok"}}

2.Data footer appears

Code:

{"total":10,"rows":[{"kd_item":"21","nm_item":"Bahan Sutera No.01","satuan":"m","stok":"4380","hpp":"21000","total":"91980000","c_date":"2015-11-12 20:47:51.514","m_date":"2015-11-12 23:24:41.624","b1":"10004","b2":null,"b3":null,"b4":null},{"kd_item":"16","nm_item":"bahan katun import","satuan":"m","stok":"9980","hpp":"17000","total":"169660000","c_date":"2015-10-29 08:48:03.761","m_date":"2015-11-02 23:53:43.262","b1":null,"b2":null,"b3":null,"b4":null},{"kd_item":"11","nm_item":"Bahan Kaos 20s","satuan":"m","stok":"9825","hpp":"9000","total":"88425000","c_date":"2015-10-29 08:48:03.014","m_date":"2015-11-13 21:26:37.976","b1":"30002","b2":null,"b3":null,"b4":null},{"kd_item":"10","nm_item":"Bahan Gamis","satuan":"m","stok":"9850","hpp":"18500","total":"182225000","c_date":"2015-10-29 08:48:03.013","m_date":"2015-11-13 22:34:56.104","b1":"20001","b2":null,"b3":null,"b4":null},{"kd_item":"9","nm_item":"Bahan Kaos 30s","satuan":"m","stok":"9785","hpp":"9000","total":"88065000","c_date":"2015-10-29 08:48:03.011","m_date":"2015-11-13 22:11:02.809","b1":"30001","b2":null,"b3":null,"b4":"10003"},{"kd_item":"8","nm_item":"Bahan baju Muslim 01","satuan":"m","stok":"9900","hpp":"21000","total":"207900000","c_date":"2015-10-29 08:48:02.98","m_date":"2015-11-06 00:02:25.7","b1":null,"b2":"30001","b3":null,"b4":""},{"kd_item":"6","nm_item":"Bahan Jeans Hitam","satuan":"m","stok":"9965","hpp":"23000","total":"229195000","c_date":"2015-10-29 08:47:45.954","m_date":"2015-11-06 00:28:33.372","b1":"30001","b2":null,"b3":null,"b4":null},{"kd_item":"5","nm_item":"Bahan batik","satuan":"m","stok":"9900","hpp":"15000","total":"148500000","c_date":"2015-10-29 08:47:45.926","m_date":"2015-11-15 00:13:48.643","b1":"10003","b2":"13","b3":null,"b4":null},{"kd_item":"2","nm_item":"bahan levis","satuan":"m","stok":"10000","hpp":"25000","total":"250000000","c_date":"2015-10-29 08:47:38.228","m_date":null,"b1":"","b2":null,"b3":null,"b4":null},{"kd_item":"1","nm_item":"bahan katun","satuan":"m","stok":"9935","hpp":"12000","total":"119220000","c_date":"2015-10-29 08:47:38.169","m_date":"2015-11-06 09:48:49.867","b1":"30001","b2":"20001","b3":"10003","b4":"10001"},{"stok":93520,"nm_item":"Total Stok"}],"footer":{"stok":93520,"nm_item":"Total Stok"}}

what the data is correct ??

[jarry]

Please refer to http://jsfiddle.net/4upsen4e/. It works fine.

[dilma12]

maybe i can help litle..

i have same problem about merger footer..

i add function
onLoadSuccess:function(){
       $(this).datagrid('mergeCells', {index: 1, field: 'nm_item',colspan: 2,type: 'footer'});
}

$('#tbl-kartu-stok').datagrid({
                url:'<?=base_url()?>ks/c_kartu_stok/data_kartu_stok/<?=$nama?>',
                toolbar:'#toolbar',
                pagination: 'true',
                pageSize:'20',
                remoteFilter: 'true',
                rownumbers: 'true',
                showFooter:'true',
                singleSelect: 'true',               
                columns:[[
                    {field:'kd_item',title:'Kode',width:70,halign:'center',align:'right', sortable:true},
                    {field:'nm_item',title:'Nama bahan',width:210,halign:'center',sortable:true},
                    {field:'satuan',title:'Satuan',width:120,halign:'center',align:'center',sortable:true},
                    {field:'stok',title:'Stok',width:80,sortable:true,halign:'center',align:'right', formatter: function(value,row,index){
                            return accounting.formatNumber(value);
                    }},
                    {field:'hpp',title:'HPP',width:110,sortable:true,halign:'center',align:'right', formatter: function(value,row,index){
                            return accounting.formatNumber(value);
                    }},
                    {field:'total',title:'Total',width:110,sortable:true,halign:'center',align:'right', formatter: function(value,row,index){
                            return accounting.formatNumber(value);
                    }},
                    {field:'c_date',title:'Create Date',width:150,halign:'center',align:'center',sortable:true},
                    {field:'m_date',title:'Modified Date',width:150,halign:'center',align:'center',sortable:true}
                ]]
            });