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
|
<?php
/**
* Database clause class, to build WHERE-clauses
*
* This file is part of Zoph.
*
* Zoph 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.
*
* Zoph 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 Zoph; if not, write to the Free Software
* Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
*
* @package Zoph
* @author Jeroen Roos
*/
namespace db;
/**
* The clause object is used to build WHERE-clauses
*
* @package Zoph
* @author Jeroen Roos
*/
class clause {
/** @var string contains the WHERE clause */
private $clause;
/** @var array contains any subclauses */
private $subclauses;
/**
* Create a new WHERE clause
* @param string clause to be created
*/
public function __construct($clause) {
$this->clause=$clause;
}
/**
* Add a subclause with AND conjunction
* @param clause subclause to be added
*/
public function addAnd(clause $clause) {
$this->subclauses[]=array(
"conj" => "AND",
"subc" => $clause
);
return $this;
}
/**
* Add a subclause with OR conjunction
* @param clause subclause to be added
*/
public function addOr(clause $clause) {
$this->subclauses[]=array(
"conj" => "OR",
"subc" => $clause
);
return $this;
}
/**
* Add a subclause with NOT conjunction
* @param clause subclause to be added
*/
public function addNot(clause $clause) {
$this->subclauses[]=array(
"conj" => "NOT",
"subc" => $clause
);
return $this;
}
/**
* Create a WHERE ... IN (..., ..., ...) clause
* @param string variable
* @param param parameters
* @return clause WHERE clause
*/
public static function InClause($var, param $param) {
return new self($var . " IN (" . implode(", ", $param->getName()) . ")");
}
/**
* Create a WHERE ... IN (SELECT ...) clause
* @param string variable
* @param select subquery
* @return clause WHERE clause
*/
public static function inSubQry($var, select $subqry) {
return new self($var . " IN (" . rtrim($subqry, ";") . ")");
}
/**
* Create a WHERE ... NOT IN (..., ..., ...) clause
* @param string variable
* @param param parameters
* @return clause WHERE clause
*/
public static function NotInClause($var, param $param) {
return new self($var . " NOT IN (" . implode(", ", $param->getName()) . ")");
}
/**
* Build the clause
* @return string clause
*/
public function __toString() {
$sql="(" . $this->clause . ")";
if (is_array($this->subclauses)) {
foreach ($this->subclauses as $subclause) {
$conj=$subclause["conj"];
$subc=$subclause["subc"];
$sql.= " " . $conj . " (" . $subc . ")";
}
}
return $sql;
}
}
|
