<?php
session_start();
?>
<?php require_once('Connections/osense.php'); ?>
<?php
//session_start();
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
//echo "hai";
//echo $_SESSION['MM_Username'];
//echo $_SESSION['Username'];
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) { 
  // For security, start by assuming the visitor is NOT authorized. 
  $isValid = False; 
 // echo "hai1";
  // When a visitor has logged into this site, the Session variable MM_Username set equal to their username. 
  // Therefore, we know that a user is NOT logged in if that Session variable is blank. 
  if (!empty($UserName)) { 
    // Besides being logged in, you may restrict access to only certain users based on an ID established when they login. 
    // Parse the strings into arrays.
	$isValid = true; 
    $arrUsers = Explode(",", $strUsers); 
    $arrGroups = Explode(",", $strGroups); 
    if (in_array($UserName, $arrUsers)) { 
      $isValid = true; 
    } 
    // Or, you may restrict access to only certain users based on their username. 
    if (in_array($UserGroup, $arrGroups)) { 
      $isValid = true; 
    } 
    if (($strUsers == "") && true) { 
      $isValid = true; 
    } 
  } 
  return $isValid; 
}

$MM_restrictGoTo = "login.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {   
  $MM_qsChar = "?";
  $MM_referrer = $_SERVER['PHP_SELF'];
  if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
  if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0) 
  $MM_referrer .= "?" . $QUERY_STRING;
  $MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
  header("Location: ". $MM_restrictGoTo); 
  exit;
}
?>
<?php
$currentPage = $_SERVER["PHP_SELF"];
//$_SESSION['MM_Username']="divya";
//echo $_SESSION['MM_Username'];
$maxRows_jtrak = 8;
$pageNum_jtrak = 0;
if (isset($_GET['pageNum_jtrak'])) {
  $pageNum_jtrak = $_GET['pageNum_jtrak'];
}
$startRow_jtrak = $pageNum_jtrak * $maxRows_jtrak;

$colname_jtrak = "1";
if (isset($_SESSION['MM_Username'])) {
  $colname_jtrak = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
}
#mysql_select_db($database_osense, $osense);
$query_jtrak = sprintf("SELECT * FROM jobtrack WHERE loginid = '%s' ORDER BY request_time DESC", $colname_jtrak);
// FIX me: ugly hack
if ($colname_jtrak == "dnc") {
    $query_jtrak = sprintf("SELECT * FROM jobtrack ORDER BY request_time DESC");
}
$query_limit_jtrak = sprintf("%s LIMIT %d, %d", $query_jtrak, $startRow_jtrak, $maxRows_jtrak);
$jtrak = mysqli_query( $osense,$query_limit_jtrak);# or die(mysql_error());
$row_jtrak = mysqli_fetch_assoc($jtrak);

if (isset($_GET['totalRows_jtrak'])) {
  $totalRows_jtrak = $_GET['totalRows_jtrak'];
} else {
  #$all_jtrak = mysql_query($query_jtrak);
	$all_jtrak = mysqli_query($osense,$query_jtrak);
  $totalRows_jtrak = mysqli_num_rows($all_jtrak);
}
$totalPages_jtrak = ceil($totalRows_jtrak/$maxRows_jtrak)-1;

$queryString_jtrak = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_jtrak") == false && 
        stristr($param, "totalRows_jtrak") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_jtrak = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_jtrak = sprintf("&totalRows_jtrak=%d%s", $totalRows_jtrak, $queryString_jtrak);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>manage jobs</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>

<script type="text/javascript" src="jquery-1.5.2.js"></script>

<link href="modals/SyntaxHighlighter.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="modals/shCore.js" language="javascript"></script>
<script type="text/javascript" src="modals/shBrushJScript.js" language="javascript"></script>
<script type="text/javascript" src="modals/ModalPopups.js" language="javascript"></script>

