One Hat Cyber Team

Edit File: sendPassedMail.php

<?php
include("inc/header.php");
?>
<?php
if(isset($submit)){
include "inc/config.php";

$file_no=$_POST['file_no'];

$sql=mysql_query("SELECT * FROM passed a,corp_mem b,branch c WHERE a.file_no=b.file_no AND c.branchid=b.branch_id AND a.file_no='$file_no'");
if(!$sql){
echo mysql_error();	
	}
while ($row=mysql_fetch_array($sql)){
$name=$row['othernames']." ".$row['surname'];
$address=$row['address'];
$branch=$row['branch_name'];
$number=$row['mem_num'];
$grad_year=$row['grad_year'];
$file_no=$row['file_no'];
$email=$row['email'];
$year=date('Y');
$dues=$year-$grad_year;
$date=date("d M, Y");
//$branchName=getAny("branch",$row['branch_id'],"branchid","branch_name");
$str='Nigerian Society of Engineers Corporate Membership Application';

?>
<?php
$html='<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<title>'.$str.'</title>
<style>
tr:nth-child(even) {background: #CCC;}
tr:nth-child(odd) {background: #FFF;}
table:{ background-color:transparent !important;}
.link:{background:#006; color:#FFF; width:60px; padding:10px;}
</style>
</head>
<body>
<div style="width: 800px;">
<img src="http://www.nse.org.ng/images/banner.jpg" />
<div align="right" style="margin: 10px;">'.$date.'</div>
<div style="margin: 10px;">
'.$name.'
'.$address.'
'.$branch.'


Dear Member,
ELECTION TO CORPORATE MEMBERSHIP
Please accept my very hearty congratulations on your election as a Corporate Member of the NIGERIAN SOCIETY OF ENGINEERS as approved during the Council meeting held on the 10th of July, 2014.

Your Membership Number is '.$number.' which, henceforth, should be quoted as a reference number in all your correspondence with this office';

if($dues<=5){
	$html.='In accordance with the Articles of Association of the Society, you are required to pay the sum of N53,300 as detailed below, in certified bank draft, in favour of The Nigerian Society of Engineers and return the obligation form, duly signed, within two months of receipt of this advice, otherwise your election/transfer will be void. Please pay your NEC building levy & Special Levy to our Union Bank Account No. 0941020002580 Sort Code 032154607 while other levies to First Bank Account No. 2020502052, Sort Code 011150000, Maitama Branch, Abuja. Remember to return the original copy of the teller with the pink obligation form to NSE HQ. 

Annual subscription become due on the 1st of July of each year, in accordance with articles 19 and 20 of the Articles of Association of the Society

Note that your certificate of membership will be released to you through your Branch after full payment of the fees indicated below, followed by induction. However, we will notify you through SMS/Email when your certificate is ready. PLEASE CONFIRM YOUR NAMES AND NSE NUMBER WITTEN ON YOUR CERTIFICATE BEFORE LAMINATING IT. Call 098767053 for any enquiry.

DETAILS OF FEES AND CHARGES
<table>
<tr><td> Current Subscription</td><td>N7,000</td></tr>
<tr><td> Transfer/Enrolment Fee</td><td>N1,500</td></tr>
<tr><td> Benevolent Fund</td><td>N1,000</td></tr>
<tr><td> Membership Materials</td><td>N5,800</td></tr>
<tr><td> International Levy</td><td>N1,000</td></tr>
<tr><td> Abuja NEC & Building Levy</td><td>N10,000</td></tr>
<tr><td> Special Levy(NEC Phase 2)</td><td>N25,000</td></tr>
<tr><td> WECSI</td><td>N2,000</td></tr>
<tr style="border: 1px solid;"><td style="border: 1px solid;"> Total Amount to be paid</td><td style="border: 1px solid;">N53,300</td></tr>
</table>

We sincerely look forward to your active participation in the society activities at the National and Branch levels.
Yours faithfully,



 Engr. Ovens F. Ehimatie,MNSE 
Head, Membership Services 
For: Executive Secretary

</div>
</div>
</body>
</html>';
	
	
	}
	elseif($dues>5 && $dues<=10){
		$html.='In accordance with the Articles of Association of the Society, you are required to pay the sum of N58,300 as detailed below, in certified bank draft, in favour of The Nigerian Society of Engineers and return the obligation form, duly signed, within two months of receipt of this advice, otherwise your election/transfer will be void. Please pay your NEC building levy & Special Levy to our Union Bank Account No. 0941020002580 Sort Code 032154607 while other levies to First Bank Account No. 2020502052, Sort Code 011150000, Maitama Branch, Abuja. Remember to return the original copy of the teller with the pink obligation form to NSE HQ. 

Annual subscription become due on the 1st of July of each year, in accordance with articles 19 and 20 of the Articles of Association of the Society

Note that your certificate of membership will be released to you through your Branch after full payment of the fees indicated below, followed by induction. However, we will notify you through SMS/Email when your certificate is ready. PLEASE CONFIRM YOUR NAMES AND NSE NUMBER WITTEN ON YOUR CERTIFICATE BEFORE LAMINATING IT. Call 098767053 for any enquiry.

DETAILS OF FEES AND CHARGES
<table>
<tr><td> Current Subscription</td><td>N7,000</td></tr>
<tr><td> Transfer/Enrolment Fee</td><td>N1,500</td></tr>
<tr><td> Benevolent Fund</td><td>N1,000</td></tr>
<tr><td> Membership Materials</td><td>N5,800</td></tr>
<tr><td> International Levy</td><td>N1,000</td></tr>
<tr><td> Abuja NEC & Building Levy</td><td>N15,000</td></tr>
<tr><td> Special Levy(NEC Phase 2)</td><td>N25,000</td></tr>
<tr><td> WECSI</td><td>N2,000</td></tr>
<tr style="border: 1px solid;"><td style="border: 1px solid;"> Total Amount to be paid</td><td style="border: 1px solid;">N58,300</td></tr>
</table>

We sincerely look forward to your active participation in the societys activities at the National and Branch levels.
Yours faithfully,



 Engr. Ovens F. Ehimatie,MNSE 
Head, Membership Services 
For: Executive Secretary

</div>
</div>
</body>
</html>
';
		
		
		}
		elseif($dues >10){
$html.='In accordance with the Articles of Association of the Society, you are required to pay the sum of N63,300 as detailed below, in certified bank draft, in favour of The Nigerian Society of Engineers and return the obligation form, duly signed, within two months of receipt of this advice, otherwise your election/transfer will be void. Please pay your NEC building levy & Special Levy to our Union Bank Account No. 0941020002580 Sort Code 032154607 while other levies to First Bank Account No. 2020502052, Sort Code 011150000, Maitama Branch, Abuja. Remember to return the original copy of the teller with the pink obligation form to NSE HQ. 

Annual subscription become due on the 1st of July of each year, in accordance with articles 19 and 20 of the Articles of Association of the Society

Note that your certificate of membership will be released to you through your Branch after full payment of the fees indicated below, followed by induction. However, we will notify you through SMS/Email when your certificate is ready. PLEASE CONFIRM YOUR NAMES AND NSE NUMBER WITTEN ON YOUR CERTIFICATE BEFORE LAMINATING IT. Call 098767053 for any enquiry.

DETAILS OF FEES AND CHARGES
<table>
<tr><td> Current Subscription</td><td>N7,000</td></tr>
<tr><td> Transfer/Enrolment Fee</td><td>N1,500</td></tr>
<tr><td> Benevolent Fund</td><td>N1,000</td></tr>
<tr><td> Membership Materials</td><td>N5,800</td></tr>
<tr><td> International Levy</td><td>N1,000</td></tr>
<tr><td> Abuja NEC & Building Levy</td><td>N20,000</td></tr>
<tr><td> Special Levy(NEC Phase 2)</td><td>N25,000</td></tr>
<tr><td> WECSI</td><td>N2,000</td></tr>
<tr style="border: 1px solid;"><td style="border: 1px solid;"> Total Amount to be paid</td><td style="border: 1px solid;">N63,300</td></tr>
</table>

We sincerely look forward to your active participation in the societys activities at the National and Branch levels.
Yours faithfully,



 Engr. Ovens F. Ehimatie,MNSE 
Head, Membership Services 
For: Executive Secretary

</div>
</div>
</body>
</html>
';		
		
			}

$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";

// More headers
$headers .= 'From: <application@nse.org.ng>' . "\r\n";
echo $html;

$mail=mail($email,$str,$html,$headers);
//$update=mysql_query("UPDATE passed SET sent='0' WHERE file_no='$file_no'");
/*if(!$update){
echo mysql_error();	
	
	}*/
}

function getAny($table,$value,$field,$output){
$sql=mysql_query("SELECT * FROM $table WHERE $field='$value'");
$row=mysql_fetch_array($sql);
return $row["$output"];	
	}

if($mail){
echo "mail sent";	
header('refresh: 5; url=sendPassedMail.php');
	}
	else{
echo "Error sending mail";		
}
}
		?>
		<form action="" method="post">
	<table>
<tr><td>File No</td><td><input type="text" name="file_no" /></td></tr>
<tr><td colspan="2"><input type="submit" name="submit" value="Send Election Letter" /></td></tr>
</table>		
		
		</form>