get("mb_user_id"); require_once (dirname(__FILE__) . "/../classes/class_wms.php"); ?> '; echo ''; ?> Edit GUI WMS "; } return $text; } ?> get("mb_user_id"); #delete gui_wms from gui if ($del && $del == 'true') { $sql = "SELECT DISTINCT gui_wms_position from gui_wms WHERE fkey_gui_id = $1 and fkey_wms_id = $2"; $v = array ( $guiList, $wmsList ); $t = array ( 's', 'i' ); $res = db_prep_query($sql, $v, $t); $cnt = 0; while ($row = db_fetch_array($res)) { $wms_position = $row["gui_wms_position"]; $cnt++; } #if($cnt > 1){die("Error: WMS (ID) not unique!");} $sql = "Delete from gui_wms where fkey_gui_id = $1 and fkey_wms_id = $2 "; $v = array ( $guiList, $wmsList ); $t = array ( 's', 'i' ); $res = db_prep_query($sql, $v, $t); $sql = "Delete from gui_layer where fkey_gui_id = $1 and gui_layer_wms_id = $2"; $v = array ( $guiList, $wmsList ); $t = array ( 's', 'i' ); $res = db_prep_query($sql, $v, $t); $del = 'false'; $sql = "UPDATE gui_wms SET gui_wms_position = (gui_wms_position - 1) WHERE gui_wms_position > $1"; $sql .= " AND fkey_gui_id = $2 "; $v = array ( $wms_position, $guiList ); $t = array ( 'i', 's' ); $res = db_prep_query($sql, $v, $t); unset ($wmsList); } #update gui_wms_position if ($up && $up == 'true') { if ($wmsList != "") { $sql = "SELECT gui_wms_position "; $sql .= "FROM gui_wms WHERE fkey_gui_id = $1 AND fkey_wms_id = $2"; $v = array ( $guiList, $wmsList ); $t = array ( 's', 'i' ); $res = db_prep_query($sql, $v, $t); if ($row = db_fetch_array($res)) { $wms_position = $row["gui_wms_position"]; } } if ($wms_position > 0) { $sql = "UPDATE gui_wms SET "; $sql .= "gui_wms_position = $1"; $sql .= " WHERE fkey_gui_id = $2 AND fkey_wms_id = $3"; $v = array ( ($wms_position -1 ), $guiList, $wmsList); $t = array ( 'i', 's', 'i' ); $res = db_prep_query($sql, $v, $t); $sql = "UPDATE gui_wms SET "; $sql .= "gui_wms_position = $1"; $sql .= " WHERE gui_wms_position = $2 AND fkey_gui_id = $3 AND fkey_wms_id <> $4 "; $v = array ( $wms_position, ($wms_position -1 ), $guiList, $wmsList); $t = array ( 'i', 'i', 's', 'i' ); $res = db_prep_query($sql, $v, $t); } } if ($down && $down == 'true') { $max = 0; if ($wmsList != "") { $sql = "SELECT gui_wms_position "; $sql .= "FROM gui_wms WHERE fkey_gui_id = $1 AND fkey_wms_id = $2"; $v = array ( $guiList, $wmsList ); $t = array ( 's', 'i' ); $res = db_prep_query($sql, $v, $t); if ($row = db_fetch_array($res)) { $wms_position = $row["gui_wms_position"]; } $sql = "SELECT MAX(gui_wms_position) as max FROM gui_wms WHERE fkey_gui_id = $1 "; $v = array ( $guiList ); $t = array ( 's' ); $res = db_prep_query($sql, $v, $t); if ($row = db_fetch_array($res)) { $max = $row["max"]; } } if ($wms_position < $max) { $sql = "UPDATE gui_wms SET "; $sql .= "gui_wms_position = $1"; $sql .= " WHERE fkey_gui_id = $2 AND fkey_wms_id = $3"; $v = array ( ($wms_position +1 ), $guiList, $wmsList); $t = array ( 'i', 's', 'i' ); $res = db_prep_query($sql, $v, $t); $sql = "UPDATE gui_wms SET "; $sql .= "gui_wms_position = $1"; $sql .= " WHERE gui_wms_position = $2 AND fkey_gui_id = $3 AND fkey_wms_id <> $4"; $v = array ( $wms_position, ($wms_position +1 ), $guiList, $wmsList); $t = array ( 'i', 'i', 's', 'i' ); $res = db_prep_query($sql, $v, $t); } } /*handle Updates*/ if (isset ($update_content) && $update_content == "1") { if (isset ($this_gui_wms_epsg)) { $sql = "UPDATE gui_wms set gui_wms_epsg = $1, gui_wms_mapformat = $2, "; $sql .= "gui_wms_featureinfoformat = $3, gui_wms_exceptionformat = $4, "; $sql .= "gui_wms_visible = $5, gui_wms_opacity = $6, gui_wms_sldurl = $7 "; $sql .= "WHERE fkey_gui_id = $8 AND fkey_wms_id = $9"; $v = array ( $this_gui_wms_epsg, $this_gui_wms_mapformat, $this_gui_wms_featureinfoformat, $this_gui_wms_exceptionformat, $this_gui_wms_visible, $this_gui_wms_opacity, $this_gui_wms_sldurl, $this_gui, $this_wms ); $t = array ( 's', 's', 's', 's', 'i', 'i', 's', 's', 'i' ); $res = db_prep_query($sql, $v, $t); } else { $sql = "UPDATE gui_wms set gui_wms_mapformat = $1, "; $sql .= "gui_wms_featureinfoformat = $2, gui_wms_exceptionformat = $3, "; $sql .= "gui_wms_visible = $4, gui_wms_opacity = $5, gui_wms_sldurl = $6 "; $sql .= "WHERE fkey_gui_id = $7 AND fkey_wms_id = $8"; $v = array ( $this_gui_wms_mapformat, $this_gui_wms_featureinfoformat, $this_gui_wms_exceptionformat, $this_gui_wms_visible, $this_gui_wms_opacity, $this_gui_wms_sldurl, $this_gui, $this_wms ); $t = array ( 's', 's', 's', 'i', 'i', 's', 's', 'i' ); $res = db_prep_query($sql, $v, $t); } /* */ $cnt = 0; while (list ($key, $val) = each($_POST)) { if (preg_match("/___/", $key)) { $myKey = explode("___", $key); if ($myKey[1] != "layer_parent" && $myKey[1] != 'layer_id') { $sql = "UPDATE gui_layer SET " . $myKey[1] . " = $1 WHERE fkey_gui_id = $2 AND fkey_layer_id = $3"; $v = array ( $val, $this_gui, preg_replace("/L_/", "", $myKey[0] )); if ($myKey[1] == 'gui_layer_style') { $t = array ( 's', 's', 'i' ); } else { $t = array ( 'i', 's', 'i' ); } if (!$res = db_prep_query($sql, $v, $t)) { echo "FEHLER in ZEILE 288"; } } } } } echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; echo "GUI"; echo ""; echo "WMS-TITLE"; echo ""; echo "
"; require_once (dirname(__FILE__) . "/../classes/class_administration.php"); $admin = new administration(); $ownguis = $admin->getGuisByOwner(Mapbender :: session()->get("mb_user_id"), true); $gui_id = array (); if (count($ownguis) > 0) { for ($i = 0; $i < count($ownguis); $i++) { $gui_id[$i] = $ownguis[$i]; } } echo ""; echo ""; $sql = "SELECT * from gui_wms JOIN gui ON gui_wms.fkey_gui_id = gui.gui_id JOIN wms ON "; $sql .= "gui_wms.fkey_wms_id = wms.wms_id AND gui_wms.fkey_gui_id=gui.gui_id WHERE gui.gui_id = $1 ORDER BY gui_wms_position"; $v = array ( $selected_gui_id ); $t = array ( 's' ); $res = db_prep_query($sql, $v, $t); $count_wms = 0; # WMS select box on right side echo ""; echo ""; echo ""; echo "

