[Mapbender-commits] r8279 - trunk/mapbender/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2012-03-08 08:16:31 -0800 (Thu, 08 Mar 2012)
New Revision: 8279

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql
Log:
add new modules to gui1

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql	2012-03-06 07:09:29 UTC (rev 8278)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql	2012-03-08 16:16:31 UTC (rev 8279)
@@ -193,4 +193,52 @@
 gui_element.e_id = 'legend' AND
 gui_element.fkey_gui_id
 NOT IN (SELECT fkey_gui_id FROM gui_element_vars WHERE fkey_e_id = 'legend' AND var_name = 'reverseLegend');
+DELETE FROM gui_element WHERE e_id = 'WMS_preferences' AND fkey_gui_id = 'gui1';
 
+INSERT INTO gui_element(fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES('gui1','WMS_preferencesButton',2,1,'button for configure the preferences of each loaded wms','Manage WMS preferences','img','../img/button_blink_red/preferences_off.png','',670,60,24,24,1,'','','','../plugins/mb_button.js','','WMS_preferencesDiv','','http://www.mapbender.org/index.php/WMS_preferences');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui1', 'WMS_preferencesButton', 'dialogWidth', '400', '' ,'var');
+
+INSERT INTO gui_element(fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES('gui1','WMS_preferencesDiv',12,1,'Configure WMS preferences - div tag','WMS preferences','div','','',870,60,400,500,NULL ,'z-index:9999;','','div','../plugins/mod_WMSpreferencesDiv.php','','mapframe1','jq_ui_dialog','http://www.mapbender.org/index.php/mod_WMSpreferencesDiv');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui1', 'WMS_preferencesDiv', 'overwrite', '0', '' ,'var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui1', 'WMS_preferencesDiv', 'saveInSession', '0', '' ,'var');
+
+INSERT INTO gui_element(fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES('gui1','jq_ui_autocomplete',5,1,'Module to manage jQuery UI autocomplete module','','','','',NULL ,NULL ,NULL ,NULL ,NULL ,'','','','','../extensions/jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.autocomplete.js','','jq_ui,jq_ui_widget,jq_ui_position','http://jqueryui.com/demos/autocomplete/');
+
+
+INSERT INTO gui_element(fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES('gui1','jsonAutocompleteGazetteer',12,1,'Client for json webservices like geonames.org','Gazetteer','div','','',220,110,NULL ,NULL ,999,'','','div','../plugins/mod_jsonAutocompleteGazetteer.php','','mapframe1','','http://www.mapbender.org/index.php/mod_jsonAutocompleteGazetteer');
+
+
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui1', 'jsonAutocompleteGazetteer', 'gazetteerUrl', 'http://ws.geonames.org/searchJSON?lang=de&',
+  '' ,'var');
+
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui1', 'jsonAutocompleteGazetteer', 'isGeonames', 'true', '' ,'var');
+
+--INSERT INTO gui_element(fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES('toolbox_jquery','jq_ui_autocomplete',5,1,'Module to manage jQuery UI autocomplete module','','','','',NULL ,NULL ,NULL ,NULL ,NULL ,'','','','','../extensions/jquery-ui-1.8.16.custom/development-bundle/ui/jquery.ui.autocomplete.js','','jq_ui,jq_ui_widget,jq_ui_position','http://jqueryui.com/demos/autocomplete/');
+
+-- Function: f_normalize_load_count(text,integer)
+
+--DROP FUNCTION f_normalize_load_count(text,integer);
+
+CREATE OR REPLACE FUNCTION f_normalize_load_count(tablename text, newmaxvalue integer)
+  RETURNS void AS
+$BODY$
+DECLARE
+   tablename ALIAS FOR $1;
+   newmaxvalue ALIAS FOR $2;
+   oldmaxvalue integer;
+   querytext text;
+   result record;
+BEGIN
+   querytext:= 'SELECT max(load_count) FROM ' || lower(tablename);
+   EXECUTE querytext INTO oldmaxvalue;
+   querytext:= 'UPDATE ' || lower(tablename) || ' SET load_count = ' || 'floor((load_count::real/' || oldmaxvalue ||  ')*' || newmaxvalue || ')';
+   EXECUTE querytext;
+RETURN;--querytext;
+END;
+$BODY$
+  LANGUAGE plpgsql VOLATILE
+  COST 100;
+ALTER FUNCTION f_normalize_load_count(text , integer) OWNER TO postgres;
+
+
+