Code Coverage |
||||||||||
Classes and Traits |
Functions and Methods |
Lines |
||||||||
| Total | |
0.00% |
0 / 1 |
|
0.00% |
0 / 2 |
CRAP | |
0.00% |
0 / 31 |
| Extract | |
0.00% |
0 / 1 |
|
0.00% |
0 / 2 |
90 | |
0.00% |
0 / 31 |
| parse | |
0.00% |
0 / 1 |
56 | |
0.00% |
0 / 23 |
|||
| getSql | |
0.00% |
0 / 1 |
6 | |
0.00% |
0 / 8 |
|||
| <?php | |
| /* | |
| * This file is part of EC-CUBE | |
| * | |
| * Copyright(c) 2000-2016 LOCKON CO.,LTD. All Rights Reserved. | |
| * | |
| * http://www.lockon.co.jp/ | |
| * | |
| * This program is free software; you can redistribute it and/or | |
| * modify it under the terms of the GNU General Public License | |
| * as published by the Free Software Foundation; either version 2 | |
| * of the License, or (at your option) any later version. | |
| * | |
| * This program is distributed in the hope that it will be useful, | |
| * but WITHOUT ANY WARRANTY; without even the implied warranty of | |
| * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | |
| * GNU General Public License for more details. | |
| * | |
| * You should have received a copy of the GNU General Public License | |
| * along with this program; if not, write to the Free Software | |
| * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. | |
| */ | |
| namespace Eccube\Doctrine\ORM\Query; | |
| use Doctrine\ORM\Query\AST\Functions\FunctionNode; | |
| use Doctrine\ORM\Query\Lexer; | |
| use Doctrine\ORM\Query\Parser; | |
| use Doctrine\ORM\Query\SqlWalker; | |
| /** | |
| * EXTRACT (field FROM [type] source) | |
| * field: | |
| * 単位指定子 | |
| * - YEAR | |
| * - MONTH | |
| * - DAY | |
| * - HOUR | |
| * - MINUTE | |
| * - SECOND | |
| * - WEEK | |
| * type: | |
| * 日付/時刻データ型 | |
| * sourceが文字列の場合のみ必須 | |
| * - TIMESTAMP | |
| * - DATE | |
| * - TIME | |
| * source: | |
| * 日付/時刻データ型、もしくは日付/時刻を表す文字列 | |
| * 文字列の場合はtypeが必須 | |
| * | |
| * @package Eccube\Doctrine\ORM\Query | |
| */ | |
| class Extract extends FunctionNode | |
| { | |
| protected $field; | |
| protected $type; | |
| protected $source; | |
| protected $formats = array( | |
| 'YEAR' => '%Y', | |
| 'MONTH' => '%m', | |
| 'DAY' => '%d', | |
| 'HOUR' => '%H', | |
| 'MINUTE' => '%M', | |
| 'SECOND' => '%S', | |
| 'WEEK' => '%W', | |
| ); | |
| protected $dateTimeTypes = array( | |
| 'TIMESTAMP', | |
| 'DATE', | |
| 'TIME', | |
| ); | |
| public function parse(Parser $parser) | |
| { | |
| $lexer = $parser->getLexer(); | |
| $parser->match(Lexer::T_IDENTIFIER); | |
| $parser->match(Lexer::T_OPEN_PARENTHESIS); | |
| $upperField = strtoupper($lexer->lookahead['value']); | |
| if ($lexer->lookahead['type'] !== Lexer::T_IDENTIFIER || !isset($this->formats[$upperField])) { | |
| $parser->syntaxError(implode('/', array_keys($this->formats))); | |
| } | |
| $parser->match(Lexer::T_IDENTIFIER); | |
| $this->field = $upperField; | |
| $parser->match(Lexer::T_FROM); | |
| $next = $lexer->glimpse(); | |
| if (isset($next['type']) && $next['type'] === Lexer::T_STRING) { | |
| $upperType = strtoupper($lexer->lookahead['value']); | |
| if ($lexer->lookahead['type'] !== Lexer::T_IDENTIFIER || !in_array($upperType, $this->dateTimeTypes, true)) { | |
| $parser->syntaxError(implode('/', $this->dateTimeTypes)); | |
| } | |
| $parser->match(Lexer::T_IDENTIFIER); | |
| $this->type = $upperType; | |
| } | |
| $this->source = $parser->ArithmeticPrimary(); | |
| $parser->match(Lexer::T_CLOSE_PARENTHESIS); | |
| } | |
| public function getSql(SqlWalker $sqlWalker) | |
| { | |
| $driver = $sqlWalker->getConnection()->getDriver()->getName(); | |
| if ($driver == 'pdo_sqlite') { | |
| return sprintf("CAST(STRFTIME('%s', %s) AS INTEGER)", $this->formats[$this->field], $this->source->dispatch($sqlWalker)); | |
| } else { | |
| return sprintf('EXTRACT(%s FROM %s %s)', $this->field, (string)$this->type, $this->source->dispatch($sqlWalker)); | |
| } | |
| } | |
| } |