'.$testMatch.' is not valid.
'; echo 'Parameter serviceType is not valid (wms, wfs).
'; die(); } $serviceType = $testMatch; $testMatch = NULL; } $serviceType= strtoupper($serviceType); //TODO: Check wether request parameters cannot be found! Since this is not handled, update will not be available! require_once(dirname(__FILE__)."/../php/mb_validatePermission.php"); require_once(dirname(__FILE__)."/../classes/class_wms.php"); ?> '; ?> id) { echo "
Skipped: " . $upd_wmsid . "
"; continue; } // update WMS from upload URL $mywms = new wms(); $result = $mywms->createObjFromXML($uploadUrl); if (!$result['success']) { //echo $result['message']; //do nothing first - TODO give negative result! //die(); } else { $mywms->optimizeWMS(); echo "
"; if (!MD_OVERWRITE) { $mywms->overwrite=false; } //possibility to see update information in georss and/or twitter channel if(empty($_POST['twitter_news'])) { $mywms->twitterNews = false; } if(empty($_POST['rss_news'])) { $mywms->setGeoRss = false; } $mywms->updateObjInDB($upd_wmsid); echo "
Updated: " . $upd_wmsid . "
"; } /* // start new monitoring for this WMS $now = time(); $sql = "UPDATE mb_monitor SET status = '-2', status_comment = 'Monitoring is still in progress...', " . "timestamp_begin = $1, timestamp_end = $2 WHERE upload_id = $3 AND fkey_wms_id = $4"; $v = array($now, $now, $upload_id, $upd_wmsid); $t = array('s', 's', 's', 'i'); $res = db_prep_query($sql,$v,$t); $currentFilename = "wms_monitor_report_" . $upload_id . "_" . $upd_wmsid . "_" . $wmsOwner . ".xml"; $exec = PHP_PATH . "php5 ../../tools/mod_monitorCapabilities_write.php " . $currentFilename. " 0"; echo exec(escapeshellcmd($exec)); */ } echo "
Please note: The updated services need to be monitored again in order to update the database.

"; } break; case "WFS": $checkboxes = intval($_POST['cbs']); for ($i=0; $i < $checkboxes; $i++) { echo $i; if (!isset($_POST['cb'.$i]) || !isset($_POST['upl_id'.$i]) ) { continue; } $upd_wfsid = intval($_POST['cb'.$i]); $upload_id = intval($_POST['upl_id'.$i]); if ($upd_wfsid) { // get upload URL $sql = "SELECT wfs_upload_url, wfs_owner FROM wfs WHERE wfs_id = $1"; $v = array($upd_wfsid); $t = array("i"); $res = db_prep_query($sql, $v, $t); $row = db_fetch_array($res); $uploadUrl = $row["wfs_upload_url"]; $wfsOwner = $row["wfs_owner"]; if ($wfsOwner !== $user->id) { echo "
Skipped: " . $upd_wfsid . "
"; continue; } $id = $upd_wfsid; $url = $uploadUrl; //get authentication information from db $sql = "SELECT wfs_auth_type, wfs_username, wfs_password from wfs WHERE wfs_id = $1 "; $v = array($id); $t = array('i'); $res = db_prep_query($sql,$v,$t); $row = db_fetch_assoc($res); $auth['auth_type'] = $row["wfs_auth_type"]; $auth['username'] = $row["wfs_username"]; $auth['password'] = $row["wfs_password"]; $wfsFactory = new UniversalWfsFactory(); if ($auth['auth_type'] =='') { $auth = false; } $myWfs = $wfsFactory->createFromUrl($url, $auth); //if (!MD_OVERWRITE) { //if($obj->overwrite_md) { // $myWfs->overwrite = true; //} else { $myWfs->overwrite=false; //} $myWfs->id = $id; echo "
Updated: " . $upd_wfsid . "
"; /* // start new monitoring for this WMS $now = time(); $sql = "UPDATE mb_monitor SET status = '-2', status_comment = 'Monitoring is still in progress...', " . "timestamp_begin = $1, timestamp_end = $2 WHERE upload_id = $3 AND fkey_wms_id = $4"; $v = array($now, $now, $upload_id, $upd_wmsid); $t = array('s', 's', 's', 'i'); $res = db_prep_query($sql,$v,$t); $currentFilename = "wms_monitor_report_" . $upload_id . "_" . $upd_wmsid . "_" . $wmsOwner . ".xml"; $exec = PHP_PATH . "php5 ../../tools/mod_monitorCapabilities_write.php " . $currentFilename. " 0"; echo exec(escapeshellcmd($exec)); */ } echo "
Please note: The updated services need to be monitored again in order to update the database.

"; } break; } //$e = new mb_exception("mod_monitorCapabilities_read.php: userId: ".$_SESSION["mb_user_id"]); switch ($serviceType) { case "WMS": $sql = "SELECT mb_wms_availability.* FROM mb_wms_availability, wms " . "WHERE mb_wms_availability.fkey_wms_id = wms.wms_id AND wms.wms_owner = $1"; $res = db_prep_query($sql, array($_SESSION["mb_user_id"]), array("i")); break; case "WFS": $sql = "SELECT mb_wfs_availability.* FROM mb_wfs_availability, wfs " . "WHERE mb_wfs_availability.fkey_wfs_id = wfs.wfs_id AND wfs.wfs_owner = $1"; $res = db_prep_query($sql, array($_SESSION["mb_user_id"]), array("i")); break; } $wms = array(); $wms_id = array(); $wfs = array(); $wfs_id = array(); $upload_id = array(); $avg_response_time = array(); $comment = array(); $upload_url = array(); $updated = array(); $status = array(); while($row = db_fetch_array($res)){ switch ($serviceType) { case "WMS": $serviceId = $row["fkey_wms_id"]; $wms[] = $serviceId; $wms_id[$serviceId] = $serviceId; $mapurl[$serviceId] = $row["map_url"]; $image[$serviceId] = $row["image"]; break; case "WFS": $serviceId = $row["fkey_wfs_id"]; $wfs[] = $serviceId; $wfs_id[$serviceId] = $serviceId; break; } $status[$serviceId] = $row["last_status"]; $comment[$serviceId] = $row["status_comment"]; $average_resp_time[$serviceId] = $row["average_resp_time"]; $upload_url[$serviceId] = $row["upload_url"]; $updated[$serviceId] = $row["fkey_upload_id"]; $upload_id[$serviceId] = $row["fkey_upload_id"]; $cap_diff[$serviceId] = $row["cap_diff"]; $percentage[$serviceId] = $row["availability"]; $total[$serviceId] = $row["monitor_count"]; } $newArray = $status; if ($_GET['sortby']) { if ($_GET['sortby'] == "wms") { $newArray = $wms_id; asort($newArray); } 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); } elseif ($_GET['image'] == "last") { $newArray = $image; arsort($newArray); } } $script = $_SERVER["SCRIPT_NAME"]."?serviceType=".$_REQUEST['serviceType']."&guiID=".$gui_id."&"; $str = "monitoring results

\n"; $str .= "
\n\t"; $str .= "\n\t\n"; $str .= "\n\t\n

\n "; $str .= ""; switch ($serviceType) { case "WMS": $str .= ""; break; case "WFS": $str .= ""; break; } $str .= ""; switch ($serviceType) { case "WMS": $str .= ""; break; case "WFS": // break; } $str .= ""; $str .= ""; $cnt = 0; foreach ($newArray as $k => $value) { $img = "stop.bmp"; if ($status[$k]==0) $img = "wait.bmp"; elseif ($status[$k]==1) $img = "go.bmp"; if ($updated[$k] == "0" && $status[$k] == 0) $fill = "checked"; else $fill = "disabled"; //switch ($serviceType) { // case "WMS": if (fmod($cnt, 2) == 1) { $str .= "\n\t\t"; } else { $str .= "\n\t\t"; } // break; //} switch ($serviceType) { case "WMS": $str .= "\n\t\t\t"; $str .= "\n\t\t\t"; break; case "WFS": $str .= "\n\t\t\t"; $str .= "\n\t\t\t"; break; } $str .= "\n\t\t\t"; $str .= "\n\t\t\t"; //$str .= "\n\t\t\t"; if ($serviceType == "WMS") { $str .= "\n\t\t\t"; } else { $str .= "'>x
wms
wfscurrent statusimageavg. response timeoverall availabilityDiff
" . $wms_id[$k] . "
" . $admin->getWmsTitleByWmsId($wms_id[$k]) . "		" . $wfs_id[$k] . "
" . $admin->getWfsTitleByWfsId($wfs_id[$k]) . "		" . $comment[$k] . "
".date("F j, Y, G:i:s", $upload_id[$k])."
" . $comment[$k] . "
".$upload_id[$k]."
"; $str .= "
o
"; } } $str .= "\n\t\t\t"; if ($avg_response_time[$k] == NULL) { $str .= "n/a"; } else { $str .= $avg_response_time[$k] . " s"; } $str .= ""; $str .= "\n\t\t\t" . $percentage[$k] . " %  (" . $total[$k] . " cycles)
"; $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 .= "
"; switch ($serviceType) { case "WMS": $str .= "\n\t\t"; $str .= "\n\t\t\t"; if ($cap_diff[$k] != "" && $status[$k] == 0) $str .= ""; break; case "WFS": $str .= "\n\t\t"; $str .= "\n\t\t\t"; if ($cap_diff[$k] != "" && $status[$k] == 0) $str .= ""; break; } $str .= ""; $cnt++; } $str .= "\n\t\n\t
\n
"; echo $str; ?>