8,7 → 8,7 |
* @license http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL |
* @license GPL v3 <http://www.gnu.org/licenses/gpl.txt> |
*/ |
define('SEPARATEUR_IMAGES', ","); |
define('SEPARATEUR_IMAGES', " / "); |
|
Class FormateurGroupeColonne { |
|
427,10 → 427,29 |
return $date_formatee; |
} |
|
static function getImages_preload($cel, $obsids) { |
if(!$obsids) return; |
$rec = $cel->requeter( |
sprintf("SELECT o.id_observation, GROUP_CONCAT(nom_original ORDER BY nom_original ASC SEPARATOR '%s') AS i " . |
"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) " . |
"WHERE o.ce_utilisateur = %d AND o.id_observation IN (%s) " . |
"GROUP BY id_observation", |
SEPARATEUR_IMAGES, |
$cel->id_utilisateur, |
implode(',', $obsids))); |
foreach($rec as $v) { |
self::$cache['getImages'][$v['id_observation']] = $v['i']; |
} |
return NULL; |
} |
|
static function getImages($obs, $id_utilisateur, $cel) { |
if(! $id_utilisateur) return NULL; |
if(isset(self::$cache['getImages'][$obs['id_observation']])) |
return self::$cache['getImages'][$obs['id_observation']]; |
|
$rec = $cel->requeter( |
sprintf("SELECT GROUP_CONCAT(nom_original SEPARATOR '%s') AS i FROM cel_images i" |
sprintf("SELECT GROUP_CONCAT(nom_original ORDER BY nom_original ASC SEPARATOR '%s') AS i 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)" |
." WHERE o.ce_utilisateur = %d AND o.id_observation = %d LIMIT 1", |