5 require_once(CONST_LibDir.'/SimpleWordList.php');
12 private $oTransliterator;
14 public function __construct(&$oDB)
17 $this->oNormalizer = \Transliterator::createFromRules(CONST_Term_Normalization_Rules);
18 $this->oTransliterator = \Transliterator::createFromRules(CONST_Transliteration);
21 public function checkStatus()
23 $sSQL = 'SELECT word_id FROM word WHERE word_id is not null limit 1';
24 $iWordID = $this->oDB->getOne($sSQL);
25 if ($iWordID === false) {
26 throw new \Exception('Query failed', 703);
29 throw new \Exception('No value', 704);
34 public function normalizeString($sTerm)
36 if ($this->oNormalizer === null) {
40 return $this->oNormalizer->transliterate($sTerm);
44 public function mostFrequentWords($iNum)
46 $sSQL = "SELECT word FROM word WHERE type = 'W'";
47 $sSQL .= "ORDER BY info->'count' DESC LIMIT ".$iNum;
48 return $this->oDB->getCol($sSQL);
52 private function makeStandardWord($sTerm)
54 return trim($this->oTransliterator->transliterate(' '.$sTerm.' '));
58 public function tokensForSpecialTerm($sTerm)
62 $sSQL = "SELECT word_id, info->>'class' as class, info->>'type' as type ";
63 $sSQL .= ' FROM word WHERE word_token = :term and type = \'S\'';
65 Debug::printVar('Term', $sTerm);
66 Debug::printSQL($sSQL);
67 $aSearchWords = $this->oDB->getAll($sSQL, array(':term' => $this->makeStandardWord($sTerm)));
69 Debug::printVar('Results', $aSearchWords);
71 foreach ($aSearchWords as $aSearchTerm) {
72 $aResults[] = new \Nominatim\Token\SpecialTerm(
73 $aSearchTerm['word_id'],
74 $aSearchTerm['class'],
76 \Nominatim\Operator::TYPE
80 Debug::printVar('Special term tokens', $aResults);
86 public function extractTokensFromPhrases(&$aPhrases)
89 $aWordLists = array();
91 foreach ($aPhrases as $iPhrase => $oPhrase) {
92 $sNormPhrase = $this->normalizeString($oPhrase->getPhrase());
93 Debug::printVar('Phrase', $sNormPhrase);
95 $oWordList = new SimpleWordList($sNormPhrase);
97 foreach ($oWordList->getTokens() as $sToken) {
98 $sTransToken = $this->makeStandardWord($sToken);
99 if (!isset($aTokens[$sTransToken])) {
100 $aTokens[$sTransToken] = array();
102 $aTokens[$sTransToken][$sToken] = $sToken;
105 $aWordLists[] = $oWordList;
108 Debug::printVar('Tokens', $aTokens);
109 Debug::printVar('WordLists', $aWordLists);
111 $oValidTokens = $this->computeValidTokens($aTokens);
113 foreach ($aPhrases as $iPhrase => $oPhrase) {
114 $oPhrase->setWordSets($aWordLists[$iPhrase]->getWordSets($oValidTokens));
117 return $oValidTokens;
121 private function computeValidTokens($aTokens)
123 $oValidTokens = new TokenList();
125 if (!empty($aTokens)) {
126 $this->addTokensFromDB($oValidTokens, $aTokens);
128 // Try more interpretations for Tokens that could not be matched.
129 foreach ($aTokens as $sToken => $aNormalized) {
130 if (!$oValidTokens->contains($sToken)) {
131 if (preg_match('/^([0-9]{5}) [0-9]{4}$/', $sToken, $aData)) {
132 // US ZIP+4 codes - merge in the 5-digit ZIP code
133 $oValidTokens->addToken(
135 new Token\Postcode(null, $aData[1], 'us')
137 } elseif (preg_match('/^[0-9]+$/', $sToken)) {
138 // Unknown single word token with a number.
139 // Assume it is a house number.
140 $oValidTokens->addToken(
142 new Token\HouseNumber(null, trim($sToken))
149 return $oValidTokens;
153 private function addTokensFromDB(&$oValidTokens, $aTokens)
155 // Check which tokens we have, get the ID numbers
156 $sSQL = 'SELECT word_id, word_token, type, word,';
157 $sSQL .= " info->>'op' as operator,";
158 $sSQL .= " info->>'class' as class, info->>'type' as ctype,";
159 $sSQL .= " info->>'count' as count";
160 $sSQL .= ' FROM word WHERE word_token in (';
161 $sSQL .= join(',', $this->oDB->getDBQuotedList(array_keys($aTokens))).')';
163 Debug::printSQL($sSQL);
165 $aDBWords = $this->oDB->getAll($sSQL, null, 'Could not get word tokens.');
167 foreach ($aDBWords as $aWord) {
168 $iId = (int) $aWord['word_id'];
169 $sTok = $aWord['word_token'];
170 $aNorms = $aTokens[$sTok];
172 switch ($aWord['type']) {
173 case 'C': // country name tokens
174 if ($aWord['word'] !== null) {
175 foreach ($aNorms as $sNorm) {
176 $oValidTokens->addToken(
178 new Token\Country($iId, $aWord['word'])
183 case 'H': // house number tokens
184 foreach ($aNorms as $sNorm) {
185 $oValidTokens->addToken($sNorm, new Token\HouseNumber($iId, $aWord['word_token']));
188 case 'P': // postcode tokens
189 // Postcodes are not normalized, so they may have content
190 // that makes SQL injection possible. Reject postcodes
191 // that would need special escaping.
192 if ($aWord['word'] !== null
193 && pg_escape_string($aWord['word']) == $aWord['word']
195 $sNormPostcode = $this->normalizeString($aWord['word']);
196 foreach ($aNorms as $sNorm) {
197 if ($sNormPostcode == $sNorm) {
198 $oValidTokens->addToken(
200 new Token\Postcode($iId, $aWord['word'], null)
206 case 'S': // tokens for classification terms (special phrases)
207 if ($aWord['class'] !== null && $aWord['ctype'] !== null) {
208 foreach ($aNorms as $sNorm) {
209 if ($aWord['word'] == $sNorm) {
210 $oValidTokens->addToken($sTok, new Token\SpecialTerm(
214 (isset($aWord['operator'])) ? Operator::NEAR : Operator::NONE
220 case 'W': // full-word tokens
221 foreach ($aNorms as $sNorm) {
222 $oValidTokens->addToken($sNorm, new Token\Word(
224 (int) $aWord['count'],
225 substr_count($aWord['word_token'], ' ') + 1,
226 levenshtein($aWord['word'], $sNorm) + 1
230 case 'w': // partial word terms
231 foreach ($aNorms as $sNorm) {
232 $oValidTokens->addToken($sNorm, new Token\Partial(
234 $aWord['word_token'],
235 (int) $aWord['count']