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

[svn_mapbender at osgeo.org]

Author: verenadiewald
Date: 2013-06-03 01:15:40 -0700 (Mon, 03 Jun 2013)
New Revision: 8637

Modified:
   trunk/mapbender/http/php/mod_wfs.php
Log:
get otherSRS definitions from table wfs_featuretype_epsg, if available for this wfs conf's featuretype

Modified: trunk/mapbender/http/php/mod_wfs.php
===================================================================
--- trunk/mapbender/http/php/mod_wfs.php	2013-06-03 08:13:27 UTC (rev 8636)
+++ trunk/mapbender/http/php/mod_wfs.php	2013-06-03 08:15:40 UTC (rev 8637)
@@ -155,6 +155,19 @@
 			$counter++;
 		}
 		
+		//get OtherSRS if available
+		$sql = "SELECT * FROM wfs_featuretype_epsg";
+		$sql .= " WHERE fkey_featuretype_id = $1";
+		$v = array($featuretype_id);
+		$t = array('i');
+		$res = db_prep_query($sql,$v,$t);
+		echo "wfs_conf[".$i."]['other_srs'] = new Array();";
+		$counter = 0;
+		while($row = db_fetch_array($res)){
+			echo "wfs_conf[".$i."]['other_srs'][".$counter."] = new Array();";
+			echo "wfs_conf[".$i."]['other_srs'][".$counter."]['epsg']  = '".$row["epsg"]."';";
+			$counter++;
+		}		
 		
 		$sql = "SELECT * FROM wfs_featuretype ";
 		$sql .= "WHERE fkey_wfs_id = $1 AND featuretype_id = $2";