D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
diafrica
/
result.dominicaninstitute.org
/
Filename :
checkdresults.php
back
Copy
<?php if (!$_SESSION){ session_start(); } $_SESSION['ss'] = $_GET['ses']; $_SESSION['level'] = $_GET['lev']; $acc=$_SESSION['acc']; $yto=$_SESSION['yto']; if(isset($acc) && ($acc=="studentoftheuniversity2015byto")){?> <?php include("Connecter/dataconn.php"); ?> <?php if(isset($_GET['who'])) { $mat=$_GET['who']; $session=$_GET['ses']; $level=$_GET['lev']; $programmesn=$_GET['tab']; ?> <!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--> <div class="headingbiggest">Result for Year <?php echo $level; ?></div><hr /> <?php for($i=1;$i<3;$i++){ ?> <?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.semester=$i and r.matric='$mat'"; $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) { $z=0; ?> <div class="headingbigger"><b>Semester <?php echo($i); ?></b></div> <div class="post2"> <table width="98%" cellpadding="3" cellspacing="2" border="0"> <tr valign="top"> <td width="20" rowspan="2" valign="middle" class="cellhead"> </td> <td width="60" rowspan="2" valign="middle" class="cellhead">Code</td> <td rowspan="2" valign="middle" class="cellhead">Course</td> <td rowspan="2" valign="middle" class="cellhead">Unit</td> <td rowspan="2" valign="middle" class="cellhead">Status</td> <td rowspan="2" valign="middle" class="cellhead">Stand</td> <td rowspan="2" valign="middle" class="cellhead">Stance</td> <td rowspan="2" valign="middle" class="cellhead">Score</td> <td rowspan="2" valign="middle" class="cellhead">GP</td> <td rowspan="2" valign="middle" class="cellhead">WGP</td> <td colspan="3" valign="middle" class="cellhead">APPROVAL STATUS</td> </tr> <tr valign="top"> <td valign="middle" class="cellhead">DEPT</td> <td valign="middle" class="cellhead">FAC</td> <td valign="middle" class="cellhead">SEN</td> </tr> <?php do { $z++; ?> <tr valign="top"> <td class="cellbody"><?php echo($z); ?>.</td> <td class="cellbody"><?php echo($row_dio1['code']); ?></td> <td class="cellbody"><?php echo($row_dio1['namer']); ?></td> <td class="cellbody3"><?php echo($row_dio1['unit']); ?></td> <td class="cellbody3"><?php echo($row_dio1['status']); ?></td> <td class="cellbody"><?php echo($row_dio1['stand']); ?></td> <td class="cellbody"><?php echo($row_dio1['stance']); ?></td> <td class="cellbody2"><?php echo($row_dio1['score']); ?></td> <td class="cellbody3"><?php echo($row_dio1['gp']); ?></td> <?php $wgp=$row_dio1['unit'] * $row_dio1['gp']; ?> <td class="cellbody2"><?php echo($wgp); ?></td> <td class="cellbody3"><?php echo $row_dio1['dept_status']; ?></td> <td class="cellbody3"><?php echo $row_dio1['fac_status']; ?></td> <td class="cellbody3"><?php echo $row_dio1['sen_status']; ?></td> </tr> <?php } while ($row_dio1 = mysql_fetch_assoc($dio1)); ?> <tr valign="top"> <td colspan="13" class="cellbody"> </td> </tr> <tr valign="top"> <td colspan="13" class="cellbody"><strong>KEYS: </strong>DEPT=Department, FAC=Faculty, SEN=Senate, A=Approved, NYA=Not Yet Approved.</td> </tr> </table> <div class="headingstyled">Summary of Result</div> <table width="98%" cellpadding="3" cellspacing="2" border="0"> <tr valign="top"> <td width="450px"> <table width="450px" cellpadding="3" cellspacing="2" border="0"> <tr valign="top"> <td class="cellhead">Previous Semesters</td> <td class="cellhead">Current Semester</td> <td class="cellhead">All Semesters</td> </tr> <tr valign="top"> <td class="cellbody"> <?php // FIXED: Previous Semesters = All courses BEFORE this semester // This includes: // - All sessions before current session // - If current semester is 2, also include semester 1 of current session if($i == 1) { // For first semester: Previous = All courses from sessions BEFORE current session $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='$mat'"; } else { // For second semester: Previous = All courses from sessions BEFORE current session + Semester 1 of current session $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='$mat'"; } $result = mysql_query($sql, $csn) or die(mysql_error()); $row = mysql_fetch_array($result); $ptur = $row[0] ? $row[0] : 0; // All registered units (Total UT) // Total Units with scores entered if($i == 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='$mat' and r.score>=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='$mat' and r.score>=0"; } $result = mysql_query($sql, $csn) or die(mysql_error()); $row = mysql_fetch_array($result); $ptut = $row[0] ? $row[0] : 0; // Total Units Passed (score >= 40) if($i == 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='$mat' and r.score>=40"; } 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='$mat' and r.score>=40"; } $result = mysql_query($sql, $csn) or die(mysql_error()); $row = mysql_fetch_array($result); $ptup = $row[0] ? $row[0] : 0; // Total Units with NULL scores (not yet entered) if($i == 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='$mat' and r.score IS NULL"; } 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='$mat' and r.score IS NULL"; } $result = mysql_query($sql, $csn) or die(mysql_error()); $row = mysql_fetch_array($result); $ptun = $row[0] ? $row[0] : 0; // Total Weighted Grade Points (only for courses with scores) if($i == 1) { $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='$mat' and r.score>=0"; } else { $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='$mat' and r.score>=0"; } $result = mysql_query($sql, $csn) or die(mysql_error()); $row = mysql_fetch_array($result); $ptwgp = $row[0] ? $row[0] : 0; // Calculate CGPA based on ALL registered units (including those without scores) if($ptur > 0) { $pcgpa = $ptwgp / $ptur; $pcgpa = round($pcgpa, 2); } else { $pcgpa = 0; } ?> <table border="1" cellpadding="3" cellspacing="2" frame="box" rules="rows"> <tr valign="top"><td width="80px"><b>Total UT: </b></td><td width="40px"><?php echo($ptur); ?></td></tr> <tr valign="top"><td><b>Total UP: </b></td><td><?php echo($ptup); ?></td></tr> <tr valign="top"><td><b>Total UN: </b></td><td><?php echo($ptun); ?></td></tr> <tr valign="top"><td><b>CGPA: </b></td><td><?php echo($pcgpa); ?></td></tr> </table> </td> <td class="cellbody"> <?php // CURRENT SEMESTER - This semester only // Total Units Registered (all courses) $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.semester=$i and r.matric='$mat'"; $result = mysql_query($sql, $csn) or die(mysql_error()); $row = mysql_fetch_array($result); $ctur = $row[0] ? $row[0] : 0; // All registered units // Total Units with scores entered $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.semester=$i and r.matric='$mat' and r.score>=0"; $result = mysql_query($sql, $csn) or die(mysql_error()); $row = mysql_fetch_array($result); $ctut = $row[0] ? $row[0] : 0; // Total Units Passed (score >= 40) $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.semester=$i and r.matric='$mat' and r.score>=40"; $result = mysql_query($sql, $csn) or die(mysql_error()); $row = mysql_fetch_array($result); $ctup = $row[0] ? $row[0] : 0; // Total Units with NULL scores (not yet entered) $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.semester=$i and r.matric='$mat' and r.score IS NULL"; $result = mysql_query($sql, $csn) or die(mysql_error()); $row = mysql_fetch_array($result); $ctun = $row[0] ? $row[0] : 0; // Total Weighted Grade Points (only for courses with scores) $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.semester=$i and r.matric='$mat' and r.score>=0"; $result = mysql_query($sql, $csn) or die(mysql_error()); $row = mysql_fetch_array($result); $ctwgp = $row[0] ? $row[0] : 0; // Calculate CGPA based on ALL registered units (including those without scores) if($ctur > 0) { $ccgpa = $ctwgp / $ctur; $ccgpa = round($ccgpa, 2); } else { $ccgpa = 0; } ?> <table border="1" cellpadding="3" cellspacing="2" frame="box" rules="rows"> <tr valign="top"><td width="80px"><b>Total UT: </b></td><td width="40px"><?php echo($ctur); ?></td></tr> <tr valign="top"><td><b>Total UP: </b></td><td><?php echo($ctup); ?></td></tr> <tr valign="top"><td><b>Total UN: </b></td><td><?php echo($ctun); ?></td></tr> <tr valign="top"><td><b>CGPA: </b></td><td><?php echo($ccgpa); ?></td></tr> </table> </td> <td class="cellbody"> <?php // ALL SEMESTERS - All courses up to current semester $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<=$i)) and r.matric='$mat'"; $result = mysql_query($sql, $csn) or die(mysql_error()); $row = mysql_fetch_array($result); $atur = $row[0] ? $row[0] : 0; // All registered units // Total Units with scores entered $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<=$i)) and r.matric='$mat' and r.score>=0"; $result = mysql_query($sql, $csn) or die(mysql_error()); $row = mysql_fetch_array($result); $atut = $row[0] ? $row[0] : 0; // Total Units Passed (score >= 40) $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<=$i)) and r.matric='$mat' and r.score>=40"; $result = mysql_query($sql, $csn) or die(mysql_error()); $row = mysql_fetch_array($result); $atup = $row[0] ? $row[0] : 0; // Total Units with NULL scores (not yet entered) $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<=$i)) and r.matric='$mat' and r.score IS NULL"; $result = mysql_query($sql, $csn) or die(mysql_error()); $row = mysql_fetch_array($result); $atun = $row[0] ? $row[0] : 0; // Total Weighted Grade Points (only for courses with scores) $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<=$i)) and r.matric='$mat' and r.score>=0"; $result = mysql_query($sql, $csn) or die(mysql_error()); $row = mysql_fetch_array($result); $atwgp = $row[0] ? $row[0] : 0; // Calculate CGPA based on ALL registered units (including those without scores) if($atur > 0) { $acgpa = $atwgp / $atur; $acgpa = round($acgpa, 2); } else { $acgpa = 0; } ?> <table border="1" cellpadding="3" cellspacing="2" frame="box" rules="rows"> <tr valign="top"><td width="80px"><b>Total UT: </b></td><td width="40px"><?php echo($atur); ?></td></tr> <tr valign="top"><td><b>Total UP: </b></td><td><?php echo($atup); ?></td></tr> <tr valign="top"><td><b>Total UN: </b></td><td><?php echo($atun); ?></td></tr> <tr valign="top"><td><b>CGPA: </b></td><td><?php echo($acgpa); ?></td></tr> </table> </td> </tr> </table> </td> <td> <div id="chart<?php echo($i); ?>" style="width:350px;height:150px;border:1px solid #A4BED4;"></div> <p> <script> var data<?php echo($i); ?> = [ { CGPA:"<?php echo($pcgpa); ?>", Semester:"Previous" }, { CGPA:"<?php echo($ccgpa); ?>", Semester:"Current" }, { CGPA:"<?php echo($acgpa); ?>", Semester:"All" } ]; var barChart<?php echo($i); ?> = new dhtmlXChart({ view:"barH", container:"chart<?php echo($i); ?>", value:"#CGPA#", width:20, label: "#CGPA#", gradient:"3d", color:"#ffcc00", xAxis:{ start:0, end:7, step:1, title:"CGPA", lines: true }, yAxis:{ title:"Semester(s)", template:"#Semester#" }, padding:{ left:75, right:30 } }) barChart<?php echo($i); ?>.parse(data<?php echo($i); ?>,"json"); </script> </p> </td> </tr> <tr valign="top"> <td><table width="100%" border="1" cellspacing="1" cellpadding="1" style="border-collapse:collapse"> <tr> <th align="left" scope="col">Scores</th> <th align="center" scope="col"> </th> <th align="center" scope="col"> </th> </tr> <tr> <td align="left">70-100</td> <td align="center">A</td> <td align="center">5</td> </tr> <tr> <td align="left">60-69</td> <td align="center">B</td> <td align="center">4</td> </tr> <tr> <td align="left">50-59</td> <td align="center">C</td> <td align="center">3</td> </tr> <tr> <td align="left">45-49</td> <td align="center">D</td> <td align="center">2</td> </tr> <tr> <td align="left">40-44</td> <td align="center">E</td> <td align="center">1</td> </tr> <tr> <td align="left">0-39</td> <td align="center">F</td> <td align="center">0</td> </tr> </table></td> <td><table width="100%" border="1" cellspacing="1" cellpadding="1" style="border-collapse:collapse"> <tr> <th align="left" scope="col">Average(CGPA)</th> <th scope="col"> </th> </tr> <tr> <td>4.50-5.00</td> <td>First Class</td> </tr> <tr> <td>3.50-4.49</td> <td>2nd Class Upper</td> </tr> <tr> <td>2.40-3.49</td> <td>2nd Class Lower</td> </tr> <tr> <td>1.50-2.39</td> <td>Third Class</td> </tr> <tr> <td>1.00-1.49</td> <td>Pass</td> </tr> <tr> <td>0.00-1.48</td> <td>Fail</td> </tr> </table></td> </tr> </table> </div><div class="post-bot2"></div> <?php } ?> <?php } ?> <div style="text-align:center; font-size:20px"><a href="checkresprev.php"><input name="donecourse" type="submit" id="donecourse" value="Print Preview" style="font-size:20px; font-weight:bold; color:maroon;" /></a></div> <!--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("dstu.php"); }?> <?php } else { include("student.php"); }?>