<?php
session_start();
?>
<?php require_once('Connections/osense.php'); ?>
<?php
#mysql_select_db($database_osense, $osense);
$query_Recordset1 = "SELECT * FROM statustable";
#$Recordset1 = mysql_query($query_Recordset1, $osense) or die(mysql_error());
	$Recordset1 = mysqli_query($osense,$query_Recordset1 );
#$row_Recordset1 = mysql_fetch_assoc($Recordset1);
	$row_Recordset1 = mysqli_fetch_assoc($Recordset1);
#$totalRows_Recordset1 = mysql_num_rows($Recordset1);
	$totalRows_Recordset1 = mysqli_num_rows($Recordset1);

//mysql_select_db($database_osense, $osense);
$query_Recordset2 = "SELECT * FROM iptable WHERE node_up = 0 ORDER BY node_id ASC";
#$Recordset2 = mysql_query($query_Recordset2, $osense) or die(mysql_error());
	$Recordset2 = mysqli_query($osense,$query_Recordset2 );
#$row_Recordset2 = mysql_fetch_assoc($Recordset2);
	$row_Recordset2 = mysqli_fetch_assoc($Recordset2);
#$totalRows_Recordset2 = mysql_num_rows($Recordset2);
	$totalRows_Recordset2 = mysqli_num_rows($Recordset2);

$query_lsense = "SELECT * FROM iptable, lightsense where (iptable.node_id=lightsense.node_id) ORDER BY lightsense.node_no ASC";
#$lsense = mysql_query($query_lsense, $osense) or die(mysql_error());
	$lsense = mysqli_query( $osense,$query_lsense);
#$row_lsense = mysql_fetch_assoc($lsense);
	$row_lsense = mysqli_fetch_assoc($lsense);
#$totalRows_lsense = mysql_num_rows($lsense);
	$totalRows_lsense = mysqli_num_rows($lsense);
