One Hat Cyber Team

Edit File: demandNote.php

<?php
die();
ini_set('display_errors',1);
//mail("writesalisu@gmail.com", "Mail Setup", "Hello Once Again", "From: salisu@niqs.org.ng");
//die();

require_once "Mail.php"; // PEAR Mail package
require_once ('Mail/mime.php'); // PEAR Mail_Mime packge
//$con = mysql_connect("localhost","niqsorgn_portal","@Xchange69!");
$con = mysqli_connect("localhost","niqsorgn_portal","@Xchange69!") or die("NC");
$db = mysqli_select_db($con, "niqsorgn_pota1969");

// Gagariga Taridouye: 00744 
// Ruya Fadason:       01526
// Treasurer: 01779
// SG:        01544
// AND a.memberNo = 'DA9999'

$sql=mysqli_query($con, "SELECT * FROM members a, dues b WHERE a.memberNo = b.memberNo AND a.sent!=12 AND a.memberGrade!=8 AND memberGrade!=6 AND a.memberEmail!='' AND (b.outstanding + b.annualSub + b.upgradeCharge + b.annualSub2017 + b.annualSub2018 + b.annualSub2019 + b.devtLevy1 + b.devtLevy2 + b.annualSub2020 + b.annualSub2021) > '50' ORDER BY a.memberID ASC LIMIT 0,300"); 
if(!$sql){
	echo mysqli_error($con);
}
$mysent = 0;
$notsent = 0;
$i = mysqli_num_rows($sql);
echo "Count : $i ";
while ($row=mysqli_fetch_array($sql)){
	$memNo=$row['memberNo'];
		$names=$row['memberSurname']." ".$row['memberOthernames'];
		
		$date=date('Y-m-d');
		$email=$row['memberEmail'];
		$phone=$row['memberPhone'];
		
		$grade=$row['memberGrade'];
		if($grade == 1 || $grade == 2 || $grade == 9){ $names = "QS ".$names; }
		
		//$email = filter_var($email, FILTER_SANITIZE_EMAIL);
		$amount=$row['outstanding'];
		$annualSub=$row['annualSub'];
		$advance=$row['advance'];
		$upgradeCharge=$row['upgradeCharge'];
		 $an2017 = $row['annualSub2017'];
		 $an2018 = $row['annualSub2018'];
		 $an2019 = $row['annualSub2019'];
		 $an2020 = $row['annualSub2020'];
		 $an2021 = $row['annualSub2021'];
		 $devt = $row['devtLevy1'];
		 $devt2 = $row['devtLevy2'];
		$annual=$annualSub;
		$total=$row['outstanding']+$row['annualSub']+$advance+$upgradeCharge+$row['annualSub2017']+$row['annualSub2018']+$row['annualSub2019']+$row['annualSub2020']+$row['devtLevy1']+$row['devtLevy2']+$row['annualSub2021'];

$html='
	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
	<!doctype html>
	<html xmlns="http://www.w3.org/1999/xhtml">
	<head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
	<title>NIQS Demand Note</title>
	
	</head>
	<body leftmargin="5" topmargin="0" marginwidth="0" marginheight="0" style="font-family: Georgia, Times, serif">
	
	<table align="center" width="95%" border="1" bordercolor="gold" cellpadding="4" cellspacing="0"> 
	<tr><td>
	 <img src="https://niqs.org.ng/niqs_logo2020.png" width="50%"/>
	 </td>
	</tr> 
	<tr><td>
	
	<table width="90%" align="center" border="0" cellpadding="0" cellspacing="0"> 
	<tr><td>

Dear '.$names.', '.$memNo.'
	NOTICE FOR THE PAYMENT OF 2021 ANNUAL SUBSCRIPTION AND OTHER OUTSTANDING 
	Please find below the details of your 2021 Annual Subscription, Levy and other outstandings for payment. 
	
	
	</td></tr></table>
	
	
	<table align="center" width="90%" border="0" cellspacing="0" padding="0"><tr><td>
	<table width="60%" border="1" cellspacing="0" padding="0">
	<tr><th colspan="2">FINANCIAL SUMMARY</th></tr>
	<tr><th align="left">Item Description</th><th align="right">Amount</th></tr></thead><tbody>';
	
	if ($an2021 > 0){
	 $html .= '<tr><td>2021 Annual Subscription</td><td align="right"><del>N</del>'.number_format($an2021,2).'</td></tr>';
	}

if ($an2020 > 0){
	 $html .= '<tr><td>2020 Annual Subscription</td><td align="right"><del>N</del>'.number_format($an2020,2).'</td></tr>';
	}
	
	if ($an2019 > 0){
	 $html .= '<tr><td>2019 Annual Subscription</td><td align="right"><del>N</del>'.number_format($an2019,2).'</td></tr>';
	}
	
	if ($an2018 > 0){
	 $html .= '<tr><td>2018 Annual Subscription (Outstanding) </td><td align="right"><del>N</del>'.number_format($an2018,2).'</td></tr>';
	}
	
	if ($an2017 > 0){
	 $html .= '<tr><td>2017 Annual Subscription (Outstanding)</td><td align="right"><del>N</del>'.number_format($an2017,2).'</td></tr>';
	}
	
	if ($annual > 0){
	 $html .= '<tr><td>2016 Annual Subscription (Outstanding)</td><td align="right"><del>N</del>'.number_format($annualSub,2).'</td></tr>';
	}
	
	if ($amount > 0){
	 $html .= '<tr><td>Previous Outstanding up to December 31st, 2015</td><td align="right"><del>N</del>'.number_format($amount,2).'</td></tr>';
	}

//if ($devt > 0){
	 $html .= '<tr><td>NIQS Head Office Development Levy (1st Installment)</td><td align="right"><del>N</del>'.number_format($devt,2).'</td></tr>';
	//}
	//if ($devt2 > 0){
	 $html .= '<tr><td>NIQS Head Office Development Levy (2nd Installment)</td><td align="right"><del>N</del>'.number_format($devt2,2).'</td></tr>';
	//}
	
	
	if ($upgradeCharge > 0) {
	 $html .= '<tr><td>Upgrade Charge</td><td align="right"><del>N</del>'.number_format($upgradeCharge,2).'</td></tr>';
	}
	 $html .='<tr><td align="left">TOTAL</td><td align="right"><del>N</del>'.number_format($total, 2).'</td></tr>
	</table> 
	</td></tr></table>
	
	<table align="center" width="90%" border="0" cellpadding="0" cellspacing="0">
	<tr><td>
	
	Our Institute has no financier, nor does it enjoy any grant from other sources, hence, the growth of NIQS depends on the regular payment of your annual subscription and other charges as and when due. It is one of your professional obligations to the Institute. We wish to remind you of the following: 
	<ol style="padding-left:10px;">
	<li>2021 Annual Subscription and other charges for all Members are due on 1st January 2021 in accordance with section 10.3.1 of the Constitution of the Nigerian Institute of Quantity Surveyors. </li>
	<li>All members are expected to be financially up-to-date on or before 31st of March of every year, as in section 10.3.2 of the Constitution of the Nigerian Institute of Quantity Surveyors. THIS THEREFORE SERVES AS A 3RD (THIRD AND FINAL) REMINDER. </li> 
	<li>At the 2018 AGM of the Institute, it was agreed that any member or practicing firm whose annual subscription accumulates up to <del>N</del>500,000.00 should be automatically de-registered from the Institute\'s record. Re-registration of such member can only take place after he/she has paid up the outstanding amount and gone through qualification exercise via EPCI Route </li>';
	
	/*
	$totaldevt = $devt + $devt2;
	if($totaldevt > 0)
	{
 	 $html .='<li>The 2016 Annual General Meeting held on 10th November, 2016 in Port Harcourt approved the mandatory payment of Secretariat Development Levy by every member and practising firm payable within the two years (starting from 2017) as follows: 
	
	 <table cellpading="0" cellspacing="0" style="margin-left:20px;">
	 <tr><th align="left"> Grade </th> 			<th align="left">Amount(N)</th>		<th align="left">Installmental Payment</th></tr>
	 <tr><td> Past Presidents </td>				<td cellspacing="10">200,000.00 </td>	<td cellspacing="10">(100,000.00 x 2years)</td></tr>
	 <tr><td> Fellows </td>					<td cellspacing="10">100,000.00 </td>	<td>(50,000.00 x 2years)</td></tr>
	 <tr><td> Members (Above 10 years) </td>			<td cellspacing="10">75,000.00 </td>	<td>(37,500.00 x 2years)</td></tr>
	 <tr><td> Members (Under 10 years) </td>			<td cellspacing="10">50,000.00 </td>	<td>(25,000.00 x 2years)</td></tr>
	 <tr><td> Probationers & Technicians </td>		<td cellspacing="10">10,000.00 </td>	<td>(5,000.00 x 2years)</td></tr>
	 <tr><td> Practising Firms</td>				<td cellspacing="10">100,000.00 </td>	<td>(50,000.00 x 2years)</td></tr>
	 </table> 
	Members may choose to pay the levy amount in maximum of two (2) installments as shown above or pay it at once. </li>
	';
	}
	*/
	
	$html .='<li>For ease and convenience of payments, the Institute has made available the following payment modes. 
	(i) Online Payment - <a href="http://niqs.org.ng/onlinepayments/paysubscription.php">click here to make payment</a> 
	(ii) POS Payment at National Secretariat, Abuja and Liaison Office, Lagos 
	(iii) Bank Payment - You can make Direct Bank Deposit or Electronic Transfers to the following Bank Accounts details. 
	Account Name: The Nigerian Institute of Quantity Surveyors 
	Guaranty Trust Bank Plc Account No: 0010899819 
	OR 
	Polaris Bank Plc Account No: 1150000015 
	Forward the evidence of Electronic Transfer(E-PAYMENT) or scanned copy of Payment Deposit Slip to finance@niqs.org.ng against which an official receipt will be issued. 
	
	Always quote your membership number ('.$memNo.') in all your correspondences with us.
	Your full name and membership number must be provided on the deposit slip as a reference. 
	
	</li>
<li>Only financially up to date professional members shall benefit from the following:</li>
	
	</ol>

<ol style="list-style-type: square;">
	 <li>The Institute\'s Group Life Insurance Policy and Benevolence Fund.</li>
	 <li>Prompt receipt of all NIQS publications e.g. Journals, QS Connect, etc.</li>
	 <li>Eligible for appointment into NIQS Committees and serve as Resource Persons during Workshops and Seminars.</li>
	 <li>Eligible to vote and be voted for during the Biennial Election General Meeting.</li>
	</ol>

Kindly avail us your feedback through the email address and phone number below to submit your complaints or contributions that will advance the course of our dear Institute. 
 Email: info@niqs.org.ng 
 Phone Number: 08167593807
	
	Best Regards. 
	
	 
	QS Paul E. J. Anavhe, FNIQS 
	Treasurer
	
	
	</td></tr></table>
	
	
	</td></tr>
	
	<tr><td> 
	 <center>
	 <a href="http://www.niqs.org.ng" style="text-decoration:none">www.niqs.org.ng</a> | <a href="http://twitter.com/niqslive" style="text-decoration:none">Twitter</a> | <a href="http://facebook.com/TheNigerianInstituteOfQuantitySurveyors" style="text-decoration:none">Facebook</a>
	</center>
	</td></tr>
	</table>
	</body>
	</html>';
	
	//echo $html;
	
	
	//$to = "t.adefisayo@niqs.org.ng";
	//$to = "secretarygeneral@niqs.org.ng";
	//$to = "nimi266@yahoo.co.uk, writesalisu@gmail.com";
	//$to = "salaumusa@yahoo.com, secretarygeneral@niqs.org.ng, d.ndayebo@niqs.org.ng, danladi.ndayebo@gmail.com, o.ebiloma@niqs.org.ng, salisu@niqs.org.ng, t.adefisayo@niqs.org.ng";
	$to = $email;
	//$to = "osasokr@yahoo.com";
	$subject = "NIQS Notice for Payment of 2020 Annual Subscription and other Charges";
	$headers = "MIME-Version: 1.0" . "\r\n"; 
	$headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n"; 
	
	// More headers 
	$headers .= 'From: finance@niqs.org.ng' . "\r\n"; 
	$headers .= 'Reply-To: finance@niqs.org.ng' . "\r\n"; 
	//$headers .= 'CC: o.ebiloma@niqs.org.ng, t.adefisayo@niqs.org.ng, salisu@niqs.org.ng' . "\r\n";

if(mail($to,$subject,$html,$headers))
	{
	 	$mysent = $mysent + 1;
	 	//echo "Demand Note Sent Successfully ";
 		mysqli_query($con, "UPDATE members SET sent='12' WHERE memberNo='$memNo'");
 		mail("nimi266@gmail.com",$subject,$html,$headers);
 		//mail("salisuspot@gmail.com",$subject,$html,$headers);
 	}else{
		$notsent = $notsent + 1;
		//echo "Error Sending Mail";
 	}

}

echo " Sent : $mysent ";
echo " Not Sent : $notsent ";
/*
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 = "1969niqsheadofficeabuja"; // 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/");
}
}

function strafter($string, $substring) {
  $pos = strpos($string, $substring);
  if ($pos === false)
   return $string;
  else  
   return(substr($string, $pos+strlen($substring)));
}

function strbefore($string, $substring) {
  $pos = strpos($string, $substring);
  if ($pos === false)
   return $string;
  else  
   return(substr($string, 0, $pos));
}
*/