X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/f05ea577f42c5ad4a62ff25ec62fbb60c550ee26..ec86a972a241754b66be0a31e73ca7ca27bc51de:/website/polygons.php diff --git a/website/polygons.php b/website/polygons.php old mode 100755 new mode 100644 index 2e7197ab..a2264b18 --- a/website/polygons.php +++ b/website/polygons.php @@ -1,39 +1,50 @@ getInt('days', 1); - $bReduced = $oParams->getBool('reduced', false); - $sClass = $oParams->getString('class', false); +$oParams = new Nominatim\ParameterParser(); - $oDB =& getDB(); +$sOutputFormat = 'html'; +$iDays = $oParams->getInt('days', false); +$bReduced = $oParams->getBool('reduced', false); +$sClass = $oParams->getString('class', false); - $iTotalBroken = (int) chksql($oDB->getOne('select count(*) from import_polygon_error')); +$oDB = new Nominatim\DB(); +$oDB->connect(); - $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++; +$iTotalBroken = (int) $oDB->getOne('select count(*) from import_polygon_error'); + +$aPolygons = array(); +while ($iTotalBroken && empty($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'; - 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)); + $aWhere = array(); + if ($iDays) { + $aWhere[] = "updated > 'now'::timestamp - '".$iDays." day'::interval"; + $iDays++; } - if (CONST_Debug) { - var_dump($aPolygons); - exit; + if ($bReduced) $aWhere[] = "errormessage like 'Area reduced%'"; + if ($sClass) $sWhere[] = "class = '".pg_escape_string($sClass)."'"; + + if (!empty($aWhere)) { + $sSQL .= ' where '.join(' and ', $aWhere); } + + $sSQL .= ' order by updated desc limit 1000'; + $aPolygons = $oDB->getAll($sSQL); +} + +if (CONST_Debug) { + var_dump($aPolygons); + exit; +} + ?> @@ -82,50 +93,45 @@ table td { Total number of broken polygons: $iTotalBroken

"; - if (!$aPolygons) exit; - echo ""; - echo ""; +echo "

Total number of broken polygons: $iTotalBroken

"; +if (!$aPolygons) exit; +echo '
'; +echo ''; //var_dump($aPolygons[0]); - foreach ($aPolygons[0] as $sCol => $sVal) { - 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 ""; - foreach ($aRow as $sCol => $sVal) { - switch ($sCol) { +foreach ($aPolygons[0] as $sCol => $sVal) { + echo ''; +} +echo ''; +echo ''; +$aSeen = array(); +foreach ($aPolygons as $aRow) { + if (isset($aSeen[$aRow['type'].$aRow['id']])) continue; + $aSeen[$aRow['type'].$aRow['id']] = 1; + echo ''; + foreach ($aRow as $sCol => $sVal) { + switch ($sCol) { case 'error message': - if (preg_match('/Self-intersection\\[([0-9.\\-]+) ([0-9.\\-]+)\\]/',$sVal,$aMatch)) { + if (preg_match('/Self-intersection\\[([0-9.\\-]+) ([0-9.\\-]+)\\]/', $sVal, $aMatch)) { $aRow['lat'] = $aMatch[2]; $aRow['lon'] = $aMatch[1]; - echo ""; + echo ''; } else { - echo ""; + echo ''; } break; case 'id': echo ''; break; default: - echo ""; + echo ''; break; - } } - echo ""; - if (isset($aRow['lat'])) { - echo ""; - } else { - echo ""; - } - echo ""; } - echo "
".$sCol."  
'.$sCol.' 
".($sVal?$sVal:' ')."'.($sVal?$sVal:' ').'".($sVal?$sVal:' ')."'.($sVal?$sVal:' ').''.osmLink($aRow).'".($sVal?$sVal:' ')."'.($sVal?$sVal:' ').'josmP2 
"; + echo 'josm'; + echo ''; +} +echo ''; + ?>