$critical=1;
?>
<html>
<head>
<title>NetEye Health Monitor</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.style1 {
	font-size: xx-large;
	font-weight: bold;
	color: #336666;
}
.border {
	border: medium solid #336666;
}
.con {background-color:#669966;}
.coff {background-color:#FF3333;}
-->
</style>
<link rel="stylesheet" type="text/css" href="sdmenu/sdmenu.css" />
<script type="text/javascript" src="sdmenu/sdmenu.js"></script>
<script type="text/javascript" src="jquery-1.2.2.pack.js"></script>
<link rel="stylesheet" type="text/css" href="featuredcontentglider.css" />
<link rel="stylesheet" type="text/css" href="cssbuttonstoggler.css" />
<script type="text/javascript" src="featuredcontentglider.js">

	<script type="text/javascript">
	// <![CDATA[
	var myMenu;
	window.onload = function() {
		myMenu = new SDMenu("my_menu");
		myMenu.init();
	};
	// ]]>
	</script>
</head>

<body>
<table width="1000" height="736" align="center" class="border">
  <tr>
    <td width="157"><div align="center"><img src="wname.jpg" width="150"><span class="style1"> </span></div></td>
    <td width="672"><div align="center"><span class="style1">NetEye</span></div></td>
    <td width="149"><span class="style1"><img src="wicon.jpg"></span></td>
  </tr>
  <tr height="640">
    <td width="157">
	<div style="float: left" id="my_menu" class="sdmenu">
      <div>
        <span>NetEye</span>
        <a href="home.php">Home</a>
        <a href="topology.php">Topology</a>
		<!--a href="registration.php">Registration Form</a-->
		
      </div>
      <div>
        <span>MySpace</span>
        <?php
	if ($_SESSION['ilog']!="yes")
		{
		?> 
		<a href="login.php">Login</a>
		<?php
		}
		else
		{
		?> 
		<a href="sjobs.php">Schedule jobs</a>
        <a href="myjobs.php">Manage jobs</a>
        <a href="nodebusy.php">Doctor (node status)</a>
        <a href="cnodegrp1.php">Create node group</a>
        <a href="logout.php">Logout</a>
       <!--a href="sjobs1.php">Schedule new tier2 jobs</a-->
        <!--a href="myjobs1.php">Manage tier2 jobs</a-->
		<?php
		}
		?> 
      </div>
      <div class="">
        <span>Support</span>
        <a href=http://www.cs.wayne.edu/~hzhang/group/index.html>DNC Research Group</a>
      </div>

    </div>
	</td>
	<td colspan="2">
	<table align="center"><tr><td>
	<script type="text/javascript">
	featuredcontentglider.init({
		gliderid: "canadaprovinces", //ID of main glider container
		contentclass: "glidecontent", //Shared CSS class name of each glider content
		togglerid: "p-select", //ID of toggler container
		selected: 0, //Default selected content index (0=1st)
		persiststate: false, //Remember last content shown within browser session (true/false)?
		speed: 500, //Glide animation duration (in milliseconds)
		direction: "downup", //set direction of glide: "updown", "downup", "leftright", or "rightleft"
		autorotate: true, //Auto rotate contents (true/false)?
		autorotateconfig: [5000, 5] //if auto rotate enabled, set [milliseconds_btw_rotations, cycles_before_stopping]
	})
	
	</script>
	
	<div id="canadaprovinces" class="glidecontentwrapper">
	<div class="glidecontent" align="center">
	<br><strong>Health Summary</strong></span><br><br>
	<table border="1" align="center">
  	<tr bgcolor="#66CC00">
	<td>Motes Up:&nbsp; </td>
	<td> <?php echo $row_Recordset1['nodes_up']; ?>&nbsp; </td>
	</tr>
	<tr bgcolor="#FF0000">
	<td>Motes Down:&nbsp; </td>
	<td> <?php echo $row_Recordset1['nodes_down']; ?>&nbsp; </td>
	</tr>
	<!--tr bgcolor="#66CC00">
	<td>Tier 2 Nodes Up:&nbsp; </td>
	<td> <?php echo $row_Recordset1['tnodes_up']; ?>&nbsp; </td>
	</tr-->
	<!--tr bgcolor="#FF0000">
	<td>Tier 2 Nodes Down:&nbsp; </td>
	<td> <?php echo $row_Recordset1['tnodes_down']; ?>&nbsp; </td>
	</tr-->
	<tr bgcolor="#66CC00">
	<td>Motes Free:&nbsp; </td>
	<td> <?php echo $row_Recordset1['nodes_free']; ?>&nbsp; </td>
	</tr>
	<tr bgcolor="#FF0000">
	<td>Motes Busy:&nbsp; </td>
	<td> <?php echo $row_Recordset1['nodes_busy']; ?>&nbsp; </td>
	</tr>
	<!--tr bgcolor="#66CC00">
	<td>Tier 2 Nodes Free:&nbsp; </td>
	<td> <?php echo $row_Recordset1['tnodes_free']; ?>&nbsp; </td>
	</tr-->
	<!--tr bgcolor="#FF0000">
	<td>Tier 2 Nodes Busy:&nbsp; </td>
	<td> <?php echo $row_Recordset1['tnodes_busy']; ?>&nbsp; </td>
	</tr-->
	<tr  bgcolor="#66CC00">
	<td>Jobs Running:&nbsp; </td>
	<td> <?php echo $row_Recordset1['t1jobs_run']; ?>&nbsp; </td>
	</tr>
	<tr bgcolor="#FF0000">
	<td>Jobs Pending:&nbsp; </td>
	<td> <?php echo $row_Recordset1['t1jobs_pend']; ?>&nbsp; </td>
	</tr>
	<!--tr bgcolor="#66CC00">
	<td>Tier 2 Jobs Running:&nbsp; </td>
	<td> <?php echo $row_Recordset1['t2jobs_run']; ?>&nbsp; </td>
	</tr-->
	<!--tr bgcolor="#FF0000">
	<td>Tier 2 Jobs Pending:&nbsp; </td>
	<td> <?php echo $row_Recordset1['t2jobs_pend']; ?>&nbsp; </td>
	</tr-->
	<tr bgcolor="#66CC00">
	<td>Jobs completed in last 24 hours:&nbsp; </td>
	<td> <?php echo $row_Recordset1['jlessday']; ?>&nbsp; </td>
	</tr>
        <tr bgcolor="#FF0000">
	<td>Jobs completed in past week:&nbsp; </td>
	<td> <?php echo $row_Recordset1['jlessweek']; ?>&nbsp; </td>
	</tr>
	</table>
	</div>

	<div class="glidecontent" align="center">
	<span align="center"><strong>Nodes Health Status</strong></span><br><br>
	<table width="250" height="302" border="1" align="center">
        <tr>
          <td>&nbsp;</td>
          <td>0</td>
          <td>1</td>
          <td>2</td>
          <td>3</td>
          <td>4</td>
          <td>5</td>
          <td>6</td>
          <td>7</td>
          <td>8</td>
          <td>9</td>
          <td>10</td>
          <td>11</td>
          <td>12</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td>0</td>
		  <?php 
		  $i=1;
		  do {
		  $j=($i/13)-1; 
		  if ($i>13)
		  {
		  if (($i%13)==1)
		  {
		  echo "<td>".round($j+1)."</td>";
		  }
		  }
		  
		  if ($row_lsense['node_up']<$critical)
		  { 
		  echo "<td><div align='center' class='coff'> ".($i-1).""."</div></td>";
		  }
		 else 
		 {
		 echo "<td><div align='center' class='con'>".($i-1).""."</div></td>"; 
		 }
          
		  if (($i%13)==0)
		  {
		  echo "<td>".$j."</td></tr><tr>";
		  }
		  $i=$i+1;
		  } while ($row_lsense = mysqli_fetch_assoc($lsense)); ?>
		
	      <td>&nbsp;</td>
          <td>0</td>
          <td>1</td>
          <td>2</td>
          <td>3</td>
          <td>4</td>
          <td>5</td>
          <td>6</td>
          <td>7</td>
          <td>8</td>
          <td>9</td>
          <td>10</td>
          <td>11</td>
          <td>12</td>
          <td>&nbsp;</td>
        </tr>
      </table>
	<br><span align="left"><strong>Red - nodes down</strong></span>
	<br><span align="left"><strong>Green - nodes up</strong></span>
	</div>
	
	<div class="glidecontent">
	<table border="1" bordercolor="#FF0000" align="center">
	<tr><td bgcolor="#FF0000">Nodes Down</td></tr>
	
	  <?php do { ?>
	  <?php
	  echo "<tr><td>".$row_Recordset2['node_id']."</td></tr>";
	  ?>
	  <?php } while ($row_Recordset2 = mysqli_fetch_assoc($Recordset2)); ?>
	
	</table>
	</div>
	
	</div>
	
	<div id="p-select" class="cssbuttonstoggler"> 
	<a href="#" class="toc"><span>Health Summary</span></a> <a href="#" class="toc"><span>Nodes Health Status</span></a> <a href="#" class="toc"><span>Nodes Down</span></a>
	<a href="#" class="prev"><span>Back</span></a> <a href="#" class="next"><span>Foward</span></a>
	</div>
	</td></tr>
	</table>
	</td>
  </tr>
</table>
</body>
</html>
<?php
mysqli_free_result($Recordset1);

mysqli_free_result($Recordset2);
?>
