Blame | Last modification | View Log | RSS feed
<?
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;
}
}
?>