DbHandle)) {
// parameter
if (isset($_GET['lwf'])) {
$lwf=$_GET['lwf'];
// Flaechenname
$clname=$Db->String("
select clname
from beo.w_cl
where upper(substr(clname,1,3)) like upper('".$lwf."')");
// Title
echo "".LWF." ".$clname."
\n";
// sql Metadaten
// Personen
// a) Link auf persoenliche Webseite 2017 ff
//if ($lang=="FR") {$link_person="https://www.wsl.ch/fr/annuaire-du-personnel/";}
//if ($lang=="DE") {$link_person="https://www.wsl.ch/de/mitarbeitende/";}
//if ($lang=="IT") {$link_person="https://www.wsl.ch/it/collaboratori/";}
//if ($lang=="EN") {$link_person="https://www.wsl.ch/en/employees/";}
//$sql_contact="decode(cr_organisation,'WSL',
// '' || cr_creator || '',
// cr_creator) ".CONTACT.",\n";
// b) Link auf persoenliche Webseite bis 2017
//$sql_contact="decode(cr_organisation,'WSL',
// '' || cr_creator || '',
// cr_creator) ".CONTACT.",\n";
// c) kein link
$sql_contact="cr_creator ".CONTACT.",\n";
// Projekte
// a) link to url
// $sql_surv="decode(url,null,
// decode(title_".$lang.",null,title_de,title_".$lang."),
// '' ||
// decode(title_".$lang.",null,title_de,title_".$lang.") ||
// '') ".SURVEY.",\n";
// b) kein link
$sql_surv="decode(title_".$lang.",null,title_de,title_".$lang.") ".SURVEY.",\n";
// sql
$sql="
select ".$sql_surv.
$sql_contact.
"decode(freq,
'asNeeded',null,
'irregular',null,
'unique','".UNIQUE."',
'biannually','".BIANNUALLY."',
'annually','".ANNUALLY."',
'monthly','".MONTHLY."',
'fortnightly','".FORTNIGHTLY."',
'continuously','".CONTINUOUSLY."',
freq) ".FREQUENZ.",
".$lwf." ".PERIOD."
from beo.metadata
where categories not like '%Leitung%'
and ".$lwf." is not null
and envidat like '%w%' or envidat like '%x%'
order by metadata.survey";
// results
$Db->HtmlTable($sql);
}
}
?>