X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/4a321487f3d44241242a1729ab4d137df1f57bfb..12168e3ca9421ab1d0195507919c26ce029ce155:/website/polygons.php diff --git a/website/polygons.php b/website/polygons.php index a00e26db..4c1401ef 100755 --- a/website/polygons.php +++ b/website/polygons.php @@ -6,10 +6,10 @@ require_once(CONST_BasePath.'/lib/log.php'); require_once(CONST_BasePath.'/lib/output.php'); ini_set('memory_limit', '200M'); -$oParams = new ParameterParser(); +$oParams = new Nominatim\ParameterParser(); $sOutputFormat = 'html'; -$iDays = $oParams->getInt('days', 1); +$iDays = $oParams->getInt('days', false); $bReduced = $oParams->getBool('reduced', false); $sClass = $oParams->getString('class', false); @@ -21,13 +21,22 @@ $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++; + $sSQL .= ' from import_polygon_error'; - if ($bReduced) $sSQL .= " and errormessage like 'Area reduced%'"; - if ($sClass) $sSQL .= " and class = '".pg_escape_string($sClass)."'"; - $sSQL .= " order by updated desc limit 1000"; + $aWhere = array(); + if ($iDays) { + $aWhere[] = "updated > 'now'::timestamp - '".$iDays." day'::interval"; + $iDays++; + } + + if ($bReduced) $aWhere[] = "errormessage like 'Area reduced%'"; + if ($sClass) $sWhere[] = "class = '".pg_escape_string($sClass)."'"; + + if (sizeof($aWhere)) { + $sSQL .= ' where '.join(' and ', $aWhere); + } + + $sSQL .= ' order by updated desc limit 1000'; $aPolygons = chksql($oDB->getAll($sSQL)); } @@ -86,48 +95,42 @@ table td { echo "
Total number of broken polygons: $iTotalBroken
"; if (!$aPolygons) exit; -echo "".$sCol." | "; + echo ''.$sCol.' | '; } -echo ""; -echo " | "; -echo " | '; +echo ''; $aSeen = array(); foreach ($aPolygons as $aRow) { if (isset($aSeen[$aRow['type'].$aRow['id']])) continue; $aSeen[$aRow['type'].$aRow['id']] = 1; - echo " | |||||
---|---|---|---|---|---|---|---|---|---|
".($sVal?$sVal:' ')." | "; + echo ''.($sVal?$sVal:' ').' | '; } else { - echo "".($sVal?$sVal:' ')." | "; + echo ''.($sVal?$sVal:' ').' | '; } break; case 'id': echo ''.osmLink($aRow).' | '; break; default: - echo "".($sVal?$sVal:' ')." | "; + echo ''.($sVal?$sVal:' ').' | '; break; } } - echo "josm | "; - if (isset($aRow['lat'])) { - echo "P2 | "; - } else { - echo ""; - } - echo " | josm | '; + echo ''; } -echo "