View GitHub Repository sql

Schedule Inspection
Subscribe

Code Duplication    Length = 4-6 lines in 2 locations

src/SQL.php 2 locations

@@ 187-192 (lines=6) @@
184 
    protected function buildQueryForAnd($queryBuilder, $key, $value)
185 
    {
186 
        $sqlOptions = self::buildFilter([$key => $value]);
187 
        if (in_array($sqlOptions['method'], ['in', 'notIn'])) {
188 
            $queryBuilder->andWhere(
189 
                $queryBuilder->expr()->{$sqlOptions['method']}( $sqlOptions['key'], $sqlOptions['value'])
190 
            );
191 
            return $queryBuilder;
192 
        }
193 
        $queryBuilder->andWhere(
194 
                '`'.$sqlOptions['key'].'`'
195 
                . ' ' . $sqlOptions['operand']
@@ 207-210 (lines=4) @@
204 
            $subKey = array_keys($orValue)[0];
205 
            $subValue = $orValue[$subKey];
206 
            $sqlOptions = self::buildFilter([$subKey => $subValue]);
207 
            if (in_array($sqlOptions['method'], ['in', 'notIn'])) {
208 
                $orQuery[] =  $queryBuilder->expr()->{$sqlOptions['method']}( $sqlOptions['key'], $sqlOptions['value']);
209 
                continue;
210 
            }
211 
            $orQuery[] =
212 
                '`'.$sqlOptions['key'].'`'
213 
                . ' ' . $sqlOptions['operand']