@@ -2,22 +2,22 @@ |
||
2 | 2 | namespace Maphper\Lib\Sql; |
3 | 3 | |
4 | 4 | class In implements WhereConditional { |
5 | - public function matches($key, $value, $mode) { |
|
6 | - return !is_numeric($key) && is_array($value); |
|
7 | - } |
|
5 | + public function matches($key, $value, $mode) { |
|
6 | + return !is_numeric($key) && is_array($value); |
|
7 | + } |
|
8 | 8 | |
9 | - public function getSql($key, $value, $mode) { |
|
10 | - $args = []; |
|
11 | - $inSql = []; |
|
12 | - $count = count($value); |
|
9 | + public function getSql($key, $value, $mode) { |
|
10 | + $args = []; |
|
11 | + $inSql = []; |
|
12 | + $count = count($value); |
|
13 | 13 | $value = array_values($value); // fix numeric index being different than $i |
14 | - for ($i = 0; $i < $count; $i++) { |
|
15 | - $args[$key . $i] = $value[$i]; |
|
16 | - $inSql[] = ':' . $key . $i; |
|
17 | - } |
|
18 | - if (count($inSql) == 0) return []; |
|
19 | - else $sql = [$key . ' IN ( ' . implode(', ', $inSql) . ')']; |
|
14 | + for ($i = 0; $i < $count; $i++) { |
|
15 | + $args[$key . $i] = $value[$i]; |
|
16 | + $inSql[] = ':' . $key . $i; |
|
17 | + } |
|
18 | + if (count($inSql) == 0) return []; |
|
19 | + else $sql = [$key . ' IN ( ' . implode(', ', $inSql) . ')']; |
|
20 | 20 | |
21 | - return ['args' => $args, 'sql' => $sql]; |
|
22 | - } |
|
21 | + return ['args' => $args, 'sql' => $sql]; |
|
22 | + } |
|
23 | 23 | } |