File: 0.02.12a/server/web/history.alert.php (View as HTML)

  1: <?php
  2: ob_start();
  3: require("include.php");
  4: $NATS->Start();
  5: if (!$NATS_Session->Check($NATS->DB))
  6: 	{
  7: 	header("Location: ./?login_msg=Invalid+Or+Expired+Session");
  8: 	exit();
  9: 	}
 10: if ($NATS_Session->userlevel<1) UL_Error("View Alert");
 11: ob_end_flush();
 12: Screen_Header("Alert History for ".$_REQUEST['nodeid'],1);
 13: ?>
 14: <br>
 15: <?php
 16: echo "<b class=\"minortitle\">Node Alerts for: <a href=node.php?nodeid=".$_REQUEST['nodeid'].">".$_REQUEST['nodeid']."</a></b><br><br>";
 17: 
 18: function dal($arow)
 19: {
 20: global $NATS;
 21: echo "<table border=0>";
 22: echo "<tr><td align=right><b>Alert : </b></td>";
 23: echo "<td align=left><b>".$arow['nodeid']."/".$arow['alertid']."</b></td></tr>";
 24: echo "<tr><td align=right>Opened : </td>";
 25: echo "<td align=left>".nicedt($arow['openedx'])."</td></tr>";
 26: 
 27: if ($arow['closedx']>0)
 28: 	{
 29: 	$st="<b class=\"al0\">Resolved</b>";
 30: 	$ct=nicedt($arow['closedx'])." (Open for ".nicediff($arow['closedx']-$arow['openedx']).")";
 31: 	}
 32: else
 33: 	{
 34: 	$st="<b>Open</b>";
 35: 	$ct="n/a";
 36: 	}
 37: 
 38: echo "<tr><td align=right>Status : </td>";
 39: echo "<td align=left>".$st."</td></tr>";
 40: echo "<tr><td align=right>Closed : </td>";
 41: echo "<td align=left>".$ct."</td></tr>";
 42: 
 43: echo "<tr><td align=right>Level : </td>";
 44: echo "<td align=left><b class=\"al".$arow['alertlevel']."\">".aText($arow['alertlevel'])."</td></tr>";
 45: 
 46: echo "<tr><td colspan=2>&nbsp;<br><b><u>Alert Log</u></b></td></tr>";
 47: 
 48: $hq="SELECT * FROM fnalertlog WHERE alertid=".$arow['alertid']." ORDER BY postedx DESC";
 49: $px=0;
 50: $first=true;
 51: $hr=$NATS->DB->Query($hq);
 52: while ($hrow=$NATS->DB->Fetch_Array($hr))
 53: 	{
 54: 	if ($hrow['postedx']!=$px) // first entry for that px
 55: 		{
 56: 		if (!$first) echo "</td></tr>"; // first ever px or not
 57: 		else $first=false;
 58: 		echo "<tr><td align=right valign=top>";
 59: 		$px=$hrow['postedx'];
 60: 		echo nicedt($px);
 61: 		echo " : ";
 62: 		echo "</td><td align=left valign=top>";
 63: 		}
 64: 	echo $hrow['logentry']."<br>";
 65: 	}
 66: if (!$first) echo "</td></tr>";
 67: 		
 68: 		
 69: echo "</table>";
 70: }
 71: 
 72: if (isset($_REQUEST['alertid']))
 73: 	{ // display this one
 74: 	$q="SELECT * FROM fnalert WHERE alertid=".ss($_REQUEST['alertid']);
 75: 	$r=$NATS->DB->Query($q);
 76: 	if ($row=$NATS->DB->Fetch_Array($r)) dal($row);
 77: 	else echo "<b>Error Fetching AlertID</b><br><br>";
 78: 	}
 79: else
 80: 	{ // see if one is open
 81: 	$q="SELECT * FROM fnalert WHERE nodeid=\"".ss($_REQUEST['nodeid'])."\" AND closedx=0";
 82: 	$r=$NATS->DB->Query($q);
 83: 	if ($row=$NATS->DB->Fetch_Array($r)) dal($row);
 84: 	// otherwise nothing open...
 85: 	}
 86: 	
 87: echo "<br><br>";
 88: echo "<b class=\"minortitle\">Alert History for ".$_REQUEST['nodeid']."</b><br><br>";
 89: // display history
 90: 
 91: $hq="SELECT * FROM fnalert WHERE nodeid=\"".ss($_REQUEST['nodeid'])."\" ORDER BY alertid DESC";
 92: $hr=$NATS->DB->Query($hq);
 93: //echo $hq;
 94: 
 95: echo "<table border=0>";
 96: while ($hrow=$NATS->DB->Fetch_Array($hr))
 97: 	{
 98: 	echo "<tr><td><a href=history.alert.php?alertid=".$hrow['alertid']."&nodeid=".$_REQUEST['nodeid'].">";
 99: 	echo $_REQUEST['nodeid']."/".$hrow['alertid'];
100: 	echo "</td></td>";
101: 	echo "<td>";
102: 	if ($hrow['closedx']<=0) echo "<b>Open</b>";
103: 	else echo "Resolved";
104: 	echo "</td>";
105: 	echo "<td>";
106: 	echo nicedt($hrow['openedx'])." - ";
107: 	if ($hrow['closedx']<=0) echo "n/a";
108: 	else echo nicedt($hrow['closedx']);
109: 	echo "</td>";
110: 	
111: 	echo "</tr>";
112: 	}
113: echo "</table>";
114: 
115: ?>
116: 
117: 
118: <?php
119: Screen_Footer();
120: ?>
121: