FileMaster

Edit File: Expr.php

<?php
declare (strict_types=1);
namespace MailPoetVendor\Doctrine\ORM\Query;
if (!defined('ABSPATH')) exit;
use Traversable;
use function func_get_args;
use function implode;
use function is_bool;
use function is_float;
use function is_int;
use function is_iterable;
use function iterator_to_array;
use function str_replace;
class Expr
{
 public function andX($x = null)
 {
 return new Expr\Andx(func_get_args());
 }
 public function orX($x = null)
 {
 return new Expr\Orx(func_get_args());
 }
 public function asc($expr)
 {
 return new Expr\OrderBy($expr, 'ASC');
 }
 public function desc($expr)
 {
 return new Expr\OrderBy($expr, 'DESC');
 }
 public function eq($x, $y)
 {
 return new Expr\Comparison($x, Expr\Comparison::EQ, $y);
 }
 public function neq($x, $y)
 {
 return new Expr\Comparison($x, Expr\Comparison::NEQ, $y);
 }
 public function lt($x, $y)
 {
 return new Expr\Comparison($x, Expr\Comparison::LT, $y);
 }
 public function lte($x, $y)
 {
 return new Expr\Comparison($x, Expr\Comparison::LTE, $y);
 }
 public function gt($x, $y)
 {
 return new Expr\Comparison($x, Expr\Comparison::GT, $y);
 }
 public function gte($x, $y)
 {
 return new Expr\Comparison($x, Expr\Comparison::GTE, $y);
 }
 public function avg($x)
 {
 return new Expr\Func('AVG', [$x]);
 }
 public function max($x)
 {
 return new Expr\Func('MAX', [$x]);
 }
 public function min($x)
 {
 return new Expr\Func('MIN', [$x]);
 }
 public function count($x)
 {
 return new Expr\Func('COUNT', [$x]);
 }
 public function countDistinct($x)
 {
 return 'COUNT(DISTINCT ' . implode(', ', func_get_args()) . ')';
 }
 public function exists($subquery)
 {
 return new Expr\Func('EXISTS', [$subquery]);
 }
 public function all($subquery)
 {
 return new Expr\Func('ALL', [$subquery]);
 }
 public function some($subquery)
 {
 return new Expr\Func('SOME', [$subquery]);
 }
 public function any($subquery)
 {
 return new Expr\Func('ANY', [$subquery]);
 }
 public function not($restriction)
 {
 return new Expr\Func('NOT', [$restriction]);
 }
 public function abs($x)
 {
 return new Expr\Func('ABS', [$x]);
 }
 public function mod($x, $y) : Expr\Func
 {
 return new Expr\Func('MOD', [$x, $y]);
 }
 public function prod($x, $y)
 {
 return new Expr\Math($x, '*', $y);
 }
 public function diff($x, $y)
 {
 return new Expr\Math($x, '-', $y);
 }
 public function sum($x, $y)
 {
 return new Expr\Math($x, '+', $y);
 }
 public function quot($x, $y)
 {
 return new Expr\Math($x, '/', $y);
 }
 public function sqrt($x)
 {
 return new Expr\Func('SQRT', [$x]);
 }
 public function in($x, $y)
 {
 if (is_iterable($y)) {
 if ($y instanceof Traversable) {
 $y = iterator_to_array($y);
 }
 foreach ($y as &$literal) {
 if (!$literal instanceof Expr\Literal) {
 $literal = $this->quoteLiteral($literal);
 }
 }
 }
 return new Expr\Func($x . ' IN', (array) $y);
 }
 public function notIn($x, $y)
 {
 if (is_iterable($y)) {
 if ($y instanceof Traversable) {
 $y = iterator_to_array($y);
 }
 foreach ($y as &$literal) {
 if (!$literal instanceof Expr\Literal) {
 $literal = $this->quoteLiteral($literal);
 }
 }
 }
 return new Expr\Func($x . ' NOT IN', (array) $y);
 }
 public function isNull($x)
 {
 return $x . ' IS NULL';
 }
 public function isNotNull($x)
 {
 return $x . ' IS NOT NULL';
 }
 public function like($x, $y)
 {
 return new Expr\Comparison($x, 'LIKE', $y);
 }
 public function notLike($x, $y)
 {
 return new Expr\Comparison($x, 'NOT LIKE', $y);
 }
 public function concat($x, $y)
 {
 return new Expr\Func('CONCAT', func_get_args());
 }
 public function substring($x, $from, $len = null)
 {
 $args = [$x, $from];
 if ($len !== null) {
 $args[] = $len;
 }
 return new Expr\Func('SUBSTRING', $args);
 }
 public function lower($x)
 {
 return new Expr\Func('LOWER', [$x]);
 }
 public function upper($x)
 {
 return new Expr\Func('UPPER', [$x]);
 }
 public function length($x)
 {
 return new Expr\Func('LENGTH', [$x]);
 }
 public function literal($literal)
 {
 return new Expr\Literal($this->quoteLiteral($literal));
 }
 private function quoteLiteral($literal) : string
 {
 if (is_int($literal) || is_float($literal)) {
 return (string) $literal;
 }
 if (is_bool($literal)) {
 return $literal ? 'true' : 'false';
 }
 return "'" . str_replace("'", "''", $literal) . "'";
 }
 public function between($val, $x, $y)
 {
 return $val . ' BETWEEN ' . $x . ' AND ' . $y;
 }
 public function trim($x)
 {
 return new Expr\Func('TRIM', $x);
 }
 public function isMemberOf($x, $y)
 {
 return new Expr\Comparison($x, 'MEMBER OF', $y);
 }
 public function isInstanceOf($x, $y)
 {
 return new Expr\Comparison($x, 'INSTANCE OF', $y);
 }
}

Back