@@ -160,6 +160,9 @@ |
||
160 | 160 | $this->fieldDeliRight = $right; |
161 | 161 | } |
162 | 162 | |
163 | + /** |
|
164 | + * @param string $sql |
|
165 | + */ |
|
163 | 166 | public static function createSafeSQL($sql, $list) |
164 | 167 | { |
165 | 168 | return str_replace(array_keys($list), array_values($list), $sql); |
@@ -310,6 +310,10 @@ discard block |
||
310 | 310 | return; |
311 | 311 | } |
312 | 312 | |
313 | + /** |
|
314 | + * @param SingleRow[] $seq |
|
315 | + * @param string $field |
|
316 | + */ |
|
313 | 317 | protected function quickSortExec($seq, $field) |
314 | 318 | { |
315 | 319 | if (!count($seq)) { |
@@ -337,7 +341,7 @@ discard block |
||
337 | 341 | |
338 | 342 | /** |
339 | 343 | * @param $document |
340 | - * @return array|string |
|
344 | + * @return string |
|
341 | 345 | */ |
342 | 346 | public static function fixUTF8($document) |
343 | 347 | { |
@@ -131,6 +131,9 @@ |
||
131 | 131 | return $arrayDS->getIterator(); |
132 | 132 | } |
133 | 133 | |
134 | + /** |
|
135 | + * @param string $sql |
|
136 | + */ |
|
134 | 137 | protected function getQueryKey($sql, $array) |
135 | 138 | { |
136 | 139 | $key1 = md5($sql); |
@@ -73,7 +73,7 @@ discard block |
||
73 | 73 | |
74 | 74 | /** |
75 | 75 | * |
76 | - * @param $array |
|
76 | + * @param SingleRow[] $array |
|
77 | 77 | * @return SingleRow[] |
78 | 78 | */ |
79 | 79 | public function match($array) |
@@ -243,7 +243,7 @@ discard block |
||
243 | 243 | /** |
244 | 244 | * |
245 | 245 | * @param SingleRow $singleRow |
246 | - * @return string |
|
246 | + * @return boolean |
|
247 | 247 | */ |
248 | 248 | private function evalString(SingleRow $singleRow) |
249 | 249 | { |
@@ -142,37 +142,37 @@ discard block |
||
142 | 142 | |
143 | 143 | $result = ""; |
144 | 144 | switch ($relation) { |
145 | - case Relation::EQUAL: |
|
146 | - $result = $field . "=" . $value; |
|
147 | - break; |
|
145 | + case Relation::EQUAL: |
|
146 | + $result = $field . "=" . $value; |
|
147 | + break; |
|
148 | 148 | |
149 | - case Relation::GREATER_THAN: |
|
150 | - $result = $field . ">" . $value; |
|
151 | - break; |
|
149 | + case Relation::GREATER_THAN: |
|
150 | + $result = $field . ">" . $value; |
|
151 | + break; |
|
152 | 152 | |
153 | - case Relation::LESS_THAN: |
|
154 | - $result = $field . "<" . $value; |
|
155 | - break; |
|
153 | + case Relation::LESS_THAN: |
|
154 | + $result = $field . "<" . $value; |
|
155 | + break; |
|
156 | 156 | |
157 | - case Relation::GREATER_OR_EQUAL_THAN: |
|
158 | - $result = $field . ">=" . $value; |
|
159 | - break; |
|
157 | + case Relation::GREATER_OR_EQUAL_THAN: |
|
158 | + $result = $field . ">=" . $value; |
|
159 | + break; |
|
160 | 160 | |
161 | - case Relation::LESS_OR_EQUAL_THAN: |
|
162 | - $result = $field . "<=" . $value; |
|
163 | - break; |
|
161 | + case Relation::LESS_OR_EQUAL_THAN: |
|
162 | + $result = $field . "<=" . $value; |
|
163 | + break; |
|
164 | 164 | |
165 | - case Relation::NOT_EQUAL: |
|
166 | - $result = $field . "!=" . $value; |
|
167 | - break; |
|
165 | + case Relation::NOT_EQUAL: |
|
166 | + $result = $field . "!=" . $value; |
|
167 | + break; |
|
168 | 168 | |
169 | - case Relation::STARTS_WITH: |
|
170 | - $result = " starts-with($field, $value) "; |
|
171 | - break; |
|
169 | + case Relation::STARTS_WITH: |
|
170 | + $result = " starts-with($field, $value) "; |
|
171 | + break; |
|
172 | 172 | |
173 | - case Relation::CONTAINS: |
|
174 | - $result = " contains($field, $value) "; |
|
175 | - break; |
|
173 | + case Relation::CONTAINS: |
|
174 | + $result = " contains($field, $value) "; |
|
175 | + break; |
|
176 | 176 | |
177 | 177 | } |
178 | 178 | return $result; |
@@ -201,40 +201,40 @@ discard block |
||
201 | 201 | $field = " $name "; |
202 | 202 | $valueparam = " [[" . $paramName . "]] "; |
203 | 203 | switch ($relation) { |
204 | - case Relation::EQUAL: { |
|
205 | - $result = $field . "=" . $valueparam; |
|
206 | - break; |
|
207 | - } |
|
208 | - case Relation::GREATER_THAN: { |
|
209 | - $result = $field . ">" . $valueparam; |
|
210 | - break; |
|
211 | - } |
|
212 | - case Relation::LESS_THAN: { |
|
213 | - $result = $field . "<" . $valueparam; |
|
214 | - break; |
|
215 | - } |
|
216 | - case Relation::GREATER_OR_EQUAL_THAN: { |
|
217 | - $result = $field . ">=" . $valueparam; |
|
218 | - break; |
|
219 | - } |
|
220 | - case Relation::LESS_OR_EQUAL_THAN: { |
|
221 | - $result = $field . "<=" . $valueparam; |
|
222 | - break; |
|
223 | - } |
|
224 | - case Relation::NOT_EQUAL: { |
|
225 | - $result = $field . "!=" . $valueparam; |
|
226 | - break; |
|
227 | - } |
|
228 | - case Relation::STARTS_WITH: { |
|
229 | - $param[$paramName] = $value . "%"; |
|
230 | - $result = $field . " like " . $valueparam; |
|
231 | - break; |
|
232 | - } |
|
233 | - case Relation::CONTAINS: { |
|
234 | - $param[$paramName] = "%" . $value . "%"; |
|
235 | - $result = $field . " like " . $valueparam; |
|
236 | - break; |
|
237 | - } |
|
204 | + case Relation::EQUAL: { |
|
205 | + $result = $field . "=" . $valueparam; |
|
206 | + break; |
|
207 | + } |
|
208 | + case Relation::GREATER_THAN: { |
|
209 | + $result = $field . ">" . $valueparam; |
|
210 | + break; |
|
211 | + } |
|
212 | + case Relation::LESS_THAN: { |
|
213 | + $result = $field . "<" . $valueparam; |
|
214 | + break; |
|
215 | + } |
|
216 | + case Relation::GREATER_OR_EQUAL_THAN: { |
|
217 | + $result = $field . ">=" . $valueparam; |
|
218 | + break; |
|
219 | + } |
|
220 | + case Relation::LESS_OR_EQUAL_THAN: { |
|
221 | + $result = $field . "<=" . $valueparam; |
|
222 | + break; |
|
223 | + } |
|
224 | + case Relation::NOT_EQUAL: { |
|
225 | + $result = $field . "!=" . $valueparam; |
|
226 | + break; |
|
227 | + } |
|
228 | + case Relation::STARTS_WITH: { |
|
229 | + $param[$paramName] = $value . "%"; |
|
230 | + $result = $field . " like " . $valueparam; |
|
231 | + break; |
|
232 | + } |
|
233 | + case Relation::CONTAINS: { |
|
234 | + $param[$paramName] = "%" . $value . "%"; |
|
235 | + $result = $field . " like " . $valueparam; |
|
236 | + break; |
|
237 | + } |
|
238 | 238 | } |
239 | 239 | |
240 | 240 | return $result; |
@@ -269,38 +269,38 @@ discard block |
||
269 | 269 | |
270 | 270 | foreach ($field as $valueparam) { |
271 | 271 | switch ($relation) { |
272 | - case Relation::EQUAL: { |
|
273 | - $result[$pos] &= ($valueparam == $value); |
|
274 | - break; |
|
275 | - } |
|
276 | - case Relation::GREATER_THAN: { |
|
277 | - $result[$pos] &= ($valueparam > $value); |
|
278 | - break; |
|
279 | - } |
|
280 | - case Relation::LESS_THAN: { |
|
281 | - $result[$pos] &= ($valueparam < $value); |
|
282 | - break; |
|
283 | - } |
|
284 | - case Relation::GREATER_OR_EQUAL_THAN: { |
|
285 | - $result[$pos] &= ($valueparam >= $value); |
|
286 | - break; |
|
287 | - } |
|
288 | - case Relation::LESS_OR_EQUAL_THAN: { |
|
289 | - $result[$pos] &= ($valueparam <= $value); |
|
290 | - break; |
|
291 | - } |
|
292 | - case Relation::NOT_EQUAL: { |
|
293 | - $result[$pos] &= ($valueparam != $value); |
|
294 | - break; |
|
295 | - } |
|
296 | - case Relation::STARTS_WITH: { |
|
297 | - $result[$pos] &= (strpos($valueparam, $value) === 0); |
|
298 | - break; |
|
299 | - } |
|
300 | - case Relation::CONTAINS: { |
|
301 | - $result[$pos] &= (strpos($valueparam, $value) !== false); |
|
302 | - break; |
|
303 | - } |
|
272 | + case Relation::EQUAL: { |
|
273 | + $result[$pos] &= ($valueparam == $value); |
|
274 | + break; |
|
275 | + } |
|
276 | + case Relation::GREATER_THAN: { |
|
277 | + $result[$pos] &= ($valueparam > $value); |
|
278 | + break; |
|
279 | + } |
|
280 | + case Relation::LESS_THAN: { |
|
281 | + $result[$pos] &= ($valueparam < $value); |
|
282 | + break; |
|
283 | + } |
|
284 | + case Relation::GREATER_OR_EQUAL_THAN: { |
|
285 | + $result[$pos] &= ($valueparam >= $value); |
|
286 | + break; |
|
287 | + } |
|
288 | + case Relation::LESS_OR_EQUAL_THAN: { |
|
289 | + $result[$pos] &= ($valueparam <= $value); |
|
290 | + break; |
|
291 | + } |
|
292 | + case Relation::NOT_EQUAL: { |
|
293 | + $result[$pos] &= ($valueparam != $value); |
|
294 | + break; |
|
295 | + } |
|
296 | + case Relation::STARTS_WITH: { |
|
297 | + $result[$pos] &= (strpos($valueparam, $value) === 0); |
|
298 | + break; |
|
299 | + } |
|
300 | + case Relation::CONTAINS: { |
|
301 | + $result[$pos] &= (strpos($valueparam, $value) !== false); |
|
302 | + break; |
|
303 | + } |
|
304 | 304 | } |
305 | 305 | } |
306 | 306 | } |