MysqlCeil.php

<?php
namespace Ttree\Medialib\Analytics\Query\AST;

/*                                                                        *
 * This script belongs to the FLOW3 package "Ttree.Medialib".             *
 *                                                                        *
 *                                                                        */

use TYPO3\Flow\Annotations as Flow;
use \Doctrine\ORM\Query\AST\Functions\FunctionNode;
use \Doctrine\ORM\Query\Lexer;

class MysqlCeil extends FunctionNode {

  public $simpleArithmeticExpression;

	public function getSql(\Doctrine\ORM\Query\SqlWalker $sqlWalker) {
		return 'CEIL(' . $sqlWalker->walkSimpleArithmeticExpression(
			$this->simpleArithmeticExpression
		) . ')';
	}

	public function parse(\Doctrine\ORM\Query\Parser $parser) {
		$lexer = $parser->getLexer();

		$parser->match(Lexer::T_IDENTIFIER);
		$parser->match(Lexer::T_OPEN_PARENTHESIS);

		$this->simpleArithmeticExpression = $parser->SimpleArithmeticExpression();

		$parser->match(Lexer::T_CLOSE_PARENTHESIS);
	}

}

?>

$config = $this->entityManager->getConfiguration();
$config->addCustomNumericFunction('CEIL', 'Ttree\Medialib\Analytics\Query\AST\MysqlCeil');