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

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2010-02-16 06:27:03 -0500 (Tue, 16 Feb 2010)
New Revision: 5508

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
Log:
add sql for resultList, jq_ui_dialog, jq_datatables, jq_ui_theme, jq_ui_dialog, jq_ui

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-02-16 11:15:01 UTC (rev 5507)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql	2010-02-16 11:27:03 UTC (rev 5508)
@@ -1179,3 +1179,73 @@
 INSERT INTO gui_mb_user (fkey_gui_id, fkey_mb_user_id, mb_user_type) VALUES ('toolbox_jquery', 1, 'owner');
 
 
+--
+-- add jq_ui_theme
+--
+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', 'jq_ui_theme', 
+'../extensions/jquery-ui-1.7.2.custom/css/smoothness/jquery-ui-1.7.2.custom.css', 'UI Theme from Themeroller' ,'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 = 'jq_ui_theme');
+
+
+--
+-- add resultList to applications with element gazetteerWFS
+--
+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)
+SELECT gui_element.fkey_gui_id, 'resultList',2,1,'','Result List','div','','',NULL ,NULL ,NULL ,NULL ,NULL ,
+'','','div','mod_ResultList.js','../../lib/resultGeometryListController.js, ../../lib/resultGeometryListModel.js','mapframe1','','' 
+from gui_element WHERE 
+gui_element.e_id = 'gazetteerWFS' AND 
+gui_element.fkey_gui_id 
+NOT IN (SELECT fkey_gui_id FROM gui_element WHERE e_id = 'resultList');
+
+
+--
+-- add jq_ui_dialog to applications with element gazetteerWFS
+--
+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)  
+Select gui_element.fkey_gui_id ,'jq_ui_dialog',5,1,'Dialog from jQuery UI framework','','','','',NULL ,NULL ,NULL ,NULL ,NULL ,
+'','','','../plugins/jq_ui_dialog.js','../extensions/jquery-ui-1.7.2.custom/development-bundle/ui/min.ui.dialog.js','','jq_ui','' 
+from gui_element WHERE 
+gui_element.e_id = 'gazetteerWFS' AND 
+gui_element.fkey_gui_id 
+NOT IN (SELECT fkey_gui_id FROM gui_element WHERE e_id = 'jq_ui_dialog');
+
+
+--
+-- add jq_ui to applications with element gazetteerWFS
+--
+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) 
+Select gui_element.fkey_gui_id ,'jq_ui',1,1,'The jQuery UI core','','','','',NULL ,NULL ,NULL ,NULL ,NULL ,'','',
+'','','../extensions/jquery-ui-1.7.2.custom/development-bundle/ui/min.ui.core.js','','',''
+from gui_element WHERE 
+gui_element.e_id = 'gazetteerWFS' AND 
+gui_element.fkey_gui_id 
+NOT IN (SELECT fkey_gui_id FROM gui_element WHERE e_id = 'jq_ui');
+
+
+--
+-- add jq_datatables to applications with element gazetteerWFS
+--
+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) 
+Select gui_element.fkey_gui_id ,
+'jq_datatables',1,1,'Includes the jQuery plugin datatables, use like this
+$(selector).datatables(options)','','','','',NULL ,NULL ,NULL ,NULL ,NULL ,'','','','../plugins/jq_datatables.js','../extensions/dataTables-1.5/media/js/jquery.dataTables.min.js','','','http://www.datatables.net/' 
+from gui_element WHERE 
+gui_element.e_id = 'gazetteerWFS' AND 
+gui_element.fkey_gui_id 
+NOT IN (SELECT fkey_gui_id FROM gui_element WHERE e_id = 'jq_datatables');
+
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) 
+SELECT gui_element.fkey_gui_id, 'jq_datatables','defaultCss', '../extensions/dataTables-1.5/media/css/demo_table_jui.css', '' ,'file/css'
+from gui_element 
+WHERE 
+gui_element.e_id = 'jq_datatables' AND 
+gui_element.fkey_gui_id 
+NOT IN (SELECT fkey_gui_id FROM gui_element_vars WHERE fkey_e_id = 'jq_datatables' AND var_name = 'defaultCss');
+
+