Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1307 Rev 1309
Line 268... Line 268...
268 
				'	INNER JOIN del_image_protocole AS dip '.
 268 
				'	INNER JOIN del_image_protocole AS dip '.
269 
				'		ON ce_protocole = id_protocole '.
 269 
				'		ON ce_protocole = id_protocole '.
270 
				'	LEFT JOIN del_utilisateur AS duo '.
 270 
				'	LEFT JOIN del_utilisateur AS duo '.
271 
				'		ON do.ce_utilisateur = duo.id_utilisateur '.
 271 
				'		ON do.ce_utilisateur = duo.id_utilisateur '.
272 
				'	LEFT JOIN del_utilisateur AS duv '.
 272 
				'	LEFT JOIN del_utilisateur AS duv '.
273 
				'		ON CAST(divo.ce_utilisateur AS UNSIGNED) = duv.id_utilisateur '.
 273 
				'		ON if((CHAR_LENGTH(divo.ce_utilisateur) <> 32),CAST(divo.ce_utilisateur AS unsigned),0) '.
- 
 
 274 
				'			= duv.id_utilisateur '.
274 
				$this->chargerClauseWhere().' '.
 275 
				$this->chargerClauseWhere().' '.
275 
				'ORDER BY divo.date DESC '.
 276 
				'ORDER BY divo.date DESC '.
276 
				'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite();
 277 
				'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite();
Line 277... Line 278...
277 
 
 278