Code Duplication    Length = 6-8 lines in 2 locations

system/sql.php 2 locations

@@ 223-228 (lines=6) @@
220
                } catch (Exception $e) {
221
                    $valeur = $valeur;
222
                }
223
                if (0 === strpos($champ, 'equal_')) {
224
                    $champ = substr($champ, 6);
225
                    $where[$champ] = "$champ LIKE '" . Sql::sanitize(trim($valeur)) . "'";
226
                } else {
227
                    $where[$champ] = "$champ LIKE '" . Sql::sanitize(trim($valeur)) . "%'";
228
                }
229
            } else {
230
                if ($valeur == "null") {
231
                    $where[$champ] = "$champ IS null";
@@ 234-241 (lines=8) @@
231
                    $where[$champ] = "$champ IS null";
232
                } elseif ($valeur == "IS NOT null") {
233
                    $where[$champ] = "$champ IS NOT null";
234
                } elseif ($valeur != '') {
235
                    if (0 === strpos($champ, 'equal_')) {
236
                        $champ = substr($champ, 6);
237
                        $where[$champ] = "$champ = '" . Sql::sanitize(trim($valeur)) . "'";
238
                    } else {
239
                        $where[$champ] = "$champ LIKE '%" . Sql::sanitize(trim($valeur)) . "%'";
240
                    }
241
                }
242
            }
243
        }
244
        return $where;