From: marc tobias <mtmail@gmx.net>
Date: Tue, 2 Apr 2019 12:49:31 +0000 (+0200)
Subject: On postcode searches observe given bounded viewbox
X-Git-Tag: v3.3.0~12^2
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/c9a63508943d92cfe2a1f5d2c12454662bb46770

On postcode searches observe given bounded viewbox
---

diff --git a/lib/SearchDescription.php b/lib/SearchDescription.php
index 358e6969..506d4202 100644
--- a/lib/SearchDescription.php
+++ b/lib/SearchDescription.php
@@ -588,6 +588,9 @@ class SearchDescription
 
         $sSQL .= "p.postcode = '".reset($this->aName)."'";
         $sSQL .= $this->countryCodeSQL(' AND p.country_code');
+        if ($this->oContext->bViewboxBounded) {
+            $sSQL .= ' AND ST_Intersects('.$this->oContext->sqlViewboxSmall.', geometry)';
+        }
         $sSQL .= $this->oContext->excludeSQL(' AND p.place_id');
         $sSQL .= " LIMIT $iLimit";
 
diff --git a/test/bdd/api/search/postcode.feature b/test/bdd/api/search/postcode.feature
index 63c86469..e70495f6 100644
--- a/test/bdd/api/search/postcode.feature
+++ b/test/bdd/api/search/postcode.feature
@@ -26,6 +26,18 @@ Feature: Searches with postcodes
             | country_code |
             | li           |
 
+    Scenario: Postcode search with bounded viewbox restriction
+        When sending json search query "9486" with address
+          | bounded | viewbox |
+          | 1       | 9.55,47.20,9.58,47.22 |
+        Then result addresses contain
+            | postcode |
+            | 9486     |
+        When sending json search query "9486" with address
+          | bounded | viewbox                 |
+          | 1       | 5.00,20.00,6.00,21.00 |
+        Then exactly 0 results are returned
+
     Scenario: Postcode search with structured query
         When sending json search query "" with address
             | postalcode | country |