Wijmo 5 - Sum Totals in Top Row + filter

Place

by Joel Parks

HTML

<link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdn.grapecity.com/wijmo/5.20183.568/styles/wijmo.min.css">
<script src="https://cdn.grapecity.com/wijmo/5.20183.568/controls/wijmo.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.20183.568/controls/wijmo.grid.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.20183.568/controls/wijmo.grid.filter.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.20183.568/controls/wijmo.input.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.20183.568/interop/angular/wijmo.angular.min.js"></script>
<!-- mark this as an Angular application and give it a controller -->
<div ng-app="app" ng-controller="appCtrl">
    <wj-flex-grid items-source="data" control="mainCMgrid" selection-mode="Row" item-formatter="itemFormatter" sorting-column="sortingColumn(s,e)">
        <wj-flex-grid-column header="Country" binding="country"></wj-flex-grid-column>
        <wj-flex-grid-column header="Sales" binding="sales"></wj-flex-grid-column>
        <wj-flex-grid-column header="Expenses" binding="expenses"></wj-flex-grid-column>
        <wj-flex-grid-column header="Downloads" binding="downloads"></wj-flex-grid-column>
    </wj-flex-grid>
</div>

JavaScript

// define app, include Wijmo 5 directives
var app = angular.module('app', ['wj']);
var colNames = {
    0: "country",
    1: "sales",
    2: "expenses",
    3: "downloads"
};


// controller
app.controller('appCtrl', function ($scope) {

    // 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
        });
    }

    // expose data as a CollectionView to get events
    $scope.data = new wijmo.collections.CollectionView(data);
    $scope.filterHTML = '<button class="wj-btn wj-btn-glyph wj-right wj-elem-filter" type="button" tabindex="-1" aria-label="Edit Filter for Column Country" aria-haspopup="dialog" aria-expanded="false" aria-pressed="false"><span class="wj-glyph-filter"></span></button>';

    $scope.sort = {
        col: null,
        dir: null
    };
    $scope.$watch('mainCMgrid', function () {
        var mainCMgrid = $scope.mainCMgrid;
        if (mainCMgrid) {
            mainCMgrid.columnHeaders.rows.push(new wijmo.grid.Row());
            mainCMgrid.columnHeaders.hostElement.children[0].childNodes[0] += $scope.filterHTML;
            //             mainCMgrid.columnHeaders.rows.insert(1, new wijmo.grid.Row());
            var p = mainCMgrid.columnHeaders;
						//console.log(p);
            for (var r = 0; r < p.rows.length; r++) {
                for (var c = 0; c < p.columns.length; c++) {
                    p.setCellData(r, c, colNames[c]);
                }
            }
            for (var r = 1; r < p.rows.length; r++) {
                for (var c = 0; c < p.columns.length; c++) {
                    //p.setCellData(r, c, 'row1 ' + r + ',col ' + c);
										p.setCellData(r, c, 'Hello');
										$scope.sumRow(mainCMgrid);
                }
...