应用程序数据管理新妙招！在维度标签中设置日期格式

Kendo UI for jQuery R1 2021 SP1试用版下载

Kendo UI是带有jQuery、Angular、React和Vue库的JavaScript UI组件的最终集合，无论选择哪种JavaScript框架，都可以快速构建高性能响应式Web应用程序。通过可自定义的UI组件，Kendo UI可以创建数据丰富的桌面、平板和移动Web应用程序。通过响应式的布局、强大的数据绑定、跨浏览器兼容性和即时使用的主题，Kendo UI将开发时间加快了50%。

通过PivotGrid，您可以控制尺寸标签呈现的内容格式。

通过在行或标题模板中实现自定义模板，可以实现此操作。

下面的示例演示如何在PivotGrid中格式化维度标签的日期值。

<script src="https://demos.telerik.com/kendo-ui/content/shared/js/products.js"></script>

<div id="example">
<div id="pivotgrid"></div>

<div class="responsive-message"></div>

<script id="rowTemplate" type="text/x-kendo-template">
# if (member.name.indexOf("LastSupply") === 0 && member.name !== "LastSupply") { #
#: kendo.toString(kendo.parseDate(member.caption), "d") #
# } else { #
#: member.caption #
# } #
</script>

<script>
$(document).ready(function () {
var d = new Date();
products.forEach(function(p) {
p.LastSupply = new Date(d);
d.setDate(d.getDate() + 1);
});

var pivotgrid = $("#pivotgrid").kendoPivotGrid({
columnWidth: 120,
height: 570,
rowHeaderTemplate: $("#rowTemplate").html(),
dataSource: {
data: products,
schema: {
model: {
fields: {
ProductName: { type: "string" },
UnitPrice: { type: "number" },
UnitsInStock: { type: "number" },
Discontinued: { type: "boolean" },
LastSupply: { type: "date" },
CategoryName: { field: "Category.CategoryName" }
}
},
cube: {
dimensions: {
ProductName: { caption: "All Products" },
CategoryName: { caption: "All Categories" },
Discontinued: { caption: "Discontinued" }
},
measures: {
"Sum": { field: "UnitPrice", format: "{0:c}", aggregate: "sum" },
"Average": { field: "UnitPrice", format: "{0:c}", aggregate: "average" }
}
}
},
columns: [{ name: "CategoryName", expand: true }, { name: "ProductName" } ],
rows: [{ name: "Discontinued", expand: true }, { name: "LastSupply", expand: false }],
measures: ["Sum"]
}
}).data("kendoPivotGrid");
});
</script>
</div>