'; ?> '.$testMatch.' is not valid.
'; die(); } $languageCode = $testMatch; $testMatch = NULL; Mapbender::session()->set("mb_lang",$languageCode); //set session var to languageCode $localeObj = new Mb_locale(Mapbender::session()->get("mb_lang")); } $admin = new administration(); $user = new User(); //******************************************************************************************************************************************************************************** //wms //******************************************************************************************************************************************************************************** //echo $user->id."
"; //only logged in user can see their subscribed services $sql = "SELECT DISTINCT mb_wms_availability.fkey_wms_id FROM mb_wms_availability,mb_user_abo_ows WHERE mb_wms_availability.fkey_wms_id=mb_user_abo_ows.fkey_wms_id AND mb_user_abo_ows.fkey_mb_user_id=$1"; $res = db_prep_query($sql, array($user->id), array("i")); $cnt = 0; $wms = array(); while(db_fetch_row($res)){ $wms[$cnt] = db_result($res,$cnt,"fkey_wms_id"); $cnt++; } $status = array(); $upload_id = array(); for ($i=0; $i\n\t"; $str .= ""; $str .= ""; $str .= "";//Verfügbarkeit Dienstebeschreibung $str .= "";//Durchschnittliche Antwortzeit Beschreibung $str .= "";//Verfügbarkeit Kartenbild $str .= "";//Verfügbarkeit (2 Monate) $cnt = 0; foreach ($newArray as $k => $value) { $img = "stop.png"; $img_map = "nopicture.png"; if ($status[$k]==0) $img = "wait.png"; elseif ($status[$k]==1) $img = "go.png"; if ($image[$k]==1) $img_map = "picture.png"; if ($updated[$k] == "0" && $status[$k] == 0) $fill = "checked"; else $fill = "disabled"; if (fmod($cnt, 2) == 1) { $str .= "\n\t\t"; } else { $str .= "\n\t\t"; } $str .= "\n\t\t\t"; $str .= "\n\t\t\t";//Aufruf des Capabilities Dokument $str .= "\n\t\t\t"; $str .= "\n\t\t\t"; $str .= "\n\t\t\t"; //$str .= "\n\t\t\t"; $str .= "\n\t\t"; $cnt++; } $str .= "\n\t

"._mb("Service ID").": ".$wms_id[$k]."
".$admin->getWmsTitleByWmsId($wms_id[$k])."

" . $comment[$k] . "

".date("F j, Y, G:i:s", $upload_id[$k])."

"; if ($avg_response_time[$k] == NULL) { $str .= "n/a"; } else { if($avg_response_time[$k] == 0){ $str .= "< 1 s"; } else { $str .= $avg_response_time[$k] . " s"; } } $str .= "

"; $str .= "

";//Getesteter GetMap Aufruf $str .= "

" . $percentage[$k] . " % (" . $total[$k] . " "._mb('cycles').")
"; $str .= "\n\t\t\t

" . $percentage[$k] . " %
"; $str .= ""; $val = $percentage[$k]; for ($i=0; $i<10; $i++) { if ($val>=10) { $str .= ""; $val-=10; } elseif($val>0){ $str .= ""; if (round($val) < 10) { $str .= ""; } $val=-1; } else { $str .= ""; } } $str .= "

\n\t
\n"; //******************************************************************************************************************************************************************************** //wfs //******************************************************************************************************************************************************************************** //only logged in user can see their subscribed services $sql = "SELECT DISTINCT mb_wfs_availability.fkey_wfs_id FROM mb_wfs_availability,mb_user_abo_ows WHERE mb_wfs_availability.fkey_wfs_id=mb_user_abo_ows.fkey_wfs_id AND mb_user_abo_ows.fkey_mb_user_id=$1"; $res = db_prep_query($sql, array($user->id), array("i")); $cnt = 0; $wfs = array(); while(db_fetch_row($res)){ $wfs[$cnt] = db_result($res,$cnt,"fkey_wfs_id"); $cnt++; } $status = array(); $upload_id = array(); for ($i=0; $i"; $wfs_id[$wfs[$i]] = $wfs[$i]; $sql = "SELECT fkey_upload_id, last_status, status_comment, upload_url, availability, average_resp_time FROM mb_wfs_availability "; $sql .= "WHERE fkey_wfs_id = $1"; $v = array($wfs_id[$wfs[$i]]); $t = array('i'); $res = db_prep_query($sql,$v,$t); $avg_response_time[$wfs[$i]] = round(db_result($res,0,"average_resp_time"),1); $status[$wfs[$i]] = intval(db_result($res,0,"last_status")); $comment[$wfs[$i]] = db_result($res,0,"status_comment"); $upload_url[$wfs[$i]] = db_result($res,0,"upload_url"); $percentage[$wfs[$i]]=db_result($res,0,"availability"); $upload_id[$wfs[$i]] = db_result($res,0,"fkey_upload_id"); //$image[$wms[$i]] =db_result($res,0,"image"); //$map_url[$wfs[$i]] =db_result($res,0,"map_url"); } $newArray = $status; if ($_GET['sortby']) { if ($_GET['sortby'] == "wfs") { $newArray = $wfs_id; asort($newArray); } elseif ($_GET['sortby'] == "status") { $newArray = $status; asort($newArray); } elseif ($_GET['sortby'] == "avgresp") { $newArray = $avg_response_time; asort($newArray); } elseif ($_GET['sortby'] == "avail") { $newArray = $percentage; arsort($newArray); } elseif ($_GET['sortby'] == "last") { $newArray = $upload_id; arsort($newArray); } } $str .= "

\n\t"; $str .= ""; $str .= ""; $str .= "";//Verfügbarkeit Dienstebeschreibung $str .= "";//Durchschnittliche Antwortzeit Beschreibung $str .= "";//Verfügbarkeit (2 Monate) $cnt = 0; foreach ($newArray as $k => $value) { $img = "stop.png"; $img_map = "nopicture.png"; if ($status[$k]==0) $img = "wait.png"; elseif ($status[$k]==1) $img = "go.png"; //if ($image[$k]==1) $img_map = "picture.png"; if ($updated[$k] == "0" && $status[$k] == 0) $fill = "checked"; else $fill = "disabled"; if (fmod($cnt, 2) == 1) { $str .= "\n\t\t"; } else { $str .= "\n\t\t"; } $str .= "\n\t\t\t"; $str .= "\n\t\t\t";//Aufruf des Capabilities Dokument $str .= "\n\t\t\t"; $str .= "\n\t\t\t"; /*$str .= "\n\t\t\t";*/ //$str .= "\n\t\t\t"; $str .= "\n\t\t"; $cnt++; } $str .= "\n\t

"._mb("WebFeatureService")."

"._mb("Availability of Capabilities")."

"._mb("Average Response Time for GetCapabilities")."

"._mb("Availability (2 month)")."

"._mb("Service ID").": ".$wfs_id[$k]."
".$admin->getWfsTitleByWfsId($wfs_id[$k])."