From MapbenderWiki

User:Christoph Baudson (Module maintainer)

Contents 1 wms -> category 1.1 files 1.2 database 1.3 SQL 1.4 element vars 2 layer -> category 2.1 files 2.2 database 2.3 SQL 2.4 element vars 3 moved from version history 3.1 filteredWms_topic *- myWMS -> topic

wms -> category

this module allows the administrator to sort wms into categories.

files

https://mapbender.osgeo.org/source/browse/mapbender/trunk/mapbender/http/php/mod_filteredWms_topic.php

database

table md_topic_category

CREATE TABLE md_topic_category ( md_topic_category_id serial, md_topic_category_code_en varchar(255), md_topic_category_code_de varchar(255), CONSTRAINT md_topic_category_pkey PRIMARY KEY (md_topic_category_id) ); INSERT INTO md_topic_category VALUES (1, 'farming', 'Landwirtschaft'); INSERT INTO md_topic_category VALUES (2, 'biota', 'Biotope'); INSERT INTO md_topic_category VALUES (3, 'boundaries', 'Grenzen'); INSERT INTO md_topic_category VALUES (4, 'climatologyMeteorologyAtmosphere', 'Wetterkunde'); INSERT INTO md_topic_category VALUES (5, 'economy', 'Wirtschaft'); INSERT INTO md_topic_category VALUES (6, 'elevation', 'Höhendaten'); INSERT INTO md_topic_category VALUES (7, 'environment', 'Umwelt'); INSERT INTO md_topic_category VALUES (8, 'geoscientificInformation', 'Geowissenschaft'); INSERT INTO md_topic_category VALUES (9, 'health', 'Gesundheit'); INSERT INTO md_topic_category VALUES (10, 'imageryBaseMapsEarthCover', 'Grundlagenkarten'); INSERT INTO md_topic_category VALUES (11, 'intelligenceMilitary', 'militärische Aufklärung'); INSERT INTO md_topic_category VALUES (12, 'inlandWaters', 'Binnengewässer'); INSERT INTO md_topic_category VALUES (13, 'location', 'Ortsinformationen'); INSERT INTO md_topic_category VALUES (14, 'oceans', 'Meereskunde'); INSERT INTO md_topic_category VALUES (15, 'planningCadastre', 'Landnutzung/Planung/Kataster'); INSERT INTO md_topic_category VALUES (16, 'society', 'Gesellschaft'); INSERT INTO md_topic_category VALUES (17, 'structure', 'Bauwerke'); INSERT INTO md_topic_category VALUES (18, 'transportation', 'Transportwesen'); INSERT INTO md_topic_category VALUES (19, 'utilitiesCommunication', 'Infrastruktur');

table wms_md_topic_category

