D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
diafrica
/
result.dominicaninstitute.org
/
Filename :
checkresprev.php
back
Copy
<?php if (!$_SESSION){ session_start(); } include("Connecter/dataconn.php"); $natasession=$_SESSION['ss']; $progid=$_SESSION["deptsn"]; $mat=$_SESSION["matric_no"]; $level=$_SESSION["level"]; $de=$_GET['de']; $_SESSION["de"] = $de; $session=$natasession; $programmesn=$progid; ?> <!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" /> <link rel="shortcut icon" href="logo.ico" type="image/ico" /> <script src="bar/dhtmlxchart.js" type="text/javascript"></script> <link rel="STYLESHEET" type="text/css" href="bar/dhtmlxchart.css"> <style type="text/css"> body,td { font-family: Verdana, Geneva, sans-serif; font-size:12px; } </style> <style type="text/css" media="print"> @media print { .no-print { display: none !important; } } </style> <style type="text/css"> body { margin-left: 5px; margin-top: 5px; margin-right: 5px; margin-bottom: 5px; } </style> <title>::Result Preview</title> </head> <body> <table width="100%" border="0" cellpadding="0"> <tr> <td scope="col"><table width="100%" border="0" cellpadding="0"> <tr> <td scope="col"><table width="100%" border="0" cellpadding="0"> <tr> <td width="22%" align="left" scope="col"><img src="images/logo.png" width="87" height="78" /></td> <td width="78%" align="left" scope="col"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <th align="left" scope="col"><span style="font-size:24px"><strong>DOMINICAN INSTITUTE IBADAN</strong></span></th> </tr> <tr> <td><hr /></td> </tr> <tr> <td><strong>Education Layout, Oyo Road, Samonda, Ibadan, Oyo State.</strong></td> </tr> </table> </td> </tr> </table></td> </tr> <tr> <td align="center"><hr /></td> </tr> <tr> <td align="center" style="font-size:20px"><strong><?php echo $_SESSION['level'];?>00 LEVEL RESULT</strong></td> </tr> <tr> <td align="center"><hr /></td> </tr> <tr> <td><table width="100%" border="0" cellspacing="1" cellpadding="1"> <tr> <td width="50%" align="left" scope="col"><strong>NAME:</strong> <?php echo $_SESSION['stud_name'];?></td> <td width="50%" align="left" scope="col"><strong>MATRIC NUMBER:</strong> <?php echo $_SESSION['matric_no'];?></td> </tr> <tr> <td align="left" scope="col"><strong>LEVEL OF STUDY:</strong> <?php echo $_SESSION['level'];?>00 Level</td> <td align="left" scope="col"><strong>SESSION:</strong> <?php echo $_SESSION['ss'];?> <strong>YEAR OF ENTRY: </strong><?php echo $_SESSION['yearofentry'];?></td> </tr> <tr> <td align="left" scope="col"><strong>FACULTY:</strong> <?php echo $_SESSION['faculty'];?></td> <td align="left" scope="col"><strong>DEPARTMENT:</strong> <?php echo $_SESSION['dept'];?></td> </tr> <tr> <td align="left" scope="col"><strong>PROGRAM:</strong> <?php echo $_SESSION['prog'];?></td> <td align="left" scope="col"><strong>DEGREE IN VIEW:</strong> <?php echo $_SESSION['degree'];?> <?php echo $_SESSION['prog'];?></td> </tr> </table></td> </tr> <?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; $semester = $i; ?> <tr> <td><?php if($i == 1){?><hr /><?php }?> </td> </tr> <tr> <td align="left" style="font-size:20px"> <?php if($semester == 2){?> <p style="page-break-after: always;"></p> <p style="page-break-after: always;"></p> <br /><br /> <?php }?> <strong><?php if($i == 1){echo "FIRST";}else{echo "SECOND";}?> SEMESTER RESULT</strong></td> </tr> <tr> <td> <table width="100%" cellpadding="3" cellspacing="2" border="1" style="border-collapse:collapse"> <tr valign="top"> <td rowspan="2" align="center" valign="middle" bgcolor="#CCCCCC"> </td> <td width="5%" rowspan="2" valign="middle" bgcolor="#CCCCCC"><strong>Code</strong></td> <td rowspan="2" valign="middle" bgcolor="#CCCCCC"><strong>Course</strong></td> <td rowspan="2" align="center" valign="middle" bgcolor="#CCCCCC"><strong>Unit</strong></td> <td rowspan="2" align="center" valign="middle" bgcolor="#CCCCCC"><strong>Status</strong></td> <td rowspan="2" valign="middle" bgcolor="#CCCCCC"><strong>Stand</strong></td> <td rowspan="2" align="center" valign="middle" bgcolor="#CCCCCC"><strong>Stance</strong></td> <td rowspan="2" align="center" valign="middle" bgcolor="#CCCCCC"><strong>Score</strong></td> <td rowspan="2" align="center" valign="middle" bgcolor="#CCCCCC"><strong>GP</strong></td> <td rowspan="2" align="center" valign="middle" bgcolor="#CCCCCC"><strong>WGP</strong></td> <td colspan="3" align="center" bgcolor="#CCCCCC" style="font-weight: bold">APPROVAL STATUS</td> </tr> <tr valign="top"> <td align="center" bgcolor="#CCCCCC" style="font-weight: bold">DEPT</td> <td align="center" bgcolor="#CCCCCC" style="font-weight: bold">FAC</td> <td align="center" bgcolor="#CCCCCC" style="font-weight: bold">SEN</td> </tr> <?php do { $z++; ?> <tr valign="top"> <td align="center"><?php echo($z); ?>.</td> <td ><?php echo($row_dio1['code']); ?></td> <td><?php echo($row_dio1['namer']); ?></td> <td align="center"><?php echo($row_dio1['unit']); ?></td> <td align="center" ><?php echo($row_dio1['status']); ?></td> <td ><?php echo($row_dio1['stand']); ?></td> <td align="center" ><?php echo($row_dio1['stance']); ?></td> <td align="center"><?php echo($row_dio1['score']); ?></td> <td align="center"><?php echo($row_dio1['gp']); ?></td> <?php $wgp=$row_dio1['unit'] * $row_dio1['gp']; ?> <td align="center" ><?php echo($wgp); ?></td> <td style="text-align: center" ><?php echo $row_dio1['dept_status']; ?></td> <td style="text-align: center" ><?php echo $row_dio1['fac_status']; ?></td> <td style="text-align: center" ><?php echo $row_dio1['sen_status']; ?></td> </tr> <?php } while ($row_dio1 = mysql_fetch_assoc($dio1)); ?> </table> </td> </tr> <tr> <td><span class="cellbody"><strong>KEYS: </strong>DEPT=Department, FAC=Faculty, SEN=Senate, A=Approved, NYA=Not Yet Approved.</span></td> </tr> <?php if($i == 2){?> <?php }?> <tr> <td> <table width="100%" border="0"> <tr valign="top"> <td> <table cellpadding="2" border="1" style="border-collapse:collapse"> <tr valign="top"> <td colspan="3" align="center" class="cellhead"><strong>RESULT SUMMARY</strong></td> </tr> <tr valign="top"> <td bgcolor="#CCCCCC" class="cellhead"><strong>Previous Semesters</strong></td> <td bgcolor="#CCCCCC" class="cellhead"><strong>Current Semester</strong></td> <td bgcolor="#CCCCCC" class="cellhead"><strong>All Semesters</strong></td> </tr> <tr valign="top"> <td class="cellbody"> <?php // FIXED: Previous Semesters = All courses BEFORE this semester 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 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="2" frame="box" style="border-collapse:collapse"> <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 // FIXED: Current Semester - This semester only (removed level condition for extra year students) $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="2" frame="box" style="border-collapse:collapse"> <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 // FIXED: 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="2"frame="box" style="border-collapse:collapse"> <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> <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> </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> <?php } ?> </td> </tr> <?php }?> <tr> <td> </td> </tr> <tr> <td align="center" class="no-print"> <table width="100%" border="0" cellspacing="5" cellpadding="5" style="border-collapse:collapse"> <tr> <td width="50%" align="right" scope="col"> <a href="checkdresults.php?tab=<?php echo $programmesn; ?>&who=<?php echo $mat; ?>&ses=<?php echo $session; ?>&lev=<?php echo $level; ?>"><input name="back" type="submit" value="Back" style="font-size:25px; font-weight:bold; color:#F90;" /></a> </td> <td width="50%" align="left" scope="col"> <input onClick="printer()" title="Send to printer" id="print-me" name="print" type="submit" value="Print" style="font-size:25px; font-weight:bold; color:#090;" /> </td> </tr> </table> </td> </tr> <tr> <td align="right"> </td> </tr> </table></td> </tr> </table> </body> </html> <script type="text/javascript"> function printer() { window.print(); } </script>