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'; |
} |
} |