View GitHub Repository sql

Schedule Inspection
Subscribe

Code Duplication    Length = 4-6 lines in 2 locations

src/SQL.php 2 locations

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