View GitHub Repository f3-cms

Schedule Inspection
Subscribe

Code Duplication    Length = 6-6 lines in 2 locations

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

@@ 239-244 (lines=6) @@
236 
        $db = \Registry::get('db');
237 
        $sqlClauses = [];
238 
        $searchFieldsArray = preg_split("/[,]/", $searchFields);
239 
        foreach ($searchFieldsArray as $field) {
240 
            $sqlClauses[] = 'LOWER(' . $db->quotekey($field) . ') = ' . $db->quote($search);
241 
            if ($search_type == 'fuzzy') {
242 
                $sqlClauses[] = 'LOWER(' . $db->quotekey($field) . ') LIKE ' . $db->quote('%' . $search . '%');
243 
            }
244 
        }
245 

                                

                                                            

                                    246
                                    
                                    
        // get total results

                                

                                                            

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

                                

                                                                        

                

                                                            

                    
app/lib/FFCMS/Controllers/API/APIMapper.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 ';