| 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",
|