| Line 165... |
Line 165... |
| 165 |
if (!empty($idsCommentaires)) {
|
165 |
if (!empty($idsCommentaires)) {
|
| 166 |
$idsCommentairesconcat = implode(', ', $idsCommentaires);
|
166 |
$idsCommentairesconcat = implode(', ', $idsCommentaires);
|
| 167 |
$requete = 'SELECT DISTINCT dc.*, '.
|
167 |
$requete = 'SELECT DISTINCT dc.*, '.
|
| 168 |
' dob.id_observation AS dob_id_observation, dob.ce_zone_geo AS dob_ce_zone_geo, '.
|
168 |
' dob.id_observation AS dob_id_observation, dob.ce_zone_geo AS dob_ce_zone_geo, '.
|
| 169 |
' dob.zone_geo AS dob_zone_geo, dob.date_observation AS dob_date_observation, dob.nom_sel AS dob_nom_sel, '.
|
169 |
' dob.zone_geo AS dob_zone_geo, dob.date_observation AS dob_date_observation, dob.nom_sel AS dob_nom_sel, '.
|
| 170 |
' duo.prenom AS observateur_prenom, duo.nom AS observateur_nom, duo.courriel AS observateur_courriel '.
|
170 |
' dob.prenom_utilisateur AS observateur_prenom, dob.nom_utilisateur AS observateur_nom, dob.courriel_utilisateur AS observateur_courriel '.
|
| 171 |
'FROM del_commentaire AS dc '.
|
171 |
'FROM del_commentaire AS dc '.
|
| 172 |
' INNER JOIN del_observation AS dob '.
|
172 |
' INNER JOIN del_observation AS dob '.
|
| 173 |
' ON dob.id_observation = dc.ce_observation '.
|
173 |
' ON dob.id_observation = dc.ce_observation '.
|
| 174 |
' LEFT JOIN del_utilisateur AS duo '.
|
- |
|
| 175 |
' ON dob.ce_utilisateur = duo.id_utilisateur '.
|
- |
|
| 176 |
"WHERE id_commentaire IN ($idsCommentairesconcat) ".
|
174 |
"WHERE id_commentaire IN ($idsCommentairesconcat) ".
|
| 177 |
'ORDER BY dc.date DESC '.
|
175 |
'ORDER BY dc.date DESC '.
|
| 178 |
'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite().' '.
|
176 |
'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite().' '.
|
| 179 |
' -- '.__FILE__.' : '.__LINE__;
|
177 |
' -- '.__FILE__.' : '.__LINE__;
|
| 180 |
$commentaires = $this->bdd->recupererTous($requete);
|
178 |
$commentaires = $this->bdd->recupererTous($requete);
|