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); } } ?>