One Hat Cyber Team

View File Name : pending.php

<? include("inc/header.php"); ?>
<style>
table{font-size:12px}
tr:nth-child(even) {background: #CCC;}
tr:nth-child(odd) {background: #FFF;}
</style>

<?php
include("inc/config.php");
$appType=$_GET['appType'];
$query=returnQuery($appType);
$sql=mysql_query($query);
if(!$sql){ echo mysql_error();}
$num=mysql_num_rows($sql);

?>
<pre><span><strong><h4><?php echo returnTitle($appType); ?></h4></strong></span></pre>
<?php if(!$num){echo "No Pending Application";}else{ ?>
<table border="1" cellspacing="0" cellpadding="5" width="100%">
<tr><th>S/No</th><th>Name</th><th>Application No</th><th>Application Date</th><th>View Credentials</th><th>Approval</th></tr>
<?php
$sno=0;
while ($row=mysql_fetch_array($sql)){ 
$sno++; 
//echo returnRows($appType,$row,$sno);
if($appType==1){
?>
<tr><td><?php echo $sno; ?></td><td><?php echo $row['examSurname']." ".$row['examOthernames']; ?></td><td><?php echo $row['examAuthNum']; ?></td><td><?php echo $row['examDateReg']; ?></td><td><a href="viewFellCredentials.php?appType=<?php echo $appType; ?>&studID=<?php echo $row['examID']; ?>">View Application</a></td><td><a href="approveStudent.php?appType=<?php echo $appType; ?>&studID=<?php echo $row['examID']; ?>">Approve Application</a><td></tr>
<?php } elseif($appType==2){ ?>
<tr><td><?php echo $sno; ?></td><td><?php echo $row['examSurname']." ".$row['examOthernames']; ?></td><td><?php echo $row['examAuthNum']; ?></td><td><?php echo $row['examDateReg']; ?></td><td><a href="viewFellCredentials.php?appType=<?php echo $appType; ?>&studID=<?php echo $row['examID']; ?>">View Application</a></td><td><a href="approveStudent.php?appType=<?php echo $appType; ?>&studID=<?php echo $row['examID']; ?>">Approve Application</a><td></tr>
<?php
} elseif($appType==3){?>
<tr><td><?php echo $sno; ?></td><td><?php echo $row['examSurname']." ".$row['examOthernames']; ?></td><td><?php echo $row['examAuthNum']; ?></td><td><?php echo $row['examDateReg']; ?></td><td><a href="viewFellCredentials.php?appType=<?php echo $appType; ?>&studID=<?php echo $row['examID']; ?>">View Application</a></td><td><a href="approveStudent.php?appType=<?php echo $appType; ?>&studID=<?php echo $row['examID']; ?>">Approve Application</a><td></tr>
<?php } elseif($appType==4){ ?>
<tr><td><?php echo $sno; ?></td><td><?php echo $row['examSurname']." ".$row['examOthernames']; ?></td><td><?php echo $row['examAuthNum']; ?></td><td><?php echo $row['examDateReg']; ?></td><td><a href="viewTechCredentials.php?appType=<?php echo $appType; ?>&studID=<?php echo $row['examID']; ?>">View Application</a></td><td><a href="approveStudent.php?appType=<?php echo $appType; ?>&studID=<?php echo $row['examID']; ?>">Approve Application</a><td></tr>	
<?php } elseif($appType==5){ ?>
	<tr><td><?php echo $sno; ?></td><td><?php echo $row['examSurname']." ".$row['examOthernames']; ?></td><td><?php echo $row['examAuthNum']; ?></td><td><?php echo $row['examDateReg']; ?></td><td><a href="viewStudCredentials.php?appType=<?php echo $appType; ?>&studID=<?php echo $row['examID']; ?>">View Application</a></td><td><a href="approveStudent.php?appType=<?php echo $appType; ?>&studID=<?php echo $row['examID']; ?>">Approve Application</a><td></tr>
	
<?php }}
?>
</table>
<?php
}
function returnQuery($appType){
	switch($appType){
		case "1":
		$query="SELECT * FROM examreg a,transaction b,examclearance c WHERE a.examAuthNum=b.transRef AND a.examID=c.studID AND c.appTypeID='$appType' AND b.transStatus='PAID' AND c.clearApproval1='0' AND c.clearAssignNo='0'";
		break;
		
		case "2":
		$query="SELECT * FROM examreg a,transaction b,examclearance c WHERE a.examAuthNum=b.transRef AND a.examID=c.studID AND c.appTypeID='$appType' AND b.transStatus='PAID' AND c.clearApproval1='0' AND c.clearAssignNo='0'";
		break;
		
		case "3":
		$query="SELECT * FROM examreg a,transaction b,examclearance c WHERE a.examAuthNum=b.transRef AND a.examID=c.studID AND c.appTypeID='$appType' AND b.transStatus='PAID' AND c.clearApproval1='0' AND c.clearAssignNo='0'";
		break;
		
		case "4":
		$query="SELECT * FROM examreg a,transaction b,examclearance c WHERE a.examAuthNum=b.transRef AND a.examID=c.studID AND c.appTypeID='$appType' AND b.transStatus='PAID' AND c.clearApproval1='0' AND c.clearAssignNo='0'";
		break;
		
		case "5":
		$query="SELECT * FROM examreg a,transaction b,examclearance c WHERE a.examAuthNum=b.transRef AND a.examID=c.studID AND c.appTypeID='$appType' AND b.transStatus='PAID' AND c.clearApproval1='0' AND c.clearAssignNo='0'";
		break;
	}
	return $query;
}
function returnTitle($appType){
	switch($appType){
		case "1":
		$title='PENDING GDE APPLICATION';
		break;
		
		case "2":
		$title='PENDING TPC APPLICATION';
		break;
		
		case "3":
		$title='PENDING PCI APPLICATION';
		break;
		
		case "4":
		$title='PENDING TECHNICIAN APPLICATION';
		break;
		
		case "5":
		$title='PENDING STUDENT APPLICATION';
		break;
	}
	return $title;
}
?>