View GitHub Repository sql

Schedule Inspection
Subscribe

Code Duplication    Length = 11-11 lines in 2 locations

src/SQL.php 2 locations

@@ 118-128 (lines=11) @@
115 
                    }
116 
                } else {
117 
                    $sqlOptions = self::buildFilter([$key=>$value]);
118 
                    if(in_array($sqlOptions['method'], ['in', 'notIn', ''])){
119 
                        $queryBuilder->andWhere(
120 
                            $queryBuilder->expr()->{$sqlOptions['method']}( $sqlOptions['key'], $sqlOptions['value'])
121 
                        );
122 
                    }
123 
                    else{
124 
                        $queryBuilder->andWhere(
125 
                            $sqlOptions['key']
126 
                            . ' ' . $sqlOptions['operand']
127 
                            . ' ' . $queryBuilder->createNamedParameter($sqlOptions['value']));
128 
                    }
129 
                }
130 
            }
131 
        }
@@ 101-111 (lines=11) @@
98 
                        $subValue = $orValue[$subKey];
99 
                        if (strpos($subKey, '__')!==false) {
100 
                            $sqlOptions = self::buildFilter([$subKey=>$subValue]);
101 
                            if(in_array($sqlOptions['method'], ['in','notIn',''])){
102 
                                $queryBuilder->orWhere(
103 
                                    $queryBuilder->expr()->{$sqlOptions['method']}( $sqlOptions['key'], $sqlOptions['value'])
104 
                                );
105 
                            }
106 
                            else{
107 
                                $queryBuilder->orWhere(
108 
                                    $sqlOptions['key']
109 
                                    . ' ' . $sqlOptions['operand']
110 
                                    . ' ' . $queryBuilder->createNamedParameter($sqlOptions['value']));
111 
                            }
112 
                        } else {
113 
                            $queryBuilder->orWhere($subKey . '=' . $queryBuilder->createNamedParameter($subValue));
114 
                        }