| 46,8 → 46,10 |
|---|
| "FROM del_observation do ". |
| "LEFT JOIN del_utilisateur du ". |
| "ON do.ce_utilisateur = du.id_utilisateur ". |
| 'WHERE (do.mots_cles_texte LIKE "%aDeterminer%" OR nom_sel IS NULL OR nom_ret IS NULL) '. |
| "AND DATE_FORMAT( do.date_transmission, '%Y-%m-%d' ) = CURDATE() ". |
| 'WHERE (do.mots_cles_texte LIKE "%aDeterminer%" OR nom_sel IS NULL OR nom_ret IS NULL) AND '. |
| '(do.date_transmission > DATE_SUB(CURDATE(), INTERVAL 1 DAY) OR '. |
| 'do.date_creation > DATE_SUB(CURDATE(), INTERVAL 1 DAY) OR '. |
| 'do.date_modification > DATE_SUB(CURDATE(), INTERVAL 1 DAY)) '. |
| "ORDER BY do.id_observation"; |
| $obs = $this->conteneur->getBdd()->recupererTous($requete); |
| return $obs; |