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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2018-05-04 02:00:26 -0700 (Fri, 04 May 2018)
New Revision: 9907

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
New option to list categories in wfs search view

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2018-05-04 08:52:27 UTC (rev 9906)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2018-05-04 09:00:26 UTC (rev 9907)
@@ -2407,7 +2407,7 @@
 CREATE OR REPLACE VIEW search_wfs_view AS 
 
 
-SELECT wfs_new.featuretype_id, wfs_new.featuretype_srs, wfs_new.featuretype_title, wfs_new.featuretype_abstract, wfs_new.featuretype_latlon_bbox, wfs_new.element_type, wfs_new.featuretype_latlon_array, wfs_new.wfs_id, f_get_availability_of_ressource(wfs_new.wfs_id ,'wfs') as availability,  f_get_status_of_ressource(wfs_new.wfs_id ,'wfs') as status, wfs_new.wfs_title, wfs_new.wfs_abstract, wfs_new.wfs_timestamp_create, wfs_new.wfs_timestamp, wfs_new.wfs_network_access, wfs_new.wfs_pricevolume, wfs_new.wfs_proxylog, wfs_new.wfs_owner, wfs_new.country, wfs_new.administrativearea, wfs_new.accessconstraints, wfs_new.fkey_mb_group_id, wfs_new.orga_id, wfs_new.the_geom, wfs_new.bbox, wfs_new.searchtext, wfs_new.wfs_conf_id, wfs_new.wfs_conf_abstract, wfs_new.wfs_conf_description, wfs_new.modultype, wfs_new.department, wfs_new.mb_group_name, wfs_new.mb_group_logo_path, wfs_new.fkey_termsofuse_id, termsofuse.isopen
+SELECT wfs_new.featuretype_id, wfs_new.featuretype_srs, wfs_new.featuretype_title, wfs_new.featuretype_abstract, wfs_new.featuretype_latlon_bbox, wfs_new.element_type, wfs_new.featuretype_latlon_array, wfs_new.wfs_id,  f_collect_custom_cat_wfs_featuretype(wfs_new.featuretype_id) AS md_custom_cats, f_collect_inspire_cat_wfs_featuretype(wfs_new.featuretype_id) AS md_inspire_cats, f_collect_topic_cat_wfs_featuretype(wfs_new.featuretype_id) AS md_topic_cats, f_get_availability_of_ressource(wfs_new.wfs_id ,'wfs') as availability,  f_get_status_of_ressource(wfs_new.wfs_id ,'wfs') as status, wfs_new.wfs_title, wfs_new.wfs_abstract, wfs_new.wfs_timestamp_create, wfs_new.wfs_timestamp, wfs_new.wfs_network_access, wfs_new.wfs_pricevolume, wfs_new.wfs_proxylog, wfs_new.wfs_owner, wfs_new.country, wfs_new.administrativearea, wfs_new.accessconstraints, wfs_new.fkey_mb_group_id, wfs_new.orga_id, wfs_new.the_geom, wfs_new.bbox, wfs_new.searchtext, wfs_new.wfs_conf_id, wfs_new.wfs_conf_abstract, wf
 s_new.wfs_conf_description, wfs_new.modultype, wfs_new.department, wfs_new.mb_group_name, wfs_new.mb_group_logo_path, wfs_new.fkey_termsofuse_id, termsofuse.isopen
    FROM ( SELECT wfs_table.featuretype_id, wfs_table.featuretype_srs, wfs_table.featuretype_title, wfs_table.featuretype_abstract, wfs_table.featuretype_latlon_bbox, wfs_table.element_type, wfs_table.featuretype_latlon_array, wfs_table.wfs_id, wfs_table.wfs_title, wfs_table.wfs_abstract, wfs_table.wfs_timestamp_create, wfs_table.wfs_timestamp, wfs_table.wfs_network_access, wfs_table.wfs_pricevolume, wfs_table.wfs_proxylog, wfs_table.wfs_owner, wfs_table.country, wfs_table.administrativearea, wfs_table.accessconstraints, wfs_table.fkey_mb_group_id, wfs_table.orga_id, wfs_table.the_geom, wfs_table.bbox, wfs_table.searchtext, wfs_table.wfs_conf_id, wfs_table.wfs_conf_abstract, wfs_table.wfs_conf_description, wfs_table.modultype, wfs_table.department, wfs_table.mb_group_name, wfs_table.mb_group_logo_path, wfs_termsofuse.fkey_termsofuse_id
            FROM ( SELECT wfs_info.featuretype_id, wfs_info.featuretype_srs, wfs_info.featuretype_title, wfs_info.featuretype_abstract, wfs_info.featuretype_latlon_bbox, wfs_info.element_type, wfs_info.featuretype_latlon_array, wfs_info.wfs_id, wfs_info.wfs_title, wfs_info.wfs_abstract, wfs_info.wfs_timestamp_create, wfs_info.wfs_timestamp, wfs_info.wfs_network_access, wfs_info.wfs_pricevolume, wfs_info.wfs_proxylog, wfs_info.wfs_owner, wfs_info.country, wfs_info.administrativearea, wfs_info.accessconstraints, wfs_info.fkey_mb_group_id, wfs_info.orga_id, wfs_info.the_geom, wfs_info.bbox, wfs_info.searchtext, wfs_info.wfs_conf_id, wfs_info.wfs_conf_abstract, wfs_info.wfs_conf_description, wfs_info.modultype, mb_group.mb_group_id AS department, mb_group.mb_group_name, mb_group.mb_group_logo_path
                    FROM ( SELECT featuretype.featuretype_id, featuretype.featuretype_srs, featuretype.featuretype_title, featuretype.featuretype_abstract, featuretype.featuretype_latlon_bbox, featuretype.element_type, featuretype.featuretype_latlon_array, featuretype.wfs_id, featuretype.wfs_title, featuretype.wfs_abstract, featuretype.wfs_timestamp_create, featuretype.wfs_timestamp, featuretype.wfs_network_access, featuretype.wfs_pricevolume, featuretype.wfs_proxylog, featuretype.wfs_owner, featuretype.country, featuretype.administrativearea, featuretype.accessconstraints, featuretype.fkey_mb_group_id, featuretype.orga_id, geometryfromtext(((((((((((((((((((('POLYGON(('::text || featuretype.featuretype_latlon_array[1]) || ' '::text) || featuretype.featuretype_latlon_array[2]) || ','::text) || featuretype.featuretype_latlon_array[1]) || ' '::text) || featuretype.featuretype_latlon_array[4]) || ','::text) || featuretype.featuretype_latlon_array[3]) || ' '::text) || featuretype.feature
 type_latlon_array[4]) || ','::text) || featuretype.featuretype_latlon_array[3]) || ' '::text) || featuretype.featuretype_latlon_array[2]) || ','::text) || featuretype.featuretype_latlon_array[1]) || ' '::text) || featuretype.featuretype_latlon_array[2]) || '))'::text, 4326) AS the_geom, (((((featuretype.featuretype_latlon_array[1] || ','::text) || featuretype.featuretype_latlon_array[2]) || ','::text) || featuretype.featuretype_latlon_array[3]) || ','::text) || featuretype.featuretype_latlon_array[4] AS bbox, f_collect_searchtext_wfs(featuretype.wfs_id, featuretype.featuretype_id) AS searchtext, wfs_conf.wfs_conf_id, wfs_conf.wfs_conf_abstract, wfs_conf.wfs_conf_description, wfs_conf.wfs_conf_type AS modultype
@@ -2432,4 +2432,3 @@
 
 ALTER TABLE search_wfs_view
   OWNER TO postgres;
-