One Hat Cyber Team

View File Name : demandN.php

<?php
ini_set('display_errors',1);
die();
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");

$sql=mysql_query("SELECT * FROM members a, dues b WHERE a.memberNo = b.memberNo AND a.sent='0' AND a.memberEmail!='' AND memberGrade='5' AND (b.outstanding + b.annualSub + b.advance + b.upgradeCharge + b.annualSub2017 + b.devtLevy1) >  '500' ORDER BY a.memberID ASC LIMIT 0 , 50"); 
if(!$sql){
	echo mysql_error();
}
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=$row['outstanding'];
	$annualSub=$row['annualSub'];
	$advance=$row['advance'];
	$upgradeCharge=$row['upgradeCharge'];
 $an2017 = $row['annualSub2017'];
 //$an2018 = $row['annualSub2018'];
 $devt = $row['devtLevy1'];
	$annual=$annualSub;
	$total=$row['outstanding']+$row['annualSub']+$advance+$upgradeCharge+$row['annualSub2017']+$row['devtLevy1'];

$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 2017 Demand Note</title>

<style type="text/css">
@media print {
  * { background: transparent !important; color: black !important; text-shadow: none !important; filter:none !important; -ms-filter: none !important; margin: 10px;} 
  a, a:visited { text-decoration: underline; }
  a[href]:after { content: " (" attr(href) ")"; }
  abbr[title]:after { content: " (" attr(title) ")"; }
  .ir a:after, a[href^="javascript:"]:after, a[href^="#"]:after { content: ""; }  
  pre, blockquote { border: 1px solid #999; page-break-inside: avoid; }
  thead { display: table-header-group; } 
   img { page-break-inside: avoid; }
  .summary{ page-break-inside: avoid; }
  img { max-width: 100% !important; }
  @page { margin: 0.5cm; }
  p, h2, h3 { orphans: 3; widows: 3; }
p,li,td{text-align: justify; }
  h2, h3 { page-break-after: avoid; }
table{
			border-collapse:collapse;
margin-left: 5px; margin-right: 5px;
		}
}

li{padding-bottom: 5px;}
p,li,td{text-align: justify; }

		body{
			width:100%;
			background-color:#ffffff;
			-webkit-font-smoothing:antialiased;
			font-family:Georgia, Times, serif;

		}
		table{
			border-collapse:collapse;
margin-left: 5px; margin-right: 5px;
		}
img{margin-left:5px;}
@media only screen and (max-width: 640px){
		.deviceWidth{
			width:440px!important;
			padding:0;
		}

}	@media only screen and (max-width: 640px){
		.center{
			text-align:center!important;
		}

}	@media only screen and (max-width: 479px){
		.deviceWidth{
			width:280px!important;
			padding:0;
		}

}	@media only screen and (max-width: 479px){
		.center{
			text-align:center!important;
		}

}

</style></head>
<body leftmargin="5" topmargin="0" marginwidth="0" marginheight="0" style="font-family: Georgia, Times, serif">
<table width="580" border="0" cellpadding="0" cellspacing="0"> 
<tr><td>
    <img src="http://portal.niqs.org.ng/interswitch/logo.png"/>
  </td>
</tr> </table>
<table width="580" border="0" cellpadding="0" cellspacing="0"> 
<tr><td><p>Dear '.$name.', '.$memNo.'</p>
<p><strong><u>DEMAND NOTE FOR 2017 ANNUAL SUBSCRIPTION AND OTHER CHARGES</u></strong><br/>
Please find below the details of your 2017 Annual Subscription, Levy and Previous Outstandings (if any).
</p>
</td></tr></table>
<table  width="580" border="1" cellpadding="0" cellspacing="0">
<thead><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</td><td align="right">'.number_format($annualSub,2).'</td></tr>';
}
if ($an2017 > 0){
 $html .= '<tr><td>2017 Annual Subscription</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 ($devt > 0){
 $html .= '<tr><td>NIQS Head Office Development Levy</td><td align="right">'.number_format($devt,2).'</td></tr>';
}

if ($upgradeCharge > 0) {
 $html .= '<tr><td>Upgrade Charge</td><td align="right">'.number_format($upgradeCharge,2).'</td></tr>';
}
  $html .='<tr><td align="left"><strong>TOTAL</strong></td><td align="right">'.number_format($total, 2).'</td></tr>
</table>
<table  width="580" border="0" cellpadding="0" cellspacing="0">
<tr><td>
<p><strong>Please note:</strong></p>
<ol style="padding-left:58px;">
<li>2017 Annual Subscription and other charges for all Members <strong>are due on 1st January,2017.</strong></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.
</li>
<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.
</li>
<li>
<strong>PAYMENT MODE:</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/>
Skye Bank Plc Account No: 1150000015<br/>
Forward the evidence of Electronic Transfer(E-PAYMENT) or scanned copy of Payment Deposit Slip to niqsenquiry@gmail.com against which an official receipt will be issued.
</li>
<li><strong>BENEFITS OF PAYMENT OF ANNUAL SUBSCRIPTION</strong>
<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>
</li>
</ol>
<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>mails.niqs@gmail.com</strong><br/>Phone Number: <strong>08167593807</strong></p>

<p>Best Regards<br>
<strong>Dr. Babatunde O. Adesiyan, FNIQS</strong><br>
<strong>Treasurer</strong>
</p>
</td></tr></table>
</body>
</html>';

$fmail = filter_var(strbefore($email,','), FILTER_SANITIZE_EMAIL); 
$smail = filter_var(strafter($email,','), FILTER_SANITIZE_EMAIL); 
$email="";

if (strcmp($fmail,$smail) === 0){
 $email = $fmail;
} else {
 $email = $fmail.",".$smail;
}

echo $html;

/*if(sendMail($email,$html)){
	//update sent
    mysql_query("UPDATE members SET sent='1' WHERE memberNo='$memNo'");
  }else{
	echo "Error Sending Mail";
  }
*/
}
//sendMail('niyiment@gmail.com',$html); 

function sendMail($email,$html){
	 $from = "mails.niqs@gmail.com"; //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 = "smtp.gmail.com"; // all scripts must use localhost
 $username = "mails.niqs@gmail.com"; //  your email address (same as webmail username)
 $password = "niqsno84abuja"; // your password (same as webmail password)

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

$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));
}

?>