1#@!#!123s

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

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

<?php
if(isset($_GET['checksession'])) {
	$de=$_GET['de'];
	$semester=$_GET['semester'];
	$level=$_GET['level'];
	$programmesn=$_GET['programmesn'];
	$session=$_GET['session'];
	$se=$session+1;
	$session=$session."/".$se;
	
	$dp=$_GET['decimalplace'];
	

$sql = "SELECT *,programmes.sn as feli1,programmes.namer as feli2,departments.namer as feli3 FROM programmes inner join departments on programmes.departmentsn = departments.sn where programmes.sn=$programmesn";
$result = mysql_query($sql);
$row=mysql_fetch_array($result);
$feli=$row['feli2']. " [" . $row['feli3']. "]";
?>

<!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"); ?>

<script src="bar/dhtmlxchart.js" type="text/javascript"></script>
	<link rel="STYLESHEET" type="text/css" href="bar/dhtmlxchart.css">

<style>
.wie { width:40px; }
.wie2 { width:50px; }
</style>



<script src='semesterdresult.js'></script>

</head>
<body>

<?php include("top.php"); ?>
<?php include("dtable0no.php"); ?>
<?php include("nav.php"); ?>
<?php include("dtable1no.php"); ?>
<?php include("topcontainer.php"); ?>
<!--Content Goes Here-->
<div class="headingbiggest">Result for <?php echo $session; ?> Session, Year <?php echo $level; ?> <?php echo $de; ?>, Semester <?php echo $semester; ?> in <?php echo $feli; ?></div><hr />

<?php
$sql = "SELECT * FROM coursestobetaken where session='$session' and level=$level and semester=$semester and de='$de' and programmesn=$programmesn";
$result = mysql_query($sql);
$num=mysql_num_rows($result);
if($num>0){
?>



<?php
$query_dio2 = "SELECT * FROM studentsexisting where programmesn=$programmesn and session='$session' and level=$level and status='good' and de='$de'";
$dio2 = mysql_query($query_dio2, $csn) or die(mysql_error());
$row_dio2 = mysql_fetch_assoc($dio2);
$totalRows_dio2 = mysql_num_rows($dio2);
?>

<?php if ($totalRows_dio2>0) { $z=0;
				?> 


                       
 <table width="100%" cellpadding="3" cellspacing="2" border="1">             
 <tr valign="bottom">
<td width="20px" class="cellhead">&nbsp;</td>
<td class="cellhead">Matric</td>
<td class="cellhead">Name of Student</td>

<?php
$query_dio1 = "SELECT distinct code, namer, unit, status FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.session='$session' and t.level=$level and t.semester=$semester and t.de='$de'";

$dio1 = mysql_query($query_dio1, $csn) or die(mysql_error());
$row_dio1 = mysql_fetch_assoc($dio1);
$totalRows_dio1 = mysql_num_rows($dio1);
?>
<?php if ($totalRows_dio1>0) { $y=0; ?> 
<?php do { $y++; ?>
<td width="60px" class="cellhead">
<table width="100%" border="0" cellpadding="3" cellspacing="2">
<tr valign="top"><td><?php echo($row_dio1['code']); ?></td></tr>
<tr valign="top"><td style="border-top:2px solid #ccc;"><?php echo($row_dio1['unit']); ?>-<?php echo($row_dio1['status']); ?></td></tr>
</table>
</td>
<?php $lil[$y]=$row_dio1['code']; 
$feri=$feri . $row_dio1['code'] . " &raquo; " . $row_dio1['namer'] . "<br>"; 
?>
<?php } while ($row_dio1 = mysql_fetch_assoc($dio1)); ?>
<?php } ?>

<td class="cellhead3">Previous Semesters<br />
<table width="100%" border="0" cellpadding="2" cellspacing="2">
<tr valign="top">
<td class="cellhead2 wie">UT</td><td class="cellhead2 wie">UP</td><td class="cellhead2 wie">UN</td><td class="cellhead2 wie">WGP</td><td class="cellhead2 wie2">CGPA</td>
</tr>
</table>
</td>
<td class="cellhead3">Current Semester<br />
<table width="100%" border="0" cellpadding="2" cellspacing="2">
<tr valign="top">
<td class="cellhead2 wie">UT</td><td class="cellhead2 wie">UP</td><td class="cellhead2 wie">UN</td><td class="cellhead2 wie">WGP</td><td class="cellhead2 wie2">CGPA</td>
</tr>
</table></td>
<td class="cellhead3">All Semesters<br />
<table width="100%" border="0" cellpadding="2" cellspacing="2">
<tr valign="top">
<td class="cellhead2 wie">UT</td><td class="cellhead2 wie">UP</td><td class="cellhead2 wie">UN</td><td class="cellhead2 wie">WGP</td><td class="cellhead2 wie2">CGPA</td>
</tr>
</table></td>

 </tr>



<?php do { $z++; $matric=$row_dio2['matric']; ?>
<tr valign="middle">
<td class="cellbody3">


<?php
$sqld="select * from students where matric='".$matric."'";
$resultd=mysql_query($sqld);
$rowd=mysql_fetch_array($resultd);
$dnamu= $rowd['surname'] . ", " . $rowd['firstname'] . " " . $rowd['othernames'];
?>
<a class="dactiond" id="semesterdresult4.php_deltab_<?php echo $row_dio1['sn']; ?>_NameofTable_Are you sure you want to _Delete_<?php echo $dnamu; ?>" style="cursor:pointer;">&#8212;</a>

</td>
<td class="cellbody"><?php echo($row_dio2['matric']); ?></td>

<td class="cellbody">
<?php
$sqld="select * from students where matric='".$matric."'";
$resultd=mysql_query($sqld);
$rowd=mysql_fetch_array($resultd);
?>
<?php echo($rowd['surname']); ?>, <?php echo($rowd['firstname']); ?> <?php echo($rowd['othernames']); ?>
</td>



<?php for($b=1;$b<=$y;$b++){ ?>
<?php
$query_dio1 = "SELECT *,r.sn as dsn FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.session='$session' and t.level=$level and t.semester=$semester and t.de='$de' and r.matric='$matric' and t.code='".$lil[$b]."'";

$dio1 = mysql_query($query_dio1, $csn) or die(mysql_error());
$row_dio1 = mysql_fetch_assoc($dio1);
?>
<td class="cellbody2"><?php echo($row_dio1['score']); ?></td>
<?php } ?>








<td class="cellhead3">
<table width="100%" border="0" cellpadding="2" cellspacing="2">
<tr valign="top">
<?php
if($semester==1){
$sql = "SELECT sum(unit) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.session<'$session' and r.matric='$matric' and r.score>=0 and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$ptut=$row[0];

$sql = "SELECT sum(unit) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.session<'$session' and r.matric='$matric' and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$ptur=$row[0];

$sql = "SELECT sum(unit) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.session<'$session' and r.matric='$matric' and r.score>=40 and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$ptup=$row[0];

$sql = "SELECT sum(unit) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.session<'$session' and r.matric='$matric' and r.score IS NULL and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$ptun=$row[0];


$sql = "SELECT sum(unit*gp) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.session<'$session' and r.matric='$matric' and r.score>=0 and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$ptwgp=$row[0];

} else {
	
$sql = "SELECT sum(unit) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and (t.session<'$session' or (t.session='$session' and t.semester=1)) and r.matric='$matric' and r.score>=0 and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$ptut=$row[0];

$sql = "SELECT sum(unit) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and (t.session<'$session' or (t.session='$session' and t.semester=1)) and r.matric='$matric' and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$ptur=$row[0];


$sql = "SELECT sum(unit) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and (t.session<'$session' or (t.session='$session' and t.semester=1)) and r.matric='$matric' and r.score>=40 and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$ptup=$row[0];


$sql = "SELECT sum(unit) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and (t.session<'$session' or (t.session='$session' and t.semester=1)) and r.matric='$matric' and r.score IS NULL and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$ptup=$row[0];


$sql = "SELECT sum(unit*gp) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and (t.session<'$session' or (t.session='$session' and t.semester=1)) and r.matric='$matric' and r.score>=0 and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$ptwgp=$row[0];	
}

$pcgpa=$ptwgp/$ptut;
$pcgpa=round($pcgpa,$dp);
?>
<td class="cellbody3a wie"><?php echo($ptur); ?></td>
<td class="cellbody3a wie"><?php echo($ptup); ?></td>
<td class="cellbody3a wie"><?php echo($ptun); ?></td>
<td class="cellbody3b wie"><?php echo($ptwgp); ?></td>
<td class="cellbody3c wie2"><?php echo($pcgpa); $tpcgpa=$tpcgpa + $pcgpa; ?></td>
</tr>
</table>
</td>









<td class="cellhead3">
<table width="100%" border="0" cellpadding="2" cellspacing="2">
<tr valign="top">
<?php
$sql = "SELECT sum(unit) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.session='$session' and t.level=$level and t.semester=$semester and r.matric='$matric' and r.score>=0 and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$ctut=$row[0];

$sql = "SELECT sum(unit) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.session='$session' and t.level=$level and t.semester=$semester and r.matric='$matric' and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$ctur=$row[0];


$sql = "SELECT sum(unit) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.session='$session' and t.level=$level and t.semester=$semester and r.matric='$matric' and r.score>=40 and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$ctup=$row[0];

$sql = "SELECT sum(unit) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.session='$session' and t.level=$level and t.semester=$semester and r.matric='$matric' and r.score IS NULL and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$ctun=$row[0];


$sql = "SELECT sum(unit*gp) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.session='$session' and t.level=$level and t.semester=$semester and r.matric='$matric' and r.score>=0 and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$ctwgp=$row[0];

$ccgpa=$ctwgp/$ctut;
$ccgpa=round($ccgpa,$dp);
?>
<td class="cellbody3a wie"><?php echo($ctur); ?></td>
<td class="cellbody3a wie"><?php echo($ctup); ?></td>
<td class="cellbody3a wie"><?php echo($ctun); ?></td>
<td class="cellbody3b wie"><?php echo($ctwgp); ?></td>
<td class="cellbody3c wie2"><?php echo($ccgpa); $tccgpa=$tccgpa + $ccgpa; ?></td>
</tr>
</table>
</td>









<td class="cellhead3">
<table width="100%" border="0" cellpadding="2" cellspacing="2">
<tr valign="top">
<?php
if($semester==1){
$sql = "SELECT sum(unit) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and (t.session<'$session' or (t.session='$session' and t.semester=1)) and r.matric='$matric' and r.score>=0 and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$atut=$row[0];

$sql = "SELECT sum(unit) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and (t.session<'$session' or (t.session='$session' and t.semester=1)) and r.matric='$matric' and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$atur=$row[0];


$sql = "SELECT sum(unit) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and (t.session<'$session' or (t.session='$session' and t.semester=1)) and r.matric='$matric' and r.score>=40 and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$atup=$row[0];

$sql = "SELECT sum(unit) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and (t.session<'$session' or (t.session='$session' and t.semester=1)) and r.matric='$matric' and r.score IS NULL and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$atun=$row[0];


$sql = "SELECT sum(unit*gp) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and (t.session<'$session' or (t.session='$session' and t.semester=1)) and r.matric='$matric' and r.score>=0 and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$atwgp=$row[0];

} else {
	
$sql = "SELECT sum(unit) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.session<='$session' and r.matric='$matric' and r.score>=0 and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$atut=$row[0];


$sql = "SELECT sum(unit) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.session<='$session' and r.matric='$matric' and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$atur=$row[0];


$sql = "SELECT sum(unit) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.session<='$session' and r.matric='$matric' and r.score>=40 and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$atup=$row[0];

$sql = "SELECT sum(unit) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.session<='$session' and r.matric='$matric' and r.score IS NULL and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$atun=$row[0];

$sql = "SELECT sum(unit*gp) FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.session<='$session' and r.matric='$matric' and r.score>=0 and t.de='$de'";
$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_array($result);
$atwgp=$row[0];	
}

$acgpa=$atwgp/$atut;
$acgpa=round($acgpa,$dp);
?>
<td class="cellbody3a wie"><?php echo($atur); ?></td>
<td class="cellbody3a wie"><?php echo($atup); ?></td>
<td class="cellbody3a wie"><?php echo($atun); ?></td>
<td class="cellbody3b wie"><?php echo($atwgp); ?></td>
<td class="cellbody3c wie2"><?php echo($acgpa); $tacgpa=$tacgpa + $acgpa; ?></td>
</tr>
</table>
</td>









</tr>
<?php } while ($row_dio2 = mysql_fetch_assoc($dio2)); ?> 
 
  </table>  

 
  
<br clear="all" />



<div style="padding:20px 15px 20px 15px; font-weight:bold; color:#960;">
<div style="float:right">
UT &raquo; Total Units Taken/Registered<br />
UP &raquo; Total Units Passed<br />
UN &raquo; Total Units Not In Yet<br />
WGP &raquo; Weighed Grade Point<br />
CGPA &raquo; Cumulative Grade Point Average<br />
<br />
C &raquo; Compulsory<br />
R &raquo; Required<br />
E &raquo; Elective<br />
</div>
<?php echo($feri); ?>
</div>




<div style="clear:both">

<?php
$tpcgpa=$tpcgpa/$z;
$tccgpa=$tccgpa/$z;
$tacgpa=$tacgpa/$z;

$tpcgpa=round($tpcgpa,$dp);
$tccgpa=round($tccgpa,$dp);
$tacgpa=round($tacgpa,$dp);
?>

<script>
	var data = [
		{ CGPA:"<?php echo($tpcgpa); ?>", Semester:"Previous" },
		{ CGPA:"<?php echo($tccgpa); ?>", Semester:"Current" },
		{ CGPA:"<?php echo($tacgpa); ?>", Semester:"All" }
	];
	
	

	var barChart =  new dhtmlXChart({
		view:"barH",
		container:"chart",
	    value:"#CGPA#",
		width:20,
		label: "#CGPA#",
		gradient:"3d",
		color:"#ffcc00",
		xAxis:{
			start:0,
            end:7,
            step:1,
			title:"Average CGPA",
			lines: true
		},
		yAxis:{
			title:"Semester(s)",
			template:"#Semester#"
		},
		padding:{
			left:75,
			right:30
		}
	})
	barChart.parse(data,"json");

	</script>
</div>


<?php
} else {
	echo("No Registered Students!");
}
?>

<?php
} else {
	echo("No result found!");	
}
?>

<!--Content Ends Here-->
<?php include("bottomcontainer.php"); ?>
<?php //include("dtable2.php"); ?>
<?php //include("side.php"); ?>
<?php include("dtable3no.php"); ?>
<?php include("foot.php"); ?>


</body>
</html>

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

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