View GitHub Repository f3-cms

Schedule Inspection
Subscribe

Code Duplication    Length = 6-6 lines in 2 locations

app/lib/FFCMS/Controllers/API/Mapper.php 1 location

@@ 558-563 (lines=6) @@
555 
        $db = \Registry::get('db');
556 
        $sqlClauses = [];
557 
        $searchFieldsArray = preg_split("/[,]/", $searchFields);
558 
        foreach ($searchFieldsArray as $field) {
559 
            $sqlClauses[] = 'LOWER(' . $db->quotekey($field) . ') = ' . $db->quote($search);
560 
            if ($search_type == 'fuzzy') {
561 
                $sqlClauses[] = 'LOWER(' . $db->quotekey($field) . ') LIKE ' . $db->quote('%' . $search . '%');
562 
            }
563 
        }
564 

                                

                                                            

                                    565
                                    
                                    
        // get total results

                                

                                                            

                                    566
                                    
                                    
        $query = 'SELECT COUNT(*) AS results FROM ' . $db->quotekey($m->table()) . ' WHERE ';

                                

                                                                        

                

                                                            

                    
app/lib/FFCMS/Traits/ControllerMapper.php 1 location

                

                

                    

                                                
                                                    

                                
                                
                                    @@ 236-241 (lines=6) @@
                                
                            


                                                            

                                    233
                                    
                                    
        $db = \Registry::get('db');

                                

                                                            

                                    234
                                    
                                    
        $sqlClauses = [];

                                

                                                            

                                    235
                                    
                                    
        $searchFieldsArray = preg_split("/[,]/", $searchFields);

                                

                                                            

                                    236
                                    
                                    
        foreach ($searchFieldsArray as $field) {

                                

                                                            

                                    237
                                    
                                    
            $sqlClauses[] = 'LOWER(' . $db->quotekey($field) . ') = ' . $db->quote($search);

                                

                                                            

                                    238
                                    
                                    
            if ($search_type == 'fuzzy') {

                                

                                                            

                                    239
                                    
                                    
                $sqlClauses[] = 'LOWER(' . $db->quotekey($field) . ') LIKE ' . $db->quote('%' . $search . '%');

                                

                                                            

                                    240
                                    
                                    
            }

                                

                                                            

                                    241
                                    
                                    
        }

                                

                                                            

                                    242
                                    
                                    

                                

                                                            

                                    243
                                    
                                    
        // get total results

                                

                                                            

                                    244
                                    
                                    
        $query = 'SELECT COUNT(*) AS results FROM ' . $db->quotekey($m->table()) . ' WHERE ' . join(' OR ', $sqlClauses);