View GitHub Repository silverstripe-blog

Schedule Inspection
Subscribe

Code Duplication    Length = 7-7 lines in 2 locations

code/model/Blog.php 2 locations

@@ 486-492 (lines=7) @@
483 
        if (DB::$getConnectionMethod() instanceof MySQLDatabase) {
484 
            $query->where(sprintf('YEAR("PublishDate") = \'%s\'', Convert::raw2sql($year)));
485 

                                

                                                            

                                    486
                                    
                                    
            if ($month) {

                                

                                                            

                                    487
                                    
                                    
                $query->where(sprintf('MONTH("PublishDate") = \'%s\'', Convert::raw2sql($month)));

                                

                                                            

                                    488
                                    
                                    

                                

                                                            

                                    489
                                    
                                    
                if ($day) {

                                

                                                            

                                    490
                                    
                                    
                    $query->where(sprintf('DAY("PublishDate") = \'%s\'', Convert::raw2sql($day)));

                                

                                                            

                                    491
                                    
                                    
                }

                                

                                                            

                                    492
                                    
                                    
            }

                                

                                                            

                                    493
                                    
                                    
        } elseif (DB::$getConnectionMethod() instanceof PostgreSQLDatabase) {

                                

                                                            

                                    494
                                    
                                    
            $where = sprintf('EXTRACT(YEAR FROM "PublishDate") = \'%s\'', Convert::raw2sql($year));

                                

                                                            

                                    495
                                    
                                    

                                

                                                                                

                                
                                
                                    @@ 496-502 (lines=7) @@
                                
                            


                                                            

                                    493
                                    
                                    
        } elseif (DB::$getConnectionMethod() instanceof PostgreSQLDatabase) {

                                

                                                            

                                    494
                                    
                                    
            $where = sprintf('EXTRACT(YEAR FROM "PublishDate") = \'%s\'', Convert::raw2sql($year));

                                

                                                            

                                    495
                                    
                                    

                                

                                                            

                                    496
                                    
                                    
            if ($month) {

                                

                                                            

                                    497
                                    
                                    
                $where .= sprintf(' AND EXTRACT(MONTH FROM "PublishDate") = \'%s\'', Convert::raw2sql($month));

                                

                                                            

                                    498
                                    
                                    

                                

                                                            

                                    499
                                    
                                    
                if ($day) {

                                

                                                            

                                    500
                                    
                                    
                    $where .= sprintf(' AND EXTRACT(DAY FROM "PublishDate") = \'%s\'', Convert::raw2sql($day));

                                

                                                            

                                    501
                                    
                                    
                }

                                

                                                            

                                    502
                                    
                                    
            }

                                

                                                            

                                    503
                                    
                                    

                                

                                                            

                                    504
                                    
                                    
            $query->where($where);

                                

                                                            

                                    505
                                    
                                    
        }