1 | <?php |
||
17 | class QueryClauses |
||
18 | { |
||
19 | const QUERY_SELECT = 1; |
||
20 | const QUERY_UPDATE = 2; |
||
21 | |||
22 | /** |
||
23 | * @var array $selectClauses |
||
24 | */ |
||
25 | private $selectClauses = []; |
||
26 | |||
27 | /** |
||
28 | * @var array $whereClauses |
||
29 | */ |
||
30 | private $whereClauses = []; |
||
31 | |||
32 | /** |
||
33 | * @var array $orderByClauses |
||
34 | */ |
||
35 | private $orderByClauses = []; |
||
36 | |||
37 | /** |
||
38 | * @var array $setClauses |
||
39 | */ |
||
40 | private $setClauses = []; |
||
41 | |||
42 | /** |
||
43 | * @var array $groupByClauses |
||
44 | */ |
||
45 | private $groupByClauses = []; |
||
46 | |||
47 | /** |
||
48 | * @var array $havingClauses |
||
49 | */ |
||
50 | private $havingClauses = []; |
||
51 | |||
52 | /** |
||
53 | * @var string $limitClause |
||
54 | */ |
||
55 | private $limitClause; |
||
56 | |||
57 | /** |
||
58 | * @var array $queryHints |
||
59 | */ |
||
60 | private $queryHints = []; |
||
61 | |||
62 | /** |
||
63 | * @param string $clause |
||
64 | * |
||
65 | * @return $this |
||
66 | */ |
||
67 | 22 | public function addSelect($clause) |
|
73 | |||
74 | /** |
||
75 | * @param string $clause |
||
76 | * |
||
77 | * @return $this |
||
78 | */ |
||
79 | 7 | public function andWhere($clause) |
|
85 | |||
86 | /** |
||
87 | * @param string $clause |
||
88 | * |
||
89 | * @return $this |
||
90 | */ |
||
91 | 1 | public function andHaving($clause) |
|
97 | |||
98 | /** |
||
99 | * @param string $clause |
||
100 | * |
||
101 | * @return $this |
||
102 | */ |
||
103 | 2 | public function addOrderBy($clause) |
|
109 | |||
110 | /** |
||
111 | * @param string $clause |
||
112 | * |
||
113 | * @return $this |
||
114 | */ |
||
115 | 4 | public function addSet($clause) |
|
121 | |||
122 | /** |
||
123 | * @param string $clause |
||
124 | * |
||
125 | * @return $this |
||
126 | */ |
||
127 | 3 | public function addGroupBy($clause) |
|
133 | |||
134 | /** |
||
135 | * @param string $clause |
||
136 | * |
||
137 | * @return $this |
||
138 | */ |
||
139 | 2 | public function setLimit($clause) |
|
145 | |||
146 | /** |
||
147 | * @param int $hint |
||
148 | * @param mixed $value |
||
149 | * |
||
150 | * @return $this |
||
151 | */ |
||
152 | 1 | public function addQueryHint($hint, $value = null) |
|
158 | |||
159 | /** |
||
160 | * @return array |
||
161 | */ |
||
162 | 26 | public function getSelectClauses() |
|
166 | |||
167 | /** |
||
168 | * @return array |
||
169 | */ |
||
170 | 26 | public function getWhereClauses() |
|
174 | |||
175 | /** |
||
176 | * @return array |
||
177 | */ |
||
178 | 26 | public function getOrderByClauses() |
|
182 | |||
183 | /** |
||
184 | * @return array |
||
185 | */ |
||
186 | 4 | public function getSetClauses() |
|
190 | |||
191 | /** |
||
192 | * @return array |
||
193 | */ |
||
194 | 22 | public function getGroupByClauses() |
|
198 | |||
199 | /** |
||
200 | * @return array |
||
201 | */ |
||
202 | 22 | public function getHavingClauses() |
|
206 | |||
207 | /** |
||
208 | * @return string |
||
209 | */ |
||
210 | 26 | public function getLimitClause() |
|
214 | |||
215 | /** |
||
216 | * @return array |
||
217 | */ |
||
218 | 4 | public function getQueryHints() |
|
222 | } |