Wijmo 5 - FlexGrid and FlexChart

by Manish Gupta

HTML

<link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
<link rel="stylesheet" href="http://cdn.wijmo.com/5.latest/styles/wijmo.min.css">
<script src="http://cdn.wijmo.com/5.latest/controls/wijmo.min.js"></script>
<script src="http://cdn.wijmo.com/5.latest/controls/wijmo.grid.min.js"></script>
<script src="http://cdn.wijmo.com/5.latest/controls/wijmo.chart.min.js"></script>
<h1>Hello Wijmo 5!</h1>

<p>This is a <b>FlexGrid</b> control:</p>
<div id="theGrid"></div>

CSS

.wj-flexgrid {
  margin: 12px;
}
.wj-flexchart {
  height: 300px;
  margin: 12px;
}
body {
  margin-bottom: 24pt;
}
.wj-colfooters .wj-cell{
  background-color:lightgreen !important;
}
body b{
  color:red;
}

JavaScript

onload = function() {
    // create some random data
    var countries = 'US,Germany,UK,Japan,Italy,Greece'.split(','),
        data = [];
    for (var i = 0; i < countries.length; i++) {
        data.push({
            country: countries[i],
            downloads: Math.round(Math.random() * 20000),
            sales: Math.random() * 10000,
            expenses: Math.random() * 5000,
        });
    }
		// random Total count
  data.push({salesCount:100025.2,expensesCount:120235.25,downloadsCount:132556.25});
    // create CollectionView on the data (so grid and chart stay in sync)
    var view = new wijmo.collections.CollectionView(data);

    // initialize the grid
    var grid = new wijmo.grid.FlexGrid('#theGrid', {
        columns: [
        	{ binding: 'country', header: 'Country' },
          { binding: 'sales', header: 'Sales' },
          { binding: 'expenses', header: 'Expenses' },
          { binding: 'downloads', header: 'Downloads', format: 'n0' }
				],
        autoGenerateColumns: false,
        itemsSource: view,
        selectionMode: wijmo.grid.SelectionMode.Row
    });
    var rowCount=grid.rows.length-1,
    totalItem=grid.rows[rowCount].dataItem;
    grid.rows[rowCount].visible=false;
    grid.columnFooters.rows.push(new wijmo.grid.GroupRow());
    grid.columnFooters.setCellData(0,0,"SubTotal")
    grid.columnFooters.setCellData(0,1,totalItem.salesCount);
    grid.columnFooters.setCellData(0,2,totalItem.expensesCount);
    grid.columnFooters.setCellData(0,3,totalItem.downloadsCount);
   
}