| Line 157... |
Line 157... |
| 157 |
$liste_nom = $this->getNomRetenu($param);
|
157 |
$liste_nom = $this->getNomRetenu($param);
|
| 158 |
if ($liste_nom != '') {
|
158 |
if ($liste_nom != '') {
|
| 159 |
// Construction de la requête
|
159 |
// Construction de la requête
|
| 160 |
// si recherche des synonymes
|
160 |
// si recherche des synonymes
|
| 161 |
$requete = (($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' num_nom, nom_sci, auteur, annee, '.
|
161 |
$requete = (($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' num_nom, nom_sci, auteur, annee, '.
|
| 162 |
'biblio_origine, nom_addendum, num_nom_retenu, '.(($referentiel == "bdtfx" || $referentiel == "bdtre") ? 'num_basionyme' :
|
162 |
'biblio_origine, nom_addendum, num_nom_retenu, num_basionyme, synonyme_mal_applique, presence, exclure_taxref '.
|
| 163 |
'basionyme').', synonyme_mal_applique, presence, exclure_taxref '.
|
- |
|
| 164 |
' FROM '.$referentiel.' WHERE num_nom_retenu IN ('.$liste_nom.') '.
|
163 |
' FROM '.$referentiel.' WHERE num_nom_retenu IN ('.$liste_nom.') '.
|
| 165 |
'ORDER BY nom_sci ASC ';
|
164 |
'ORDER BY nom_sci ASC ';
|
| 166 |
try {
|
165 |
try {
|
| 167 |
$donnees = $this->bdd->query($requete)->fetchAll(PDO::FETCH_ASSOC);
|
166 |
$donnees = $this->bdd->query($requete)->fetchAll(PDO::FETCH_ASSOC);
|
| 168 |
$info = $donnees;
|
167 |
$info = $donnees;
|
| Line 582... |
Line 581... |
| 582 |
" OR hybride_parent_02_notes LIKE {$p['mots']} ".
|
581 |
" OR hybride_parent_02_notes LIKE {$p['mots']} ".
|
| 583 |
" OR nom_francais LIKE {$p['mots']} ".
|
582 |
" OR nom_francais LIKE {$p['mots']} ".
|
| 584 |
" OR presence LIKE {$p['mots']} ".
|
583 |
" OR presence LIKE {$p['mots']} ".
|
| 585 |
" OR statut_origine LIKE {$p['mots']} ".
|
584 |
" OR statut_origine LIKE {$p['mots']} ".
|
| 586 |
" OR statut_introduction LIKE {$p['mots']} ".
|
585 |
" OR statut_introduction LIKE {$p['mots']} ".
|
| 587 |
" OR statut_culture LIKE {$p['mots']} ";
|
586 |
" OR statut_culture LIKE {$p['mots']} ".
|
| 588 |
$where .= ($referentiel == "bdtfx") ? " OR num_basionyme LIKE {$p['mots']}) " : " OR basionyme LIKE {$p['mots']}) ";
|
587 |
" OR num_basionyme LIKE {$p['mots']}) ";
|
| 589 |
}
|
588 |
}
|
| 590 |
}
|
589 |
}
|
| 591 |
if (isset($p['sg'])) {
|
590 |
if (isset($p['sg'])) {
|
| 592 |
$where .= "AND nom_supra_generique LIKE {$p['sg']} ";
|
591 |
$where .= "AND nom_supra_generique LIKE {$p['sg']} ";
|
| 593 |
}
|
592 |
}
|