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
DateAddFunction.php
49 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\AST\Node; |
| 6 | use MailPoetVendor\Doctrine\ORM\Query\Parser; |
| 7 | use MailPoetVendor\Doctrine\ORM\Query\QueryException; |
| 8 | use MailPoetVendor\Doctrine\ORM\Query\SqlWalker; |
| 9 | use MailPoetVendor\Doctrine\ORM\Query\TokenType; |
| 10 | use function strtolower; |
| 11 | class DateAddFunction extends FunctionNode |
| 12 | { |
| 13 | public $firstDateExpression = null; |
| 14 | public $intervalExpression = null; |
| 15 | public $unit = null; |
| 16 | public function getSql(SqlWalker $sqlWalker) |
| 17 | { |
| 18 | switch (strtolower($this->unit->value)) { |
| 19 | case 'second': |
| 20 | return $sqlWalker->getConnection()->getDatabasePlatform()->getDateAddSecondsExpression($this->firstDateExpression->dispatch($sqlWalker), $this->intervalExpression->dispatch($sqlWalker)); |
| 21 | case 'minute': |
| 22 | return $sqlWalker->getConnection()->getDatabasePlatform()->getDateAddMinutesExpression($this->firstDateExpression->dispatch($sqlWalker), $this->intervalExpression->dispatch($sqlWalker)); |
| 23 | case 'hour': |
| 24 | return $sqlWalker->getConnection()->getDatabasePlatform()->getDateAddHourExpression($this->firstDateExpression->dispatch($sqlWalker), $this->intervalExpression->dispatch($sqlWalker)); |
| 25 | case 'day': |
| 26 | return $sqlWalker->getConnection()->getDatabasePlatform()->getDateAddDaysExpression($this->firstDateExpression->dispatch($sqlWalker), $this->intervalExpression->dispatch($sqlWalker)); |
| 27 | case 'week': |
| 28 | return $sqlWalker->getConnection()->getDatabasePlatform()->getDateAddWeeksExpression($this->firstDateExpression->dispatch($sqlWalker), $this->intervalExpression->dispatch($sqlWalker)); |
| 29 | case 'month': |
| 30 | return $sqlWalker->getConnection()->getDatabasePlatform()->getDateAddMonthExpression($this->firstDateExpression->dispatch($sqlWalker), $this->intervalExpression->dispatch($sqlWalker)); |
| 31 | case 'year': |
| 32 | return $sqlWalker->getConnection()->getDatabasePlatform()->getDateAddYearsExpression($this->firstDateExpression->dispatch($sqlWalker), $this->intervalExpression->dispatch($sqlWalker)); |
| 33 | default: |
| 34 | throw QueryException::semanticalError('DATE_ADD() only supports units of type second, minute, hour, day, week, month and year.'); |
| 35 | } |
| 36 | } |
| 37 | public function parse(Parser $parser) |
| 38 | { |
| 39 | $parser->match(TokenType::T_IDENTIFIER); |
| 40 | $parser->match(TokenType::T_OPEN_PARENTHESIS); |
| 41 | $this->firstDateExpression = $parser->ArithmeticPrimary(); |
| 42 | $parser->match(TokenType::T_COMMA); |
| 43 | $this->intervalExpression = $parser->ArithmeticPrimary(); |
| 44 | $parser->match(TokenType::T_COMMA); |
| 45 | $this->unit = $parser->StringPrimary(); |
| 46 | $parser->match(TokenType::T_CLOSE_PARENTHESIS); |
| 47 | } |
| 48 | } |
| 49 |