jqGrid的分组功能(grouping)

  jqGrid是基于jquery的表格插件;优点是轻量级。

jqGrid分组

    再简单的分组就是开启jqgrid的分组功能:在colMolder中设置参数grouping:true以及groupingView:{groupField:"sex"}(按照性别分组)。

    往后还有其他的一些属性值:groupColumnShow : [true],groupText : ['<b>{0} - {1} Item(s)</b>'], groupSummary : [true]   ...  ...

    代码如下

<html >
 <head>
<title>jqGrid 实例</title> </head> <body> <table id="list48"></table> <div id="plist48"></div> </body> <script> $(function(){ pageInit(); }); function pageInit(){ var mydata = [ {id:"1",invdate:"2010-05-24",name:"test",note:"note",tax:"10.00",total:"2111.00"} , {id:"2",invdate:"2010-05-25",name:"test2",note:"note2",tax:"20.00",total:"320.00"}, {id:"3",invdate:"2007-09-01",name:"test3",note:"note3",tax:"30.00",total:"430.00"}, {id:"4",invdate:"2007-10-04",name:"test",note:"note",tax:"10.00",total:"210.00"}, {id:"5",invdate:"2007-10-05",name:"test2",note:"note2",tax:"20.00",total:"320.00"}, {id:"6",invdate:"2007-09-06",name:"test3",note:"note3",tax:"30.00",total:"430.00"}, {id:"7",invdate:"2007-10-04",name:"test",note:"note",tax:"10.00",total:"210.00"} ]; jQuery("#list48").jqGrid({ data: mydata, datatype: "local", height: 'auto', rowNum: 30, rowList: [10,20,30], colNames:['Inv No','Date', 'Client', 'Amount','Tax','Total','Notes'], colModel:[ {name:'id',index:'id', width:60, sorttype:"int"}, {name:'invdate',index:'invdate', width:90, sorttype:"date", formatter:"date"}, {name:'name',index:'name', width:100, editable:true}, {name:'amount',index:'amount', width:80, align:"right",sorttype:"float", formatter:"number", editable:true}, {name:'tax',index:'tax', width:80, align:"right",sorttype:"float", editable:true}, {name:'total',index:'total', width:80,align:"right",sorttype:"float"}, {name:'note',index:'note', width:150, sortable:false} ], pager: "#plist48", viewrecords: true, sortname: 'name', grouping:true, groupingView : { groupField : ['name'],
groupSummary : [true],//是否开启汇总页脚 groupColumnShow : [true],//是否展示分组列 groupText : ['<b>{0}</b>'],//组名的展示文字 groupCollapse : false, }, caption:
"Grouping Array Data" }); } </script> </html>

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/wpfwsp.html