| 48,9 → 48,9 |
|---|
| " , eflore_naturaliste_intitule_abreviation AS auteur_mex ". |
| " , eflore_naturaliste_intitule_abreviation AS auteur_m ". |
| " , eflore_selection_nom". |
| " WHERE en_id_version_projet_nom = '25' AND en_nom_genre LIKE ".$this->proteger($genre.'%'). |
| " WHERE en_id_version_projet_nom = '25' AND en_nom_genre LIKE ".Cel::db()->proteger($genre.'%'). |
| " AND en_ce_rang > 160 " . |
| " AND en_epithete_espece like ".$this->proteger($espece.'%')." AND en_ce_rang = enrg_id_rang " . |
| " AND en_epithete_espece like ".Cel::db()->proteger($espece.'%')." AND en_ce_rang = enrg_id_rang " . |
| " AND en_ce_auteur_basio_ex = auteur_bex.enaia_id_intitule_naturaliste_abrege ". |
| " AND en_ce_auteur_basio = auteur_b.enaia_id_intitule_naturaliste_abrege ". |
| " AND en_ce_auteur_modif_ex = auteur_mex.enaia_id_intitule_naturaliste_abrege ". |
| 68,13 → 68,13 |
|---|
| if ((strlen($genre) >= 1)) { |
| $requete_recherche = "SELECT DISTINCT en_nom_genre, en_id_nom, 0 as esn_ce_statut FROM eflore_nom WHERE en_id_version_projet_nom = '25'" . |
| "AND en_ce_rang = 160 " . |
| "AND en_nom_genre LIKE ".$this->proteger($genre.'%')." ORDER BY esn_ce_statut, en_nom_genre LIMIT 50"; |
| "AND en_nom_genre LIKE ".Cel::db()->proteger($genre.'%')." ORDER BY esn_ce_statut, en_nom_genre LIMIT 50"; |
| } |
| } |
| } |
| |
| if ($requete_recherche != '') { |
| $resultat_recherche = $this->executerRequete($requete_recherche); |
| $resultat_recherche = Cel::db()->executerRequete($requete_recherche); |
| |
| if (is_array($resultat_recherche)) { |
| foreach ($resultat_recherche as $ligne) { |
| 141,7 → 141,7 |
|---|
| " , eflore_naturaliste_intitule_abreviation AS auteur_mex ". |
| " , eflore_naturaliste_intitule_abreviation AS auteur_m ". |
| " ,eflore_selection_nom a, eflore_selection_nom b". |
| " WHERE a.esn_id_nom= ".$this->proteger($numNom). |
| " WHERE a.esn_id_nom= ".Cel::db()->proteger($numNom). |
| " AND a.esn_id_version_projet_taxon = 25 ". |
| " AND a.esn_id_taxon=b.esn_id_taxon ". |
| " AND b.esn_ce_statut=3 ". |
| 155,7 → 155,7 |
|---|
| " AND a.esn_id_version_projet_taxon=en_id_version_projet_nom "; |
| |
| |
| $resultat_infos_complementaires = $this->executerRequete($requete_infos_complementaires); |
| $resultat_infos_complementaires = Cel::db()->executerRequete($requete_infos_complementaires); |
| return $resultat_infos_complementaires; |
| } |
| |
| 184,7 → 184,7 |
|---|
| " AND en_ce_auteur_modif = auteur_m.enaia_id_intitule_naturaliste_abrege ". |
| " AND esn_id_version_projet_taxon=en_id_version_projet_nom "; |
| |
| $resultat_infos_complementaires = $this->executerRequete($requete_infos_complementaires); |
| $resultat_infos_complementaires = Cel::db()->executerRequete($requete_infos_complementaires); |
| |
| return $resultat_infos_complementaires; |
| } |
| 202,7 → 202,7 |
|---|
| 'eni_intitule_nom LIKE "'.$nom_saisi.'%" '. |
| 'ORDER BY LENGTH(eni_intitule_nom)'; |
| |
| $resultat_infos_comp_sur_nom = $this->executerRequete($requete_infos_comp_sur_nom); |
| $resultat_infos_comp_sur_nom = Cel::db()->executerRequete($requete_infos_comp_sur_nom); |
| |
| if (is_array($resultat_infos_comp_sur_nom)) { |
| foreach ($resultat_infos_comp_sur_nom as $ligne) { |
| 232,7 → 232,7 |
|---|
| " AND en_id_nom = esn_id_nom ". |
| " AND esn_id_version_projet_taxon=en_id_version_projet_nom "; |
| |
| $resultat_recherche_famille = $this->executerRequete($requete_famille); |
| $resultat_recherche_famille = Cel::db()->executerRequete($requete_famille); |
| |
| if (!is_array($resultat_recherche_famille) || count($resultat_recherche_famille) == 0) { |
| $resultat_recherche_famille = array('en_ce_rang' => 'fin'); |
| 247,7 → 247,7 |
|---|
| |
| $requete_num_tax = "SELECT DISTINCT b.esn_id_taxon FROM eflore_nom, eflore_nom_rang," . |
| " eflore_selection_nom a, eflore_selection_nom b". |
| " WHERE a.esn_id_nom= ".$this->proteger($num_nom). |
| " WHERE a.esn_id_nom= ".Cel::db()->proteger($num_nom). |
| " AND a.esn_id_version_projet_taxon = 25 ". |
| " AND a.esn_id_taxon=b.esn_id_taxon ". |
| " AND b.esn_ce_statut=3 ". |
| 256,7 → 256,7 |
|---|
| " AND en_id_nom = b.esn_id_nom" . |
| " AND a.esn_id_version_projet_taxon=en_id_version_projet_nom "; |
| |
| $res_num_nom = $this->executerRequete($requete_num_tax); |
| $res_num_nom = Cel::db()->executerRequete($requete_num_tax); |
| |
| $nt = null; |
| if (is_array($res_num_nom) && count($res_num_nom) > 0) { |
| 269,13 → 269,13 |
|---|
| public function taxonEstPresentDansDepartement($num_taxon,$code_departement) { |
| |
| $requete_presence_taxon = "SELECT ecd_ce_taxon FROM eflore_zg, eflore_chorologie_donnee ". |
| "WHERE ecd_ce_taxon = ".$this->proteger($num_taxon)." ". |
| "AND ezg_code = ".$this->proteger($code_departement)." ". |
| "WHERE ecd_ce_taxon = ".Cel::db()->proteger($num_taxon)." ". |
| "AND ezg_code = ".Cel::db()->proteger($code_departement)." ". |
| "AND ecd_ce_zone_geo = ezg_id_zone_geo ". |
| "AND ezg_id_projet_zg = ecd_ce_version_projet_zg ". |
| "AND ecd_ce_version_projet_taxon=25"; |
| |
| $resultat_presence_taxon = $this->executerRequete($requete_presence_taxon); |
| $resultat_presence_taxon = Cel::db()->executerRequete($requete_presence_taxon); |
| |
| $presence_taxon = (is_array($resultat_presence_taxon) && count($resultat_presence_taxon) > 0); |
| |
| 289,12 → 289,12 |
|---|
| if (isset($nom_latin_decoupe['infra']) && $nom_latin_decoupe['infra']!="") { |
| $requete="SELECT DISTINCT en_id_nom, esn_ce_statut" . |
| " FROM eflore_nom, eflore_nom_rang, eflore_selection_nom " . |
| " WHERE en_id_version_projet_nom = '25' AND en_nom_genre = ".$this->proteger($nom_latin_decoupe['genus'])." " . |
| " AND enrg_abreviation_rang = ".$this->proteger($nom_latin_decoupe['infra_type'])." " . |
| " AND en_epithete_infra_specifique = ".$this->proteger($nom_latin_decoupe['infra'])." " . |
| " WHERE en_id_version_projet_nom = '25' AND en_nom_genre = ".Cel::db()->proteger($nom_latin_decoupe['genus'])." " . |
| " AND enrg_abreviation_rang = ".Cel::db()->proteger($nom_latin_decoupe['infra_type'])." " . |
| " AND en_epithete_infra_specifique = ".Cel::db()->proteger($nom_latin_decoupe['infra'])." " . |
| " AND esn_id_nom= en_id_nom ". |
| " AND esn_id_version_projet_taxon=en_id_version_projet_nom " . |
| " AND en_epithete_espece = ".$this->proteger($nom_latin_decoupe['species'])." AND en_ce_rang = enrg_id_rang " . |
| " AND en_epithete_espece = ".Cel::db()->proteger($nom_latin_decoupe['species'])." AND en_ce_rang = enrg_id_rang " . |
| " ORDER BY esn_ce_statut ". |
| " LIMIT 1"; |
| } |
| 301,17 → 301,17 |
|---|
| else { // espece (on privilegie les noms retenu cf tri par esn_ce_statut) |
| $requete="SELECT DISTINCT en_id_nom, esn_ce_statut" . |
| " FROM eflore_nom, eflore_nom_rang, eflore_selection_nom " . |
| " WHERE en_id_version_projet_nom = '25' AND en_nom_genre = ".$this->proteger($nom_latin_decoupe['genus'])." " . |
| " WHERE en_id_version_projet_nom = '25' AND en_nom_genre = ".Cel::db()->proteger($nom_latin_decoupe['genus'])." " . |
| " AND enrg_abreviation_rang = 'sp.' " . |
| " AND esn_id_nom= en_id_nom ". |
| " AND esn_id_version_projet_taxon=en_id_version_projet_nom " . |
| " AND en_epithete_espece = ".$this->proteger($nom_latin_decoupe['species'])." AND en_ce_rang = enrg_id_rang " . |
| " AND en_epithete_espece = ".Cel::db()->proteger($nom_latin_decoupe['species'])." AND en_ce_rang = enrg_id_rang " . |
| " ORDER BY esn_ce_statut ". |
| " LIMIT 1"; |
| |
| } |
| |
| $resultat = $this->executerRequete($requete); |
| $resultat = Cel::db()->executerRequete($requete); |
| |
| $retour = array(); |
| if (is_array($resultat) && count($resultat) > 0) { |