[Mapbender-commits] r1010 - trunk/mapbender/http/php

[svn_mapbender at osgeo.org]

Author: christoph
Date: 2007-01-16 06:53:16 -0500 (Tue, 16 Jan 2007)
New Revision: 1010

Modified:
   trunk/mapbender/http/php/mod_wfs_conf.php
   trunk/mapbender/http/php/mod_wfs_edit.php
Log:
f_box und f_edit

Modified: trunk/mapbender/http/php/mod_wfs_conf.php
===================================================================
--- trunk/mapbender/http/php/mod_wfs_conf.php	2007-01-16 11:27:50 UTC (rev 1009)
+++ trunk/mapbender/http/php/mod_wfs_conf.php	2007-01-16 11:53:16 UTC (rev 1010)
@@ -99,7 +99,7 @@
         $res = db_query($sql);
         $wfsID = db_insert_id($con,'wfs_conf','wfs_conf_id');
         for($i=0; $i<$_REQUEST["num"]; $i++){
-                $sql = "INSERT INTO wfs_conf_element (fkey_wfs_conf_id,f_id,f_search,f_pos,f_style_id,f_toupper,f_label,f_label_id,f_show,f_respos) VALUES(";
+                $sql = "INSERT INTO wfs_conf_element (fkey_wfs_conf_id,f_id,f_search,f_pos,f_style_id,f_toupper,f_label,f_label_id,f_show,f_respos,f_edit,f_box) VALUES(";
                 $sql .= "'".$wfsID."',";
                 $sql .= "'".$_REQUEST["f_id".$i]."',";
                 if(!empty($_REQUEST["f_search".$i])){
@@ -115,7 +115,11 @@
                 if(!empty($_REQUEST["f_show".$i])){
                 	$sql .= "'1',";
                 }else{$sql .= "'0',";}
-                $sql .= "'".$_REQUEST["f_respos".$i]."'";
+                $sql .= "'".$_REQUEST["f_respos".$i]."',";
+                if(!empty($_REQUEST["f_edit".$i])){
+                	$sql .= "'1',";
+                }else{$sql .= "'0',";}
+                $sql .= "'".$_REQUEST["f_box".$i]."'";
                 $sql .= "); ";
 
                 $res = db_query($sql);
@@ -237,6 +241,8 @@
                 echo "<td>label_id</td>";
                 echo "<td>show</td>";
                 echo "<td>position</td>";
+                echo "<td>edit</td>";
+                echo "<td>box</td>";
         echo "</tr>";
 
         for($i=0; $i<count($aWFS->elements->element_id); $i++){
@@ -254,6 +260,8 @@
                 echo "<td><input name='f_label_id".$i."' type='text' size='2'  value='0'></td>";
                 echo "<td><input name='f_show".$i."' type='checkbox'></td>";
                 echo "<td><input name='f_respos".$i."' type='text' size='4' value='0'></td>";
+                echo "<td><input name='f_edit".$i."' type='checkbox'></td>";
+                echo "<td><textarea name='f_box".$cnt."' cols='15' rows='1' ></textarea></td>";
                 echo "</tr>";
         }
         echo "</table>";

Modified: trunk/mapbender/http/php/mod_wfs_edit.php
===================================================================
--- trunk/mapbender/http/php/mod_wfs_edit.php	2007-01-16 11:27:50 UTC (rev 1009)
+++ trunk/mapbender/http/php/mod_wfs_edit.php	2007-01-16 11:53:16 UTC (rev 1010)
@@ -117,7 +117,13 @@
                 	$sql .= '1';
                 }else{$sql .= '0';}
 				$sql .= "',";
-                $sql .= "f_respos = '".$_REQUEST["f_respos".$i]."'";
+                $sql .= "f_respos = '".$_REQUEST["f_respos".$i]."', ";
+                $sql .= "f_edit = '";
+                if(!empty($_REQUEST["f_edit".$i])){
+                	$sql .= '1';
+                }else{$sql .= '0';}
+				$sql .= "',";
+                $sql .= "f_box = '".addslashes($_REQUEST["f_box".$i])."' ";
                 $sql .= " WHERE fkey_wfs_conf_id = ".$_REQUEST["gaz"]." AND f_id = ".$_REQUEST["f_id".$i].";";
                 $res = db_query($sql);
         }
@@ -190,6 +196,8 @@
                 echo "<td>label_id</td>";
                 echo "<td>show</td>";
                 echo "<td>position</td>";
+                echo "<td>edit</td>";
+                echo "<td>box</td>";
         echo "</tr>";
         $cnt = 0;
         while($row = db_fetch_array($res)){
@@ -217,6 +225,10 @@
                 if($row["f_show"] == 1){ echo " checked"; }
                 echo "></td>";
                 echo "<td><input name='f_respos".$cnt."' type='text' size='4' value='".$row["f_respos"]."'></td>";
+                echo "<td><input name='f_edit".$cnt."' type='checkbox'";
+                if($row["f_edit"] == 1){ echo " checked"; }
+                echo "></td>";
+                echo "<td><textarea name='f_box".$cnt."' cols='15' rows='1' >".$row["f_box"]."</textarea></td>";
                 echo "</tr>";
                 $cnt++;
         }