Subversion Repositories eFlore/Archives.eflore-consultation-v2

Rev

Rev 28 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 28 Rev 32
Line 7... Line 7...
7 
            $contexte['radical']= $this->contexteRef['radical'];
 7 
            $contexte['radical']= $this->contexteRef['radical'];
8 
            $contexte['rang']= $this->contexteRef['rang'];
 8 
            $contexte['rang']= $this->contexteRef['rang'];
9 
            if(!empty($contexte['radical']) and !empty($contexte['rang']) ) {
 9 
            if(!empty($contexte['radical']) and !empty($contexte['rang']) ) {
10 
                return
10 
                return
11 
                    'SELECT nom.*, intitule.eni_intitule_nom
11 
                    'SELECT nom.*, intitule.eni_intitule_nom
12 
                    FROM eflore_nom_intitule as intitule, eflore_nom as nom
12 
                    FROM eflore_nom_intitule AS intitule, eflore_nom AS nom
13 
                    WHERE intitule.eni_intitule_nom like "%'.$contexte['radical'].'%"
 13 
                    WHERE intitule.eni_intitule_nom LIKE "%'.$contexte['radical'].'%"
14 
                    AND nom.en_id_nom = intitule.eni_id_nom
 14 
                    AND nom.en_id_nom = intitule.eni_id_nom
15 
                    AND nom.en_ce_rang = '.$contexte['rang'];
 15 
                    AND nom.en_ce_rang = '.$contexte['rang'];
16 
            }
 16 
            }
17 
        }
 17 
        }
18 
        if (array_key_exists('radical',$this->contexteRef) ) {
 18 
        if (array_key_exists('radical',$this->contexteRef) ) {
19 
            $contexte['radical']= $this->contexteRef['radical'];
 19 
            $contexte['radical']= $this->contexteRef['radical'];
20 
            if(!empty($contexte['radical']) ) {
 20 
            if(!empty($contexte['radical']) ) {
21 
                return
21 
                return
22 
                    'SELECT nom.*, intitule.eni_intitule_nom
22 
                    'SELECT nom.*, intitule.eni_intitule_nom
23 
                    FROM eflore_nom_intitule as intitule, eflore_nom as nom
23 
                    FROM eflore_nom_intitule AS intitule, eflore_nom AS nom
24 
                    WHERE intitule.eni_intitule_nom like "%'.$contexte['radical'].'%"
 24 
                    WHERE intitule.eni_intitule_nom LIKE "%'.$contexte['radical'].'%"
25 
                    AND nom.en_id_nom = intitule.eni_id_nom';
 25 
                    AND nom.en_id_nom = intitule.eni_id_nom';
26 
            }
 26 
            }
27 
        }
 27 
        }
28 
        return null;
 28 
        return null;
29 
    }
 29 
    }