get("mb_user_id"));
$command = $_REQUEST["command"];
$wfsFeatureTypeName = $_REQUEST["wfsFeatureTypeName"];
#$wfsDescribeFeatureType = $_REQUEST["wfsDescribeFeatureType"];
$wfsGetFeatureAttr = $_REQUEST["wfsGetFeatureAttr"];
$wfsGetFeature = $_REQUEST["wfsGetFeature"];
$wfsFilter = $_REQUEST["wfsFilter"];
$exportToShape = $_REQUEST["exportToShape"] == "true" ? true : false;
function toShape ($filenamePrefix, $geoJson, $destSrs) {
$srsArray = explode(":", $destSrs);
$srs = array_pop($srsArray);
$unique = TMPDIR . "/" . $filenamePrefix;
file_put_contents($unique.".json",$geoJson);
if(defined("OGR2OGR_PATH")) {
$pathOgr = OGR2OGR_PATH;
}
else {
$pathOgr = '/usr/bin/ogr2ogr';
}
$exec = $pathOgr .' -a_srs EPSG:'.$srs.' -f "ESRI Shapefile" '.$unique.'.shp '. $unique.".json";
exec($exec);
$exec = 'zip -j '.$unique.'.zip '.$unique.'.shp '.$unique.'.dbf '.$unique.'.shx '.$unique.'.gfs '.$unique.'.gml '.$unique.'.prj '.$unique.".json";
exec($exec);
//$exec = 'rm -f'.$unique.'.zip '.$unique.'.shp '.$unique.'.dbf '.$unique.'.shx '.$unique.'.gfs '.$unique.'.gml '.$unique.'.prj ';
//exec($exec);
return $unique;
}
/**
* checks if a variable name is valid.
* Currently a valid name would be sth. like Mapbender::session()->get("mb_user_id")
* TODO: this function is also in mod_wfs_result!! Maybe merge someday.
*/
function isValidVarName ($varname) {
if (preg_match("/[\$]{1}_[a-z]+\[\"[a-z_]+\"\]/i", $varname) != 0) {
return true;
}
return false;
}
/**
* If access to the WFS conf is restricted, modify the filter.
* TODO: this function is also in mod_wfs_result!! Maybe merge someday.
*/
function checkAccessConstraint($filter, $wfs_conf_id) {
/* wfs_conf_element */
$sql = "SELECT * FROM wfs_conf_element ";
$sql .= "JOIN wfs_element ON wfs_conf_element.f_id = wfs_element.element_id ";
$sql .= "WHERE wfs_conf_element.fkey_wfs_conf_id = $1 ";
$sql .= "ORDER BY wfs_conf_element.f_respos";
$v = array($wfs_conf_id);
$t = array('i');
$res = db_prep_query($sql,$v,$t);
while($row = db_fetch_array($res)){
if (!empty($row["f_auth_varname"])) {
$auth_varname = $row["f_auth_varname"];
$element_name = $row["element_name"];
}
}
if (!empty($auth_varname)) {
if (isValidVarName($auth_varname)) {
$user = eval("return " . $auth_varname . ";");
if ($user) {
$pattern = "(]*>)(.*)()";
$replacement = "\\1\\2" . $element_name . "" . $user . "\\3";
$filter = mb_eregi_replace($pattern, $replacement, $filter);
}
else {
$e = new mb_exception("mod_wfsGazetteerEditor_server: checkAccessConstraint: invalid value of variable containing user information!");
}
}
else {
$e = new mb_exception("mod_wfsGazetteerEditor_server: checkAccessConstraint: var name is not valid! (" . $auth_varname . ")");
}
}
return $filter;
}
if ($command == "getWfsConf") {
$wfsConfIdString = $_GET["wfsConfIdString"];
if ($wfsConfIdString != "") {
//array_keys(array_flip()) produces an array with unique entries
$wfsConfIdArray = array_keys(array_flip(mb_split(",", $wfsConfIdString)));
$availableWfsConfIds = $user->getWfsConfByPermission();
$wfsConfIdArray = array_intersect($wfsConfIdArray, $availableWfsConfIds);
if (count($wfsConfIdArray) === 0) {
echo "no wfs conf available.";
die();
}
}
else {
echo "please specify wfs conf id.";
die();
}
$obj = new WfsConf();
$obj->load($wfsConfIdArray);
$json = new Mapbender_JSON();
$output = $json->encode($obj->confArray);
echo $output;
}
else if ($command == "getSearchResults") {
$wfs_conf_id = $_REQUEST["wfs_conf_id"];
$backlink = $_REQUEST["backlink"];
$frame = $_REQUEST["frame"];
$filter = $_REQUEST["filter"];
$url = $_REQUEST["url"];
$typename = $_REQUEST["typename"];
$exportToShape = $_REQUEST["exportToShape"] == "true" ? true : false;
$destSrs = $_REQUEST["destSrs"];
$storedQueryId = $_REQUEST["storedQueryId"];
$storedQueryParams = $_REQUEST["storedQueryParams"];
$wfsConf = WfsConfiguration::createFromDb($wfs_conf_id);
if (is_null($wfsConf)) {
sendErrorMessage("Invalid WFS conf: " . $wfs_conf_id);
}
// append authorisation condition to filter
$filter = checkAccessConstraint($filter, $wfs_conf_id);
$admin = new administration();
$filter = administration::convertIncomingString($filter);
$wfsId = $wfsConf->wfsId;
$myWfsFactory = new UniversalWfsFactory();
$myWfs = $myWfsFactory->createFromDb($wfsId);
$data = $myWfs->getFeature($typename, $filter,$destSrs, $storedQueryId, $storedQueryParams, null);
if ($data === null) die('{}');
if (defined("WFS_RESPONSE_SIZE_LIMIT") && WFS_RESPONSE_SIZE_LIMIT < strlen($data)) {
die("Too many results, please restrict your search.");
}
$gmlFactory = new UniversalGmlFactory();
$myGml = $gmlFactory->createFromXml($data, $wfsConf);
if (!is_null($myGml)) {
$geoJson = $myGml->toGeoJSON();
if ($exportToShape) {
$filenamePrefix = md5(microtime());
$zipFile = toShape($filenamePrefix, $geoJson, $destSrs);
header("Content-Type: application/json; charset=utf-8");
echo '{"filename": "' . $zipFile . '.zip"}';
}
else {
header("Content-type:application/x-json; charset=utf-8");
echo $geoJson;
}
}
else {
$geoJson = "{}";
header("Content-type:application/x-json; charset=utf-8");
echo $geoJson;
}
}
else if($command == "getFeature"){
//copied from above
$wfs_conf_id = $_REQUEST["wfs_conf_id"];
$destSrs = $_REQUEST["destSrs"];
$wfsConf = WfsConfiguration::createFromDb($wfs_conf_id);
if (is_null($wfsConf)) {
sendErrorMessage("Invalid WFS conf: " . $wfs_conf_id); //TODO - sendErrorMessage - locate where it is declared!
}
$admin = new administration();
$wfsId = $wfsConf->wfsId;
$filter = null;
$myWfsFactory = new UniversalWfsFactory();
$myWfs = $myWfsFactory->createFromDb($wfsId);
$data = $myWfs->getFeature($wfsFeatureTypeName, null, $destSrs, null, null, 20);
if ($data === null) die('{}');
if (defined("WFS_RESPONSE_SIZE_LIMIT") && WFS_RESPONSE_SIZE_LIMIT < strlen($data)) {
die("Too many results, please restrict your search.");
}
$gmlFactory = new UniversalGmlFactory();
//TODO: The following code is not nice but more stable - exchange it later with the code below!
$parser = xml_parser_create();
xml_parser_set_option($parser,XML_OPTION_CASE_FOLDING,0);
xml_parser_set_option($parser,XML_OPTION_SKIP_WHITE,1);
xml_parser_set_option($parser,XML_OPTION_TARGET_ENCODING,"UTF-8");
xml_parse_into_struct($parser,$data,$values,$tags);
$code = xml_get_error_code($parser);
xml_parser_free($parser);
if ($code) {
$line = xml_get_current_line_number($parser);
$mb_exception = new mb_exception(xml_error_string($code) . " in line " . $line);
}
function sepNameSpace($s){
$c = mb_strpos($s,":");
if($c>0){
return mb_substr($s,$c+1);
} else {
return $s;
}
}
$featureNameToUpper = mb_strtoupper($wfsGetFeatureAttr);
$featureValuesArray = array();
foreach ($values as $element) {
if(mb_strtoupper($element[tag]) == $featureNameToUpper || sepNameSpace(mb_strtoupper($element[tag])) == $featureNameToUpper){
array_push($featureValuesArray, $element[value]);
}
}
//$featureValues = join("|", $featureValuesArray);
$json = new Services_JSON();
echo $json->encode($featureValuesArray);
//TODO: use the following if php error in parsing xml is fixed - ubuntu 12.04 (2013.10.07 - has no problems!)
/*$myGml = $gmlFactory->createFromXml($data, $wfsConf);
if (!is_null($myGml)) {
echo $myGml;
die();
$geoJson = $myGml->toGeoJSON();
//echo $geoJson;
//parse attribute objects
$featureValuesArray = array();
$geoObj = json_decode($geoJson);
foreach($geoObj->features as $feature) {
array_push($featureValuesArray, $feature->properties->{$wfsGetFeatureAttr});
}
$json = new Services_JSON();
echo $json->encode($featureValuesArray);
}
else {
$geoJson = "{}";
header("Content-type:application/x-json; charset=utf-8");
echo $geoJson;
}*/
}
else {
echo "please enter a valid command.";
}
?>