Title: Problem MergeCells on Footer Datagrid Post by: noerone on November 16, 2015, 09:11:16 AM i don't know where my fault from merge cell on datagrid. can you help me.
Code: $('#tbl-kartu-stok').datagrid({ this for mergecells : Code: $('#tbl-kartu-stok').datagrid('mergeCells', { output : (http://i.imgur.com/YLvCvMy.jpg) Title: Re: Problem MergeCells on Footer Datagrid Post by: jarry on November 16, 2015, 06:27:37 PM Please notice that the row index starts with 0. Try this code instead.
Code: $('#tbl-kartu-stok').datagrid('mergeCells', { Title: Re: Problem MergeCells on Footer Datagrid Post by: noerone on November 16, 2015, 06:44:27 PM Please notice that the row index starts with 0. Try this code instead. Code: $('#tbl-kartu-stok').datagrid('mergeCells', { I already tried it , but it does not change Title: Re: Problem MergeCells on Footer Datagrid Post by: noerone on November 16, 2015, 07:52:23 PM 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 ?? Title: Re: Problem MergeCells on Footer Datagrid Post by: jarry on November 16, 2015, 08:00:52 PM Please refer to http://jsfiddle.net/4upsen4e/. It works fine.
Title: Re: Problem MergeCells on Footer Datagrid Post by: dilma12 on October 06, 2016, 12:14:52 AM 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} ]] }); |