Subversion Repositories eFlore/Applications.del

Compare Revisions

Ignore whitespace Rev 1743 → Rev 1744

/branches/v1.3-beryllium/scripts/modules/adeterminer/AlerteMailADeterminer.php
81,9 → 81,9
' OR nom_sel IS NULL OR nom_sel = "" '.
' OR nom_ret IS NULL OR nom_ret = "") '.
' AND ('.
" do.date_transmission > DATE_SUB($date, INTERVAL 1 DAY) ".
" OR do.date_creation > DATE_SUB($date, INTERVAL 1 DAY) ".
" OR do.date_modification > DATE_SUB($date, INTERVAL 1 DAY) ".
" TO_DAYS($date) - TO_DAYS(do.date_transmission) IN (0, 1) ".
" OR TO_DAYS($date) - TO_DAYS(do.date_creation) IN (0, 1) ".
" OR TO_DAYS($date) - TO_DAYS(do.date_modification) IN (0, 1) ".
' ) '.
"ORDER BY do.id_observation ";
$obs = $this->conteneur->getBdd()->recupererTous($requete);
/branches/v1.3-beryllium/scripts/modules/commentaires/AlerteMailCommentaires.php
194,7 → 194,7
" FROM del_utilisateur_infos ".
" WHERE preferences LIKE $preferences ".
") ".
"AND TO_DAYS($date) - TO_DAYS(dc.date) <= 1 ".
"AND TO_DAYS($date) - TO_DAYS(dc.date) IN (0, 1) ".
"ORDER BY dc.ce_observation";
$commentaires = $this->conteneur->getBdd()->recupererTous($requete);
return $commentaires;