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; |
} |
} |