Html Grid
Invoke the renderaggregates method of the jqxGrid.
Author: http://jqwidgets.com
HTML
<script src="https://jqwidgets.com/public/jqwidgets/jqx-all.js"></script>
<link rel="stylesheet" href="https://jqwidgets.com/public/jqwidgets/styles/jqx.base.css">
<link rel="stylesheet" href="https://jqwidgets.com/public/jqwidgets/styles/jqx.energyblue.css">
<script src="https://jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/generatedata.js"></script>
<div id='jqxWidget'>
<div id="grid"></div>
</div>
JavaScript
$(document).ready(function () {
// prepare the data
var data = generatedata(200);
var source =
{
localdata: data,
datatype: "array",
updaterow: function (rowid, rowdata, commit) {
// synchronize with the server - send update command
commit(true);
},
datafields:
[
{ name: 'firstname', type: 'string' },
{ name: 'lastname', type: 'string' },
{ name: 'productname', type: 'string' },
{ name: 'available', type: 'bool' },
{ name: 'quantity', type: 'number' },
{ name: 'price', type: 'number' }
]
};
var dataAdapter = new $.jqx.dataAdapter(source);
// initialize jqxGrid
$("#grid").jqxGrid(
{
width: 600,
source: dataAdapter,
showstatusbar: true,
statusbarheight: 50,
editable: true,
sortable: true,
filterable: true,
showaggregates: true,
selectionmode: 'checkbox',
altrows: true,
columns: [
{
text: 'First Name', columntype: 'textbox', datafield: 'firstname', width: 100,
},
{
text: 'Last Name', datafield: 'lastname', columntype: 'textbox', width: 100,
},
{
text: 'Product', datafield: 'productname', width: 170,
},
{
text: 'Quantity', datafield: 'quantity', width: 85, cellsalign: 'right', cellsformat: 'n2', aggregates: ['min', 'max'],
},
{
...