| 213,7 → 213,7 |
|---|
| 'ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby : 'date_modification DESC').' '. |
| "LIMIT $this->start,$this->limit "; |
| |
| $elements = Cel::db()->executerRequete($requete); |
| $elements = Cel::db()->requeter($requete); |
| |
| // Création du contenu |
| $contenu = $this->executerService($elements); |
| 260,7 → 260,7 |
|---|
| $contenu = ''; |
| if (isset($_GET['debut'])) $this->start = $_GET['debut']; |
| if (isset($_GET['limite'])) $this->limit = $_GET['limite']; |
| |
| |
| $this->limit = ($this->limit < 1000) ? $this->limit : 1000;// Pour éviter les abus ! |
| |
| // Construction de la requête |
| 281,9 → 281,9 |
|---|
| $requete .= ' ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby : |
| 'date_modification DESC, zone_geo ASC').' '. |
| "LIMIT $this->start,$this->limit "; |
| |
| $elements = Cel::db()->executerRequete($requete); |
| |
| $elements = Cel::db()->requeter($requete); |
| |
| // Création du contenu |
| if ($elements != false && count($elements) > 0) { |
| $contenu = $this->executerService($elements); |
| 348,7 → 348,7 |
|---|
| } |
| return $requete; |
| } |
| |
| |
| private function creerSousRequeteTags($tag) { |
| $requete = '(id_observation IN (SELECT id_observation FROM cel_obs_images coi INNER JOIN cel_images ci ON coi.id_image = ci.id_image WHERE '; |
| $where = ''; |
| 537,13 → 537,13 |
|---|
| $description = $this->nettoyerTexte($description); |
| return $description; |
| } |
| |
| |
| private function creerDescriptionChampsEtendus($obs, $item) { |
| $champs_etendus = ''; |
| foreach($obs['obs_etendue'] as $cle => &$champ) { |
| $champs_etendus .= '<li>'.$champ->label.' : '.$champ->valeur.' </li>'; |
| } |
| |
| |
| if($champs_etendus != '') { |
| $champs_etendus = '<li> Champs supplémentaires : <ul>'.$champs_etendus.'</ul></li>'; |
| } |
| 572,14 → 572,14 |
|---|
| } |
| return $url_service; |
| } |
| |
| private function getIntituleAuteur($courriel) { |
| |
| private function getIntituleAuteur($courriel) { |
| $courriel = strtolower($courriel); |
| if(isset($this->auteurs[$courriel])) { |
| if(isset($this->auteurs[$courriel])) { |
| $intitule = $this->auteurs[$courriel]; |
| } else { |
| $intitule = $courriel; |
| } |
| return $intitule; |
| } |
| return $intitule; |
| } |
| } |