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 use Doctrine\ORM\Query\QueryException;

    26 

    27 /**

    28  * "DATE_ADD(date1, interval, unit)"

    29  *

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

    31  * @link    www.doctrine-project.org

    32  * @since   2.0

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

    34  */

    35 class DateAddFunction extends FunctionNode

    36 {

    37     public $firstDateExpression = null;

    38     public $intervalExpression = null;

    39     public $unit = null;

    40 

    41     public function getSql(SqlWalker $sqlWalker)

    42     {

    43         $unit = strtolower($this->unit);

    44         if ($unit == "day") {

    45             return $sqlWalker->getConnection()->getDatabasePlatform()->getDateAddDaysExpression(

    46                 $this->firstDateExpression->dispatch($sqlWalker),

    47                 $this->intervalExpression->dispatch($sqlWalker)

    48             );

    49         } else if ($unit == "month") {

    50             return $sqlWalker->getConnection()->getDatabasePlatform()->getDateAddMonthExpression(

    51                 $this->firstDateExpression->dispatch($sqlWalker),

    52                 $this->intervalExpression->dispatch($sqlWalker)

    53             );

    54         } else {

    55             throw QueryException::semanticalError('DATE_ADD() only supports units of type day and month.');

    56         }

    57     }

    58 

    59     public function parse(Parser $parser)

    60     {

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

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

    63 

    64         $this->firstDateExpression = $parser->ArithmeticPrimary();

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

    66         $this->intervalExpression = $parser->ArithmeticPrimary();

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

    68         $this->unit = $parser->StringPrimary();

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

    70     }

    71 }