190 |
jpm |
1 |
<?php
|
|
|
2 |
class TaxonsListe {
|
|
|
3 |
|
|
|
4 |
private $parametres = null;
|
|
|
5 |
private $ressources = null;
|
|
|
6 |
private $bdd = null;
|
|
|
7 |
|
|
|
8 |
private $nbreTotalNoms = 0;
|
|
|
9 |
private $noms = array();
|
|
|
10 |
|
|
|
11 |
public function __construct(Ressources $ressources, Parametres $parametres, Bdd $bdd) {
|
|
|
12 |
$this->ressources = $ressources;
|
|
|
13 |
$this->parametres = $parametres;
|
|
|
14 |
$this->bdd = $bdd;
|
|
|
15 |
}
|
|
|
16 |
|
|
|
17 |
public function consulter() {
|
|
|
18 |
$this->noms = $this->rechercher();
|
|
|
19 |
$this->nbreNomsTotal = $this->recupererNombreNomsTotal();
|
|
|
20 |
$this->trierNoms();
|
|
|
21 |
$retour = $this->construireTableauRetour();
|
|
|
22 |
return $retour;
|
|
|
23 |
}
|
|
|
24 |
|
|
|
25 |
private function rechercher() {
|
|
|
26 |
$resultats = array();
|
|
|
27 |
$recherche = $this->parametres->get('recherche');
|
|
|
28 |
|
|
|
29 |
if ($recherche == 'stricte') {
|
|
|
30 |
$resultats = $this->rechercherStricte();
|
|
|
31 |
} else if ($recherche == 'etendue') {
|
|
|
32 |
$resultats = $this->rechercherEtendue();
|
|
|
33 |
} else if ($recherche == 'floue') {
|
|
|
34 |
$resultats = $this->rechercherFloue();
|
|
|
35 |
}
|
|
|
36 |
|
|
|
37 |
return $resultats;
|
|
|
38 |
}
|
|
|
39 |
|
|
|
40 |
private function rechercherStricte() {
|
|
|
41 |
$conditions = array();
|
|
|
42 |
if ($masque = $this->parametres->getMasquePourBdd()) {
|
|
|
43 |
$conditions[] = "nom_sci = $masque";
|
|
|
44 |
}
|
|
|
45 |
if ($masqueSg = $this->parametres->getMasquePourBdd('sg')) {
|
|
|
46 |
$conditions[] = "nom_supra_generique = $masqueSg";
|
|
|
47 |
}
|
|
|
48 |
if ($masqueGen = $this->parametres->getMasquePourBdd('gen')) {
|
|
|
49 |
$conditions[] = "genre = $masqueGen";
|
|
|
50 |
}
|
|
|
51 |
if ($masqueSp = $this->parametres->getMasquePourBdd('sp')) {
|
|
|
52 |
$conditions[] = "epithete_sp = $masqueSp";
|
|
|
53 |
}
|
|
|
54 |
$requete = 'SELECT SQL_CALC_FOUND_ROWS '.
|
|
|
55 |
' num_nom, nom_sci '.
|
|
|
56 |
'FROM fournier_v1_00 '.
|
|
|
57 |
'WHERE num_nom = num_nom_retenu '.
|
|
|
58 |
implode(' AND ', $conditions).
|
|
|
59 |
'ORDER BY nom_sci ASC '.
|
|
|
60 |
'LIMIT 0,100';
|
|
|
61 |
$resultats = $this->bdd->recupererTous($requete);
|
|
|
62 |
|
|
|
63 |
return $resultats;
|
|
|
64 |
}
|
|
|
65 |
|
|
|
66 |
private function rechercherEtendue() {
|
|
|
67 |
$conditions = array();
|
|
|
68 |
if ($masque = $this->parametres->getMasquePourBdd()) {
|
|
|
69 |
$conditions[] = "nom_sci LIKE $masque";
|
|
|
70 |
}
|
|
|
71 |
if ($masqueSg = $this->parametres->getMasquePourBdd('sg')) {
|
|
|
72 |
$conditions[] = "nom_supra_generique LIKE $masqueSg";
|
|
|
73 |
}
|
|
|
74 |
if ($masqueGen = $this->parametres->getMasquePourBdd('gen')) {
|
|
|
75 |
$conditions[] = "genre LIKE $masqueGen";
|
|
|
76 |
}
|
|
|
77 |
if ($masqueSp = $this->parametres->getMasquePourBdd('sp')) {
|
|
|
78 |
$conditions[] = "epithete_sp LIKE $masqueSp";
|
|
|
79 |
}
|
|
|
80 |
$requete = 'SELECT SQL_CALC_FOUND_ROWS '.
|
|
|
81 |
' num_nom, nom_sci, num_nom_retenu '.
|
|
|
82 |
'FROM fournier_v1_00 '.
|
|
|
83 |
'WHERE num_nom = num_nom_retenu '.
|
|
|
84 |
implode(' AND ', $conditions).
|
|
|
85 |
'ORDER BY nom_sci ASC '.
|
|
|
86 |
'LIMIT 0,100';
|
|
|
87 |
|
|
|
88 |
$resultats = $this->bdd->recupererTous($requete);
|
|
|
89 |
return $resultats;
|
|
|
90 |
}
|
|
|
91 |
|
|
|
92 |
private function rechercherFloue() {
|
|
|
93 |
$masque = $this->parametres->getMasquePourBdd();
|
|
|
94 |
$requete = 'SELECT SQL_CALC_FOUND_ROWS '.
|
|
|
95 |
' num_nom, nom_sci, num_nom_retenu '.
|
|
|
96 |
'FROM fournier_v1_00 '.
|
|
|
97 |
'WHERE num_nom = num_nom_retenu '.
|
|
|
98 |
($masque ? 'AND '.
|
|
|
99 |
" (SOUNDEX(nom_sci) = SOUNDEX($masque)) ".
|
|
|
100 |
" OR (SOUNDEX(REVERSE(nom_sci)) = SOUNDEX(REVERSE($masque))) " : '').
|
|
|
101 |
'ORDER BY nom_sci ASC '.
|
|
|
102 |
'LIMIT 0,100';
|
|
|
103 |
$resultats = $this->bdd->recupererTous($requete);
|
|
|
104 |
return $resultats;
|
|
|
105 |
}
|
|
|
106 |
|
|
|
107 |
private function recupererNombreNomsTotal() {
|
|
|
108 |
$requete = 'SELECT FOUND_ROWS() AS nbre';
|
|
|
109 |
$nombre = $this->bdd->recuperer($requete);
|
|
|
110 |
return (int) $nombre['nbre'];
|
|
|
111 |
}
|
|
|
112 |
|
|
|
113 |
private function trierNoms() {
|
|
|
114 |
$recherche = $this->parametres->get('recherche');
|
|
|
115 |
if ($recherche == 'floue') {
|
|
|
116 |
$this->trierRechercheFloue();
|
|
|
117 |
}
|
|
|
118 |
}
|
|
|
119 |
|
|
|
120 |
public function trierRechercheFloue() {
|
|
|
121 |
$nomDemande = $this->parametres->get('masque');
|
|
|
122 |
$nomDemandeSimple = strtolower(Chaine::supprimerAccents($nomDemande));
|
|
|
123 |
|
|
|
124 |
foreach ($this->noms as $id => $nom) {
|
|
|
125 |
$nomFlouSimple = strtolower(Chaine::supprimerAccents($nom['nom_sci']));
|
|
|
126 |
// Prime pour la ressemblance globale :
|
|
|
127 |
$score = 500 - levenshtein($nomFlouSimple, $nomDemandeSimple);
|
|
|
128 |
// On affine
|
|
|
129 |
$score += similar_text($nomDemandeSimple, $nomFlouSimple) * 3;
|
|
|
130 |
$this->noms[$id]['score'] = $score;
|
|
|
131 |
}
|
|
|
132 |
$noms = $this->noms;
|
|
|
133 |
$this->noms = Tableau::trierMD($noms, array('score' => false));
|
|
|
134 |
//print_r($this->noms);
|
|
|
135 |
}
|
|
|
136 |
|
|
|
137 |
private function construireTableauRetour() {
|
|
|
138 |
$retour = array('entete' => array(), 'resultats' => array());
|
|
|
139 |
$retour['resultats'] = $this->construireResultats();
|
|
|
140 |
$retour['entete'] = $this->construireEntete();
|
|
|
141 |
return $retour;
|
|
|
142 |
}
|
|
|
143 |
|
|
|
144 |
private function construireResultats() {
|
|
|
145 |
$nomsFormates = array();
|
|
|
146 |
foreach ($this->noms as $nom) {
|
|
|
147 |
$id = $nom['num_nom'];
|
|
|
148 |
$nomsFormates[$id] = $this->formaterNom($nom);
|
|
|
149 |
}
|
|
|
150 |
return $nomsFormates;
|
|
|
151 |
}
|
|
|
152 |
|
|
|
153 |
private function formaterNom($nom) {
|
|
|
154 |
$nomFormate = array();
|
|
|
155 |
$nomformate['nom_sci'] = $nom['nom_sci'];
|
|
|
156 |
$nomformate['retenu'] = ($nom['num_nom'] == $nom['num_nom_retenu']) ? true : false;
|
|
|
157 |
$nomformate['href'] = $this->formaterHref($nom);
|
|
|
158 |
return $nomformate;
|
|
|
159 |
}
|
|
|
160 |
|
|
|
161 |
private function formaterHref($nom) {
|
|
|
162 |
$squelette = 'http://localhost/service:nel:0.1/fournier/taxons/%s';
|
|
|
163 |
$href = sprintf($squelette, $nom['num_nom_retenu']);
|
|
|
164 |
return $href;
|
|
|
165 |
}
|
|
|
166 |
|
|
|
167 |
private function construireEntete() {
|
|
|
168 |
$entete = array('masque' => '', 'depart' => 0, 'limite' => 100, 'total' => 0);
|
|
|
169 |
$entete['masque'] = $this->formaterEnteteMasque();
|
|
|
170 |
$entete['depart'] = (int) $this->parametres->get('navigation.depart');
|
|
|
171 |
$entete['limite'] = (int) $this->parametres->get('navigation.limite');
|
|
|
172 |
$entete['total'] = $this->nbreNomsTotal;
|
|
|
173 |
if ($hrefPrecedent = $this->formaterEnteteHrefPrecedent()) {
|
|
|
174 |
$entete['href.precedent'] = $hrefPrecedent;
|
|
|
175 |
}
|
|
|
176 |
if ($hrefSuivant = $this->formaterEnteteHrefSuivant()) {
|
|
|
177 |
$entete['href.suivant'] = $hrefSuivant;
|
|
|
178 |
}
|
|
|
179 |
return $entete;
|
|
|
180 |
}
|
|
|
181 |
|
|
|
182 |
private function formaterEnteteMasque() {
|
|
|
183 |
$masqueComplet = array();
|
|
|
184 |
if ($this->parametres->exister('masque')) {
|
|
|
185 |
$masque = '';
|
|
|
186 |
$masque .= 'nom_sci='.$this->parametres->get('masque');
|
|
|
187 |
if ($this->parametres->get('recherche') == 'etendue') {
|
|
|
188 |
$masque .= '%';
|
|
|
189 |
}
|
|
|
190 |
$masqueComplet[] = $masque;
|
|
|
191 |
}
|
|
|
192 |
if ($this->parametres->exister('masque.sg')) {
|
|
|
193 |
$masque = '';
|
|
|
194 |
$masque .= 'nom_supra_generique='.$this->parametres->get('masque.sg');
|
|
|
195 |
if ($this->parametres->get('recherche') == 'etendue') {
|
|
|
196 |
$masque .= '%';
|
|
|
197 |
}
|
|
|
198 |
$masqueComplet[] = $masque;
|
|
|
199 |
}
|
|
|
200 |
if ($this->parametres->exister('masque.gen')) {
|
|
|
201 |
$masque = '';
|
|
|
202 |
$masque .= 'genre='.$this->parametres->get('masque.gen');
|
|
|
203 |
if ($this->parametres->get('recherche') == 'etendue') {
|
|
|
204 |
$masque .= '%';
|
|
|
205 |
}
|
|
|
206 |
$masqueComplet[] = $masque;
|
|
|
207 |
}
|
|
|
208 |
if ($this->parametres->exister('masque.sp')) {
|
|
|
209 |
$masque = '';
|
|
|
210 |
$masque .= 'epithete_sp='.$this->parametres->get('masque.sp');
|
|
|
211 |
if ($this->parametres->get('recherche') == 'etendue') {
|
|
|
212 |
$masque .= '%';
|
|
|
213 |
}
|
|
|
214 |
$masqueComplet[] = $masque;
|
|
|
215 |
}
|
|
|
216 |
return implode('&', $masqueComplet);
|
|
|
217 |
}
|
|
|
218 |
|
|
|
219 |
private function formaterEnteteHrefPrecedent() {
|
|
|
220 |
$limite = $this->parametres->get('navigation.limite');
|
|
|
221 |
$departActuel = $this->parametres->get('navigation.depart');
|
|
|
222 |
$departPrecedent = $departActuel - $limite;
|
|
|
223 |
$href = null;
|
|
|
224 |
if ($departPrecedent >= 0) {
|
|
|
225 |
$squelette = 'http://localhost/service:nel:0.1/fournier/taxons?navigation.depart=%s&navigation.limite=%s';
|
|
|
226 |
$href = sprintf($squelette, $departPrecedent, $limite);
|
|
|
227 |
}
|
|
|
228 |
return $href;
|
|
|
229 |
}
|
|
|
230 |
|
|
|
231 |
private function formaterEnteteHrefSuivant() {
|
|
|
232 |
$limite = $this->parametres->get('navigation.limite');
|
|
|
233 |
$departActuel = $this->parametres->get('navigation.depart');
|
|
|
234 |
$departSuivant = $departActuel + $limite;
|
|
|
235 |
$href = null;
|
|
|
236 |
if ($departSuivant < $this->nbreNomsTotal) {
|
|
|
237 |
$squelette = 'http://localhost/service:nel:0.1/fournier/taxons?navigation.depart=%s&navigation.limite=%s';
|
|
|
238 |
$href = sprintf($squelette, $departSuivant, $limite);
|
|
|
239 |
}
|
|
|
240 |
return $href;
|
|
|
241 |
}
|
|
|
242 |
}
|
|
|
243 |
?>
|