One Hat Cyber Team

Edit File: demandNotice.php

<?php
die();
ini_set('display_errors',1);
//require_once ('Mail/mime.php');
/*****ACTION POINT START***/
//uncomment the requires
//uncomment the sent update
//uncomment the connectionstring
//uncomment send mail
 /*****ACTION POINT END***/
 
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_individual=mysql_query("SELECT * FROM members a, dues b WHERE a.memberNo = b.memberNo AND a.memberNo = $mem_no");

$sql=mysql_query("SELECT * FROM members a, dues b WHERE a.memberNo = b.memberNo AND a.sent='0' AND a.memberEmail!=''  AND (b.outstanding + b.annualSub + b.advance + b.upgradeCharge) >  '500' ORDER BY a.memberID DESC LIMIT 0 , 500"); 
if(!$sql){
	echo mysql_error();
}
/*$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,50");*/

$html = ""; $email="";
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'];
	$upgradeCharge=$row['upgradeCharge'];
	$annual=number_format($annualSub,2);
	$total=number_format($row['outstanding']+$annualSub+$advance+$upgradeCharge,2);
$html='<table width="100%" >
<tr><td><img src="http://portal.niqs.org.ng/membership/images/header.jpg" /></td></tr>
<tr><td height="370" valign="top" style="padding-left:120px !important;">Dear '.$name.','.$memNo.'
DEMAND NOTE FOR 2016 ANNUAL SUBSCRIPTION
<ol>
<li>Kindly note that the 2016 Annual Subscription for all Members is due on the 1st January,2016. 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>PAYMENT MODE:
 (a.) On-line Payment: Please visit our website(www.niqs.org.ng) and click on "MAKE PAYMENT" and login before you continue.
(b.) Bank Deposit/Electronic Transfer:
Account Name: The Nigerian Institute of Quantity Surveyors
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Guarantee Trust Bank Plc Account No: 0010899819
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;OR
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Skye Bank Plc with Account No: 1150000015
</li>
</ol>


Forward your evidence of Electronic Transfer(E-PAYMENT) or scanned copy of Payment Deposit Slip to niqsenquiry@gmail.com.

<table width="100%" border="1">
<tr><td colspan="2">YOUR FINANCIAL SUMMARY</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>Upgrade Charge</td><td>'.number_format($upgradeCharge,2).'</td></tr>
<tr><td>TOTAL</td><td>N'.$total.'</td></tr>

</table>
Please always quote your membership number in all your correspondences with us.
Your full name and membership number must be provided on the pay-in-slip as a reference.
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 08167593807

Best Regards
Signed:
Dr. Babatunde O. Adesiyan, FNIQS
Treasurer
</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 Note"; // subject of your email

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

$text = ''; // text versions of email.
//$html = "<html><body>Name: $name Email: $email Message: $message </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 = "localhost"; // all scripts must use localhost
 $username = "info@niqs.org.ng"; //  your email address (same as webmail username)
 $password = "{{Great}}"; // 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("" . $mail->getMessage() . "");
}
else {
	return 1;
//echo("Message successfully sent!");
// header("Location: http://www.example.com/");
}
}
?>