100,11 → 100,9 |
private function getIdsObsImg() { |
$date_debut = date('Y-m-d H:i:s', $this->parametres['date.debut']); |
$date_fin = date('Y-m-d H:i:s', $this->parametres['date.fin']); |
$limite = @min(intval($this->parametres['navigation.limite']), 1000); |
$limite = $limite ?: 100; // 0 => 10 |
$limite = isset($this->parametres['navigation.limite']) ? intval($this->parametres['navigation.limite']) : 10; |
$depart = intval(@$this->parametres['navigation.depart']); |
$ordre = $this->parametres['ordre']; |
|
$date_debut = "'{$date_debut}'"; |
$date_fin = "'{$date_fin}'"; |
|
128,11 → 126,10 |
' ON (p.id_observation = c.ce_observation) '. |
' LEFT JOIN del_commentaire_vote AS cv '. |
' ON (c.id_commentaire = cv.ce_proposition) '. |
'GROUP BY id_image, p.id_observation '. |
'GROUP BY p.id_image, p.id_observation '. |
'ORDER BY modif_date ' . $ordre . ' '. |
'LIMIT '.$depart.', '.$limite. |
' -- '.__FILE__.':'.__LINE__; |
|
return $this->bdd->recupererTous($requete); |
// On récupère id_obs, id_image, votes, tags, modif_date |
} |
226,7 → 223,7 |
if (!isset($obs[$idobs]['images'])) { |
$obs[$idobs]['images'] = array(); |
} |
//print_r($ids); |
|
$img_obj = array( |
'id_image' => $idimg, |
'nom_image' => $imgdata['nom_image'], |