X-Git-Url: http://git.ithinksw.org/extjs.git/blobdiff_plain/c930e9176a5a85509c5b0230e2bff5c22a591432..f562e4c6e5fac7bcb445985b99acbea4d706e6f0:/examples/grid-filtering/grid-filter-local.js diff --git a/examples/grid-filtering/grid-filter-local.js b/examples/grid-filtering/grid-filter-local.js new file mode 100644 index 00000000..5e67aaeb --- /dev/null +++ b/examples/grid-filtering/grid-filter-local.js @@ -0,0 +1,235 @@ +/* + +This file is part of Ext JS 4 + +Copyright (c) 2011 Sencha Inc + +Contact: http://www.sencha.com/contact + +GNU General Public License Usage +This file may be used under the terms of the GNU General Public License version 3.0 as published by the Free Software Foundation and appearing in the file LICENSE included in the packaging of this file. Please review the following information to ensure the GNU General Public License version 3.0 requirements will be met: http://www.gnu.org/copyleft/gpl.html. + +If you are unsure which license is appropriate for your use, please contact the sales department at http://www.sencha.com/contact. + +*/ +Ext.Loader.setConfig({enabled: true}); +Ext.Loader.setPath('Ext.ux', '../ux'); +Ext.require([ + 'Ext.grid.*', + 'Ext.data.*', + 'Ext.ux.grid.FiltersFeature', + 'Ext.toolbar.Paging' +]); + +Ext.define('Product', { + extend: 'Ext.data.Model', + fields: [{ + name: 'id', + type: 'int' + }, { + name: 'company' + }, { + name: 'price', + type: 'float' + }, { + name: 'date', + type: 'date', + dateFormat: 'Y-m-d' + }, { + name: 'visible', + type: 'boolean' + }, { + name: 'size' + }] +}); + +Ext.onReady(function(){ + + Ext.QuickTips.init(); + + // for this demo configure local and remote urls for demo purposes + var url = { + local: 'grid-filter.json', // static data file + remote: 'grid-filter.php' + }; + + // configure whether filter query is encoded or not (initially) + var encode = false; + + // configure whether filtering is performed locally or remotely (initially) + var local = true; + + var store = Ext.create('Ext.data.JsonStore', { + // store configs + autoDestroy: true, + model: 'Product', + proxy: { + type: 'ajax', + url: (local ? url.local : url.remote), + reader: { + type: 'json', + root: 'data', + idProperty: 'id', + totalProperty: 'total' + } + }, + remoteSort: false, + sorters: [{ + property: 'company', + direction: 'ASC' + }], + pageSize: 50 + }); + + var filters = { + ftype: 'filters', + // encode and local configuration options defined previously for easier reuse + encode: encode, // json encode the filter query + local: local, // defaults to false (remote filtering) + + // Filters are most naturally placed in the column definition, but can also be + // added here. + filters: [ + { + type: 'boolean', + dataIndex: 'visible' + } + ] + }; + + // use a factory method to reduce code while demonstrating + // that the GridFilter plugin may be configured with or without + // the filter types (the filters may be specified on the column model + var createColumns = function (finish, start) { + + var columns = [{ + dataIndex: 'id', + text: 'Id', + // instead of specifying filter config just specify filterable=true + // to use store's field's type property (if type property not + // explicitly specified in store config it will be 'auto' which + // GridFilters will assume to be 'StringFilter' + filterable: true, + width: 30 + //,filter: {type: 'numeric'} + }, { + dataIndex: 'company', + text: 'Company', + id: 'company', + flex: 1, + filter: { + type: 'string' + // specify disabled to disable the filter menu + //, disabled: true + } + }, { + dataIndex: 'price', + text: 'Price', + filter: { + //type: 'numeric' // specify type here or in store fields config + }, + width: 70 + }, { + dataIndex: 'size', + text: 'Size', + filter: { + type: 'list', + options: ['small', 'medium', 'large', 'extra large'] + //,phpMode: true + } + }, { + dataIndex: 'date', + text: 'Date', + filter: true, + renderer: Ext.util.Format.dateRenderer('m/d/Y') + }, { + dataIndex: 'visible', + text: 'Visible' + // this column's filter is defined in the filters feature config + }]; + + return columns.slice(start || 0, finish); + }; + + var grid = Ext.create('Ext.grid.Panel', { + border: false, + store: store, + columns: createColumns(4), + loadMask: true, + features: [filters], + dockedItems: [Ext.create('Ext.toolbar.Paging', { + dock: 'bottom', + store: store + })] + }); + + // add some buttons to bottom toolbar just for demonstration purposes + grid.child('pagingtoolbar').add([ + '->', + { + text: 'Encode: ' + (encode ? 'On' : 'Off'), + tooltip: 'Toggle Filter encoding on/off', + enableToggle: true, + handler: function (button, state) { + var encode = (grid.filters.encode !== true); + var text = 'Encode: ' + (encode ? 'On' : 'Off'); + grid.filters.encode = encode; + grid.filters.reload(); + button.setText(text); + } + }, + { + text: 'Local Filtering: ' + (local ? 'On' : 'Off'), + tooltip: 'Toggle Filtering between remote/local', + enableToggle: true, + handler: function (button, state) { + var local = (grid.filters.local !== true), + text = 'Local Filtering: ' + (local ? 'On' : 'Off'), + newUrl = local ? url.local : url.remote, + store = grid.view.getStore(); + + // update the GridFilter setting + grid.filters.local = local; + // bind the store again so GridFilters is listening to appropriate store event + grid.filters.bindStore(store); + // update the url for the proxy + store.proxy.url = newUrl; + + button.setText(text); + store.load(); + } + }, + { + text: 'All Filter Data', + tooltip: 'Get Filter Data for Grid', + handler: function () { + var data = Ext.encode(grid.filters.getFilterData()); + Ext.Msg.alert('All Filter Data',data); + } + },{ + text: 'Clear Filter Data', + handler: function () { + grid.filters.clearFilters(); + } + },{ + text: 'Add Columns', + handler: function () { + if (grid.headerCt.items.length < 6) { + grid.headerCt.add(createColumns(6, 4)); + grid.view.refresh(); + this.disable(); + } + } + } + ]); + + var win = Ext.create('Ext.Window', { + title: 'Grid Filters Example', + height: 400, + width: 700, + layout: 'fit', + items: grid + }).show(); + + store.load(); +});