byjg /
anydataset
@@ -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 | } |
