Subversion Repositories eFlore/Archives.eflore-consultation-v2

Rev

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

Rev 170 Rev 173
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 
        echo '<pre>'.print_r($this->contexteRef, true).'</pre>';
6 
        if (array_key_exists('nvp', $this->contexteRef)) {
 7 
        if (array_key_exists('nvp', $this->contexteRef)) {
7 
            $contexte['nvp'] = $this->contexteRef['nvp'];
 8 
            $contexte['nvp'] = $this->contexteRef['nvp'];
8 
            if (!empty($contexte['nvp'])) {
 9 
            if (!empty($contexte['nvp'])) {
9 
                return
10 
                return
10 
                'SELECT DISTINCT
11 
                'SELECT DISTINCT
11 
                version.eprv_id_version,
 12 
                version.eprv_id_version,
12 
                version.eprv_nom,
13 
                version.eprv_nom,
13 
                version.eprv_code_version,
14 
                version.eprv_code_version,
14 
                projet.epr_id_projet,
 15 
                projet.epr_id_projet,
15 
                projet.epr_intitule_projet,
 16 
                projet.epr_intitule_projet,
16 
                projet.epr_abreviation_projet
 17 
                projet.epr_abreviation_projet
17
18
18 
                FROM
19 
                FROM
19 
                eflore_projet_version AS version,
 20 
                eflore_projet_version AS version,
20 
                eflore_projet AS projet
 21 
                eflore_projet AS projet
21
22
22 
                WHERE
23 
                WHERE
23 
                version.eprv_id_version = '.$contexte['nvp'].'
24 
                version.eprv_id_version = '.$contexte['nvp'].'
24 
                AND version.eprv_ce_projet = projet.epr_id_projet
 25 
                AND version.eprv_ce_projet = projet.epr_id_projet
25 
                AND version.eprv_date_fin_version IS NULL
26 
                AND version.eprv_date_fin_version IS NULL
26 
                AND projet.epr_mark_projet_consultable = 1
 27 
                AND projet.epr_mark_projet_consultable = 1
27 
                ORDER BY version.eprv_nom ASC';
 28 
                ORDER BY version.eprv_nom ASC';
28 
            }
 29 
            }
29 
        }
 30 
        }
30 
        return null;
 31 
        return null;
31 
    }
 32 
    }
32 
}
 33 
}
33 
?>
 34 
?>