271,11 → 271,11 |
|
private function chargerInfosImage() { |
$requete = 'SELECT SQL_CALC_FOUND_ROWS '. |
' ci.ci_id_image AS id_img, co.id AS id_obs, '. |
' ci.ci_id_image AS id_img, ci.ci_meta_date AS date, '. |
' co.id AS id_obs, '. |
' identifiant AS utilisateur_courriel, '. |
' nom_sel, num_nom_sel, '. |
' location, id_location, lieudit, station, milieu, '. |
' ci.ci_meta_date AS date '. |
' location, id_location, lieudit, station, milieu '. |
'FROM cel_images AS ci'. |
' LEFT JOIN cel_obs_images AS coi '. |
' ON (coi.coi_ce_image = ci.ci_id_image) '. |
464,6 → 464,7 |
$info['auteur.libelle'] = $this->Utilisateurs->getIntitule($img['utilisateur_courriel']); |
$info['auteur.id'] = $this->Utilisateurs->getId($img['utilisateur_courriel']); |
$info['binaire.href'] = $this->formaterUrlImage($img); |
$info['observation.id'] = $img['id_obs']; |
if (isset($img['nom_sel'])) { |
$info['determination.libelle'] = $this->formaterDetermination($img); |
$info['determination.nom_sci'] = $img['nom_sel']; |