10 private $oTransliterator;
11 private $aCountryRestriction;
13 public function __construct(&$oDB)
16 $this->oNormalizer = \Transliterator::createFromRules(CONST_Term_Normalization_Rules);
17 $this->oTransliterator = \Transliterator::createFromRules(CONST_Transliteration);
20 public function checkStatus()
22 $sSQL = "SELECT word_id FROM word WHERE word_token IN (' a')";
23 $iWordID = $this->oDB->getOne($sSQL);
24 if ($iWordID === false) {
25 throw new Exception('Query failed', 703);
28 throw new Exception('No value', 704);
33 public function setCountryRestriction($aCountries)
35 $this->aCountryRestriction = $aCountries;
39 public function normalizeString($sTerm)
41 if ($this->oNormalizer === null) {
45 return $this->oNormalizer->transliterate($sTerm);
48 private function makeStandardWord($sTerm)
50 return trim($this->oTransliterator->transliterate(' '.$sTerm.' '));
54 public function tokensForSpecialTerm($sTerm)
58 $sSQL = 'SELECT word_id, class, type FROM word ';
59 $sSQL .= ' WHERE word_token = \' \' || :term';
60 $sSQL .= ' AND class is not null AND class not in (\'place\')';
62 Debug::printVar('Term', $sTerm);
63 Debug::printSQL($sSQL);
64 $aSearchWords = $this->oDB->getAll($sSQL, array(':term' => $this->makeStandardWord($sTerm)));
66 Debug::printVar('Results', $aSearchWords);
68 foreach ($aSearchWords as $aSearchTerm) {
69 $aResults[] = new \Nominatim\Token\SpecialTerm(
70 $aSearchTerm['word_id'],
71 $aSearchTerm['class'],
73 \Nominatim\Operator::TYPE
77 Debug::printVar('Special term tokens', $aResults);
83 public function extractTokensFromPhrases(&$aPhrases)
86 $aWordLists = array();
88 foreach ($aPhrases as $iPhrase => $oPhrase) {
89 $sNormQuery .= ','.$this->normalizeString($oPhrase->getPhrase());
90 $sPhrase = $this->makeStandardWord($oPhrase->getPhrase());
91 Debug::printVar('Phrase', $sPhrase);
92 if (strlen($sPhrase) > 0) {
93 $aWords = explode(' ', $sPhrase);
94 Tokenizer::addTokens($aTokens, $aWords);
95 $aWordLists[] = $aWords;
97 $aWordLists[] = array();
101 Debug::printVar('Tokens', $aTokens);
102 Debug::printVar('WordLists', $aWordLists);
104 $oValidTokens = $this->computeValidTokens($aTokens, $sNormQuery);
106 foreach ($aPhrases as $iPhrase => $oPhrase) {
107 $oPhrase->computeWordSets($aWordLists[$iPhrase], $oValidTokens);
110 return $oValidTokens;
114 private function computeValidTokens($aTokens, $sNormQuery)
116 $oValidTokens = new TokenList();
118 if (!empty($aTokens)) {
119 $this->addTokensFromDB($oValidTokens, $aTokens, $sNormQuery);
121 // Try more interpretations for Tokens that could not be matched.
122 foreach ($aTokens as $sToken) {
123 if ($sToken[0] != ' ' && !$oValidTokens->contains($sToken)) {
124 if (preg_match('/^([0-9]{5}) [0-9]{4}$/', $sToken, $aData)) {
125 // US ZIP+4 codes - merge in the 5-digit ZIP code
126 $oValidTokens->addToken(
128 new Token\Postcode(null, $aData[1], 'us')
130 } elseif (preg_match('/^[0-9]+$/', $sToken)) {
131 // Unknown single word token with a number.
132 // Assume it is a house number.
133 $oValidTokens->addToken(
135 new Token\HouseNumber(null, trim($sToken))
142 return $oValidTokens;
146 private function addTokensFromDB(&$oValidTokens, $aTokens, $sNormQuery)
148 // Check which tokens we have, get the ID numbers
149 $sSQL = 'SELECT word_id, word_token, word, class, type, country_code,';
150 $sSQL .= ' operator, coalesce(search_name_count, 0) as count';
151 $sSQL .= ' FROM word WHERE word_token in (';
152 $sSQL .= join(',', $this->oDB->getDBQuotedList($aTokens)).')';
154 Debug::printSQL($sSQL);
156 $aDBWords = $this->oDB->getAll($sSQL, null, 'Could not get word tokens.');
158 foreach ($aDBWords as $aWord) {
160 $iId = (int) $aWord['word_id'];
162 if ($aWord['class']) {
163 // Special terms need to appear in their normalized form.
164 // (postcodes are not normalized in the word table)
165 $sNormWord = $this->normalizeString($aWord['word']);
166 if ($aWord['word'] && strpos($sNormQuery, $sNormWord) === false) {
170 if ($aWord['class'] == 'place' && $aWord['type'] == 'house') {
171 $oToken = new Token\HouseNumber($iId, trim($aWord['word_token']));
172 } elseif ($aWord['class'] == 'place' && $aWord['type'] == 'postcode') {
174 && pg_escape_string($aWord['word']) == $aWord['word']
176 $oToken = new Token\Postcode(
179 $aWord['country_code']
183 // near and in operator the same at the moment
184 $oToken = new Token\SpecialTerm(
188 $aWord['operator'] ? Operator::NEAR : Operator::NONE
191 } elseif ($aWord['country_code']) {
192 // Filter country tokens that do not match restricted countries.
193 if (!$this->aCountryRestriction
194 || in_array($aWord['country_code'], $this->aCountryRestriction)
196 $oToken = new Token\Country($iId, $aWord['country_code']);
198 } elseif ($aWord['word_token'][0] == ' ') {
199 $oToken = new Token\Word(
201 $aWord['word_token'][0] != ' ',
202 (int) $aWord['count'],
203 substr_count($aWord['word_token'], ' ')
206 $oToken = new Token\Partial(
208 $aWord['word_token'],
209 (int) $aWord['count']
214 // remove any leading spaces
215 if ($aWord['word_token'][0] == ' ') {
216 $oValidTokens->addToken(substr($aWord['word_token'], 1), $oToken);
218 $oValidTokens->addToken($aWord['word_token'], $oToken);
226 * Add the tokens from this phrase to the given list of tokens.
228 * @param string[] $aTokens List of tokens to append.
232 private static function addTokens(&$aTokens, $aWords)
234 $iNumWords = count($aWords);
236 for ($i = 0; $i < $iNumWords; $i++) {
237 $sPhrase = $aWords[$i];
238 $aTokens[' '.$sPhrase] = ' '.$sPhrase;
239 $aTokens[$sPhrase] = $sPhrase;
241 for ($j = $i + 1; $j < $iNumWords; $j++) {
242 $sPhrase .= ' '.$aWords[$j];
243 $aTokens[' '.$sPhrase] = ' '.$sPhrase;
244 $aTokens[$sPhrase] = $sPhrase;