CREATE TABLE wms_md_topic_category ( fkey_wms_id int4 NOT NULL, fkey_md_topic_category_id int4 NOT NULL, CONSTRAINT wms_md_topic_category_fkey_md_topic_category_id_fkey FOREIGN KEY (fkey_md_topic_category_id) REFERENCES md_topic_category (md_topic_category_id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE, CONSTRAINT wms_md_topic_category_fkey_wms_id_fkey FOREIGN KEY (fkey_wms_id) REFERENCES wms (wms_id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE );

SQL

INSERT INTO gui_element(fkey_gui_id, e_id, e_pos, e_public, e_comment, 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('admin1','filteredWms_topic',2,1,'allocate topics to wms of this user','a','','href = "../php/mod_filteredWms_topic.php?sessionID&e_id_css=filteredWms_topic" target = "AdminFrame" ',10,1750,200,20,NULL ,'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;','myWMS -> topic','a','','','','AdminFrame','http://www.mapbender.org/index.php/user'); INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('admin1', 'filteredWms_topic', 'file css', '../css/administration_alloc.css', 'css' ,'file/css');

element vars

language specifies the language of the topics; 'en' for english, 'de' for german.

INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('admin1', 'filteredWms_topic', 'language', 'de', '' ,'php_var');

layer -> category

this module allows the administrator to sort layers into categories.

files

https://mapbender.osgeo.org/source/browse/mapbender/trunk/mapbender/http/php/mod_filteredWms_layer_topic.php

database

table md_topic_category

CREATE TABLE md_topic_category ( md_topic_category_id serial, md_topic_category_code_en varchar(255), md_topic_category_code_de varchar(255), CONSTRAINT md_topic_category_pkey PRIMARY KEY (md_topic_category_id) ); INSERT INTO md_topic_category VALUES (1, 'farming', 'Landwirtschaft'); INSERT INTO md_topic_category VALUES (2, 'biota', 'Biotope'); INSERT INTO md_topic_category VALUES (3, 'boundaries', 'Grenzen'); INSERT INTO md_topic_category VALUES (4, 'climatologyMeteorologyAtmosphere', 'Wetterkunde'); INSERT INTO md_topic_category VALUES (5, 'economy', 'Wirtschaft'); INSERT INTO md_topic_category VALUES (6, 'elevation', 'Höhendaten'); INSERT INTO md_topic_category VALUES (7, 'environment', 'Umwelt'); INSERT INTO md_topic_category VALUES (8, 'geoscientificInformation', 'Geowissenschaft'); INSERT INTO md_topic_category VALUES (9, 'health', 'Gesundheit'); INSERT INTO md_topic_category VALUES (10, 'imageryBaseMapsEarthCover', 'Grundlagenkarten'); INSERT INTO md_topic_category VALUES (11, 'intelligenceMilitary', 'militärische Aufklärung'); INSERT INTO md_topic_category VALUES (12, 'inlandWaters', 'Binnengewässer'); INSERT INTO md_topic_category VALUES (13, 'location', 'Ortsinformationen'); INSERT INTO md_topic_category VALUES (14, 'oceans', 'Meereskunde'); INSERT INTO md_topic_category VALUES (15, 'planningCadastre', 'Landnutzung/Planung/Kataster'); INSERT INTO md_topic_category VALUES (16, 'society', 'Gesellschaft'); INSERT INTO md_topic_category VALUES (17, 'structure', 'Bauwerke'); INSERT INTO md_topic_category VALUES (18, 'transportation', 'Transportwesen'); INSERT INTO md_topic_category VALUES (19, 'utilitiesCommunication', 'Infrastruktur');

table layer_md_topic_category

CREATE TABLE layer_md_topic_category ( fkey_layer_id int4 NOT NULL, fkey_md_topic_category_id int4 NOT NULL, CONSTRAINT layer_md_topic_category_fkey_md_topic_category_id_fkey FOREIGN KEY (fkey_md_topic_category_id) REFERENCES md_topic_category (md_topic_category_id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE, CONSTRAINT layer_md_topic_category_fkey_layer_id_fkey FOREIGN KEY (fkey_layer_id) REFERENCES layer (layer_id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE );

SQL

INSERT INTO gui_element(fkey_gui_id, e_id, e_pos, e_public, e_comment, 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('admin1','filteredWms_layer_topic',2,1,'allocate topics to layers of wms of this user','a','','href = "../php/mod_filteredWms_layer_topic.php?sessionID&e_id_css=filteredWms_layer_topic" target = "AdminFrame" ',10,1750,200,20,NULL ,'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;','myWMS -> layer','a','','','','AdminFrame','http://www.mapbender.org/index.php/user'); INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('admin1', 'filteredWms_layer_topic', 'file css', '../css/administration_alloc_4.css', 'css' ,'file/css');

element vars

language specifies the language of the topics; 'en' for english, 'de' for german.

INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('admin1', 'filteredWms_layer_topic', 'language', 'de', '' ,'php_var');

moved from version history

filteredWms_topic *- myWMS -> topic

• position admin1
• andere admin gui?
• was ist mit diesem Modul?
• hat noch Fehler, Uli fragen

INSERT INTO gui_element(fkey_gui_id, e_id, e_pos, e_public, e_comment, 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('admin1','filteredWms_topic',2,1,'allocate topics to wms of this user','a','','href = "../php/mod_filteredWms_topic.php?sessionID&e_id_css=filteredWms_topic" target = "AdminFrame" ',10,950,200,20,NULL ,'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;','myWMS -> topic','a','','','','AdminFrame','http://www.mapbender.org/index.php/user'); INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('admin1', 'filteredWms_topic', 'file css', '../css/administration_alloc.css', 'css' ,'file/css');

• Fehler

Warning: in_array() [function.in-array]: Wrong datatype for second argument in d:\umn\svn_mb241_rc1\http\php\mod_filteredwms_topic.php on line 135