View GitHub Repository sql

Schedule Inspection
Subscribe

Code Duplication    Length = 11-11 lines in 2 locations

src/SQL.php 2 locations

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