public function getWhere()
    {
        $where = '';

        // add boolean where clause for searchwords
        if ($this->pObj->wordsAgainst != '') {
            $where .= ' AND MATCH (title, content) AGAINST (\'' . $this->pObj->wordsAgainst . '\' IN BOOLEAN MODE) ';
        }

        // add boolean where clause for tags
        if (($tagWhere = $this->createQueryForTags($this->pObj->tagsAgainst))) {
            $where .= $tagWhere;
        }

        // restrict to storage page
        $where .= ' AND pid in (' . $this->pObj->startingPoints . ') ';

        // add language
        $lang = intval($GLOBALS['TSFE']->sys_language_uid);
        $where .= ' AND language IN(' . $lang . ', -1) ';

        // add "tagged content only" searchphrase
        if ($this->conf['showTaggedContentOnly']) {
            $where .= ' AND tags <> ""';
        }

        // add enable fields
        $pageRepository = GeneralUtility::makeInstance(PageRepository::class);
        $where .= $pageRepository->enableFields($this->table);

        return $where;
    }
public function getWhere()
    {
        $where = '';

        // add boolean where clause for searchwords
        if ($this->pObj->wordsAgainst != '') {
            $where .= ' AND MATCH (title, content) AGAINST (\'' . $this->pObj->wordsAgainst . '\' IN BOOLEAN MODE) ';
        }

        // add boolean where clause for tags
        if (($tagWhere = $this->createQueryForTags($this->pObj->tagsAgainst))) {
            $where .= $tagWhere;
        }

        // restrict to storage page
        $where .= ' AND pid in (' . $this->pObj->startingPoints . ') ';

        // add language
        $lang = intval($GLOBALS['TSFE']->sys_language_uid);
        $where .= ' AND language IN(' . $lang . ', -1) ';

        // add "tagged content only" searchphrase
        if ($this->conf['showTaggedContentOnly']) {
            $where .= ' AND tags <> ""';
        }

        // add enable fields
        $pageRepository = GeneralUtility::makeInstance(PageRepository::class);
        $where .= $pageRepository->enableFields($this->table);

        return $where;
    }
public function getWhere ( ) { $ where = '' ; // add boolean where clause for searchwords if ( $ this -> pObj -> wordsAgainst != '' ) { $ where .= ' AND MATCH (title, content) AGAINST (\'' . $ this -> pObj -> wordsAgainst . '\' IN BOOLEAN MODE) ' ; } // add boolean where clause for tags if ( ( $ tagWhere = $ this -> createQueryForTags ( $ this -> pObj -> tagsAgainst ) ) ) { $ where .= $ tagWhere ; } // restrict to storage page $ where .= ' AND pid in (' . $ this -> pObj -> startingPoints . ') ' ; // add language $ lang = intval ( $ GLOBALS [ 'TSFE' ] -> sys_language_uid ) ; $ where .= ' AND language IN(' . $ lang . ', -1) ' ; // add "tagged content only" searchphrase if ( $ this -> conf [ 'showTaggedContentOnly' ] ) { $ where .= ' AND tags <> ""' ; } // add enable fields $ pageRepository = GeneralUtility :: makeInstance ( PageRepository :: class ) ; $ where .= $ pageRepository -> enableFields ( $ this -> table ) ; return $ where ; }
get where clause for search results

@return string where clause
get where clause for search results