refactor ReverseGeocode

[nominatim.git] / website / polygons.php
diff --git a/website/polygons.php b/website/polygons.php

index 3c98bdbca86030651042b83bc34c4eb52dd8dc13..b855214a89a6ece1e65e762ef40f67e0a0ef28e8 100755 (executable)
--- a/website/polygons.php
+++ b/website/polygons.php
@@ -2,40 +2,38 @@
         require_once(dirname(dirname(__FILE__)).'/settings/settings.php');
         require_once(CONST_BasePath.'/lib/init-website.php');
         require_once(CONST_BasePath.'/lib/log.php');
-
-       $sOutputFormat = 'html';
+       require_once(CONST_BasePath.'/lib/output.php');
         ini_set('memory_limit', '200M');
  
         $oDB =& getDB();
-       if (!isset($_GET['days'])) $_GET['days'] = 1;
-       $bReduced = false;
-       if (isset($_GET['reduced'])) $bReduced = true;
-       $sClass = false;
-       if (isset($_GET['class'])) $sClass = $_GET['class'];
+
+       $sOutputFormat = 'html';
+       $iDays = getParamInt('days', 1);
+       $bReduced = getParamBool('reduced', false);
+       $sClass = getParamString('class', false);
+
+       $iTotalBroken = (int) chksql($oDB->getOne('select count(*) from import_polygon_error'));
  
         $aPolygons = array();
-       while(!sizeof($aPolygons))
+       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";
-               if ($_GET['days'])
-               {
-                       $sSQL .= " where updated > 'now'::timestamp - '".(int)$_GET['days']." day'::interval";
-                       $_GET['days']++;
-               }
-               if ($bReduced)
-               {
-                       $sSQL .= " and errormessage like 'Area reduced%'";
-               }
-               if ($sClass)
-               {
-                       $sSQL .= " and class = '".pg_escape_string($sClass)."'";
-               }
+               $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 = $oDB->getAll($sSQL);
+               $aPolygons = chksql($oDB->getAll($sSQL));
+       }
+
+       if (CONST_Debug)
+       {
+               var_dump($aPolygons);
+               exit;
         }
-//var_dump($aPolygons);
  ?>
  <!DOCTYPE html>
  <html>
@@ -84,6 +82,8 @@ table td {
  
  <?php
  
+       echo "<p>Total number of broken polygons: $iTotalBroken</p>";
+       if (!$aPolygons) exit;
         echo "<table>";
         echo "<tr>";
  //var_dump($aPolygons[0]);
@@ -117,8 +117,7 @@ table td {
                                 }
                                 break;
                         case 'id':
-                               $sOSMType = ($aRow['type'] == 'N'?'node':($aRow['type'] == 'W'?'way':($aRow['type'] == 'R'?'relation':'')));
-                               echo '<td><a href="http://www.openstreetmap.org/browse/'.$sOSMType.'/'.$aRow['id'].'" target="_new">'.$aRow['id'].'</a></td>';
+                               echo '<td>'.osmLink($aRow).'</td>';
                                 break;
                         default:
                                 echo "<td>".($sVal?$sVal:'&nbsp;')."</td>";
@@ -137,10 +136,6 @@ table td {
                 echo "</tr>";
         }
         echo "</table>";
-
-
-
-//     include(CONST_BasePath.'/lib/template/details-'.$sOutputFormat.'.php');
  ?>
  </body>
  </html>