Subversion Repositories eFlore/Applications.del

Compare Revisions

Ignore whitespace Rev 1460 → Rev 1461

/trunk/scripts/modules/commentaires/AlerteMailCommentaires.php
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);