Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1233 Rev 1246
Line 110... Line 110...
110 
		$requete =  'SELECT DISTINCT id_vote, prenom, nom, nom_sel, intitule, ce_image,  valeur, dob.id_observation as del_obs, divo.date as date_vote '.
 110 
		$requete =  'SELECT DISTINCT id_vote, prenom, nom, nom_sel, intitule, ce_image,  valeur, dob.id_observation as del_obs, divo.date as date_vote '.
111 
					' FROM `del_image_vote` divo '.
 111 
					' FROM `del_image_vote` divo '.
112 
					' INNER JOIN del_obs_image doi ON divo.ce_image = doi.id_image '.
 112 
					' INNER JOIN del_obs_image doi ON divo.ce_image = doi.id_image '.
113 
					' INNER JOIN del_observation dob ON dob.id_observation = doi.id_observation '.
 113 
					' INNER JOIN del_observation dob ON dob.id_observation = doi.id_observation '.
114 
					' INNER JOIN del_image_protocole ON ce_protocole = id_protocole '.
 114 
					' INNER JOIN del_image_protocole ON ce_protocole = id_protocole '.
115 
					' INNER JOIN del_utilisateur ON dob.ce_utilisateur = id_utilisateur '.
 115 
					' LEFT JOIN del_utilisateur ON dob.ce_utilisateur = id_utilisateur '.
116 
					$this->chargerClauseWhere()." ".
 116 
					$this->chargerClauseWhere()." ".
117 
					' ORDER BY divo.date DESC '.
 117 
					' ORDER BY divo.date DESC '.
118 
					' LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite();
 118 
					' LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite();
119 
		$elements = $this->gestionBdd->getBdd()->recupererTous($requete);
 119 
		$elements = $this->gestionBdd->getBdd()->recupererTous($requete);
120 
		return $elements;
 120 
		return $elements;