One Hat Cyber Team

View File Name : demandNoteOutstanding.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='01526' OR 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' ORDER BY a.memberID ASC"); 
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'];
		
		if($memNo = '00744'){ $total = $total + 161224; } //QS Gagariga
		if($memNo = '01526'){ $total = $total + 1205450; } //QS Fadason
		

$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 QS '.$names.', '.$memNo.'</p>
	<p><strong><u>DEMAND NOTE FOR 2019 ANNUAL SUBSCRIPTION AND OTHER CHARGES</u></strong><br/>
	Please find below the details of your 2019 Annual Subscription, Levy and Previous Outstandings (if any).
	</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="left">Amount(N)</th></tr></thead><tbody>';
	
	if ($amount > 0){
	 $html .= '<tr><td>Previous Outstanding up to December 31st, 2015</td><td align="right">'.number_format($amount,2).'</td></tr>';
	}
	if ($annual > 0){
	 $html .= '<tr><td>2016 Annual Subscription (Outstanding)</td><td align="right">'.number_format($annualSub,2).'</td></tr>';
	}
	if ($an2017 > 0){
	 $html .= '<tr><td>2017 Annual Subscription (Outstanding)</td><td align="right">'.number_format($an2017,2).'</td></tr>';
	}
	
	if ($an2018 > 0){
	 $html .= '<tr><td>2018 Annual Subscription</td><td align="right">'.number_format($an2018,2).'</td></tr>';
	}
	
	if ($an2019 > 0){
	 $html .= '<tr><td>2019 Annual Subscription</td><td align="right">'.number_format($an2019,2).'</td></tr>';
	}
	

	//if ($devt > 0){
	 $html .= '<tr><td>NIQS Head Office Development Levy (1st Installment Outstanding)</td><td align="right">'.number_format($devt,2).'</td></tr>';
	//}
	//if ($devt2 > 0){
	 $html .= '<tr><td>NIQS Head Office Development Levy (2nd Installment)</td><td align="right">'.number_format($devt2,2).'</td></tr>';
	//}
	
	
	if ($upgradeCharge > 0) {
	 $html .= '<tr><td>Upgrade Charge</td><td align="right">'.number_format($upgradeCharge,2).'</td></tr>';
	}
	
	//QS Gagariga special row
	if($memNo == "00744"){ 
	  $html .= '<tr><td>Advance in lieu of 2016 FIG Registration received February 2, 2016 </td><td align="right"> 161,224.00 </td></tr>';

	}elseif($memNo == "01526"){
	  //QS Fadason special rows 
	  $html .= '<tr><td>Balance for 250 BESMM3 for Students @ N2,250 each received July 24, 2013 </td><td align="right"> 505,450.00 </td></tr>';
	  $html .= '<tr><td>Personal Loan received September 2, 2015 </td><td align="right"> 700,000.00 </td></tr>';
	} 
	
	
	//special rows --
	
	  $html .='<tr><td align="left"><strong>TOTAL</strong></td><td align="right">'.number_format($total, 2).'</td></tr>
	</table>
	</td></tr></table>
	
	<table align="center" width="90%" border="0" cellpadding="0" cellspacing="0">
	<tr><td>
	
	<p><strong>Please note:</strong></p>
	<ol style="padding-left:10px;">
	<li>2019 Annual Subscription and other charges for all Members <strong>are due on 1st January,2019.</strong> <br>(Section 10.3.1 of the NIQS Constitution)<br><br></li>
	<li>All members are expected to be financially up-to-date on or before 31<sup>st</sup> of March 2019. <br>(Section 10.3.2 of the NIQS Constitution)<br><br></li> 
	<li>Our Institute has neither a financier nor enjoys any grant from other sources. Its growth depends on the regular payment of your Annual Subscription and other charges as this is one of your professional obligations to the Institute.<br><br></li>';
	
	$totaldevt = $devt + $devt2;
	if($totaldevt > 0)
	{
 	  $html .='<li><strong>NIQS Head Office Development Levy</strong><br/>
	The 2016 Annual General Meeting held on 10th November, 2016 at Horlikins Event Place, Port Harcourt approved the payment of New Secretariat Development Levy by all Members and Practising Firms payable within the next two years as follows: 
	
	  <table cellpading="0" cellspacing="0" style="margin-left:20px;">
	  <tr><th align="left" colspan="2">Grade</th><th>Amount(N)</th></tr>
	  <tr><td>Past Presidents</td><td>&nbsp;&nbsp;</td><td cellspacing="10">100,000.00 x 2years</td></tr>
	  <tr><td>Fellows</td><td>&nbsp;&nbsp;</td><td>50,000.00 x 2years</td></tr>
	  <tr><td>Members (Above 10 years)</td><td>&nbsp;&nbsp;</td><td>37,500.00 x 2years</td></tr>
	  <tr><td>Members (Under 10 years)</td><td>&nbsp;&nbsp;</td><td>25,000.00 x 2years</td></tr>
	  <tr><td>Probationers & Technicians</td><td>&nbsp;&nbsp;</td><td>5,000.00 x 2years</td></tr>
	  <tr><td>Practising Firms</td><td>&nbsp;&nbsp;</td><td>50,000.00 x 2years</td></tr>
	  </table>
	Members may choose to stagger the levy amount in maximum of two (2) installments.<br><br></li>
	';
	}
	
	$html .='<li>
	<strong>PAYMENT OPTION:</strong><br/>
	<strong>(a) <i>On-line Payment:</i></strong> Please visit our website(www.niqs.org.ng), click on "MAKE PAYMENT", and login before you continue.<br/>
	<strong>(b) <i>Bank Deposit/Electronic Transfer:</i></strong><br/>
	<strong>Account Name: The Nigerian Institute of Quantity Surveyors</strong><br/>
	Guaranty Trust Bank Plc Account No: 0010899819<br/>
	OR<br/>
	Polaris Bank Plc Account No: 1150000015<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><br>
	</li>
<li><strong>BENEFITS OF PAYMENT OF ANNUAL SUBSCRIPTION</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>

	<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>
	<p>Kindly avail us your feedback through the email address and phone number below to make your 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 = "salisu@niqs.org.ng";
	$subject = "Draft NIQS 2019 Demand Note - ".$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: writesalisu@gmail.comg, salisuspot@gmail.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));
}
*/

?>