1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
|
//BLOCK1
//get the info yellow_Agents (parents)
$qpar = "select * from yellow_agents";
$rpar = mysql_query($qpar) or die(mysql_error());
$apar = mysql_fetch_array($rpar);
//BLOCK2
//get the info yellow_Agents_garderies
$qgarderies = "select * from yellow_agents_garderies";
$rgarderies = mysql_query($qgarderies) or die(mysql_error());
$agarderies = mysql_fetch_array($rgarderies);
//BLOCK3
// vérifier si le email a déjà été envoyer selon la table de log yellow_alert_sended
$qnotsend = "select * from yellow_alert_sended where yellow_alert_sended.fusion != '$apar[email_parents]$agarderies[AgentID_garderies]'";
$rnotsend = mysql_query($qnotsend) or die(mysql_error());
if(mysql_num_rows($rnotsend) > '0')
{
echo "exit car le courriel a déjà ete envoyé";
exit();
}
//BLOCK4
// vérifier les couincidations des annonces des garderies avec les alerts des parents enregistrer
$qexpa = "select DISTINCT * from yellow_alert, yellow_agents_garderies where
yellow_alert.statut_Alert = 'active' &&
yellow_alert.statut_Alert = yellow_agents_garderies.statut_annonceID &&
yellow_alert.CategoryList = yellow_agents_garderies.CategoryID &&
yellow_alert.Provinces = yellow_agents_garderies.Provinces &&
yellow_alert.state = yellow_agents_garderies.state";
$rexpa = mysql_query($qexpa) or die(mysql_error());
if(mysql_num_rows($rexpa) > '0')
{
while($aexp = mysql_fetch_array($rexpa))
{
//BLOCK5
//envoie du courriel au parent
$to = $aexp[email_parents];
$subject = stripslashes ("Notification Test");
$message = stripslashes ("Test une annonce à été modifier et/ou ajoute et correspond à votre alerte qui est activé.\n\n");
$message .= stripslashes ("Voici le lien de l'annonce en question qui correspond au parametre de votre alert.\n\n");
$message .= stripslashes ("\nhttp://$_SERVER[HTTP_HOST]/TEST/info_garderies.php?id=$aexp[AgentID_garderies]\n\n");
$message .= stripslashes ("merci et bonne journée\n\n");
$headers = "MIME-Version: 1.0\n";
$headers .= "Content-type: text/plain; charset=iso-8859-1\n";
$headers .= "Content-Transfer-Encoding: 8bit\n";
$headers .= "From: $_SERVER[HTTP_POST] <$aset[ContactEmail]>\n";
$headers .= "X-Priority: 1\n";
$headers .= "X-MSMail-Priority: High\n";
$headers .= "X-Mailer: PHP/" . phpversion()."\n";
mail($to, $subject, $message, $headers);
//BLOCK6
// après que le mail soit envoyé on log l'envoie dans la table yellow_alert_sended pour pouvoir vérifier avant l'envoie à savoir si le mail a déjà été envoyé
mysql_query("insert into yellow_alert_sended set fusion = '$aexp[email_parents]$aexp[AgentID_garderies]', AgentID_garderies = '$aexp[AgentID_garderies]'");
}
} |
Partager