Class yii\db\sqlite\conditions\InConditionBuilder

                public function __construct(QueryBuilder $queryBuilder)
{
    $this->queryBuilder = $queryBuilder;
}

            

                public function build(ExpressionInterface $expression, array &$params = []): string
{
    $operator = strtoupper($expression->getOperator());
    $column = $expression->getColumn();
    $values = $expression->getValues();
    if ($column === []) {
        // no columns to test against
        return $operator === 'IN' ? '0=1' : '';
    }
    if ($values instanceof Query) {
        return $this->buildSubqueryInCondition($operator, $column, $values, $params);
    }
    if (!is_array($values)) {
        // ensure values is an array
        $values = [$values];
    }
    if (is_array($column)) {
        if (count($column) > 1) {
            return $this->buildCompositeInCondition($operator, $column, $values, $params);
        }
        $column = reset($column);
    }
    $nullCondition = null;
    $nullConditionOperator = null;
    if ($this->hasNullValue($column, $values)) {
        $nullCondition = $this->buildNullCondition($operator, $column, $params);
        $nullConditionOperator = $operator === 'IN' ? 'OR' : 'AND';
    }
    $sqlValues = $this->buildValues($expression, $values, $params);
    if ($sqlValues === []) {
        if ($nullCondition === null) {
            return $operator === 'IN' ? '0=1' : '';
        }
        return $nullCondition;
    }
    $column = $this->normalizeColumn($column, $params);
    if (count($sqlValues) > 1) {
        $sql = "$column $operator (" . implode(', ', $sqlValues) . ')';
    } else {
        $operator = $operator === 'IN' ? '=' : '<>';
        $sql = "{$column}{$operator}" . reset($sqlValues);
    }
    return $nullCondition !== null && $nullConditionOperator !== null
        ? "{$sql} {$nullConditionOperator} {$nullCondition}"
        : $sql;
}

            

                protected function buildCompositeInCondition(
    string $operator,
    array $columns,
    array $values,
    array &$params
): string {
    $quotedColumns = [];
    $columnKeys = [];
    foreach ($columns as $i => $column) {
        $quotedColumns[$i] = $this->normalizeColumn($column, $params);
        $columnKeys[$i] = $this->resolveColumnKey($column);
    }
    $vss = [];
    $notEqualOperator = $this->getNotEqualOperator();
    foreach ($values as $value) {
        $vs = [];
        foreach ($columns as $i => $_) {
            $columnKey = $columnKeys[$i];
            $columnValue = null;
            if (
                (is_array($value) || $value instanceof ArrayAccess)
                && $columnKey !== null
            ) {
                $columnValue = $value[$columnKey] ?? null;
            }
            if ($columnValue === null) {
                $vs[] = $quotedColumns[$i] . ($operator === 'IN' ? ' IS' : ' IS NOT') . ' NULL';
            } else {
                if ($columnValue instanceof ExpressionInterface) {
                    $placeholder = $this->queryBuilder->buildExpression($columnValue, $params);
                } else {
                    $placeholder = $this->queryBuilder->bindParam($columnValue, $params);
                }
                $vs[] = $quotedColumns[$i] . ($operator === 'IN' ? ' = ' : " {$notEqualOperator} ") . $placeholder;
            }
        }
        $vss[] = '(' . implode($operator === 'IN' ? ' AND ' : ' OR ', $vs) . ')';
    }
    if ($vss === []) {
        return $operator === 'IN' ? '0=1' : '';
    }
    return '(' . implode($operator === 'IN' ? ' OR ' : ' AND ', $vss) . ')';
}

            

                protected function buildValues(ConditionInterface $condition, array $values, array &$params): array
{
    $sqlValues = [];
    $column = $condition->getColumn();
    if (is_array($column)) {
        $column = reset($column);
    }
    $columnKey = $this->resolveColumnKey($column);
    foreach ($values as $i => $value) {
        if (is_array($value) || $value instanceof ArrayAccess) {
            $value = $columnKey !== null ? ($value[$columnKey] ?? null) : null;
        }
        if ($value === null) {
            continue;
        } elseif ($value instanceof ExpressionInterface) {
            $sqlValues[$i] = $this->queryBuilder->buildExpression($value, $params);
        } else {
            $sqlValues[$i] = $this->queryBuilder->bindParam($value, $params);
        }
    }
    return $sqlValues;
}

            

                protected function getNullCondition(string $operator, string $column): string
{
    $column = $this->queryBuilder->db->quoteColumnName($column);
    return $column . ($operator === 'IN' ? ' IS NULL' : ' IS NOT NULL');
}