<?php session_start(); ?>
<?php require_once('Connections/osense.php'); ?>
<?php
$currentPage = $_SERVER["PHP_SELF"];

$maxRows_regmanage = 10;
$pageNum_regmanage = 0;
if (isset($_GET['pageNum_regmanage'])) {
  $pageNum_regmanage = $_GET['pageNum_regmanage'];
}
$startRow_regmanage = $pageNum_regmanage * $maxRows_regmanage;

#mysql_select_db($database_osense, $osense);
$query_regmanage = "SELECT * FROM registration";
$query_limit_regmanage = sprintf("%s LIMIT %d, %d", $query_regmanage, $startRow_regmanage, $maxRows_regmanage);
$regmanage = mysqli_query($osense,$query_limit_regmanage);# or die(mysql_error());
$row_regmanage = mysqli_fetch_assoc($regmanage);

if (isset($_GET['totalRows_regmanage'])) {
  $totalRows_regmanage = $_GET['totalRows_regmanage'];
} else {
  $all_regmanage = mysqli_query($osense,$query_regmanage);
  $totalRows_regmanage = mysqli_num_rows($all_regmanage);
}
$totalPages_regmanage = ceil($totalRows_regmanage/$maxRows_regmanage)-1;

$queryString_regmanage = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_regmanage") == false && 
        stristr($param, "totalRows_regmanage") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_regmanage = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_regmanage = sprintf("&totalRows_regmanage=%d%s", $totalRows_regmanage, $queryString_regmanage);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Manage Registration</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;
}
-->
</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="logout.php">Logout</a-->
		<?php
		}
		?> 
		<a href="sjobs.php">Schedule jobs</a>
        <a href="myjobs.php">Manage jobs</a>
        <a href="nodebusy.php">Check nodes busy</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-->
      </div>
      <div>
        <span>AdminSpace</span>
		<a href="inlogadd.php">Create Users</a>
		<a href="regman.php">Manage Registration</a>
      </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"><div align="center"><strong>Welcome Admin</strong></div>
	  <br>
	<table border="0" width="50%" align="center">
  <tr>
    <td width="23%" align="center">
      <?php if ($pageNum_regmanage > 0) { // Show if not first page ?>
      <a href="<?php printf("%s?pageNum_regmanage=%d%s", $currentPage, 0, $queryString_regmanage); ?>">First</a>
      <?php } // Show if not first page ?>
    </td>
    <td width="31%" align="center">
      <?php if ($pageNum_regmanage > 0) { // Show if not first page ?>
      <a href="<?php printf("%s?pageNum_regmanage=%d%s", $currentPage, max(0, $pageNum_regmanage - 1), $queryString_regmanage); ?>">Previous</a>
      <?php } // Show if not first page ?>
    </td>
    <td width="23%" align="center">
      <?php if ($pageNum_regmanage < $totalPages_regmanage) { // Show if not last page ?>
      <a href="<?php printf("%s?pageNum_regmanage=%d%s", $currentPage, min($totalPages_regmanage, $pageNum_regmanage + 1), $queryString_regmanage); ?>">Next</a>
      <?php } // Show if not last page ?>
    </td>
    <td width="23%" align="center">
      <?php if ($pageNum_regmanage < $totalPages_regmanage) { // Show if not last page ?>
      <a href="<?php printf("%s?pageNum_regmanage=%d%s", $currentPage, $totalPages_regmanage, $queryString_regmanage); ?>">Last</a>
      <?php } // Show if not last page ?>
    </td>
  </tr>
</table><br>	<table border="1" align="center">
  <tr>
    <td>rID</td>
    <td>First Name</td>
    <td>Last Name</td>
    <td>Academic Institution</td>
    <td>Student (Y/N) </td>
	<td>Email</td>
    <td>Student Advisor</td>
    <td>Status</td>
  </tr>
  <?php do { ?>
  <tr>
    <td> <a href="regmandetail.php?recordID=<?php echo $row_regmanage['rID']; ?>"> <?php echo $row_regmanage['rID']; ?>&nbsp; </a> </td>
    <td> <?php echo $row_regmanage['FirstName']; ?>&nbsp; </td>
    <td> <?php echo $row_regmanage['LastName']; ?>&nbsp; </td>
    <td> <?php echo $row_regmanage['Institution']; ?>&nbsp; </td>
    <td> <?php echo $row_regmanage['Student']; ?>&nbsp; </td>
	<td> <?php echo $row_regmanage['Email']; ?>&nbsp; </td>
    <td> <?php echo $row_regmanage['Advisor']; ?>&nbsp; </td>
    <td> 
	<?php 
	if ($row_regmanage['Status'] == "Pending") {
	   echo "<a href='cusers.php?rID=".$row_regmanage['rID']."'>".$row_regmanage['Status']."</a>"; 
	}
	else  { 
	   echo $row_regmanage['Status'];
	} ?>
	</td>
  </tr>
  <?php } while ($row_regmanage = mysqli_fetch_assoc($regmanage)); ?>
</table>
    <div align="center"><br>
  Records <?php echo ($startRow_regmanage + 1) ?> to <?php echo min($startRow_regmanage + $maxRows_regmanage, $totalRows_regmanage) ?> of <?php echo $totalRows_regmanage ?>
    </div></td>
  </tr>
</table>
<p>&nbsp;</p>
</body>
</html>
<?php
mysqli_free_result($regmanage);
?>
