Forum


03:32

31/05/2010

Hi there,
I'm trying to get grouping working, however. If I change the grouping variable from true to false everything works as it should be.
When change it to true, I get only a "Loading…". Any thoughts here?
My code:
<table id='jqGrid__languages'></table>
<div id='jqGridPager__languages'></div>
<script type='text/javascript'>
$('#jqGrid__languages').jqGrid({
'url' : 'admin_en/tabledata/_languages',
'hidegrid' : false,
'mtype' : 'post',
'datatype' : 'json',
'height' : 'auto',
'colModel':[
{'name':'t.id', 'index':'t.id', 'label':'ID', 'edittype':'text', 'editable' : true},
{'name':'t.name', 'index':'t.name', 'label':'Name', 'edittype':'text', 'editable' : true},
{'name':'t.enabled', 'index':'t.enabled', 'label':'Enabled', 'edittype':'checkbox', 'format':'checkbox', 'editable' : true, 'editoptions':{'value':'1:0'}},
{'name':'t.collation', 'index':'t.collation', 'label':'Collation', 'edittype':'text', 'editable' : true},
{'name':'t.modified', 'index':'t.modified', 'label':'Modified', 'edittype':'text', 'editable' : true},
{'name':'t.created', 'index':'t.created', 'label':'Created', 'edittype':'text', 'editable' : true},
],
'caption' : 'Edit languages',
'rowNum' : 50,
'rownumbers' : true,
'rowList' :[50,100,200],
'pager' : '#jqGridPager__languages',
'sortname' : 't.id',
'viewrecords': true,
'gridview' : true,
'sortorder' : 'desc',
'sortable' : true,
'prmNames' : {
'id' : 'data[options][rowid]',
'page' : 'data[options][page]',
'rows' : 'data[options][rows]',
'sort' : 'data[options][sortindex]',
'order' : 'data[options][sortorder]',
'search' : 'data[options][search]',
'nd' : 'data[options][stamp]',
'oper' : 'data[options][oper]'
},
'ondblClickRow' : function(rowid) {
$('#jqGrid__languages').jqGrid('editGridRow', rowid, {reloadAfterSubmit:true, width:850, modal:true, mtype:'post', url:'admin_en/send/_languages', closeAfterEdit: true, closeOnEscape:true});
},
'grouping': false,
'groupingView' : {
'groupField' : ['name'],
'groupSummary': [true],
'groupColumnShow': [true],
'groupText: ['<b>{0}</b>'],
'groupCollapse: false',
'groupOrder': ['asc']
},
});
$('#jqGrid__languages').jqGrid('navGrid', '#jqGridPager__languages',
{view:true}, //options
{reloadAfterSubmit:false, width:850, modal:true, mtype:'post', url:'admin_en/send/_languages', closeAfterEdit: true, closeOnEscape:true}, // edit options
{reloadAfterSubmit:false, width:850, modal:true, mtype:'post', url:'admin_en/send/_languages', closeAfterAdd: true, closeOnEscape:true}, // add options
{reloadAfterSubmit:false, jqModal:true, closeOnEscape:true, mtype:'post', url:'admin_en/send/_languages/t.id/SINGLELAN'}, // del options
{closeOnEscape:true}, // search options
{height:250,jqModal:false,closeOnEscape:true} // view options
);
$('#jqGrid__languages').jqGrid('navButtonAdd','#jqGridPager__languages',{
caption: '',
title: 'Reorder Columns',
onClickButton : function (){
$('#jqGrid__languages').jqGrid('columnChooser');
}
});
$('#jqGrid__languages').jqGrid('filterToolbar');
</script>
The data sent is:
{"total":"1","page":"1","records":"4","rows":[
{"id":"1","cell":["hu","Magyar","1","utf8_hungarian_ci","2010-11-11 01:01:16","2010-11-11 01:01:16"]},
{"id":"2","cell":["en","English","1","utf8_general_ci","2010-11-11 01:01:17","2010-11-11 01:01:17"]}, {"id":"3","cell":["ab","Magyarb","0","utf8_hungarian_ci","2010-11-11 01:01:16","2010-11-11 01:01:16"]},
{"id":"4","cell":["aa","Magyara","0","utf8_hungarian_ci","2010-11-11 01:01:16","2010-11-11 01:01:16"]}
]
}
I tried my best to make the code readable. Hope it worked.
Most Users Ever Online: 715
Currently Online:
63 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66