Subversion Repositories eFlore/Archives.eflore-consultation-v2

Rev

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

Rev 131 Rev 141
1 
<?php
 1 
<?php
2 
class PROJET_VERSION_TOUS extends macroElement {
 2 
class PROJET_VERSION_TOUS extends macroElement {
3 
    function getSQL()
 3 
    function getSQL()
4 
    {
 4 
    {
5 
        $contexte = array();
 5 
        $contexte = array();
6 
        $contexte['nvp'] = $this->contexteRef['nvp'];
 - 
 
7 
        return
6 
        return
8 
        'SELECT DISTINCT
7 
        'SELECT DISTINCT
9 
        version.eprv_id_version,
 8 
        version.eprv_id_version,
10 
        version.eprv_nom,
 9 
        version.eprv_nom,
11 
        projet.epr_id_projet,
 10 
        projet.epr_id_projet,
12 
        projet.epr_intitule_projet,
 11 
        projet.epr_intitule_projet,
13 
        projet.epr_abreviation_projet
 12 
        projet.epr_abreviation_projet
14
13
15 
        FROM
14 
        FROM
16 
        eflore_projet_version AS version,
 15 
        eflore_projet_version AS version,
17 
        eflore_projet AS projet,
 16 
        eflore_projet AS projet,
18 
        eflore_projet_type AS type,
 17 
        eflore_projet_type AS type,
19 
        eflore_projet_utiliser_module AS avoir_module
 18 
        eflore_projet_utiliser_module AS avoir_module
20
19
21 
        WHERE
20 
        WHERE
22 
        version.eprv_ce_projet = projet.epr_id_projet
 21 
        version.eprv_ce_projet = projet.epr_id_projet
23 
        AND version.eprv_date_fin_version IS NULL
22 
        AND version.eprv_date_fin_version IS NULL
24 
        AND projet.epr_mark_projet_consultable = 1
23 
        AND projet.epr_mark_projet_consultable = 1
25 
        AND projet.epr_ce_type_projet = type.eprt_id_type_projet
 24 
        AND projet.epr_ce_type_projet = type.eprt_id_type_projet
26 
        AND type.eprt_id_type_projet IN (4, 5)
25 
        AND type.eprt_id_type_projet IN (4, 5)
27 
        AND avoir_module.eprum_id_version = version.eprv_id_version
 26 
        AND avoir_module.eprum_id_version = version.eprv_id_version
28 
        AND avoir_module.eprum_id_module = 18
27 
        AND avoir_module.eprum_id_module = 18
29 
        ORDER BY version.eprv_nom ASC';
 28 
        ORDER BY version.eprv_nom ASC';
30 
    }
 29 
    }
31 
}
 30 
}
32 
?>
 31 
?>