1 <?php

     2 /*

     3  * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS

     4  * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT

     5  * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR

     6  * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT

     7  * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,

     8  * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT

     9  * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,

    10  * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY

    11  * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT

    12  * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE

    13  * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

    14  *

    15  * This software consists of voluntary contributions made by many individuals

    16  * and is licensed under the LGPL. For more information, see

    17  * <http://www.doctrine-project.org>.

    18  */

    19 

    20 namespace Doctrine\ORM\Query\AST\Functions;

    21 

    22 use Doctrine\ORM\Query\Lexer;

    23 use Doctrine\ORM\Query\SqlWalker;

    24 use Doctrine\ORM\Query\Parser;

    25 

    26 /**

    27  * "DATE_DIFF(date1, date2)"

    28  *

    29  * @license http://www.opensource.org/licenses/lgpl-license.php LGPL

    30  * @link    www.doctrine-project.org

    31  * @since   2.0

    32  * @author  Benjamin Eberlei <kontakt@beberlei.de>

    33  */

    34 class DateDiffFunction extends FunctionNode

    35 {

    36     public $date1;

    37     public $date2;

    38 

    39     public function getSql(SqlWalker $sqlWalker)

    40     {

    41         return $sqlWalker->getConnection()->getDatabasePlatform()->getDateDiffExpression(

    42             $this->date1->dispatch($sqlWalker),

    43             $this->date2->dispatch($sqlWalker)

    44         );

    45     }

    46 

    47     public function parse(Parser $parser)

    48     {

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

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

    51 

    52         $this->date1 = $parser->ArithmeticPrimary();

    53         $parser->match(Lexer::T_COMMA);

    54         $this->date2 = $parser->ArithmeticPrimary();

    55 

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

    57     }

    58 }