View GitHub Repository sql

Schedule Inspection
Subscribe

Code Duplication    Length = 6-7 lines in 2 locations

src/SQL.php 2 locations

@@ 185-190 (lines=6) @@
182 
                        if(in_array($sqlOptions['method'], ['in', 'notIn'])){
183 
                            $orQuery[] =  $queryBuilder->expr()->{$sqlOptions['method']}( $sqlOptions['key'], $sqlOptions['value']);
184 
                        }
185 
                        else{
186 
                            $orQuery[] =
187 
                                '`'.$sqlOptions['key'].'`'
188 
                                . ' ' . $sqlOptions['operand']
189 
                                . ' ' . $queryBuilder->createNamedParameter($sqlOptions['value']);
190 
                        }
191 
                    }
192 

                                

                                                            

                                    193
                                    
                                    
                    $queryBuilder->andWhere(

                                

                                                                                

                                
                                
                                    @@ 203-209 (lines=7) @@
                                
                            


                                                            

                                    200
                                    
                                    
                            $queryBuilder->expr()->{$sqlOptions['method']}( $sqlOptions['key'], $sqlOptions['value'])

                                

                                                            

                                    201
                                    
                                    
                        );

                                

                                                            

                                    202
                                    
                                    
                    }

                                

                                                            

                                    203
                                    
                                    
                    else{

                                

                                                            

                                    204
                                    
                                    
                        $queryBuilder->andWhere(

                                

                                                            

                                    205
                                    
                                    
                            '`'.$sqlOptions['key'].'`'

                                

                                                            

                                    206
                                    
                                    
                            . ' ' . $sqlOptions['operand']

                                

                                                            

                                    207
                                    
                                    
                            . ' ' . $queryBuilder->createNamedParameter($sqlOptions['value'])

                                

                                                            

                                    208
                                    
                                    
                        );

                                

                                                            

                                    209
                                    
                                    
                    }

                                

                                                            

                                    210
                                    
                                    
                }

                                

                                                            

                                    211
                                    
                                    
            }

                                

                                                            

                                    212
                                    
                                    
        }