1) { // A searchword MUST be at least two characters long! $swordArray[$i]['sword'] = $val; $swordArray[$i]['oper'] = $lastoper ?: $defaultOperator; $lastoper = ''; $i++; } } } } return $swordArray; } /** * Used to split a search-word line up into elements to search for. This function will detect boolean words like AND and OR, + and -, and even find sentences encapsulated in "" * This function could be re-written to be more clean and effective - yet it's not that important. * * @param string $origSword The raw sword string from outside * @param string $specchars Special chars which are used as operators (+- is default) * @param string $delchars Special chars which are deleted if the append the searchword (+-., is default) * @return array|null Returns an ARRAY if there were search words, otherwise the return value may be unset. */ protected static function split(string $origSword, string $specchars = '+-', string $delchars = '+.,-'): ?array { $value = null; $sword = $origSword; $specs = '[' . preg_quote($specchars, '/') . ']'; // As long as $sword is TRUE (that means $sword MUST be reduced little by little until its empty inside the loop!) while ($sword) { // There was a double-quote and we will then look for the ending quote. if (preg_match('/^"/', $sword)) { // Removes first double-quote $sword = (string)preg_replace('/^"/', '', $sword); // Removes everything till next double-quote preg_match('/^[^"]*/', $sword, $reg); // reg[0] is the value, should not be trimmed $value[] = (string)$reg[0]; $sword = (string)preg_replace('/^' . preg_quote($reg[0], '/') . '/', '', $sword); // Removes last double-quote $sword = trim((string)preg_replace('/^"/', '', $sword)); } elseif (preg_match('/^' . $specs . '/', $sword, $reg)) { $value[] = (string)$reg[0]; // Removes = sign $sword = trim((string)preg_replace('/^' . $specs . '/', '', $sword)); } elseif (preg_match('/[\\+\\-]/', $sword)) { // Check if $sword contains + or - // + and - shall only be interpreted as $specchars when there's whitespace before it // otherwise it's included in the searchword (e.g. "know-how") // explode $sword to single words $a_sword = explode(' ', $sword); // get first word $word = (string)array_shift($a_sword); // Delete $delchars at end of string $word = rtrim($word, $delchars); // add searchword to values $value[] = $word; // re-build $sword $sword = implode(' ', $a_sword); } else { // There are no double-quotes around the value. Looking for next (space) or special char. preg_match('/^[^ ' . preg_quote($specchars, '/') . ']*/', $sword, $reg); // Delete $delchars at end of string $word = rtrim(trim($reg[0]), $delchars); $value[] = $word; $sword = trim((string)preg_replace('/^' . preg_quote($reg[0], '/') . '/', '', $sword)); } } return $value; } /** * This returns an SQL search-operator (eg. AND, OR, NOT) translated from the current localized set of operators (eg. in danish OG, ELLER, IKKE). * * @param string $operator The possible operator to find in the internal operator array. * @param array $operatorTranslateTable an array of possible operators * @return string|null If found, the SQL operator for the localized input operator. */ protected static function getOperator(string $operator, array $operatorTranslateTable): ?string { $operator = trim($operator); // case-conversion is charset insensitive, but it doesn't spoil // anything if input string AND operator table is already converted $operator = strtolower($operator); foreach ($operatorTranslateTable as $key => $val) { $item = $operatorTranslateTable[$key][0]; // See note above. $item = strtolower($item); if ($operator == $item) { return $operatorTranslateTable[$key][1]; } } return null; } /** * If MySQL Fulltext feature is used, the DB tables "index_rel" and "index_words" are not in use * and skipped in various places. */ public static function isMysqlFullTextEnabled(): bool { $extConf = GeneralUtility::makeInstance(ExtensionConfiguration::class)->get('indexed_search'); return (bool)($extConf['useMysqlFulltext'] ?? false); } }