lada/lada-client: app/controller/Sql.js annotate

annotate app/controller/Sql.js @ 162:5eb0cfac0e30

Added nested id attribute which comes in JSON response to the model as we need it later in the grid view to be able to acess messungsIs and probeId in the custom renderer.

author	Torsten Irländer <torsten.irlaender@intevation.de>
date	Wed, 03 Jul 2013 14:02:35 +0200
parents	5da0b56bf9bf
children	78134e20e62d

rev	line source
31 897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	1 var queries = new Array('query1', 'query2');
6 8e79bda4d55b Added a list to select predefined SQL Statement for the Proben list. Torsten Irländer <torsten.irlaender@intevation.de> parents: diff changeset	2 Ext.define('Lada.controller.Sql', {
8e79bda4d55b Added a list to select predefined SQL Statement for the Proben list. Torsten Irländer <torsten.irlaender@intevation.de> parents: diff changeset	3 extend: 'Ext.app.Controller',
8 e4fcb4ddd782 Moved stored SQL into its own file. Torsten Irländer <torsten.irlaender@intevation.de> parents: 6 diff changeset	4 stores: [
120 19eab475bbe5 Clean up part one. Reduced application to the search page. Moved some stores for comoboboxes right to the combobox Torsten Irländer <torsten.irlaender@intevation.de> parents: 97 diff changeset	5 'Proben' // List of found Proben
8 e4fcb4ddd782 Moved stored SQL into its own file. Torsten Irländer <torsten.irlaender@intevation.de> parents: 6 diff changeset	6 ],
6 8e79bda4d55b Added a list to select predefined SQL Statement for the Proben list. Torsten Irländer <torsten.irlaender@intevation.de> parents: diff changeset	7 init: function() {
8e79bda4d55b Added a list to select predefined SQL Statement for the Proben list. Torsten Irländer <torsten.irlaender@intevation.de> parents: diff changeset	8 console.log('Initialising the Sql controller');
8e79bda4d55b Added a list to select predefined SQL Statement for the Proben list. Torsten Irländer <torsten.irlaender@intevation.de> parents: diff changeset	9 this.control({
8e79bda4d55b Added a list to select predefined SQL Statement for the Proben list. Torsten Irländer <torsten.irlaender@intevation.de> parents: diff changeset	10 // CSS like selector to select element in the viewport. See
8e79bda4d55b Added a list to select predefined SQL Statement for the Proben list. Torsten Irländer <torsten.irlaender@intevation.de> parents: diff changeset	11 // ComponentQuery documentation for more details.
31 897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	12 '#search': {
6 8e79bda4d55b Added a list to select predefined SQL Statement for the Proben list. Torsten Irländer <torsten.irlaender@intevation.de> parents: diff changeset	13 // Map the "render" event to the given function.
8e79bda4d55b Added a list to select predefined SQL Statement for the Proben list. Torsten Irländer <torsten.irlaender@intevation.de> parents: diff changeset	14 render: this.onPanelRendered,
8e79bda4d55b Added a list to select predefined SQL Statement for the Proben list. Torsten Irländer <torsten.irlaender@intevation.de> parents: diff changeset	15 // Map Doubleclick on rows of the probenlist.
28 4d60b9ebce15 Renamed sql modul into search. Further display The query selection as Combobox Torsten Irländer <torsten.irlaender@intevation.de> parents: 25 diff changeset	16 select: this.selectSql
31 897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	17 },
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	18 '#SearchBtn': {
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	19 // Map click event on Button.
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	20 click: this.search
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	21 },
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	22 '#ResetBtn': {
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	23 // Map click event on Button.
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	24 click: this.reset
6 8e79bda4d55b Added a list to select predefined SQL Statement for the Proben list. Torsten Irländer <torsten.irlaender@intevation.de> parents: diff changeset	25 }
8e79bda4d55b Added a list to select predefined SQL Statement for the Proben list. Torsten Irländer <torsten.irlaender@intevation.de> parents: diff changeset	26 });
8e79bda4d55b Added a list to select predefined SQL Statement for the Proben list. Torsten Irländer <torsten.irlaender@intevation.de> parents: diff changeset	27 },
8e79bda4d55b Added a list to select predefined SQL Statement for the Proben list. Torsten Irländer <torsten.irlaender@intevation.de> parents: diff changeset	28 onPanelRendered: function() {
8e79bda4d55b Added a list to select predefined SQL Statement for the Proben list. Torsten Irländer <torsten.irlaender@intevation.de> parents: diff changeset	29 console.log('The panel was rendered');
8e79bda4d55b Added a list to select predefined SQL Statement for the Proben list. Torsten Irländer <torsten.irlaender@intevation.de> parents: diff changeset	30 },
28 4d60b9ebce15 Renamed sql modul into search. Further display The query selection as Combobox Torsten Irländer <torsten.irlaender@intevation.de> parents: 25 diff changeset	31 selectSql: function(element, record, index) {
31 897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	32 var selection = element.getValue() - 1;
25 f964a50bfe57 Restructured the application. Fixed layouts etc. Torsten Irländer <torsten.irlaender@intevation.de> parents: 17 diff changeset	33 console.log('Selected SQL ' + selection);
31 897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	34 for (var i = 0; i < queries.length; ++i) {
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	35 var toHide = Ext.getCmp(queries[i]);
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	36 toHide.hide();
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	37 }
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	38 var toShow = Ext.getCmp(queries[selection]);
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	39 var buttons = Ext.getCmp('SearchBtnPanel');
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	40 this.reset();
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	41 toShow.show();
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	42 buttons.show();
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	43 },
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	44 search: function(element, record, index) {
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	45 var result = Ext.getCmp('result');
28 4d60b9ebce15 Renamed sql modul into search. Further display The query selection as Combobox Torsten Irländer <torsten.irlaender@intevation.de> parents: 25 diff changeset	46 console.log('Loading store');
36 2a67e062519b Implemted search. When user clicks on the search buttons parameters are Torsten Irländer <torsten.irlaender@intevation.de> parents: 35 diff changeset	47
2a67e062519b Implemted search. When user clicks on the search buttons parameters are Torsten Irländer <torsten.irlaender@intevation.de> parents: 35 diff changeset	48 // Get search parameters:
2a67e062519b Implemted search. When user clicks on the search buttons parameters are Torsten Irländer <torsten.irlaender@intevation.de> parents: 35 diff changeset	49 var searchParams = {};
2a67e062519b Implemted search. When user clicks on the search buttons parameters are Torsten Irländer <torsten.irlaender@intevation.de> parents: 35 diff changeset	50 if (Ext.getCmp('search').getValue() == 1) {
96 ecb0c0cf386b Only add search params if the user actually set them in the form. Torsten Irländer <torsten.irlaender@intevation.de> parents: 36 diff changeset	51 var mst = Ext.getCmp('mst').getValue();
ecb0c0cf386b Only add search params if the user actually set them in the form. Torsten Irländer <torsten.irlaender@intevation.de> parents: 36 diff changeset	52 var uwb = Ext.getCmp('uwb').getValue();
ecb0c0cf386b Only add search params if the user actually set them in the form. Torsten Irländer <torsten.irlaender@intevation.de> parents: 36 diff changeset	53 if (mst !== null) {
139 df6e36dd57ee Changed params probe -> probeId, mst -> mstId, uwb -> umwId Torsten Irländer <torsten.irlaender@intevation.de> parents: 120 diff changeset	54 searchParams['mstId'] = mst;
96 ecb0c0cf386b Only add search params if the user actually set them in the form. Torsten Irländer <torsten.irlaender@intevation.de> parents: 36 diff changeset	55 }
ecb0c0cf386b Only add search params if the user actually set them in the form. Torsten Irländer <torsten.irlaender@intevation.de> parents: 36 diff changeset	56 if (uwb !== null) {
139 df6e36dd57ee Changed params probe -> probeId, mst -> mstId, uwb -> umwId Torsten Irländer <torsten.irlaender@intevation.de> parents: 120 diff changeset	57 searchParams['umwId'] = uwb;
96 ecb0c0cf386b Only add search params if the user actually set them in the form. Torsten Irländer <torsten.irlaender@intevation.de> parents: 36 diff changeset	58 }
36 2a67e062519b Implemted search. When user clicks on the search buttons parameters are Torsten Irländer <torsten.irlaender@intevation.de> parents: 35 diff changeset	59 } else {
2a67e062519b Implemted search. When user clicks on the search buttons parameters are Torsten Irländer <torsten.irlaender@intevation.de> parents: 35 diff changeset	60 // Get date object an convert it into a timestamp (ms since epoch)
97 9a549ca6e664 Only getTimte from datefield if the value is not null. Torsten Irländer <torsten.irlaender@intevation.de> parents: 96 diff changeset	61 var datefield = Ext.getCmp('pbegin').getValue();
9a549ca6e664 Only getTimte from datefield if the value is not null. Torsten Irländer <torsten.irlaender@intevation.de> parents: 96 diff changeset	62 if (datefield !== null) {
9a549ca6e664 Only getTimte from datefield if the value is not null. Torsten Irländer <torsten.irlaender@intevation.de> parents: 96 diff changeset	63 var ts = Ext.getCmp('pbegin').getValue().getTime();
96 ecb0c0cf386b Only add search params if the user actually set them in the form. Torsten Irländer <torsten.irlaender@intevation.de> parents: 36 diff changeset	64 searchParams['begin'] = ts;
ecb0c0cf386b Only add search params if the user actually set them in the form. Torsten Irländer <torsten.irlaender@intevation.de> parents: 36 diff changeset	65 }
36 2a67e062519b Implemted search. When user clicks on the search buttons parameters are Torsten Irländer <torsten.irlaender@intevation.de> parents: 35 diff changeset	66 }
2a67e062519b Implemted search. When user clicks on the search buttons parameters are Torsten Irländer <torsten.irlaender@intevation.de> parents: 35 diff changeset	67 result.getStore().load({
2a67e062519b Implemted search. When user clicks on the search buttons parameters are Torsten Irländer <torsten.irlaender@intevation.de> parents: 35 diff changeset	68 params: searchParams
2a67e062519b Implemted search. When user clicks on the search buttons parameters are Torsten Irländer <torsten.irlaender@intevation.de> parents: 35 diff changeset	69 });
28 4d60b9ebce15 Renamed sql modul into search. Further display The query selection as Combobox Torsten Irländer <torsten.irlaender@intevation.de> parents: 25 diff changeset	70 console.log('Store loaded');
25 f964a50bfe57 Restructured the application. Fixed layouts etc. Torsten Irländer <torsten.irlaender@intevation.de> parents: 17 diff changeset	71 result.show();
31 897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	72 },
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	73 reset: function(element, record, index) {
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	74 var buttons = Ext.getCmp('SearchBtnPanel');
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	75 var result = Ext.getCmp('result');
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	76 for (var i = 0; i < queries.length; ++i) {
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	77 var toHide = Ext.getCmp(queries[i]);
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	78 toHide.hide();
897e3100c6da Changed logic of the Probenauswahl. Now logic works like the BFS version. Torsten Irländer <torsten.irlaender@intevation.de> parents: 28 diff changeset	79 }
147 5da0b56bf9bf Do no hide the earch buttons and the resultlist on reset. Torsten Irländer <torsten.irlaender@intevation.de> parents: 139 diff changeset	80 //result.hide();
5da0b56bf9bf Do no hide the earch buttons and the resultlist on reset. Torsten Irländer <torsten.irlaender@intevation.de> parents: 139 diff changeset	81 //buttons.hide();
6 8e79bda4d55b Added a list to select predefined SQL Statement for the Proben list. Torsten Irländer <torsten.irlaender@intevation.de> parents: diff changeset	82 }
8e79bda4d55b Added a list to select predefined SQL Statement for the Proben list. Torsten Irländer <torsten.irlaender@intevation.de> parents: diff changeset	83 });

http://lada.wald.intevation.org