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>