Maphper\Lib\Sql\In::getSql()

Complexity

Conditions	4
Paths	8

Size

Total Lines	19
Code Lines	13

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function getSql($key, $value, $mode) {
        $args = [];
        $inSql = [];
        $count = count($value);
        $value = array_values($value); // fix numeric index being different than $i
        for ($i = 0; $i < $count; $i++) {
            $args[$key . $i] = $value[$i];
            $inSql[] = ':' . $key . $i;
        }

        $notText = '';
        if (\Maphper\Maphper::FIND_NOT & $mode) {
            $notText = ' NOT';
        }

        if (count($inSql) == 0) return ['args' => [], 'sql' => ''];
        else $sql = [$key . $notText . ' IN ( ' .  implode(', ', $inSql) . ')'];

        return ['args' => $args, 'sql' => $sql];
    }