/** * Set operator after checking for compatibility * addWhere strtouppers the operator */ public function setOperator($operator) { if (empty($operator)) { return false; } if (!PHPWS_DB::checkOperator($operator)) { return PHPWS_Error::get(PHPWS_DB_BAD_OP, 'core', 'PHPWS_DB::addWhere', _('DB Operator:') . $operator); } if ($operator == 'LIKE' || $operator == 'ILIKE') { $operator = $GLOBALS['PHPWS_DB']['lib']->getLike(); } elseif ($operator == 'NOT LIKE' || $operator == 'NOT ILIKE') { $operator = 'NOT ' . $GLOBALS['PHPWS_DB']['lib']->getLike(); } elseif ($operator == '~' || $operator == '~*' || $operator == 'REGEXP' || $operator == 'RLIKE') { $operator = $GLOBALS['PHPWS_DB']['lib']->getRegexp(); } elseif ($operator == '!~' || $operator == '!~*' || $operator == 'NOT REGEXP' || $operator == 'NOT RLIKE') { $operator = $GLOBALS['PHPWS_DB']['lib']->getNotRegexp(); } $this->operator = $operator; }