| Line 72... |
Line 72... |
| 72 |
}
|
72 |
}
|
| Line 73... |
Line 73... |
| 73 |
|
73 |
|
| 74 |
protected function chargerObsADeterminer() {
|
74 |
protected function chargerObsADeterminer() {
|
| 75 |
//TODO: optimiser la requête si beaucoup de mails sont envoyés
|
75 |
//TODO: optimiser la requête si beaucoup de mails sont envoyés
|
| 76 |
$date = ($this->dateRenvoi == null) ? 'CURDATE()' : "'$this->dateRenvoi'";
|
76 |
$date = ($this->dateRenvoi == null) ? 'CURDATE()' : "'$this->dateRenvoi'";
|
| - |
|
77 |
$requete = 'SELECT id_observation, do.courriel_utilisateur, '.
|
| - |
|
78 |
' date_observation, nom_ret, nom_sel, '.
|
| 77 |
$requete = "SELECT * ".
|
79 |
' ce_zone_geo, zone_geo, lieudit, station '.
|
| 78 |
"FROM del_obs_image AS doi ".
|
80 |
'FROM del_observation AS do '.
|
| 79 |
" INNER JOIN del_observation AS do ON doi.id_observation = do.id_observation ".
|
81 |
'WHERE do.ce_utilisateur != 0 '.
|
| 80 |
" LEFT JOIN del_utilisateur AS du ON do.ce_utilisateur = du.id_utilisateur AND do.ce_utilisateur != 0 ".
|
82 |
' AND do.ce_utilisateur IS NOT NULL '.
|
| 81 |
'WHERE (do.mots_cles_texte LIKE "%aDeterminer%" '.
|
83 |
' AND (do.mots_cles_texte LIKE "%aDeterminer%" '.
|
| 82 |
' OR nom_sel IS NULL OR nom_sel = "" '.
|
84 |
' OR nom_sel IS NULL OR nom_sel = "" '.
|
| 83 |
' OR nom_ret IS NULL OR nom_ret = "") '.
|
85 |
' OR nom_ret IS NULL OR nom_ret = "") '.
|
| 84 |
' AND ('.
|
86 |
' AND ('.
|
| 85 |
" TO_DAYS($date) - TO_DAYS(do.date_transmission) IN (0, 1) ".
|
87 |
" TO_DAYS($date) - TO_DAYS(do.date_transmission) IN (0, 1) ".
|