import { Component } from '@angular/core';

@Component({
 selector: 'app-root',
 templateUrl: './app.component.html'
})

export class AppComponent { filterChanged: boolean = false; source: any = { dataType: 'json', dataFields: [ { name: 'ShipCountry', type: 'string' }, { name: 'ShipCity', type: 'string' }, { name: 'ShipAddress', type: 'string' }, { name: 'ShipName', type: 'string' }, { name: 'Freight', type: 'number' }, { name: 'ShippedDate', type: 'date' } ], root: 'value', url: 'http://services.odata.org/V3/Northwind/Northwind.svc/Orders?$format=json&$callback=?' }; getWidth() : any { if (document.body.offsetWidth < 850) { return '90%'; } return 850; } dataAdapter: any = new jqx.dataAdapter(this.source, { formatData: (data: any): void => { if (data.sortdatafield && data.sortorder) { // update the $orderby param of the OData service. // data.sortdatafield - the column's datafield value(ShipCountry, ShipCity, etc.). // data.sortorder - the sort order(asc or desc). data.$orderby = data.sortdatafield + ' ' + data.sortorder; } let filterOperator; if (data.filterslength) { this.filterChanged = true; let filterParam = ''; for (let i = 0; i < data.filterslength; i++) { // filter's value. let filterValue = data['filtervalue' + i]; // filter's condition. For the filterMode='simple' it is 'CONTAINS'. let filterCondition = data['filtercondition' + i]; // filter's data field - the filter column's datafield value. let filterDataField = data['filterdatafield' + i]; // 'and' or 'or' depending on the filter expressions. When the filterMode='simple', the value is 'or'. filterOperator = data[filterDataField + 'operator']; let startIndex = 0; if (filterValue.indexOf('-') == -1) { if (filterCondition == 'CONTAINS') { filterParam += 'substringof("' + filterValue + '", ' + filterDataField + ') eq true'; filterParam += ' ' + filterOperator + ' '; } } else { if (filterDataField == 'ShippedDate') { let dateGroups = new Array(); let startIndex = 0; let item = filterValue.substring(startIndex).indexOf('-'); while (item > -1) { dateGroups.push(filterValue.substring(startIndex, item + startIndex)); startIndex += item + 1; item = filterValue.substring(startIndex).indexOf('-'); if (item == -1) { dateGroups.push(filterValue.substring(startIndex)); } } if (dateGroups.length == 3) { filterParam += 'year(ShippedDate) eq ' + parseInt(dateGroups[0]) + ' and month(ShippedDate) eq ' + parseInt(dateGroups[1]) + ' and day(ShippedDate) eq ' + parseInt(dateGroups[2]); } filterParam += ' ' + filterOperator + ' '; } } } // remove last filter operator. filterParam = filterParam.substring(0, filterParam.length - filterOperator.length - 2); data.$filter = filterParam; this.source.totalRecords = 0; } else { if (this.filterChanged) { this.source.totalRecords = 0; this.filterChanged = false; } } if (this.source.totalRecords) { // update the $skip and $top params of the OData service. // data.pagenum - page number starting from 0. // data.pagesize - page size data.$skip = data.pagenum * data.pagesize; data.$top = data.pagesize; } return data; }, downloadComplete: (data, status, xhr) => { if (!this.source.totalRecords) { this.source.totalRecords = data.value.length; } }, loadError: (xhr, status, error) => { throw new Error('http://services.odata.org: ' + error.toString()); } } ); columns: any[] = [ { text: 'Ship Name', dataField: 'ShipName', width: 250 }, { text: 'Ship Country', dataField: 'ShipCountry', width: 150 }, { text: 'Ship City', dataField: 'ShipCity', width: 150 }, { text: 'Ship Address', dataField: 'ShipAddress', width: 150 }, { text: 'Ship Date', dataField: 'ShippedDate', width: 150, cellsFormat: 'yyyy-MM-dd' } ];
}