| 48,6 → 48,31 |
|---|
| AND nom.en_ce_rang = '.$contexte['rang']; |
| } |
| } |
| if (array_key_exists('radical', $this->contexteRef) and array_key_exists('nvp', $this->contexteRef) ) { |
| $contexte['radical'] = $this->contexteRef['radical']; |
| $contexte['nvp'] = $this->contexteRef['nvp']; |
| if(!empty($contexte['nvp']) ) { |
| return |
| 'SELECT |
| nom.*, |
| intitule.eni_intitule_nom, |
| selection.esn_ce_statut, |
| selection.esn_id_version_projet_taxon |
| |
| FROM |
| eflore_nom_intitule AS intitule, |
| eflore_nom AS nom, |
| eflore_selection_nom AS selection |
| |
| WHERE |
| intitule.eni_intitule_nom LIKE "'.$contexte['radical'].'" |
| AND intitule.eni_id_categorie_format = 3 |
| AND intitule.eni_id_valeur_format = 4 |
| AND nom.en_id_nom = intitule.eni_id_nom |
| AND nom.en_id_nom = selection.esn_id_nom |
| AND selection.esn_id_version_projet_taxon = '.$contexte['nvp']; |
| } |
| } |
| if (array_key_exists('radical', $this->contexteRef) ) { |
| $contexte['radical'] = $this->contexteRef['radical']; |
| if(!empty($contexte['radical']) ) { |
| 62,7 → 87,7 |
|---|
| WHERE |
| intitule.eni_intitule_nom LIKE "'.$contexte['radical'].'" |
| AND intitule.eni_id_categorie_format = 3 |
| AND intitule.eni_id_valeur_format = 3 |
| AND intitule.eni_id_valeur_format = 4 |
| AND nom.en_id_nom = intitule.eni_id_nom'; |
| } |
| } |