X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/b14bc75dc4a0ca44485599d8ab4cf1c5781098e2..3ff8bb55a72e958b141e1967c426e127595beeb8:/website/polygons.php?ds=inline diff --git a/website/polygons.php b/website/polygons.php index b855214a..153a279d 100755 --- a/website/polygons.php +++ b/website/polygons.php @@ -1,141 +1,134 @@ getOne('select count(*) from import_polygon_error')); +$sOutputFormat = 'html'; +$iDays = $oParams->getInt('days', 1); +$bReduced = $oParams->getBool('reduced', false); +$sClass = $oParams->getString('class', false); - $aPolygons = array(); - while($iTotalBroken && !sizeof($aPolygons)) - { - $sSQL = 'select osm_type as "type",osm_id as "id",class as "key",type as "value",name->\'name\' as "name",'; - $sSQL .= 'country_code as "country",errormessage as "error message",updated'; - $sSQL .= " from import_polygon_error"; - $sSQL .= " where updated > 'now'::timestamp - '".$iDays." day'::interval"; - $iDays++; +$oDB =& getDB(); - if ($bReduced) $sSQL .= " and errormessage like 'Area reduced%'"; - if ($sClass) $sSQL .= " and class = '".pg_escape_string($sClass)."'"; - $sSQL .= " order by updated desc limit 1000"; - $aPolygons = chksql($oDB->getAll($sSQL)); - } +$iTotalBroken = (int) chksql($oDB->getOne('select count(*) from import_polygon_error')); + +$aPolygons = array(); +while ($iTotalBroken && !sizeof($aPolygons)) { + $sSQL = 'select osm_type as "type",osm_id as "id",class as "key",type as "value",name->\'name\' as "name",'; + $sSQL .= 'country_code as "country",errormessage as "error message",updated'; + $sSQL .= " from import_polygon_error"; + $sSQL .= " where updated > 'now'::timestamp - '".$iDays." day'::interval"; + $iDays++; + + if ($bReduced) $sSQL .= " and errormessage like 'Area reduced%'"; + if ($sClass) $sSQL .= " and class = '".pg_escape_string($sClass)."'"; + $sSQL .= " order by updated desc limit 1000"; + $aPolygons = chksql($oDB->getAll($sSQL)); +} + +if (CONST_Debug) { + var_dump($aPolygons); + exit; +} - if (CONST_Debug) - { - var_dump($aPolygons); - exit; - } ?>
- - - -".$sCol." | "; - } - echo ""; - echo " | "; - echo " | ||||
---|---|---|---|---|---|---|
".($sVal?$sVal:' ')." | "; - } - else - { - echo "".($sVal?$sVal:' ')." | "; - } - break; - case 'id': - echo ''.osmLink($aRow).' | '; - break; - default: - echo "".($sVal?$sVal:' ')." | "; - break; - } - } - echo "josm | "; - if (isset($aRow['lat'])) - { - echo "P2 | "; - } - else - { - echo ""; - } - echo " |