torsten@31: var queries = new Array('query1', 'query2');
torsten@246: 
torsten@6: Ext.define('Lada.controller.Sql', {
torsten@6:     extend: 'Ext.app.Controller',
torsten@8:     stores: [
torsten@235:         'Proben',    // List of found Proben
torsten@235:         'Queries'
torsten@8:     ],
torsten@6:     init: function() {
torsten@6:         console.log('Initialising the Sql controller');
torsten@6:         this.control({
torsten@6:             // CSS like selector to select element in the viewport. See
torsten@6:             // ComponentQuery documentation for more details.
torsten@31:             '#search': {
torsten@6:                 // Map the "render" event to the given function.
torsten@6:                 render: this.onPanelRendered,
torsten@6:                 // Map Doubleclick on rows of the probenlist.
torsten@28:                 select: this.selectSql
torsten@31:             },
torsten@31:             '#SearchBtn': {
torsten@31:                 // Map click event on Button.
torsten@31:                 click: this.search
torsten@31:             },
torsten@31:             '#ResetBtn': {
torsten@31:                 // Map click event on Button.
torsten@31:                 click: this.reset
torsten@6:             }
torsten@6:         });
torsten@6:     },
torsten@6:     onPanelRendered: function() {
torsten@6:         console.log('The panel was rendered');
torsten@6:     },
torsten@28:     selectSql: function(element, record, index) {
torsten@241:         var result = Ext.getCmp('result');
torsten@246:         var filters = Ext.getCmp('queryfilters');
torsten@252:         var sqlquery = Ext.getCmp('sqlquery');
torsten@252:         var sqldesc = Ext.getCmp('sqldesc');
torsten@31:         var buttons = Ext.getCmp('SearchBtnPanel');
torsten@253:         var displayFields = record[0].data.results;
torsten@246:         var filterFields = record[0].data.filters;
torsten@253: 
torsten@31:         this.reset();
torsten@246: 
torsten@252:         sqlquery.setValue(record[0].data.sql);
torsten@252:         sqldesc.setValue(record[0].data.description);
torsten@252: 
torsten@246:         // Setup Columns of the probenlist
torsten@241:         result.setupColumns(displayFields);
torsten@246: 
torsten@246:         // Setup Columns of the probenlist
torsten@246:         if (filterFields.length > 0) {
torsten@246:             var items = filters.items.items;
torsten@246:             for (var i=0; i < items.length; i++) {
torsten@246:                 var filtername = items[i].id;
torsten@246:                 items[i].hide();
torsten@246:                 for (var j=0; j < filterFields.length; j++) {
torsten@246:                     if ('filter-'+filterFields[j] === filtername) {
torsten@246:                         items[i].show();
torsten@246:                     };
torsten@246:                 };
torsten@246: 
torsten@246:             };
torsten@246:             filters.show();
torsten@246:         } else {
torsten@246:             filters.hide();
torsten@246:         };
torsten@31:         buttons.show();
torsten@31:     },
torsten@31:     search: function(element, record, index) {
torsten@31:         var result = Ext.getCmp('result');
torsten@28:         console.log('Loading store');
torsten@36: 
torsten@36:         // Get search parameters:
torsten@36:         var searchParams = {};
torsten@36:         if (Ext.getCmp('search').getValue() == 1) {
torsten@251:             var mst = Ext.getCmp('filter-mstId').getValue();
torsten@251:             var uwb = Ext.getCmp('filter-umwId').getValue();
torsten@96:             if (mst !== null) {
torsten@139:                 searchParams['mstId'] = mst;
torsten@96:             }
torsten@96:             if (uwb !== null) {
torsten@139:                 searchParams['umwId'] = uwb;
torsten@96:             }
torsten@36:         } else {
torsten@36:             // Get date object an convert it into a timestamp (ms since epoch)
torsten@251:             var datefield = Ext.getCmp('filter-pbegin').getValue();
torsten@97:             if (datefield !== null) {
torsten@251:                 var ts = Ext.getCmp('filter-pbegin').getValue().getTime();
torsten@96:                 searchParams['begin'] = ts;
torsten@96:             }
torsten@36:         }
torsten@36:         result.getStore().load({
torsten@36:             params: searchParams
torsten@36:         });
torsten@28:         console.log('Store loaded');
torsten@25:         result.show();
torsten@31:     },
torsten@31:     reset: function(element, record, index) {
torsten@31:         var buttons = Ext.getCmp('SearchBtnPanel');
torsten@31:         var result = Ext.getCmp('result');
torsten@246:         //for (var i = 0; i < queries.length; ++i) {
torsten@246:         //    var toHide = Ext.getCmp(queries[i]);
torsten@246:         //    toHide.hide();
torsten@246:         //}
torsten@147:         //result.hide();
torsten@147:         //buttons.hide();
torsten@6:     }
torsten@6: });