One Hat Cyber Team

View File Name : demandNoteGagariga.php

<?php
ini_set('display_errors',1);
die();
//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","{{Xtreme1969}}") or die("NC");
$db = mysqli_select_db($con, "niqsorgn_pota1969");

// Gagariga Taridouye: 00744 
// Ruya Fadason:       01526
// (a.memberNo='01526' OR a.memberNo='00744')

$sql=mysqli_query($con, "SELECT * FROM members a, dues b WHERE a.memberNo = b.memberNo AND a.memberNo='00744' AND a.sent!=88 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) >  '500'"); 
if(!$sql){
	echo mysqli_error($con);
}
$mysent = 0;
$notsent = 0;
$i = mysqli_num_rows($sql);
echo "Count : $i <br>";
while ($row=mysqli_fetch_array($sql)){
	$memNo=$row['memberNo'];
		$names=$row['memberSurname']." ".$row['memberOthernames'];
		
		$date=date('Y-m-d');
		$email=$row['memberEmail'];
		
		//$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'];
		 $devt = $row['devtLevy1'];
		 $devt2 = $row['devtLevy2'];
		$annual=$annualSub;
		$total=$row['outstanding']+$row['annualSub']+$advance+$upgradeCharge+$row['annualSub2017']+$row['annualSub2018']+$row['annualSub2019']+$row['devtLevy1']+$row['devtLevy2'];
		
		$total = $total + 161224; //QS Gagariga
		

$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 2019 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="http://portal.niqs.org.ng/interswitch/logo.png"/>
	  </td>
	</tr> 
	<tr><td>
	
	<table width="90%" align="center" border="0" cellpadding="0" cellspacing="0"> 
	<tr><td>

	<br>
	<p>Dear '.$names.', '.$memNo.'</p>
	<p><strong><u>NOTICE FOR THE PAYMENT OF 2019 ANNUAL SUBSCRIPTION AND OTHER OUTSTANDING</u></strong><br/><br/>
	Please find below the details of your 2019 Annual Subscription, Levy and other outstandings for payment.<br><br>
	</p>
	
	</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"><strong>FINANCIAL SUMMARY</strong></th></tr>
	<tr><th align="left">Item Description</th><th align="right">Amount</th></tr></thead><tbody>';
	
	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 ($annual > 0){
	 $html .= '<tr><td>2016 Annual Subscription (Outstanding)</td><td align="right"><del>N</del>'.number_format($annualSub,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 ($an2018 > 0){
	 $html .= '<tr><td>2018 Annual Subscription</td><td align="right"><del>N</del>'.number_format($an2018,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 ($devt > 0){
	 $html .= '<tr><td>NIQS Head Office Development Levy (1st Installment Outstanding)</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>';
	}
	
	//QS Gagariga special row
	  $html .= '<tr><td>Advance in lieu of 2016 FIG Registration received February 2, 2016 </td><td align="right"><del>N</del> 161,224.00 </td></tr>';

	
	//special rows --
	  $html .='<tr><td align="left"><strong>TOTAL</strong></td><td align="right"><b><del>N</del>'.number_format($total, 2).'</b></td></tr>
	</table><br>
	</td></tr></table>
	
	<table align="center" width="90%" border="0" cellpadding="0" cellspacing="0">
	<tr><td>
	
	<p>We also wish to remind you of the following for your information: </p>
	<ol style="padding-left:10px;">
	<li>2019 Annual Subscription and other charges for all Members <strong>are due on 1st January, 2019</strong> in accordance with section 10.3.1 of the Constitution of the Nigerian Institute of Quantity Surveyors.<br><br></li>
	<li>All members are expected to be financially up-to-date on or before 31<sup>st</sup> of March of every year. See section 10.3.2 of the Constitution of Nigerian Institute of Quantity Surveyors.<br><br></li> 
	<li>It has been agreed at the 2018 AGM of the Institute 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. <br><br></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><br><br>
	Members may choose to pay the levy amount in maximum of two (2) installments as shown above or pay it at once.<br><br></li>
	';
	}
	
	$html .='<li>For your convenience, the Institute has made available the following Bank Accounts details'."'".' through which you can make <b>Direct Bank Deposit or Electronic Transfers.<br/><br/>
	Account Name: The Nigerian Institute of Quantity Surveyors<br/><br/>
	Guaranty Trust Bank Plc Account No: 0010899819<br/>
	OR<br/>
	Polaris Bank Plc Account No: 1150000015</b><br/><br/>
	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.<br>
	
	<p>Always quote your membership number<strong> ('.$memNo.') </strong>in all your correspondences with us.</p>
	<p>Your full name and membership number must be provided on the deposit slip as a reference.</p> <br>
	
	</li>
<li><strong>The following are benefits of prompt payment of membership subscriptions:</strong></li>
	
	</ol>

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

	<p>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. <br> 
       Email: <strong>info@niqs.org.ng</strong><br> 
       Phone Number: <strong>08167593807</strong></p>
	
	<p>Best Regards.<br>
	
	<br><br>
	<strong>QS Musa Salau, FNIQS</strong><br>
	<strong>Treasurer</strong>
	</p>
	
	</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>';
	
	//$to = "t.adefisayo@niqs.org.ng";
	//$to = "nimi266@yahoo.co.uk";
	//$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 = "o.ebiloma@niqs.org.ng";
	$subject = "NIQS Notice for Payment of 2019 Annual Subscription and other Charges - ".$names;
	$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: obafemionashile@yahoo.com, secretarygeneral@niqs.org.ng, salaumusa@yahoo.com' . "\r\n"; 
	
	if(mail($to,$subject,$html,$headers))
	{
	  	$mysent = $mysent + 1;
	  	//echo "<b><font color='blue'>Demand Note Sent Successfully </font></b>";
    		//mysqli_query($con, "UPDATE members SET sent='1' WHERE memberNo='$memNo'");
    		//mail("nimi266@yahoo.co.uk",$subject,$html,$headers);
    		//mail("salisuspot@gmail.com",$subject,$html,$headers);
  	}else{
		$notsent = $notsent + 1;
		//echo "Error Sending Mail";
  	}

}

echo "<br> Sent : $mysent ";
echo "<br> 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 <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 = "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("<p>" . $mail->getMessage() . "</p>");
}
else {
	return 1;
//echo("<p>Message successfully sent!</p>");
// 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));
}
*/

?>