| 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']; |
| } |
| } |
| } |