Skip to content
Snippets Groups Projects
Select Git revision
  • master
  • release_4.0.0
  • laminas_migration
  • 4.0.0
  • 3.0.3
  • 3.0.2
  • 3.0.1
  • 3.0.0
  • 1.2.15
  • 1.2.14
  • 1.2.13
  • 1.2.12
  • 1.2.11
  • 1.2.10
  • 1.2.9
  • 1.2.8
  • 1.2.7
  • 1.2.6
  • 1.2.5
  • 1.2.4
  • 1.2.3
  • 1.2.2
  • 1.2.1
23 results

CompriseEntre.php

Blame
  • Code owners
    Assign users and groups as approvers for specific file changes. Learn more.
    CompriseEntre.php 1.50 KiB
    <?php
    
    namespace UnicaenOracle\ORM\Query\Functions;
    
    use Doctrine\ORM\Query\AST\Functions\FunctionNode;
    use Doctrine\ORM\Query\Lexer;
    use Doctrine\ORM\Query\Parser;
    use Doctrine\ORM\Query\SqlWalker;
    
    class CompriseEntre extends FunctionNode
    {
        public $histoCreation;
        public $histoDestruction;
        public $dateObs;
    
        public function getSql(SqlWalker $sqlWalker)
        {
            $sql = sprintf('UNICAEN_ORACLE.COMPRISE_ENTRE(%s, %s',
                    $this->histoCreation->dispatch($sqlWalker),
                    $this->histoDestruction->dispatch($sqlWalker));
            
            if ($this->dateObs){
                $sql .= ','.$this->dateObs->dispatch($sqlWalker);
            }
            $sql .= ')';
            return $sql;
        }
    
        /**
         * NB: le format DQL attendu est "compriseEntre"
         * (et non pas "UNICAEN_ORACLE.COMPRISE_ENTRE").
         * 
         * @param Parser $parser
         */
        public function parse(Parser $parser)
        {
            $lexer = $parser->getLexer();
            $parser->match(Lexer::T_IDENTIFIER);
            $parser->match(Lexer::T_OPEN_PARENTHESIS);
            $this->histoCreation = $parser->ArithmeticPrimary();
            if(Lexer::T_COMMA === $lexer->lookahead['type']){
                $parser->match(Lexer::T_COMMA);
                $this->histoDestruction = $parser->ArithmeticPrimary();
            }
            if(Lexer::T_COMMA === $lexer->lookahead['type']){
                $parser->match(Lexer::T_COMMA);
                $this->dateObs = $parser->ArithmeticPrimary();
            }
            $parser->match(Lexer::T_CLOSE_PARENTHESIS);
        }
    }