View GitHub Repository sql

Schedule Inspection
Subscribe

Code Duplication    Length = 4-6 lines in 2 locations

src/SQL.php 2 locations

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