WMS Webquellen in der GINIUS Legende einfügen

INSERT INTO G3E_DATACONNECTION (
   G3E_DCNO,
   G3E_USERNAME,
   G3E_LOCATION,
   G3E_GDOTYPE,
   G3E_TYPE)
VALUES (
   4,
   'WMS - Kanton Solothurn - Verkehr',
   'http://www.sogis1.so.ch/cgi-bin/sogis/sogis_verkehr.wms?service=wms&request=getcapabilities&version=1.1.1',
   'WMS.GTDatabase',
   7);

EXECUTE G3E_DATACONNECTION_PKG.CreateOptimizedTable;

-- Hinzufuegen der neuen Raster-(WMS-) Komponente
INSERT INTO G3E_COMPONENT (
   G3E_CNO,
   G3E_USERNAME,
   G3E_NAME,
   G3E_TOOLTIP,
   G3E_TYPE,
   G3E_TABLE,
   G3E_DETAIL,
   G3E_ALIGNMENTFIELD,
   G3E_DCNO,
   G3E_GEOMETRYFIELD,
   G3E_GEOMETRYTYPE,
   G3E_LTT)
VALUES (
   3000,
   'WMS-Solothurn-Verkehr',
   'WMS-SOLOTHURN-VERKEHR',
   NULL,
   32,
   'WMS_SO_VERKEHR',
   0,
   NULL,
   4,
   'Geometry',
   'RasterGeometry',
   0);

-- Hinzufuegen des neuen Feature
INSERT INTO G3E_FEATURE (
   G3E_FNO,
   G3E_USERNAME,
   G3E_TOOLTIP,
   G3E_PRIMARYGEOGRAPHICCNO,
   G3E_PRIMARYATTRIBUTECNO,
   G3E_DCNO,
   G3E_IMPORTFEATURENAME)
VALUES (
   280,
   'WMS-Solothurn-Verkehr',
   NULL,
   3000,
   3000,
   4,
   'WMS-Solothurn-Verkehr');

-- Hinzufuegen der neuen Komponente zum neuen Feature
INSERT INTO G3E_FEATURECOMPONENT (
   G3E_FCNO,
   G3E_FNO,
   G3E_CNO,
   G3E_REQUIRED,
   G3E_REPEATING,
   G3E_AUTOREPEAT,
   G3E_PINO,
   G3E_ORDINAL,
   G3E_INSERTORDINAL,
   G3E_DELETEORDINAL)
VALUES (
   280010,
   280,
   3000,
   0,
   0,
   0,
   7,
   10,
   10,
   100);

-- Hinzufuegen der neuen (WMS-)Komponente in die ViewDefinition
INSERT INTO G3E_COMPONENTVIEWDEFINITION (
   G3E_VNO,
   G3E_VIEW,
   G3E_FNO,
   G3E_CNO,
   G3E_LENO,
   G3E_FIELDS)
VALUES (
   28000,
   'V_WMS_SO_VERKEHR',
   280,
   3000,
   NULL,
   'GEOMETRY');

-- Hinzufuegen der neuen (WMS-)Komponente in die ViewComposition
INSERT INTO G3E_COMPONENTVIEWCOMPOSITION (
   G3E_CVCNO,
   G3E_VNO,
   G3E_CNO,
   G3E_FNO)
VALUES (
   2800001,
   28000,
   3000,
   280);

-- Verknuepfen der gewuenschten WMS-Layer zur neuen Komponente
-- ACHTUNG: Intergraph verwendet hier den WMS-Layer-TITEL und nicht den NAMEN !!! 
INSERT INTO G3E_WMSLAYERS (
   G3E_WLNO,
   G3E_VIEW,
   G3E_DCNO,
   G3E_WMSREQUEST)
VALUES (
   28000,
   'V_WMS_SO_VERKEHR',
   4,
   'LAYERS=WMS_Dienst_Verkehr_des_Kanton_Solothurn&STYLES=');

-- Hinzufuegen des neuen LegendEntry fuer die neue Raster- (WMS-)Komponente
INSERT INTO G3E_LEGENDENTRY (
   G3E_LENO,
   G3E_LEGENDENTRY,
   G3E_USERNAME,
   G3E_VNO)
VALUES (
   280000000,
   'WMS-Solothurn-Verkehr',
   'WMS-Solothurn-Verkehr',
   28000);

-- Hinzufuegen des neuen LegendEntry in die gewuenschte Legende (in LegendDefinition)
INSERT INTO G3E_LD_001_D (
   G3E_LENO,
   G3E_DISPLAYORDINAL)
VALUES (
   280000000,
   990);

-- Anpassen der automatisch angelegten SettingsEintraege
UPDATE G3E_LD_001_D_SET SET
   G3E_DISPLAYMODE = 1,
   G3E_DISPLAYSCALEMIN = 1,
   G3E_DISPLAYSCALEMAX = 10000,
   G3E_USEDISPLAYSCALE = 1,
   G3E_LOCATABLE = 1
   WHERE G3E_LENO=280000000;

-- Hinzufuegen des Eintrags in die gewuenschte LegendDisplayControl
INSERT INTO G3E_LDC_001_D (
   G3E_DCROWNO,
   G3E_LEGENDITEM,
   G3E_USERNAME,
   G3E_LEVEL,
   G3E_ORDINAL,
   G3E_LEAFINDICATOR,
   G3E_ROLE)
VALUES (
   25290,
   'WMS',
   'WMS',
   2,
   25290,
   0,
   'EVERYONE');

INSERT INTO G3E_LDC_001_D (
   G3E_DCROWNO,
   G3E_LEGENDITEM,
   G3E_USERNAME,
   G3E_LEVEL,
   G3E_ORDINAL,
   G3E_LEAFINDICATOR)
VALUES (
   25300,
   'WMS-Solothurn-Verkehr',
   'WMS-Solothurn-Verkehr',
   3,
   25300,
   1);