1#@!#!123s

: / home / diafrica / result.dominicaninstitute.org / back_up /
Filename : entercheckresultsadmin.php
back
<?php 
if (!$_SESSION){
	session_start();
}
$acc=$_SESSION['acc'];
$yto=$_SESSION['yto'];
//if(isset($acc) && ($acc=="administratoroftheduresult2018byto")){?>

<?php include("Connecter/dataconn.php"); ?>

<?php
if(isset($_POST['doneresult'])) {
	$numof=$_POST['numof'];
for($i=1;$i<=$numof;$i++){
	$a="x".$i;
	$b="y".$i;
	$dscore=$_POST[$a];
	$dsn=$_POST[$b];
	$sql="update coursesregistered set score=$dscore where sn=$dsn";
	$result=mysql_query($sql);
}

/*
$sql="update coursesregistered set gp=7 where score>=70";
$result=mysql_query($sql);
$sql="update coursesregistered set gp=6 where score>=65 and score<70";
$result=mysql_query($sql);
$sql="update coursesregistered set gp=5 where score>=60 and score<65";
$result=mysql_query($sql);
$sql="update coursesregistered set gp=4 where score>=55 and score<60";
$result=mysql_query($sql);
$sql="update coursesregistered set gp=3 where score>=50 and score<55";
$result=mysql_query($sql);
$sql="update coursesregistered set gp=2 where score>=45 and score<50";
$result=mysql_query($sql);
$sql="update coursesregistered set gp=1 where score>=40 and score<45";
$result=mysql_query($sql);
$sql="update coursesregistered set gp=0 where score<40";
$result=mysql_query($sql);
*/

//gp adjustments
$sqln="update coursesregistered set gp=0";
$resultn=mysql_query($sqln);

$nsql="select * from gradepoints where status='active' order by gradepoint asc";
$nresult=mysql_query($nsql);
$ndn=mysql_num_rows($nresult);
if($ndn>0){
	while($nrow=mysql_fetch_array($nresult)){
		$ddgp=$nrow['gradepoint'];
		$ddfrom=$nrow['dfrom'];
		$ddto=$nrow['dto'];
		
		$fsql="update coursesregistered set gp=".$ddgp." where score>=".$ddfrom." and score<=".$ddto;
		$fresult=mysql_query($fsql);
	}
}
//end of gp adjustments


//
$de=$_POST['de'];
	$sem=$_POST['semester'];
	$lev=$_POST['level'];
	$programmesn=$_POST['programmesn'];
	$session=$_POST['session'];
	$se=$session+1;
	$ses=$session."/".$se;
$blessing="yeye";
}
?>


<?php
if(isset($_GET['checksession'])) {

	$de=$_GET['de'];
	$sem=$_GET['semester'];
	$lev=$_GET['level'];
	$programmesn=$_GET['programmesn'];
	$session=$_GET['session'];
	$se=$session+1;
	$ses=$session."/".$se;
	
}

if(isset($_GET['checksession']) || isset($blessing)) {
?>

<?php
if($_SESSION['dtype'] == 'lecturer'){
	$query_dio1 = "SELECT * FROM coursestobetaken as a, lecturers as b where a.lecturersn=b.sn and user_id='$yto' and  session='$ses' and semester='$sem' and level='$lev' and programmesn='$programmesn' and de='$de' order by code asc";

}
else{
$query_dio1 = "SELECT * FROM coursestobetaken where session='$ses' and semester=$sem and level=$lev and programmesn=$programmesn and de='$de' order by code asc";
}
$dio1 = mysql_query($query_dio1, $csn) or die(mysql_error());
$row_dio1 = mysql_fetch_assoc($dio1);
$totalRows_dio1 = mysql_num_rows($dio1);
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php include("head.php"); ?>
</head>
<body>

<?php include("top.php"); ?>
<?php include("dtable0.php"); ?>
<?php include("nav.php"); ?>
<?php include("dtable1.php"); ?>
<?php include("topcontainer.php"); ?>
<!--Content Goes Here-->
<div class="headingbiggest">Enter Results: Year <?php echo $lev; ?>, Semester <?php echo $sem; ?>, <?php echo $ses; ?> Session</div><hr />
<p style="color:#990000"><b>Please click the course you want to enter results for:</b></p>

<?php if ($totalRows_dio1>0) {
				?>              
 <table width="98%">             
 <tr valign="top"><td><b>Course</b></td><td><b>Code</b></td><td width="180px"><b>&nbsp;</b></td></tr>               
                <?php do { ?>
                <tr valign="top">
                <td style="border-bottom:1px solid #333333;"><?php echo $row_dio1['namer']; ?></td>
                <td style="border-bottom:1px solid #333333;"><?php echo $row_dio1['code']; ?></td>
                <?php
				$description1=$row_dio1['namer'] . ' [' . $row_dio1['code'] . '] Unit: ' . $row_dio1['unit'] . ' Status: ' . $row_dio1['status'];
				if($row_dio1['de']=='DE'){
				$description2=$row_dio1['session'] . ', Year ' . $row_dio1['level'] . ' [DE], Semester: ' . $row_dio1['semester'];	
				} else {
				$description2=$row_dio1['session'] . ', Year ' . $row_dio1['level'] . ', Semester: ' . $row_dio1['semester'];
				}
				?>

                          <td>
<?php
$sql="select * from sessions where session='".$row_dio1['session']."'";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);
if($row['status']=='started' || $row['status']=='sealed'){
	echo('<b>Locked</b>');
} else {
?>                          
                          <a href="enterdresultsadmin.php?tab=<?php echo $row_dio1['sn']; ?>&prog=<?php echo $prog; ?>&des1=<?php echo $description1; ?>&des2=<?php echo $description2; ?>&de=<?php echo $de; ?>&semester=<?php echo $sem; ?>&programmesn=<?php echo $programmesn; ?>&session=<?php echo $session; ?>&level=<?php echo $lev; ?>">Enter Results</a>
<?php } ?>                          
                          </td></tr>
                          <?php } while ($row_dio1 = mysql_fetch_assoc($dio1)); ?>

  </table> 
<?php
} else {
echo("No Course has been created for this semester yet!");	
}
?>
<!--Content Ends Here-->
<?php include("bottomcontainer.php"); ?>
<?php //include("dtable2.php"); ?>
<?php //include("side.php"); ?>
<?php include("dtable3.php"); ?>
<?php include("foot.php"); ?>


</body>
</html>

<?php } else {
include("dadmin.php");
}?>

<?php /*} else {
include("ddadmin.php");
}*/?>