| 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, '. |
| ' identifiant AS utilisateur_courriel, '. |
| ' nom_sel, num_nom_sel, '. |
| ' location, id_location, lieudit, station, milieu, '. |
| ' ci.ci_meta_date AS date '. |
| ' 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 '. |
| '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']; |