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 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85
| <?php
require_once('PHPMailer/class.phpmailer.php');
require_once('PHPMailer/class.smtp.php');
// Connexion à la base SQL SAGE
require('config/config.php');
// Récupération de Foundation et CSS Perso
require('header.html');
require('footer.html');
// Définition de la date en Francais
$jour = array("Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi");
$mois = array("","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre");
$datefr = $jour[date("w")]." ".date("d")." ".$mois[date("n")]." ".date("Y");
// Requete de récupération de la base SQL
$query = "
SELECT *,(SELECT SUM(Total) FROM dbo.Vue_ClassementRegroupe) AS toto,(SELECT SUM(ALARME) FROM dbo.Vue_ClassementRegroupe) AS TotalAla, (SELECT SUM(HUMAIN) FROM dbo.Vue_ClassementRegroupe) AS TotalHum
FROM dbo.Vue_ClassementRegroupe
WHERE CO_Nom NOT LIKE 'Divers'
ORDER BY ALARME+HUMAIN DESC
";
$result = odbc_exec($connection, $query) or die("<p>".odbc_errormsg($connection));
// Variable de classement
$s = 0;
// Contenu du mail
$mail = new PHPMailer;
$mail-> charSet = "UTF-8";
$mail->isSMTP();
$mail->Host = "smtp.domaine.fr";
$mail->SMTPAuth = true;
$mail->Username = 'email@domaine.fr';
$mail->Password = '********';
$mail->Port = 25;
$mail->From = 'email@domaine.fr';
$mail->FromName = 'CA';
$mail->addAddress('email2@domaine.fr','utilisateur');
$mail->WordWrap = 50;
$mail->isHTML(true);
$mail->Subject = 'CA - '.date('d/m/Y');
$mail->Body = '<html><body><br>';
$mail->Body.= '</br>';
$mail->Body.= '<h2 style="margin-top: -50px;text-align: center;font-family: MuseoSlab500Regular, arial, helvetica, sans-serif;font-weight: normal;">CLASSEMENT COMMERCIAL<p style="color:darkred;">'.$datefr.'</p></h2>';
$mail->Body.= '<center>
<table style="padding: 10px;"><th style="text-align: left;font-size: 20px;background-color: #000000;color: #ffffff;">Position</th><th style="text-align: center;font-size: 20px;background-color: #000000;">Nom</th><th style="text-align: center;font-size: 20px;background-color: #000000;color: #ffffff;">Total</th><body style="background-color: #FFEF01;"><th style="text-align: center;font-size: 20px;background-color: #000000;color: #ffffff;">Alarme</th><th style="text-align: center;font-size: 20px;background-color: #000000;color: #ffffff;">Humain</th>';
// Boucle de contenu du mail
while ($data = odbc_fetch_array($result)) {
$mail->attachmentExists($TotalAlarme = $data['TotalAla']);
$mail->attachmentExists($TotalHumain = $data['TotalHum']);
$mail->attachmentExists($TotalGeneral = $data['toto']);
$mail->Body.= '<tr><td style="background-color: #000000;color: #ffffff;font-size: 20px;text-align: center;font-weight: bold;"><p>'.++$s.'</p></td>';
$mail->Body .= '<td style="background-color: #ffffff;font-weight:bold;font-family: Times New Roman, sans-serif;">' . $data['CO_Nom'] . '</td>';
$mail->Body .= '<td style="background-color: #ffffff;text-align: center;color:darkred;font-family: Arial, Helvetica, sans-serif;font-weight: bold;">' . number_format($data['ALARME'] + $data['HUMAIN'], 0, ',', ' ') . ' ' . '</td>';
$mail->Body .= '<td style="background-color: #ffffff;text-align: center;color:red;font-family: Arial, Helvetica, sans-serif;">' . number_format($data['ALARME'], 0, ',', ' ') . ' ' . '</td>';
$mail->Body .= '<td style="background-color: #ffffff;text-align: center;color:red;font-family: Arial, Helvetica, sans-serif;">' . number_format($data['HUMAIN'], 0, ',', ' ') . ' ' . '</td></tr>';
}
$mail->Body .= '</table>';
$mail->Body .= '</br>';
$mail->Body .= '<center><table style="padding: 10px;"><th style="text-align: left;font-size: 20px;background-color: #000000;color: #ffffff;width: 300px;text-align: center;">Total Alarme</th><th style="text-align: left;font-size: 20px;background-color: #000000;color: #ffffff;width: 300px;text-align: center;">Total Humain</th><th style="text-align: left;font-size: 20px;background-color: #000000;color: #ffffff;width: 300px;text-align: center;">Total Alarme + Humain</th>';
$mail->Body .= '<tr><td style="color: white;background-color: red;font-family: Arial, Helvetica, sans-serif;font-size: 30px;font-weight: bold;width: 150px;height: 50px;text-align: center;">'.number_format($TotalAlarme, 0, ',', ' ').' ' . '</td>';
$mail->Body .= '<td style="color: white;background-color: red;font-family: Arial, Helvetica, sans-serif;font-size: 30px;font-weight: bold;width: 150px;height: 50px;text-align: center;">'.number_format($TotalHumain, 0, ',', ' ').' ' . '</td>';
$mail->Body.= '<td style="color: white;background-color: red;font-family: Arial, Helvetica, sans-serif;font-size: 30px;font-weight: bold;width: 150px;height: 50px;text-align: center;">'.number_format($TotalGeneral, 0, ',', ' ').' ' . '</td>';
$mail->Body .= '</tr></table>';
$mail->Body .= '<p>Ce courriel vous est envoyé automatiquement, merci de ne pas utiliser la fonction "Répondre".</p>';
$mail->Body.= '</body></html></center>';
$mail->AltBody = 'This is the body in plain text for non-HTML mail clients';
// Condition si le mail à été envoyé ou pas
if(!$mail->send()) {
echo 'Message could not be sent.';
echo 'Mailer Error: ' . $mail->ErrorInfo;
exit;
}
echo 'Message has been sent';
// Retour à la page d'accueil automatiquement lorsque le mail à été envoyé
header("Location: index.php"); |
Partager