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