| 48,7 → 48,7 |
|---|
| } |
| $this->envoyerJson($retour); |
| } |
| |
| |
| private function getImage() { |
| $image = null; |
| if (isset($_GET['imgId'])) { |
| 74,24 → 74,20 |
|---|
| $observations = $this->traiterValeursMultiples($_GET['obsId']); |
| |
| if (! is_null($observations)) { |
| $requete = 'SELECT co.id_observation, cim.id_image '. |
| 'FROM cel_obs AS co '. |
| ' LEFT JOIN cel_obs_images AS coi '. |
| ' ON (coi.id_observation = co.id_observation) '. |
| ' LEFT JOIN cel_images AS cim '. |
| ' ON (coi.id_image = cim.id_image) '. |
| "WHERE co.id_observation IN ($observations) "; |
| $requete = 'SELECT ce_observation, id_image '. |
| 'FROM cel_images '. |
| "WHERE ce_observation IN ($observations) "; |
| |
| $resultat_requete_images = Cel::db()->requeter($requete); |
| $resultats = Cel::db()->requeter($requete); |
| |
| $infos = array(); |
| if(is_array($resultat_requete_images)) { |
| $infos = $resultat_requete_images; |
| if (is_array($resultats)) { |
| $infos = $resultats; |
| } |
| |
| foreach ($infos as $info) { |
| if(is_numeric($info['id_image'])) { |
| $ids[$info['id_observation']][] = (int) $info['id_image']; |
| if (is_numeric($info['id_image'])) { |
| $ids[$info['ce_observation']][] = (int) $info['id_image']; |
| } |
| } |
| } |