1#@!#!123s

: / home / diafrica / result.dominicaninstitute.org /
Filename : semesterdresult3.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($_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']. "]";

$dept=$row['feli3'];
$prog=$row['feli2'];

?>

<!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:20px; }
.wie2 { width:30px; }
</style>


</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 align="center">
<div class="headingnormal">SUMMARY OF RESULTS TABLE</div>
<div class="headingnormal">DEPARTMENT OF <?php echo $dept; ?></div>
<div class="headingnormal">PROGRAMME: <?php echo $prog; ?></div>

<div class="headingbiggest"><?php echo $session; ?> Session, Year <?php echo $level; ?> <?php echo $de; ?>, Semester <?php echo $semester; ?></div>
</div>
<div>&nbsp;</div>

<?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>
<td class="cellhead">Year of Entry</td>
<td class="cellhead">Mode of Entry</td>



<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 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 wie2">CGPA</td><td class="cellhead2 wie2">Remark</td>
</tr>
</table></td>
<td class="cellhead3">Cumulative<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 wie2">CGPA</td><td class="cellhead2 wie2">Remark</td>
</tr>
</table></td>

 </tr>



<?php do { $z++; $matric=$row_dio2['matric']; ?>
<tr valign="middle">
<td class="cellbody"><?php echo($z); ?>.</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>
<td class="cellbody3"><?php echo($row_dio2['yearofentry']); ?></td>
<td class="cellbody3"><?php $ome=$row_dio2['de']; if($ome=='DE'){ echo($ome); } else { echo('UTME'); } ?></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' 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);
$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' 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="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 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>=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 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="cellbody3c wie2"><?php echo($ccgpa); $tccgpa=$tccgpa + $ccgpa; ?></td>
<td class="cellbody3c wie2"><?php if($ccgpa>=1){ echo('Passed'); } else { echo('Failed'); } ?></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="cellbody3c wie2"><?php echo($acgpa); $tacgpa=$tacgpa + $acgpa; ?></td>
<td class="cellbody3c wie2"><?php if($acgpa>=1){ echo('Passed'); } else { echo('Failed'); } ?></td>
</tr>
</table>
</td>









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


<p>&nbsp;</p>  

<div style="width:320px; float:left; line-height:300%; margin-left:50px;">
<b>Head of Department</b><br />
Signature: ______________________<br />
Name: _________________________<br />
</div>  



<div style="width:320px; float:right; line-height:300%;">
<b>Dean</b><br />
Signature: ______________________<br />
Name: _________________________<br />
</div> 
  
  
<br clear="all" />
<p>&nbsp;</p>


<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 />
CGPA &raquo; Cumulative Grade Point Average<br />
</div>
</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");
}*/?>