54,8 → 54,15 |
" AND dc.ce_utilisateur = dob.ce_utilisateur ". |
" AND dc.ce_observation = dob.id_observation ". |
") ". |
"AND DATE_FORMAT( dc.date, '%Y-%m-%d' ) = CURDATE()". |
"AND dc.ce_utilisateur IN ". |
"( ". |
" SELECT id_utilisateur ". |
" FROM del_utilisateur_infos ". |
" WHERE preferences LIKE ".$this->conteneur->getBdd()->proteger('%"mail_notification_mes_obs":"1"%')." ". |
") ". |
"AND DATE_FORMAT( dc.date, '%Y-%m-%d' ) = CURDATE() ". |
"ORDER BY dc.ce_observation"; |
|
$commentaires = $this->conteneur->getBdd()->recupererTous($requete); |
return $commentaires; |
} |
89,6 → 96,7 |
$auteur_obs = $obs['ce_utilisateur']; |
$obs['date'] = $this->formaterDateObs($obs['date_observation']); |
$obs['lien'] = $this->obtenirLienFicheObs($obs['id_observation']); |
$obs['commentaires'] = array(); |
$this->correspondance_id_obs_auteurs[$id_obs] = $auteur_obs; |
$this->observations_concernees[$auteur_obs][$id_obs] = $obs; |
} |