New file |
0,0 → 1,54 |
<? |
|
|
|
|
|
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; |
} |
|
|
|
} |
|
|
?> |
|