1,5 → 1,7 |
<?php |
// declare(encoding='UTF-8'); |
|
// ATTENTION ! Classe compatible uniquement avec nouveau format de bdd du cel // |
/** |
* Service fournissant la liste des ids des images liées à une observation. |
* Encodage en entrée : utf8 |
52,22 → 54,29 |
*/ |
private function getListeIds() { |
$ids = array(); |
|
if (isset($_GET['obsId'])) { |
$observations = $this->traiterValeursMultiples($_GET['obsId']); |
|
if (! is_null($observations)) { |
$requete = 'SELECT ci.id, cim.ci_id_image '. |
'FROM cel_inventory AS ci '. |
$requete = 'SELECT co.id_observation, cim.id_image '. |
'FROM cel_obs AS co '. |
' LEFT JOIN cel_obs_images AS coi '. |
' ON (coi.coi_ce_observation = ci.ordre AND coi.coi_ce_utilisateur = ci.identifiant) '. |
' ON (coi.id_observation = co.id_observation AND coi.id_utilisateur = co.ce_utilisateur) '. |
' LEFT JOIN cel_images AS cim '. |
' ON (coi.coi_ce_image = cim.ci_id_image) '. |
"WHERE ci.id IN ($observations) "; |
$infos = $this->requeter($requete); |
' ON (coi.id_image = cim.id_image) '. |
"WHERE co.id_observation IN ($observations) "; |
|
$resultat_requete_images = $this->requeter($requete); |
|
$infos = array(); |
if(is_array($resultat_requete_images)) { |
$infos = $resultat_requete_images; |
} |
|
foreach ($infos as $info) { |
if ($info['ci_id_image'] != 0) { |
$ids[$info['id']][] = (int) $info['ci_id_image']; |
if ($info['id_image'] != 0) { |
$ids[$info['id_observation']][] = (int) $info['id_image']; |
} |
} |
} |