"; echo ""; echo "

"; $may_delete = !isset($wmsList); //TODO - check if the other application is not the same if (isset($wmsList)) { // check if user is not owner of the wms or if the wms is still referenced in another own application $sql = <<"; echo ""; } else { echo "Bitte benutzen Sie !Vollständig Löschen! um den WMS vollständig zu entfernen."; } echo "
"; if (isset ($wmsList)) { #gui_wms $sql_gw = "SELECT * FROM gui_wms WHERE fkey_gui_id = $1 AND fkey_wms_id = $2"; $v = array ( $guiList, $wmsList ); $t = array ( 's', 'i' ); $res_gw = db_prep_query($sql_gw, $v, $t); $cnt_gw = 0; while ($row = db_fetch_array($res_gw)) { $gui_wms_position[$cnt_gw] = $row["gui_wms_position"]; $gui_wms_mapformat[$cnt_gw] = $row["gui_wms_mapformat"]; $gui_wms_featureinfoformat[$cnt_gw] = $row["gui_wms_featureinfoformat"]; $gui_wms_exceptionformat[$cnt_gw] = $row["gui_wms_exceptionformat"]; $gui_wms_epsg[$cnt_gw] = $row["gui_wms_epsg"]; $gui_wms_visible[$cnt_gw] = $row["gui_wms_visible"]; $gui_wms_opacity[$cnt_gw] = $row["gui_wms_opacity"]; $gui_wms_sldurl[$cnt_gw] = $row["gui_wms_sldurl"]; # sld url $cnt_gw++; } #wms $sql_w = "SELECT * FROM wms WHERE wms_id = $1"; $v = array ( $wmsList ); $t = array ( 'i' ); $res_w = db_prep_query($sql_w, $v, $t); $cnt_w = 0; while ($row = db_fetch_array($res_w)) { $wms_id[$cnt_w] = $row["wms_id"]; $wms_version[$cnt_w] = $row["wms_version"]; $wms_title[$cnt_w] = $row["wms_title"]; $wms_abstract[$cnt_w] = htmlentities($row["wms_abstract"], ENT_QUOTES, "UTF-8"); $wms_getcapabilities[$cnt_w] = $row["wms_getcapabilities"]; $wms_supportsld[$cnt_w] = $row["wms_supportsld"]; # Buttons zum sld support anzeigen? $cnt_w++; } #wms_format $sql_wf = "SELECT * FROM wms_format WHERE fkey_wms_id = $1"; $v = array ( $wmsList ); $t = array ( 'i' ); $res_wf = db_prep_query($sql_wf, $v, $t); $cnt_wf = 0; while ($row = db_fetch_array($res_wf)) { $data_type[$cnt_wf] = $row["data_type"]; $data_format[$cnt_wf] = $row["data_format"]; $cnt_wf++; } #gui_layer $sql_gl = "SELECT l.*, gl.*, sld.sld_user_layer_id, sld.use_sld FROM layer AS l, gui_layer AS gl left outer join sld_user_layer AS sld on sld.fkey_layer_id = gl.fkey_layer_id WHERE l.layer_id = gl.fkey_layer_id AND gl.gui_layer_wms_id = $1 AND gl.fkey_gui_id = $2 AND (sld.fkey_gui_id = $3 or sld.fkey_gui_id is NULL) AND (sld.fkey_mb_user_id = $4 or sld.fkey_mb_user_id is NULL) ORDER BY l.layer_pos"; $v = array ( $wmsList, $guiList, $guiList, $mb_user_id ); $t = array ( 'i', 's', 's', 'i' ); $res_gl = db_prep_query($sql_gl, $v, $t); $gui_layer_status = array (); $gui_layer_title = array (); $gui_layer_selectable = array (); $gui_layer_visible = array (); $gui_layer_queryable = array (); $gui_layer_querylayer = array (); $gui_layer_minscale = array (); $gui_layer_maxscale = array (); $gui_layer_priority = array (); $gui_layer_style = array (); $gui_layer_wfs_featuretype = array (); $layer_maxscale = array (); $layer_id = array (); $layer_parent = array (); $layer_name = array (); $layer_title = array (); $layer_queryable = array (); $layer_minscale = array (); $layer_maxscale = array (); $sld_user_layer_id = array (); $use_sld = array (); while ($row = db_fetch_array($res_gl)) { array_push($gui_layer_status, $row["gui_layer_status"]); array_push($gui_layer_title, $row["gui_layer_title"]); array_push($gui_layer_selectable, $row["gui_layer_selectable"]); array_push($gui_layer_visible, $row["gui_layer_visible"]); array_push($gui_layer_queryable, $row["gui_layer_queryable"]); array_push($gui_layer_querylayer, $row["gui_layer_querylayer"]); array_push($gui_layer_minscale, $row["gui_layer_minscale"]); array_push($gui_layer_maxscale, $row["gui_layer_maxscale"]); array_push($gui_layer_priority, $row["gui_layer_priority"]); array_push($gui_layer_style, $row["gui_layer_style"]); array_push($gui_layer_wfs_featuretype, $row["gui_layer_wfs_featuretype"]); array_push($layer_id, $row["layer_id"]); array_push($layer_parent, $row["layer_parent"]); array_push($layer_name, $row["layer_name"]); array_push($layer_title, $row["layer_title"]); array_push($layer_queryable, $row["layer_queryable"]); array_push($layer_minscale, $row["layer_minscale"]); array_push($layer_maxscale, $row["layer_maxscale"]); array_push($sld_user_layer_id, $row["sld_user_layer_id"]); array_push($use_sld, $row["use_sld"]); } #layer_epsg $sql_le = "SELECT * FROM layer_epsg WHERE fkey_layer_id = $1"; $v = array ( $layer_id[0] ); $t = array ( 'i' ); $res_le = db_prep_query($sql_le, $v, $t); $cnt_le = 0; while ($row = db_fetch_array($res_le)) { $epsg[$cnt_le] = $row["epsg"]; $cnt_le++; } # Save button echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; #epsg if ($gui_wms_position[0] == 0) { echo ""; echo ""; echo ""; } #format echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; # visibility echo ""; echo ""; echo ""; # opacity echo ""; echo ""; echo ""; # sld support if ($wms_supportsld[0]) { echo ""; echo ""; echo ""; } else { echo ""; } echo "
"; echo "LINK: Capabilities"; echo "WMS ID: " . $wms_id[0] . "
EPSG: "; echo ""; echo "
Mapformat: "; echo ""; echo "
Infoformat: "; echo ""; echo "
Exceptionformat: "; echo ""; echo "
Visibility: "; echo ""; echo "
Opacity: "; echo ""; echo "
SLD-URL: "; echo ""; #echo ""; #$layer_names = implode(",", $layer_name); echo " SLD laden/anzeigen"; echo "

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; if ($wms_supportsld[0]) { echo ""; } echo ""; #echo ""; echo ""; for ($i = 0; $i < count($layer_id); $i++) { #layer_styles $sql_styles = "SELECT * FROM layer_style WHERE fkey_layer_id = $1"; $v = array ( $layer_id[$i] ); $t = array ( 'i' ); $res_styles = db_prep_query($sql_styles, $v, $t); $cnt_styles = 0; $style = array (); while ($row = db_fetch_array($res_styles)) { $style[$cnt_styles] = $row["name"]; $cnt_styles++; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; /**/ echo "\n"; /**/ echo "\n"; /* wfs configuration */ echo ""; if ($wms_supportsld[0]) { echo ""; } echo "\n"; if ($i == 0) { echo ""; } } echo "
Nr.ID" . toImage('Parent') . "NameTitle" . toImage('on/off') . "" . toImage('sel') . "" . toImage('sel_default') . "" . toImage('info') . "" . toImage('info_default') . "" . toImage('minScale 1:') . "" . toImage('maxScale 1:') . "" . toImage('Style') . "" . toImage('Prio') . "" . toImage('setWFS') . "" . toImage('SLD') . "
Nr.IDParentNameTitleon/offselsel_defaultinfoinfo_defaultminScale 1:maxScale 1:PriosetWFS
"; echo ""; echo ""; echo " "; echo ""; echo ""; echo " "; echo ""; echo "
\n"; echo ""; if ($i > 0) { echo ""; } echo ""; if ($i > 0) { echo ""; } echo "

\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; } ?>