[Mapbender-commits] r8419 - branches/2.7/resources/db/pgsql/UTF-8/update
svn_mapbender at osgeo.org
svn_mapbender at osgeo.org
Thu Jul 5 07:32:26 PDT 2012
Author: astrid_emde
Date: 2012-07-05 07:32:24 -0700 (Thu, 05 Jul 2012)
New Revision: 8419
Modified:
branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql
Log:
* Table keyword columen keyword changed to text
* legend - new element vars
* new gazetteer in gui1
* wms preferences with div
--> merged from trunk
Modified: branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql
===================================================================
--- branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql 2012-07-05 14:23:21 UTC (rev 8418)
+++ branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql 2012-07-05 14:32:24 UTC (rev 8419)
@@ -1,4 +1,4 @@
--- new file for db changes to 2.7.3-- new file for db changes to 2.7.3
+-- new file for db changes to 2.7.3
-- replace gettext to handle ' in french translation
DROP FUNCTION IF EXISTS gettext(text, text);
@@ -105,7 +105,7 @@
gui_element.e_id = 'measure_widget' AND
gui_element.fkey_gui_id
NOT IN (SELECT fkey_gui_id FROM gui_element_vars WHERE fkey_e_id = 'measure_widget' AND var_name = 'pointStrokeWidthDefault');
-
+
--get featureInfoTunnel ready for working with toggleModule
UPDATE gui_element SET e_attributes = NULL WHERE e_id = 'featureInfoTunnel';
@@ -205,12 +205,52 @@
NOT IN (SELECT fkey_gui_id FROM gui_element_vars WHERE fkey_e_id = 'legend' AND var_name = 'reverseLegend');
--
+-- add WMS_preferences as dialog to gui1
+--
+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_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui1', 'jsonAutocompleteGazetteer', 'isGeonames', 'true', '' ,'var');
+
+
+--
+-- new gazetteer jsonAutocompleteGazetteer
+--
+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');
+
+--
-- change datatype from 50 to 256 to handle longer style names
--
ALTER TABLE layer_style ALTER COLUMN name TYPE character varying(256);
ALTER TABLE gui_layer ALTER COLUMN gui_layer_style TYPE character varying(256);
+ALTER TABLE keyword ALTER COLUMN keyword TYPE text;
+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_slider',5,1,'slider from the jQuery UI framework','','','','',NULL ,NULL ,NULL ,NULL ,NULL ,'','','','','../extensions/jquery-ui-1.8.16.custom/development-bundle/ui/minified/jquery.ui.slider.min.js','','jq_ui,jq_ui_mouse,jq_ui_widget','');
+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','resultList_Highlight',2,1,'highlighting functionality for resultList','','div','','',NULL ,NULL ,NULL ,NULL ,NULL ,'','','','../plugins/mb_resultList_Highlight.js','','resultList,mapframe1,overview','','http://www.mapbender.org/resultList_Highlight');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui1', 'resultList_Highlight', 'maxHighlightedPoints', '500', 'max number of points to highlight' ,'var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui1', 'resultList_Highlight', 'resultHighlightColor', '#ff0000', 'color of the highlighting' ,'var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui1', 'resultList_Highlight', 'resultHighlightLineWidth', '2', 'width of the highlighting line' ,'var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui1', 'resultList_Highlight', 'resultHighlightZIndex', '100', 'zindex of the highlighting' ,'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','resultList_Zoom',2,1,'zoom functionality for resultList','','div','','',NULL ,NULL ,NULL ,NULL ,NULL ,'','','','../plugins/mb_resultList_Zoom.js','','resultList,mapframe1','','http://www.mapbender.org/resultList_Zoom');
+
+
+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','resultList',2,1,'','Result List','div','','',NULL ,NULL ,NULL ,NULL ,NULL ,'','','div','mod_ResultList.js','../../lib/resultGeometryListController.js, ../../lib/resultGeometryListModel.js','mapframe1','','');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui1', 'resultList', 'position', '[600,50]', 'position of the result list dialog' ,'var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui1', 'resultList', 'resultListHeight', '400', 'height of the result list dialog' ,'var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui1', 'resultList', 'resultListTitle', 'Search results', 'title of the result list dialog' ,'var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui1', 'resultList', 'resultListWidth', '600', 'width of the result list dialog' ,'var');
+
+UPDATE gui_element SET e_js_file = '../extensions/wz_jsgraphics.js,geometry.js,../extensions/RaphaelJS/raphael-1.4.7.min.js,../extensions/RaphaelJS/raphael-1.4.7.min.js,../extensions/RaphaelJS/raphael-1.4.7.min.js,../extensions/RaphaelJS/raphael-1.4.7.min.js' where fkey_gui_id = 'gui1' AND e_id = 'body';
+
--
-- replace server name wms1.ccgis.de to wms.wheregroup.com
--
@@ -229,3 +269,9 @@
-- Fix: Ticket #870, http://trac.osgeo.org/mapbender/ticket/870
UPDATE gui_element set e_attributes='frameborder="1" onmouseover="this.style.zIndex=300;this.style.width=''350px'';" onmouseout="this.style.zIndex=3;this.style.width=''200px'';"' where fkey_gui_id='gui' and e_id='legend';
+
+--
+-- legend: add new element vars enlargetreewidth and enlargetreewidthopacity to gui
+--
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui', 'treeGDE', 'enlargetreewidth', '300', 'false (default): no enlargement of the div, integer value to enlarge on mouseover' ,'var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui', 'treeGDE', 'enlargetreewidthopacity', 'true', '' ,'var');
More information about the Mapbender_commits
mailing list