gctools-outilsgc /
gcconnex
| @@ 385-403 (lines=19) @@ | ||
| 382 | ||
| 383 | // get names wheres and joins |
|
| 384 | $names_where = ''; |
|
| 385 | if ($names !== null) { |
|
| 386 | if (!is_array($names)) { |
|
| 387 | $names = array($names); |
|
| 388 | } |
|
| 389 | ||
| 390 | $sanitised_names = array(); |
|
| 391 | foreach ($names as $name) { |
|
| 392 | // normalise to 0. |
|
| 393 | if (!$name) { |
|
| 394 | $name = '0'; |
|
| 395 | } |
|
| 396 | $sanitised_names[] = '\'' . sanitise_string($name) . '\''; |
|
| 397 | } |
|
| 398 | ||
| 399 | if ($names_str = implode(',', $sanitised_names)) { |
|
| 400 | $return['joins'][] = "JOIN {$db_prefix}metastrings msn on $table.name_id = msn.id"; |
|
| 401 | $names_where = "(msn.string IN ($names_str))"; |
|
| 402 | } |
|
| 403 | } |
|
| 404 | ||
| 405 | // get values wheres and joins |
|
| 406 | $values_where = ''; |
|
| @@ 407-425 (lines=19) @@ | ||
| 404 | ||
| 405 | // get values wheres and joins |
|
| 406 | $values_where = ''; |
|
| 407 | if ($values !== null) { |
|
| 408 | if (!is_array($values)) { |
|
| 409 | $values = array($values); |
|
| 410 | } |
|
| 411 | ||
| 412 | $sanitised_values = array(); |
|
| 413 | foreach ($values as $value) { |
|
| 414 | // normalize to 0 |
|
| 415 | if (!$value) { |
|
| 416 | $value = 0; |
|
| 417 | } |
|
| 418 | $sanitised_values[] = '\'' . sanitise_string($value) . '\''; |
|
| 419 | } |
|
| 420 | ||
| 421 | if ($values_str = implode(',', $sanitised_values)) { |
|
| 422 | $return['joins'][] = "JOIN {$db_prefix}metastrings msv on $table.value_id = msv.id"; |
|
| 423 | $values_where = "({$binary}msv.string IN ($values_str))"; |
|
| 424 | } |
|
| 425 | } |
|
| 426 | ||
| 427 | if ($ids !== null) { |
|
| 428 | if (!is_array($ids)) { |
|
