Subversion Repositories eFlore/Archives.eflore-consultation-v2

Rev

Rev 69 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
69 jpm 1 
<?php
2 
class NOM_SELECTION extends macroElement {
3 
    function getSQL()
4 
    {
5 
        $contexte = array();
6 
        if (array_key_exists('nn', $this->contexteRef)) {
7 
            $contexte['nn'] = $this->contexteRef['nn'];
8 
            if (!empty($contexte['nn'])) {
9 
                return
10 
                'SELECT DISTINCT
11 
                nom.en_id_nom,
12 
                selection.esn_code_numerique_1,
13 
                selection.esn_code_numerique_2,
14 
                selection.esn_code_alphanumerique_1,
15 
                selection.esn_code_alphanumerique_2,
16 
                selection.esn_commentaire_nomenclatural,
17 
                statut.esns_intitule_statut,
18 
                statut.esns_abreviation_intitule_statut,
19 
                statut.esns_description_statut,
77 jpm 20 
                taxon.et_id_taxon,
69 jpm 21 
                taxon.et_notes_taxon,
77 jpm 22 
                version.eprv_id_version,
69 jpm 23 
                version.eprv_nom,
24 
                projet.epr_intitule_projet,
25 
                projet.epr_abreviation_projet
26 
 
27 
                FROM
28 
                eflore_nom AS nom,
29 
                eflore_selection_nom AS selection,
30 
                eflore_selection_nom_statut AS statut,
31 
                eflore_taxon AS taxon,
32 
                eflore_projet_version AS version,
33 
                eflore_projet AS projet
34 
 
35 
                WHERE
36 
                nom.en_id_nom = '.$contexte['nn'].'
37 
                AND nom.en_id_nom = selection.esn_id_nom
38 
                AND selection.esn_ce_statut = statut.esns_id_statut
39 
                AND selection.esn_id_taxon = taxon.et_id_taxon
40 
                AND taxon.et_id_version_projet_taxon = version.eprv_id_version
77 jpm 41 
                AND version.eprv_ce_projet = projet.epr_id_projet
69 jpm 42 
                AND version.eprv_date_fin_version IS NULL
77 jpm 43 
                AND projet.epr_mark_projet_consultable = 1
44 
                ORDER BY version.eprv_nom ASC';
69 jpm 45 
            }
46 
        }
47 
        return null;
48 
    }
49 
}
50 
?>