Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1307 Rev 1309
Line 278... Line 278...
278 
				'	INNER JOIN del_observation AS do '.
 278 
				'	INNER JOIN del_observation AS do '.
279 
				'			ON doi.id_observation = do.id_observation '.
 279 
				'			ON doi.id_observation = do.id_observation '.
280 
				'	LEFT JOIN del_utilisateur AS duo '.
 280 
				'	LEFT JOIN del_utilisateur AS duo '.
281 
				'		ON do.ce_utilisateur = duo.id_utilisateur '.
 281 
				'		ON do.ce_utilisateur = duo.id_utilisateur '.
282 
				'	LEFT JOIN del_utilisateur AS du '.
 282 
				'	LEFT JOIN del_utilisateur AS du '.
283 
				'		ON CAST(dit.ce_utilisateur AS UNSIGNED) = du.id_utilisateur '.
 283 
				'		ON if((CHAR_LENGTH(dit.ce_utilisateur) <> 32),CAST(dit.ce_utilisateur AS unsigned),0) '.
- 
 
 284 
				'			= du.id_utilisateur '.
284 
				'WHERE actif = 1 '.
 285 
				'WHERE actif = 1 '.
285 
				$this->chargerClauseWhere().' '.
 286 
				$this->chargerClauseWhere().' '.
286 
				'ORDER BY date DESC '.
 287 
				'ORDER BY date DESC '.
287 
				'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite();
 288 
				'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite();
288 
		$elements = $this->gestionBdd->getBdd()->recupererTous($requete);
 289 
		$elements = $this->gestionBdd->getBdd()->recupererTous($requete);