Subversion Repositories eFlore/Archives.eflore-consultation-v2

Rev

Rev 121 | Rev 170 | Go to most recent revision | Only display areas with differences | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 121 Rev 141
1 
<?php
 1 
<?php
2 
class PROJET_VERSION extends macroElement {
 2 
class PROJET_VERSION extends macroElement {
3 
    function getSQL()
 3 
    function getSQL()
4 
    {
 4 
    {
5 
        $contexte = array();
 5 
        $contexte = array();
6 
        if (array_key_exists('nvp', $this->contexteRef)) {
 6 
        if (array_key_exists('nvp', $this->contexteRef)) {
7 
            $contexte['nvp'] = $this->contexteRef['nvp'];
 7 
            $contexte['nvp'] = $this->contexteRef['nvp'];
8 
            if (!empty($contexte['nvp'])) {
 8 
            if (!empty($contexte['nvp'])) {
9 
                return
9 
                return
10 
                'SELECT DISTINCT
10 
                'SELECT DISTINCT
11 
                version.eprv_id_version,
 11 
                version.eprv_id_version,
12 
                version.eprv_nom,
 12 
                version.eprv_nom,
13 
                projet.epr_id_projet,
 13 
                projet.epr_id_projet,
14 
                projet.epr_intitule_projet,
 14 
                projet.epr_intitule_projet,
15 
                projet.epr_abreviation_projet
 15 
                projet.epr_abreviation_projet
16
16
17 
                FROM
17 
                FROM
18 
                eflore_projet_version AS version,
 18 
                eflore_projet_version AS version,
19 
                eflore_projet AS projet
 19 
                eflore_projet AS projet
20
20
21 
                WHERE
21 
                WHERE
22 
                version.eprv_id_version = '.$contexte['nvp'].'
22 
                version.eprv_id_version = '.$contexte['nvp'].'
23 
                AND version.eprv_ce_projet = projet.epr_id_projet
 23 
                AND version.eprv_ce_projet = projet.epr_id_projet
24 
                AND version.eprv_date_fin_version IS NULL
24 
                AND version.eprv_date_fin_version IS NULL
25 
                AND projet.epr_mark_projet_consultable = 1
 25 
                AND projet.epr_mark_projet_consultable = 1
26 
                ORDER BY version.eprv_nom ASC';
 26 
                ORDER BY version.eprv_nom ASC';
27 
            }
 27 
            }
28 
        }
 28 
        }
29 
        return
29 
        return null;
30 
        'SELECT DISTINCT
- 
 
31 
        version.eprv_id_version,
 - 
 
32 
        version.eprv_nom,
 - 
 
33 
        projet.epr_id_projet,
 - 
 
34 
        projet.epr_intitule_projet,
 - 
 
35 
        projet.epr_abreviation_projet
 - 
 
36
- 
 
37 
        FROM
- 
 
38 
        eflore_projet_version AS version,
 - 
 
39 
        eflore_projet AS projet,
 - 
 
40 
        eflore_projet_type AS type,
 - 
 
41 
        eflore_projet_utiliser_module AS avoir_module
 - 
 
42
- 
 
43 
        WHERE
- 
 
44 
        version.eprv_ce_projet = projet.epr_id_projet
 - 
 
45 
        AND version.eprv_date_fin_version IS NULL
- 
 
46 
        AND projet.epr_mark_projet_consultable = 1
- 
 
47 
        AND projet.epr_ce_type_projet = type.eprt_id_type_projet
 - 
 
48 
        AND type.eprt_id_type_projet IN (4, 5)
- 
 
49 
        AND avoir_module.eprum_id_version = version.eprv_id_version
 - 
 
50 
        AND avoir_module.eprum_id_module = 18
- 
 
51 
        ORDER BY version.eprv_nom ASC';
 - 
 
52 
    }
 30 
    }
53 
}
 31 
}
54 
?>
 32 
?>