61,7 → 61,7 |
" FROM del_utilisateur_infos ". |
" WHERE preferences LIKE ".$this->conteneur->getBdd()->proteger('%"mail_notification_mes_obs":"0"%')." ". |
") ". |
"AND DATE_FORMAT( dc.date, '%Y-%m-%d' ) = CURDATE() ". |
"AND TO_DAYS(NOW()) - TO_DAYS(dc.date) <= 1 ". |
"ORDER BY dc.ce_observation"; |
$commentaires = $this->conteneur->getBdd()->recupererTous($requete); |
return $commentaires; |
89,7 → 89,7 |
" FROM del_utilisateur_infos ". |
" WHERE preferences LIKE ".$this->conteneur->getBdd()->proteger('%"mail_notification_mes_obs":"0"%')." ". |
") ". |
"AND DATE_FORMAT( dc.date, '%Y-%m-%d' ) = CURDATE()". |
"AND TO_DAYS(NOW()) - TO_DAYS(dc.date) <= 1 ". |
") ". |
"ORDER BY do.ce_utilisateur, do.id_observation "; |
$observations = $this->conteneur->getBdd()->recupererTous($requete); |