Wijmo 5 - Multi-column Filter

by Ross Dederer

HTML

<link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
<script src="http://code.jquery.com/jquery-2.1.0.min.js"></script>
<script src="http://cdn.wijmo.com/5.20142.0/controls/wijmo.min.js"></script>
<script src="http://cdn.wijmo.com/5.20142.0/controls/wijmo.input.min.js"></script>
<script src="http://cdn.wijmo.com/5.20142.0/controls/wijmo.grid.min.js"></script>
<script src="http://cdn.wijmo.com/5.20142.0/controls/wijmo.chart.min.js"></script>
<link rel="stylesheet" href="http://cdn.wijmo.com/5.20142.0/styles/wijmo.min.css">
<script src="http://cdn.wijmo.com/5.20142.0/interop/angular/wijmo.angular.js"></script>
<!-- mark this as an Angular application and give it a controller -->
<div ng-app="app" ng-controller="appCtrl">
    
<h1>Multi-column Filter</h1>

    <p>
        Filter: <input ng-model="filter"></p>
        
    <wj-flex-grid items-source="data" selection-mode="Row" style="height:200px">
    </wj-flex-grid>
</div>

JavaScript

// define app, include Wijmo 5 directives
var app = angular.module('app', ['wj']);

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

    // refresh collectionView when filter changes
    $scope.$watch('filter', function() {
        $scope.data.refresh();
    });
    function applyFilter(item) {
        if (!$scope.filter) return true;
        var filter = $scope.filter.toLowerCase();
        for (var k in item) {
            var val = item[k];
            if (wijmo.isString(val)) {
                if (val.toLowerCase().indexOf(filter) >= 0) {
                    return true;
                }
            }
        }
        return false;
    }
    
    // create some random data
    var countries = 'US,Germany,UK,Japan,Italy,Greece'.split(','),
        products = 'Phone,Bike,Car,Shirt,Tablet,Sandwich'.split(','),
        data = [];
    for (var i = 0; i < countries.length; i++) {
        data.push({
            country: countries[i],
            product: products[i % products.length],
            downloads: Math.round(Math.random() * 20000)
        });
    }

    // expose data as a CollectionView to get events
    $scope.data = new wijmo.collections.CollectionView(data);
    $scope.data.filter = applyFilter;
});