View GitHub Repository sql

Schedule Inspection
Subscribe

Code Duplication    Length = 4-6 lines in 2 locations

src/SQL.php 2 locations

@@ 178-183 (lines=6) @@
175 
    protected function buildQueryForAnd($queryBuilder, $key, $value)
176 
    {
177 
        $sqlOptions = self::buildFilter([$key => $value]);
178 
        if (in_array($sqlOptions['method'], ['in', 'notIn'])) {
179 
            $queryBuilder->andWhere(
180 
                $queryBuilder->expr()->{$sqlOptions['method']}( $sqlOptions['key'], $sqlOptions['value'])
181 
            );
182 
            return $queryBuilder;
183 
        }
184 
        $queryBuilder->andWhere(
185 
                '`'.$sqlOptions['key'].'`'
186 
                . ' ' . $sqlOptions['operand']
@@ 198-201 (lines=4) @@
195 
            $subKey = array_keys($orValue)[0];
196 
            $subValue = $orValue[$subKey];
197 
            $sqlOptions = self::buildFilter([$subKey => $subValue]);
198 
            if (in_array($sqlOptions['method'], ['in', 'notIn'])) {
199 
                $orQuery[] =  $queryBuilder->expr()->{$sqlOptions['method']}( $sqlOptions['key'], $sqlOptions['value']);
200 
                continue;
201 
            }
202 
            $orQuery[] =
203 
                '`'.$sqlOptions['key'].'`'
204 
                . ' ' . $sqlOptions['operand']