| 100,9 → 100,11 |
|---|
| 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 = isset($this->parametres['navigation.limite']) ? intval($this->parametres['navigation.limite']) : 10; |
| $limite = @min(intval($this->parametres['navigation.limite']), 1000); |
| $limite = $limite ?: 100; // 0 => 10 |
| $depart = intval(@$this->parametres['navigation.depart']); |
| $ordre = $this->parametres['ordre']; |
| |
| $date_debut = "'{$date_debut}'"; |
| $date_fin = "'{$date_fin}'"; |
| |
| 126,10 → 128,11 |
|---|
| ' ON (p.id_observation = c.ce_observation) '. |
| ' LEFT JOIN del_commentaire_vote AS cv '. |
| ' ON (c.id_commentaire = cv.ce_proposition) '. |
| 'GROUP BY p.id_image, p.id_observation '. |
| 'GROUP BY 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 |
| } |
| 223,7 → 226,7 |
|---|
| if (!isset($obs[$idobs]['images'])) { |
| $obs[$idobs]['images'] = array(); |
| } |
| |
| //print_r($ids); |
| $img_obj = array( |
| 'id_image' => $idimg, |
| 'nom_image' => $imgdata['nom_image'], |