Subversion Repositories eFlore/Archives.eflore-consultation-v2

<?php
class PROJET_VERSION_TOUS extends macroElement {
    function getSQL()
    {
        $contexte = array();
        return 
        'SELECT DISTINCT 
        version.eprv_id_version,
        version.eprv_nom,
        version.eprv_code_version, 
        projet.epr_id_projet,
        projet.epr_intitule_projet,
        projet.epr_abreviation_projet
        
        FROM 
        eflore_projet_version AS version,
        eflore_projet AS projet,
        eflore_projet_type AS type,
        eflore_projet_utiliser_module AS avoir_module
        
        WHERE 
        version.eprv_ce_projet = projet.epr_id_projet
        AND version.eprv_date_fin_version IS NULL 
        AND projet.epr_mark_projet_consultable = 1 
        AND projet.epr_ce_type_projet = type.eprt_id_type_projet
        AND type.eprt_id_type_projet IN (4, 5) 
        AND avoir_module.eprum_id_version = version.eprv_id_version
        AND avoir_module.eprum_id_module = 18 
        ORDER BY version.eprv_nom ASC';
    }
}
?>