1
|
|
|
<?php |
2
|
|
|
/* |
3
|
|
|
* This file is part of EC-CUBE |
4
|
|
|
* |
5
|
|
|
* Copyright(c) 2000-2016 LOCKON CO.,LTD. All Rights Reserved. |
6
|
|
|
* |
7
|
|
|
* http://www.lockon.co.jp/ |
8
|
|
|
* |
9
|
|
|
* This program is free software; you can redistribute it and/or |
10
|
|
|
* modify it under the terms of the GNU General Public License |
11
|
|
|
* as published by the Free Software Foundation; either version 2 |
12
|
|
|
* of the License, or (at your option) any later version. |
13
|
|
|
* |
14
|
|
|
* This program is distributed in the hope that it will be useful, |
15
|
|
|
* but WITHOUT ANY WARRANTY; without even the implied warranty of |
16
|
|
|
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
17
|
|
|
* GNU General Public License for more details. |
18
|
|
|
* |
19
|
|
|
* You should have received a copy of the GNU General Public License |
20
|
|
|
* along with this program; if not, write to the Free Software |
21
|
|
|
* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
22
|
|
|
*/ |
23
|
|
|
|
24
|
|
|
namespace Eccube\Doctrine\ORM\Query; |
25
|
|
|
|
26
|
|
|
use Doctrine\ORM\Query\AST\Functions\FunctionNode; |
27
|
|
|
use Doctrine\ORM\Query\Lexer; |
28
|
|
|
use Doctrine\ORM\Query\Parser; |
29
|
|
|
use Doctrine\ORM\Query\SqlWalker; |
30
|
|
|
|
31
|
|
|
/** |
32
|
|
|
* @package Eccube\Doctrine\ORM\Query |
33
|
|
|
*/ |
34
|
|
|
class Normalize extends FunctionNode |
35
|
|
|
{ |
36
|
|
|
protected $string; |
37
|
|
|
const FROM = 'あいうえおかきくけこさしすせそたちつてとなにぬねのはひふへほまみむめもやゆよらりるれろわをんがぎぐげござじずぜぞだぢづでどばびぶべぼぱぴぷぺぽぁぃぅぇぉっゃゅょわいえー'; |
38
|
|
|
const TO = 'アイウエオカキクケコサシスセソタチツテトナニヌネノハヒフヘホマミムメモヤユヨラリルレロワヲンガギグゲゴザジズゼゾダヂヅデドバビブベボパピプペポァィゥェォッャュョヮヰヱー'; |
39
|
|
|
|
40
|
1 |
|
public function parse(Parser $parser) |
|
|
|
|
41
|
|
|
{ |
42
|
1 |
|
$parser->match(Lexer::T_IDENTIFIER); |
43
|
1 |
|
$parser->match(Lexer::T_OPEN_PARENTHESIS); |
44
|
1 |
|
$this->string = $parser->ArithmeticPrimary(); |
45
|
1 |
|
$parser->match(Lexer::T_CLOSE_PARENTHESIS); |
46
|
|
|
} |
47
|
|
|
|
48
|
1 |
|
public function getSql(SqlWalker $sqlWalker) |
|
|
|
|
49
|
|
|
{ |
50
|
1 |
|
switch ($sqlWalker->getConnection()->getDriver()->getName()) { |
51
|
1 |
|
case 'pdo_pgsql': |
52
|
1 |
|
$sql = sprintf("LOWER(TRANSLATE(%s, '%s', '%s'))", $this->string->dispatch($sqlWalker), self::FROM, self::TO); |
53
|
1 |
|
break; |
54
|
|
|
case 'pdo_mysql': |
55
|
|
|
$sql = sprintf('CONVERT(%s USING utf8) COLLATE utf8_unicode_ci', $this->string->dispatch($sqlWalker)); |
56
|
|
|
break; |
57
|
|
|
default: |
58
|
|
|
$sql = sprintf('LOWER(%s)', $this->string->dispatch($sqlWalker)); |
59
|
1 |
|
break; |
60
|
|
|
} |
61
|
1 |
|
return $sql; |
|
|
|
|
62
|
|
|
} |
63
|
|
|
} |
64
|
|
|
|