introduce util function to query db from command line

diff --git a/lib/Geocode.php b/lib/Geocode.php
index 9b7b9d6c596d620e539b6dfbf323b8ca6a5bf32f..8d3ae79aeff5c97612f163506aeb3939e80ff4ac 100644 (file)
--- a/lib/Geocode.php
+++ b/lib/Geocode.php
@@ -202,6 +202,98 @@
                        return $this->sQuery;
                }
 
+
+               function loadParamArray($aParams)
+               {
+                       if (isset($aParams['addressdetails'])) $this->bIncludeAddressDetails = (bool)$aParams['addressdetails'];
+                       if (isset($aParams['bounded'])) $this->bBoundedSearch = (bool)$aParams['bounded'];
+                       if (isset($aParams['dedupe'])) $this->bDeDupe = (bool)$aParams['dedupe'];
+
+                       if (isset($aParams['limit'])) $this->setLimit((int)$aParams['limit']);
+                       if (isset($aParams['offset'])) $this->iOffset = (int)$aParams['offset'];
+
+                       if (isset($aParams['fallback'])) $this->bFallback = (bool)$aParams['fallback'];
+
+                       // List of excluded Place IDs - used for more acurate pageing
+                       if (isset($aParams['exclude_place_ids']) && $aParams['exclude_place_ids'])
+                       {
+                               foreach(explode(',',$aParams['exclude_place_ids']) as $iExcludedPlaceID)
+                               {
+                                       $iExcludedPlaceID = (int)$iExcludedPlaceID;
+                                       if ($iExcludedPlaceID) $aExcludePlaceIDs[$iExcludedPlaceID] = $iExcludedPlaceID;
+                               }
+                               $this->aExcludePlaceIDs = $aExcludePlaceIDs;
+                       }
+
+                       // Only certain ranks of feature
+                       if (isset($aParams['featureType'])) $this->setFeatureType($aParams['featureType']);
+                       if (isset($aParams['featuretype'])) $this->setFeatureType($aParams['featuretype']);
+
+                       // Country code list
+                       if (isset($aParams['countrycodes']))
+                       {
+                               $aCountryCodes = array();
+                               foreach(explode(',',$aParams['countrycodes']) as $sCountryCode)
+                               {
+                                       if (preg_match('/^[a-zA-Z][a-zA-Z]$/', $sCountryCode))
+                                       {
+                                               $aCountryCodes[] = strtolower($sCountryCode);
+                                       }
+                               }
+                               $this->aCountryCodes = $aCountryCodes;
+                       }
+
+                       if (isset($aParams['viewboxlbrt']) && $aParams['viewboxlbrt'])
+                       {
+                               $aCoOrdinatesLBRT = explode(',',$aParams['viewboxlbrt']);
+                               $this->setViewBox($aCoOrdinatesLBRT[0], $aCoOrdinatesLBRT[1], $aCoOrdinatesLBRT[2], $aCoOrdinatesLBRT[3]);
+                       }
+                       else if (isset($aParams['viewbox']) && $aParams['viewbox'])
+                       {
+                               $aCoOrdinatesLTRB = explode(',',$aParams['viewbox']);
+                               $this->setViewBox($aCoOrdinatesLTRB[0], $aCoOrdinatesLTRB[3], $aCoOrdinatesLTRB[2], $aCoOrdinatesLTRB[1]);
+                       }
+
+                       if (isset($aParams['route']) && $aParams['route'] && isset($aParams['routewidth']) && $aParams['routewidth'])
+                       {
+                               $aPoints = explode(',',$aParams['route']);
+                               if (sizeof($aPoints) % 2 != 0)
+                               {
+                                       userError("Uneven number of points");
+                                       exit;
+                               }
+                               $fPrevCoord = false;
+                               $aRoute = array();
+                               foreach($aPoints as $i => $fPoint)
+                               {
+                                       if ($i%2)
+                                       {
+                                               $aRoute[] = array((float)$fPoint, $fPrevCoord);
+                                       }
+                                       else
+                                       {
+                                               $fPrevCoord = (float)$fPoint;
+                                       }
+                               }
+                               $this->aRoutePoints = $aRoute;
+                       }
+               }
+
+               function setQueryFromParams($aParams)
+               {
+                       // Search query
+                       $sQuery = (isset($aParams['q'])?trim($aParams['q']):'');
+                       if (!$sQuery)
+                       {
+                               $this->setStructuredQuery(@$aParams['amenity'], @$aParams['street'], @$aParams['city'], @$aParams['county'], @$aParams['state'], @$aParams['country'], @$aParams['postalcode']);
+                               $this->setReverseInPlan(false);
+                       }
+                       else
+                       {
+                               $this->setQuery($sQuery);
+                       }
+               }
+
                function loadStructuredAddressElement($sValue, $sKey, $iNewMinAddressRank, $iNewMaxAddressRank, $aItemListValues)
                {
                        $sValue = trim($sValue);

diff --git a/lib/lib.php b/lib/lib.php
index b2f85ca2a4f1f721c31ecf793ec0cc0b1714dc9c..6fdc45a052c704714f3f399b4458e8822a20c50b 100644 (file)
--- a/lib/lib.php
+++ b/lib/lib.php
@@ -117,18 +117,26 @@
        }
 
 
