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

[svn_mapbender at osgeo.org]

Author: verenadiewald
Date: 2012-09-13 01:13:45 -0700 (Thu, 13 Sep 2012)
New Revision: 8486

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.3_to_2.7.4_pgsql_UTF-8.sql
Log:
update sqls for integration of TableTools extension in resultList

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.3_to_2.7.4_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.3_to_2.7.4_pgsql_UTF-8.sql	2012-09-07 07:52:59 UTC (rev 8485)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.3_to_2.7.4_pgsql_UTF-8.sql	2012-09-13 08:13:45 UTC (rev 8486)
@@ -1,3 +1,31 @@
 -- new file for db changes to 2.7.4
 ALTER TABLE wms ADD COLUMN wms_max_imagesize INTEGER DEFAULT 1000;
 ALTER TABLE wfs ADD COLUMN wfs_max_features INTEGER DEFAULT 1000;
+
+-- new element_var tableTools for element resultList
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
+SELECT gui_element.fkey_gui_id,
+'resultList', 'tableTools', '[
+      {
+	      "sExtends": "xls",
+	      "sButtonText": "Export to CSV",
+	      "sFileName": "result.csv"
+      }
+]', 'set the initialization options for tableTools' ,'var' 
+from gui_element
+WHERE
+gui_element.e_id = 'resultList' AND
+gui_element.fkey_gui_id
+NOT IN (SELECT fkey_gui_id FROM gui_element_vars WHERE fkey_e_id = 'resultList' AND var_name = 'tableTools');
+
+--update jq_datatables element (new dataTables version + TableTools extension)
+UPDATE gui_element set e_mb_mod = '../extensions/dataTables-1.7.5/media/js/jquery.dataTables.min.js,../extensions/dataTables-1.7.5/extras/TableTools-2.0.0/media/js/TableTools.min.js' WHERE e_id = 'jq_datatables';
+
+--update css file of dataTables in body element
+UPDATE gui_element_vars set var_value = '../extensions/dataTables-1.7.5/media/css/demo_table_jui.css' WHERE fkey_e_id = 'body' AND var_name = 'jq_datatables_css';
+
+
+
+
+
+