Rev 77 | Blame | Compare with Previous | Last modification | View Log | RSS feed
<?php
class NOM_SELECTION extends macroElement {
function getSQL()
{
$contexte = array();
if (array_key_exists('nn', $this->contexteRef) AND array_key_exists('nvp', $this->contexteRef)) {
$contexte['nn'] = $this->contexteRef['nn'];
$contexte['nvp'] = $this->contexteRef['nvp'];
if ($contexte['nn'] != '' AND $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_intitule_statut,
statut.esns_abreviation_intitule_statut,
statut.esns_description_statut,
taxon.et_id_taxon,
taxon.et_notes_taxon
FROM
eflore_nom AS nom,
eflore_selection_nom AS selection,
eflore_selection_nom_statut AS statut,
eflore_taxon AS taxon,
eflore_projet_version AS version,
eflore_projet AS projet
WHERE
nom.en_id_nom = '.$contexte['nn'].'
AND nom.en_id_nom = selection.esn_id_nom
AND selection.esn_id_version_projet_taxon = '.$contexte['nvp'].'
AND selection.esn_ce_statut = statut.esns_id_statut
AND selection.esn_id_taxon = taxon.et_id_taxon
AND selection.esn_id_version_projet_taxon = taxon.et_id_version_projet_taxon
AND taxon.et_id_version_projet_taxon = version.eprv_id_version
AND version.eprv_ce_projet = projet.epr_id_projet
AND version.eprv_date_fin_version IS NULL
AND projet.epr_mark_projet_consultable = 1
ORDER BY version.eprv_nom ASC';
}
}
if (array_key_exists('nn', $this->contexteRef)) {
$contexte['nn'] = $this->contexteRef['nn'];
if (!empty($contexte['nn'])) {
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_intitule_statut,
statut.esns_abreviation_intitule_statut,
statut.esns_description_statut,
taxon.et_id_taxon,
taxon.et_notes_taxon
FROM
eflore_nom AS nom,
eflore_selection_nom AS selection,
eflore_selection_nom_statut AS statut,
eflore_taxon AS taxon,
eflore_projet_version AS version,
eflore_projet AS projet
WHERE
nom.en_id_nom = '.$contexte['nn'].'
AND nom.en_id_nom = selection.esn_id_nom
AND selection.esn_ce_statut = statut.esns_id_statut
AND selection.esn_id_taxon = taxon.et_id_taxon
AND selection.esn_id_version_projet_taxon = taxon.et_id_version_projet_taxon
AND taxon.et_id_version_projet_taxon = version.eprv_id_version
AND version.eprv_ce_projet = projet.epr_id_projet
AND version.eprv_date_fin_version IS NULL
AND projet.epr_mark_projet_consultable = 1
ORDER BY version.eprv_nom ASC';
}
}
return null;
}
}
?>