| Line 44... |
Line 44... |
| 44 |
//TODO: optimiser la requête si beaucoup de mails sont envoyés
|
44 |
//TODO: optimiser la requête si beaucoup de mails sont envoyés
|
| 45 |
$requete = "SELECT * ".
|
45 |
$requete = "SELECT * ".
|
| 46 |
"FROM del_observation do ".
|
46 |
"FROM del_observation do ".
|
| 47 |
"LEFT JOIN del_utilisateur du ".
|
47 |
"LEFT JOIN del_utilisateur du ".
|
| 48 |
"ON do.ce_utilisateur = du.id_utilisateur ".
|
48 |
"ON do.ce_utilisateur = du.id_utilisateur ".
|
| 49 |
'WHERE (do.mots_cles_texte LIKE "%aDeterminer%" OR nom_sel IS NULL OR nom_ret IS NULL) '.
|
49 |
'WHERE (do.mots_cles_texte LIKE "%aDeterminer%" OR nom_sel IS NULL OR nom_ret IS NULL) AND '.
|
| 50 |
"AND DATE_FORMAT( do.date_transmission, '%Y-%m-%d' ) = CURDATE() ".
|
50 |
'(do.date_transmission > DATE_SUB(CURDATE(), INTERVAL 1 DAY) OR '.
|
| - |
|
51 |
'do.date_creation > DATE_SUB(CURDATE(), INTERVAL 1 DAY) OR '.
|
| - |
|
52 |
'do.date_modification > DATE_SUB(CURDATE(), INTERVAL 1 DAY)) '.
|
| 51 |
"ORDER BY do.id_observation";
|
53 |
"ORDER BY do.id_observation";
|
| 52 |
$obs = $this->conteneur->getBdd()->recupererTous($requete);
|
54 |
$obs = $this->conteneur->getBdd()->recupererTous($requete);
|
| 53 |
return $obs;
|
55 |
return $obs;
|
| 54 |
}
|
56 |
}
|