<?php
require '../../inc/PHPMailerAutoload.php';
include ('../../inc/confNetisse.php');
if(WTS_ENV == 'demo'){
require './ses.php';
}
$sendmail = isset($PILE_CONF["SENDEMAIL"])?$PILE_CONF["SENDEMAIL"]:false;
if(isset($_REQUEST['IDA']) && $sendmail) {
//$mail = new PHPMailer();
$start = date('H:i:s');
$IDA = $_REQUEST['IDA'];
$nom_agence = $_REQUEST['agence'];
$afa = (isset($GLOBALS["BO_CONF"]["AFA"]) && $GLOBALS["BO_CONF"]["AFA"]) ? true : false;
$rdv = isset($_REQUEST['choice']) ? $_REQUEST['choice'] : 0;
$civ = "";
if (isset($_REQUEST['civ'])) $civ = $_REQUEST['civ'];
$nom = "";
$prenom = "";
if (isset($_REQUEST['nom'])) $nom = $_REQUEST['nom'];
if (isset($_REQUEST['prenom'])) $prenom = $_REQUEST['prenom'];
$company = "";
if (isset($_REQUEST['company'])) $company = $_REQUEST['company'];
$NFCPROV = 0;
if (isset($_REQUEST['nfcprov'])) $NFCPROV = $_REQUEST['nfcprov'];
$meeting = ($choice == 2) ? 1 : 0;
$CLIENT = 0;
if (isset($_REQUEST['client'])) $CLIENT = $_REQUEST['client'];
$phone = "";
if (isset($_GET['phone'])) $phone = $_GET['phone'];
$ticket = "";
if (isset($_GET['ticket'])) $ticket = $_GET['ticket'];
$action = "";
if (isset($_REQUEST['action'])) $action = $_REQUEST['action'];
$action = $action ? json_decode($action) : false;
$IDMOTIF = 0;
if (isset($_REQUEST['motif'])) $IDMOTIF = $_REQUEST['motif'];
$MOTIFS = ($GLOBALS["BORNE_CONF"]["MULTIPLEMOTIFS"])?explode(",", $IDMOTIF):array($IDMOTIF);
$afa_motifs = (isset($GLOBALS["BO_CONF"]["AFA_MOTIFS"]) && $GLOBALS["BO_CONF"]["AFA_MOTIFS"]) ? true : false;
$q = "SELECT id_agence".$afaQ." FROM ca_agences WHERE code_agence=:code_agence and supp=:supp ";
$values = array('code_agence' => $IDA, 'supp' => 0);
$result = excuteQuery($q, $values);
if (!$result['status'])
wts_die (var_dump($result['stmt']->errorInfo()));
$o = $result['stmt']->fetch(PDO::FETCH_OBJ);
$agence = $o->id_agence;
$q = "SELECT titre FROM ca_motifs WHERE id_motif IN (".implode(",", $MOTIFS).")";
$r = excuteQuery($q);
if (!$r['status'])
wts_die (var_dump($r['stmt']->errorInfo()));
$objetVenue = array();
while($o = $r['stmt']->fetch(PDO::FETCH_OBJ)){
$objetVenue[] = $o->titre;
}
$objetVenue = implode(",", $objetVenue);
$ADRESSES = array();
$mailWhere = ($GLOBALS["BO_CONF"]["CONSEILLER"]["receive_email"]) ? " AND receive_email = 1" : "";
$mailWhere .= ' AND id_conseiller IN (SELECT ca.id_conseiller FROM ca_conseiller_agence ca WHERE id_agence= '.$agence.' AND ca.receive_notifications=1)';
$q = "SELECT email FROM ca_conseillers WHERE id_agence=".$agence." AND inactif=0 AND supp=0".$mailWhere;;
$r = excuteQuery($q);
if (!$r['status'])
wts_die (var_dump($r['stmt']->errorInfo()));
$i = 0;
while($o = $r['stmt']->fetch(PDO::FETCH_OBJ))
{
$check = explode(";", $o->email);
if (count($check) == 1) {
if (!in_array($o->email, $ADRESSES)) {
$ADRESSES[$i] = $o->email;
$i++;
}
} else {
for($j=0;$j<(count($check));$j++) {
if (!in_array($check[$j], $ADRESSES)) {
$ADRESSES[$i] = $check[$j];
$i++;
}
}
}
}
if(!$action){
$q = "SELECT count(*) as total FROM ca_clients WHERE DATEDIFF(date_arrivee,now())=0 AND id_agence=".$agence." ORDER BY id_client";
$r = excuteQuery($q);
if (!$r['status'])
wts_die (var_dump($r['stmt']->errorInfo()));
while($o = $r['stmt']->fetch(PDO::FETCH_OBJ)){
$total=$o->total;
}
$q = "UPDATE ca_clients SET nbr=".$total." WHERE id_client =".$id;
$r = excuteQuery($q);
if (!$r['status'])
wts_die (var_dump($r['stmt']->errorInfo()));
}
if($rdv==0 && count($ADRESSES) > 0){
$headers ='From: "Borne d\'orientation"<borne@welcometouchscreen.com>'."\n";
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=utf-8' . "\r\n";
$body= '
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<table width="600" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center"><span style="font-family:Verdana, Geneva, sans-serif; font-size:16px; font-weight:bold;text-transform: uppercase;">'.$PROJECT_TITLE.'</span></td>
</tr>
<tr>
<td align="center"> </td>
</tr>
<tr>
<td align="center"><span style="font-family:Verdana, Geneva, sans-serif; font-size:14px; font-weight:bold;text-transform: uppercase;">'.$nom_agence.'</span></td>
</tr>
<tr>
<td align="center"> </td>
</tr>
<tr>
<td align="center" bgcolor="#fafafa"> </td>
</tr>
<tr>
<td align="center" bgcolor="#fafafa">
<span style="font-family:Verdana, Geneva, sans-serif; font-size:16px; font-weight:bold;">Un nouveau client s\'est enregistré sur la borne d\'orientation.</span></td>
</tr>
<tr>
<td align="center" bgcolor="#fafafa"> </td>
</tr>
<tr>
<td align="center" bgcolor="#fafafa">
<table width="600" border="0" cellspacing="0" cellpadding="10">';
if($rdv == 0){
$body .= '
<tr>
<td align="right"><span style="font-family:Verdana, Geneva, sans-serif; font-size:12px;">Prise de rendez-vous préalable : </span></td>
<td align="left"><span style="font-family:Verdana, Geneva, sans-serif; font-size:12px; font-weight:bold;">Non</span></td>
</tr>
<tr>
<td align="right"><span style="font-family:Verdana, Geneva, sans-serif; font-size:12px;">Objet de la venue :</span></td>
<td align="left"><span style="font-family:Verdana, Geneva, sans-serif; font-size:12px; font-weight:bold;">'.$objetVenue.'</span></td>
</tr>';
} else{
$body .= '<tr>
<td align="right"><span style="font-family:Verdana, Geneva, sans-serif; font-size:12px;">Objet de la venue :</span></td>
<td align="left"><span style="font-family:Verdana, Geneva, sans-serif; font-size:12px; font-weight:bold;">Invitation en salle de réunion</span></td>
</tr>';
}
$body .= '<tr>
<td align="right"><span style="font-family:Verdana, Geneva, sans-serif; font-size:12px;">Heure d\'arrivée : </span></td>
<td align="left"><span style="font-family:Verdana, Geneva, sans-serif; font-size:12px; font-weight:bold;">'.$start.'</span></td>
</tr>';
if (($civ != "")&&($nom != "")) {
$body .= '<tr>
<td align="right"><span style="font-family:Verdana, Geneva, sans-serif; font-size:12px;">Nom : </span></td>
<td align="left"><span style="font-family:Verdana, Geneva, sans-serif; font-size:12px; font-weight:bold;">'.$civ.' '.$prenom.' '.$nom.'</span></td>
</tr>';
}
if ($phone != "") {
$body .= '<tr>
<td align="right"><span style="font-family:Verdana, Geneva, sans-serif; font-size:12px;">Numéro de Téléphone : </span></td>
<td align="left"><span style="font-family:Verdana, Geneva, sans-serif; font-size:12px; font-weight:bold;">'.$phone.'</span></td>
</tr>';
}
if ($ticket != "") {
$body .= '<tr>
<td align="right"><span style="font-family:Verdana, Geneva, sans-serif; font-size:12px;">Numéro de Ticket : </span></td>
<td align="left"><span style="font-family:Verdana, Geneva, sans-serif; font-size:12px; font-weight:bold;">'.$ticket.'</span></td>
</tr>';
}
$body .= '</table>
</td>
</tr>
<tr>
<td align="center" bgcolor="#fafafa"> </td>
</tr>
<tr>
<td align="center" bgcolor="#fafafa"><a href="'.$MAILRDVSRDVPATH.'/?IDA='.$IDA.'" style="font-family:Verdana, Geneva, sans-serif; font-size:14px; font-weight:bold;color:#c70317;">Accéder à l\'interface de gestion client</a></td>
</tr>
<tr>
<td align="center" bgcolor="#fafafa"> </td>
</tr>
<tr>
<td align="center" bgcolor="#fafafa"> </td>
</tr>
</table>
</body>
</html>';
if(WTS_ENV == 'demo'){
$SENDERNAME = $PROJECT_ABBREVIATION;
$SENDEREMAIL = $MAIL_FROM;
if ($prenom != "") {
$SUBJECT = "Borne d'accueil : ".$civ." ".$prenom." ".$nom;
} else if($nom != "") {
$SUBJECT = "Borne d'accueil : ".$civ." ".$nom;
}
else{
$SUBJECT = "Borne d'accueil : ".strip_tags($objetVenue);
}
$ses = new SimpleEmailService('AKIAJ4AK54QVXKXT2VXA', 'OyNcXwcmTGhvxEqrgD8TjCwYeg68fPFXXBGVU2WZ');
$m = new SimpleEmailServiceMessage();
// ENCODAGE :
$m->setFrom($SENDERNAME.' <'.$SENDEREMAIL.'>');
$m->addReplyTo($SENDEREMAIL);
$m->setSubject($SUBJECT);
$m->setMessageFromString('',$body);
// DESTINATAIRES
$m->addTo($ADRESSES);
try {
$ses->sendEmail($m);
$return = array("status"=>true);
}
catch (AwsException $e) {
$return = array("status"=>false, "message" => ("Mailer Error: " . $e->getMessage()));
}
echo json_encode($return);
}
else{
$mail = new PHPMailer();
$mail->isSMTP();
$mail->SMTPDebug = 0;
$mail->Debugoutput = 'html';
$mail->Host = SMTP_HOST;
$mail->Port = SMTP_PORT;
$mail->SMTPAuth = false;
$mail->Username = SMTP_USERNAME;
$mail->Password = SMTP_PASSWORD;
$mail->setFrom($MAIL_FROM, $PROJECT_ABBREVIATION.' : Borne d\'orientation');
$mail->CharSet = 'UTF-8';
for($i=0;$i<count($ADRESSES);$i++) {
$mail->addAddress($ADRESSES[$i]);
}
if ($prenom != "") {
$mail->Subject = "Borne d'accueil : ".$civ." ".$prenom." ".$nom;
} else if($nom != "") {
$mail->Subject = "Borne d'accueil : ".$civ." ".$nom;
}
else{
$mail->Subject = "Borne d'accueil : ".strip_tags($objetVenue);
}
$mail->msgHTML($body);
//send the message, check for errors
if($mail->send())
{
$return = array("status"=>true);
}
else
{
$return = array("status"=>false, "message" => ("Mailer Error: " . $mail->ErrorInfo));
}
echo json_encode($return);
}
}
} else {
echo json_encode(array("status"=>false));
}
?>