Extjs grid 合计
1、直接在客户端统计,动态的修改Grid
?
2、代码如下
buttons: [{text: '查询',handler: function() {var a = Ext.getCmp('wholesale-query-form').form.getValues();var s = Ext.StoreMgr.lookup('wholesaleReportStore');s.load({params:a,callback:function(r,options,success){ if(!success){alert("数据加载失败!");}else{//合计行var sumc = 0; //数量合计var sumw = 0; //重量合计var suma = 0; //总金额合计var avgp = 0; //平均价合计var wgrid = Ext.getCmp("wholesale-report-grid")wgrid.store.each(function(record){ sumc += Number(record.data.scount);sumw += Number(record.data.sweight);suma += Number(record.data.samount); });avgp = (suma/sumw).toFixed(2);var n = wgrid.getStore().getCount();// 获得总行数 var p = new Ext.data.Record({salerName: '总计:', scount:sumc,sweight:sumw,samount:suma,aprice:avgp }); wgrid.store.insert(n, p);// 插入到最后一行 }}});}}]
?