Subversion Repositories eFlore/Archives.eflore-consultation-v2

Rev

Rev 83 | Rev 141 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 83 Rev 121
Line 24... Line 24...
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 null;
 29 
        return
- 
 
 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';
30 
    }
 52 
    }
31 
}
 53 
}
32 
?>
 54 
?>
33 

            55