Subversion Repositories Applications.referentiel

Rev

Rev 344 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 344 Rev 372
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
		}