Subversion Repositories eFlore/Archives.eflore-consultation-v2

Rev

Rev 95 | Only display areas with differences | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 95 Rev 170
1 
<?php
 1 
<?php
2 
class NOM_SELECTION_PROJETS extends macroElement {
 2 
class NOM_SELECTION_PROJETS extends macroElement {
3 
    function getSQL()
 3 
    function getSQL()
4 
    {
 4 
    {
5 
        $contexte = array();
 5 
        $contexte = array();
6 
        if (array_key_exists('nn', $this->contexteRef)) {
 6 
        if (array_key_exists('nn', $this->contexteRef)) {
7 
            $contexte['nn'] = $this->contexteRef['nn'];
 7 
            $contexte['nn'] = $this->contexteRef['nn'];
8 
            if (!empty($contexte['nn'])) {
 8 
            if (!empty($contexte['nn'])) {
9 
                return
9 
                return
10 
                'SELECT DISTINCT
10 
                'SELECT DISTINCT
11 
                nom.en_id_nom,
 11 
                nom.en_id_nom,
12 
                version.eprv_id_version,
 12 
                version.eprv_id_version,
13 
                version.eprv_nom,
 13 
                version.eprv_nom,
- 
 
 14 
                version.eprv_code_version,
14 
                projet.epr_intitule_projet,
 15 
                projet.epr_intitule_projet,
15 
                projet.epr_abreviation_projet
 16 
                projet.epr_abreviation_projet
16
17
17 
                FROM
18 
                FROM
18 
                eflore_nom AS nom,
 19 
                eflore_nom AS nom,
19 
                eflore_selection_nom AS selection,
 20 
                eflore_selection_nom AS selection,
20 
                eflore_taxon AS taxon,
 21 
                eflore_taxon AS taxon,
21 
                eflore_projet_version AS version,
 22 
                eflore_projet_version AS version,
22 
                eflore_projet AS projet
 23 
                eflore_projet AS projet
23
24
24 
                WHERE
25 
                WHERE
25 
                nom.en_id_nom = '.$contexte['nn'].'
26 
                nom.en_id_nom = '.$contexte['nn'].'
26 
                AND nom.en_id_nom = selection.esn_id_nom
27 
                AND nom.en_id_nom = selection.esn_id_nom
27 
                AND selection.esn_id_taxon = taxon.et_id_taxon
28 
                AND selection.esn_id_taxon = taxon.et_id_taxon
28 
                AND selection.esn_id_version_projet_taxon = taxon.et_id_version_projet_taxon
29 
                AND selection.esn_id_version_projet_taxon = taxon.et_id_version_projet_taxon
29 
                AND taxon.et_id_version_projet_taxon = version.eprv_id_version
30 
                AND taxon.et_id_version_projet_taxon = version.eprv_id_version
30 
                AND version.eprv_ce_projet = projet.epr_id_projet
 31 
                AND version.eprv_ce_projet = projet.epr_id_projet
31 
                AND version.eprv_date_fin_version IS NULL
32 
                AND version.eprv_date_fin_version IS NULL
32 
                AND projet.epr_mark_projet_consultable = 1
 33 
                AND projet.epr_mark_projet_consultable = 1
33 
                ORDER BY version.eprv_nom ASC';
 34 
                ORDER BY version.eprv_nom ASC';
34 
            }
 35 
            }
35 
        }
 36 
        }
36 
        return null;
 37 
        return null;
37 
    }
 38 
    }
38 
}
 39 
}
39 
?>
 40 
?>