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