1,54 → 1,31 |
<? |
|
|
|
|
|
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; |
} |
|
|
|
} |
|
|
?> |
|
<?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; |
} |
} |
?> |