| 218,68 → 218,38 |
|---|
| } |
| |
| private function getServiceParMotsCles() { |
| $contenu = ''; |
| $mot_cle = $this->parametres[0]; |
| |
| if (isset($mot_cle)) { |
| $mot_cle_encode = $this->bdd->quote($this->encoderMotCle($mot_cle)); |
| |
| // Construction de la requête |
| $requete = 'SELECT * '. |
| 'FROM cel_mots_cles_obs '. |
| "WHERE cmc_id_mot_cle_general = $mot_cle_encode "; |
| $elements = $this->executerRequete($requete); |
| |
| if ($elements != false && count($elements) > 0) { |
| // Pré-construction du where de la requête |
| $tpl_where = '(mots_cles LIKE "%%%s%%" AND identifiant = %s )'; |
| $requete_where = array(); |
| foreach ($elements as $occurence) { |
| $requete_where[] = sprintf($tpl_where, $occurence['cmc_id_mot_cle_utilisateur'], $this->bdd->quote($occurence['cmc_id_proprietaire'])); |
| } |
| |
| // Construction de la requête |
| $requete = 'SELECT * '. |
| 'FROM cel_inventory '. |
| 'WHERE '.implode(" \nOR ", $requete_where).' '. |
| ' '.(($this->etreFluxAdmin()) ? '' : 'AND transmission = 1 '). |
| 'ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby : |
| 'date_modification, date_creation DESC').' '. |
| "LIMIT $this->start,$this->limit "; |
| $elements = $this->executerRequete($requete); |
| |
| // Création du contenu |
| $contenu = $this->executerService($elements); |
| } else { |
| $this->messages[] = "Aucune observation ne correspond à ce mot clé."; |
| } |
| $infos=array(); |
| $infos[0]['num_nom_sel'] = ''; |
| $infos[0]['date_modification'] = '2011-06-28'; |
| $donnees = $this->construireDonneesCommunesAuFlux($infos); |
| $donnees['items'][0]['guid'] = 0; |
| $donnees['items'][0]['description'] = 'Ce flux est devenu obsolète. Veuillez utiliser le flux '. |
| '<b>http://www.tela-botanica.org/eflore/cel2/jrest/CelSyndicationObservation/multicriteres/atom?projet='; |
| if (isset($this->parametres[0])) { |
| $donnees['items'][0]['description'] .= $this->parametres[0].'</b>'; |
| } else { |
| $this->messages[] = "Le service demandé nécessite d'indiquer un mot-clé en dernier paramêtre."; |
| $donnees['items'][0]['description'] .= '</b>'; |
| } |
| $donnees['items'][0]['titre'] = ''; |
| $contenu = Cel::traiterSquelettePhp($this->squelette, $donnees); |
| return $contenu; |
| } |
| |
| private function getServiceParCommune() { |
| $contenu = ''; |
| $commune = $this->parametres[0]; |
| if (isset($commune)) { |
| $commune = $this->bdd->quote($commune); |
| |
| // Construction de la requête |
| $requete = (isset($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' * '. |
| 'FROM cel_inventory '. |
| "WHERE location = $commune ". |
| ' '.(($this->etreFluxAdmin()) ? '' : 'AND transmission = 1 '). |
| 'ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby : 'date_modification DESC, location ASC').' '. |
| "LIMIT $this->start,$this->limit "; |
| |
| $elements = $this->executerRequete($requete); |
| |
| // Création du contenu |
| $contenu = $this->executerService($elements); |
| $infos=array(); |
| $infos[0]['num_nom_sel'] = ''; |
| $infos[0]['date_modification'] = '2011-06-28'; |
| $donnees = $this->construireDonneesCommunesAuFlux($infos); |
| $donnees['items'][0]['guid'] = 0; |
| $donnees['items'][0]['description'] = 'Ce flux est devenu obsolète. Veuillez utiliser le flux '. |
| '<b>http://www.tela-botanica.org/eflore/cel2/jrest/CelSyndicationObservation/multicriteres/atom?commune='; |
| if (isset($this->parametres[0])) { |
| $donnees['items'][0]['description'] .= $this->parametres[0].'</b>'; |
| } else { |
| $this->messages[] = "Le service demandé nécessite d'indiquer une nom de commune en dernier paramêtre."; |
| $donnees['items'][0]['description'] .= '</b>'; |
| } |
| $donnees['items'][0]['titre'] = ''; |
| $contenu = Cel::traiterSquelettePhp($this->squelette, $donnees); |
| return $contenu; |
| } |
| |