File manager - Edit - /home/c14075/dragmet-ural.ru/www/bitrix/modules/main/lib/orm/query/filter/operator.php
Back
<?php /** * Bitrix Framework * @package bitrix * @subpackage main * @copyright 2001-2016 Bitrix */ namespace Bitrix\Main\ORM\Query\Filter; use Bitrix\Main\ORM\Query\Filter\Expressions\NullExpression; /** * SQL operators handler. * @package bitrix * @subpackage main */ class Operator { /** * Available operators. * @var array */ protected static $operators = array( '=' => 'eq', '<>' => 'neq', '!=' => 'neq', '<' => 'lt', '<=' => 'lte', '>' => 'gt', '>=' => 'gte', 'in' => 'in', 'between' => 'between', 'like' => 'like', 'exists' => 'exists', 'match' => 'match', 'expr' => 'expr' ); /** * List of available operators `code => method`. * * @return array */ 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) { return "MATCH ({$columnSql}) AGAINST ({$valueSql} IN BOOLEAN MODE)"; } public static function expr($columnSql, $valueSql) { return "{$columnSql}"; } }
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.28 |
proxy
|
phpinfo
|
Settings