Subversion Repositories eFlore/Archives.eflore-consultation-v2

Rev

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

Rev 122 Rev 170
Line 46... Line 46...
46 
                AND nom.en_ce_intitule_cn = commentaire.enic_id_intitule_cn
46 
                AND nom.en_ce_intitule_cn = commentaire.enic_id_intitule_cn
47 
                AND nom.en_id_nom = commentaire.enic_id_intitule_cn
47 
                AND nom.en_id_nom = commentaire.enic_id_intitule_cn
48 
                AND nom.en_ce_rang = '.$contexte['rang'];
 48 
                AND nom.en_ce_rang = '.$contexte['rang'];
49 
            }
 49 
            }
50 
        }
 50 
        }
- 
 
 51 
        if (array_key_exists('radical', $this->contexteRef) and array_key_exists('nvp', $this->contexteRef) ) {
- 
 
 52 
            $contexte['radical'] = $this->contexteRef['radical'];
- 
 
 53 
            $contexte['nvp'] = $this->contexteRef['nvp'];
- 
 
 54 
            if(!empty($contexte['nvp']) ) {
- 
 
 55 
                return
- 
 
 56 
                    'SELECT
- 
 
 57 
                    nom.*,
- 
 
 58 
                    intitule.eni_intitule_nom,
- 
 
 59 
                    selection.esn_ce_statut,
- 
 
 60 
                    selection.esn_id_version_projet_taxon
- 
 
 61
- 
 
 62 
                    FROM
- 
 
 63 
                    eflore_nom_intitule AS intitule,
- 
 
 64 
                    eflore_nom AS nom,
- 
 
 65 
                    eflore_selection_nom AS selection
- 
 
 66
- 
 
 67 
                    WHERE
- 
 
 68 
                    intitule.eni_intitule_nom LIKE "'.$contexte['radical'].'"
- 
 
 69 
                    AND intitule.eni_id_categorie_format = 3
- 
 
 70 
                    AND intitule.eni_id_valeur_format = 4
- 
 
 71 
                    AND nom.en_id_nom = intitule.eni_id_nom
- 
 
 72 
                    AND nom.en_id_nom = selection.esn_id_nom
- 
 
 73 
                    AND selection.esn_id_version_projet_taxon = '.$contexte['nvp'];
- 
 
 74 
            }
- 
 
 75 
        }
51 
        if (array_key_exists('radical', $this->contexteRef) ) {
 76 
        if (array_key_exists('radical', $this->contexteRef) ) {
52 
            $contexte['radical'] = $this->contexteRef['radical'];
 77 
            $contexte['radical'] = $this->contexteRef['radical'];
53 
            if(!empty($contexte['radical']) ) {
 78 
            if(!empty($contexte['radical']) ) {
54 
                return
79 
                return
55 
                    'SELECT
80 
                    'SELECT
Line 60... Line 85...
60 
                    eflore_nom AS nom
85 
                    eflore_nom AS nom
Line 61... Line 86...
61
86
62 
                    WHERE
87 
                    WHERE
63 
                    intitule.eni_intitule_nom LIKE "'.$contexte['radical'].'"
 88 
                    intitule.eni_intitule_nom LIKE "'.$contexte['radical'].'"
64 
                    AND intitule.eni_id_categorie_format = 3
89 
                    AND intitule.eni_id_categorie_format = 3
65 
                    AND intitule.eni_id_valeur_format = 3
90 
                    AND intitule.eni_id_valeur_format = 4
66 
                    AND nom.en_id_nom = intitule.eni_id_nom';
 91 
                    AND nom.en_id_nom = intitule.eni_id_nom';
67 
            }
 92 
            }
68 
        }
 93 
        }
69 
        return null;
 94 
        return null;