torsten@472: /* Copyright (C) 2013 by Bundesamt fuer Strahlenschutz
torsten@472:  * Software engineering by Intevation GmbH
torsten@472:  *
torsten@472:  * This file is Free Software under the GNU GPL (v>=3)
torsten@472:  * and comes with ABSOLUTELY NO WARRANTY! Check out
raimund@500:  * the documentation coming with IMIS-Labordaten-Application for details.
torsten@472:  */
torsten@472: 
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',
raimund@491: 
raimund@491:     requires: [
raimund@491:         'Lada.view.widgets.Mst',
raimund@491:         'Lada.view.widgets.Uwb',
raimund@491:         'Lada.view.widgets.Datetime',
raimund@491:         'Lada.view.About'
raimund@491:     ],
raimund@491: 
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:     ],
raimund@491: 
torsten@6:     init: function() {
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 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:         });
raimund@491:         this.callParent(arguments);
torsten@6:     },
raimund@491: 
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:      */
raimund@500:     selectSql: function(element, record) {
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
raimund@500:         var j;
raimund@500:         for (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;
rrenkert@418:             var multi = filterFields[j].multiSelect;
torsten@369:             var field = null;
raimund@500:             if (type === 'text') {
raimund@491:                 field = Ext.create('Ext.form.field.Text', {
raimund@491:                     name: name,
raimund@491:                     fieldLabel: label
raimund@491:                 });
raimund@491:             }
raimund@500:             else if (type === 'number') {
raimund@491:                 field = Ext.create('Ext.form.field.Number', {
raimund@491:                     name: name,
raimund@491:                     fieldLabel: label
raimund@491:                 });
raimund@491:             }
raimund@500:             else if (type === 'datetime') {
raimund@491:                 field = Ext.create('Lada.view.widgets.Datetime', {
raimund@491:                     name: name,
raimund@491:                     fieldLabel: label
raimund@491:                 });
raimund@491:             }
raimund@500:             else if (type === 'bool') {
raimund@491:                 field = Ext.create('Lada.view.widgets.Testdatensatz', {
raimund@491:                     name: name,
raimund@491:                     fieldLabel: label,
raimund@491:                     emptyText: ''
raimund@491:                 });
raimund@491:             }
raimund@500:             else if (type === 'listmst') {
raimund@491:                 field = Ext.create('Lada.view.widgets.Mst', {
raimund@491:                     name: name,
raimund@491:                     fieldLabel: label,
raimund@491:                     multiSelect: multi
raimund@491:                 });
raimund@491:             }
raimund@500:             else if (type === 'listumw') {
raimund@491:                 field = Ext.create('Lada.view.widgets.Uwb', {
raimund@491:                     name: name,
raimund@491:                     fieldLabel: label,
raimund@491:                     multiSelect: multi
raimund@491:                 });
raimund@491:             }
raimund@500:             else if (type === 'listdbasis') {
raimund@491:                 field = Ext.create('Lada.view.widgets.Datenbasis', {
raimund@491:                     name: name,
raimund@491:                     fieldLabel: label,
raimund@491:                     multiSelect: multi
raimund@491:                 });
raimund@491:             }
raimund@500:             else if (type === 'listver') {
raimund@491:                 field = Ext.create('Lada.view.widgets.Verwaltungseinheit', {
raimund@491:                     name: name,
raimund@491:                     fieldLabel: label,
raimund@491:                     multiSelect: multi
raimund@491:                 });
raimund@491:             }
raimund@500:             else if (type === 'listnetz') {
raimund@491:                 field = Ext.create('Lada.view.widgets.Netzbetreiber', {
raimund@491:                     name: name,
raimund@491:                     fieldLabel: label,
raimund@491:                     multiSelect: multi
raimund@491:                 });
torsten@366:             }
torsten@369:             if (field) {
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:     },
raimund@491: 
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:      */
raimund@500:     search: function() {
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();
raimund@491:         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) {
raimund@500:                 value = value.join(',');
torsten@378:             }
torsten@378:             searchParams[filter.getName()] = value;
torsten@36:         }
torsten@36:         result.getStore().load({
torsten@36:             params: searchParams
torsten@36:         });
torsten@25:         result.show();
torsten@31:     },
raimund@491: 
raimund@500:     reset: function() {
raimund@500:         // var buttons = Ext.getCmp('SearchBtnPanel');
raimund@500:         // var result = Ext.getCmp('result');
raimund@500:         // for (var i = 0; i < queries.length; ++i) {
raimund@500:         //     var toHide = Ext.getCmp(queries[i]);
raimund@500:         //     toHide.hide();
raimund@500:         // }
raimund@500:         // result.hide();
raimund@500:         // buttons.hide();
torsten@386:     },
raimund@491: 
raimund@500:     about: function() {
torsten@386:         var info = this.getInfoStore();
raimund@500:         Ext.widget('about', {
raimund@491:             info: info
raimund@491:         });
torsten@6:     }
torsten@6: });