Rev 170 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed
<?php
class PROJET_VERSION extends macroElement {
function getSQL()
{
$contexte = array();
echo '<pre>'.print_r($this->contexteRef, true).'</pre>';
if (array_key_exists('nvp', $this->contexteRef)) {
$contexte['nvp'] = $this->contexteRef['nvp'];
if (!empty($contexte['nvp'])) {
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
WHERE
version.eprv_id_version = '.$contexte['nvp'].'
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;
}
}
?>