$img = "wait.bmp";
} elseif ($status[$k] == 1) {
$img = "go.bmp";
}
if ($updated[$k] == "0" && $status[$k] == 0) {
$fill = "checked";
} else {
$fill = "disabled";
}
if (fmod($cnt, 2) == 1) {
$str .= "\n\t\t<tr bgcolor='#e6e6e6'>";
} else {
$str .= "\n\t\t<tr bgcolor='#f0f0f0'>";
}
$str .= "\n\t\t\t<td><input name='cb" . $cnt . "' value='" . $wms_id[$k] . "' type=checkbox " . $fill . " /><input type=hidden name='upl_id" . $cnt . "' value='" . $upload_id[$k] . "'></td>";
$str .= "\n\t\t\t<td valign='top'><b>" . $wms_id[$k] . "</b><br>" . $admin->getWmsTitleByWmsId($wms_id[$k]) . "</td>";
$str .= "\n\t\t\t<td valign='top'><a href='" . $upload_url[$k] . "' target=_blank><img title='Connect to service' border=0 src = '../img/trafficlights/" . $img . "'></a></td>";
$str .= "\n\t\t\t<td valign='top'>" . $comment[$k] . "<br><div style='font-size:12'>" . date("F j, Y, G:i:s", $upload_id[$k]) . "</div></td>";
$str .= "\n\t\t\t<td valign='top'>";
$str .= "<table bgcolor='black' border=1 cellspacing=1 cellpadding=0><tr><td height=20 width=20 align=center valign=middle bgcolor='";
if ($image[$k] == -1) {
$str .= "red";
} elseif ($image[$k] == 0) {
$str .= "yellow";
} elseif ($image[$k] == 1) {
$str .= "green";
}
if ($image[$k] != -1) {
$str .= "'><a href='" . $mapurl[$k] . "'>o</a></td></tr></table></td>";
} else {
$str .= "'><a href='" . $mapurl[$k] . "'>x</a></td></tr></table></td>";
$owner_ids = $admin->getOwnerByWms($myWMS);
if ($owner_ids && count($owner_ids) > 0) {
$owner_mail_addresses = array();
$j = 0;
for ($i = 0; $i < count($owner_ids); $i++) {
$adr_tmp = $admin->getEmailByUserId($owner_ids[$i]);
if (!in_array($adr_tmp, $owner_mail_addresses) && $adr_tmp) {
$owner_mail_addresses[$j] = $adr_tmp;
$j++;
}
}
$replyto = $admin->getEmailByUserId(Mapbender::session()->get("mb_user_id"));
$from = $replyto;
$pathArray = explode("http/php/", $_SERVER["PATH_TRANSLATED"]);
$path = $pathArray[0];
$body = "WMS '" . $admin->getWmsTitleByWmsId($myWMS) . "' has been updated. \n\nServer name: " . $_SERVER["SERVER_NAME"] . "\nInstallation Path: " . $path . "\n\nYou may want to check the changes as you are an owner of this WMS.";
$error_msg = "";
for ($i = 0; $i < count($owner_mail_addresses); $i++) {
if (!$admin->sendEmail($replyto, $from, $owner_mail_addresses[$i], $owner_mail_addresses[$i], "[Mapbender] A user has updated one of your WMS", $body, $error)) {
if ($error) {
$error_msg .= $error . " ";
}
}
}
if (!$error_msg) {
echo "<script language='javascript'>";
echo "alert('Other owners of this WMS have been informed about the changes!');";
echo "</script>";
} else {
echo "<script language='javascript'>";
echo "alert('When notifying the owners of this WMS about your changes, an error occured: ' + '" . $error_msg . "');";
} else {
$status_price = 0;
}
$auth = $admin->getAuthInfoOfWMS($ownwms[$i]);
if ($auth['auth_type'] == '') {
$status_auth = 0;
} else {
$status_auth = 1;
}
echo "<tr>";
echo "<td>" . $ownwms[$i] . "</td>";
echo "<td";
if ($status_auth == 1) {
echo " bgcolor=\"#FF0000\"";
}
echo ">" . $admin->getWmsTitleByWmsId($ownwms[$i]);
echo "<td>";
#for owsproxy
echo "<input type='checkbox' id='wms_" . $ownwms[$i] . "_proxy' name='wms_" . $ownwms[$i] . "_proxy' onclick='if(this.checked){document.getElementById(\"wms_\"+" . $ownwms[$i] . "+\"_log\").disabled=false;document.getElementById(\"wms_\"+" . $ownwms[$i] . "+\"_price\").disabled=true;document.getElementById(\"status_\"+" . $ownwms[$i] . "+\"_proxy\").value=\"1\"}else{document.getElementById(\"wms_\"+" . $ownwms[$i] . "+\"_log\").checked=false;document.getElementById(\"wms_\"+" . $ownwms[$i] . "+\"_log\").disabled=true;document.getElementById(\"wms_\"+" . $ownwms[$i] . "+\"_price\").disabled=true;document.getElementById(\"wms_\"+" . $ownwms[$i] . "+\"_price\").value=\"0\";document.getElementById(\"status_\"+" . $ownwms[$i] . "+\"_proxy\").value=\"0\";document.getElementById(\"status_\"+" . $ownwms[$i] . "+\"_log\").value=\"0\"}'";
#default
if ($status_proxy == 1) {
echo " checked";
} else {
echo " unchecked";
}
//if a proxy string is set
if ($status_auth == 1) {
echo " disabled";
}
echo ">";
#initialize hidden field for status proxy:
$upload_id[$cnt] = db_result($res, $cnt, "upload_id");
$status[$cnt] = intval(db_result($res, $cnt, "status"));
$comment[$cnt] = db_result($res, $cnt, "status_comment");
$timestamp_begin = db_result($res, $cnt, "timestamp_begin");
$timestamp_end = db_result($res, $cnt, "timestamp_end");
$upload_url[$cnt] = db_result($res, $cnt, "upload_url");
if ($status[$cnt] == '0' || $status[$cnt] == '1') {
$response_time[$cnt] = strval($timestamp_end - $timestamp_begin) . " s";
} else {
$response_time[$cnt] = "n/a";
}
$cnt++;
}
$str = "<span style='font-size:30'>" . _mb("Monitoring results") . "</span><hr><br>\n";
//Monitoring Ergebnisse
$str .= "<b>" . $wms_id . "</b><br>" . $admin->getWmsTitleByWmsId($wms_id) . "<br><br><br>\n";
$str .= "<table cellpadding=10 cellspacing=0 border=0>";
$str .= "<tr bgcolor='#dddddd'><th align='left'>date</th><th align='left' colspan = 2>" . _mb("Status") . "</th><th align='center'>" . _mb("Response time") . "</th></tr>";
//Status Antwortzeit
for ($k = 0; $k < count($upload_id); $k++) {
$img = "stop.png";
if ($status[$k] == 0) {
$img = "wait.png";
} elseif ($status[$k] == 1) {
$img = "go.png";
}
if (fmod($k, 2) == 1) {
$str .= "\n\t\t<tr bgcolor='#e6e6e6'>";
} else {
$str .= "\n\t\t<tr bgcolor='#f0f0f0'>";
}
if (!in_array($row["md_topic_category_id"], $topic_id_layer)) {
array_push($topic_id, $row["md_topic_category_id"]);
array_push($topic_name, $row["md_topic_category_code_" . $language_suffix]);
}
}
/*INSERT HTML*/
echo "<form name='form1' action='" . $self . "' method='post'>";
/*insert wms in selectbox*************************************************************************/
echo "<div class='text1'>WMS: </div>";
echo "<select style='background:#ffffff' class='select1' name='selected_wms' onChange='submit()' size='10'>";
for ($i = 0; $i < count($own_wms_id_array); $i++) {
echo "<option value='" . $own_wms_id_array[$i] . "' ";
if ($selected_wms && $selected_wms == $own_wms_id_array[$i]) {
echo "selected";
}
echo ">" . $admin->getWmsTitleByWmsId($own_wms_id_array[$i]) . "</option>";
}
echo "</select>";
/*insert wms in selectbox*************************************************************************/
echo "<div class='text2'>Layer: </div>";
echo "<select style='background:#ffffff' class='select2' name='selected_layer' onChange='submit()' size='10'>";
for ($i = 0; $i < count($own_layer_id_array); $i++) {
echo "<option value='" . $own_layer_id_array[$i] . "' ";
if ($selected_layer && $selected_layer == $own_layer_id_array[$i]) {
echo "selected";
}
echo ">" . $admin->getLayerTitleByLayerId($own_layer_id_array[$i]) . "</option>";
}
echo "</select>";
/*insert all groups in selectbox*******************************************************************/
echo "<div class='text3'>TOPICS:</div><br>";
// push into problematic array
if ($status == '-1' or $status == '-2') {
$status_comment = "Monitoring process timed out.";
$status = '-1';
array_push($problemOWS, $wms_id_own[$k]);
array_push($commentProblemOWS, $status_comment);
}
$v = array('0', intval($status), intval($image), $status_comment, (string) intval($timestamp_end), $map_url, (string) intval($timestamp_begin), $cap_diff, (string) $time, $wms_id_own[$k]);
$t = array('s', 'i', 'i', 's', 's', 's', 's', 's', 's', 's');
$res = db_prep_query($sql, $v, $t);
}
$body = "";
echo "\nmonitoring info in db for user: "******"\n";
//loop for single monitor requests that has problems
for ($i = 0; $i < count($problemOWS); $i++) {
$body .= $br . $admin->getWmsTitleByWmsId($problemOWS[$i]) . " (" . $problemOWS[$i] . "): " . $commentProblemOWS[$i] . $br;
}
unset($problemOWS);
unset($commentProblemOWS);
//end of loop for single monitor requests
// Send an email to the user if body string exists
if ($body) {
$error_msg = "";
if ($admin->getEmailByUserId($userid)) {
$admin->sendEmail(MAILADMIN, MAILADMINNAME, $admin->getEmailByUserId($userid), $user, "Mapbender monitoring report " . date("F j, Y, G:i:s", $time), utf8_decode($body), &$error_msg);
} else {
$error_msg = "Email address of user '" . $admin->getUserNameByUserId($userid) . "' unknown!\n";
}
if ($error_msg) {
echo "\n ERROR: " . $error_msg;
}
$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<tr bgcolor='#e6e6e6'>";
} else {
$str .= "\n\t\t<tr bgcolor='#f0f0f0'>";
}
$str .= "\n\t\t\t<td valign='top'><a href='../php/mod_showMetadata.php?resource=layer&id=" . $layer_id[$k] . "&subscribe=1' onclick='var metadataWindow=window.open(this.href,'" . _mb("Metadata") . "','width=500,height=600,left=100,top=200,scrollbars=yes ,dependent=yes'); metadataWindow.focus();newWindow.href.location='test.php'; >" . _mb("Service ID") . ": " . $wms_id[$k] . "</a><br>" . $admin->getWmsTitleByWmsId($wms_id[$k]) . "</td>";
$str .= "\n\t\t\t<td valign='top'><a href='" . $upload_url[$k] . "' target=_blank><img title='" . _mb("Request GetCapabilities") . "' border=0 src = '../img/trafficlights/" . $img . "'></a></td>";
//Aufruf des Capabilities Dokument
$str .= "\n\t\t\t<td valign='top'>" . $comment[$k] . "<br><div style='font-size:12'>" . date("F j, Y, G:i:s", $upload_id[$k]) . "</div></td>";
$str .= "\n\t\t\t<td valign='top' align = 'left'>";
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 .= "</td>";
$str .= "\n\t\t\t<td valign='top'>";
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";
if (fmod($cnt, 2) == 1) {
$str .= "\n\t\t<tr bgcolor='#e6e6e6'>";
} else {
$str .= "\n\t\t<tr bgcolor='#f0f0f0'>";
}
#generieren der checkboxen für jeden wms namen: cb123, wert 123, der andere input fuer upl_id123 mit wert des upload_ids aus der monitor tabelle - unnoetig
$str .= "\n\t\t\t<td><input name='cb" . $cnt . "' value='" . $wms_id[$k] . "' type=checkbox />";
#<input type=hidden name='upl_id".$cnt."' value='".$upload_id[$k]."'>
$str .= "</td>";
$str .= "\n\t\t\t<td valign='top'><a href='../php/mod_showMetadata.php?resource=layer&id=" . $layer_id[$k] . "' onclick='window.open(this.href,'Metadaten','width=500,height=600,left=100,top=200,scrollbars=yes ,dependent=yes'); return false' target='_blank' >Dienst ID: " . $wms_id[$k] . "</a><br>" . $admin->getWmsTitleByWmsId($wms_id[$k]) . "</td>";
#$str .= "\n\t\t\t<td valign='top'><b>" . $wms_id[$k] . "</b><br>" . $admin->getWmsTitleByWmsId($wms_id[$k]) . "</td>";
$str .= "\n\t\t\t<td valign='top'><a href='" . $upload_url[$k] . "' target=_blank><img title='Connect to service' border=0 src = '../img/trafficlights/" . $img . "'></a></td>";
$str .= "\n\t\t\t<td valign='top'>" . $comment[$k] . "<br><div style='font-size:12'>" . date("F j, Y, G:i:s", $upload_id[$k]) . "</div></td>";
$str .= "\n\t\t\t<td valign='top' align = 'left'>";
if ($avg_response_time[$k] == NULL) {
$str .= "n/a";
} else {
$str .= $avg_response_time[$k] . " s";
}
$str .= "</td>";
$str .= "\n\t\t\t<td valign='top'><b>" . $percentage[$k] . " %</b> <span style='font-size:12'>(" . $total[$k] . " cycles)</span><br>";
$str .= "<table bgcolor='black' border=1 cellspacing=1 cellpadding=0><tr>";
$val = $percentage[$k];
for ($i = 0; $i < 10; $i++) {
if ($val >= 10) {
