<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<base href="http://demos.telerik.com/kendo-ui/grid/editing">
<style>
html {
font-size: 14px;
font-family: Arial, Helvetica, sans-serif;
}
</style>
<title></title>
<link rel="stylesheet" href="https://kendo.cdn.telerik.com/2017.3.913/styles/kendo.common-material.min.css" />
<link rel="stylesheet" href="https://kendo.cdn.telerik.com/2017.3.913/styles/kendo.material.min.css" />
<link rel="stylesheet" href="https://kendo.cdn.telerik.com/2017.3.913/styles/kendo.material.mobile.min.css" />
<script src="https://kendo.cdn.telerik.com/2017.3.913/js/jquery.min.js"></script>
<script src="https://kendo.cdn.telerik.com/2017.3.913/js/kendo.all.min.js"></script>
</head>
<body>
<div id="grid"></div>
<script>
$(document).ready(function () {
var crudServiceBaseUrl = "https://demos.telerik.com/kendo-ui/service",
dataSource = new kendo.data.DataSource({
transport: {
read: {
url: crudServiceBaseUrl + "/Products",
dataType: "jsonp"
},
update: {
url: crudServiceBaseUrl + "/Products/Update",
dataType: "jsonp"
},
destroy: {
url: crudServiceBaseUrl + "/Products/Destroy",
dataType: "jsonp"
},
create: {
url: crudServiceBaseUrl + "/Products/Create",
dataType: "jsonp"
},
parameterMap: function (options, operation) {
if (operation !== "read" && options.models) {
return { models: kendo.stringify(options.models) };
}
}
},
batch: true,
pageSize: 5,
aggregate: [
{ field: "UnitPrice", aggregate: "sum" },
{ field: "UnitsInStock", aggregate: "sum" },
],
schema: {
model: {
id: "ProductID",
fields: {
ProductID: { editable: false, nullable: true },
ProductName: { validation: { required: true } },
UnitPrice: { type: "number", validation: { required: true, min: 1 } },
Discontinued: { type: "boolean" },
UnitsInStock: { type: "number", validation: { min: 0, required: true } }
}
}
}
});
$("#grid").kendoGrid({
dataSource: dataSource,
navigatable: true,
pageable: false,
// height: 550,
toolbar: ["create", "save", "cancel"],
columns: [
{ field: 'ProductName', title: 'ProductName', footerTemplate: 'Total', attributes: { style: 'text-align:center;' }, footerAttributes: { style: 'color: red;text-align:center;' } },
{ field: 'UnitPrice', title: 'UnitPrice', footerTemplate: '#: data.UnitPrice ? data.UnitPrice.sum: 0 #', attributes: { style: 'text-align:center;' }, footerAttributes: { style: 'color: red;text-align:center;' }, headerAttributes: { style: 'text-align:center;' } },
{ field: 'UnitsInStock', title: 'UnitsInStock', footerTemplate: '#: data.UnitsInStock ? data.UnitsInStock.sum: 0 #', attributes: { style: 'text-align:center;' }, footerAttributes: { style: 'color: red;text-align:center;' }, headerAttributes: { style: 'text-align:center;' } },
{ title: 'Total', template: '#= data.UnitPrice + data.UnitsInStock #', footerTemplate: '#: (data.UnitPrice ? data.UnitPrice.sum: 0) + (data.UnitsInStock ? data.UnitsInStock.sum: 0) #', attributes: { style: 'color: red;text-align:center;' }, footerAttributes: { style: 'color: red;text-align:center;' }, headerAttributes: { style: 'color: red;text-align:center;' } },
{ command: 'destroy', title: ' ', width: '150' },
],
editable: true
});
});
</script>
</div>
<!-- <div id="example">
<div id="grid"
data-role="grid"
data-bind="source:dataSource"
data-toolbar="['create', 'save', 'cancel']"
data-editable="true"
@*data-pageable="true"*@
@*data-toolbar="['create']"*@
@*data-editable="inline"*@
data-columns="[
{ field : 'ProductName', title: 'ProductName', footerTemplate: 'Total', attributes: { style: 'text-align:center;' }, footerAttributes: { style: 'color: red;text-align:center;' } },
{ field : 'UnitPrice', title: 'UnitPrice', footerTemplate: '#: data.UnitPrice ? data.UnitPrice.sum: 0 #', attributes: { style: 'text-align:center;' }, footerAttributes: { style: 'color: red;text-align:center;' }, headerAttributes: { style: 'text-align:center;' } },
{ field : 'UnitsInStock', title: 'UnitsInStock', footerTemplate: '#: data.UnitsInStock ? data.UnitsInStock.sum: 0 #', attributes: { style: 'text-align:center;' }, footerAttributes: { style: 'color: red;text-align:center;' }, headerAttributes: { style: 'text-align:center;' } },
{ title: 'Total', template: '#= data.UnitPrice + data.UnitsInStock #', footerTemplate: '#: (data.UnitPrice ? data.UnitPrice.sum: 0) + (data.UnitsInStock ? data.UnitsInStock.sum: 0) #', attributes: { style: 'color: red;text-align:center;' }, footerAttributes: { style: 'color: red;text-align:center;' }, headerAttributes: { style: 'color: red;text-align:center;' } },
{ command: 'destroy', title: ' ', width: '150' },
@*{ command: ['edit', 'destroy'], title: ' ' },*@
]">
</div> -->
</body>
</html>