-       function getPreferredLanguages()
+       function getPreferredLanguages($sLangString=false)
        {
-               // If we have been provided the value in $_GET it overrides browser value
-               if (isset($_GET['accept-language']) && $_GET['accept-language'])
+               if (!$sLangString)
                {
-                       $_SERVER["HTTP_ACCEPT_LANGUAGE"] = $_GET['accept-language'];
+                       // If we have been provided the value in $_GET it overrides browser value
+                       if (isset($_GET['accept-language']) && $_GET['accept-language'])
+                       {
+                               $_SERVER["HTTP_ACCEPT_LANGUAGE"] = $_GET['accept-language'];
+                               $sLangString = $_GET['accept-language'];
+                       }
+                       else if (isset($_SERVER["HTTP_ACCEPT_LANGUAGE"]))
+                       {
+                               $sLangString = $_SERVER["HTTP_ACCEPT_LANGUAGE"];
+                       }
                }
 
                $aLanguages = array();
-               if (isset($_SERVER["HTTP_ACCEPT_LANGUAGE"]))
+               if ($sLangString)
                {
-                       if (preg_match_all('/(([a-z]{1,8})(-[a-z]{1,8})?)\s*(;\s*q\s*=\s*(1|0\.[0-9]+))?/i', $_SERVER['HTTP_ACCEPT_LANGUAGE'], $aLanguagesParse, PREG_SET_ORDER))
+                       if (preg_match_all('/(([a-z]{1,8})(-[a-z]{1,8})?)\s*(;\s*q\s*=\s*(1|0\.[0-9]+))?/i', $sLangString, $aLanguagesParse, PREG_SET_ORDER))
                        {
                                foreach($aLanguagesParse as $iLang => $aLanguage)
                                {

diff --git a/website/search.php b/website/search.php
index d4004ddbc3a40ba41e1a8c9edc232ff3761a7898..872d9801761a58664fa25b7221a47ceb9aa2f677 100755 (executable)
--- a/website/search.php
+++ b/website/search.php
@@ -3,7 +3,7 @@
 
        require_once(dirname(dirname(__FILE__)).'/lib/init-website.php');
        require_once(CONST_BasePath.'/lib/log.php');
-        require_once(CONST_BasePath.'/lib/Geocode.php');
+       require_once(CONST_BasePath.'/lib/Geocode.php');
 
        ini_set('memory_limit', '200M');
 
@@ -25,104 +25,6 @@
        if (isset($aLangPrefOrder['name:ja'])) $oGeocode->setReverseInPlan(true);
        if (isset($aLangPrefOrder['name:pl'])) $oGeocode->setReverseInPlan(true);
 
-       function loadParamsToGeocode($oGeocode, $aParams, $bBatch = false)
-       {
-               if (isset($aParams['addressdetails'])) $oGeocode->setIncludeAddressDetails((bool)$aParams['addressdetails']);
-               if (isset($aParams['bounded'])) $oGeocode->setBounded((bool)$aParams['bounded']);
-               if (isset($aParams['dedupe'])) $oGeocode->setDedupe((bool)$aParams['dedupe']);
-
-               if (isset($aParams['limit'])) $oGeocode->setLimit((int)$aParams['limit']);
-               if (isset($aParams['offset'])) $oGeocode->setOffset((int)$aParams['offset']);
-
-               if (isset($aParams['fallback'])) $oGeocode->setFallback((int)$aParams['fallback']);
-
-               // List of excluded Place IDs - used for more acurate pageing
-               if (isset($aParams['exclude_place_ids']) && $aParams['exclude_place_ids'])
-               {
-                       foreach(explode(',',$aParams['exclude_place_ids']) as $iExcludedPlaceID)
-                       {
-                               $iExcludedPlaceID = (int)$iExcludedPlaceID;
-                               if ($iExcludedPlaceID) $aExcludePlaceIDs[$iExcludedPlaceID] = $iExcludedPlaceID;
-                       }
-                       $oGeocode->setExcludedPlaceIds($aExcludePlaceIDs);
-               }
-
-               // Only certain ranks of feature
-               if (isset($aParams['featureType'])) $oGeocode->setFeatureType($aParams['featureType']);
-               if (isset($aParams['featuretype'])) $oGeocode->setFeatureType($aParams['featuretype']);
-
-               // Country code list
-               if (isset($aParams['countrycodes']))
-               {
-                       $aCountryCodes = array();
-                       foreach(explode(',',$aParams['countrycodes']) as $sCountryCode)
-                       {
-                               if (preg_match('/^[a-zA-Z][a-zA-Z]$/', $sCountryCode))
-                               {
-                                       $aCountryCodes[] = strtolower($sCountryCode);
-                               }
-                       }
-                       $oGeocode->setCountryCodesList($aCountryCodes);
-               }
-
-               if (isset($aParams['viewboxlbrt']) && $aParams['viewboxlbrt'])
-               {
-                       $aCoOrdinatesLBRT = explode(',',$aParams['viewboxlbrt']);
-                       $oGeocode->setViewBox($aCoOrdinatesLBRT[0], $aCoOrdinatesLBRT[1], $aCoOrdinatesLBRT[2], $aCoOrdinatesLBRT[3]);
-               }
-               else if (isset($aParams['viewbox']) && $aParams['viewbox'])
-               {
-                       $aCoOrdinatesLTRB = explode(',',$aParams['viewbox']);
-                       $oGeocode->setViewBox($aCoOrdinatesLTRB[0], $aCoOrdinatesLTRB[3], $aCoOrdinatesLTRB[2], $aCoOrdinatesLTRB[1]);
-               }
-
-               if (isset($aParams['route']) && $aParams['route'] && isset($aParams['routewidth']) && $aParams['routewidth'])
-               {
-                       $aPoints = explode(',',$aParams['route']);
-                       if (sizeof($aPoints) % 2 != 0)
-                       {
-                               userError("Uneven number of points");
-                               exit;
-                       }
-                       $fPrevCoord = false;
-                       $aRoute = array();
-                       foreach($aPoints as $i => $fPoint)
-                       {
-                               if ($i%2)
-                               {
-                                       $aRoute[] = array((float)$fPoint, $fPrevCoord);
-                               }
-                               else
-                               {
-                                       $fPrevCoord = (float)$fPoint;
-                               }
-                       }
-                       $oGeocode->setRoute($aRoute);
-               }
-
-               // Search query
-               $sQuery = (isset($aParams['q'])?trim($aParams['q']):'');
-               if (!$sQuery && !$bBatch && isset($_SERVER['PATH_INFO']) && $_SERVER['PATH_INFO'][0] == '/')
-               {
-                       $sQuery = substr($_SERVER['PATH_INFO'], 1);
-
-                       // reverse order of '/' separated string
-                       $aPhrases = explode('/', $sQuery);
-                       $aPhrases = array_reverse($aPhrases);
-                       $sQuery = join(', ',$aPhrases);
-               }
-               if (!$sQuery)
-               {
-                       $oGeocode->setStructuredQuery(@$aParams['amenity'], @$aParams['street'], @$aParams['city'], @$aParams['county'], @$aParams['state'], @$aParams['country'], @$aParams['postalcode']);
-                       $oGeocode->setReverseInPlan(false);
-               }
-               else
-               {
-                       $oGeocode->setQuery($sQuery);
-               }
-
-       }
-
        // Format for output
        $sOutputFormat = 'html';
        if (isset($_GET['format']) && ($_GET['format'] == 'html' || $_GET['format'] == 'xml' || $_GET['format'] == 'json' ||  $_GET['format'] == 'jsonv2'))
@@ -166,7 +68,7 @@
                $oGeocode->setIncludePolygonAsSVG($bAsSVG);
        }
 
-       loadParamsToGeocode($oGeocode, $_GET, false);
+       $oGeocode->loadParamArray($_GET);
 
        if (CONST_Search_BatchMode && isset($_GET['batch']))
        {
@@ -175,13 +77,30 @@
                foreach($aBatch as $aBatchParams)
                {
                        $oBatchGeocode = clone $oGeocode;
-                       loadParamsToGeocode($oBatchGeocode, $aBatchParams, true);
+                       $oBatchGeocode->loadParamArray($aBatchParams);
+                       $oBatchGeocode->setQueryFromParams($aBatchParams);
                        $aSearchResults = $oBatchGeocode->lookup();
                        $aBatchResults[] = $aSearchResults;
                }
                include(CONST_BasePath.'/lib/template/search-batch-json.php');
                exit;
-       }
+       } else {
+        if (!(isset($_GET['q']) && $_GET['q']) && isset($_SERVER['PATH_INFO']) && $_SERVER['PATH_INFO'][0] == '/')
+        {
+            $sQuery = substr($_SERVER['PATH_INFO'], 1);
+
+            // reverse order of '/' separated string
+            $aPhrases = explode('/', $sQuery);
+            $aPhrases = array_reverse($aPhrases);
+            $sQuery = join(', ',$aPhrases);
+            $oGeocode->setQuery($sQuery);
+        }
+        else
+        {
+            $oGeocode->setQueryFromParams($_GET);
+        }
+
+    }
 
        $hLog = logStart($oDB, 'search', $oGeocode->getQueryString(), $aLangPrefOrder);