[Mapbender-commits] r4156 - trunk/mapbender/http/php
svn_mapbender at osgeo.org
svn_mapbender at osgeo.org
Thu Jun 25 04:30:37 EDT 2009
Author: vera
Date: 2009-06-25 04:30:37 -0400 (Thu, 25 Jun 2009)
New Revision: 4156
Modified:
trunk/mapbender/http/php/mod_editWMS_Metadata.php
Log:
session var angepasst
Modified: trunk/mapbender/http/php/mod_editWMS_Metadata.php
===================================================================
--- trunk/mapbender/http/php/mod_editWMS_Metadata.php 2009-06-25 08:27:52 UTC (rev 4155)
+++ trunk/mapbender/http/php/mod_editWMS_Metadata.php 2009-06-25 08:30:37 UTC (rev 4156)
@@ -1,497 +1,497 @@
-<?php
-# $Id$
-# http://www.mapbender.org/index.php?title=Edit_WMS_Metadata
-# Copyright (C) 2002 CCGIS
-#
-# This program is free software; you can redistribute it and/or modify
-# it under the terms of the GNU General Public License as published by
-# the Free Software Foundation; either version 2, or (at your option)
-# any later version.
-#
-# This program is distributed in the hope that it will be useful,
-# but WITHOUT ANY WARRANTY; without even the implied warranty of
-# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
-# GNU General Public License for more details.
-#
-# You should have received a copy of the GNU General Public License
-# along with this program; if not, write to the Free Software
-# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
-
-require_once(dirname(__FILE__)."/mb_validatePermission.php");
-require_once(dirname(__FILE__)."/../classes/class_administration.php");
-
-include_once '../include/dyn_css.php';
-
-$adm = new administration();
-?>
-<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
-<html>
-<head>
-<title>Edit WMS Metadata</title>
-<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
-<script language="JavaScript">
-var dTarget;
-function save() {
- document.forms[0].update_content.value=1;
- document.forms[0].submit();
-}
-
-function deletepreview(layer_id) {
- var url = String(document.location);
- url = url.substr(0, url.indexOf('?'));
- window.open(url+"?<?php echo $urlParameters; ?>&delete_preview=1&layer_id="+layer_id,'delete preview', 'height=50, width=150, dependent=yes');
- document.getElementById(layer_id+"_dp").style.display="none";
-}
-
-function pick_the_date(obj) {
- dTarget = obj;
- var datePickerParameters = "m=Jan_Feb_Mrz_Apr_Mai_Jun_Jul_Aug_Sep_Okt_Nov_Dez&d=Mo_Di_Mi_Do_Fr_Sa_So&t=heute";
- var datePickerStyle = "left=200,top=200,width=230,height=210,toolbar=0,location=0,directories=0,status=0,menubar=0,scrollbars=0"
- var dp = window.open('../extensions/datepicker/datepicker.php?' + datePickerParameters,'dp',datePickerStyle);
- dp.focus();
- return false;
-}
-</script>
-</head>
-<body>
-<?php
-
-function guessTimestamp($timestr) {
-
- if (mb_strpos($timestr, '.')) {
- list($day, $month, $year) = explode(".", $timestr);
- }
- elseif (mb_strpos($timestr, '/')) {
- list($month, $day, $year) = explode("/", $timestr);
- }
- elseif (mb_strpos($timestr, '-')) {
- list($year, $month, $day) = explode("-", $timestr);
- }
- else {
- $year = 0;
- $month = 0;
- $day = 0;
- }
- return mktime(0, 0, 0, $month, $day, intval($year));
-}
-
-#Update handling
-
-if (isset($_REQUEST['update_content']) && $_REQUEST['update_content'] == true) {
-
- $update_wms_sql = "UPDATE wms SET ";
- $update_wms_sql .= "wms_title = $1, wms_abstract = $2, fees = $3, ";
- $update_wms_sql .= "accessconstraints = $4, contactperson = $5, ";
- $update_wms_sql .= "contactposition = $6, contactorganization = $7, ";
- $update_wms_sql .= "address = $8, city = $9, stateorprovince = $10, ";
- $update_wms_sql .= "postcode = $11, country = $12, ";
- $update_wms_sql .= "contactvoicetelephone = $13, ";
- $update_wms_sql .= "contactfacsimiletelephone = $14, ";
- $update_wms_sql .= "contactelectronicmailaddress = $15 ";
-
- $v = array();
- array_push($v, $_REQUEST['wms_title_box']);
- array_push($v, $_REQUEST['wms_abstract_box']);
- array_push($v, $_REQUEST['fees_box']);
- array_push($v, $_REQUEST['accessconstraints_box']);
- array_push($v, $_REQUEST['contactperson_box']);
- array_push($v, $_REQUEST['contactposition_box']);
- array_push($v, $_REQUEST['contactorganization_box']);
- array_push($v, $_REQUEST['address_box']);
- array_push($v, $_REQUEST['city_box']);
- array_push($v, $_REQUEST['stateorprovince_box']);
- array_push($v, $_REQUEST['postcode_box']);
- array_push($v, $_REQUEST['country_box']);
- array_push($v, $_REQUEST['contactvoicetelephone_box']);
- array_push($v, $_REQUEST['contactfacsimiletelephone_box']);
- array_push($v, $_REQUEST['contactelectronicmailaddress_box']);
- $t = array("s", "s", "s", "s", "s", "s", "s", "s", "s", "s", "s", "s", "s", "s", "s");
-
- if (isset($_REQUEST['wms_timestamp_box']) && $_REQUEST['wms_timestamp_box'] <> "") {
- $update_wms_sql .= ", wms_timestamp = $16 ";
- array_push($v, guessTimestamp($_REQUEST['wms_timestamp_box']));
- array_push($t, "s");
-
- $update_wms_sql .= "WHERE wms_id = $17";
- }
- else {
- $update_wms_sql .= "WHERE wms_id = $16";
- }
- array_push($v, $_REQUEST['wms_id']);
- array_push($t, "s");
-
- $res_update_wms_sql = db_prep_query($update_wms_sql, $v, $t);
-
- while(list($key,$val) = each($_REQUEST)) {
- if(preg_match("/___/", $key)) {
- $myKey = explode("___", $key);
- $layer_id = preg_replace("/L_/","",$myKey[0]);
- if($myKey[1]=="layer_abstract") {
- $layer_sql = "UPDATE layer SET layer_abstract = $1 ";
- $layer_sql .= "WHERE layer_id = $2 AND fkey_wms_id = $3";
- $v = array($val, $layer_id, $_REQUEST['wms_id']);
- $t = array("s", "i", "s");
- $res_keyword_sql = db_prep_query($layer_sql, $v, $t);
- }
- if($myKey[1]=="layer_keywords") {
- #Get all keywords depending on the given layer after user modification
- $keywords = explode(",",$val);
- #delete all blanks from the keywords list
- for ($j = 0; $j < count($keywords); $j++) {
- $word = $keywords[$j];
- $word = trim($word);
- $keywords[$j] = $word;
- }
- #echo "1: Keywords eines Layers: id des Layers: ", $layer_id, ", �bergebener String: ", $val, ";<br>";
- #Get all keywords depending on this layer from database
- $keyword_sql = "SELECT keyword_id, keyword FROM keyword, layer_keyword, layer " .
- "WHERE keyword.keyword_id = layer_keyword.fkey_keyword_id " .
- "AND layer_keyword.fkey_layer_id = layer.layer_id " .
- "AND layer.fkey_wms_id = $1 " .
- "AND layer.layer_id = $2";
-
- $v = array($_REQUEST['wms_id'], $layer_id);
- $t = array("s", "i");
- $res_keyword_sql = db_prep_query($keyword_sql, $v, $t);
- while($keyword_row = db_fetch_array($res_keyword_sql))
- {
- $keyword = $keyword_row['keyword'];
- $keyword_id = $keyword_row['keyword_id'];
- #keyword has been deleted or has been modified
- #keyword exists in database but not in user data
- $index = -1;
- #echo "1a: Abfrage ob DB Keywords in User Liste: Keyword: ", $keyword, ";<br>";
- if(in_array($keyword, $keywords) == false)
- {
- #echo "1c: Keyword nicht in User Liste: Keyword: ", $keyword, ";<br>";
- #Deleting reference to the keyword from the layer_keyword table.
- $keyword_sql = "DELETE FROM layer_keyword " .
- "WHERE fkey_layer_id = $1 " .
- "AND fkey_keyword_id = $2";
- $v = array($layer_id, $keyword_id);
- $t = array("i", "i");
- db_prep_query($keyword_sql, $v, $t);
- #Checking, if the keyword is in use by any layer
- $layer_sql = "SELECT * FROM layer_keyword " .
- "WHERE fkey_keyword_id = $1";
- $v = array($keyword_id);
- $t = array("i");
- $res_layer_sql = db_prep_query($layer_sql, $v, $t);
- if(!($row = db_fetch_array($res_layer_sql)))
- {
- #If keyword will not longer be in use, delete it from keyword table
- $keyword_sql = "DELETE FROM keyword " .
- "WHERE keyword_id = $1";
- $v = array($keyword_id);
- $t = array("i");
- db_prep_query($keyword_sql, $v, $t);
- }
- }
- #Keyword exists in the database and in the user data
- else
- {
- #echo "1d: Keyword ist in User Liste: Keyword: ", $keyword, ";<br>";
- for($i = 0; $i < count($keywords); $i++)
- {
- #Delete keyword from the user data list, because the data
- #have not to be updated within the database
- if($keywords[$i] == $keyword)
- {
- $keywords[$i] = null;
- }
- }
- }
- }
- #Inserting keyword, that are not existing in the database
- for($i = 0; $i < count($keywords); $i++)
- {
- #echo "2: Alle Eintr�ge des Keyword arrays: Keyword: ", $keywords[$i], "; Index: ", $i, ";<br>";
- if($keywords[$i] != null)
- {
- #echo "3: Eintr�ge ungleich null: Keyword: ", $keywords[$i], "; Index: ", $i, ";<nr>";
- $keyword = trim($keywords[$i]);
- #Check, if the keyword is exsiting in the database
- $keyword_sql = "SELECT keyword_id FROM keyword " .
- "WHERE UPPER(keyword) = UPPER($1)";
- $v = array($keyword);
- $t = array("s");
- $res_keyword_sql = db_prep_query($keyword_sql, $v, $t);
- $keyword_row = db_fetch_array($res_keyword_sql);
- #Keyword exists in the database
- if($keyword_row != null)
- {
- $keyword_id = $keyword_row[0];
- #echo "4: Keyword in Datenbank vorhanden: id des Keywords: ", $keyword_id, ";<br>";
- }
- #Keyword does not exist in the database
- else
- {
- $keyword_sql = "INSERT INTO keyword (keyword) VALUES ($1)";
- $v = array($keyword);
- $t = array("s");
- $res_keyword_sql = db_prep_query($keyword_sql, $v, $t);
-
- $keyword_sql = "SELECT keyword_id FROM keyword WHERE keyword = $1";
- $v = array($keyword);
- $t = array("s");
- $res_keyword_sql = db_prep_query($keyword_sql, $v, $t);
- $keyword_row = db_fetch_array($res_keyword_sql);
- if($keyword_row != null)
- {
- $keyword_id = $keyword_row[0];
- #echo "4: Keyword in der Datenbank nicht vorhanden: id des Keywords: ", $keyword_id, ";<br>";
- }
- }
- #Inserting the reference between layer and keyword in the layer_keyword table
- $keyword_sql = "INSERT INTO layer_keyword (fkey_layer_id, fkey_keyword_id) " .
- "VALUES ($1, $2)";
- $v = array($layer_id, $keyword_id);
- $t = array("s", "s");
- $res_keyword_sql = db_prep_query($keyword_sql, $v, $t);
- }
- }
- #Delete all elements from array
- unset($keywords);
- }
- }
- }
-}
-unset($update_content);
-
-#delete preview
-
-if(isset($_REQUEST['delete_preview']) && $_REQUEST['delete_preview']=='1'
- && isset($_REQUEST['layer_id']))
-{
- $preview_sql = "DELETE FROM layer_preview WHERE fkey_layer_id = $1";
- $v = array($_REQUEST['layer_id']);
- $t = array("s");
- $res_preview_sql = db_prep_query($preview_sql, $v, $t);
- die("Preview has been deleted!</body></html>");
-}
-?>
-<form name='form1' action='<?php echo $self . "&show_wms_list=true"; ?>' method='post'>
-
-<table border='0'>
-<tr>
-<td WIDTH="300" align="left">
-<B>WMS Metadaten<B/>
-<td/>
-<td WIDTH="160">
-<td/>
-</tr>
-
-<?php
-
-#Use select box to select a wms
-
-if (isset($_REQUEST['show_wms_list']) && $_REQUEST['show_wms_list'] == true)
-{
-
- #Querying information from wms data table
- $wms_sql = "SELECT wms_id, wms_title FROM wms WHERE wms_owner = $1 ORDER BY wms_title";
- $v = array($_SESSION["mb_user_id"]);
- $t = array("i");
- $res_wms_sql = db_prep_query($wms_sql, $v, $t);
- #wms-selection
-
- $selectBox = "";
- while($row = db_fetch_array($res_wms_sql)) {
- if ($adm->getWmsPermission($row["wms_id"], $_SESSION['mb_user_id'])) {
- $selectBox .= "<option value='".$row["wms_id"]."' ";
- if(isset($_REQUEST['wmsList']) && $_REQUEST['wmsList'] == $row["wms_id"]) {
- $selectBox .= "selected";
- }
- $selectBox .= "> ".$row["wms_title"]."</option>";
- }
- }
-
- if ($selectBox != "") {
- echo "<tr><td>";
- echo "<select size=6 name='wmsList' onchange='submit()'>".$selectBox."</select>";
- echo "</td><td width='160px' align='right'>";
- echo "<input type='button' class='sbutton' value='save' onclick='save()'>";
- echo "</td></tr>";
- }
- else {
- echo "<div>no wms owner.</div>";
- die;
- }
-
- if(isset($_REQUEST['wmsList']) == true && $_REQUEST['wmsList'] <>0)
- editWMSByWMSID ($_REQUEST['wmsList']);
-}
-
-echo "</table>";
-
-//$wms_id;
-function editWMSByWMSID($param_wms_id)
-{
- global $wms_id;
- $wms_id = $param_wms_id;
-
-}
-
-
-if(isset($wms_id) == true && $wms_id <>0)
-{
- $selected_wms_sql = "SELECT * FROM wms WHERE wms_id = $1";
- $v = array($wms_id);
- $t = array("s");
- $res_selected_wms_sql = db_prep_query($selected_wms_sql, $v, $t);
- $selected_row = db_fetch_array($res_selected_wms_sql);
-
-?>
-
- <table border='0' class='table_top' >
- <tr>
- <td>WMS-Titel:<td><td/>
- <input type='text' name='wms_title_box' value='<?php echo $selected_row["wms_title"];?>' /><td/>
-
- <td>WMS- Abstract:<td><td/>
- <input type='text' name='wms_abstract_box' value='<?php echo $selected_row["wms_abstract"];?>' /><td/>
-
- <td >Fees:<td><td/>
- <input type='text' name='fees_box' value='<?php echo $selected_row["fees"]?>'/><td/>
- <tr/>
-
- <tr>
- <td>Access Constraints:<td><td/>
- <input type='text' name='accessconstraints_box' value='<?php echo $selected_row["accessconstraints"]?>'/><td/>
-
- <td>Contact Person:<td><td/>
- <input type='text' name='contactperson_box' value='<?php echo $selected_row["contactperson"]?>'/><td/>
-
- <td>Contact Position:<td><td/>
- <input type='text' name='contactposition_box' value='<?php echo $selected_row["contactposition"]?>'/><td/>
- <tr/>
-
- <tr>
- <td>Contact Organization:<td><td/>
- <input type='text' name='contactorganization_box' value='<?php echo $selected_row["contactorganization"]?>'/><td/>
-
- <td>Address:<td><td/>
- <input type='text' name='address_box' value='<?php echo $selected_row["address"]?>'/><td/>
-
- <td style="width:">City:<td><td/>
- <input type='text' name='city_box' value='<?php echo $selected_row["city"]?>'/><td/>
- <tr/>
-
- <tr>
- <td>State or Province:<td><td/>
- <input type='text' name='stateorprovince_box' value='<?php echo $selected_row["stateorprovince"]?>'/><td/>
-
- <td>Postcode:<td><td/>
- <input type='text' name='postcode_box' value='<?php echo $selected_row["postcode"]?>'/><td/>
-
- <td>Country:<td><td/>
- <input type='text' name='country_box' value='<?php echo $selected_row["country"]?>'/><td/>
- <tr/>
-
- <tr>
- <td>Telephone:<td><td/>
- <input type='text' name='contactvoicetelephone_box'
- value='<?php echo $selected_row["contactvoicetelephone"]?>'/><td/>
-
- <td>Fax:<td><td/>
- <input type='text' name='contactfacsimiletelephone_box' value='<?php echo $selected_row["contactfacsimiletelephone"]?>'/><td/>
-
- <td>E-Mail:<td><td/>
- <input type='text' name='contactelectronicmailaddress_box' value='<?php echo $selected_row["contactelectronicmailaddress"]?>'/><td/>
- <tr/>
- <tr>
- <?php
- if (isset($selected_row["wms_timestamp"]) && $selected_row["wms_timestamp"] <> "") {
- $datum = date("d.m.Y",$selected_row["wms_timestamp"]);
- }
- else $datum = ""
-?>
- <td>Date:<td><td/>
- <input type='text' name='wms_timestamp_box' value='<?php echo $datum?>' onClick='pick_the_date(document.form1.wms_timestamp_box)'/><td/>
- <tr/>
-
- <table class="table_layer">
- <tr><td>Nr.</td><td>Title</td><td>Abstract</td><td>Keywords</td><td></td></tr>
-
-
-<?php
-
- $layer_sql = "SELECT * FROM layer WHERE layer.fkey_wms_id = $1" .
- " ORDER BY layer_pos";
- $v = array($wms_id);
- $t = array("s");
- $res_layer_sql = db_prep_query($layer_sql, $v, $t);
-
- while($layer_row = db_fetch_array($res_layer_sql))
- {
- ?>
- <tr align='center'>
- <td><input type='text' size='1' name='L_<?php echo $layer_row['layer_id']?>___layer_nr'
- value='<?php echo $layer_row['layer_pos']?>' readonly></td>
- <td><input type='text' size='15' name='L_<?php echo $layer_row['layer_id']?>___layer_title'
- value='<?php echo $layer_row['layer_title']?>' readonly></td>
- <td><input type='text' size='42' name='L_<?php echo $layer_row['layer_id']?>___layer_abstract'
- value='<?php echo $layer_row['layer_abstract']?>'>
-
- <?php
- $keyword_sql = "SELECT keyword FROM keyword, layer_keyword, layer " .
- "WHERE keyword.keyword_id = layer_keyword.fkey_keyword_id " .
- "AND layer_keyword.fkey_layer_id = layer.layer_id " .
- "AND layer.fkey_wms_id = $1 " .
- "AND layer.layer_id = $2";
- $v = array($wms_id, $layer_row['layer_id']);
- $t = array("s", "i");
- $res_keyword_sql = db_prep_query($keyword_sql, $v, $t);
- $keywordList = "";
- $seperator = "";
- while($keyword_row = db_fetch_array($res_keyword_sql))
- {
- if($keywordList != "")
- {
- $seperator = ",";
- }
- $keywordList .= $seperator.$keyword_row["keyword"];
- }
- ?>
- <td><input type='text' size='42' name='L_<?php echo $layer_row['layer_id']?>___layer_keywords'
- value='<?php echo $keywordList?>'>
- </td>
- <td>
- <!--
- <input type="button" value='preview' onclick="window.open('../frames/index.php?&gui_id=layer_preview&layer_preview=1&portal_services=<?php echo $layer_row['layer_id'];?>', 'mini_mapbender', 'height=370, width=370, dependent=yes');">
- -->
- </td>
- <td>
-<?php
-/*
- $preview_sql = "SELECT * FROM layer_preview " .
- "WHERE fkey_layer_id = ".$layer_row['layer_id']."";
- $res_preview_sql = db_query($preview_sql);
- if(db_numrows($res_preview_sql)>0){?>
- <!--
- <input id="<?php echo $layer_row['layer_id'];?>_dp" type="button" value='delete preview' onclick="deletepreview('<?php echo $layer_row['layer_id'];?>');">
- -->
-<?php }else{?>
- <!--
- <input id="<?php echo $layer_row['layer_id'];?>_dp" type="button" value='delete preview' style="display:none;" onclick="deletepreview('<?php echo $layer_row['layer_id'];?>');">
- -->
-<?php }*/?>
- </td>
- </tr>
- <?php
- }
- #editWMSByWMSID(961);
- ?>
- </table>
- <input type='hidden' name='update_content' value=''/>
- <input type='hidden' name='wms_id' value='<?php echo $wms_id ?>'/>
- <!--
- <input type="hidden" value='' name='delete_preview'>
- -->
- <input type="hidden" value='' name='layer_id'>
- </form>
- </body>
- </html>
-<?php
-}
+<?php
+# $Id$
+# http://www.mapbender.org/index.php?title=Edit_WMS_Metadata
+# Copyright (C) 2002 CCGIS
+#
+# This program is free software; you can redistribute it and/or modify
+# it under the terms of the GNU General Public License as published by
+# the Free Software Foundation; either version 2, or (at your option)
+# any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
+
+require_once(dirname(__FILE__)."/mb_validatePermission.php");
+require_once(dirname(__FILE__)."/../classes/class_administration.php");
+
+include_once '../include/dyn_css.php';
+
+$adm = new administration();
+?>
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html>
+<head>
+<title>Edit WMS Metadata</title>
+<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
+<script language="JavaScript">
+var dTarget;
+function save() {
+ document.forms[0].update_content.value=1;
+ document.forms[0].submit();
+}
+
+function deletepreview(layer_id) {
+ var url = String(document.location);
+ url = url.substr(0, url.indexOf('?'));
+ window.open(url+"?<?php echo $urlParameters; ?>&delete_preview=1&layer_id="+layer_id,'delete preview', 'height=50, width=150, dependent=yes');
+ document.getElementById(layer_id+"_dp").style.display="none";
+}
+
+function pick_the_date(obj) {
+ dTarget = obj;
+ var datePickerParameters = "m=Jan_Feb_Mrz_Apr_Mai_Jun_Jul_Aug_Sep_Okt_Nov_Dez&d=Mo_Di_Mi_Do_Fr_Sa_So&t=heute";
+ var datePickerStyle = "left=200,top=200,width=230,height=210,toolbar=0,location=0,directories=0,status=0,menubar=0,scrollbars=0"
+ var dp = window.open('../extensions/datepicker/datepicker.php?' + datePickerParameters,'dp',datePickerStyle);
+ dp.focus();
+ return false;
+}
+</script>
+</head>
+<body>
+<?php
+
+function guessTimestamp($timestr) {
+
+ if (mb_strpos($timestr, '.')) {
+ list($day, $month, $year) = explode(".", $timestr);
+ }
+ elseif (mb_strpos($timestr, '/')) {
+ list($month, $day, $year) = explode("/", $timestr);
+ }
+ elseif (mb_strpos($timestr, '-')) {
+ list($year, $month, $day) = explode("-", $timestr);
+ }
+ else {
+ $year = 0;
+ $month = 0;
+ $day = 0;
+ }
+ return mktime(0, 0, 0, $month, $day, intval($year));
+}
+
+#Update handling
+
+if (isset($_REQUEST['update_content']) && $_REQUEST['update_content'] == true) {
+
+ $update_wms_sql = "UPDATE wms SET ";
+ $update_wms_sql .= "wms_title = $1, wms_abstract = $2, fees = $3, ";
+ $update_wms_sql .= "accessconstraints = $4, contactperson = $5, ";
+ $update_wms_sql .= "contactposition = $6, contactorganization = $7, ";
+ $update_wms_sql .= "address = $8, city = $9, stateorprovince = $10, ";
+ $update_wms_sql .= "postcode = $11, country = $12, ";
+ $update_wms_sql .= "contactvoicetelephone = $13, ";
+ $update_wms_sql .= "contactfacsimiletelephone = $14, ";
+ $update_wms_sql .= "contactelectronicmailaddress = $15 ";
+
+ $v = array();
+ array_push($v, $_REQUEST['wms_title_box']);
+ array_push($v, $_REQUEST['wms_abstract_box']);
+ array_push($v, $_REQUEST['fees_box']);
+ array_push($v, $_REQUEST['accessconstraints_box']);
+ array_push($v, $_REQUEST['contactperson_box']);
+ array_push($v, $_REQUEST['contactposition_box']);
+ array_push($v, $_REQUEST['contactorganization_box']);
+ array_push($v, $_REQUEST['address_box']);
+ array_push($v, $_REQUEST['city_box']);
+ array_push($v, $_REQUEST['stateorprovince_box']);
+ array_push($v, $_REQUEST['postcode_box']);
+ array_push($v, $_REQUEST['country_box']);
+ array_push($v, $_REQUEST['contactvoicetelephone_box']);
+ array_push($v, $_REQUEST['contactfacsimiletelephone_box']);
+ array_push($v, $_REQUEST['contactelectronicmailaddress_box']);
+ $t = array("s", "s", "s", "s", "s", "s", "s", "s", "s", "s", "s", "s", "s", "s", "s");
+
+ if (isset($_REQUEST['wms_timestamp_box']) && $_REQUEST['wms_timestamp_box'] <> "") {
+ $update_wms_sql .= ", wms_timestamp = $16 ";
+ array_push($v, guessTimestamp($_REQUEST['wms_timestamp_box']));
+ array_push($t, "s");
+
+ $update_wms_sql .= "WHERE wms_id = $17";
+ }
+ else {
+ $update_wms_sql .= "WHERE wms_id = $16";
+ }
+ array_push($v, $_REQUEST['wms_id']);
+ array_push($t, "s");
+
+ $res_update_wms_sql = db_prep_query($update_wms_sql, $v, $t);
+
+ while(list($key,$val) = each($_REQUEST)) {
+ if(preg_match("/___/", $key)) {
+ $myKey = explode("___", $key);
+ $layer_id = preg_replace("/L_/","",$myKey[0]);
+ if($myKey[1]=="layer_abstract") {
+ $layer_sql = "UPDATE layer SET layer_abstract = $1 ";
+ $layer_sql .= "WHERE layer_id = $2 AND fkey_wms_id = $3";
+ $v = array($val, $layer_id, $_REQUEST['wms_id']);
+ $t = array("s", "i", "s");
+ $res_keyword_sql = db_prep_query($layer_sql, $v, $t);
+ }
+ if($myKey[1]=="layer_keywords") {
+ #Get all keywords depending on the given layer after user modification
+ $keywords = explode(",",$val);
+ #delete all blanks from the keywords list
+ for ($j = 0; $j < count($keywords); $j++) {
+ $word = $keywords[$j];
+ $word = trim($word);
+ $keywords[$j] = $word;
+ }
+ #echo "1: Keywords eines Layers: id des Layers: ", $layer_id, ", �bergebener String: ", $val, ";<br>";
+ #Get all keywords depending on this layer from database
+ $keyword_sql = "SELECT keyword_id, keyword FROM keyword, layer_keyword, layer " .
+ "WHERE keyword.keyword_id = layer_keyword.fkey_keyword_id " .
+ "AND layer_keyword.fkey_layer_id = layer.layer_id " .
+ "AND layer.fkey_wms_id = $1 " .
+ "AND layer.layer_id = $2";
+
+ $v = array($_REQUEST['wms_id'], $layer_id);
+ $t = array("s", "i");
+ $res_keyword_sql = db_prep_query($keyword_sql, $v, $t);
+ while($keyword_row = db_fetch_array($res_keyword_sql))
+ {
+ $keyword = $keyword_row['keyword'];
+ $keyword_id = $keyword_row['keyword_id'];
+ #keyword has been deleted or has been modified
+ #keyword exists in database but not in user data
+ $index = -1;
+ #echo "1a: Abfrage ob DB Keywords in User Liste: Keyword: ", $keyword, ";<br>";
+ if(in_array($keyword, $keywords) == false)
+ {
+ #echo "1c: Keyword nicht in User Liste: Keyword: ", $keyword, ";<br>";
+ #Deleting reference to the keyword from the layer_keyword table.
+ $keyword_sql = "DELETE FROM layer_keyword " .
+ "WHERE fkey_layer_id = $1 " .
+ "AND fkey_keyword_id = $2";
+ $v = array($layer_id, $keyword_id);
+ $t = array("i", "i");
+ db_prep_query($keyword_sql, $v, $t);
+ #Checking, if the keyword is in use by any layer
+ $layer_sql = "SELECT * FROM layer_keyword " .
+ "WHERE fkey_keyword_id = $1";
+ $v = array($keyword_id);
+ $t = array("i");
+ $res_layer_sql = db_prep_query($layer_sql, $v, $t);
+ if(!($row = db_fetch_array($res_layer_sql)))
+ {
+ #If keyword will not longer be in use, delete it from keyword table
+ $keyword_sql = "DELETE FROM keyword " .
+ "WHERE keyword_id = $1";
+ $v = array($keyword_id);
+ $t = array("i");
+ db_prep_query($keyword_sql, $v, $t);
+ }
+ }
+ #Keyword exists in the database and in the user data
+ else
+ {
+ #echo "1d: Keyword ist in User Liste: Keyword: ", $keyword, ";<br>";
+ for($i = 0; $i < count($keywords); $i++)
+ {
+ #Delete keyword from the user data list, because the data
+ #have not to be updated within the database
+ if($keywords[$i] == $keyword)
+ {
+ $keywords[$i] = null;
+ }
+ }
+ }
+ }
+ #Inserting keyword, that are not existing in the database
+ for($i = 0; $i < count($keywords); $i++)
+ {
+ #echo "2: Alle Eintr�ge des Keyword arrays: Keyword: ", $keywords[$i], "; Index: ", $i, ";<br>";
+ if($keywords[$i] != null)
+ {
+ #echo "3: Eintr�ge ungleich null: Keyword: ", $keywords[$i], "; Index: ", $i, ";<nr>";
+ $keyword = trim($keywords[$i]);
+ #Check, if the keyword is exsiting in the database
+ $keyword_sql = "SELECT keyword_id FROM keyword " .
+ "WHERE UPPER(keyword) = UPPER($1)";
+ $v = array($keyword);
+ $t = array("s");
+ $res_keyword_sql = db_prep_query($keyword_sql, $v, $t);
+ $keyword_row = db_fetch_array($res_keyword_sql);
+ #Keyword exists in the database
+ if($keyword_row != null)
+ {
+ $keyword_id = $keyword_row[0];
+ #echo "4: Keyword in Datenbank vorhanden: id des Keywords: ", $keyword_id, ";<br>";
+ }
+ #Keyword does not exist in the database
+ else
+ {
+ $keyword_sql = "INSERT INTO keyword (keyword) VALUES ($1)";
+ $v = array($keyword);
+ $t = array("s");
+ $res_keyword_sql = db_prep_query($keyword_sql, $v, $t);
+
+ $keyword_sql = "SELECT keyword_id FROM keyword WHERE keyword = $1";
+ $v = array($keyword);
+ $t = array("s");
+ $res_keyword_sql = db_prep_query($keyword_sql, $v, $t);
+ $keyword_row = db_fetch_array($res_keyword_sql);
+ if($keyword_row != null)
+ {
+ $keyword_id = $keyword_row[0];
+ #echo "4: Keyword in der Datenbank nicht vorhanden: id des Keywords: ", $keyword_id, ";<br>";
+ }
+ }
+ #Inserting the reference between layer and keyword in the layer_keyword table
+ $keyword_sql = "INSERT INTO layer_keyword (fkey_layer_id, fkey_keyword_id) " .
+ "VALUES ($1, $2)";
+ $v = array($layer_id, $keyword_id);
+ $t = array("s", "s");
+ $res_keyword_sql = db_prep_query($keyword_sql, $v, $t);
+ }
+ }
+ #Delete all elements from array
+ unset($keywords);
+ }
+ }
+ }
+}
+unset($update_content);
+
+#delete preview
+
+if(isset($_REQUEST['delete_preview']) && $_REQUEST['delete_preview']=='1'
+ && isset($_REQUEST['layer_id']))
+{
+ $preview_sql = "DELETE FROM layer_preview WHERE fkey_layer_id = $1";
+ $v = array($_REQUEST['layer_id']);
+ $t = array("s");
+ $res_preview_sql = db_prep_query($preview_sql, $v, $t);
+ die("Preview has been deleted!</body></html>");
+}
+?>
+<form name='form1' action='<?php echo $self . "&show_wms_list=true"; ?>' method='post'>
+
+<table border='0'>
+<tr>
+<td WIDTH="300" align="left">
+<B>WMS Metadaten<B/>
+<td/>
+<td WIDTH="160">
+<td/>
+</tr>
+
+<?php
+
+#Use select box to select a wms
+
+if (isset($_REQUEST['show_wms_list']) && $_REQUEST['show_wms_list'] == true)
+{
+
+ #Querying information from wms data table
+ $wms_sql = "SELECT wms_id, wms_title FROM wms WHERE wms_owner = $1 ORDER BY wms_title";
+ $v = array(Mapbender::session()->get("mb_user_id"));
+ $t = array("i");
+ $res_wms_sql = db_prep_query($wms_sql, $v, $t);
+ #wms-selection
+
+ $selectBox = "";
+ while($row = db_fetch_array($res_wms_sql)) {
+ if ($adm->getWmsPermission($row["wms_id"], Mapbender::session()->get("mb_user_id"))) {
+ $selectBox .= "<option value='".$row["wms_id"]."' ";
+ if(isset($_REQUEST['wmsList']) && $_REQUEST['wmsList'] == $row["wms_id"]) {
+ $selectBox .= "selected";
+ }
+ $selectBox .= "> ".$row["wms_title"]."</option>";
+ }
+ }
+
+ if ($selectBox != "") {
+ echo "<tr><td>";
+ echo "<select size=6 name='wmsList' onchange='submit()'>".$selectBox."</select>";
+ echo "</td><td width='160px' align='right'>";
+ echo "<input type='button' class='sbutton' value='save' onclick='save()'>";
+ echo "</td></tr>";
+ }
+ else {
+ echo "<div>no wms owner.</div>";
+ die;
+ }
+
+ if(isset($_REQUEST['wmsList']) == true && $_REQUEST['wmsList'] <>0)
+ editWMSByWMSID ($_REQUEST['wmsList']);
+}
+
+echo "</table>";
+
+//$wms_id;
+function editWMSByWMSID($param_wms_id)
+{
+ global $wms_id;
+ $wms_id = $param_wms_id;
+
+}
+
+
+if(isset($wms_id) == true && $wms_id <>0)
+{
+ $selected_wms_sql = "SELECT * FROM wms WHERE wms_id = $1";
+ $v = array($wms_id);
+ $t = array("s");
+ $res_selected_wms_sql = db_prep_query($selected_wms_sql, $v, $t);
+ $selected_row = db_fetch_array($res_selected_wms_sql);
+
+?>
+
+ <table border='0' class='table_top' >
+ <tr>
+ <td>WMS-Titel:<td><td/>
+ <input type='text' name='wms_title_box' value='<?php echo $selected_row["wms_title"];?>' /><td/>
+
+ <td>WMS- Abstract:<td><td/>
+ <input type='text' name='wms_abstract_box' value='<?php echo $selected_row["wms_abstract"];?>' /><td/>
+
+ <td >Fees:<td><td/>
+ <input type='text' name='fees_box' value='<?php echo $selected_row["fees"]?>'/><td/>
+ <tr/>
+
+ <tr>
+ <td>Access Constraints:<td><td/>
+ <input type='text' name='accessconstraints_box' value='<?php echo $selected_row["accessconstraints"]?>'/><td/>
+
+ <td>Contact Person:<td><td/>
+ <input type='text' name='contactperson_box' value='<?php echo $selected_row["contactperson"]?>'/><td/>
+
+ <td>Contact Position:<td><td/>
+ <input type='text' name='contactposition_box' value='<?php echo $selected_row["contactposition"]?>'/><td/>
+ <tr/>
+
+ <tr>
+ <td>Contact Organization:<td><td/>
+ <input type='text' name='contactorganization_box' value='<?php echo $selected_row["contactorganization"]?>'/><td/>
+
+ <td>Address:<td><td/>
+ <input type='text' name='address_box' value='<?php echo $selected_row["address"]?>'/><td/>
+
+ <td style="width:">City:<td><td/>
+ <input type='text' name='city_box' value='<?php echo $selected_row["city"]?>'/><td/>
+ <tr/>
+
+ <tr>
+ <td>State or Province:<td><td/>
+ <input type='text' name='stateorprovince_box' value='<?php echo $selected_row["stateorprovince"]?>'/><td/>
+
+ <td>Postcode:<td><td/>
+ <input type='text' name='postcode_box' value='<?php echo $selected_row["postcode"]?>'/><td/>
+
+ <td>Country:<td><td/>
+ <input type='text' name='country_box' value='<?php echo $selected_row["country"]?>'/><td/>
+ <tr/>
+
+ <tr>
+ <td>Telephone:<td><td/>
+ <input type='text' name='contactvoicetelephone_box'
+ value='<?php echo $selected_row["contactvoicetelephone"]?>'/><td/>
+
+ <td>Fax:<td><td/>
+ <input type='text' name='contactfacsimiletelephone_box' value='<?php echo $selected_row["contactfacsimiletelephone"]?>'/><td/>
+
+ <td>E-Mail:<td><td/>
+ <input type='text' name='contactelectronicmailaddress_box' value='<?php echo $selected_row["contactelectronicmailaddress"]?>'/><td/>
+ <tr/>
+ <tr>
+ <?php
+ if (isset($selected_row["wms_timestamp"]) && $selected_row["wms_timestamp"] <> "") {
+ $datum = date("d.m.Y",$selected_row["wms_timestamp"]);
+ }
+ else $datum = ""
+?>
+ <td>Date:<td><td/>
+ <input type='text' name='wms_timestamp_box' value='<?php echo $datum?>' onClick='pick_the_date(document.form1.wms_timestamp_box)'/><td/>
+ <tr/>
+
+ <table class="table_layer">
+ <tr><td>Nr.</td><td>Title</td><td>Abstract</td><td>Keywords</td><td></td></tr>
+
+
+<?php
+
+ $layer_sql = "SELECT * FROM layer WHERE layer.fkey_wms_id = $1" .
+ " ORDER BY layer_pos";
+ $v = array($wms_id);
+ $t = array("s");
+ $res_layer_sql = db_prep_query($layer_sql, $v, $t);
+
+ while($layer_row = db_fetch_array($res_layer_sql))
+ {
+ ?>
+ <tr align='center'>
+ <td><input type='text' size='1' name='L_<?php echo $layer_row['layer_id']?>___layer_nr'
+ value='<?php echo $layer_row['layer_pos']?>' readonly></td>
+ <td><input type='text' size='15' name='L_<?php echo $layer_row['layer_id']?>___layer_title'
+ value='<?php echo $layer_row['layer_title']?>' readonly></td>
+ <td><input type='text' size='42' name='L_<?php echo $layer_row['layer_id']?>___layer_abstract'
+ value='<?php echo $layer_row['layer_abstract']?>'>
+
+ <?php
+ $keyword_sql = "SELECT keyword FROM keyword, layer_keyword, layer " .
+ "WHERE keyword.keyword_id = layer_keyword.fkey_keyword_id " .
+ "AND layer_keyword.fkey_layer_id = layer.layer_id " .
+ "AND layer.fkey_wms_id = $1 " .
+ "AND layer.layer_id = $2";
+ $v = array($wms_id, $layer_row['layer_id']);
+ $t = array("s", "i");
+ $res_keyword_sql = db_prep_query($keyword_sql, $v, $t);
+ $keywordList = "";
+ $seperator = "";
+ while($keyword_row = db_fetch_array($res_keyword_sql))
+ {
+ if($keywordList != "")
+ {
+ $seperator = ",";
+ }
+ $keywordList .= $seperator.$keyword_row["keyword"];
+ }
+ ?>
+ <td><input type='text' size='42' name='L_<?php echo $layer_row['layer_id']?>___layer_keywords'
+ value='<?php echo $keywordList?>'>
+ </td>
+ <td>
+ <!--
+ <input type="button" value='preview' onclick="window.open('../frames/index.php?&gui_id=layer_preview&layer_preview=1&portal_services=<?php echo $layer_row['layer_id'];?>', 'mini_mapbender', 'height=370, width=370, dependent=yes');">
+ -->
+ </td>
+ <td>
+<?php
+/*
+ $preview_sql = "SELECT * FROM layer_preview " .
+ "WHERE fkey_layer_id = ".$layer_row['layer_id']."";
+ $res_preview_sql = db_query($preview_sql);
+ if(db_numrows($res_preview_sql)>0){?>
+ <!--
+ <input id="<?php echo $layer_row['layer_id'];?>_dp" type="button" value='delete preview' onclick="deletepreview('<?php echo $layer_row['layer_id'];?>');">
+ -->
+<?php }else{?>
+ <!--
+ <input id="<?php echo $layer_row['layer_id'];?>_dp" type="button" value='delete preview' style="display:none;" onclick="deletepreview('<?php echo $layer_row['layer_id'];?>');">
+ -->
+<?php }*/?>
+ </td>
+ </tr>
+ <?php
+ }
+ #editWMSByWMSID(961);
+ ?>
+ </table>
+ <input type='hidden' name='update_content' value=''/>
+ <input type='hidden' name='wms_id' value='<?php echo $wms_id ?>'/>
+ <!--
+ <input type="hidden" value='' name='delete_preview'>
+ -->
+ <input type="hidden" value='' name='layer_id'>
+ </form>
+ </body>
+ </html>
+<?php
+}
?>
\ No newline at end of file
More information about the Mapbender_commits
mailing list