Subversion Repositories eFlore/Applications.cel

Rev

Rev 2209 | Rev 2461 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2209 Rev 2446
Line 72... Line 72...
72 
 
 72 
 
73 
		if (isset($_GET['obsId'])) {
 73 
		if (isset($_GET['obsId'])) {
Line 74... Line 74...
74 
			$observations = $this->traiterValeursMultiples($_GET['obsId']);
 74 
			$observations = $this->traiterValeursMultiples($_GET['obsId']);
75 
 
 75 
 
76 
			if (! is_null($observations)) {
 76 
			if (! is_null($observations)) {
77 
				$requete = 	'SELECT co.id_observation, cim.id_image '.
 - 
 
78 
							'FROM cel_obs AS co '.
 - 
 
79 
							'	LEFT JOIN cel_obs_images AS coi '.
 - 
 
80 
							'		ON (coi.id_observation = co.id_observation) '.
 - 
 
81 
							'	LEFT JOIN cel_images AS cim '.
 77 
				$requete = 	'SELECT ce_observation, id_image '.
Line 82... Line 78...
82 
							'		ON (coi.id_image = cim.id_image) '.
 78 
							'FROM cel_images '.
Line 83... Line 79...
83 
							"WHERE co.id_observation IN ($observations) ";
 79 
							"WHERE ce_observation IN ($observations) ";
84 
 
 80 
 
85 
				$resultat_requete_images = Cel::db()->requeter($requete);
 81 
				$resultats = Cel::db()->requeter($requete);
86 
 
 82 
 
Line 87... Line 83...
87 
				$infos = array();
 83 
				$infos = array();
88 
				if(is_array($resultat_requete_images)) {
 84 
				if (is_array($resultats)) {
89 
					$infos = $resultat_requete_images;
 85 
					$infos = $resultats;
90 
				}
 86 
				}
91 
 
 87 
 
92 
				foreach ($infos as $info) {
 88 
				foreach ($infos as $info) {
93 
					if(is_numeric($info['id_image'])) {
 89 
					if (is_numeric($info['id_image'])) {
94 
						$ids[$info['id_observation']][] = (int) $info['id_image'];
 90 
						$ids[$info['ce_observation']][] = (int) $info['id_image'];