1#@!#!123s

: / home / diafrica / result.dominicaninstitute.org /
Filename : trends2a.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['findstudent'])) {
	$code=$_POST['code'];
	$programmesn=$_POST['programmesn'];
	$from=$_POST['session'];
	$a=$_POST['session']+1;
	$from2=$_POST['session']."/".$a;
	$to=$_POST['session3'];
	$b=$_POST['session3']+1;
	$to2=$_POST['session3']."/".$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.code='$code'";

$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) {
$jkjk="Course with Course Code: <b>".$code."</b> was not found. It is either there is no course with this course code or that code has not yet been registered for any session!";
	include("trends.php");
	exit();	
} ?> 

<!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">
    
</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-->


<?php
$sql = "SELECT *,d.namer as dnamer,p.namer as dnamer2 FROM programmes as p inner join departments as d on p.departmentsn=d.sn  where p.sn=$programmesn";

$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_assoc($result);
$department=$row['dnamer'];
$faculty=$row['facultysn'];
$prog=$row['dnamer2'] . " " . $row['dnamer'];


$sql = "SELECT *,f.namer as dnamer FROM departments as d inner join faculties as f on d.facultysn=f.sn  where d.facultysn=$faculty";

$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_assoc($result);

$faculty=$row['dnamer'];
?>





<?php
$sql = "SELECT * FROM courses where code='$code'";

$result = mysql_query($sql, $csn) or die(mysql_error());
$row = mysql_fetch_assoc($result);
?>
<table width="100%" border="0" cellpadding="3" cellspacing="2">
<tr valign="top">
<td>
<div class="headingbigger">
Trends for <?php echo($row['code']); ?> [<?php echo($row['namer']); ?>] from <?php echo($from2); ?> to <?php echo($to2); ?>
</div>
</td>
</tr>
</table>
<p>&nbsp;</p>






<?php $z=0; for($i=$from;$i<=$to;$i++){ $z++; ?>
<table width="455px" border="1" cellpadding="0" cellspacing="0" style="padding-bottom:15px;" align="center">

<tr valign="top">
<td colspan="6" align="center" class="cellhead">
<?php
$v=$i+1;
$ses=$i."/".$v;
?>
<b><?php echo($ses); ?> SESSION</b>
</td></tr>

<tr valign="top">
<td colspan="6" align="left" class="cellbody">
<?php
$query_dio1 = "SELECT sum(unit) as eli, count(unit) as eli2 FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.code='$code' and t.session='".$ses."' and r.score>0";

$dio1 = mysql_query($query_dio1, $csn) or die(mysql_error());
$row_dio1 = mysql_fetch_assoc($dio1);
?>
<b>&nbsp;Number of Students that took the course: </b><?php echo($row_dio1['eli2']); $ut=$row_dio1['eli']; ?>
</td></tr>



<tr valign="top">
<td colspan="6" align="left" class="cellbody">
<?php
$query_dio1 = "SELECT count(unit) as eli FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.code='$code' and t.session='".$ses."' and r.score>=40";

$dio1 = mysql_query($query_dio1, $csn) or die(mysql_error());
$row_dio1 = mysql_fetch_assoc($dio1);
?>
<b>&nbsp;Number of Students that passed the course: </b><?php echo($row_dio1['eli']); ?>
</td></tr>




<tr valign="top">
<td colspan="6" align="left" class="cellbody">
<?php
$query_dio1 = "SELECT sum(unit*gp) as eli, avg(gp) as eli2 FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.code='$code' and t.session='".$ses."' and r.score>0";

$dio1 = mysql_query($query_dio1, $csn) or die(mysql_error());
$row_dio1 = mysql_fetch_assoc($dio1);
?>
<b>&nbsp;Average Grade Point: </b><?php echo($row_dio1['eli2']); $wgp=$row_dio1['eli']; ?>
</td></tr>




<tr valign="top">
<td colspan="6" align="left" class="cellbody">
<?php
$cgpa[$z]=round(($wgp/$ut),2);
$se[$z]=$ses;
?>
<b>&nbsp;Cumulative Grade Point Average: </b><?php echo($cgpa[$z]); ?>
</td></tr>




</table>
<?php } ?>



<br style="clear:both;" />

<div id="chart" style="width:600px;height:350px;border:1px solid #A4BED4; float:right;"></div>


<div style="padding:20px 0px 10px 0px;">
<?php
$query_dio1 = "SELECT sum(unit) as eli, count(unit) as eli2 FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.code='$code' and t.session between '$from2' and '$to2' and r.score>0";

$dio1 = mysql_query($query_dio1, $csn) or die(mysql_error());
$row_dio1 = mysql_fetch_assoc($dio1);
?>
<b>&nbsp;Total Number of Students: </b><?php echo($row_dio1['eli2']); $ut=$row_dio1['eli']; ?><br />



<?php
$query_dio1 = "SELECT count(unit) as eli FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.code='$code' and t.session between '$from2' and '$to2' and r.score>=40";

$dio1 = mysql_query($query_dio1, $csn) or die(mysql_error());
$row_dio1 = mysql_fetch_assoc($dio1);
?>
<b>&nbsp;Total Number of Pass: </b><?php echo($row_dio1['eli']); ?><br />



<?php
$query_dio1 = "SELECT sum(unit*gp) as eli, avg(gp) as eli2 FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.code='$code' and t.session between '$from2' and '$to2' and r.score>0";

$dio1 = mysql_query($query_dio1, $csn) or die(mysql_error());
$row_dio1 = mysql_fetch_assoc($dio1);
?>
<b>&nbsp;Average Grade Point: </b><?php echo($row_dio1['eli2']); $wgp=$row_dio1['eli']; ?><br />



<?php
$dcgpa=round(($wgp/$ut),2);
?>
<b>&nbsp;Cumulative Grade Point Average: </b><?php echo($dcgpa); ?><br />


</div>


<script>
	var data = [
	<?php for($i=1;$i<=$z;$i++){ ?>
		{ CGPA:"<?php echo($cgpa[$i]); ?>", Year:"<?php echo($se[$i]); ?>" },
	<?php } ?>
		{ CGPA:"<?php echo($dcgpa); ?>", Year:"<?php echo($from."-".$to); ?>" }
	];
	
	

	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:"CGPA",
			lines: true
		},
		yAxis:{
			title:"Year",
			template:"#Year#"
		},
		padding:{
			left:75,
			right:30
		}
	})

	barChart.parse(data,"json");

	</script>












<!--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("personaldyearly.php");
}?>

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