Rev 27 | Go to most recent revision | Blame | Last modification | View Log | RSS feed
<?php
class NOM_SELECTION extends macroElement {
function getSQL()
{
$contexte = array();
if (array_key_exists('radical',$this->contexteRef) and array_key_exists('rang',$this->contexteRef) ) {
$contexte['radical']= $this->contexteRef['radical'];
$contexte['rang']= $this->contexteRef['rang'];
if(!empty($contexte['radical']) and !empty($contexte['rang']) ) {
return
'SELECT nom.*, intitule.eni_intitule_nom
FROM eflore_nom_intitule as intitule, eflore_nom as nom
WHERE intitule.eni_intitule_nom like "%'.$contexte['radical'].'%"
AND nom.en_id_nom = intitule.eni_id_nom
AND nom.en_ce_rang = '.$contexte['rang'];
}
}
if (array_key_exists('radical',$this->contexteRef) ) {
$contexte['radical']= $this->contexteRef['radical'];
if(!empty($contexte['radical']) ) {
return
'SELECT nom.*, intitule.eni_intitule_nom
FROM eflore_nom_intitule as intitule, eflore_nom as nom
WHERE intitule.eni_intitule_nom like "%'.$contexte['radical'].'%"
AND nom.en_id_nom = intitule.eni_id_nom';
}
}
return null;
}
}
?>