$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"'."\n"; $headers = 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=utf-8' . "\r\n"; $body= '

'.$PROJECT_TITLE.'

'.$nom_agence.'

Un nouveau client s\'est enregistré sur la borne d\'orientation.

'; if($rdv == 0){ $body .= ' '; } else{ $body .= ''; } $body .= ''; if (($civ != "")&&($nom != "")) { $body .= ''; } if ($phone != "") { $body .= ''; } if ($ticket != "") { $body .= ''; } $body .= ' Prise de rendez-vous préalable : Non Objet de la venue : '.$objetVenue.' Objet de la venue : Invitation en salle de réunion Heure d\'arrivée : '.$start.' Nom : '.$civ.' '.$prenom.' '.$nom.' Numéro de Téléphone : '.$phone.' Numéro de Ticket : '.$ticket.'

Accéder à l\'interface de gestion client

'; 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;$iaddAddress($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)); } ?>