torsten@31: var queries = new Array('query1', 'query2'); torsten@246: torsten@294: /** torsten@294: * Controller for the Search torsten@294: * This controller handles all logic related to the search torsten@294: */ torsten@6: Ext.define('Lada.controller.Sql', { torsten@6: extend: 'Ext.app.Controller', torsten@8: stores: [ torsten@235: 'Proben', // List of found Proben torsten@374: 'ProbenList', // List of found Proben torsten@386: 'Queries', rrenkert@422: 'Info' torsten@8: ], torsten@369: requires: [ torsten@369: 'Lada.view.widgets.Mst', torsten@369: 'Lada.view.widgets.Uwb', torsten@386: 'Lada.view.widgets.Datetime', torsten@386: 'Lada.view.About' torsten@369: ], 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@386: }, torsten@386: '#AboutBtn': { torsten@386: // Map click event on Button. torsten@386: click: this.about torsten@6: } torsten@6: }); torsten@6: }, torsten@6: onPanelRendered: function() { torsten@6: console.log('The panel was rendered'); torsten@6: }, torsten@294: /** torsten@294: * Function called when the user selects a SQL query in the dropdownlist. torsten@294: * The function will hide/display additional element related to the torsten@294: * selected search query torsten@294: */ 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@413: displayFields.reverse(); torsten@241: result.setupColumns(displayFields); torsten@246: torsten@369: // Setup Filters of the probenlist torsten@369: // torsten@369: // Allowed types are torsten@369: // * text torsten@369: // * number torsten@369: // * datetime torsten@375: // * bool torsten@369: // * listmst torsten@369: // * listumw torsten@375: // * listver torsten@375: // * listdbasis torsten@375: // * listnetz torsten@369: // torsten@369: // Iterate over all configured filters and add filters dynamically torsten@369: // torsten@369: // 1. Empty filters torsten@369: filters.removeAll(); torsten@369: var hide = true; torsten@369: // 2. Iterate over all configured filters torsten@369: for (var j=0; j < filterFields.length; j++) { torsten@369: var type = filterFields[j].type; torsten@369: var name = filterFields[j].dataIndex; torsten@369: var label = filterFields[j].label; torsten@369: var field = null; torsten@369: if (type == "text") { torsten@369: console.log("Found text filter"); torsten@369: field = Ext.create('Ext.form.field.Text', { name: name, fieldLabel: label }); torsten@369: } else if (type == "number") { torsten@369: console.log("Found number filter"); torsten@369: field = Ext.create('Ext.form.field.Number', { name: name, fieldLabel: label }); torsten@369: } else if (type == "datetime") { torsten@369: console.log("Found datetime filter"); torsten@369: field = Ext.create('Lada.view.widgets.Datetime', { name: name, fieldLabel: label }); torsten@375: } else if (type == "bool") { torsten@375: console.log("Found bool filter"); torsten@375: field = Ext.create('Lada.view.widgets.Testdatensatz', { name: name, fieldLabel: label, emptyText: '' }); torsten@369: } else if (type == "listmst") { torsten@369: console.log("Found listmst filter"); rrenkert@403: field = Ext.create('Lada.view.widgets.Mst', { name: name, fieldLabel: label }); torsten@369: } else if (type == "listumw") { torsten@369: console.log("Found listumw filter"); rrenkert@403: field = Ext.create('Lada.view.widgets.Uwb', { name: name, fieldLabel: label }); torsten@375: } else if (type == "listdbasis") { torsten@375: console.log("Found listdbasis filter"); rrenkert@403: field = Ext.create('Lada.view.widgets.Datenbasis', { name: name, fieldLabel: label }); torsten@375: } else if (type == "listver") { torsten@375: console.log("Found listver filter"); rrenkert@403: field = Ext.create('Lada.view.widgets.Verwaltungseinheit', { name: name, fieldLabel: label }); torsten@375: } else if (type == "listnetz") { torsten@375: console.log("Found listnetz filter"); rrenkert@403: field = Ext.create('Lada.view.widgets.Netzbetreiber', { name: name, fieldLabel: label }); torsten@366: } torsten@369: if (field) { torsten@369: console.log("Pushing field to filters"); torsten@369: filters.add(field); torsten@369: filters.show(); torsten@369: hide = false; torsten@369: } torsten@369: } torsten@369: if (hide) { torsten@246: filters.hide(); torsten@369: } torsten@31: buttons.show(); torsten@31: }, torsten@294: /** torsten@294: * Function is called when the user clicks the search button. The function torsten@294: * will perform a search to the server on refreshes the result list. torsten@294: */ torsten@31: search: function(element, record, index) { torsten@31: var result = Ext.getCmp('result'); torsten@369: var filters = Ext.getCmp('queryfilters'); torsten@369: var search = Ext.getCmp('search'); torsten@36: torsten@36: // Get search parameters: torsten@36: var searchParams = {}; torsten@369: searchParams['qid'] = search.getValue(); torsten@369: for (var i = filters.items.length - 1; i >= 0; i--){ torsten@369: var filter = filters.items.items[i]; torsten@369: var value = filter.getValue(); torsten@378: if (value instanceof Array) { torsten@378: value = value.join(","); torsten@378: } torsten@378: searchParams[filter.getName()] = value; torsten@36: } torsten@369: console.log('Loading store with the following search params: ' + searchParams); 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@386: }, torsten@386: about: function(element, record, index) { torsten@386: var info = this.getInfoStore(); torsten@386: var view = Ext.widget('about', {info: info}); torsten@6: } torsten@6: });