Subversion Repositories eFlore/Archives.eflore-consultation-v2

Rev

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

Rev 69 Rev 77
Line 15... Line 15...
15 
                selection.esn_code_alphanumerique_2,
 15 
                selection.esn_code_alphanumerique_2,
16 
                selection.esn_commentaire_nomenclatural,
 16 
                selection.esn_commentaire_nomenclatural,
17 
                statut.esns_intitule_statut,
 17 
                statut.esns_intitule_statut,
18 
                statut.esns_abreviation_intitule_statut,
 18 
                statut.esns_abreviation_intitule_statut,
19 
                statut.esns_description_statut,
 19 
                statut.esns_description_statut,
- 
 
 20 
                taxon.et_id_taxon,
20 
                taxon.et_notes_taxon,
 21 
                taxon.et_notes_taxon,
- 
 
 22 
                version.eprv_id_version,
21 
                version.eprv_nom,
 23 
                version.eprv_nom,
22 
                projet.epr_intitule_projet,
 24 
                projet.epr_intitule_projet,
23 
                projet.epr_abreviation_projet
 25 
                projet.epr_abreviation_projet
Line 24... Line 26...
24
26
Line 34... Line 36...
34 
                nom.en_id_nom = '.$contexte['nn'].'
36 
                nom.en_id_nom = '.$contexte['nn'].'
35 
                AND nom.en_id_nom = selection.esn_id_nom
37 
                AND nom.en_id_nom = selection.esn_id_nom
36 
                AND selection.esn_ce_statut = statut.esns_id_statut
38 
                AND selection.esn_ce_statut = statut.esns_id_statut
37 
                AND selection.esn_id_taxon = taxon.et_id_taxon
39 
                AND selection.esn_id_taxon = taxon.et_id_taxon
38 
                AND taxon.et_id_version_projet_taxon = version.eprv_id_version
40 
                AND taxon.et_id_version_projet_taxon = version.eprv_id_version
39 
                AND version.eprv_ce_projet  = projet.epr_id_projet
 41 
                AND version.eprv_ce_projet = projet.epr_id_projet
40 
                AND version.eprv_date_fin_version IS NULL
42 
                AND version.eprv_date_fin_version IS NULL
41 
                AND projet.epr_mark_projet_consultable = 1';
 43 
                AND projet.epr_mark_projet_consultable = 1
- 
 
 44 
                ORDER BY version.eprv_nom ASC';
42 
            }
 45 
            }
43 
        }
 46 
        }
44 
        return null;
 47 
        return null;
45 
    }
 48 
    }
46 
}
 49 
}