View GitHub Repository webtrees

Schedule Inspection
Subscribe

Code Duplication    Length = 3-3 lines in 2 locations

app/Query/QueryName.php 1 location

@@ 377-379 (lines=3) @@
374 
			$sql .= " AND n_surn NOT IN ('', '@N.N.')";
375 
		}
376 

                                

                                                            

                                    377
                                    
                                    
		foreach (self::getAlphabetForLocale(WT_LOCALE) as $letter) {

                                

                                                            

                                    378
                                    
                                    
			$sql .= " AND n_givn NOT LIKE '" . $letter . "%' COLLATE " . I18N::collation();

                                

                                                            

                                    379
                                    
                                    
		}

                                

                                                            

                                    380
                                    
                                    
		$sql .= " GROUP BY UPPER(LEFT(n_givn, 1))) AS subquery ORDER BY initial = '@', initial = '', initial";

                                

                                                            

                                    381
                                    
                                    

                                

                                                            

                                    382
                                    
                                    
		foreach (Database::prepare($sql)->execute($args)->fetchAssoc() as $alpha => $count) {

                                

                                                                        

                

                                                            

                    
app/Controller/IndividualListController.php 1 location

                

                

                    

                                                
                                                    

                                
                                
                                    @@ 376-378 (lines=3) @@
                                
                            


                                                            

                                    373
                                    
                                    
			$sql .= " AND n_surn NOT IN ('', '@N.N.')";

                                

                                                            

                                    374
                                    
                                    
		}

                                

                                                            

                                    375
                                    
                                    

                                

                                                            

                                    376
                                    
                                    
		foreach ($this->getAlphabetForLocale(WT_LOCALE) as $letter) {

                                

                                                            

                                    377
                                    
                                    
			$sql .= " AND n_givn NOT LIKE '" . $letter . "%' COLLATE " . I18N::collation();

                                

                                                            

                                    378
                                    
                                    
		}

                                

                                                            

                                    379
                                    
                                    
		$sql .= " GROUP BY UPPER(LEFT(n_givn, 1))) AS subquery ORDER BY initial = '@', initial = '', initial";

                                

                                                            

                                    380
                                    
                                    

                                

                                                            

                                    381
                                    
                                    
		foreach (Database::prepare($sql)->execute($args)->fetchAssoc() as $alpha => $count) {