| Line 147... |
Line 147... |
| 147 |
'nom_sel_nn AS `determination.nn`, famille AS `determination.famille`, '.
|
147 |
'nom_sel_nn AS `determination.nn`, famille AS `determination.famille`, '.
|
| 148 |
'nom_referentiel AS `determination.referentiel`, ce_zone_geo AS id_zone_geo, pays, '.
|
148 |
'nom_referentiel AS `determination.referentiel`, ce_zone_geo AS id_zone_geo, pays, '.
|
| 149 |
'zone_geo, lieudit, station, milieu, date_observation, do.mots_cles_texte, '.
|
149 |
'zone_geo, lieudit, station, milieu, date_observation, do.mots_cles_texte, '.
|
| 150 |
'do.date_transmission, do.commentaire, '.
|
150 |
'do.date_transmission, do.commentaire, '.
|
| 151 |
'do.ce_utilisateur AS `auteur.id`, do.prenom_utilisateur AS `auteur.prenom`, '.
|
151 |
'do.ce_utilisateur AS `auteur.id`, do.prenom_utilisateur AS `auteur.prenom`, '.
|
| 152 |
'do.nom_utilisateur AS `auteur.nom`, '.
|
152 |
'do.nom_utilisateur AS `auteur.nom`, do.courriel_utilisateur AS `auteur.courriel`, '.
|
| 153 |
'id_image, date_prise_de_vue AS `date`, hauteur, largeur, nom_original '.
|
153 |
'id_image, date_prise_de_vue AS `date`, hauteur, largeur, nom_original '.
|
| 154 |
'FROM del_observation AS do '.
|
154 |
'FROM del_observation AS do '.
|
| 155 |
' LEFT JOIN del_image AS di ON (do.id_observation = di.ce_observation) '.
|
155 |
' LEFT JOIN del_image AS di ON (do.id_observation = di.ce_observation) '.
|
| 156 |
"WHERE id_observation IN ($idsObsConcat) ".
|
156 |
"WHERE id_observation IN ($idsObsConcat) ".
|
| 157 |
' -- '.__FILE__.':'.__LINE__;
|
157 |
' -- '.__FILE__.':'.__LINE__;
|
| Line 381... |
Line 381... |
| 381 |
'GROUP BY ce_proposition '.
|
381 |
'GROUP BY ce_proposition '.
|
| 382 |
'-- '.__FILE__.':'.__LINE__;
|
382 |
'-- '.__FILE__.':'.__LINE__;
|
| 383 |
$commentaires = $this->bdd->recuperer($requete);
|
383 |
$commentaires = $this->bdd->recuperer($requete);
|
| 384 |
return $commentaires ? $commentaires['nb'] : 0;
|
384 |
return $commentaires ? $commentaires['nb'] : 0;
|
| 385 |
}
|
385 |
}
|
| 386 |
}
|
386 |
}
|
| 387 |
|
387 |
|