Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 1765 Rev 1766
Line 427... Line 427...
427 
		return $date_formatee;
 427 
		return $date_formatee;
428 
	}
 428 
	}
Line 429... Line 429...
429 
 
 429 
 
430 
	static function getImages_preload($cel, $obsids) {
 430 
	static function getImages_preload($cel, $obsids) {
431 
		if(!$obsids) return;
 431 
		if(!$obsids) return;
432 
		$rec = $cel->requeter(
 432 
		$rec = Cel::db()->requeter(
433 
			sprintf("SELECT o.id_observation, GROUP_CONCAT(nom_original ORDER BY nom_original ASC SEPARATOR '%s') AS i " .
 433 
			sprintf("SELECT o.id_observation, GROUP_CONCAT(nom_original ORDER BY nom_original ASC SEPARATOR '%s') AS i " .
434 
					"FROM cel_images i LEFT JOIN cel_obs_images oi ON (i.id_image = oi.id_image) LEFT JOIN cel_obs o ON (oi.id_observation = o.id_observation) " .
 434 
					"FROM cel_images i LEFT JOIN cel_obs_images oi ON (i.id_image = oi.id_image) LEFT JOIN cel_obs o ON (oi.id_observation = o.id_observation) " .
435 
					"WHERE o.ce_utilisateur = %d AND o.id_observation IN (%s) " .
 435 
					"WHERE o.ce_utilisateur = %d AND o.id_observation IN (%s) " .
436 
					"GROUP BY id_observation",
 436 
					"GROUP BY id_observation",