| 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; |
| } |