noerone
Newbie
Posts: 13
|
|
« on: November 16, 2015, 09:11:16 AM » |
|
i don't know where my fault from merge cell on datagrid. can you help me. $('#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 : $('#tbl-kartu-stok').datagrid('mergeCells', { index: 1, field: 'nm_item', colspan: 2, type: 'footer' }); output :
|
|
|
Logged
|
|
|
|
noerone
Newbie
Posts: 13
|
|
« Reply #3 on: November 16, 2015, 07:52:23 PM » |
|
I have 2 types of data output : 1.Data footer does not appear {"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 {"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 ??
|
|
|
Logged
|
|
|
|
dilma12
|
|
« Reply #5 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} ]] });
|
|
|
Logged
|
|
|
|