Mailing - À propos des remboursements
<?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)) { global $submissions; $submissions = webform_get_submissions(313) + webform_get_submissions(317); global $registrations; $registrations = webform_get_submissions(311) + webform_get_submissions(315); global $dict; $dict = Array(); ksort($submissions); function register_entry($sid, $message_fr, $message_en, $update=1, $lang="") { global $dict; global $registrations; $registration = $registrations[$sid]; $reg = $registration->data; $to = $reg[14]['value'][0]; $header = "From: Semestre Lebesgue 2014 \n"; $header .= "Content-Type: text/plain; charset=utf-8"; $registration = $registrations[$sid]; $nid_registration = $registration->nid; $reg = $registration->data; if ($nid_registration == 311) { if ((isset($reg[22])) and $reg[22]['value'][0] == "Oui") { return; } if ($lang == "") { $lang = "fr"; } } else { if ((isset($reg[21])) and $reg[21]['value'][0] == "Oui") { return; } if ($lang == "") { $lang = "en"; } } if ($lang == "fr") { $subject = "[CHL2014] À propos des remboursements"; if ($reg[2]['value'][0] == "M.") { $message = "Cher participant,\n"; } else { $message = "Chère participante,\n"; } $message .= $message_fr; $message .= "\nCordialement,\nLes organisateurs\n"; } else { $subject = "[CHL2014] About reimbursements"; $message = "Dear Participant,\n"; $message .= $message_en; $message .= "\nBest regards,\nThe organizers\n"; } $title = "" . $reg[3]['value'][0] . " ". $reg[4]['value'][0] . "\n\n"; $key = strtoupper($reg[3]['value'][0] . $reg[4]['value'][0]); if ($update == 1 or (! isset($dict[$key]))) { $dict[$key] = Array("to" => $to, "subject" => $subject, "message" => $message, "header" => $header, "title" => $title); } } 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";
echo preg_replace("/\n/", "
", htmlentities($message, ENT_QUOTES, "UTF-8"));
echo "
\n"; } else { echo "Erreur dans l'envoi du mail à $to
\n"; } } $message1_fr = " Étant donné que vous allez recevoir des aides financières en lien avec votre participation à l'école de printemps sur les théories de Hodge, nous vous rappelons que : . vous ne serez remboursés qu'après l'école et pas directement sur place . lors de l'école, nous allons vous faire remplir des formulaires contenant diverses informations dont vos coordonnées bancaires . en ce qui concerne le logement, comme vous êtes hébergé en cité universitaire, vous n'aurez rien à payer . nous vous rembourserons un forfait de 15 euros par jour (dimanche compris) pour les dépenses de la vie quotidienne (sachant que les jours de conférences, les déjeuners vous seront fournis) "; $message2_fr = " Étant donné que vous allez recevoir des aides financières en lien avec votre participation à l'école de printemps sur les théories de Hodge, nous vous rappelons que : . vous ne serez remboursés qu'après l'école et pas directement sur place . lors de l'école, nous allons vous faire remplir des formulaires contenant diverses informations dont vos coordonnées bancaires . en ce qui concerne le logement, vous serez remboursés de 35 euros par jour maximum sur présentation des factures (conservez-les donc) . nous vous rembourserons un forfait de 15 euros par jour (dimanche compris) pour les dépenses de la vie quotidienne (sachant que les jours de conférences, les déjeuners vous seront fournis) "; $depl_fr = " . pour le remboursement des frais de déplacement, n'oubliez pas de conserver tous vos tickets (cartes d'embarquement, billets de train) et factures\n"; $message1_en = " As you got support for lodging and/or living and/or travelling expanses for attending our spring school on Hodge theories, we recall that . we will not give you money during the school, you will be reimbursed afterwards . you will be asked to fill a form, with bank data (swift or iban code) . for lodging expanses, as you are provided with a student room, you will not have to pay . for living expanses, you do not need to keep the receipts, you will get a flat rate of 15 euros per day, including Sundays (lunches on working days are provided by us) "; $message2_en = " As you got support for lodging and/or living and/or travelling expanses for attending our spring school on Hodge theories, we recall that . we will not give you money during the school, you will be reimbursed afterwards . you will be asked to fill a form, with bank data (swift or iban code) . for lodging expanses, please keep your bills and you will be reimbursed afterwards for up to 35 euros per night . for living expanses, you do not need to keep the receipts, you will get a flat rate of 15 euros per day, including Sundays (lunches on working days are provided by us) "; $depl_en = " . for reimbursement of travel expanses, please keep the boarding passes, train, bus tickets, and all the relevant bills\n"; foreach($submissions as $sid => $submission) { $arr = $submission->data; $sid_registration = $arr[1]['value'][0]; if ($sid_registration == 1277) { continue; } if (! isset($registrations[$sid_registration])) { continue; } $reg = $registrations[$sid_registration]->data; if ($submission->nid == 313) { $cid = 6; $cid_travel = 4; $cid_travel2 = 10; } else { $cid = 5; $cid_travel = 3; $cid_travel2 = 9; } if ((! isset($reg[19])) or $reg[19]['value'][0] == "" or (! isset($arr[$cid]))) { continue; } $lang = ""; if ($submission->nid == 317) { $lang = "en"; } if ($arr[$cid]['value'][0] == 'univcity') { $message_fr = $message1_fr; $message_en = $message1_en; } else { $message_fr = $message2_fr; $message_en = $message2_en; } if ($arr[$cid_travel]['value'][0] != 0 and (! (isset($arr[$cid_travel2]) and $arr[$cid_travel2]['value'][0] == 0))) { $message_fr .= $depl_fr; $message_en .= $depl_en; } register_entry($sid_registration, $message_fr, $message_en, 1, $lang); } 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"; } ?>