Subversion Repositories eFlore/Archives.eflore-consultation-v2

Rev

Rev 76 | Blame | Compare with Previous | Last modification | View Log | RSS feed

<?php
class TAXON_NOMS extends macroElement {
    function getSQL()
    {
        $contexte = array();
        if (array_key_exists('nt', $this->contexteRef) and array_key_exists('nvp', $this->contexteRef)) {
            
            $contexte['nt'] = $this->contexteRef['nt'];
            $contexte['nvp'] = $this->contexteRef['nvp'];
            if (!empty($contexte['nt']) && !empty($contexte['nvp'])) {
                return 
                'SELECT DISTINCT 
                nom.en_id_nom,
                selection.esn_code_numerique_1,
                selection.esn_code_numerique_2,
                selection.esn_code_alphanumerique_1,
                selection.esn_code_alphanumerique_2,
                selection.esn_commentaire_nomenclatural,
                statut.esns_id_statut,
                statut.esns_intitule_statut,
                statut.esns_abreviation_intitule_statut,
                statut.esns_description_statut,
                taxon.et_id_taxon
               
                FROM 
                eflore_nom AS nom,
                eflore_selection_nom AS selection,
                eflore_selection_nom_statut AS statut,
                eflore_taxon AS taxon
                
                WHERE 
                selection.esn_id_taxon = '.$contexte['nt'].'
                AND selection.esn_id_version_projet_taxon = '.$contexte['nvp'].' 
                AND selection.esn_ce_statut = statut.esns_id_statut 
                AND selection.esn_id_nom = nom.en_id_nom 
                AND selection.esn_id_taxon = taxon.et_id_taxon';
            }
        }
        return null;
    }
}
?>