1,10 → 1,6 |
<?php |
class Dictionnaire extends RestService { |
|
// SELECT a.id, a.cle, b.id, b.cle FROM definitions a, definitions b WHERE a.id != b.id AND INSTR(b.cle, a.cle) != 0 order by a.cle; |
// SELECT group_concat( distinct a.id) FROM definitions a, definitions b WHERE a.id != b.id AND INSTR(b.cle, a.cle) != 0 |
static $sous_mots = array(20,22,33,37,65,103,106,151,160,164,177,202,220,222,230,249,250,257,262,276,284,307,334,352,359,394,397,401,422,437,438,449,452,453,463,469,475,498,517,527,547,549,550,585,603,604,606,607,638,641,660); |
|
//+----------------------------------------------------------------------------------------------------------------+ |
// Consulter |
public function consulter($ressources, $parametres) { |
22,11 → 18,11 |
break; |
|
case 'zglossary': |
$retour = $this->getMots_zglossary(); |
$retour = $this->getMotsZglossary(); |
break; |
|
case 'autoabbr': |
$retour = $this->getMots_autoabbr(); |
$retour = $this->getMotsAutoAbbr(); |
break; |
|
case 'def': |
71,12 → 67,6 |
|
|
private function getMots() { |
/* |
$requete = sprintf('SELECT cle FROM definitions WHERE id NOT IN (%s) ORDER BY LENGTH(cle) DESC', |
implode(",", self::$sous_mots)); |
$requete = sprintf('SELECT cle FROM definitions WHERE id NOT IN (%s)', |
implode(",", self::$sous_mots)); |
*/ |
$requete = 'SELECT TRIM(cle) as cle FROM definitions'; // certaines cles ont des espaces |
$assoc = $this->bdd->recupererTous($requete); |
|
84,13 → 74,13 |
return $assoc; |
} |
|
private function getMots_zglossary() { |
private function getMotsZglossary() { |
$assoc = $this->bdd->recupererTous('SELECT cle as term, 0 as type, valeur as definition FROM definitions' . |
' WHERE valeur != ""'); |
return $assoc; |
} |
|
private function getMots_autoabbr() { |
private function getMotsAutoAbbr() { |
$assoc = $this->bdd->recupererTous("SELECT CONCAT(cle, '*') as cle FROM definitions WHERE valeur != ''"); |
$assoc2 = Array(); |
foreach($assoc as $v) { |