AbsFunction.php
9 months ago
AvgFunction.php
9 months ago
BitAndFunction.php
9 months ago
BitOrFunction.php
9 months ago
ConcatFunction.php
9 months ago
CountFunction.php
9 months ago
CurrentDateFunction.php
9 months ago
CurrentTimeFunction.php
9 months ago
CurrentTimestampFunction.php
9 months ago
DateAddFunction.php
9 months ago
DateDiffFunction.php
9 months ago
DateSubFunction.php
9 months ago
FunctionNode.php
9 months ago
IdentityFunction.php
9 months ago
LengthFunction.php
9 months ago
LocateFunction.php
9 months ago
LowerFunction.php
9 months ago
MaxFunction.php
9 months ago
MinFunction.php
9 months ago
ModFunction.php
9 months ago
SizeFunction.php
9 months ago
SqrtFunction.php
9 months ago
SubstringFunction.php
9 months ago
SumFunction.php
9 months ago
TrimFunction.php
9 months ago
UpperFunction.php
9 months ago
index.php
9 months ago
DateSubFunction.php
32 lines
| 1 | <?php |
| 2 | declare (strict_types=1); |
| 3 | namespace MailPoetVendor\Doctrine\ORM\Query\AST\Functions; |
| 4 | if (!defined('ABSPATH')) exit; |
| 5 | use MailPoetVendor\Doctrine\ORM\Query\QueryException; |
| 6 | use MailPoetVendor\Doctrine\ORM\Query\SqlWalker; |
| 7 | use function strtolower; |
| 8 | class DateSubFunction extends DateAddFunction |
| 9 | { |
| 10 | public function getSql(SqlWalker $sqlWalker) |
| 11 | { |
| 12 | switch (strtolower($this->unit->value)) { |
| 13 | case 'second': |
| 14 | return $sqlWalker->getConnection()->getDatabasePlatform()->getDateSubSecondsExpression($this->firstDateExpression->dispatch($sqlWalker), $this->intervalExpression->dispatch($sqlWalker)); |
| 15 | case 'minute': |
| 16 | return $sqlWalker->getConnection()->getDatabasePlatform()->getDateSubMinutesExpression($this->firstDateExpression->dispatch($sqlWalker), $this->intervalExpression->dispatch($sqlWalker)); |
| 17 | case 'hour': |
| 18 | return $sqlWalker->getConnection()->getDatabasePlatform()->getDateSubHourExpression($this->firstDateExpression->dispatch($sqlWalker), $this->intervalExpression->dispatch($sqlWalker)); |
| 19 | case 'day': |
| 20 | return $sqlWalker->getConnection()->getDatabasePlatform()->getDateSubDaysExpression($this->firstDateExpression->dispatch($sqlWalker), $this->intervalExpression->dispatch($sqlWalker)); |
| 21 | case 'week': |
| 22 | return $sqlWalker->getConnection()->getDatabasePlatform()->getDateSubWeeksExpression($this->firstDateExpression->dispatch($sqlWalker), $this->intervalExpression->dispatch($sqlWalker)); |
| 23 | case 'month': |
| 24 | return $sqlWalker->getConnection()->getDatabasePlatform()->getDateSubMonthExpression($this->firstDateExpression->dispatch($sqlWalker), $this->intervalExpression->dispatch($sqlWalker)); |
| 25 | case 'year': |
| 26 | return $sqlWalker->getConnection()->getDatabasePlatform()->getDateSubYearsExpression($this->firstDateExpression->dispatch($sqlWalker), $this->intervalExpression->dispatch($sqlWalker)); |
| 27 | default: |
| 28 | throw QueryException::semanticalError('DATE_SUB() only supports units of type second, minute, hour, day, week, month and year.'); |
| 29 | } |
| 30 | } |
| 31 | } |
| 32 |