src/DQL/SumIfWithinLastXHours.php line 20

Open in your IDE?
  1. <?php
  3. namespace App\DQL;
  5. use Doctrine\ORM\Query\AST\Functions\FunctionNode;
  6. use Doctrine\ORM\Query\Lexer;
  8. /**
  9. * @author Cosmin-Romeo TANASE <[email protected]>
  10. */
  11. class SumIfWithinLastXHours extends FunctionNode
  12. {
  13. private $expr = [];
  15. public function parse(\Doctrine\ORM\Query\Parser $parser)
  16. {
  17. $parser->match(Lexer::T_IDENTIFIER);
  18. $parser->match(Lexer::T_OPEN_PARENTHESIS);
  20. $this->date = $parser->ArithmeticFactor();
  22. $parser->match(Lexer::T_COMMA);
  23. $this->intervalExpression = $parser->ArithmeticFactor();
  25. $parser->match(Lexer::T_CLOSE_PARENTHESIS);
  26. }
  28. public function getSql(\Doctrine\ORM\Query\SqlWalker $sqlWalker)
  29. {
  30. return sprintf(
  31. 'SUM(IF((%s>DATE_SUB(NOW(), INTERVAL %s HOUR)), 1, 0))',
  32. $sqlWalker->walkArithmeticTerm($this->date),
  33. $sqlWalker->walkArithmeticTerm($this->intervalExpression)
  34. );
  35. }
  36. }