D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
diafrica
/
result.dominicaninstitute.org
/
Filename :
liststudentsassigned_temp.php
back
Copy
<?php if (!$_SESSION){ session_start(); } $acc=$_SESSION['acc']; $yto=$_SESSION['yto']; if(isset($acc) && ($acc=="administratoroftheduresult2018byto")){?> <?php include("Connecter/dataconn.php"); ?> <?php include("checkforpending.php"); ?> <?php /* if(isset($_GET['good'])) { $a1=$_GET['good']; $sqlwork="update tempstudents set status='good' where sn = $a1"; $work=@mysql_query($sqlwork); } if(isset($_GET['suspend'])) { $a1=$_GET['suspend']; $sqlwork="update tempstudents set status='suspend' where sn = $a1"; $work=@mysql_query($sqlwork); } if(isset($_GET['expel'])) { $a1=$_GET['expel']; $sqlwork="update tempstudents set status='expel' where sn = $a1"; $work=@mysql_query($sqlwork); } */ ?> <?php if(isset($_GET['good'])) { $a1=$_GET['good']; $sqlwork="update tempstudents set status='good' where sn = $a1"; $work=@mysql_query($sqlwork); $sqlwork="select * from tempstudents where sn = $a1"; $rework=@mysql_query($sqlwork); $rowwork=mysql_fetch_array($rework); $sqlwork="delete from studentsexisting where matric = '".$rowwork['matric']."' and session>'".$rowwork['session']."'"; $work=@mysql_query($sqlwork); //Begin of register courses $mat2=$rowwork['matric']; $adeprogid=$rowwork['programmesn']; $adesession=$rowwork['session']; $adelevel=$rowwork['level']; $adede=$rowwork['de']; //Go through registered courses for all $query_vin = "SELECT *,r.sn as dsn,t.sn as dcode FROM coursesregisteredall as r inner join coursestobetaken as t on r.coursesn=t.sn where t.programmesn=$adeprogid and t.session='$adesession' and t.level=$adelevel and t.de='$adede'"; $vin = mysql_query($query_vin, $csn) or die(mysql_error()); $num_vin=mysql_num_rows($vin); //if any exists if($num_vin>0){ while($row_vin=mysql_fetch_array($vin)){ $a1=$row_vin['dcode']; $sqlwork2="select * from coursesregistered where coursesn=$a1 and matric='$mat2'"; $work2=mysql_query($sqlwork2); $num_work3=mysql_num_rows($work2); if($num_work3==0){ $sql="insert into coursesregistered (coursesn,matric,archived) values ($a1,'$mat2','No')"; $result=@mysql_query($sql); } } } //End of register courses } if(isset($_GET['suspend'])) { $a1=$_GET['suspend']; $sqlwork="update tempstudents set status='suspend' where sn = $a1"; $work=@mysql_query($sqlwork); $sqlwork="select * from tempstudents where sn = $a1"; $rework=@mysql_query($sqlwork); $rowwork=mysql_fetch_array($rework); $sqlwork="delete from studentsexisting where matric = '".$rowwork['matric']."' and session>'".$rowwork['session']."'"; $work=@mysql_query($sqlwork); //Begin of Delete of registered courses from session onwards $mat2=$rowwork['matric']; $adeprogid=$rowwork['programmesn']; $adesession=$rowwork['session']; $adede=$rowwork['de']; $sqlcourse="select * from coursestobetaken where programmesn=$adeprogid and session>='$adesession' and de='$adede'"; $recourse = mysql_query($sqlcourse, $csn) or die(mysql_error()); while($rowcourse=mysql_fetch_array($recourse)){ $sqlwork="delete from coursesregistered where matric = '".$mat2."' and coursesn=".$rowcourse['sn']; $work=mysql_query($sqlwork) or die(mysql_error()); } //End of Delete of registered courses from session onwards } if(isset($_GET['expel'])) { $a1=$_GET['expel']; $sqlwork="update tempstudents set status='expel' where sn = $a1"; $work=@mysql_query($sqlwork); $sqlwork="select * from tempstudents where sn = $a1"; $rework=@mysql_query($sqlwork); $rowwork=mysql_fetch_array($rework); $sqlwork="delete from studentsexisting where matric = '".$rowwork['matric']."' and session>'".$rowwork['session']."'"; $work=@mysql_query($sqlwork); //Begin of Delete of registered courses from session onwards $mat2=$rowwork['matric']; $adeprogid=$rowwork['programmesn']; $adesession=$rowwork['session']; $adede=$rowwork['de']; $sqlcourse="select * from coursestobetaken where programmesn=$adeprogid and session>='$adesession' and de='$adede'"; $recourse = mysql_query($sqlcourse, $csn) or die(mysql_error()); while($rowcourse=mysql_fetch_array($recourse)){ $sqlwork="delete from coursesregistered where matric = '".$mat2."' and coursesn=".$rowcourse['sn']; $work=mysql_query($sqlwork) or die(mysql_error()); } //End of Delete of registered courses from session onwards } ?> <?php if(isset($_GET['addstudent'])) { $a1=$_GET['matric']; $a2=$_GET['surname']; $a3=$_GET['firstname']; $a4=$_GET['othernames']; $a5=$_GET['dob']; $a6=$_GET['passwrd']; $b1=$_GET['programmesn']; $b2=$_GET['yearofentry']; $b3=$_GET['de']; $b4=$_GET['session']; $b5=$_GET['level']; $a1=strtoupper($a1); $sqlwork2="select * from students where matric='$a1'"; $work2=mysql_query($sqlwork2); $num_work2=mysql_num_rows($work2); if($num_work2==0){ $sqlwork="insert into students (matric,surname,firstname,othernames,dob,programmesn,yearofentry,passwrd,de,archived) values ('$a1','$a2','$a3','$a4','$a5',$b1,'$b2','$a6','$b3','No')"; $work=@mysql_query($sqlwork); $sqlwork="insert into tempstudents (matric,programmesn,yearofentry,session,level,de,archived,status) values ('$a1',$b1,'$b2','$b4',$b5,'$b3','No','good')"; $work=@mysql_query($sqlwork); } } ?> <?php if(isset($_GET['ses'])) { $natasession=$_GET['ses']; $progid=$_GET['tab']; $query_dio1 = "SELECT * FROM programmes where sn=".$progid; $dio1 = mysql_query($query_dio1, $csn) or die(mysql_error()); $row_dio1 = mysql_fetch_assoc($dio1); $typer=$row_dio1['typer']; $n=$row_dio1['numberofyears']; $query_dio2 = "SELECT * FROM departments where sn=".$row_dio1['departmentsn']; $dio2 = mysql_query($query_dio2, $csn) or die(mysql_error()); $row_dio2 = mysql_fetch_assoc($dio2); ?> <!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"); ?> <link rel="stylesheet" type="text/css" href="cal/dhtmlxcalendar.css"> <link rel="stylesheet" type="text/css" href="cal/skins/dhtmlxcalendar_dhx_web.css"> <script src="cal/dhtmlxcalendar.js"></script> <script> function doOnLoad() { var myCalendar1 = new dhtmlXCalendarObject(["dob"]); myCalendar1.setSkin('dhx_web'); myCalendar1.setWeekStartDay=7; myCalendar1.setDateFormat("%Y-%m-%d"); myCalendar1.hideTime(); var myCalendar2 = new dhtmlXCalendarObject(["dob2"]); myCalendar2.setSkin('dhx_web'); myCalendar2.setWeekStartDay=7; myCalendar2.setDateFormat("%Y-%m-%d"); myCalendar2.hideTime(); } </script> </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">Students for <?php echo($row_dio1['namer']); ?> [<?php echo($row_dio2['namer']); ?>] in <?php echo($natasession); ?> Session</div> <hr /> <?php //Loop for Each Year/Level in the Programme of Study ?> <?php for($i=0;$i<$n;$i++){ $p=$i+1; ?> <?php $session=$natasession; $level=$p; $programmesn=$progid; $de=''; ?> <div class="headingbigger">Year <?php echo($p); ?></div> <div class="post2"> <table width="100%" border="1" cellpadding="3" cellspacing="2" frame="vsides" rules="rows"> <?php $query_vin = "SELECT * FROM tempstudents where programmesn=$programmesn and session='$session' and level=$level and de='$de' order by status asc, matric asc"; $vin = mysql_query($query_vin, $csn) or die(mysql_error()); $num_vin=mysql_num_rows($vin); ?> <?php if($num_vin<1){ echo("<tr><td colspan='9' style='color:#990000;'>No Student Added Yet!</td></tr>"); } else { ?> <tr valign="top" style="background-color:#000; color:#FFF;"> <td width="20px"><b> </b></td> <td width="60px"><b>Matric</b></td> <td><b>Surname</b></td> <td><b>Firstname</b></td> <td><b>Othernames</b></td> <td><b>DOB</b></td> <td><b>YearofEntry</b></td> <td><b>Status</b></td> <td width="130px"><b> </b></td> </tr> <?php $f=0; while($row_vin = mysql_fetch_assoc($vin)) { $f++; ?> <tr valign="top"> <td align="left"><?php echo($f); ?>.</td> <td align="left"><?php echo($row_vin['matric']); ?></td> <?php $sql="SELECT * FROM students where matric = '".$row_vin['matric']."'"; $result = mysql_query($sql); $row = mysql_fetch_array($result); ?> <td align="left"><?php echo($row['surname']); ?></td> <td align="left"><?php echo($row['firstname']); ?></td> <td align="left"><?php echo($row['othernames']); ?></td> <td align="left"><?php echo($row['dob']); ?></td> <td align="left"><?php echo($row_vin['yearofentry']); ?></td> <td align="left"><?php echo($row_vin['status']); ?></td> <td align="center"> <?php if($row_vin['status']=='good'){ ?> <a href="liststudentsassigned.php?tab=<?php echo $programmesn; ?>&ses=<?php echo $session; ?>&suspend=<?php echo($row_vin['sn']); ?>">Suspend</a> <a href="liststudentsassigned.php?tab=<?php echo $programmesn; ?>&ses=<?php echo $session; ?>&expel=<?php echo($row_vin['sn']); ?>">Expel</a> <?php } ?> <?php if($row_vin['status']=='suspend'){ ?> <a href="liststudentsassigned.php?tab=<?php echo $programmesn; ?>&ses=<?php echo $session; ?>&good=<?php echo($row_vin['sn']); ?>">UnSuspend</a> <a href="liststudentsassigned.php?tab=<?php echo $programmesn; ?>&ses=<?php echo $session; ?>&expel=<?php echo($row_vin['sn']); ?>">Expel</a> <?php } ?> <?php if($row_vin['status']=='expel'){ ?> <a href="liststudentsassigned.php?tab=<?php echo $programmesn; ?>&ses=<?php echo $session; ?>&good=<?php echo($row_vin['sn']); ?>">UnExpel</a> <a href="liststudentsassigned.php?tab=<?php echo $programmesn; ?>&ses=<?php echo $session; ?>&suspend=<?php echo($row_vin['sn']); ?>">Suspend</a> <?php } ?> </td> </tr> <?php } } ?> </table> <?php if($p==1){ ?> <table width="100%" border="1" cellpadding="3" cellspacing="2" frame="border" rules="none"> <tr valign="top"> <td width="50px" style="background-color:#000; color:#FFF; font-weight:bold;">Add Students Here</td> <td> <form action="liststudentsassigned.php" method="get" name="form1" id="form1"> <b>Matric:</b><input name="matric" type="text" size="8" required="required" /> <b>Surname:</b><input name="surname" type="text" size="15" required="required" /> <b>FirstName:</b><input name="firstname" type="text" size="8" required="required" /> <b>OtherNames:</b><input name="othernames" type="text" size="8" /><br /> <b>Password:</b><input name="passwrd" type="text" size="8" required="required" /> <b>Date of Birth:</b><input name="dob" id="dob" type="text" size="8" required="required" readonly="readonly" value="<?php echo(date('Y-m-d')); ?>" onmousedown="doOnLoad();" /> <div align="right"> <input name="addstudent" type="submit" id="addstudent" value=" Add Student " /> <input name="ses" type="hidden" value="<?php echo($session); ?>" /> <input name="tab" type="hidden" value="<?php echo($programmesn); ?>" /> <input name="programmesn" type="hidden" value="<?php echo($programmesn); ?>" /> <input name="session" type="hidden" value="<?php echo($session); ?>" /> <input name="yearofentry" type="hidden" value="<?php echo(substr($session,0,4)); ?>" /> <input name="level" type="hidden" value="<?php echo($level); ?>" /> <input name="de" type="hidden" value="<?php echo($de); ?>" /> </div> </form> </td> </tr> </table> <?php } ?> <div> </div> <div> </div> <div> </div> <div> </div> </div><div class="post-bot2"></div> <?php //End of Loop for Each Year/Level in the Programme of Study ?> <?php } ?> <?php //Beginning of Direct Entry ?> <?php if($typer=='Degree'){ ?> <div class="headingbiggest">Students for DIRECT ENTRY</div> <hr /> <?php //Loop for Each Year/Level in the Programme of Study ?> <?php for($i=1;$i<$n;$i++){ $p=$i+1; ?> <?php $session=$natasession; $level=$p; $programmesn=$progid; $de='DE'; ?> <div class="headingbigger">Year <?php echo($p); ?> [<?php echo($de); ?>]</div> <div class="post2"> <table width="100%" border="1" cellpadding="3" cellspacing="2" frame="vsides" rules="rows"> <?php $query_vin = "SELECT * FROM tempstudents where programmesn=$programmesn and session='$session' and level=$level and de='$de' order by status asc, matric asc"; $vin = mysql_query($query_vin, $csn) or die(mysql_error()); $num_vin=mysql_num_rows($vin); ?> <?php if($num_vin<1){ echo("<tr><td colspan='9' style='color:#990000;'>No Student Added Yet!</td></tr>"); } else { ?> <tr valign="top" style="background-color:#000; color:#FFF;"> <td width="20px"><b> </b></td> <td width="60px"><b>Matric</b></td> <td><b>Surname</b></td> <td><b>Firstname</b></td> <td><b>Othernames</b></td> <td><b>DOB</b></td> <td><b>YearofEntry</b></td> <td><b>Status</b></td> <td width="130px"><b> </b></td> </tr> <?php $f=0; while($row_vin = mysql_fetch_assoc($vin)) { $f++; ?> <tr valign="top"> <td align="left"><?php echo($f); ?>.</td> <td align="left"><?php echo($row_vin['matric']); ?></td> <?php $sql="SELECT * FROM students where matric = '".$row_vin['matric']."'"; $result = mysql_query($sql); $row = mysql_fetch_array($result); ?> <td align="left"><?php echo($row['surname']); ?></td> <td align="left"><?php echo($row['firstname']); ?></td> <td align="left"><?php echo($row['othernames']); ?></td> <td align="left"><?php echo($row['dob']); ?></td> <td align="left"><?php echo($row_vin['yearofentry']); ?></td> <td align="left"><?php echo($row_vin['status']); ?></td> <td align="center"> <?php if($row_vin['status']=='good'){ ?> <a href="liststudentsassigned.php?tab=<?php echo $programmesn; ?>&ses=<?php echo $session; ?>&suspend=<?php echo($row_vin['sn']); ?>">Suspend</a> <a href="liststudentsassigned.php?tab=<?php echo $programmesn; ?>&ses=<?php echo $session; ?>&expel=<?php echo($row_vin['sn']); ?>">Expel</a> <?php } ?> <?php if($row_vin['status']=='suspend'){ ?> <a href="liststudentsassigned.php?tab=<?php echo $programmesn; ?>&ses=<?php echo $session; ?>&good=<?php echo($row_vin['sn']); ?>">UnSuspend</a> <a href="liststudentsassigned.php?tab=<?php echo $programmesn; ?>&ses=<?php echo $session; ?>&expel=<?php echo($row_vin['sn']); ?>">Expel</a> <?php } ?> <?php if($row_vin['status']=='expel'){ ?> <a href="liststudentsassigned.php?tab=<?php echo $programmesn; ?>&ses=<?php echo $session; ?>&good=<?php echo($row_vin['sn']); ?>">UnExpel</a> <a href="liststudentsassigned.php?tab=<?php echo $programmesn; ?>&ses=<?php echo $session; ?>&suspend=<?php echo($row_vin['sn']); ?>">Suspend</a> <?php } ?> </td> </tr> <?php } } ?> </table> <?php if($p==2){ ?> <table width="100%" border="1" cellpadding="3" cellspacing="2" frame="border" rules="none"> <tr valign="top"> <td width="50px" style="background-color:#000; color:#FFF; font-weight:bold;">Add Students Here</td> <td> <form action="liststudentsassigned.php" method="get" name="form1" id="form1"> <b>Matric:</b><input name="matric" type="text" size="8" required="required" /> <b>Surname:</b><input name="surname" type="text" size="15" required="required" /> <b>FirstName:</b><input name="firstname" type="text" size="8" required="required" /> <b>OtherNames:</b><input name="othernames" type="text" size="8" /><br /> <b>Password:</b><input name="passwrd" type="text" size="8" required="required" /> <b>Date of Birth:</b><input name="dob" id="dob2" type="text" size="8" required="required" readonly="readonly" value="<?php echo(date('Y-m-d')); ?>" onmousedown="doOnLoad();" /> <div align="right"> <input name="addstudent" type="submit" id="addstudent" value=" Add Student " /> <input name="ses" type="hidden" value="<?php echo($session); ?>" /> <input name="tab" type="hidden" value="<?php echo($programmesn); ?>" /> <input name="programmesn" type="hidden" value="<?php echo($programmesn); ?>" /> <input name="session" type="hidden" value="<?php echo($session); ?>" /> <input name="yearofentry" type="hidden" value="<?php echo(substr($session,0,4)); ?>" /> <input name="level" type="hidden" value="<?php echo($level); ?>" /> <input name="de" type="hidden" value="<?php echo($de); ?>" /> </div> </form> </td> </tr> </table> <?php } ?> <div> </div> <div> </div> <div> </div> <div> </div> </div> <div class="post-bot2"></div> <?php //End of Loop for Each Year/Level in the Programme of Study ?> <?php } ?> <?php //End of Direct Entry ?> <?php } ?> <form action="newsession3.php" method="post" name="form1" id="form1"> <div align="right"> <input name="donestudent" type="submit" id="donestudent" value=" Done " style="font-size:16px; font-weight:bold; color:maroon;" /> <input name="ses" type="hidden" value="<?php echo($session); ?>" /> <input name="tab" type="hidden" value="<?php echo($programmesn); ?>" /> </div> </form> <!--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("dadmin.php"); } ?> <?php } else { include("ddadmin.php"); }?>