flexgrid折叠后汇总数字异常

登录

本帖最后由 oraclexp79 于 2018-11-5 15:05 编辑

this.reportGrid.collapseGroupsToLevel(0); //折叠
为什么我用以上js代码分组折叠后，对应的字段汇总数字是0呢?
另外再请问一下，groupPanel有封装如何获取groupPanel上的按钮焦点事件方法吗？

JeffryLI · JeffryLI

关于汇总，请参考这这段代码

onload = function () {
// generate some random data
var countries = 'US,Germany,UK,Japan,Italy,Greece'.split(','),
products = 'Phones,Computers,Cameras,Stereos'.split(','),
data = [];
for (var i = 0; i < 200; i++) {
data.push({
id: i,
country: countries[i % countries.length],
product: products[i % products.length],
sales: Math.random() * 10000,
expenses: Math.random() * 5000,
});
}
groupPanel上没有监听点击事件。
// create a group to show the grand totals
var grandTotalsGroup = new wijmo.collections.PropertyGroupDescription('Grand Total',
function(item, propName) {
return '';
}
);
// grid with custom aggregates
var theGrid = new wijmo.grid.FlexGrid('#theGrid', {
autoGenerateColumns: false,
columns: [ // column definitions with aggregates
{ binding: 'id', header: 'ID', width: 60, isReadOnly: true },
{ binding: 'country', header: 'Country' },
{ binding: 'product', header: 'Product' },
{ binding: 'sales', header: 'Sales', aggregate: 'Sum' },
{ binding: 'expenses', header: 'Expenses', aggregate: 'Sum' },
{ binding: 'profit', header: 'Profit', dataType: 'Number', isReadOnly: true }
],
itemsSource: new wijmo.collections.CollectionView(data, {
groupDescriptions: [
grandTotalsGroup,
'country'
]
})
});
// start collapsed
theGrid.collapseGroupsToLevel(1);
// custom cell calculation
theGrid.formatItem.addHandler(function(s, e) {
// cells and column footer panels only
if (e.panel == s.cells) {
// get row, column, and data item (or group description)
var r = s.rows[e.row];
var c = s.columns[e.col];
var item = s.rows[e.row].dataItem;
var group = r instanceof wijmo.grid.GroupRow ? item : null;
// assume value is not negative
var negative = false;
// calculate profit
if (c.binding == 'profit') {
var profit = group
? group.getAggregate('Sum', 'sales') - group.getAggregate('Sum', 'expenses')
: item.sales - item.expenses;
e.cell.textContent = wijmo.Globalize.format(profit, c.format);
negative = profit < 0;
}
// update 'negative' class on cell
wijmo.toggleClass(e.cell, 'negative', negative);
}
});
}

复制代码

		自动登录	找回密码
密码			立即注册

[已处理] flexgrid折叠后汇总数字异常

本帖子中包含更多资源

1 个回复

元老葡萄