Lettres de relance
<?php include_once(drupal_get_path('module', 'webform') .'/includes/webform.submissions.inc'); include_once('includes/file.inc'); global $user; if (in_array("authenticated user", $user->roles)) { $submissions = webform_get_submissions(313) + webform_get_submissions(317); $registrations = webform_get_submissions(311) + webform_get_submissions(315); ksort($submissions); function echo_mail($to, $subject, $message, $header, $title) { echo "\n";
echo $title . "
";
$head = explode("\n", $header);
foreach ($head as $line) {
$pos = strpos($line, ":");
echo "" . substr($line, 0, $pos+1) . "" . htmlentities(substr($line, $pos+1), ENT_QUOTES, "UTF-8") . "
\n";
}
echo "À: " . htmlentities($to, ENT_QUOTES, "UTF-8") . "
\n";
echo "Sujet: " . htmlentities($subject, ENT_QUOTES, "UTF-8") . "
\n";
echo "
\n\n";
echo htmlentities($message, ENT_QUOTES, "UTF-8");
echo "
\n"; } else { echo "Erreur dans l'envoi du mail à $to
\n"; } } $dict = Array(); $names = Array(); foreach($submissions as $sid => $submission) { $arr = $submission->data; $sid_registration = $arr[1]['value'][0]; if ($sid_registration == 1277) { continue; } if (isset($registrations[$sid_registration])) { $registration = $registrations[$sid_registration]; $reg = $registration->data; $key = strtoupper($reg[3]['value'][0] . $reg[4]['value'][0]); $names[$key] = ""; $nid_submission = $submission->nid; $nid_registration = $registration->nid; if ((isset($reg[19])) and $reg[19]['value'][0] != "") { continue; } if ($nid_registration == 311) { if ((isset($reg[22])) and $reg[22]['value'][0] == "Oui") { continue; } } else { if ((isset($reg[21])) and $reg[21]['value'][0] == "Oui") { continue; } } $to = $reg[14]['value'][0]; $header = ""; $title = "" . $reg[3]['value'][0] . " ". $reg[4]['value'][0] . "\n\n"; if ($nid_submission == 313 and $nid_registration == 311) { $subject = "[CHL2014] Inscription à l'école de théories de Hodge à Rennes"; if ($reg[2]['value'][0] == "M.") { $message = "Cher participant,\n"; } else { $message = "Chère participante,\n"; } $message .= " Comme nous devons bientôt confirmer les réservations de chambres universitaires, nous vous demandons de payer les frais d'inscription avant le 31 mars. Après cette date, nous ne serons plus en mesure de vous fournir de chambre en résidence universitaire. Le paiement s'effectue en ligne depuis la page : //www.lebesgue.fr/fr/content/sem2014-hodge-paiement?sid=$sid_registration Sinon, merci de nous prévenir si vous devez annuler votre participation. Cordialement, Les organisateurs "; } else { $subject = "[CHL2014] Registration to Rennes school on Hodge theories"; $message = "Dear Participant, As we need to confirm the booking of the student rooms soon, we kindly ask you to pay the registration fees before March 31st. After this deadline, we will be unable to provide you with a student room. For the payment, please visit //www.lebesgue.fr/content/sem2014-hodge-paiement?sid=$sid_registration Otherwise, please let us know if you have to cancel your participation. With best regards, The organizers "; } $header = "From: Semestre Lebesgue 2014 \n"; $header .= "Content-Type: text/plain; charset=utf-8"; $dict[$key] = Array("to" => $to, "subject" => $subject, "message" => $message, "header" => $header, "title" => $title); } } if (0 == 1) { foreach($registrations as $sid_registration => $registration) { if ($sid_registration == 1277) { continue; } $reg = $registration->data; $key = strtoupper($reg[3]['value'][0] . $reg[4]['value'][0]); if (isset($names[$key])) { continue; } $names[$key] = ""; $nid_registration = $registration->nid; if ((isset($reg[19])) and $reg[19]['value'][0] != "") { continue; } if ($registration->nid == 311) { if ((isset($reg[22])) and $reg[22]['value'][0] == "Oui") { continue; } } else { if ((isset($reg[21])) and $reg[21]['value'][0] == "Oui") { continue; } } $to = $reg[14]['value'][0]; $header = ""; if ($nid_registration == 311) { $subject = "[CHL2014] Inscription à l'école de théories de Hodge à Rennes"; if ($reg[2]['value'][0] == "M.") { $message = "Cher participant,\n"; } else { $message = "Chère participante,\n"; } $message .= " Nous vous rappelons que la date limite d'inscription est le 31 mars. Nous vous demandons donc de payer les frais d'inscription avant cette date. Le paiement s'effectue en ligne à la page : //www.lebesgue.fr/fr/content/sem2014-hodge-paiement?sid=$sid_registration Sinon, merci de nous prévenir si vous devez annuler votre participation. Cordialement, Les organisateurs "; } else { $subject = "[CHL2014] Registration to Rennes school on Hodge theories"; $message = "Dear Participant, Please note that the deadline for registration is March 31st. We kindly ask you to pay the registration fees before this date. For the payment, please visit //www.lebesgue.fr/content/sem2014-hodge-paiement?sid=$sid_registration Otherwise, please let us know if you have to cancel your participation. With best regards, The organizers "; } $header = "From: Semestre Lebesgue 2014 \n"; $header .= "Content-Type: text/plain; charset=utf-8"; $dict[$key] = Array("to" => $to, "subject" => $subject, "message" => $message, "header" => $header); } } ksort($dict); $nb = 0; foreach ($dict as $demand) { echo_mail($demand["to"], $demand["subject"], $demand["message"], $demand["header"], $demand["title"]); $nb++; } echo "
Total: $nb mails
"; } else { echo "Veuillez vous connecter sur le site pour accéder à cette page.
\n"; } ?>