Subversion Repositories eFlore/Applications.del

Rev

Rev 1349 | Rev 1571 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1349 Rev 1461
Line 59... Line 59...
59 
					"( ".
 59 
					"( ".
60 
					"	SELECT id_utilisateur ".
 60 
					"	SELECT id_utilisateur ".
61 
					"	FROM del_utilisateur_infos ".
 61 
					"	FROM del_utilisateur_infos ".
62 
					"		WHERE preferences LIKE ".$this->conteneur->getBdd()->proteger('%"mail_notification_mes_obs":"0"%')." ".
 62 
					"		WHERE preferences LIKE ".$this->conteneur->getBdd()->proteger('%"mail_notification_mes_obs":"0"%')." ".
63 
					") ".
 63 
					") ".
64 
					"AND DATE_FORMAT( dc.date, '%Y-%m-%d' ) = CURDATE() ".
 64 
					"AND TO_DAYS(NOW()) - TO_DAYS(dc.date) <= 1 ".
65 
					"ORDER BY dc.ce_observation";
 65 
					"ORDER BY dc.ce_observation";
66 
		$commentaires = $this->conteneur->getBdd()->recupererTous($requete);
 66 
		$commentaires = $this->conteneur->getBdd()->recupererTous($requete);
67 
		return $commentaires;
 67 
		return $commentaires;
68 
	}
 68 
	}
Line 87... Line 87...
87 
							"( ".
 87 
							"( ".
88 
							"	SELECT id_utilisateur ".
 88 
							"	SELECT id_utilisateur ".
89 
							"	FROM del_utilisateur_infos ".
 89 
							"	FROM del_utilisateur_infos ".
90 
							"		WHERE preferences LIKE ".$this->conteneur->getBdd()->proteger('%"mail_notification_mes_obs":"0"%')." ".
 90 
							"		WHERE preferences LIKE ".$this->conteneur->getBdd()->proteger('%"mail_notification_mes_obs":"0"%')." ".
91 
							") ".
 91 
							") ".
92 
						"AND DATE_FORMAT( dc.date, '%Y-%m-%d' ) = CURDATE()".
 92 
						"AND TO_DAYS(NOW()) - TO_DAYS(dc.date) <= 1 ".
93 
					") ".
93 
					") ".
94 
					"ORDER BY do.ce_utilisateur, do.id_observation ";
 94 
					"ORDER BY do.ce_utilisateur, do.id_observation ";
95 
		$observations = $this->conteneur->getBdd()->recupererTous($requete);
 95 
		$observations = $this->conteneur->getBdd()->recupererTous($requete);
96 
		return $observations;
 96 
		return $observations;
97 
	}
 97 
	}