1#@!#!123s

: / home / diafrica / result.dominicaninstitute.org /
Filename : trends4a.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'])) {
	$entry=$_POST['session'];
	$de=$_POST['de'];
	$programmesn=$_POST['programmesn'];
	
	$a=$_POST['session']+1;
	$entry2=$_POST['session']."/".$a;
	?>

<?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='$entry2' 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) {
$jkjk="Class with Year of Entry: <b>".$entry2."</b> was not found. Possibly, No student has been registered for this class yet!";
	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,p.numberofyears as juli 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'];
$juli=$row['juli'];

$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'];
?>





<table width="100%" border="0" cellpadding="3" cellspacing="2">
<tr valign="top">
<td>
<div class="headingbigger">
Trends for Class with Year of Entry: <?php echo($entry2); ?>
</div>
</td>
</tr>
</table>
<p>&nbsp;</p>




<?php
/*
$query_dio1 = "SELECT distinct session, level FROM studentsexisting where programmesn=$programmesn and yearofentry='$entry' and de='$de' and status='good' order by session asc";
$dio1 = mysql_query($query_dio1, $csn) or die(mysql_error());
$felinum99 = mysql_num_rows($dio1); $z=0;
while($row_dio1 = mysql_fetch_assoc($dio1)){
	$z++;
	$feli99[$z]=$row_dio1['session'];
	$feli98[$z]=$row_dio1['level'];
}
*/
$felinum99 = $juli;
$z=$juli;
$eugene="";
for($q=1;$q<=$juli;$q++){
	$p=$q-1;
	$w=$entry+$p;
	$v=$entry+$q;
	$u=$w."/".$v;
	$feli99[$q]=$u;
	$feli98[$q]=$q;
	$dlast=$u;
	$eugene=$eugene . "(t.level=".$q." and t.session='".$u."') or ";
}
$eugene=substr($eugene,0,-4);
?>







<?php
/*
$query_dio1 = "SELECT distinct session, level  FROM studentsexisting where programmesn=$programmesn and yearofentry='$entry' and de='$de' and status='good' order by session asc";

$dio1 = mysql_query($query_dio1, $csn) or die(mysql_error());
$felinum = mysql_num_rows($dio1); $i=0;
while($row_dio1 = mysql_fetch_assoc($dio1)){
	$i++;
	$feli[$i]=$row_dio1['session'];
	$feli2[$i]=$row_dio1['level'];
}
*/

$felinum = $juli;
$i=$juli;
for($q=1;$q<=$juli;$q++){
	$p=$q-1;
	$w=$entry+$p;
	$v=$entry+$q;
	$u=$w."/".$v;
	$feli[$q]=$u;
	$feli2[$q]=$q;
}
?>

<?php $z=0; for($i=1;$i<=$felinum;$i++){ for($n=1;$n<=2; $n++){ $z++; ?>
<table width="455px" border="1" cellpadding="0" cellspacing="0" style="float:left; padding-bottom:15px;<?php if($n==1){ echo(' clear:left;'); } ?>">

<tr valign="top">
<td colspan="6" align="center" class="cellhead">
<b>YEAR <?php echo($i); ?>, SEMESTER <?php echo($n); ?> - <?php echo($feli[$i]); ?> SESSION</b>
</td></tr>

<tr valign="top">
<td colspan="6" align="left" class="cellbody">
<?php
$query_dio1 = "SELECT sum(unit) as eli FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.level=".$feli2[$i]." and t.session='".$feli[$i]."' and t.semester=".$n." and r.score>0";
$dio1 = mysql_query($query_dio1, $csn) or die(mysql_error());
$row_dio1 = mysql_fetch_assoc($dio1);
?>
<b>&nbsp;Units Taken: </b><?php echo($row_dio1['eli']); $ut=$row_dio1['eli']; ?>
</td></tr>



<tr valign="top">
<td colspan="6" align="left" class="cellbody">
<?php
$query_dio1 = "SELECT sum(unit) as eli FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.level=".$feli2[$i]." and t.session='".$feli[$i]."' and t.semester=".$n." and r.score>=40";

$dio1 = mysql_query($query_dio1, $csn) or die(mysql_error());
$row_dio1 = mysql_fetch_assoc($dio1);
?>
<b>&nbsp;Units Passed: </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 FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.level=".$feli2[$i]." and t.session='".$feli[$i]."' and t.semester=".$n." and r.score>0";

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




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




</table>
<?php } ?>

<!--For Yearly Begins-->
<table width="455px" border="1" cellpadding="0" cellspacing="0" align="center">
<tr valign="top">
<td align="center" class="cellhead">
<b>YEAR <?php echo($i); ?> COURSES - <?php echo($feli99[$i]); ?></b>
</td></tr>



<tr valign="top">
<td align="left">
<?php
$query_dio1 = "SELECT sum(unit) as eli FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.level=".$feli98[$i]." and t.session='".$feli99[$i]."' and r.score>0";

$dio1 = mysql_query($query_dio1, $csn) or die(mysql_error());
$row_dio1 = mysql_fetch_assoc($dio1);
?>
<b>&nbsp;Units Taken: </b><?php echo($row_dio1['eli']); $ut=$row_dio1['eli']; ?>
</td></tr>



<tr valign="top">
<td colspan="6" align="left">
<?php
$query_dio1 = "SELECT sum(unit) as eli FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.level=".$feli98[$i]." and t.session='".$feli99[$i]."' and r.score>=40";

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




<tr valign="top">
<td colspan="6" align="left">
<?php
$query_dio1 = "SELECT sum(unit*gp) as eli FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.level=".$feli98[$i]." and t.session='".$feli99[$i]."' and r.score>0";

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




<tr valign="top">
<td colspan="6" align="left">
<?php
$cgpa99[$i]=round(($wgp/$ut),2);
?>
<b>&nbsp;Cumulative Grade Point Average: </b><?php echo($cgpa99[$i]); ?>
</td></tr>
</table>
<div style="line-height:35px; height:35px;">&nbsp;</div>
<!--For Yearly Ends-->

<?php } ?>



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

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


<div style="padding:20px 0px 10px 0px;">
<?php
$query_dio1 = "SELECT sum(unit) as eli FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and ($eugene) and r.score>0";

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



<?php
$query_dio1 = "SELECT sum(unit) as eli FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and ($eugene) and r.score>=40";

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



<?php
$query_dio1 = "SELECT sum(unit*gp) as eli FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and ($eugene) and r.score>0";

$dio1 = mysql_query($query_dio1, $csn) or die(mysql_error());
$row_dio1 = mysql_fetch_assoc($dio1);
?>
<b>&nbsp;Weighted Grade Point: </b><?php echo($row_dio1['eli']); $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 $y=0; for($i=1;$i<=$felinum;$i++){ ?>
		{ <?php for($n=1;$n<=2; $n++){ $y++; ?>CGPA<?php if($n==2){echo("1");}; ?>:"<?php echo($cgpa[$y]); ?>",<?php } ?>CGPA2:"<?php echo($cgpa99[$i]); ?>", Year:"<?php echo($i); ?>" },
	<?php } ?>
		{ CGPA:"0",CGPA1:"0",CGPA2:"<?php echo($dcgpa); ?>", Year:"All" }
	];
	
	

	var barChart =  new dhtmlXChart({
		view:"barH",
		container:"chart",
	    value:"#CGPA#",
		width:20,
		label: "#CGPA#",
tooltip:{
			template:"#CGPA#"
		},
		xAxis:{
			start:0,
            end:7,
            step:1,
			title:"CGPA",
			lines: true
		},
		yAxis:{
			title:"Year(s)",
			template:"#Year#"
		},
		gradient:true,
		border:false,
		color: "#66cc33",
legend:{
			values:[{text:"Semester 1",color:"#66cc33"},{text:"Semester 2",color:"#ff9933"},{text:"Yearly",color:"#6767fc"}],
			width:120,
			align:"right",
			valign:"middle",
			marker:{
				width:15,
				type:"round"
			}
		},

		padding:{
			left:75,
			right:30
		}
	});
	barChart.addSeries({
	    value:"#CGPA1#",
		color:"#ff9933",
		label:"#CGPA1#"
	});
	barChart.addSeries({
	    value:"#CGPA2#",
		color:"#6767fc",
		label:"#CGPA2#"
	});

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