@@ 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; |