operator.php

<?php
namespace Bitrix\Main\ORM\Query\Filter;
use Bitrix\Main\ORM\Query\Filter\Expressions\NullExpression;
 
class Operator
{
    protected static $operators = array(
        '=' => 'eq',
        '<>' => 'neq',
        '!=' => 'neq',
        '<' => 'lt',
        '<=' => 'lte',
        '>' => 'gt',
        '>=' => 'gte',
        'in' => 'in',
        'between' => 'between',
        'like' => 'like',
        'exists' => 'exists',
        'match' => 'match',
        'expr' => 'expr'
    );
 
    public static function get()
    {
        return static::$operators;
    }
 
    public static function eq($columnSql, $valueSql)
    {
        if ($valueSql instanceof NullExpression)
        {
            return "{$columnSql} IS NULL";
        }
        return "{$columnSql} = {$valueSql}";
    }
 
    public static function neq($columnSql, $valueSql)
    {
        if ($valueSql instanceof NullExpression)
        {
            return "{$columnSql} IS NOT NULL";
        }
        return "{$columnSql} <> {$valueSql}";
    }
 
    public static function lt($columnSql, $valueSql)
    {
        return "{$columnSql} < {$valueSql}";
    }
 
    public static function lte($columnSql, $valueSql)
    {
        return "{$columnSql} <= {$valueSql}";
    }
 
    public static function gt($columnSql, $valueSql)
    {
        return "{$columnSql} > {$valueSql}";
    }
 
    public static function gte($columnSql, $valueSql)
    {
        return "{$columnSql} >= {$valueSql}";
    }
 
    public static function in($columnSql, $valueSql)
    {
        return "{$columnSql} IN (".join(', ', (array) $valueSql).")";
    }
 
    public static function between($columnSql, $valueSql)
    {
        return "{$columnSql} BETWEEN {$valueSql[0]} AND {$valueSql[1]}";
    }
 
    public static function like($columnSql, $valueSql)
    {
        return "{$columnSql} LIKE {$valueSql}";
    }
 
    public static function exists($columnSql, $valueSql)
    {
        return "EXISTS ({$valueSql})";
    }
 
    public static function match($columnSql, $valueSql)
    {
        $connection = \Bitrix\Main\Application::getConnection();
        $helper = $connection->getSqlHelper();
 
        return $helper->getMatchFunction($columnSql, $valueSql);
    }
 
    public static function expr($columnSql, $valueSql)
    {
        return "{$columnSql}";
    }
}