Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1739 Rev 1742
Line 18... Line 18...
18 
	private $conteneur;
 18 
	private $conteneur;
19 
	private $testeurCourriel = null;
 19 
	private $testeurCourriel = null;
20 
	private $recapitulatifAdmin = [];
 20 
	private $recapitulatifAdmin = [];
21 
	private $messageRecapitulatif = null;
 21 
	private $messageRecapitulatif = null;
Line -... Line 22...
- 
 
 22 
 
- 
 
 23 
	private $dateRenvoi = null;
22 
 
 24 
 
23 
	private $observations_concernees = array();
 25 
	private $observations_concernees = array();
24 
	private $correspondance_id_obs_auteurs = array();
 26 
	private $correspondance_id_obs_auteurs = array();
Line 25... Line 27...
25 
	private 	$utilisateursInfos = array();
 27 
	private 	$utilisateursInfos = array();
Line 29... Line 31...
29 
	}
 31 
	}
Line 30... Line 32...
30 
 
 32 
 
31 
	public function executer() {
 33 
	public function executer() {
32 
		try {
 34 
		try {
- 
 
 35 
			$this->verifierModeUtilisation();
33 
			$this->verifierModeUtilisation();
 36 
			$this->verifierDateRenvoi();
34 
			$observations = $this->chargerObservationsCommentees();
 37 
			$observations = $this->chargerObservationsCommentees();
35 
			if (!empty($observations)) {
 38 
			if (!empty($observations)) {
36 
				$this->formaterObservations($observations);
 39 
				$this->formaterObservations($observations);
37 
				$commentaires = $this->chargerCommentairesDuJour();
 40 
				$commentaires = $this->chargerCommentairesDuJour();
Line 53... Line 56...
53 
				new Exception($msg);
 56 
				new Exception($msg);
54 
			}
 57 
			}
55 
		}
 58 
		}
56 
	}
 59 
	}
Line -... Line 60...
- 
 
 60 
 
- 
 
 61 
	private function verifierDateRenvoi() {
- 
 
 62 
		$dateRenvoi = $this->conteneur->getParametre('d');
- 
 
 63 
		if ($dateRenvoi) {
- 
 
 64 
			if (preg_match('/^[0-9]{4}-[0-1][0-9]-[0-3][0-9]$/', $dateRenvoi)) {
- 
 
 65 
				$this->dateRenvoi = $dateRenvoi;
- 
 
 66 
			} else {
- 
 
 67 
				$msg = "Veuillez indiquer une date au format yyyy-mm-dd valide à la suite du paramètre «-d».";
- 
 
 68 
				new Exception($msg);
- 
 
 69 
			}
- 
 
 70 
		}
- 
 
 71 
	}
57 
 
 72 
 
58 
	private function chargerObservationsCommentees() {
 73 
	private function chargerObservationsCommentees() {
59 
		// Seuls les utilisateurs ayant explicitement refusé le mail sont ignorés
 74 
		// Seuls les utilisateurs ayant explicitement refusé le mail sont ignorés
- 
 
 75 
		$preferences = $this->conteneur->getBdd()->proteger('%"mail_notification_mes_obs":"0"%');
- 
 
 76 
		$date = ($this->dateRenvoi == null) ? 'NOW()' : "'$this->dateRenvoi'";
60 
		$preferences = $this->conteneur->getBdd()->proteger('%"mail_notification_mes_obs":"0"%');
 77 
 
61 
		//TODO: optimiser la requête si beaucoup de mails sont envoyés
 78 
		//TODO: optimiser la requête si beaucoup de mails sont envoyés
62 
		$requete = "SELECT * FROM del_observation AS do ".
 79 
		$requete = "SELECT * FROM del_observation AS do ".
63 
			"WHERE do.id_observation IN ".
 80 
			"WHERE do.id_observation IN ".
64 
				"( ".
 81 
				"( ".
Line 72... Line 89...
72 
					"	FROM del_commentaire AS dc, del_observation AS dob".
 89 
					"	FROM del_commentaire AS dc, del_observation AS dob".
73 
					"	WHERE dc.nom_sel = dob.nom_sel ".
 90 
					"	WHERE dc.nom_sel = dob.nom_sel ".
74 
					"		AND dc.ce_utilisateur = dob.ce_utilisateur ".
 91 
					"		AND dc.ce_utilisateur = dob.ce_utilisateur ".
75 
					"		AND dc.ce_observation = dob.id_observation ".
 92 
					"		AND dc.ce_observation = dob.id_observation ".
76 
					") ".
 93 
					") ".
77 
					"AND TO_DAYS(NOW()) - TO_DAYS(dc.date) <= 1 ".
 94 
					"AND TO_DAYS($date) - TO_DAYS(dc.date) <= 1 ".
78 
				") ".
 95 
				") ".
79 
				"AND do.ce_utilisateur NOT IN ".
 96 
				"AND do.ce_utilisateur NOT IN ".
80 
					"( ".
 97 
					"( ".
81 
					"	SELECT id_utilisateur ".
 98 
					"	SELECT id_utilisateur ".
82 
					"	FROM del_utilisateur_infos ".
 99 
					"	FROM del_utilisateur_infos ".
Line 155... Line 172...
155 
		return sprintf($this->conteneur->getParametre('url_fiche_observation'), $id_obs);
 172 
		return sprintf($this->conteneur->getParametre('url_fiche_observation'), $id_obs);
156 
	}
 173 
	}
Line 157... Line 174...
157 
 
 174 
 
158 
	protected function chargerCommentairesDuJour() {
 175 
	protected function chargerCommentairesDuJour() {
- 
 
 176 
		$preferences = $this->conteneur->getBdd()->proteger('%"mail_notification_mes_obs":"0"%');
- 
 
 177 
		$date = ($this->dateRenvoi == null) ? 'NOW()' : "'$this->dateRenvoi'";
159 
		$preferences = $this->conteneur->getBdd()->proteger('%"mail_notification_mes_obs":"0"%');
 178 
 
160 
		// TODO: optimiser la requête si beaucoup de mails sont envoyés
 179 
		// TODO: optimiser la requête si beaucoup de mails sont envoyés
161 
		$requete = "SELECT * ".
 180 
		$requete = "SELECT * ".
162 
			"FROM del_commentaire AS dc ".
 181 
			"FROM del_commentaire AS dc ".
163 
			"WHERE dc.ce_observation != '0' ".
 182 
			"WHERE dc.ce_observation != '0' ".
Line 173... Line 192...
173 
			"( ".
 192 
			"( ".
174 
			"	SELECT id_utilisateur ".
 193 
			"	SELECT id_utilisateur ".
175 
			"	FROM del_utilisateur_infos ".
 194 
			"	FROM del_utilisateur_infos ".
176 
			"	WHERE preferences LIKE $preferences ".
 195 
			"	WHERE preferences LIKE $preferences ".
177 
			") ".
 196 
			") ".
178 
			"AND TO_DAYS(NOW()) - TO_DAYS(dc.date) <= 1 ".
 197 
			"AND TO_DAYS($date) - TO_DAYS(dc.date) <= 1 ".
179 
			"ORDER BY dc.ce_observation";
 198 
			"ORDER BY dc.ce_observation";
180 
		$commentaires = $this->conteneur->getBdd()->recupererTous($requete);
 199 
		$commentaires = $this->conteneur->getBdd()->recupererTous($requete);
181 
		return $commentaires;
 200 
		return $commentaires;
182 
	}
 201 
	}