OSGeo.org › OSGeo Software and Data Projects › Fusion › Fusion Developers

extendselection in mapserver

2 messages Options
Embed this post
Permalink
klementszabolcs

extendselection in mapserver

Reply Threaded More More options
Print post
Permalink
Hi.
I make a solution for mapserver extendselection.
The file Mapserver/php/Query.php is attached.
The interested lines is 123-160



"; /* selection variant if set */ $variant = 'intersects'; if (isset($_REQUEST['variant'])) { if (strcasecmp($_REQUEST['variant'],'contains') == 0) { $variant = 'contains'; } else if (strcasecmp($_REQUEST['variant'],'inside') == 0) { $variant = 'inside'; } } /* a filter expression to apply, in the form of an FDO SQL statement */ $filter = isset($_REQUEST['filter']) ? str_replace(array('*', '"'), array('%', "'"),html_entity_decode(urldecode( $_REQUEST['filter']))) : false; //echo "\n"; /* a spatial filter in the form on a WKT geometry */ $spatialFilter = (isset($_REQUEST['spatialfilter']) && $_REQUEST['spatialfilter'] != '') ? urldecode($_REQUEST['spatialfilter']) : false; //echo "spatial filter is $spatialFilter
"; if (!isset($mapName)) { die('mapname not set'); } if (isset($_SESSION['maps']) && isset($_SESSION['maps'][$mapName])) { $oMap = ms_newMapObj($_SESSION['maps'][$mapName]); } /* add the spatial filter if provided. It is expected to come as a WKT string, so we need to convert it to a shape */ if ($spatialFilter !== false ) { $oSpatialFilter = ms_shapeObjFromWkt($spatialFilter); } /* if extending the current selection */ $bExtendSelection = isset($_REQUEST['extendselection']) && strcasecmp($_REQUEST['extendselection'], 'true') == 0; $bComputedProperties = isset($_REQUEST['computed']) && strcasecmp($_REQUEST['computed'], 'true') == 0; $bAllLayers = false; $nLayers = count($layers); $nSelections = 0; if ($nLayers == 0) { $nLayers = $oMap->numlayers; $bAllLayers = true; } $result = NULL; $result->hasSelection = false; $result->layers = array(); $sellayers=array(); for ($i=0; $i<$nLayers; $i++) { if (!$bAllLayers) { $oLayer = $oMap->GetLayerByName($layers[$i]); } else { $oLayer = $oMap->GetLayer($i); } $oLayer->set('tolerance', 0); //klement //if (strcasecmp($layers[$i],'ing_telepulesrol')==0) { //$oLayer->set('data',str_replace('%x_ing_telepulesre%',$_REQUEST['x_ing_telepulesre'],$oLayer->data)); $oLayer->set('data',str_replace('%x_ing_telepulesrol%',$_REQUEST['x_ing_telepulesrol'],$oLayer->data)); $oLayer->set('data',str_replace('%x_fo%',$_REQUEST['x_fo'],$oLayer->data)); $oLayer->set('data',str_replace('%x_column%',$_REQUEST['x_column'],$oLayer->data)); $oLayer->set('data',str_replace('%x_elerhetoseg_tazon%',$_REQUEST['x_elerhetoseg_tazon'],$oLayer->data)); $oLayer->set('data',str_replace('%x_min%',$_REQUEST['x_min'],$oLayer->data)); $oLayer->set('data',str_replace('%x_max%',$_REQUEST['x_max'],$oLayer->data)); // } if ($oLayer->type == MS_LAYER_RASTER || $oLayer->type == MS_LAYER_QUERY || $oLayer->type == MS_LAYER_CIRCLE || $oLayer->type == MS_LAYER_CHART) { continue; } if (@$oLayer->queryByShape($oSpatialFilter) == MS_SUCCESS) { $result->hasSelection = true; $layerName = $oLayer->name; array_push($result->layers, $layerName); $result->$layerName->featureCount = $oLayer->getNumResults(); if ($bExtendSelection) { $selfeatures=array(); for ($iRes=0; $iRes < $oLayer->getNumResults(); $iRes++) { $oRes = $oLayer->getResult($iRes); $selfe=NULL; $selfe->tileindex=$oRes->tileindex; $selfe->shapeindex=$oRes->shapeindex; array_push($selfeatures,$selfe); } array_push($sellayers, $selfeatures); } } } if ($bExtendSelection) { $oMap->loadquery(getSessionSavePath()."query.qry"); for ($i=0;$iGetLayerByName($result->layers[$i]); //$AAA=$oMap->GetLayer($la->index); //echo ($AAA->name); //echo count($ss).','.$la->index.':'; for ($j=0;$jindex.':'.$xx->tileindex.','.$xx->shapeindex.';'; $aa=$oMap->queryByIndex($la->index,$xx->tileindex,$xx->shapeindex,MS_TRUE); } } } header('Content-type: text/x-json'); header('X-JSON: true'); if ($result->hasSelection) { $oMap->savequery(getSessionSavePath()."query.qry"); $result->queryFile = getSessionSavePath()."query.qry"; /*holds selection array*/ $properties = NULL; $properties->layers = array(); $totalminx = 0; $totalminy = 0; $totalmaxx = 0; $totalmaxy = 0; $bFirstElement = 1; $nLayers = $oMap->numlayers; for ($i=0; $i<$nLayers; $i++) { $oLayer = $oMap->GetLayer($i); $numResults = $oLayer->getNumResults(); if ($numResults == 0){ continue; } $oLayer->open(); $layerName = $oLayer->name != "" ? $oLayer->name : "Layer_".$i; array_push($properties->layers, $layerName); $properties->$layerName->numelements = $numResults; $properties->$layerName->propertynames = array(); $properties->$layerName->propertyvalues = array(); $properties->$layerName->propertytypes = array(); $properties->$layerName->values = array(); $properties->$layerName->metadatanames= array(); array_push($properties->$layerName->metadatanames, 'dimension'); array_push($properties->$layerName->metadatanames, 'bbox'); array_push($properties->$layerName->metadatanames, 'center'); array_push($properties->$layerName->metadatanames, 'area'); array_push($properties->$layerName->metadatanames, 'length'); /*get first shape to get the attributes*/ $oRes = $oLayer->getResult(0); $oShape = $oLayer->getShape($oRes->tileindex,$oRes->shapeindex); $selFields = array(); if (isset($_SESSION[$mapName][$layerName]['query_items'])) { $aQueryItems = $_SESSION[$mapName][$layerName]['query_items']; } else { //token separator (for parsing displayed attributes on a query) $tokenSeparator = ","; // checking if metadata "query_include_items" is set $metadataItems = $oLayer->getMetaData('query_include_items'); if ( ($metadataItems == "") || ($metadataItems == "all") ) { while ( list($key,$val) = each($oShape->values) ) { $aQueryItems[$key] = NULL; } } else { $token = strtok($metadataItems, $tokenSeparator); while ($token !== false) { $aQueryItems[trim($token)] = NULL; $token = strtok($tokenSeparator); } } // checking if metadata "query_exclude_items" is set $metadataItems = $oLayer->getMetaData('query_exclude_items'); if ($metadataItems != "") { $token = strtok($metadataItems, $tokenSeparator); while ($token !== false) { if (array_key_exists($token, $aQueryItems)) { unset($aQueryItems[$token]); } $token = strtok($tokenSeparator); } } // get all alias while ( list($key,$val) = each($aQueryItems) ) { $keyAlias = $oLayer->getMetaData("query_".$key."_alias"); trim($keyAlias); if ($keyAlias != "") { $aQueryItems[$key] = $keyAlias; } } $_SESSION[$mapName][$layerName]['query_items'] = $aQueryItems; } $oShape = $oLayer->getShape($oRes->tileindex,$oRes->shapeindex); while ( list($key,$val) = each($oShape->values) ) { if (array_key_exists($key, $aQueryItems)) { array_push($selFields, $key); //we check if an alias if provided if (isset($aQueryItems[$key]) && ($aQueryItems[$key] != "")){ $key = $aQueryItems[$key]; } array_push($properties->$layerName->propertynames, $key); //TODO : we should define away to give alias to field names array_push($properties->$layerName->propertyvalues, $key); //TODO we do not know the types of the attributes in MS. Just output 0 //we shouls possibly use OGR to get the attributes array_push($properties->$layerName->propertytypes, 0); } } for ($iRes=0; $iRes < $numResults; $iRes++) { $properties->$layerName->values[$iRes] = array(); $properties->$layerName->metadata[$iRes] = array(); $oRes = $oLayer->getResult($iRes); $oShape = $oLayer->getShape($oRes->tileindex,$oRes->shapeindex); //TODO : area, length and distance are not set $minx = $oShape->bounds->minx; $miny = $oShape->bounds->miny; $maxx = $oShape->bounds->maxx; $maxy = $oShape->bounds->maxy; if ($bFirstElement) { $bFirstElement = 0; $totalminx = $minx; $totalminy = $miny; $totalmaxx = $maxx; $totalmaxy = $maxy; } else { if ($totalminx > $minx) { $totalminx = $minx; } if ($totalminy > $miny) { $totalminy = $miny; } if ($totalmaxx < $maxx) { $totalmaxx = $maxx; } if ($totalmaxy < $maxy) { $totalmaxy = $maxy; } } //metadata : TODO dimension, area, length and distance are not set $dimension = 0; $center = 0; $area = 0; $length = 0; $bbox = $minx.','.$miny.','.$maxx.','.$maxy; array_push($properties->$layerName->metadata[$iRes], $dimension); array_push($properties->$layerName->metadata[$iRes], $bbox); array_push($properties->$layerName->metadata[$iRes], $center); array_push($properties->$layerName->metadata[$iRes], $area); array_push($properties->$layerName->metadata[$iRes], $length); //field values for($iField=0; $iField < count($selFields); $iField++) { $value = $oShape->values[$selFields[$iField]]; //$value = preg_replace( "/\r?\n/", "
", $value ); $value = str_replace("'", "\'", $value); array_push($properties->$layerName->values[$iRes], $value); } } $oLayer->close(); } //extents $properties->extents = NULL; $properties->extents->minx = $totalminx; $properties->extents->miny = $totalminy; $properties->extents->maxx = $totalmaxx; $properties->extents->maxy = $totalmaxy; /*save selection in the session*/ $_SESSION['selection_array'] = $properties; } echo var2json($result); ?>
_______________________________________________
fusion-dev mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fusion-dev
Paul Spencer-2

