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