One Hat Cyber Team

Edit File: left_nav040514.php

<?php 
session_start();
ini_set ('display_errors', '1');
include "fxn.php";

$bgcolor1 = "#0073AA";
$bgcolor2 = "#EAEAEA";

include "../inc/config.php";
$officer_id=$_SESSION['officer_id'];

$sql="SELECT * FROM admin_corp WHERE id='$officer_id'";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);

$surname=$row['surname'];
$othernames=$row['othernames'];
$title=$row['title'];
$myeo_fullname="$title $surname $othernames";
$mymstatus=$row['roles_id'];
?>
<table width="100%"  border="0" cellspacing="0" cellpadding="5" class="border2">
  <tr>
    <td bgcolor="<? echo $bgcolor1 ?>" class="white">
<?php echo "$myeo_fullname Logged In!!!<br>";
////echo GetProgramme ($myprogramme_id); echo ", "; echo GetFaculty ($myfaculty_id); echo ",<br>"; echo GetDepartment ($mydepartment_id); ?>
 </td>
  </tr>
</table>
<table width="100%"  border="0" cellspacing="0" cellpadding="8" class="border2">
<tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="index.php" title="Admin Home" target="_self">Admin Home</a></td>
  </tr>
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="log_out.php" title="Log out" target="_self">Log Out</a></td>
  </tr>
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="view_acct.php" title="Edit Profile" target="_self">Edit Profile</a></td>
  </tr>
  
 <?php //} ?>
</table>

<? //if($mymstatus=='2'){ ?>

<? //} ?>

<br>
<? if($mymstatus=='1'){ ?>
<table width="100%"  border="0" cellspacing="0" cellpadding="5" class="border2">
  <tr>
    <td bgcolor="<? echo $bgcolor1 ?>" class="white">Manage Branches and Officers</td>
  </tr>
</table>
<table width="100%"  border="0" cellspacing="0" cellpadding="8" class="border2">
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="add_school.php" title="Add A New School" target="_self">Add University</a></td>
  </tr>
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="view_universities.php" title="View Universities" target="_self">View Schools</a></td>
  </tr>
    <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="add_essay_officer.php" title="Add Essay Officer" target="_self">Add Officer</a></td>
  </tr>
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="view_school.php" title="View Pending Applicants" target="_self">View Branches</a></td>
  </tr>
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="view_dean.php" title="View Approved Applicant" target="_self">View/Edit Officers</a></td>
  </tr>
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="view_admin_comm.php" title="View Admission Committee" target="_self">View Admission Commitee</a></td>
  </tr>
  <tr>
  </tr>
</table>
<? } ?>

<table width="100%"  border="0" cellspacing="0" cellpadding="5" class="border2">
  <tr>
    <td bgcolor="<? echo $bgcolor1 ?>" class="white">Manage Corporate Application</td>
  </tr>
</table>
<table width="100%"  border="0" cellspacing="0" cellpadding="8" class="border2">
   <? if($mymstatus=='2'){?>
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="add_school.php" title="Add A New School" target="_self">Add University</a></td>
  </tr>
    <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="view_universities.php" title="View Universities" target="_self">View Schools</a></td>
  </tr>
  <? } ?>
 
   
     <? if($mymstatus=='1'){?>
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="view_intending_app.php" title="View Intending Applicant" target="_self">View Intending Applicant </a></td>
  </tr>
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="send_sms_intending.php" title="Send SMS Intending Applicant" target="_self">SMS Intending Applicant </a></td>
  </tr>
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="send_mail_int_app.php" title="Send Mail Intending Applicant" target="_self">Email Intending Applicant </a></td>
  </tr>
  <? } elseif($mymstatus=='2'){?>
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="view_intending_app2.php" title="View Intending Applicant" target="_self">View Intending Applicant </a></td>
  </tr><tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="send_sms_intending.php" title="Send SMS Intending Applicant" target="_self">SMS Intending Applicant </a></td>
  </tr>
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="send_mail_int_app2.php" title="Send Email Intending Applicant" target="_self">Email Intending Applicant </a></td>
  </tr>
  <? } ?>
  <? if($mymstatus=='1'){?>
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="view_branch22.php" title="View Registered Applicant" target="_self">View Registered Applicants  </a></td>
  </tr><tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="send_sms_registered.php" title="Send SMS Intending Applicant" target="_self">SMS Registered Applicant </a></td>
  </tr>
  <tr>
   <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="send_mail_reg_app.php" title="Send SMS Intending Applicant" target="_self">Email Registered Applicant </a></td>
  </tr>
  
  <? } 
   elseif($mymstatus=='2'){ ?>
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="view_branch.php" title="View Registered Applicant" target="_self">View Registered Applicants  </a></td>
  </tr><tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="send_sms_registered.php" title="Send SMS Intending Applicant" target="_self">SMS Registered Applicant </a></td>
  </tr>
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="send_mail_reg_app2.php" title="Send Mail Registered App" target="_self">Email Registered Applicant </a></td>
  </tr>
  
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="completed_app.php" title="View Completed Application" target="_self">View Completed Application </a></td>
  </tr>
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="examlist.php" title="Download Brief" target="_new">Download Examination List </a></td>
  </tr>
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="examlist2.php" title="Download Brief" target="_new">Download Examination List (C1) </a></td>
  </tr>
  
    
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="send_sms.php" title="Send SMS" target="_self">Send SMS(Completed)</a></td>
  </tr>
   
  
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="check_account.php" title="View Payment" target="_self">View Payment</a></td>
  </tr>
  
  
  <tr>
  </tr><? } ?>
