One Hat Cyber Team

View File Name : demandNotice220216.php

<?php
ini_set('display_errors',1);
//require_once ('Mail/mime.php'); 
require_once "Mail.php"; // PEAR Mail package
require_once ('Mail/mime.php'); // PEAR Mail_Mime packge
mysql_connect("localhost","niqsorgn_portal","@Xchange69!");
mysql_select_db("niqsorgn_pota1969");
//mysql_connect("localhost","root","@ajagbe@");
//mysql_select_db("niqs");
$sql=mysql_query("SELECT * FROM members a,dues b WHERE a.memberNo=b.memberNo AND a.sent='0' AND a.memberEmail!='' AND (b.outstanding >'500' OR b.annualSub >'500') ORDER BY memberID ASC LIMIT 0,300");
while ($row=mysql_fetch_array($sql)){
	$memNo=$row['memberNo'];
	$name=$row['memberSurname']." ".$row['memberOthernames'];
	$date=date('Y-m-d');
	$email=$row['memberEmail'];
	$email = filter_var($email, FILTER_SANITIZE_EMAIL);
	$amount=number_format($row['outstanding'],2);
	$annualSub=$row['annualSub'];
	$advance=$row['advance'];
	$annual=number_format($annualSub,2);
	$total=number_format($row['outstanding']+$annualSub+$advance,2);
$html='<table>
<tr><td><img src="portal.niqs.org.ng/images/header.png" /></td></tr>
<tr><td height="370" valign="top" style="padding-left:120px !important;"><p>Dear '.$name.','.$memNo.'</p>
<p><strong><u>DEMAND NOTE FOR 2016 ANNUAL SUBSCRIPTION</strong></u></p>
<ol>
<li>Please note that the 2016 Annual Subscription for all Members <strong>is due on the 1st January,2016.</strong> This NOTICE is to formally remind you of your outstanding Arrears of Dues/Levies(if any), as well as your current subscription.</li>
<li>Please be reminded that our esteemed Institute has  no financier nor does it enjoy any grant from other sources. The growth of NIQS depends on the regular payment of your annual subscription as at when due as this is one of your professional obligations to Institute.
</li>
<li><p><strong>PAYMENT MODE:</strong></p>
<p> <strong>(a.) <i>On-line Payment:</i></strong> Please visit our website and click on "Online Payment Guidelines" and follow the step by step details to make your payment</p>
<p><strong>(b.) <i>Bank Deposit:</i></strong>The Nigerian Institute of Quantity Surveyors</p>
<p>Guarantee Trust Bank Plc Account No: 0010899819</p>
<p>Skye Bank Plc with Account No: 1150000015</p>
</li>
</ol>
<p></p>
<p></p>
<p>Please forward evidence of Electronic Transfer(E-PAYMENT) or scanned copy of Payment Deposit Slip to niqsenquiry@gmail.com.</p>

<table width="100%" border="1">
<tr><td colspan="2"><strong>YOUR FINANCIAL SUMMARY</strong></td></tr>
<tr><td>Previous Outstanding</td><td>'.$amount.'</td></tr>
<tr><td>2016 Annual Subscription</td><td>'.$annual.'</td></tr>
<tr><td>Advance</td><td>'.number_format($advance,2).'</td></tr>
<tr><td><strong>TOTAL</strong></td><td>N'.$total.'</td></tr>

</table>
<p>Please always quote your membership number in all your correspondences with us.</p>
<p>Your full name and membership number must be provided on the pay-in-slip as a reference.</p>
<p>Let us have your feedback to this email and make your contributions that will advance the course of our dear Institute. Email:mails.niqs@gmail.com or Call <strong>08167593807</strong></p>
<p>Wishing you a prosperous New Year.</p>
<p><i>Best Regards</i></p>
<p>Signed:</p>
<p><strong>Mr. Babatunde O. Adesiyan, FNIQS</strong></p>
<p><strong>Treasurer</strong></p>
</td></tr>

</table>';
echo $html;
if (!filter_var($email, FILTER_VALIDATE_EMAIL) === false) {
    if(sendMail($email,$html)){
	//update sent
	mysql_query("UPDATE members SET sent='1' WHERE memberNo='$memNo'");
}
}else{
	echo "Error Sending Mail";
}

}


function sendMail($email,$html){
	 $from = "info@niqs.org.ng"; //enter your email address
 $to = $email; //enter the email address of the contact your sending to
 $subject = "Demand Notice"; // subject of your email

$headers = array ('From' => $from,'To' => $to, 'Subject' => $subject);

$text = ''; // text versions of email.
//$html = "<html><body>Name: $name <br> Email: $email <br>Message: $message <br></body></html>"; // html versions of email.

$crlf = "\n";

$mime = new Mail_mime($crlf);
//$mime->setTXTBody($text);
$mime->setHTMLBody($html);

//do not ever try to call these lines in reverse order
$body = $mime->get();
$headers = $mime->headers($headers);

 $host = "109.199.106.237"; //"localhost"; // all scripts must use localhost
 $username = "info@niqs.org.ng"; //  your email address (same as webmail username)
 $password = "Welcome007!"; // your password (same as webmail password)

$smtp = Mail::factory('smtp', array ('host' => $host, 'auth' => true,
'username' => $username,'password' => $password,'port' => 25));

$mail = $smtp->send($to, $headers, $body);

if (PEAR::isError($mail)) {
	return 0;
//echo("<p>" . $mail->getMessage() . "</p>");
}
else {
	return 1;
//echo("<p>Message successfully sent!</p>");
// header("Location: http://www.example.com/");
}
}
?>