Edit GUI WMS

'; ?> Edit GUI WMS "; } return $text; } ?> 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($_REQUEST)){ 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($_SESSION["mb_user_id"],true); $gui_id =array(); if (count($ownguis)>0){ for($i=0; $i"; $selected_gui_id=""; for ($i=0; $i".$gui_id[$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; echo ""; echo "	"; echo ""; echo " "; echo ""; echo " "; echo ""; echo ""; 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_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_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++; } 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"; 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.

" . toImage('Parent') . "

Name

Title

" . 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.

Parent

Name

Title

on/off

sel

sel_default

info

info_default

minScale 1:

maxScale 1:

Prio

setWFS

"; echo ""; echo "

"; echo " "; echo ""; echo"

"; echo " "; echo ""; echo "

\n"; echo "

"; if ($i > 0) { echo ""; } echo "

\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "

\n"; } ?>