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

Thu Aug 26 03:57:06 EDT 2010

Author: christoph
Date: 2010-08-26 07:57:06 +0000 (Thu, 26 Aug 2010)
New Revision: 6817

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
Log:
savemwc: saveInSession

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
===================================================================

--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql	2010-08-26 07:35:20 UTC (rev 6816)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql	2010-08-26 07:57:06 UTC (rev 6817)
@@ -1450,28 +1450,17 @@
 -- gui_digitze: added new printPDF (with rotation and pdf Template)
 --
 -- does not work with 4326 :(
-Delete from gui_element where fkey_gui_id = 'gui1' and e_id = 'printPDF';
+--Delete from gui_element where fkey_gui_id = 'gui_digitize' and e_id = 'printPDF';
+--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(
+--'gui_digitize','printPDF',2,1,'pdf print','Print','div','','',1,1,2,2,5,'','<div id="printPDF_working_bg"></div><div id="printPDF_working"><img src="../img/indicator_wheel.gif" style="padding:10px 0 0 10px">Generating PDF</div><div id="printPDF_input"><form id="printPDF_form" action="../print/printFactory.php"><div id="printPDF_selector"></div><div class="print_option"><input type="hidden" id="map_url" name="map_url" value=""/><input type="hidden" id="overview_url" name="overview_url" value=""/><input type="hidden" id="map_scale" name="map_scale" value=""/><input type="hidden" name="measured_x_values" /><input type="hidden" name="measured_y_values" /><br /></div><div class="print_option" id="printPDF_formsubmit"><input id="submit" type="submit" value="Print"><br /></div></form><div id="printPDF_result"></div></div>','div','../plugins/mb_print.js','../../lib/printbox.js,../extensions/jquery-ui-1.7.2.custom/development-bundle/external/bgiframe/jquery.bgiframe.min.js,../exten
 sions/jquery.form.min.js','mapframe1','','http://www.mapbender.org/index.php/Print');
 
-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','printPDF',2,1,'pdf print','Print','div','','',
-10,520,200,380,5,'',
-'<div id="printPDF_working_bg"></div><div id="printPDF_working"><img src="../img/indicator_wheel.gif" style="padding:10px 0 0 10px">Generating PDF</div><div id="printPDF_input"><form id="printPDF_form" action="../print/printFactory.php"><div id="printPDF_selector"></div><div class="print_option"><input type="hidden" id="map_url" name="map_url" value=""/><input type="hidden" id="overview_url" name="overview_url" value=""/><input type="hidden" id="map_scale" name="map_scale" value=""/><input type="hidden" name="measured_x_values" /><input type="hidden" name="measured_y_values" /><br /></div><div class="print_option" id="printPDF_formsubmit"><input id="submit" type="submit" value="Print"><br /></div></form><div id="printPDF_result"></div></div>',
-'div','../plugins/mb_print.js',
-'../../lib/printbox.js,../extensions/jquery-ui-1.7.2.custom/development-bundle/external/bgiframe/jquery.bgiframe.min.js,../extensions/jquery.form.min.js',
-'mapframe1','','http://www.mapbender.org/index.php/Print');
+--INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES(
+--'gui_digitize', 'printPDF', 'mbPrintConfig', '{"A4 landscape": "A4_lanscape_template.json","A4 portrait": "A4_portrait_template.json","A4 landscape": "A4_landscape_template.json","A3 landscape": "A3_landscape_template.json"}', '' ,'var');
 
-INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, 
-var_value, context, var_type) 
-VALUES('gui1', 'printPDF', 'mbPrintConfig', '{"A4 landscape": "A4_landscape_template.json","A4 portrait": "A4_portrait_template.json","A4 landscape": "A4_landscape_template.json","A3 landscape": "A3_landscape_template.json"}', '' ,'var');
+--INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES(
+--'gui_digitize', 'body', 'print_css', '../css/print_div.css', '' ,'file/css');
 
-INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, 
-var_value, context, var_type) 
-VALUES('gui1', 'body', 'print_css', '../css/print_div.css', '' ,'file/css');
-
-
 -- standard gui gui_wfs_conf entries for search
 INSERT INTO  gui_wfs_conf(fkey_gui_id, fkey_wfs_conf_id) 
 SELECT 'gui',wfs_conf_id from wfs_conf WHERE wfs_conf_id = 1 
@@ -2670,6 +2659,7 @@
   OIDS=FALSE
 );
 
+
 --
 -- add new zoomto coords to gui as a new tab
 --
@@ -2696,3 +2686,12 @@
 
 
 
+-- element var saveInSession for gui element savewmc
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
+SELECT gui_element.fkey_gui_id, 'savewmc', 'saveInSession', '0', '' ,'var'
+FROM gui_element WHERE gui_element.e_id = 'savewmc' AND gui_element.fkey_gui_id
+NOT IN (SELECT fkey_gui_id FROM gui_element_vars
+WHERE var_name = 'saveInSession' AND fkey_e_id = 'savewmc');
+-- previously, this had been a php var
+UPDATE gui_element_vars SET var_type = 'var' WHERE var_name = 'saveInSession' AND fkey_e_id = 'savewmc';
+

