1#@!#!123s

: / home / diafrica / result.dominicaninstitute.org /
Filename : liststudentsassigned_temp.php
back
<?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>&nbsp;</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>&nbsp;</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>
&nbsp;&nbsp;
<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>
&nbsp;&nbsp;
<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>
&nbsp;&nbsp;
<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" />&nbsp;
<b>Surname:</b><input name="surname" type="text" size="15" required="required" />&nbsp;
<b>FirstName:</b><input name="firstname" type="text" size="8" required="required" />&nbsp;
<b>OtherNames:</b><input name="othernames" type="text" size="8" /><br />
<b>Password:</b><input name="passwrd" type="text" size="8" required="required" />&nbsp;
<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>&nbsp;</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>&nbsp;</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>&nbsp;</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>&nbsp;</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>
&nbsp;&nbsp;
<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>
&nbsp;&nbsp;
<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>
&nbsp;&nbsp;
<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" />&nbsp;
<b>Surname:</b><input name="surname" type="text" size="15" required="required" />&nbsp;
<b>FirstName:</b><input name="firstname" type="text" size="8" required="required" />&nbsp;
<b>OtherNames:</b><input name="othernames" type="text" size="8" /><br />
<b>Password:</b><input name="passwrd" type="text" size="8" required="required" />&nbsp;
<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>&nbsp;</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>&nbsp;</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");
}?>