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 

    24 /**

    25  * "LOCATE" "(" StringPrimary "," StringPrimary ["," SimpleArithmeticExpression]")"

    26  *

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

    28  * @link    www.doctrine-project.org

    29  * @since   2.0

    30  * @author  Guilherme Blanco <guilhermeblanco@hotmail.com>

    31  * @author  Jonathan Wage <jonwage@gmail.com>

    32  * @author  Roman Borschel <roman@code-factory.org>

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

    34  */

    35 class LocateFunction extends FunctionNode

    36 {

    37     public $firstStringPrimary;

    38     public $secondStringPrimary;

    39     public $simpleArithmeticExpression = false;

    40 

    41     /**

    42      * @override

    43      */

    44     public function getSql(\Doctrine\ORM\Query\SqlWalker $sqlWalker)

    45     {

    46 

    47         return $sqlWalker->getConnection()->getDatabasePlatform()->getLocateExpression(

    48             $sqlWalker->walkStringPrimary($this->secondStringPrimary), // its the other way around in platform

    49             $sqlWalker->walkStringPrimary($this->firstStringPrimary),

    50             (($this->simpleArithmeticExpression)

    51                 ? $sqlWalker->walkSimpleArithmeticExpression($this->simpleArithmeticExpression)

    52                 : false

    53             )

    54         );

    55     }

    56 

    57     /**

    58      * @override

    59      */

    60     public function parse(\Doctrine\ORM\Query\Parser $parser)

    61     {

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

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

    64         

    65         $this->firstStringPrimary = $parser->StringPrimary();

    66         

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

    68         

    69         $this->secondStringPrimary = $parser->StringPrimary();

    70         

    71         $lexer = $parser->getLexer();

    72         if ($lexer->isNextToken(Lexer::T_COMMA)) {

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

    74             

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

    76         }

    77         

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

    79     }

    80 }

    81