<!-- 表格加统计 --> 

//需要使用GroupingStore，分组统计
    <body><script type="text/javascript"> 
            var look;//表格中按钮的函数声明（应放在Ext.onReady语句外）
            Ext.onReady(function(){    
            var reader = new Ext.data.JsonReader({ 
               fields: [ 
                        {name : 'id',mapping : 'id'},
                        {name : 'lv',mapping : 'lv',type:'int'},
                        {name : 'money',mapping : 'money'},
                        {name : 'needExp',mapping : 'needExp'},
                        {name : 'grade',mapping : 'grade'},
                        {name : 'friendCount',mapping : 'friendCount'},            
                        {name : 'friendLv',mapping : 'friendLv'},
                        {name : 'maxCommit',mapping : 'maxCommit'},
                        {name : 'maxHeroCount',mapping : 'maxHeroCount'},
                        {name: 'groupField',mapping : 'maxHeroCount',convert:function(v){  return '数据';}}
                ]
            }); 
            var storeUserLv =  new Ext.data.GroupingStore({
                proxy : new Ext.data.HttpProxy({url:'xml_grid_json.php?mode=userlv'}),
                reader: reader,
                    sortInfo:{field: 'id', direction: "id"},
                    groupField:'groupField'
                });
            var summary = new Ext.grid.GroupSummary(); 
            
            storeUserLv.load({params:{limit: 10}});

            //处理函数可在此处定义  
            look = function(){
                var sm = gridUserLv.getSelectionModel();
                var sel = sm.getSelected();
                alert(sel.get('id'));
              }

            var gridUserLv = new Ext.grid.EditorGridPanel({
                store: storeUserLv,
                columns:[{
                                header: "id",dataIndex: "id",width: 100,summaryRenderer: function(v, params, data){
                    return  '1月共计';}
                            }, {
                                header: "lv",dataIndex: "lv",width: 100,summaryType: 'sum'
                
                            }, {
                                header: "money",dataIndex: "money",width: 100
                            }, {
                                header: "needExp",dataIndex: "needExp",width: 100
                            }, {
                                header: "grade",dataIndex: "grade",width: 100
                            }, {
                                header: "friendCount",dataIndex: "friendCount",width: 100
                            }, {
                                header: "friendLv",dataIndex: "friendLv",width: 100
                            }, {
                                header: "maxCommit",dataIndex: "maxCommit",width: 100
                            }, {
                                header: "maxHeroCount",dataIndex: "maxHeroCount",editor:new Ext.form.TextField(),width: 100
                            },{ header: "数据", dataIndex: 'groupField' 
                            },{ header: "操作", dataIndex: 'Gender', 
                                renderer: function() {
                                var str = "<input type='button' value='查看' onclick='look()'>";
                                return str;
                            }
                    }],
                renderTo: Ext.getBody(),
                autoHeight: true,
                view: new Ext.grid.GroupingView({
                    showGroupName: false
                }),
                plugins : summary,
                selModel: new Ext.grid.RowSelectionModel({ singleSelect: true })
            });
         });    
</script> 
</body> 
</html>
posted @ 2011-12-08 14:03  无心花  阅读(154)  评论(0)    收藏  举报