View GitHub Repository sql

Schedule Inspection
Subscribe

Code Duplication    Length = 6-7 lines in 2 locations

src/SQL.php 2 locations

@@ 167-172 (lines=6) @@
164 
                        $sqlOptions = self::buildFilter([$subKey => $subValue]);
165 
                        if (in_array($sqlOptions['method'], ['in', 'notIn'])) {
166 
                            $orQuery[] =  $queryBuilder->expr()->{$sqlOptions['method']}( $sqlOptions['key'], $sqlOptions['value']);
167 
                        } else {
168 
                            $orQuery[] =
169 
                                '`'.$sqlOptions['key'].'`'
170 
                                . ' ' . $sqlOptions['operand']
171 
                                . ' ' . $queryBuilder->createNamedParameter($sqlOptions['value']);
172 
                        }
173 
                    }
174 
                    $queryBuilder->andWhere(
175 
                        '(' . implode(' OR ', $orQuery) . ')'
@@ 183-189 (lines=7) @@
180 
                        $queryBuilder->andWhere(
181 
                            $queryBuilder->expr()->{$sqlOptions['method']}( $sqlOptions['key'], $sqlOptions['value'])
182 
                        );
183 
                    } else {
184 
                        $queryBuilder->andWhere(
185 
                            '`'.$sqlOptions['key'].'`'
186 
                            . ' ' . $sqlOptions['operand']
187 
                            . ' ' . $queryBuilder->createNamedParameter($sqlOptions['value'])
188 
                        );
189 
                    }
190 
                }
191 
            }
192 
        }