One Hat Cyber Team

View File Name : view_reg_app_old.php

<?
include("inc/header.php");


include("inc/fxn.php");

?>
<script>
    function MM_openBrWindow(theURL,winName,features) { //v2.0
        window.open(theURL,winName,features);
    }
</script>
<?
$clear_id=$_GET['clear_id'];
if($clear_id){
	$update=mysql_query("UPDATE clearance_status SET dean_verify='1',branch_verify='1' WHERE clear_id='$clear_id'");
	if($update){
		echo "Graduate Application Approved";
		include("inc/footer.php");
		
		$student_id=GetAny("clearance_status",$clear_id,"clear_id","stud_id");
		$row_details=GetMany("stud_mem_reg",$student_id,"stud_id");
		$surname=$row_details['surname'];
		$othernames=$row_details['othernames'];
		$name= $surname." ".$othernames;
		$auth_num=$row_details['auth_num'];
		
		//send mail
		$email=$row_details['email']; 
		$str = "Nigerian Society of Engineers: Graduate Membership Application";
		 $html_data = '<html><head><title>'.$str.'</title></head><body><table width="100%" align="center" border="0" cellspacing="0" cellpadding="0">
		  <tr>
    <td width="47%" bgcolor="#944B2A"><H1><span style="color:#ffffff">NSE GRADUATE MEMBERSHIP APPLICATION</span></H1>      </td>
  </tr>
<tr><td><h4>Dear '.$name.' </h4><h4>We appreciate your interest in becoming a Graduate Member of the Nigerian Society of Engineers.<br><br><p>Your application has been accepted and is being processed for graduate membership election.</p><br><p>In accordance with the Article of Association of the Society, you are required to pay the sum of N2,000 as detailed below, within four (4) weeks of receipt of this advice, otherwise your election/transfer will be void. Payment can also be made through any of the following:<br><br>1. Payment through ATM online.<p>2. Obtaining a Graduate Membership Application PIN from Branches of Access Bank Nationwide</p><br><br><u>DETAILS OF FEES AND CHARGES</u><br><table width="283"><tr><td>Subscription</td><td>N1,000</td></tr><tr><td>Building Levy</td><td>N300</td></tr><tr>
  <td>Materials Fee</td><td>N200</td></tr><tr>
    <td>Enrollment Fee</td>
    <td>N500</td></tr><tr><td>Total</td>
      <td><strong><u>N2,000</u></strong></td></tr></table>
</h4>
    <h4>Login to make payments with your Surname and Reference No sent in the first mail sent to you when you applied.<br>
      <br>Kindly accept the assurances of our highest regard.<br><br><br><br>Yours faithfully,<br><br><br>Obene Glassber<br>Graduate Membership Coordinator<br><i>For:</i>Head, Membership Services.</h4></td></tr></table></body></html>';

include("mimemail/MIME.class");
$mime = new MIME_mail("info@nse.org.ng", $email, $str);
$mime->attach($html_data, "", HTML, BASE64);
$mime->send_mail();



		
		
		header("refresh: 2; url=view_reg_app.php");
		
	}
}
elseif(!$clear_id){
	?>
<? include("search_form.php"); ?>
<?
if($_POST['uni']){
	$uni="AND s.school='$uni'";
}
else{
	$uni='';
}
if($_POST['surname']){
	$surname="AND s.surname LIKE '%$surname%'";
}
else{
	$surname="";
}

switch ($_POST['status']){
	default:
		//$link="<a href=\"view_essay_app.php?clear_id=$clear_id\">Approve Application</a>";
		$status="AND (c.dean_verify='0' OR c.branch_verify='0')";
		break;
		
		case "1":
		$status="AND c.dean_verify='1' AND c.branch_verify='1' ";
	$link="<font color=\"#FF0000\">Approved</font>";
	break;
	
	case "2":
	$status="AND (c.dean_verify='0' OR c.branch_verify='0')";
	//$link="<a href=\"view_essay_app.php?clear_id=$clear_id\">Approve Application</a>";
	break;
}
/*if($_POST['status']=='1'){
	$status="AND dean_verify='1' AND branch_verify='1'";
	$link="<font color=\"#FF0000\">Approved</font>";
}elseif($_POST['status']=='2'){
	$status="AND (dean_verify='0' OR branch_verify='0')";
	$link="<a href=\"view_essay_app.php?clear_id=$clear_id\">Approve Application</a>";
}
elseif($_POST['status']==''){
	$status="";
	$link="<font color=\"#FF0000\">Approved</font>";
}*/
?>
		<link rel="stylesheet" href="pagination_css.css" type="text/css"  />
<p style="background-color:#CCC; width:180px; height:20px;"><strong>APPLICANTS</strong></p>
<table cellspacing="0" cellpadding="5" class="mytable" border="1" width="100%">
<th align="left">S/No</th><th align="left">Names</th><th align="left">School</th><th>Phone No</th><th>Email</th><th align="left">View Credentials</th><th>Approve Application</th>
<?

$sql2="SELECT * FROM clearance_status c,stud_mem_reg s WHERE c.stud_id=s.stud_id AND c.reg_type='3' $uni $status $surname";
$adjacents = 2;

				$result2=mysql_query($sql2);
		$total_pages=mysql_num_rows($result2);
		$targetpage = "view_reg_app.php"; 	//your file name  (the name of this file)
	$limit = 30; 
	$page = $_GET['page'];
	if($page) 
		$start = ($page - 1) * $limit; 			//first item to display on this page
	else
		$start = 0;	
		$sql22="SELECT * FROM clearance_status c,stud_mem_reg s WHERE c.stud_id=s.stud_id AND c.reg_type='3' $uni $status $surname LIMIT $start,$limit";
		$result22 = mysql_query($sql22) or die(mysql_error());
	$count22=mysql_num_rows($result22);
		
		
	if ($page == 0) $page = 1;					//if no page var is given, default to 1.
	$prev = $page - 1;							//previous page is page - 1
	$next = $page + 1;							//next page is page + 1
	$lastpage = ceil($total_pages/$limit);		//lastpage is = total pages / items per page, rounded up.
	$lpm1 = $lastpage - 1;						//last page minus 1
	$pagination = "";
	if($lastpage > 1)
	{	
		$pagination .= "<div class=\"pagination\">";
		if ($page > 1) 
			$pagination.= "<a href=\"$targetpage?page=$prev&search2=$search\">« previous</a>";
		else
			$pagination.= "<span class=\"disabled\">« previous</span>";	
		
		//pages	
		if ($lastpage < 7 + ($adjacents * 2))	//not enough pages to bother breaking it up
		{	
			for ($counter = 1; $counter <= $lastpage; $counter++)
			{
				if ($counter == $page)
					$pagination.= "<span class=\"current\">$counter</span>";
				else
					$pagination.= "<a href=\"$targetpage?page=$counter&search2=$search\">$counter</a>";					
			}
		}
		elseif($lastpage > 5 + ($adjacents * 2))	//enough pages to hide some
		{
			//close to beginning; only hide later pages
			if($page < 1 + ($adjacents * 2))		
			{
				for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
				{
					if ($counter == $page)
						$pagination.= "<span class=\"current\">$counter</span>";
					else
						$pagination.= "<a href=\"$targetpage?page=$counter&search2=$search\">$counter</a>";					
				}
				$pagination.= "...";
				$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
				$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";		
			}
			//in middle; hide some front and some back
			elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
			{
				$pagination.= "<a href=\"$targetpage?page=1&search2=$search\">1</a>";
				$pagination.= "<a href=\"$targetpage?page=2&search2=$search\">2</a>";
				$pagination.= "...";
				for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
				{
					if ($counter == $page)
						$pagination.= "<span class=\"current\">$counter</span>";
					else
						$pagination.= "<a href=\"$targetpage?page=$counter&search2=$search\">$counter</a>";					
				}
				$pagination.= "...";
				$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
				$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";		
			}
			//close to end; only hide early pages
			else
			{
				$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
				$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
				$pagination.= "...";
				for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
				{
					if ($counter == $page)
						$pagination.= "<span class=\"current\">$counter</span>";
					else
						$pagination.= "<a href=\"$targetpage?page=$counter&search2=$search\">$counter</a>";					
				}
			}
		}
		
		//next button
		if ($page < $counter - 1) 
			$pagination.= "<a href=\"$targetpage?page=$next&search2=$search\">next »</a>";
		else
			$pagination.= "<span class=\"disabled\">next »</span>";
		$pagination.= "</div>\n";		
	}
	$sno=0;
//$count=mysql_num_rows($result);
if(!$count22){
	echo "No record found";
}
$sno=0;
while ($row=mysql_fetch_array($result22)){
	$sno++;
	$surname=$row['surname'];
	$othernames=$row['othernames'];
	$phone=$row['phone'];
	$email=$row['email'];
	$fullnames="$surname $othernames";
	$school_name=GetAny("universities",$row['school'],"id","name");
	$state_name=GetAny("state",$row['state_id'],"stateid","state_name");
	$branch_name=GetAny("branch",$row['branch_id'],"branchid","branch_name");
	$clear_id=$row['clear_id'];
	
?>
<tr id="myrow">
<td><? echo $sno ?></td><td><? echo $fullnames ?></td><td><? echo $school_name ?></td><td><?=$phone?></td><td><?=$email?></td><td><a href="Javascript:" onClick= "MM_openBrWindow('view_credentials.php?stud_id=<?=$row['stud_id'] ?>','','width=555,height=425,resizable=no,scrollbars=no') ">View Credentials</a></td><td>
<?
switch ($_POST['status']){
	default:
		$link="<a href=\"view_reg_app.php?clear_id=$clear_id\">Approve Application</a>";
		break;
		
		case "1":
		
	$link="<font color=\"#FF0000\">Approved</font>";
	break;
	
	case "2":
	
	$link="<a href=\"view_reg_app.php?clear_id=$clear_id\">Approve Application</a>";
	break;
}
echo $link;
?>
</td>
</tr>
<? } ?>
<? echo $pagination?>
</table>

<? include("inc/footer.php"); ?>
	
<? }  ?>