1#@!#!123s

: / home1 / netbooks / public_html / __demo_zen /
Filename : __cron-job-aniversario.php
back
<?php
error_reporting(0);
set_time_limit(0);
require_once('includes/conecta.php');
include "includes/email/classes/class.phpmailer.php";

################################################################
#################### ALERTAS DE ANIVERSÁRIO ####################
################################################################
if ($res_aniv = $mysqli->query("SELECT nome, id, data_nascimento, email
								from clientes
								WHERE eliminado = 'N' AND ativo = 'S'
								AND data_nascimento<>'0000-00-00'
								ORDER BY nome DESC")) {
	while($dados = $res_aniv->fetch_array()) {
		
		$msg = '';
		
		if($dados['email']!='') {
			
			$separa = explode('-',$dados['data_nascimento']);
			if(date('m-d')==$separa[1].'-'.$separa[2]) {
				
				echo $dados['nome'] . ' - ' . $dados['email'];
				echo '<br>';
				
				$dia = date('Y-m-d');
				$aniversario = utf8_decode('Parabéns!');
				$msg .="<p style='font-family:Calibri;color:black;font-size:15px;'>Bom dia.";
				$msg .="<p style='font-family:Calibri;color:black;font-size:15px;'>O ZEN Cabeleireiros deseja-lhe um excelente aniversário! Muita sáude e muitos anos de vida :)<br/>";
				$msg .="<p style='font-family:Calibri;color:black;font-size:15px;'>Cumprimentos<br/><br/>";
				
				$mail = new PHPMailer();
				$mail->IsSMTP();
				$mail->SMTPDebug = 1;
				$mail->SMTPAuth = true;
				$mail->SMTPSecure = 'tls';
				$mail->Host = "zencabeleireiros.pt";
				$mail->Port = 587;
				$mail->IsHTML(true);
				$mail->Username = "noreply@zencabeleireiros.pt";
				$mail->Password = "XewVvzKxNrDOmOxQyIy8";
				$mail->SetFrom("noreply@zencabeleireiros.pt", "ZEN Cabeleireiros");
				$mail->Subject = utf8_decode('Parabéns!');
				
				$mail->Body = utf8_decode($msg);
				
				##$mail->AddAddress("nunoafdinis@hotmail.com");
				##$mail->AddAddress("zeto.carvalho.11@gmail.com");
				$mail->AddAddress($dados['email']);
				if(!$mail->Send()){
					echo "Mailer Error: " . $mail->ErrorInfo;
				} else{
					echo "Message has been sent";
				}
				
				return false;
			}
			
		}
	}
}
?>