Re: extendselection in mapserver

Reply Threaded More More options
Print post
Permalink
Hi,

thanks for posting this, this is a nice improvement to incorporate -  
the formatting seems to have been lost entirely though, so it is  
almost impossible to tell where your changes are.

If possible, try to post a diff rather than the whole file.  You can  
use svn for this or a variety of other tools depending on your platform.

And don't forget to register to the mailing list ;)

Cheers

Paul

On 14-Nov-08, at 4:05 AM, klementszabolcs wrote:

> Hi.
> I make a solution for mapserver extendselection.
> The file Mapserver/php/Query.php is attached.
> The interested lines is 123-160
>
>
> numlayers; $bAllLayers = true; } $result = NULL; $result-
> >hasSelection = false; $result->layers = array();  
> $sellayers=array(); for ($i=0; $i<$nLayers; $i++) { if (!
> $bAllLayers) { $oLayer = $oMap->GetLayerByName($layers[$i]); } else  
> { $oLayer = $oMap->GetLayer($i); } $oLayer->set('tolerance', 0); //
> klement //if (strcasecmp($layers[$i],'ing_telepulesrol')==0) { //
> $oLayer->set('data',str_replace('%x_ing_telepulesre%',
> $_REQUEST['x_ing_telepulesre'],$oLayer->data)); $oLayer-
> >set('data',str_replace('%x_ing_telepulesrol%',
> $_REQUEST['x_ing_telepulesrol'],$oLayer->data)); $oLayer-
> >set('data',str_replace('%x_fo%',$_REQUEST['x_fo'],$oLayer->data));  
> $oLayer->set('data',str_replace('%x_column%',$_REQUEST['x_column'],
> $oLayer->data)); $oLayer-
> >set('data',str_replace('%x_elerhetoseg_tazon%',
> $_REQUEST['x_elerhetoseg_tazon'],$oLayer->data)); $oLayer-
> >set('data',str_replace('%x_min%',$_REQUEST['x_min'],$oLayer-
> >data)); $oLayer->set('data',str_replace('%x_max%',
> $_REQUEST['x_max'],$oLayer->data)); // } if ($oLayer->type ==  
> MS_LAYER_RASTER || $oLayer->type == MS_LAYER_QUERY || $oLayer->type  
> == MS_LAYER_CIRCLE || $oLayer->type == MS_LAYER_CHART) { continue; }  
> if (@$oLayer->queryByShape($oSpatialFilter) == MS_SUCCESS) { $result-
> >hasSelection = true; $layerName = $oLayer->name; array_push($result-
> >layers, $layerName); $result->$layerName->featureCount = $oLayer-
> >getNumResults(); if ($bExtendSelection) { $selfeatures=array(); for  
> ($iRes=0; $iRes < $oLayer->getNumResults(); $iRes++) { $oRes =  
> $oLayer->getResult($iRes); $selfe=NULL; $selfe->tileindex=$oRes-
> >tileindex; $selfe->shapeindex=$oRes->shapeindex;  
> array_push($selfeatures,$selfe); } array_push($sellayers,  
> $selfeatures); } } } if ($bExtendSelection) { $oMap-
> >loadquery(getSessionSavePath()."query.qry"); for  
> ($i=0;$iGetLayerByName($result->layers[$i]); //$AAA=$oMap-
> >GetLayer($la->index); //echo ($AAA->name); //echo count($ss).','.
> $la->index.':'; for ($j=0;$jindex.':'.$xx->tileindex.','.$xx-
> >shapeindex.';'; $aa=$oMap->queryByIndex($la->index,$xx->tileindex,
> $xx->shapeindex,MS_TRUE); } } } header('Content-type: text/x-json');  
> header('X-JSON: true'); if ($result->hasSelection) { $oMap-
> >savequery(getSessionSavePath()."query.qry"); $result->queryFile =  
> getSessionSavePath()."query.qry"; /*holds selection array*/  
> $properties = NULL; $properties->layers = array(); $totalminx = 0;  
> $totalminy = 0; $totalmaxx = 0; $totalmaxy = 0; $bFirstElement = 1;  
> $nLayers = $oMap->numlayers; for ($i=0; $i<$nLayers; $i++) { $oLayer  
> = $oMap->GetLayer($i); $numResults = $oLayer->getNumResults(); if  
> ($numResults == 0){ continue; } $oLayer->open(); $layerName =  
> $oLayer->name != "" ? $oLayer->name : "Layer_".$i;  
> array_push($properties->layers, $layerName); $properties->$layerName-
> >numelements = $numResults; $properties->$layerName->propertynames =  
> array(); $properties->$layerName->propertyvalues = array();  
> $properties->$layerName->propertytypes = array(); $properties->
> $layerName->values = array(); $properties->$layerName-
> >metadatanames= array(); array_push($properties->$layerName-
> >metadatanames, 'dimension'); array_push($properties->$layerName-
> >metadatanames, 'bbox'); array_push($properties->$layerName-
> >metadatanames, 'center'); array_push($properties->$layerName-
> >metadatanames, 'area'); array_push($properties->$layerName-
> >metadatanames, 'length'); /*get first shape to get the attributes*/  
> $oRes = $oLayer->getResult(0); $oShape = $oLayer->getShape($oRes-
> >tileindex,$oRes->shapeindex); $selFields = array(); if  
> (isset($_SESSION[$mapName][$layerName]['query_items']))  
> { $aQueryItems = $_SESSION[$mapName][$layerName]['query_items']; }  
> else { //token separator (for parsing displayed attributes on a  
> query) $tokenSeparator = ","; // checking if metadata  
> "query_include_items" is set $metadataItems = $oLayer-
> >getMetaData('query_include_items'); if ( ($metadataItems == "") ||  
> ($metadataItems == "all") ) { while ( list($key,$val) = each($oShape-
> >values) ) { $aQueryItems[$key] = NULL; } } else { $token =  
> strtok($metadataItems, $tokenSeparator); while ($token !== false)  
> { $aQueryItems[trim($token)] = NULL; $token =  
> strtok($tokenSeparator);              } } // checking if metadata  
> "query_exclude_items" is set $metadataItems = $oLayer-
> >getMetaData('query_exclude_items'); if ($metadataItems != "")  
> { $token = strtok($metadataItems, $tokenSeparator);                
> while ($token !== false) { if (array_key_exists($token,  
> $aQueryItems)) { unset($aQueryItems[$token]); } $token =  
> strtok($tokenSeparator); } } // get all alias while ( list($key,
> $val) = each($aQueryItems) ) { $keyAlias = $oLayer-
> >getMetaData("query_".$key."_alias"); trim($keyAlias); if  
> ($keyAlias != "") { $aQueryItems[$key] = $keyAlias; } }  
> $_SESSION[$mapName][$layerName]['query_items'] = $aQueryItems; }  
> $oShape = $oLayer->getShape($oRes->tileindex,$oRes->shapeindex);  
> while ( list($key,$val) = each($oShape->values) ) { if  
> (array_key_exists($key, $aQueryItems)) { array_push($selFields,  
> $key); //we check if an alias if provided if  
> (isset($aQueryItems[$key]) && ($aQueryItems[$key] != "")){ $key =  
> $aQueryItems[$key]; } array_push($properties->$layerName-
> >propertynames, $key); //TODO : we should define away to give alias  
> to field names array_push($properties->$layerName->propertyvalues,  
> $key); //TODO we do not know the types of the attributes in MS. Just  
> output 0 //we shouls possibly use OGR to get the attributes  
> array_push($properties->$layerName->propertytypes, 0); } } for  
> ($iRes=0; $iRes < $numResults; $iRes++) { $properties->$layerName-
> >values[$iRes] = array(); $properties->$layerName->metadata[$iRes] =  
> array(); $oRes = $oLayer->getResult($iRes); $oShape = $oLayer-
> >getShape($oRes->tileindex,$oRes->shapeindex); //TODO : area, length  
> and distance are not set $minx = $oShape->bounds->minx; $miny =  
> $oShape->bounds->miny; $maxx = $oShape->bounds->maxx; $maxy =  
> $oShape->bounds->maxy; if ($bFirstElement) { $bFirstElement = 0;  
> $totalminx = $minx; $totalminy = $miny; $totalmaxx = $maxx;  
> $totalmaxy = $maxy; } else { if ($totalminx > $minx) { $totalminx =  
> $minx; } if ($totalminy > $miny) { $totalminy = $miny; } if  
> ($totalmaxx < $maxx) { $totalmaxx = $maxx; } if ($totalmaxy < $maxy)  
> { $totalmaxy = $maxy; } } //metadata : TODO dimension, area, length  
> and distance are not set $dimension = 0; $center = 0; $area = 0;  
> $length = 0; $bbox = $minx.','.$miny.','.$maxx.','.$maxy;  
> array_push($properties->$layerName->metadata[$iRes], $dimension);  
> array_push($properties->$layerName->metadata[$iRes], $bbox);  
> array_push($properties->$layerName->metadata[$iRes], $center);  
> array_push($properties->$layerName->metadata[$iRes], $area);  
> array_push($properties->$layerName->metadata[$iRes], $length); //
> field values for($iField=0; $iField < count($selFields); $iField++)  
> { $value = $oShape->values[$selFields[$iField]]; //$value =  
> preg_replace( "/\r?\n/", "
> ", $value ); $value = str_replace("'", "\'", $value);  
> array_push($properties->$layerName->values[$iRes],  
> $value);            } } $oLayer->close(); } //extents $properties-
> >extents = NULL; $properties->extents->minx = $totalminx;  
> $properties->extents->miny = $totalminy; $properties->extents->maxx  
> = $totalmaxx; $properties->extents->maxy = $totalmaxy; /*save  
> selection in the session*/ $_SESSION['selection_array'] =  
> $properties; } echo var2json($result); ?>  
> _______________________________________________
> fusion-dev mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/fusion-dev


__________________________________________

    Paul Spencer
    Chief Technology Officer
    DM Solutions Group Inc
    http://research.dmsolutions.ca/

_______________________________________________
fusion-dev mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fusion-dev
Free Embeddable Forum Powered by Nabble Help