| Line 269... |
Line 269... |
| 269 |
return $id_image_hasard;
|
269 |
return $id_image_hasard;
|
| 270 |
}
|
270 |
}
|
| Line 271... |
Line 271... |
| 271 |
|
271 |
|
| 272 |
private function chargerInfosImage() {
|
272 |
private function chargerInfosImage() {
|
| 273 |
$requete = 'SELECT SQL_CALC_FOUND_ROWS '.
|
273 |
$requete = 'SELECT SQL_CALC_FOUND_ROWS '.
|
| - |
|
274 |
' ci.ci_id_image AS id_img, ci.ci_meta_date AS date, '.
|
| 274 |
' ci.ci_id_image AS id_img, co.id AS id_obs, '.
|
275 |
' co.id AS id_obs, '.
|
| 275 |
' identifiant AS utilisateur_courriel, '.
|
276 |
' identifiant AS utilisateur_courriel, '.
|
| 276 |
' nom_sel, num_nom_sel, '.
|
277 |
' nom_sel, num_nom_sel, '.
|
| 277 |
' location, id_location, lieudit, station, milieu, '.
|
- |
|
| 278 |
' ci.ci_meta_date AS date '.
|
278 |
' location, id_location, lieudit, station, milieu '.
|
| 279 |
'FROM cel_images AS ci'.
|
279 |
'FROM cel_images AS ci'.
|
| 280 |
' LEFT JOIN cel_obs_images AS coi '.
|
280 |
' LEFT JOIN cel_obs_images AS coi '.
|
| 281 |
' ON (coi.coi_ce_image = ci.ci_id_image) '.
|
281 |
' ON (coi.coi_ce_image = ci.ci_id_image) '.
|
| 282 |
' LEFT JOIN cel_inventory AS co '.
|
282 |
' LEFT JOIN cel_inventory AS co '.
|
| Line 462... |
Line 462... |
| 462 |
$info['date'] = $img['date'];
|
462 |
$info['date'] = $img['date'];
|
| 463 |
$info['mime'] = self::MIME_JPEG;
|
463 |
$info['mime'] = self::MIME_JPEG;
|
| 464 |
$info['auteur.libelle'] = $this->Utilisateurs->getIntitule($img['utilisateur_courriel']);
|
464 |
$info['auteur.libelle'] = $this->Utilisateurs->getIntitule($img['utilisateur_courriel']);
|
| 465 |
$info['auteur.id'] = $this->Utilisateurs->getId($img['utilisateur_courriel']);
|
465 |
$info['auteur.id'] = $this->Utilisateurs->getId($img['utilisateur_courriel']);
|
| 466 |
$info['binaire.href'] = $this->formaterUrlImage($img);
|
466 |
$info['binaire.href'] = $this->formaterUrlImage($img);
|
| - |
|
467 |
$info['observation.id'] = $img['id_obs'];
|
| 467 |
if (isset($img['nom_sel'])) {
|
468 |
if (isset($img['nom_sel'])) {
|
| 468 |
$info['determination.libelle'] = $this->formaterDetermination($img);
|
469 |
$info['determination.libelle'] = $this->formaterDetermination($img);
|
| 469 |
$info['determination.nom_sci'] = $img['nom_sel'];
|
470 |
$info['determination.nom_sci'] = $img['nom_sel'];
|
| 470 |
$info['determination.nom_sci.code'] = $this->formaterNomSciCode($img);
|
471 |
$info['determination.nom_sci.code'] = $this->formaterNomSciCode($img);
|
| 471 |
}
|
472 |
}
|