View GitHub Repository sql

Schedule Inspection
Subscribe

Code Duplication    Length = 4-6 lines in 2 locations

src/SQL.php 2 locations

@@ 171-176 (lines=6) @@
168 
    protected function buildQueryForAnd($queryBuilder, $key, $value)
169 
    {
170 
        $sqlOptions = self::buildFilter([$key => $value]);
171 
        if (in_array($sqlOptions['method'], ['in', 'notIn'])) {
172 
            $queryBuilder->andWhere(
173 
                $queryBuilder->expr()->{$sqlOptions['method']}( $sqlOptions['key'], $sqlOptions['value'])
174 
            );
175 
            return $queryBuilder;
176 
        }
177 
        $queryBuilder->andWhere(
178 
                '`'.$sqlOptions['key'].'`'
179 
                . ' ' . $sqlOptions['operand']
@@ 191-194 (lines=4) @@
188 
            $subKey = array_keys($orValue)[0];
189 
            $subValue = $orValue[$subKey];
190 
            $sqlOptions = self::buildFilter([$subKey => $subValue]);
191 
            if (in_array($sqlOptions['method'], ['in', 'notIn'])) {
192 
                $orQuery[] =  $queryBuilder->expr()->{$sqlOptions['method']}( $sqlOptions['key'], $sqlOptions['value']);
193 
                continue;
194 
            }
195 
            $orQuery[] =
196 
                '`'.$sqlOptions['key'].'`'
197 
                . ' ' . $sqlOptions['operand']