Subversion Repositories eFlore/Applications.del

Rev

Rev 1684 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1684 Rev 1793
Line 16... Line 16...
16 
class ListeObservationsWidget {
 16 
class ListeObservationsWidget {
Line 17... Line 17...
17 
 
 17 
 
18 
	private $conteneur;
 18 
	private $conteneur;
19 
	private $navigation;
 19 
	private $navigation;
20 
	private $masque;
 - 
 
21 
	private $gestionBdd;
 20 
	private $masque;
22 
	private $bdd;
 21 
	private $bdd;
23 
	private $parametres = array();
 22 
	private $parametres = array();
24 
	private $ressources = array();
 23 
	private $ressources = array();
25 
	private $tri = 'date_transmission';
 24 
	private $tri = 'date_transmission';
Line 29... Line 28...
29 
		$this->conteneur = $conteneur == null ? new Conteneur() : $conteneur;
 28 
		$this->conteneur = $conteneur == null ? new Conteneur() : $conteneur;
30 
		$this->conteneur->chargerConfiguration('config_observations.ini');
 29 
		$this->conteneur->chargerConfiguration('config_observations.ini');
31 
		$this->conteneur->chargerConfiguration('config_departements_bruts.ini');
 30 
		$this->conteneur->chargerConfiguration('config_departements_bruts.ini');
32 
		$this->navigation = $conteneur->getNavigation();
 31 
		$this->navigation = $conteneur->getNavigation();
33 
		$this->masque = $conteneur->getMasque();
 32 
		$this->masque = $conteneur->getMasque();
34 
		$this->gestionBdd = $conteneur->getGestionBdd();
 - 
 
35 
		$this->bdd = $this->gestionBdd->getBdd();
 33 
		$this->bdd = $this->conteneur->getBdd();
36 
	}
 34 
	}
Line 37... Line 35...
37 
 
 35 
 
38 
	/**
 36 
	/**
39 
	 * Méthode principale de la classe.
 37 
	 * Méthode principale de la classe.
Line 345... Line 343...
345 
		$requete = 'SELECT DISTINCT dob.id_observation '.
 343 
		$requete = 'SELECT DISTINCT dob.id_observation '.
346 
			'FROM del_observation AS dob '.
 344 
			'FROM del_observation AS dob '.
347 
			'	INNER JOIN del_obs_image AS doi ON doi.id_observation = dob.id_observation '.
 345 
			'	INNER JOIN del_obs_image AS doi ON doi.id_observation = dob.id_observation '.
348 
			$this->chargerClauseWhere().' '.
 346 
			$this->chargerClauseWhere().' '.
349 
			"ORDER BY {$this->tri} {$this->directionTri} ".
 347 
			"ORDER BY {$this->tri} {$this->directionTri} ".
350 
			$this->gestionBdd->getLimitSql();
 348 
			' LIMIT '.$this->navigation->getDepart().', '.$this->navigation->getLimite();
Line 351... Line 349...
351 
 
 349 
 
352 
		return $this->bdd->recupererTous($requete);
 350 
		return $this->bdd->recupererTous($requete);
Line 353... Line 351...
353 
	}
 351 
	}