欢迎大家来到IT世界,在知识的湖畔探索吧!
点击“了解更多”获取工具
Kendo UI是带有jQuery、Angular、React和Vue库的JavaScript UI组件的最终集合,无论选择哪种JavaScript框架,都可以快速构建高性能响应式Web应用程序。通过可自定义的UI组件,Kendo UI可以创建数据丰富的桌面、平板和移动Web应用程序。通过响应式的布局、强大的数据绑定、跨浏览器兼容性和即时使用的主题,Kendo UI将开发时间加快了50%。
下面的示例演示如何将Kendo UI PivotGrid小部件与Kendo UI图表小部件集成。
<div id="example">
<div id="pivotgrid"></div>
<div id="chart"></div>
<script>
//function flatten the tree of tuples that datasource returns
function flattenTree(tuples) {
tuples = tuples.slice();
var result = [];
var tuple = tuples.shift();
var idx, length, spliceIndex, children, member;
while (tuple) {
//required for multiple measures
if(tuple.dataIndex !== undefined) {
result.push(tuple);
}
spliceIndex = 0;
for (idx = 0, length = tuple.members.length; idx < length; idx++) {
member = tuple.members[idx];
children = member.children;
if (member.measure) {
[].splice.apply(tuples, [0, 0].concat(expandMeasures(children, tuple)));
} else {
[].splice.apply(tuples, [spliceIndex, 0].concat(children));
}
spliceIndex += children.length;
}
tuple = tuples.shift();
}
return result;
}
function clone(tuple, dataIndex) {
var members = tuple.members.slice();
return {
dataIndex: dataIndex,
members: $.map(members, function(m) {
return $.extend({}, m, { children: [] });
})
};
}
function replaceLastMember(tuple, member) {
tuple.members[tuple.members.length - 1] = member;
return tuple;
};
function expandMeasures(measures, tuple) {
return $.map(measures, function(measure) {
return replaceLastMember(clone(tuple, measure.dataIndex), measure);
});
}
//Check whether the tuple has been collapsed
function isCollapsed(tuple, collapsed) {
var members = tuple.members;
for (var idx = 0, length = collapsed.length; idx < length; idx++) {
var collapsedPath = collapsed[idx];
if (indexOfPath(fullPath(members, collapsedPath.length -1), [collapsedPath]) !== -1) {
return true;
}
}
return false;
}
//Work with tuple names/captions
function indexOfPath(path, paths) {
var path = path.join(",");
for (var idx = 0; idx < paths.length; idx++) {
if (paths[idx].join(",") === path) {
return idx;
}
}
return -1;
}
function fullPath(members, idx) {
var path = [];
var parentName = members[idx].parentName;
idx -= 1;
while (idx > -1) {
path.push(members[idx].name);
idx -= 1;
}
path.push(parentName);
return path;
}
function memberCaption(member) { return member.caption };
function extractCaption(members) {
return $.map(members, memberCaption).join(" ");
};
function fullPathCaptionName(members, dLength, idx) {
var result = extractCaption(members.slice(0, idx + 1));
var measureName = extractCaption(members.slice(dLength, members.mLength));
if (measureName) {
result += " - " + measureName;
}
return result;
}
//the main function that convert PivotDataSource data into understandable for the Chart widget format
function convertData(dataSource, collapsed) {
var columnDimensionsLength = dataSource.columns().length;
var rowDimensionsLength = dataSource.rows().length;
var columnTuples = flattenTree(dataSource.axes().columns.tuples || [], collapsed.columns);
var rowTuples = flattenTree(dataSource.axes().rows.tuples || [], collapsed.rows);
var data = dataSource.data();
var rowTuple, columnTuple;
var idx = 0;
var result = [];
var columnsLength = columnTuples.length;
for (var i = 0; i < rowTuples.length; i++) {
rowTuple = rowTuples[i];
if (!isCollapsed(rowTuple, collapsed.rows)) {
for (var j = 0; j < columnsLength; j++) {
columnTuple = columnTuples[j];
if (!isCollapsed(columnTuple, collapsed.columns)) {
if (idx > columnsLength && idx % columnsLength !== 0) {
for (var ri = 0; ri < rowTuple.members.length; ri++) {
for (var ci = 0; ci < columnTuple.members.length; ci++) {
//do not add root tuple members, e.g. [CY 2005, All Employees]
//Add only children
if (!columnTuple.members[ci].parentName || !rowTuple.members[ri].parentName) {
continue;
}
result.push({
measure: Number(data[idx].value),
column: fullPathCaptionName(columnTuple.members, columnDimensionsLength, ci),
row: fullPathCaptionName(rowTuple.members, rowDimensionsLength, ri)
});
}
}
}
}
idx += 1;
}
}
}
return result;
}
</script>
<script>
$(document).ready(function () {
var collapsed = {
columns: [],
rows: []
};
var pivotgrid = $("#pivotgrid").kendoPivotGrid({
filterable: true,
//gather the collapsed members
collapseMember: function(e) {
var axis = collapsed[e.axis];
var path = e.path;
if (indexOfPath(path, axis) === -1) {
axis.push(path);
}
},
//gather the expanded members
expandMember: function(e) {
var axis = collapsed[e.axis];
var index = indexOfPath(e.path, axis);
if (index !== -1) {
axis.splice(index, 1);
}
},
columnWidth: 100,
height: 330,
dataSource: {
type: "xmla",
columns: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Employee].[Gender]" }],
rows: [{ name: "[Product].[Category]", expand: true }],
measures: ["[Measures].[Reseller Freight Cost]", "[Measures].[Internet Order Quantity]"],
transport: {
connection: {
catalog: "Adventure Works DW 2008R2",
cube: "Adventure Works"
},
read: "https://demos.telerik.com/olap/msmdpump.dll"
},
schema: {
type: "xmla"
},
error: function (e) {
alert("error: " + kendo.stringify(e.errors[0]));
}
},
dataBound: function() {
//create/bind the chart widget
initChart(convertData(this.dataSource, collapsed));
}
}).data("kendoPivotGrid");
function initChart(data) {
var chart = $("#chart").data("kendoChart");
if (!chart) {
$("#chart").kendoChart({
dataSource: {
data: data,
group: "row"
},
series: [{
type: "column",
field: "measure",
name: "#= group.value # (category)",
categoryField: "column"
}],
legend: {
position: "bottom"
},
categoryAxis: {
labels: {
rotation: 310
}
},
valueAxis: {
labels: {
format: "${0}"
}
},
dataBound: function(e) {
var categoryAxis = e.sender.options.categoryAxis;
if (categoryAxis && categoryAxis.categories) {
categoryAxis.categories.sort();
}
}
});
} else {
chart.dataSource.data(data);
}
}
});
</script>
</div>
欢迎大家来到IT世界,在知识的湖畔探索吧!
了解最新Kendo UI最新资讯,请关注Telerik中文网!
免责声明:本站所有文章内容,图片,视频等均是来源于用户投稿和互联网及文摘转载整编而成,不代表本站观点,不承担相关法律责任。其著作权各归其原作者或其出版社所有。如发现本站有涉嫌抄袭侵权/违法违规的内容,侵犯到您的权益,请在线联系站长,一经查实,本站将立刻删除。 本文来自网络,若有侵权,请联系删除,如若转载,请注明出处:https://itzsg.com/35631.html