1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
<?php
/**
* PostgresSQLBuilderJP
* 条件文の生成。where xxxx の、xxxxの部分を返す。
* 日本語テーブル、フィールドを利用しているデータベース用
* $Id: PostgresSQLBuilderJP.inc,v 1.1 2015/10/08 11:18:57 wanggb Exp $
* @author iimuro
* @access public
* @package jp.aimslib2.database.postgres
*/
class PostgresSQLBuilderJP extends PostgresSQLBuilder{
/**
* AND,OR等Where文の中身を生成する。
*/
public function createOptionCondition($param){
$option = "";
while (list($key, $val) = each($param)) {
if ($option != "") {
$option .= " AND ";
}
$mmflg = "";
$modkey = "";
if(strlen($key) > 4){
$mmflg = strtoupper(substr($key, strlen($key) - 4));
$modkey = substr($key, 0, strlen($key) - 4);
}
if($mmflg == "_ALT"){
$option .= "\"" . $modkey . "\"::text like '" . $val . "'";
} else if($mmflg == "_MAX"){
$option .= "\"" . $modkey . "\"<='" . $val . "'";
} else if ($mmflg == "_MIN"){
$option .= "\"" . $modkey . "\">='" . $val . "'";
} else if ($mmflg == "_NOT"){
if(is_array($val)){
if (count($val) > 0) {
$option .= "\"" . $key . "\" not in ('";
$option .= implode("','", $val);
$option .= "')";
} else {
$option .= "\"" . $key . "\" is not null";
}
} else if (is_int($val)) {
$option .= "\"" . $modkey . "\"!='" . $val . "'";
}else if(($val == "null")||($val == "")){
$option .= "\"" . $modkey . "\" is not null";
}else{
//$option .= $modkey . "!='" . $val . "'";
$option .= "(\"" . $modkey . "\"!='" . $val . "' OR \"" . $modkey . "\" is null)";
}
}else{
if (is_array($val)) {
if (count($val) > 0) {
$option .= "\"" . $key . "\" in ('";
$option .= implode("','", $val);
$option .= "')";
} else {
$option .= "\"" . $key . "\" is null";
}
} else if (is_int($val)) {
$option .= "\"" . $key . "\"='" . $val . "'";
} else if (($val == "null")||($val == "")) {
$option .= "\"" . $key . "\" is null";
} else {
$option .= "\"" . $key . "\"='" . $val . "'";
}
}
}
return $option;
}
/**
* created 10/27/2002 by Yu.
* 条件文の生成。set xxxx の、xxxxの部分を返す。
*/
// copyed 10/25/2002 by NAGASAWA Teruo
public static function createSetValueOption($param){
$option = "";
while(list($key, $val) = each($param)){
if($option != ""){
$option .= ",";
}
$option .= "\"" . $key . "\"='" . $val . "'";
}
return $option;
}
/**
* created 10/27/2002 by Yu.
* 条件文の生成。(xxx) values (xxx)の部分を返す。
*/
public static function createInsertValueOption($param){
$str = "";
$cols = "";
$vals = "";
while(list($key, $val) = each($param)){
if($cols != ""){
$cols .= ",";
}
if($vals != ""){
$vals .= ",";
}
$cols .= "\"" . $key . "\"";
$vals .= " '" . $val . "'";
}
$str = "(" . $cols . ") VALUES (" . $vals . ")";
return $str;
}
/**
* 対象となるレコードの先頭とレコード数を指定する文章を生成します。
* 不要なパラメータはnullを指定します。
*/
public static function createSubQuery($offset, $limit) {
$subquery = "";
if (($offset != null)&&(is_numeric($offset)) ){
$subquery .= " OFFSET " . $offset;
}
if (($limit != null)&&(is_numeric($limit)) ){
$subquery .= " LIMIT " . $limit;
}
return $subquery;
}
}
?>