[Mapbender-commits] r5151 -
branches/2.6/resources/db/pgsql/UTF-8/update
svn_mapbender at osgeo.org
svn_mapbender at osgeo.org
Sat Dec 12 05:09:17 EST 2009
Author: astrid_emde
Date: 2009-12-12 05:09:17 -0500 (Sat, 12 Dec 2009)
New Revision: 5151
Added:
branches/2.6/resources/db/pgsql/UTF-8/update/update_2.6_to_2.6.1_pgsql_UTF-8.sql
Log:
Added: branches/2.6/resources/db/pgsql/UTF-8/update/update_2.6_to_2.6.1_pgsql_UTF-8.sql
===================================================================
--- branches/2.6/resources/db/pgsql/UTF-8/update/update_2.6_to_2.6.1_pgsql_UTF-8.sql (rev 0)
+++ branches/2.6/resources/db/pgsql/UTF-8/update/update_2.6_to_2.6.1_pgsql_UTF-8.sql 2009-12-12 10:09:17 UTC (rev 5151)
@@ -0,0 +1,281 @@
+--
+-- mapframe1 set e_mb_mod - sets background to white
+--
+UPDATE gui_element SET
+e_mb_mod = 'map_obj.js,map.js,wms.js,wfs_obj.js,initWms.php',
+e_more_styles = 'overflow:hidden;background-color:white'
+WHERE e_id = 'mapframe1';
+
+--
+-- wfs target mapframe1 and overview --## what if gui has no overview?
+--
+UPDATE gui_element SET e_js_file = 'wfs.php', e_target='mapframe1,overview' WHERE e_id = 'wfs';
+--
+-- element wfs
+--
+UPDATE gui_element SET e_mb_mod = '../extensions/wz_jsgraphics.js,geometry.js' WHERE e_id = 'wfs';
+
+
+
+--
+-- update e_attributes for some elements - new definition
+--
+UPDATE gui_element SET e_attributes = '' WHERE e_id = 'forward';
+UPDATE gui_element SET e_attributes = '' WHERE e_id = 'back';
+UPDATE gui_element SET e_attributes = '' WHERE e_id = 'zoomIn1';
+UPDATE gui_element SET e_attributes = '' WHERE e_id = 'zoomOut1';
+UPDATE gui_element SET e_attributes = '' WHERE e_id = 'measure';
+
+--
+-- delete deprecated elements
+--
+DELETE FROM gui_element WHERE e_id = 'closePolygon';
+DELETE FROM gui_element WHERE e_id = 'rubber';
+DELETE FROM gui_element WHERE e_id = 'getArea';
+DELETE FROM gui_element WHERE e_id = 'rubberExt';
+
+--
+-- gazetteerWFS - add new elements var where needed (showResultInPopup)
+--
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
+SELECT gui_element.fkey_gui_id, 'gazetteerWFS', 'showResultInPopup', '1',
+'if value is 1 search results will be displayed in popup, otherwise in gazetteer div' ,'var' FROM gui_element
+WHERE gui_element.e_id = 'gazetteerWFS' AND gui_element.fkey_gui_id NOT IN
+(SELECT fkey_gui_id FROM gui_element_vars WHERE var_name = 'showResultInPopup' AND fkey_e_id = 'gazetteerWFS');
+
+
+-- gazetteerWFS - element var wfs_spatial_request_conf_filename for gui element gazetteerWFS
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
+SELECT gui_element.fkey_gui_id, 'gazetteerWFS', 'wfs_spatial_request_conf_filename', 'wfs_additional_spatial_search.conf',
+'location and name of the WFS configuration file for spatialRequest' ,'php_var' FROM gui_element
+WHERE gui_element.e_id = 'gazetteerWFS' AND gui_element.fkey_gui_id NOT IN
+(SELECT fkey_gui_id FROM gui_element_vars WHERE var_name = 'wfs_spatial_request_conf_filename' AND fkey_e_id = 'gazetteerWFS');
+
+
+
+--
+-- gazetteerWFS add tablesorter.js
+--
+UPDATE gui_element
+SET e_mb_mod = 'geometry.js,requestGeometryConstructor.js,popup.js,../extensions/jquery.tablesorter.js'
+WHERE e_id = 'gazetteerWFS';
+
+
+--
+-- element var popupcss for gui element body
+--
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
+SELECT gui_element.fkey_gui_id, 'body', 'popupcss', '../css/popup.css', 'file css', 'file/css'
+FROM gui_element WHERE gui_element.e_id = 'body'
+AND gui_element.fkey_gui_id NOT IN (SELECT fkey_gui_id FROM gui_element_vars
+WHERE var_name = 'popupcss' AND fkey_e_id = 'body');
+
+
+--
+-- element var tablesortercss for gui element body
+--
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
+SELECT gui_element.fkey_gui_id, 'body', 'tablesortercss', '../css/tablesorter.css', 'file css' ,'file/css'
+FROM gui_element WHERE gui_element.e_id = 'body'
+AND gui_element.fkey_gui_id NOT IN (SELECT fkey_gui_id FROM gui_element_vars
+WHERE var_name = 'tablesortercss' AND fkey_e_id = 'body');
+
+
+--#style in gui_digitize
+-- ---------------------
+-- add style class to element var text css of element digitize in gui_digitize
+UPDATE gui_element_vars
+SET var_value =
+'digitizeGeometryList {position:absolute; top:50px; left:0px;}
+.digitizeGeometryListItem {color:#000000; font-size:10px;}
+body {font-family: Arial, Helvetica, sans-serif; font-size:12px; color:#ff00ff; background-color:#ffffff; margin-top: 0px; margin-left:0px;}
+.button {height:18px; width:32px;}'
+WHERE fkey_e_id = 'digitize'
+ AND var_name = 'text css';
+
+
+
+--
+-- overview as div
+--
+-- element_var for overview_wms
+-- wms=int from former overview definition and add it to the new element_var (example ../php/mod_mapOV.php?wms=22&sessionID)
+INSERT INTO gui_element_vars
+select fkey_gui_id, 'overview' as fkey_e_id, 'overview_wms' as var_name,
+substr(e_src,strpos(e_src,'wms=')+4,strpos(e_src,'&')-strpos(e_src,'wms=')-4) as var_value,
+'wms that shows up as overview' as context,
+'var' as var_type from gui_element where e_id = 'overview'
+AND strpos(e_src,'wms=') > 0;
+
+--
+-- update overview as a div
+--
+UPDATE gui_element SET e_element = 'div',
+e_src = '',
+e_attributes = '',
+e_more_styles = 'overflow:hidden;',
+e_content = '<div id="overview_maps" style="position:absolute;left:0px;right:0px;"></div>',
+e_closetag = 'div',
+e_js_file = 'ovnf.php',
+e_target = 'mapframe1',
+e_requires = 'mapframe1' WHERE e_id = 'overview';
+
+
+--
+-- UPDATE treeGDE - div
+--
+--
+-- treeGDE new element_var for treeGDE in body
+--
+-- css nun Teil vom Body
+UPDATE gui_element_vars set
+fkey_e_id ='body',
+var_name = 'treeGDE_css'
+where fkey_e_id = 'treeGDE'
+and var_type = 'file/css';
+
+
+--
+-- treeGDE - div
+--
+UPDATE gui_element SET
+e_pos = 2,
+e_element = 'div',
+e_more_styles = 'visibility:visible;overflow:scroll',
+e_content = '', e_closetag = 'div',
+e_js_file = '../html/mod_treefolderPlain.php',
+e_mb_mod = 'jsTree.js', e_requires = 'mapframe1' WHERE e_id = 'treeGDE';
+
+--
+-- remove treeGDE-css statement from 'treeGDE' because its handled in 'body' element
+--
+DELETE from gui_element_vars WHERE fkey_e_id= 'treeGDE' AND var_name='cssfile';
+-- End treeGDE
+
+
+--
+-- Update ChangeEPSG
+--
+-- Notice: EPSG-Codes are now defined in e_content and not in the file itself
+--
+UPDATE gui_element SET e_element = 'select', e_src = '', e_attributes = '', e_content = '<option value="">undefined</option>
+<option value="EPSG:4326">EPSG:4326</option>
+<option value="EPSG:31466">EPSG:31466</option>
+<option value="EPSG:31467">EPSG:31467</option>
+<option value="EPSG:31468">EPSG:31468</option>
+<option value="EPSG:31469">EPSG:31469</option>', e_closetag = 'select', e_js_file = 'mod_changeEPSG.php'
+WHERE e_id = 'changeEPSG';
+
+
+--
+-- zoomCoords - new definition
+--
+UPDATE gui_element SET e_element = 'div', e_src = '',
+e_attributes = '',
+e_more_styles = 'overflow:hidden;',
+e_content = '', e_closetag = 'div',
+e_js_file = 'mod_zoomCoords.php',
+e_target = 'mapframe1,overview',
+e_requires = 'mapframe1' WHERE e_id = 'zoomCoords';
+
+
+--
+-- splash screen - add splash to all application
+--
+INSERT INTO gui_element_vars
+SELECT gui_element.fkey_gui_id, 'body', 'use_load_message', 'true' as var_value,
+'show splash screen while the application is loading' as context ,
+'php_var' as var_type
+FROM gui_element WHERE gui_element.e_id = 'body' AND
+gui_element.fkey_gui_id NOT IN
+(SELECT fkey_gui_id FROM gui_element_vars WHERE var_name = 'use_load_message' AND fkey_e_id = 'body');
+
+INSERT INTO gui_element_vars
+SELECT gui_element.fkey_gui_id, 'body', 'includeWhileLoading',
+'' as var_value,
+'show splash screen while the application is loading' as context ,
+'php_var' as var_type
+FROM gui_element WHERE gui_element.e_id = 'body' AND
+gui_element.fkey_gui_id NOT IN
+(SELECT fkey_gui_id FROM gui_element_vars WHERE var_name = 'includeWhileLoading' AND fkey_e_id = 'body');
+
+
+--
+-- gui: tab: increase the size of the frames onmouseover
+--
+UPDATE gui_element SET e_attributes = 'frameborder = "0" onmouseover="this.style.zIndex=300;this.style.width=350;" onmouseout="this.style.zIndex=2;this.style.width=200"',
+e_more_styles = 'visibility:hidden; border: 1px solid #a19c8f;'
+WHERE e_id IN ('treeGDE','printPDF','legend','imprint','meetingPoint','gazetteerWFS')
+AND fkey_gui_id IN ('gui');
+-- ## UPDATE gui_element SET e_more_styles = e_more_styles || ' background-color:#FFFFFF;' WHERE e_id IN ('treeGDE','imprint') AND fkey_gui_id IN ('gui');
+
+
+--
+-- setSpatialRequest
+--
+UPDATE gui_element SET e_mb_mod = 'geometry.js,requestGeometryConstructor.js,popup.js' WHERE e_id = 'setSpatialRequest';
+
+-- element var cssfileAddWMS for gui element addWMSfromfilteredList_ajax
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
+SELECT gui_element.fkey_gui_id, 'addWMSfromfilteredList_ajax', 'cssfileAddWMS', '../css/addwms.css', '' ,'file/css'
+FROM gui_element WHERE gui_element.e_id = 'addWMSfromfilteredList_ajax' AND
+gui_element.fkey_gui_id NOT IN
+(SELECT fkey_gui_id FROM gui_element_vars WHERE var_name = 'cssfileAddWMS' AND fkey_e_id = 'addWMSfromfilteredList_ajax');
+
+--
+-- element var capabilitiesInput for gui element addWMSfromfilteredList_ajax
+--
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
+SELECT gui_element.fkey_gui_id, 'addWMSfromfilteredList_ajax', 'capabilitiesInput', '1', 'load wms by capabilities url' ,'var'
+FROM gui_element WHERE gui_element.e_id = 'addWMSfromfilteredList_ajax'
+AND gui_element.fkey_gui_id NOT IN
+(SELECT fkey_gui_id FROM gui_element_vars WHERE var_name = 'capabilitiesInput' AND fkey_e_id = 'addWMSfromfilteredList_ajax');
+
+--
+-- element var option_dball for gui element addWMSfromfilteredList_ajax
+--
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
+SELECT gui_element.fkey_gui_id, 'addWMSfromfilteredList_ajax', 'option_dball', '1', '1 enables option "load all configured wms from db"' ,'var'
+FROM gui_element WHERE gui_element.e_id = 'addWMSfromfilteredList_ajax' AND gui_element.fkey_gui_id NOT IN
+(SELECT fkey_gui_id FROM gui_element_vars
+WHERE var_name = 'option_dball' AND fkey_e_id = 'addWMSfromfilteredList_ajax');
+
+--
+-- element var option_dbgroup for gui element addWMSfromfilteredList_ajax
+--
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
+SELECT gui_element.fkey_gui_id, 'addWMSfromfilteredList_ajax', 'option_dbgroup', '1', '1 enables option "load configured wms by group"' ,'var'
+FROM gui_element WHERE gui_element.e_id = 'addWMSfromfilteredList_ajax' AND gui_element.fkey_gui_id NOT IN
+(SELECT fkey_gui_id FROM gui_element_vars WHERE var_name = 'option_dbgroup' AND fkey_e_id = 'addWMSfromfilteredList_ajax');
+
+--
+-- element var option_dbgui for gui element addWMSfromfilteredList_ajax
+--
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
+SELECT gui_element.fkey_gui_id, 'addWMSfromfilteredList_ajax', 'option_dbgui', '1', '1 enables option "load configured wms by gui"' ,'var'
+FROM gui_element WHERE gui_element.e_id = 'addWMSfromfilteredList_ajax' AND gui_element.fkey_gui_id NOT IN
+(SELECT fkey_gui_id FROM gui_element_vars WHERE var_name = 'option_dbgui' AND fkey_e_id = 'addWMSfromfilteredList_ajax');
+
+--
+-- featureinfoTunnel - element var featureInfoPopupHeight for gui element featureInfoTunnel
+--
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) SELECT gui_element.fkey_gui_id, 'featureInfoTunnel', 'featureInfoPopupHeight', '200', '' ,'var' FROM gui_element WHERE gui_element.e_id = 'featureInfoTunnel' AND gui_element.fkey_gui_id NOT IN (SELECT fkey_gui_id FROM gui_element_vars WHERE var_name = 'featureInfoPopupHeight' AND fkey_e_id = 'featureInfoTunnel');
+
+--
+-- featureinfoTunnel - element var featureInfoPopupWidth for gui element featureInfoTunnel
+--
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) SELECT gui_element.fkey_gui_id, 'featureInfoTunnel', 'featureInfoPopupWidth', '270', '' ,'var' FROM gui_element WHERE gui_element.e_id = 'featureInfoTunnel' AND gui_element.fkey_gui_id NOT IN (SELECT fkey_gui_id FROM gui_element_vars WHERE var_name = 'featureInfoPopupWidth' AND fkey_e_id = 'featureInfoTunnel');
+
+--
+-- delete old element_vars for 'addWMSfromfilteredList_ajax' completely
+DELETE FROM gui_element_vars
+WHERE fkey_e_id = 'addWMSfromfilteredList_ajax'
+and var_name NOT IN ('cssfileAddWMS','capabilitiesInput','option_dbgui','option_dball','option_dbgroup');
+
+--
+-- body add flavicon - element var favicon for gui element body
+--
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
+SELECT gui_element.fkey_gui_id, 'body', 'favicon', '../img/favicon.png', 'favicon' ,'php_var' FROM gui_element
+WHERE gui_element.e_id = 'body' AND gui_element.fkey_gui_id NOT IN
+(SELECT fkey_gui_id FROM gui_element_vars WHERE var_name = 'favicon' AND fkey_e_id = 'body');
More information about the Mapbender_commits
mailing list