</table>
<table width="100%"  border="0" cellspacing="0" cellpadding="5" class="border2">
  <tr>
    <td bgcolor="<? echo $bgcolor1 ?>" class="white">Manage Special Application</td>
  </tr>
</table>
<table width="100%"  border="0" cellspacing="0" cellpadding="8" class="border2">
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="a1.php" title="Manage A1" target="_self">Manage A1</a></td>
  </tr>
  <?
  if($mymstatus=='1'){
	  ?>
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="c1.php" title="Manage C1" target="_self">Manage C1</a></td>
  </tr>
    <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="c2.php" title="Manage C2" target="_self">Manage C2</a></td>
  </tr>
    <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="email_c1.php" title="Email C1" target="_self">Email C1 </a></td>
  </tr>
  <? } ?>
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="email_a1.php" title="Email A1" target="_self">Email A1</a></td>
  </tr>
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="email_c1.php" title="Email C1" target="_self">Email C1 </a></td>
  </tr>
  </table>

<table width="100%"  border="0" cellspacing="0" cellpadding="5" class="border2">
  <tr>
    <td bgcolor="<? echo $bgcolor1 ?>" class="white">Manage Post Examination</td>
  </tr>
</table>
<table width="100%"  border="0" cellspacing="0" cellpadding="8" class="border2">
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="post_exam.php" title="View Unread Messages" target="_self">Completed Application</a></td>
  </tr>
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="passed.php" title="View Passed Lists" target="_self">View Results</a></td>
  </tr>
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="sendmail_result.php" title="Send Mail Passed" target="_self">Email Candidates(Passed/Failed)</a></td>
  </tr>
  
  </table>

<? //} ?>
<? if($mymstatus!='3'){?>
<table width="100%"  border="0" cellspacing="0" cellpadding="5" class="border2">
  <tr>
    <td bgcolor="<? echo $bgcolor1 ?>" class="white">Manage Enquiries</td>
  </tr>
</table>

<table width="100%"  border="0" cellspacing="0" cellpadding="8" class="border2">
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="messages.php" title="View Unread Messages" target="_self">View Unread  Messages (<?=noOfmessages();?>)</a></td>
  </tr>

</table>
        <? } ?>
        <? if($mymstatus=='3'){?>
      <table width="100%"  border="0" cellspacing="0" cellpadding="5" class="border2">
  <tr>
    <td bgcolor="<? echo $bgcolor1 ?>" class="white">Admission Committee</td>
  </tr>
</table>
<table width="100%"  border="0" cellspacing="0" cellpadding="8" class="border2">
  
  <tr>
    <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="view_branch_admin.php" title="View Registered Applicant" target="_self">View Registered Applicants  </a></td>
  </tr>
  <tr>
  <td bgcolor="<? echo $bgcolor2 ?>" class="border3"><a href="view_admin_branch.php" title="Review Application" target="_self">Review Completed Applications</a></td>
  </tr>
 
      </table>
<? }

/*function viewApplicantCount(){
		$sql=mysql_query("SELECT * FROM stud_mem_reg WHERE processing='0' AND reg_type='3'");
		return mysql_num_rows($sql);
	}
	
	function viewRegisteredApp(){
		$sql2=mysql_query("SELECT * FROM clearance_status c,corp_mem s WHERE c.stud_id=s.stud_id AND c.dean_verify='0' AND c.branch_verify='0'");
		return mysql_num_rows($sql2);
	}
	function noOfSchools(){
		$sql=mysql_query("SELECT * FROM universities");
		return mysql_num_rows($sql);
	}*/
	function noOfmessages(){
		$sql=mysql_query("SELECT * FROM messages WHERE status='0'");
		return mysql_num_rows($sql);
	}
	function noOfmessagesSent(){
		$sql=mysql_query("SELECT * FROM message_sent");
		return mysql_num_rows($sql);
	}

function Get($table,$value,$field,$output){
	$sql=mysql_query("SELECT * FROM $table WHERE $field='$value'");
	$row=mysql_fetch_array($sql);
	return $row["$output"];
}
function branchNo($branchid){
	$sql=mysql_query("SELECT * FROM corp_mem a,corp_reg_pay b WHERE a.stud_id=b.stud_id AND b.status='Paid' AND a.branch_id='$branch_id'");
	$count=mysql_num_rows($sql);
	return $count;
}
 ?>
<br>