| 69,6 → 69,7 |
|---|
| } |
| |
| protected function chargerObservationsCommentees() { |
| // Seuls les utilisateurs ayant explicitement refusé le mail sont ignorés |
| $preferences = $this->conteneur->getBdd()->proteger('%"mail_notification_mes_obs":"0"%'); |
| //TODO: optimiser la requête si beaucoup de mails sont envoyés |
| $requete = "SELECT * FROM del_observation AS do ". |
| 85,14 → 86,14 |
|---|
| " AND dc.ce_utilisateur = dob.ce_utilisateur ". |
| " AND dc.ce_observation = dob.id_observation ". |
| ") ". |
| "AND dc.ce_utilisateur NOT IN ". |
| "( ". |
| " SELECT id_utilisateur ". |
| " FROM del_utilisateur_infos ". |
| " WHERE preferences LIKE $preferences ". |
| ") ". |
| "AND TO_DAYS(NOW()) - TO_DAYS(dc.date) <= 1 ". |
| ") ". |
| "AND do.ce_utilisateur NOT IN ". |
| "( ". |
| " SELECT id_utilisateur ". |
| " FROM del_utilisateur_infos ". |
| " WHERE preferences LIKE $preferences ". |
| ") ". |
| "ORDER BY do.ce_utilisateur, do.id_observation "; |
| $observations = $this->conteneur->getBdd()->recupererTous($requete); |
| return $observations; |