|
@@ 726-734 (lines=9) @@
|
| 723 |
|
* @param string $sWord the search word |
| 724 |
|
* @return Statement |
| 725 |
|
*/ |
| 726 |
|
protected function searchDistinct($sWord) |
| 727 |
|
{ |
| 728 |
|
$expressionBuilder = GeneralUtility::makeInstance(ConnectionPool::class) |
| 729 |
|
->getQueryBuilderForTable('index_words') |
| 730 |
|
->expr(); |
| 731 |
|
$wSel = $expressionBuilder->eq('IW.wid', $this->md5inthash($sWord)); |
| 732 |
|
$this->wSelClauses[] = $wSel; |
| 733 |
|
return $this->execPHashListQuery($wSel, $expressionBuilder->eq('is_stopword', 0)); |
| 734 |
|
} |
| 735 |
|
|
| 736 |
|
/** |
| 737 |
|
* Search for a sentence |
|
@@ 771-779 (lines=9) @@
|
| 768 |
|
* @param string $sWord the search word |
| 769 |
|
* @return Statement |
| 770 |
|
*/ |
| 771 |
|
protected function searchMetaphone($sWord) |
| 772 |
|
{ |
| 773 |
|
$expressionBuilder = GeneralUtility::makeInstance(ConnectionPool::class) |
| 774 |
|
->getQueryBuilderForTable('index_words') |
| 775 |
|
->expr(); |
| 776 |
|
$wSel = $expressionBuilder->eq('IW.metaphone', $expressionBuilder->literal($sWord)); |
| 777 |
|
$this->wSelClauses[] = $wSel; |
| 778 |
|
return $this->execPHashListQuery($wSel, $expressionBuilder->eq('is_stopword', 0)); |
| 779 |
|
} |
| 780 |
|
|
| 781 |
|
/** |
| 782 |
|
* Returns AND statement for selection of section in database. (rootlevel 0-2 + page_id) |
TYPO3 /
TYPO3.CMS