<script type="text/javascript">
    function ModalPopupsAlert99(url) {
       var go = url;
       ModalPopups.Alert("jsAlert99",
           "Node programming log information",
           "", {
               okButtonText: "Close",
               loadTextFile: go,
               width: 450,
               height: 300
           });                     
    }
</script>

<link rel="stylesheet" type="text/css" href="sdmenu/sdmenu.css" />
	<script type="text/javascript" src="sdmenu/sdmenu.js"></script>
	<script type="text/javascript">
	// <![CDATA[
	var myMenu;
	window.onload = function() {
		myMenu = new SDMenu("my_menu");
		myMenu.init();
	};
	// ]]>
	</script>

<script type="text/javascript">
    function openLogWin(logUrl) {
        window.open(logUrl);
    }
</script>

<script type="text/javascript">
    function confirmCancelJob(cidUrl) {
        if (confirm("Are you sure you want to cancel this job?")) {
            document.location = cidUrl;
        }
    }
</script>

</head>

<body>
<table width="1100" 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">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-->
      </div>
	<?php
	if ($_SESSION['MM_UserGroup']==1)		{ ?>
       <div>
        <span>AdminSpace</span>
		<a href="inlogadd.php">Create Users</a>
		<a href="regman.php">Manage Registration</a>
      </div>
	<?php	}	?> 

      <div>      <div class="">
        <span>Support</span>
        <a href=http://www.cs.wayne.edu/saifullah/CRI_Lab.html>CRI Research Lab</a>

        <a href="achecknodes.php">Check failed emotes</a>
      </div>
      
      </div>
      
    </div>
	</td>
	<td colspan="2" valign="middle"><div align="center">Welcome <?php echo $_SESSION['MM_Username'] ;?> </div><br>
	<table border="0" width="50%" align="center">
	  <tr>
		<td width="23%" align="center">
		  <?php if ($pageNum_jtrak > 0) { // Show if not first page ?>
		  <a href="<?php printf("%s?pageNum_jtrak=%d%s", $currentPage, 0, $queryString_jtrak); ?>">First</a>
		  <?php } // Show if not first page ?>
		</td>
		<td width="31%" align="center">
		  <?php if ($pageNum_jtrak > 0) { // Show if not first page ?>
		  <a href="<?php printf("%s?pageNum_jtrak=%d%s", $currentPage, max(0, $pageNum_jtrak - 1), $queryString_jtrak); ?>">Previous</a>
		  <?php } // Show if not first page ?>
		</td>
		<td width="23%" align="center">
		  <?php if ($pageNum_jtrak < $totalPages_jtrak) { // Show if not last page ?>
		  <a href="<?php printf("%s?pageNum_jtrak=%d%s", $currentPage, min($totalPages_jtrak, $pageNum_jtrak + 1), $queryString_jtrak); ?>">Next</a>
		  <?php } // Show if not last page ?>
		</td>
		<td width="23%" align="center">
		  <?php if ($pageNum_jtrak < $totalPages_jtrak) { // Show if not last page ?>
		  <a href="<?php printf("%s?pageNum_jtrak=%d%s", $currentPage, $totalPages_jtrak, $queryString_jtrak); ?>">Last</a>
		  <?php } // Show if not last page ?>
		</td>
	  </tr>
	</table><br>
	<table border="1" align="center" class="border">
	  <tr>
		<td><b>jid</td>
		<td><b>ifile (contiki-excutable)</td>
		<td><b>request_time</td>
		<td><b>start_time</td>
		<td><b>duration</td>
		<?php if ($row_jtrak['status']=="completed") {
		    echo "<td><b>output</td>";
		} else {
        
            if ($row_jtrak['status']=="cancelled") {
                echo "<td><b>output</td>";
            } else {
		        echo "<td><b>output</td>";
		        // echo "<td><b>cancel</td>";
		    }

        }
		?>
		<td><b>status</td>
		<td><b>group</td>
		<td><b>emote prog left </td>
	  </tr>
	  <?php do { ?>
	  <tr align="left">
		<td> <a href="jdetail.php?recordID=<?php echo $row_jtrak['JID']; ?>"> <?php echo $row_jtrak['JID']; ?>&nbsp; </a> </td>
		<td> <?php echo $row_jtrak['ifile']; ?>&nbsp; </td>
		<td> <?php echo $row_jtrak['request_time']; ?>&nbsp; </td>
		<td> <?php echo $row_jtrak['start_time']; ?>&nbsp; </td>
		<td align="center"> <?php echo $row_jtrak['duration']." min"; ?>&nbsp; </td>
		<?php 
        
        if ($row_jtrak['status']=="completed") {
			echo "<td><a href='/users/".$row_jtrak['loginid']."/datalogs/"."Job-".$row_jtrak['JID']."/".$row_jtrak['JID'].".zip'>".$row_jtrak['JID'].".zip </a></td>";
			
        } else {
                if ($row_jtrak['status']=="cancelled" || $row_jtrak['status']=="canceling" || $row_jtrak['status']=="finished" || $row_jtrak['status']=="failed") {
                    echo "<td align='center'><i>n/a</i></td>";
                } else {
                    echo "<td><a href=javascript:confirmCancelJob('jobcancel.php?jbid=".$row_jtrak['JID']."')>Cancel Job</a></td>";
                }

#echo "<td><a href='jobcancel.php?jbid=".$row_jtrak['JID']."'>Cancel Job</a></td>";
		}
		?>

		<td> <?php 
            if($row_jtrak['status']=="completed") {
                echo "<font color=\"blue\"><b>"."completed"."</font>";
            } else if($row_jtrak['status']=="cancelled") {
                echo "<font color=\"red\">"."cancelled"."</font>";
            } else if($row_jtrak['status']=="failed") {
                echo "<font color=\"red\">"."failed"."</font>";
            } else if($row_jtrak['status']=="running") {
                echo "<font color=\"green\"><b>"."running"."</font>";
            } else {
                echo $row_jtrak['status'];
            }
        ?>&nbsp;
        
        </td>
		<td> <?php echo $row_jtrak['group_name']; ?>&nbsp; </td>
		<td align="center"> 
            <?php 

# change to show how many emotes need to prog
	$jjid = $row_jtrak['JID'];
        $query_nodeleft = sprintf("SELECT count(*) FROM nodetable where JID=$jjid and status!='running' and status!='finished'");
	$node_num = mysqli_query( $osense,$query_nodeleft);
	$mynum=$node_num->fetch_row();
echo " $mynum[0]";
# end show

#	 echo "<a emotes left $node_num</a>";


#                if ($row_jtrak['status'] == "running" || $row_jtrak['status'] == "completed" || $row_jtrak['status'] == "finished") {
            #        $jjid = $row_jtrak['JID'];
#                    $prog_log = "/var/www/html/neteye/users/Job-".$jjid;
#            $cmd_dump = "/var/www/html/cron/dump_moteprog_log.pl ".$jjid." > "."$prog_log";
                    // echo $cmd_dump;
 #                   shell_exec($cmd_dump);
#echo "how ar ";
               #     echo "<a id='loglink' href=javascript:ModalPopupsAlert99('/users/Job-$jjid');>log</a>";
#                } else if($row_jtrak['status'] == "failed") {
 #                   echo "<i>n/a</i>"; 
  #              } else { 
   #                 echo "<i>n/a</i>"; 
    #            } 
            ?>&nbsp; 
        </td>
	  </tr>
	  <?php } while ($row_jtrak = mysqli_fetch_assoc($jtrak)); ?>
	</table>
	<div align="center"><br>
	  Records <?php echo ($startRow_jtrak + 1) ?> to <?php echo min($startRow_jtrak + $maxRows_jtrak, $totalRows_jtrak) ?> of <?php echo $totalRows_jtrak ?>
	</div>
</td>
  </tr>
</table>
</body>
</html>
<?php
mysqli_free_result($node_num);
mysqli_free_result($jtrak);
?>
