Subversion Repositories eFlore/Projets.eflore-projets

Rev

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

Rev 538 Rev 539
Line 12... Line 12...
12 
* @license CECILL v2 <http://www.cecill.info/licences/Licence_CeCILL_V2-en.txt>
 12 
* @license CECILL v2 <http://www.cecill.info/licences/Licence_CeCILL_V2-en.txt>
13 
* @version 1.0
 13 
* @version 1.0
14 
* @copyright 1999-2011 Tela Botanica (accueil@tela-botanica.org)
 14 
* @copyright 1999-2011 Tela Botanica (accueil@tela-botanica.org)
15 
*/
 15 
*/
16 
// TODO : Config et Outils sont des classes statiques qui doivent poser des pb pour les tests...
 16 
// TODO : Config et Outils sont des classes statiques qui doivent poser des pb pour les tests...
17 
class Images {
 17 
class Images extends Commun {
Line 18... Line 18...
18 
 
 18 
 
19 
	private $parametres = array();
 19 
	protected $parametres = array();
20 
	private $ressources = array();
 20 
	protected $ressources = array();
Line 21... Line 21...
21 
	private $Bdd;
 21 
	private $Bdd;
22 
 
 22 
 
23 
	const CODE_REFTAX_DEFAUT = 'bdtfx';
 23 
	const CODE_REFTAX_DEFAUT = 'bdtfx';
Line 271... Line 271...
271 
 
 271 
 
272 
	private function chargerInfosImage() {
 272 
	private function chargerInfosImage() {
273 
		$requete = 	'SELECT SQL_CALC_FOUND_ROWS '.
 273 
		$requete = 	'SELECT SQL_CALC_FOUND_ROWS '.
274 
				'	ci.id_image AS id_img, ci.date_creation AS date, '.
 274 
				'	ci.id_image AS id_img, ci.date_creation AS date, '.
275 
				'	co.id_observation AS id_obs, '.
 275 
				'	co.id_observation AS id_obs, '.
276 
				'	courriel_utilisateur AS utilisateur_courriel, '.
 276 
				'	ci.courriel_utilisateur AS utilisateur_courriel, '.
277 
				'	nom_sel, nom_sel_nn, '.
 277 
				'	nom_sel, nom_sel_nn, '.
278 
				'	zone_geo, ce_zone_geo, lieudit, station, milieu '.
 278 
				'	zone_geo, ce_zone_geo, lieudit, station, milieu '.
279 
				'FROM cel_images AS ci'.
 279 
				'FROM cel_images AS ci'.
280 
				'	LEFT JOIN cel_obs_images AS coi  '.
 280 
				'	LEFT JOIN cel_obs_images AS coi  '.
281 
				'		ON (coi.id_image = ci.ci_id_image) '.
 281 
				'		ON (coi.id_image = ci.id_image) '.
282 
				'	LEFT JOIN cel_obs AS co '.
 282 
				'	LEFT JOIN cel_obs AS co '.
283 
				'		ON (coi.id_observation = co.id_observation) '.
 283 
				'		ON (coi.id_observation = co.id_observation) '.
Line 284... Line 284...
284 
				'WHERE ci.id_image = '.$this->ressources[0];
 284 
				'WHERE ci.id_image = '.$this->ressources[0];