View GitHub Repository sql

Schedule Inspection
Subscribe

Code Duplication    Length = 4-6 lines in 2 locations

src/SQL.php 2 locations

@@ 128-133 (lines=6) @@
125 
    protected function buildQueryForAnd($queryBuilder, $key, $value)
126 
    {
127 
        $sqlOptions = self::buildFilter([$key => $value]);
128 
        if (in_array($sqlOptions['method'], ['in', 'notIn'])) {
129 
            $queryBuilder->andWhere(
130 
                $queryBuilder->expr()->{$sqlOptions['method']}( $sqlOptions['key'], $sqlOptions['value'])
131 
            );
132 
            return $queryBuilder;
133 
        }
134 
        $queryBuilder->andWhere(
135 
                '`'.$sqlOptions['key'].'`'
136 
                . ' ' . $sqlOptions['operand']
@@ 148-151 (lines=4) @@
145 
            $subKey = array_keys($orValue)[0];
146 
            $subValue = $orValue[$subKey];
147 
            $sqlOptions = self::buildFilter([$subKey => $subValue]);
148 
            if (in_array($sqlOptions['method'], ['in', 'notIn'])) {
149 
                $orQuery[] =  $queryBuilder->expr()->{$sqlOptions['method']}( $sqlOptions['key'], $sqlOptions['value']);
150 
                continue;
151 
            }
152 
            $orQuery[] =
153 
                '`'.$sqlOptions['key'].'`'
154 
                . ' ' . $sqlOptions['operand']