| 1,4 → 1,5 |
|---|
| <?php |
| |
| class Dictionnaire extends RestService { |
| |
| //+----------------------------------------------------------------------------------------------------------------+ |
| 17,14 → 18,6 |
|---|
| $retour = $this->getMots(); |
| break; |
| |
| case 'zglossary': |
| $retour = $this->getMotsZglossary(); |
| break; |
| |
| case 'autoabbr': |
| $retour = $this->getMotsAutoAbbr(); |
| break; |
| |
| case 'def': |
| if(isset($ressources[1])) { |
| $retour = $this->getDefinition($ressources[1]); |
| 48,7 → 41,7 |
|---|
| $entete_http = RestServeur::HTTP_CODE_CONTENU_REQUIS; |
| } |
| |
| RestServeur::envoyerEnteteStatutHttp($entete_http); |
| //RestServeur::envoyerEnteteStatutHttp($entete_http); |
| header('Content-type: application/json; charset=UTF-8'); |
| echo $corps_http; |
| exit; |
| 55,7 → 48,8 |
|---|
| } |
| |
| private function getDefinition($mot) { |
| $requete_selection_definition = 'SELECT valeur FROM definitions WHERE cle = "'. self::simplifier($mot).'"'; |
| |
| $requete_selection_definition = 'SELECT valeur FROM onto_triples WHERE cle = "'.$this->simplifier($mot).'"'; |
| $definition = $this->bdd->recuperer($requete_selection_definition); |
| |
| return $definition; |
| 62,38 → 56,36 |
|---|
| } |
| |
| private function getToutesDefinitions() { |
| return $this->bdd->recupererTous('SELECT valeur FROM definitions'); |
| |
| $requete_selection_toutes_definitions = 'SELECT valeur FROM onto_triples'; |
| |
| $definitions = $this->bdd->recupererTous($requete_selection_toutes_definitions); |
| |
| return $definitions; |
| } |
| |
| private function getMots() { |
| $requete = 'SELECT TRIM(cle) as cle FROM definitions'; // certaines cles ont des espaces |
| $assoc = $this->bdd->recupererTous($requete); |
| |
| array_walk($assoc, array($this,"formaterTableauDefinitions")); |
| return $assoc; |
| } |
| $requete_selection_mots = 'SELECT cle FROM onto_triples'; |
| |
| private function formaterTableauDefinitions(&$item) { |
| $item = $item['cle']; |
| } |
| $mots = $this->bdd->recupererTous($requete_selection_mots); |
| |
| private function getMotsZglossary() { |
| $assoc = $this->bdd->recupererTous('SELECT cle as term, 0 as type, valeur as definition FROM definitions' . |
| ' WHERE valeur != ""'); |
| return $assoc; |
| |
| foreach($mots as &$mot) { |
| $mot['cle'] = $mot['cle']; |
| } |
| |
| private function getMotsAutoAbbr() { |
| $assoc = $this->bdd->recupererTous("SELECT CONCAT(cle, '*') as cle FROM definitions WHERE valeur != ''"); |
| $assoc2 = Array(); |
| foreach($assoc as $v) { |
| $assoc2[$v['cle']] = true; |
| return $mots; |
| } |
| return $assoc2; |
| } |
| |
| static function simplifier($chaine){ |
| return trim(strtolower(iconv('UTF-8', 'ASCII//TRANSLIT', $chaine)), " \t\n\r\0\x0b*"); |
| function simplifier($chaine){ |
| |
| $sans_accent = strtr($chaine,'àáâãäçèéêëìíîïñòóôõöùúûüýÿÀÁÂÃÄÇÈÉÊËÌÍÎÏÑÒÓÔÕÖÙÚÛÜÝ', |
| 'aaaaaceeeeiiiinooooouuuuyyAAAAACEEEEIIIINOOOOOUUUUY'); |
| |
| $en_minuscule = strtolower($sans_accent); |
| |
| return $en_minuscule; |
| } |
| } |
| ?> |
| ?> |