X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/ec4e3c36af238ae3c31a2f5eb727fe2a22f6d054..5ddf77f59e531e7975ae2cdf381cbf5b60640bbc:/website/deletable.php?ds=sidebyside diff --git a/website/deletable.php b/website/deletable.php index 5b94d45b..2d7ee7e9 100644 --- a/website/deletable.php +++ b/website/deletable.php @@ -5,101 +5,26 @@ require_once(CONST_BasePath.'/lib/log.php'); require_once(CONST_BasePath.'/lib/output.php'); ini_set('memory_limit', '200M'); -$sOutputFormat = 'html'; +$oParams = new Nominatim\ParameterParser(); +$sOutputFormat = $oParams->getSet('format', array('html', 'json'), 'html'); +set_exception_handler_by_format($sOutputFormat); -$oDB =& getDB(); +$oDB = new Nominatim\DB(); +$oDB->connect(); $sSQL = 'select placex.place_id, country_code,'; $sSQL .= " name->'name' as name, i.* from placex, import_polygon_delete i"; $sSQL .= ' where placex.osm_id = i.osm_id and placex.osm_type = i.osm_type'; $sSQL .= ' and placex.class = i.class and placex.type = i.type'; -$aPolygons = chksql($oDB->getAll($sSQL), 'Could not get list of deleted OSM elements.'); +$aPolygons = $oDB->getAll($sSQL, null, 'Could not get list of deleted OSM elements.'); if (CONST_Debug) { var_dump($aPolygons); exit; } -?> - - - - - - - Nominatim Deleted Data - - - - - - - - -

Objects in this table have been deleted in OSM but are still in the Nominatim database.

- - -'; -// var_dump($aPolygons[0]); -foreach ($aPolygons[0] as $sCol => $sVal) { - echo ''; +if ($sOutputFormat == 'json') { + echo javascript_renderData($aPolygons); +} else { + include(CONST_BasePath.'/lib/template/deletable-html.php'); } -echo ''; -foreach ($aPolygons as $aRow) { - echo ''; - foreach ($aRow as $sCol => $sVal) { - switch ($sCol) { - case 'osm_id': - echo ''; - break; - case 'place_id': - echo ''; - break; - default: - echo ''; - break; - } - } - echo ''; -} - -?> -
'.$sCol.'
'.osmLink($aRow).''.detailsLink($aRow).''.($sVal?$sVal:' ').'
- - - - -