Subversion Repositories eFlore/Projets.eflore-projets

Rev

Rev 726 | Rev 846 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 726 Rev 767
Line 231... Line 231...
231 
			'FROM cel_obs_images AS coi '.
 231 
			'FROM cel_obs_images AS coi '.
232 
			'	LEFT JOIN cel_obs AS co '.
 232 
			'	LEFT JOIN cel_obs AS co '.
233 
					'ON (coi.id_observation = co.id_observation) '.
 233 
					'ON (coi.id_observation = co.id_observation) '.
234 
			'WHERE ci.transmission = 1 '.
 234 
			'WHERE ci.transmission = 1 '.
235 
			"	AND ci.nom_ret_nn IN ($numNom)";
 235 
			"	AND ci.nom_ret_nn IN ($numNom)";
236 
			"	AND co.nom_referentiel = ".$this->Bdd->proteger($refTax);
 236 
			"	AND co.nom_referentiel = ".$this->Bdd->proteger($refTax) . ' -- ' . __FILE__ . ':' . __LINE__;
Line 237... Line 237...
237 
 
 237 
 
Line 238... Line 238...
238 
		$resultat = $this->Bdd->recupererTous($requete);
 238 
		$resultat = $this->Bdd->recupererTous($requete);
239 
 
 239 
 
Line 258... Line 258...
258 
					'		ON (coi.id_observation = co.id_observation) '.
 258 
					'		ON (coi.id_observation = co.id_observation) '.
259 
					'WHERE co.transmission = 1 '.
 259 
					'WHERE co.transmission = 1 '.
260 
					"	AND co.nom_ret_nn IN ($numNom) ".
 260 
					"	AND co.nom_ret_nn IN ($numNom) ".
261 
					'	AND ci.date_prise_de_vue != "0000-00-00" ORDER BY ci.date_prise_de_vue ASC '.
 261 
					'	AND ci.date_prise_de_vue != "0000-00-00" ORDER BY ci.date_prise_de_vue ASC '.
262 
					'	AND co.nom_referentiel LIKE '.$this->proteger($refTax.'%').' '.
 262 
					'	AND co.nom_referentiel LIKE '.$this->proteger($refTax.'%').' '.
263 
					'LIMIT 1';
 263 
					'LIMIT 1' . ' -- ' . __FILE__ . ':' . __LINE__;
Line 264... Line 264...
264 
 
 264 
 
Line 265... Line 265...
265 
		$resultat = $this->Bdd->recupererTous($requete);
 265 
		$resultat = $this->Bdd->recupererTous($requete);
266 
 
 266 
 
Line 285... Line 285...
285 
				'	LEFT JOIN cel_obs_images AS coi  '.
 285 
				'	LEFT JOIN cel_obs_images AS coi  '.
286 
				'		ON (coi.id_image = ci.id_image) '.
 286 
				'		ON (coi.id_image = ci.id_image) '.
287 
				'	LEFT JOIN cel_obs AS co '.
 287 
				'	LEFT JOIN cel_obs AS co '.
288 
				'		ON (coi.id_observation = co.id_observation) '.
 288 
				'		ON (coi.id_observation = co.id_observation) '.
289 
				'WHERE ci.id_image = '.$this->ressources[0].
 289 
				'WHERE ci.id_image = '.$this->ressources[0].
290 
				' AND co.id_observation IS NOT NULL';
 290 
				' AND co.id_observation IS NOT NULL' . ' -- ' . __FILE__ . ':' . __LINE__;
Line 291... Line 291...
291 
 
 291 
 
292 
		$this->infosImages = $this->Bdd->recupererTous($requete);
 292 
		$this->infosImages = $this->Bdd->recupererTous($requete);
Line 293... Line 293...
293 
	}
 293 
	}
Line 311... Line 311...
311 
			'	LEFT JOIN cel_obs AS co '.
 311 
			'	LEFT JOIN cel_obs AS co '.
312 
			'		ON (coi.id_observation = co.id_observation) '.
 312 
			'		ON (coi.id_observation = co.id_observation) '.
313 
			$this->formerRequeteConditions($numNomListe).' '.
 313 
			$this->formerRequeteConditions($numNomListe).' '.
314 
			'GROUP BY id_img '.
 314 
			'GROUP BY id_img '.
315 
			$this->formerRequeteTri().
 315 
			$this->formerRequeteTri().
316 
			"LIMIT $depart,$limite ";
 316 
			"LIMIT $depart,$limite " . ' -- ' . __FILE__ . ':' . __LINE__;
Line 317... Line 317...
317 
 
 317 
 
318 
		$this->infosImages = $this->Bdd->recupererTous($requete);
 318 
		$this->infosImages = $this->Bdd->recupererTous($requete);
Line 319... Line 319...
319 
	}
 319 
	}