<?php
$root_path = "../";
$page_name = "Contact";
$page_categ = "contact";
$page_key="contact";
$page_icon = "star";
$page_submenu = false;

// ## HEADER
// Useful for this page
$header_page_needs_db = true;
require $root_path.'inc/header.inc.php';

// Email destinataire
$to_email = $WEBSITE_sales_email;

$valid_form = false;
$mail_is_sent = false;

$lname_in_error = '';
$fname_in_error = '';
$email_in_error = '';
$msg_in_error = '';
$effectif_in_error = '';
$company_in_error = '';

$echec = false;

$init_contact_object = '';
if (isset($_GET['obj']) && $_GET['obj']=='SALES')
{
    $init_contact_object = 'SALES';
}

// pré-chargé newsletter
// ----------------------
$newsletter_precheck = false;
if (isset($_GET['newsletter']) && $_GET['newsletter']=='ok')
{
	$newsletter_precheck = true;
	$_POST['contact_object'] = 'NEWS';
	$_POST['contact_message'] = "Bonjour,
Veuillez, s'il vous plaît, m'inscrire à votre newsletter car je souhaite rester informé de votre actualité.
Merci.";
}

$msg_output = '';

// no bot !
// ----------
$echec = true;
$vscontok_key = md5(date('m')*date('Y')*date('d')+date('Ymd'));

if (isset($_POST['vscontok']) && ($_POST['vscontok'] == $vscontok_key))
{
	$echec = false;
	/*
    if(isset($_POST['g-recaptcha-response'])){
        $captcha=$_POST['g-recaptcha-response'];
        $echec = false;
    }
    else {
        $captcha = false;
    }

    if(!$echec)
    {
        $secret = '6LdNXwgcAAAAABGriq9zC7K75Uz8vcqt7wj-vk2p';
        $response=file_get_contents("https://www.google.com/recaptcha/api/siteverify?secret=".$secret."&response=".$captcha."&remoteip=".$_SERVER['REMOTE_ADDR']);

        // use json_decode to extract json response
        if($response.success==false)
        {
            //Do something with error
            $captcha = false;
            $echec = false;
        }
    }
*/
    if ($echec
        ||
        !isset($_POST['contactnobot'])
        ||
        (isset($_POST['contact_company']) && trim($_POST['contact_company'])=="google")
        )
    {
        $msg_output .= "Ne seriez-vous pas un robot ?<br/>Si ce n'est pas le cas, veuillez, s'il vous plaît, soumettre ce formulaire à nouveau.";
        $msg_type = 'WARNING';
        $echec = true;
        $msg_bg_color = "#d40000";
    }
}

if (1)
{
	if ( !$echec && (isset($_POST['vscontok'])) && ($_POST['vscontok'] == $vscontok_key) ) {

		$current_datetime = date("Y-m-d H:i:s");
		$db_conn = dbConnect();

		if (
			isset($_POST['contact_lastname']) && (trim($_POST['contact_lastname'])!="")
			&&
			isset($_POST['contact_firstname']) && (trim($_POST['contact_firstname'])!="")
			&&
			isset($_POST['contact_email']) && (trim($_POST['contact_email'])!="")
			&&
			isset($_POST['contact_company']) && (trim($_POST['contact_company'])!="")
			&&
			validateEmail(trim($_POST['contact_email']),0)
		    &&
		    (
		        ($_POST['contact_object']=='NEWS' && (isset($_POST['contact_newsletter'])&&($_POST['contact_newsletter']=='Y')?'Y':'N') == 'Y')
		        || $_POST['contact_object']!='NEWS'
		    )
// 			&&
// 			isset($_POST['contact_message']) && ($_POST['contact_message']!="")
		)
		{

			$echec = false;

			// On l'insère en base de données pour le suivi

			$kweery = "INSERT INTO contact
								(contact_date, object,
									lastname, firstname,
									company, job,
									email,phone,
									staff,
									message, newsletter_subscriber,
									message_sent,
									ip_address,
									host_name,
					                from_adwords,
					                from_social_network, utm_source, utm_medium, utm_campaign)
								values
								(:contact_date, :object,
									:lastname, :firstname,
									:company, :job,
									:email,:phone,
									:staff,
									:message, :newsletter_subscriber,
									:message_sent,
									:ip_address,
									:host_name,
					                :from_adwords,
					                :from_social_network, :utm_source, :utm_medium, :utm_campaign)";

			$db_query_params = ['contact_date' => $current_datetime,
								'object' => $_POST['contact_object'],
								'lastname' => trim($_POST['contact_lastname']),
								'firstname' => trim($_POST['contact_firstname']),
								'company' => trim($_POST['contact_company']),
								'job' => trim($_POST['contact_job']),
								'email' => trim($_POST['contact_email']),
								'phone' => trim($_POST['contact_phone']),
								'staff' => '',
								'message' => trim($_POST['contact_message']),
								'newsletter_subscriber' => (isset($_POST['contact_newsletter'])&&($_POST['contact_newsletter']=='Y')?'Y':'N'),
								'message_sent' => '?',
								'ip_address' => $_SERVER['REMOTE_ADDR'],
								'host_name' => substr(gethostbyaddr($_SERVER['REMOTE_ADDR']),0,255),
				                'from_adwords' => (isset($_SESSION['from_adwords'])?$_SESSION['from_adwords']:''),
				                'from_social_network' => (isset($_SESSION['social_network_id']) && $_SESSION['social_network_id']!='NONE'?$_SESSION['social_network_id']:''),
								'utm_source' => (isset($_SESSION['utm_source'])?$_SESSION['utm_source']:''),
								'utm_medium' => (isset($_SESSION['utm_medium'])?$_SESSION['utm_medium']:''),
								'utm_campaign' => (isset($_SESSION['utm_campaign'])?$_SESSION['utm_campaign']:'')];

			dbQuery($kweery,$db_query_params);

			$valid_form = true;


			// --------------------------------
			// MailJet
			$mj_status = '';
			$mj_status_prospects = '';
			$email_to_mailjet = trim($_POST['contact_email']);

			if (
					isset($_POST['contact_newsletter'])
					&& ($_POST['contact_newsletter']=='Y')
					&& $email_to_mailjet!=''
					&& validateEmail($email_to_mailjet,0)
				)
			{
				$mj = new VsMailjet();

				if ($mj!=null)
				{
    				$list_ids = $mj->getEmailSubContactLists($email_to_mailjet);

    				// liste prospects VS Ok Rgpd = 2029587
    				if (in_array(2029587,$list_ids)) $mj_status = "Déjà inscrit (on réactive si nécessaire)";
    				$mj_response = $mj->manageContact(2029587,$email_to_mailjet);
    				if ($mj_status=='')
    				{
    					if ($mj_response) $mj_status = "OK, ajouté";
    					else $mj_status = "Erreur";
    				}

    				// prospects VSE
    				if (in_array(2430100,$list_ids)) $mj_status_prospects = "Déjà inscrit (on réactive si nécessaire)";
    				$mj_response = $mj->manageContact(2430100,$email_to_mailjet);
    				if ($mj_status_prospects=='')
    				{
    					if ($mj_response) $mj_status_prospects = "OK, ajouté";
    					else $mj_status_prospects = "Erreur";
    				}
				}
			}


			// ---------------------------------

			//
			error_reporting(E_ALL ^ E_NOTICE ^ E_WARNING);

			$mail = new SystemMail();
			$mail->addTo($to_email);
			$mail->setSubject("VSExperience.com > CONTACT > ".html_entity_decode($_POST['contact_object']) );

			// Message
			$message = "Un message a &eacute;t&eacute; envoy&eacute; via le site vsexperience.com.";

			$message .= "<br/><br/>Nom : ".$_POST['contact_lastname'];
			$message .= "<br/>Pr&eacute;nom : ".$_POST['contact_firstname'];
			$message .= "<br/>Soci&eacute;t&eacute; : ". $_POST['contact_company'];
		    if (isset($_POST['contact_company']) && ($_POST['contact_company']!=''))
		    {
				$message .= "<br/><a href=\"http://www.societe.com/cgi-bin/mainsrch?champ=".str_replace("'","%27",str_replace(' ','+',$_POST['contact_company']))."\">Lien vers la fiche sur societe.com</a>";
		    }

			$message .= "<br/>Fonction : ". $_POST['contact_job'];
			$message .= "<br/>E-mail : ". $_POST['contact_email'];
			$message .= "<br/>T&eacute;l&eacute;phone : ". $_POST['contact_phone'];
			$message .= "<br/>Message :<br/>";
			$message .= nl2br($_POST['contact_message']);
			$message .= "<br/>".(isset($_POST['contact_newsletter'])&&($_POST['contact_newsletter']=='Y')?'[X]':'[_]');
			$message .= " "._("Recevoir des informations sur VSE ?");
			$message .= "<br/>";
			$message .= "<br/>Adresse IP : ". $_SERVER['REMOTE_ADDR'];
			$message .= "<br/>Nom de l'hôte : ". gethostbyaddr($_SERVER['REMOTE_ADDR']);

		    if (isset($_SESSION['from_adwords']) && ($_SESSION['from_adwords']!='') )
		    {
		      $message .= "<br/>";
		      $message .= "<br/>VIENT DES ADWORDS avec la valeur de cl&eacute; gclid : ". $_SESSION['from_adwords'];
		    }

		    if (isset($_SESSION['social_network_id']) && ($_SESSION['social_network_id']!='NONE') )
		    {
		    	$message .= "<br/>";
		    	$message .= "<br/>VIENT D'UN RESEAU SOCIAL : ". $_SESSION['social_network_id'];
		    }


		    // Mailjet
		    if (
		    		isset($_POST['contact_newsletter'])
		    		&& ($_POST['contact_newsletter']=='Y')
		    		&& $email_to_mailjet!=''
					&& validateEmail($email_to_mailjet,0)
		    		)
		    {
			    $message .= "<br/>";
				$message .= "<br/>Ajout dans MailJet (liste globale VS) : ". $mj_status;
				$message .= "<br/>Ajout dans MailJet (liste Prospects VSE) : ". $mj_status_prospects;
		    }

		    $mail->setBody($message);

		    // Envoi
		    try
		    {
				if (!isset($emailing_active)
	    					|| (isset($emailing_active) && $emailing_active)
	    			)
		    	{
		    		$mail_is_sent = $mail->send();
		    	}
		    	else
		    	{
		    		$mail_is_sent = false;
		    	}
		    }
		    catch(Exception $e)
		    {
		    	$mail_is_sent = false;
		    }

			// DEBUG
			//$mail_is_sent = true;

		    $msg_bg_color = '#00830a';

		    $msg_output = "Votre message a été transmis.";
			$msg_output .= " Nous vous répondrons dans les plus brefs délais.";

			$msg_type = 'VALIDATION';

			if ($mail_is_sent) {
				$contact_mail_sent = 'Y';
			} else {
				$contact_mail_sent = 'N';
			}


?>
	<script async src="https://www.googletagmanager.com/gtag/js?id=G-Z2ZTSJ5JCZ"></script>
	<script>
	  window.dataLayer = window.dataLayer || [];
	  function gtag(){dataLayer.push(arguments);}
	  gtag('js', new Date());
	  gtag('config', 'AW-1007380201');
	  gtag('event', 'conversion', {'send_to': 'AW-1007380201/zQixCLyupYsYEOnNreAD'});
	</script>
<?php


			// On met à jour 1 flag pour l'envoi d'e-mail

			$kweery = "UPDATE contact
								SET message_sent = :message_sent
								WHERE contact_date = :contact_date
										AND lastname = :lastname
										AND firstname = :firstname
										AND ip_address = :ip_address ";

			$db_query_params = ['message_sent' => $contact_mail_sent,
								'contact_date' => $current_datetime,
								'lastname' => trim($_POST['contact_lastname']),
								'firstname' => trim($_POST['contact_firstname']),
								'ip_address' => $_SERVER['REMOTE_ADDR'] ];


			dbQuery($kweery,$db_query_params);


			// --------------------------------------------------------------
			// -- Accusé de réception pour le demandeur
			error_reporting(E_ALL ^ E_NOTICE ^ E_WARNING);
			if (isset($mail)) unset($mail);
			$mail = new SystemMail();
			$mail->addTo(trim($_POST['contact_email']));
			$mail->setSubject("VSExperience.com > CONTACT > Accusé de réception de votre message");

			// Msg
			$message = "Bonjour ".$_POST['contact_firstname']." ".$_POST['contact_lastname'].",";
			$message .= "<br/>Votre message a bien &eacute;t&eacute; transmis.";
			$message .= "<br/>Nos &eacute;quipes vont en prendre connaissance dans les plus brefs d&eacute;lais et nous vous répondrons.";

			if (
					isset($_POST['contact_newsletter'])
					&& ($_POST['contact_newsletter']=='Y')
					&& trim($_POST['contact_email'])!=''
					)
			{
				$message .= "<br/><br/>Si vous n'êtes pas à l'origine de cette demande, veuillez nous le signaler en écrivant à : ". $WEBSITE_email .".";
			}

			$message .= "<br/><br/>Cordialement.";



			$message = '<table style="margin:auto;max-width:700px;"><tr><td>'
					.'<p style="font-family: Verdana, Helvetica, sans-serif; font-size: 20px;">
						Bonjour '. $_POST['contact_firstname']." ".$_POST['contact_lastname'] .'
						<br/>et merci de nous avoir contactés.</p>'
					.'</td><td style="margin:0;padding:0;text-align:right;"><img alt="VSE, SIRH orienté Expérience Collaborateur" title="VSE, SIRH orienté Expérience Collaborateur" src="https://vsexperience.com/images/vse_top_right_corner.png"/></td></tr>'
					.'<tr><td colspan="2">

					<p style="font-family: Helvetica, Verdana, sans-serif; font-size: 16px;">
					Votre message a bien &eacute;t&eacute; transmis.
					<br/><br/>Nos &eacute;quipes vont en prendre connaissance dans les plus brefs d&eacute;lais et nous vous répondrons.';


			if (
					isset($_POST['contact_newsletter'])
					&& ($_POST['contact_newsletter']=='Y')
					&& trim($_POST['contact_email'])!=''
					)
			{
				$message .= "<br/><br/>Si vous n'êtes pas à l'origine de ce message, veuillez nous le signaler en écrivant à : ". $WEBSITE_email .".";
			}

			$message .= '<br/><br/>Cordialement.</p>'

				.'</td></tr>
				<tr><td colspan="2" style="margin:0;padding:0;"><img width="700px"  alt="Surfez dans l\'application." title="" src="https://vsexperience.com/images/vse_bottom_waves.png"/></td></tr></table>';

			$message .= '<br/><i style="font-size:80%">Vous recevez cet e-mail car vous avez utilisé notre formulaire de contact pour nous faire passer un message. Pour désinscrire votre adresse e-mail, cliquez&nbsp;: <a target="_blank" href="https://vsexperience.com/?unsub&emid='.rand(10000, 29999).'">se désinscrire</a>.</i>';



			$mail->setBody($message);
			// Envoi
			try
			{
				if (!isset($emailing_active)
	    					|| (isset($emailing_active) && $emailing_active)
	    			)
		    	{
		    		$mail_is_sent = $mail->send();
		    	}
		    	else
		    	{
		    		$mail_is_sent = false;
		    	}
			}
			catch(Exception $e)
			{
				$mail_is_sent = false;
			}

			// --------------------------------------------------------------


			// -- ON CREE L'entrée dans vs.vsactivity.com
			try
			{
				$vs_new_contact_params = array();
				$vs_new_contact_params['email'] = trim($_POST['contact_email']);
				$vs_new_contact_params['lastname'] = trim($_POST['contact_lastname']);
				$vs_new_contact_params['firstname'] = trim($_POST['contact_firstname']);
				$vs_new_contact_params['company'] = trim($_POST['contact_company']);
				$vs_new_contact_params['job'] = trim($_POST['contact_job']);
				$vs_new_contact_params['description'] = "";
				$vs_new_contact_params['phone'] = trim($_POST['contact_phone']);
				$vs_new_contact_params['contact_subject'] = $_POST['contact_object'];
				$vs_new_contact_params['contact_message'] = base64_encode($_POST['contact_message']);

				$vs_new_contact_params['product'] = 'vsexperience';

				// Include SystemApi
				include_once($root_path.'inc/vsvse/SystemApi.class.php');

				SystemApi::doRequest("https://vs.vsactivity.com", "TrialManagement", "newContactRequest", $vs_new_contact_params);

				if (
						isset($_POST['contact_newsletter'])
						&& ($_POST['contact_newsletter']=='Y')
						&& trim($_POST['contact_email'])!=''
						)
				{
					// -- On flague dans notre VSE : vs.vsactivity.com => ajout d'un compétence : consentement avec la date du consentement dans la description
					$vs_new_consentement_params = array();
					$vs_new_consentement_params['email'] = trim($_POST['contact_email']);
					// Include SystemApi
					include_once($root_path.'inc/vsvse/SystemApi.class.php');
					SystemApi::doRequest("https://vs.vsactivity.com", "TrialManagement", "newConsentementRequest", $vs_new_consentement_params);
				}

			}
			catch (Exception $e)
			{
				// nothing mais pas de crash !
				//echo "DEBUG :: ".$e->getMesssage();
			}


			// ---------------------------------


			// clean data
			$_POST['contact_object']='';
			$_POST['contact_lastname']='';
			$_POST['contact_firstname']='';
			$_POST['contact_company']='';
			$_POST['contact_job']='';
			$_POST['contact_email']='';
			$_POST['contact_phone']='';
			$_POST['contact_message']='';
			$_POST['contact_newsletter']='N';

		} else {

			$echec = true;
			$msg_bg_color = "#d40000";

			// On l'insère en base de données pour le suivi

			$kweery = "INSERT INTO contact
								(contact_date, object,
									lastname, firstname,
									company, job,
									email,phone,
									staff,
									message, newsletter_subscriber,
									message_sent,
									ip_address,
									host_name,
					                from_adwords,
					                from_social_network, utm_source, utm_medium, utm_campaign)
								values
								(:contact_date, :object,
									:lastname, :firstname,
									:company, :job,
									:email,:phone,
									:staff,
									:message, :newsletter_subscriber,
									:message_sent,
									:ip_address,
									:host_name,
					                :from_adwords,
					                :from_social_network, :utm_source, :utm_medium, :utm_campaign)";

			$db_query_params = ['contact_date' => $current_datetime,
								'object' => "Erreur de saisie - " . $_POST['contact_object'],
								'lastname' => trim($_POST['contact_lastname']),
								'firstname' => trim($_POST['contact_firstname']),
								'company' => trim($_POST['contact_company']),
								'job' => trim($_POST['contact_job']),
								'email' => trim($_POST['contact_email']),
								'phone' => trim($_POST['contact_phone']),
								'staff' => '',
								'message' => trim($_POST['contact_message']),
								'newsletter_subscriber' => (isset($_POST['contact_newsletter'])&&($_POST['contact_newsletter']=='Y')?'Y':'N'),
								'message_sent' => '?',
								'ip_address' => $_SERVER['REMOTE_ADDR'],
								'host_name' => substr(gethostbyaddr($_SERVER['REMOTE_ADDR']),0,255),
				                'from_adwords' => (isset($_SESSION['from_adwords'])?$_SESSION['from_adwords']:''),
				                'from_social_network' => (isset($_SESSION['social_network_id']) && $_SESSION['social_network_id']!='NONE'?$_SESSION['social_network_id']:''),
								'utm_source' => (isset($_SESSION['utm_source'])?$_SESSION['utm_source']:''),
								'utm_medium' => (isset($_SESSION['utm_medium'])?$_SESSION['utm_medium']:''),
								'utm_campaign' => (isset($_SESSION['utm_campaign'])?$_SESSION['utm_campaign']:'')];


			dbQuery($kweery,$db_query_params);


			// --------------------------------
			// MailJet
			$mj_status = '';
			$mj_status_prospects = '';
			$email_to_mailjet = trim($_POST['contact_email']);
			if (
					isset($_POST['contact_newsletter'])
					&& ($_POST['contact_newsletter']=='Y')
					&& $email_to_mailjet!=''
					&& validateEmail($email_to_mailjet,0)
				)
			{
				$mj = new VsMailjet();

				if ($mj!=null)
				{
    				$list_ids = $mj->getEmailSubContactLists($email_to_mailjet);

    				// liste prospects VS Ok Rgpd = 2029587
    				if (in_array(2029587,$list_ids)) $mj_status = "Déjà inscrit (on réactive si nécessaire)";
    				$mj_response = $mj->manageContact(2029587,$email_to_mailjet);
    				if ($mj_status=='')
    				{
    					if ($mj_response) $mj_status = "OK, ajouté";
    					else $mj_status = "Erreur";
    				}

    				// prospects VSE
    				if (in_array(2430100,$list_ids)) $mj_status_prospects = "Déjà inscrit (on réactive si nécessaire)";
    				$mj_response = $mj->manageContact(2430100,$email_to_mailjet);
    				if ($mj_status_prospects=='')
    				{
    					if ($mj_response) $mj_status_prospects = "OK, ajouté";
    					else $mj_status_prospects = "Erreur";
    				}
				}
			}

			// ---------------------------------

			if ($_POST['contact_object']=='NEWS' && (isset($_POST['contact_newsletter'])&&($_POST['contact_newsletter']=='Y')?'Y':'N') == 'N')
			{
			    $msg_output = "Comme vous voulez vous abonner à notre newsletter, veuillez, s'il vous plaît, cochez la case correspondante dans le formulaire.";
			}
			else
			{
			     $msg_output = "Veuillez, s'il vous plaît, renseigner les champs obligatoires et/ou vérifier l'adresse e-mail.";
			}


			$msg_type = 'WARNING';


			error_reporting(E_ALL ^ E_NOTICE ^ E_WARNING);

			// Pour éviter les emails avec zéro info = robots !
			if (trim($_POST['contact_lastname'])!=''
                && trim($_POST['contact_firstname'])!=''
                && trim($_POST['contact_company'])!=''
                && trim($_POST['contact_email'])!=''
                && validateEmail(trim($_POST['contact_email']),0)
					&& isset($_POST['contactnobot'])
					&& trim($_POST['contact_company'])!='google'
				)
			{
				$mail = new SystemMail();
				$mail->addTo($to_email);
				$mail->setSubject("VSExperience.com > CONTACT > ERREUR DE SAISIE - ".html_entity_decode($_POST['contact_object']) );

				// Message
				$message = "Cet e-mail permet de suivre une tentative de contact depuis le site vsexperience.com.";
				$message = "<br/>Des informations sont en erreur (champs obligatoires vides ou e-mail non valide).";

				$message .= "<br/><br/>Nom : ".$_POST['contact_lastname'];
				$message .= "<br/>Pr&eacute;nom : ".$_POST['contact_firstname'];
				$message .= "<br/>Soci&eacute;t&eacute; : ". $_POST['contact_company'];

			    if (isset($_POST['contact_company']) && ($_POST['contact_company']!=''))
			    {
			      $message .= "<br/><a href=\"http://www.societe.com/cgi-bin/mainsrch?champ=".str_replace("'","%27",str_replace(' ','+',$_POST['contact_company']))."\">Lien vers la fiche sur societe.com</a>";
			    }

				$message .= "<br/>Fonction : ". $_POST['contact_job'];
				$message .= "<br/>E-mail : ". $_POST['contact_email'];
				$message .= "<br/>T&eacute;l&eacute;phone : ". $_POST['contact_phone'];
				$message .= "<br/>Message :<br/>";
				$message .= nl2br($_POST['contact_message']);
				$message .= "<br/>".(isset($_POST['contact_newsletter'])&&($_POST['contact_newsletter']=='Y')?'[X]':'[_]');
				$message .= " "._("Recevoir des informations sur VSE ?");
				$message .= "<br/>";
				$message .= "<br/>Adresse IP : ". $_SERVER['REMOTE_ADDR'];
				$message .= "<br/>Nom de l'hôte : ". gethostbyaddr($_SERVER['REMOTE_ADDR']);

			    if (isset($_SESSION['from_adwords']) && ($_SESSION['from_adwords']!='') )
			    {
			      $message .= "<br/>";
			      $message .= "<br/>VIENT DES ADWORDS avec la valeur de cl&eacute; gclid : ". $_SESSION['from_adwords'];
			    }

			    if (isset($_SESSION['social_network_id']) && ($_SESSION['social_network_id']!='NONE') )
			    {
			    	$message .= "<br/>";
			    	$message .= "<br/>VIENT D'UN RESEAU SOCIAL : ". $_SESSION['social_network_id'];
			    }


			    // Mailjet
			    if (
			    		isset($_POST['contact_newsletter'])
			    		&& ($_POST['contact_newsletter']=='Y')
			    		&& $email_to_mailjet!=''
						&& validateEmail($email_to_mailjet,0)
			    		)
			    {
				    $message .= "<br/>";
					$message .= "<br/>Ajout dans MailJet (liste globale VS) : ". $mj_status;
					$message .= "<br/>Ajout dans MailJet (liste Prospects VSE) : ". $mj_status_prospects;
			    }

			    $mail->setBody($message);

			    // Envoi
			    try
			    {
					if (!isset($emailing_active)
		    					|| (isset($emailing_active) && $emailing_active)
		    			)
			    	{
			    		$mail_is_sent = $mail->send();
			    	}
			    	else
			    	{
			    		$mail_is_sent = false;
			    	}
			    }
			    catch(Exception $e)
			    {
			    	$mail_is_sent = false;
			    }

			    if ($mail_is_sent) {
			    	$contact_mail_sent = 'Y';
			    } else {
			    	$contact_mail_sent = 'N';
			    }


			    // On met à jour 1 flag pour l'envoi d'e-mail
// 			    $kweery = "UPDATE contact
// 		    						SET message_sent = '".$contact_mail_sent."'
// 		    						WHERE contact_date = '".$current_datetime."'
// 			    						AND ip_address = '".$_SERVER['REMOTE_ADDR']."' ";

				$kweery = "UPDATE contact
									SET message_sent = :message_sent
									WHERE contact_date = :contact_date
											AND ip_address = :ip_address ";

				$db_query_params = ['message_sent' => $contact_mail_sent,
									'contact_date' => $current_datetime,
									'ip_address' => $_SERVER['REMOTE_ADDR'] ];

				dbQuery($kweery,$db_query_params);
			}


			// -- affichage
			if (!isset($_POST['contact_lastname']) || (trim($_POST['contact_lastname'])=="") )
			{
				$lname_in_error = 'error';
			}

			if (!isset($_POST['contact_firstname']) || (trim($_POST['contact_firstname'])=="") )
			{
				$fname_in_error = 'error';
			}

			if (!isset($_POST['contact_company']) || (trim($_POST['contact_company'])=="") )
			{
				$company_in_error = 'error';
			}

// 			if (!isset($_POST['contact_message']) || (trim($_POST['contact_message'])=="") )
// 			{
// 				$msg_in_error = 'error';
// 			}

			if (!isset($_POST['contact_email']) || (trim($_POST['contact_email'])=="")
			||
			!validateEmail(trim($_POST['contact_email']),0))
			{
				$email_in_error = 'error';
			}


		}


		dbDisconnect($db_conn);


	} else {
		$msg_output = "Veuillez, s'il vous plaît, compléter et soumettre le formulaire ci-dessous.";
		$msg_type = 'INFO';
	}

}

?>

<div class="divhorizontalforcols" style="margin-top:0;width:100%;background:#f4f4f4;padding-top:20px;padding-bottom:0px;">
	<div  class="divhorizontalforcols-icon" style="width:60px;padding-top:10px">
		<i class="fal fa-phone fa-2x"  style="color:#787878;"></i>
	</div>
	<div  class="divhorizontalforcols-text">
		<h2>
				<b style='color:#ff5303;font-size:140%;'>01 84 16 44 73</b>
				<br/>&nbsp;
		</h2>
	</div>
</div>

<?php if (isset($WEBSITE_linkedin_product_page) && $WEBSITE_linkedin_product_page!='') { ?>

<div class="divhorizontalforcols" style="margin-top:0;width:100%;background:#f4f4f4;padding-top:0px;padding-bottom:0px;">
	<div  class="divhorizontalforcols-icon" style="width:60px;padding-top:10px">
		<i class="fal fa-chart-network fa-2x"  style="color:#787878;"></i>
	</div>
	<div  class="divhorizontalforcols-text">
		<h2 style="line-height: 28px;">
			Vous souhaitez nous suivre sur les réseaux sociaux&nbsp;?
				<br/>
				<a style="text-decoration:none;font-size:120%;" href="<?= $WEBSITE_linkedin_product_page ?>" target="_blank"><i class="fab fa-linkedin fa-1x" title="Nous suivre sur LinkedIn"></i> LinkedIn</a>
				<?php /*&nbsp;
				<a style="text-decoration:none" href="https://twitter.com/VSExperience/" target="_blank"><i class="fab fa-twitter-square fa-1x" title="Nous suivre sur Twitter"></i> Twitter</a>
			     */ ?>
		</h2>
	</div>
</div>
<?php } ?>

<div class="divhorizontalforcols" style="margin-top:0;width:100%;background:#f4f4f4;padding-top:0px;padding-bottom:20px;">
	<div  class="divhorizontalforcols-icon" style="width:60px;padding-top:10px">
		<i class="fal fa-newspaper fa-2x"  style="color:#787878;"></i>
	</div>
	<div  class="divhorizontalforcols-text">
		<h2>Vous souhaitez recevoir notre actualité&nbsp;?
			<br/>Incrivez-vous à notre <a style="text-decoration:none;font-size:120%;" href="index.php?newsletter=ok#contact-form">newsletter</a>.
		</h2>
	</div>
</div>

<div class="divhorizontalforcols" style="margin:auto;max-width:900px;border-bottom-left-radius: 20px;border-bottom-right-radius: 20px;margin-top:0;background:<?= (isset($msg_bg_color)?$msg_bg_color:"#787878") ?>;padding-top:5px;padding-bottom:5px;">

	<div  class="divhorizontalforcols-icon" style="width:100px;padding-top:10px">
		<i class="fad fa-paper-plane  fa-3x"  style="color:#ffffff;"></i>
	</div>

	<div class="divhorizontalforcols-text">
		<h2 style="color:#ffffff;">
			<?php
			if ($msg_type=='INFO')
			{
			    echo "Vous recherchez plus d'informations ou vous voulez nous faire part de votre projet, par exemple ?";
			    echo "<br/>";
			}
			?>
			<?= displayMessage('',$msg_output) ?>
		</h2>
	</div>

</div>






<div style="position:absolute;margin-top:-165px;"><section id="contact-form"></section></div>

<form name="vs_contact" method="post">

<div class="divhorizontalforcols divaligncenter"  style="padding-top:20px;padding-bottom:30px;">

	<div class="divhorizontalforcols-2cols divalignleftforform" style="max-width: 620px;margin-bottom:0;padding: 2px 10px;">

		<br/>Sujet de votre demande
		<br/><select tabindex=0 name="contact_object" class="inputreq" style="width:590px;padding: 6px 2px 6px 0px;">
			<option value="QUESTION" <?= ( ( (isset($_POST['contact_object'])&&($_POST['contact_object']=='QUESTION')) || (isset($init_contact_object)&&($init_contact_object=='QUESTION')) ) ?' selected ':'') ?>>Question d'ordre général</option>
			<option value="NEWS" <?= ( ( (isset($_POST['contact_object'])&&($_POST['contact_object']=='NEWS')) || (isset($init_contact_object)&&($init_contact_object=='NEWS')) ) ?' selected ':'') ?>>S'abonner à notre newsletter</option>
			<option value="CALL-ME" <?= ( ( (isset($_POST['contact_object'])&&($_POST['contact_object']=='CALL-ME')) || (isset($init_contact_object)&&($init_contact_object=='CALL-ME')) ) ?' selected ':'') ?>>Projet, info : rappelez-moi !</option>
			<option value="SERVICES" <?= ( ( (isset($_POST['contact_object'])&&($_POST['contact_object']=='SERVICES')) || (isset($init_contact_object)&&($init_contact_object=='SERVICES')) ) ?' selected ':'') ?>>Services et assistance</option>
			<option value="SALES" <?= ( ( (isset($_POST['contact_object'])&&($_POST['contact_object']=='SALES')) || (isset($init_contact_object)&&($init_contact_object=='SALES')) ) ?' selected ':'') ?>>Commercial</option>
			<option value="PARTNERS" <?= ( ( (isset($_POST['contact_object'])&&($_POST['contact_object']=='PARTNERS')) || (isset($init_contact_object)&&($init_contact_object=='PARTNERS')) ) ?' selected ':'') ?>>Partenariat</option>
			<option value="JOB" <?= ( ( (isset($_POST['contact_object'])&&($_POST['contact_object']=='JOB')) || (isset($init_contact_object)&&($init_contact_object=='JOB')) ) ?' selected ':'') ?>>Recrutement & carrière</option>
			<option value="PRESS" <?= ( ( (isset($_POST['contact_object'])&&($_POST['contact_object']=='PRESS')) || (isset($init_contact_object)&&($init_contact_object=='PRESS')) ) ?' selected ':'') ?>>Presse & communication</option>
			<option value="INVESTMENT" <?= ( ( (isset($_POST['contact_object'])&&($_POST['contact_object']=='INVESTMENT')) || (isset($init_contact_object)&&($init_contact_object=='INVESTMENT')) ) ?' selected ':'') ?>>Investisseurs</option>
		</select>


		<br/><input placeholder="Nom" tabindex=1 type="text" size="72" name="contact_lastname" value="<?= (isset($_POST['contact_lastname'])?$_POST['contact_lastname']:'') ?>"
				class="inputreq<?= $lname_in_error ?>">

		<br/><input placeholder="Prénom" tabindex=2 type="text" size="72" name="contact_firstname" value="<?= (isset($_POST['contact_firstname'])?$_POST['contact_firstname']:'') ?>"
				class="inputreq<?= $fname_in_error ?>">


		<br/><input placeholder="Société" tabindex=3 type="text" size="72" name="contact_company" value="<?= (isset($_POST['contact_company'])?$_POST['contact_company']:'') ?>"
				class="inputreq<?= $company_in_error ?>">

		<br/><input placeholder="Fonction" tabindex=4 type="text" size="72" name="contact_job" value="<?= (isset($_POST['contact_job'])?$_POST['contact_job']:'') ?>"
				class="inputstd">

		<br/><input placeholder="E-mail professionnel" tabindex=5 type="text" size="72" name="contact_email" value="<?= (isset($_POST['contact_email'])?$_POST['contact_email']:'') ?>"
				class="inputreq<?= $email_in_error ?>">

		<br/><input placeholder="Téléphone" tabindex=6 type="text" size="72" name="contact_phone" value="<?= (isset($_POST['contact_phone'])?$_POST['contact_phone']:'') ?>"
				class="inputstd">

		<br/><textarea placeholder="Votre demande...." tabindex=8 cols="70" rows="4" name="contact_message"
			class="inputstd" style="font-family: 'Lato', Calibri, Arial, sans-serif;"><?= (isset($init_contact_message)?$init_contact_message:'') ?><?= (isset($_POST['contact_message'])?$_POST['contact_message']:'') ?></textarea>

		<br/>
		<input tabindex=9 type="checkbox" id="contact_newsletter" name="contact_newsletter" value="Y" <?= ((isset($_POST['contact_newsletter'])&&($_POST['contact_newsletter']=='Y') )?' checked ':'') ?>>
		<label for="contact_newsletter"><?= $WEBSITE_newsletter_disclamer ?></label>

		<br/>
		<br/>
<?php /*
<input type="hidden" id="g-recaptcha-response" name="g-recaptcha-response">
<input type="hidden" name="action" value="validate_captcha">
*/?>
<div id="form_demo_starting"></div>

		<br/>
		<input tabindex=12 type="submit" class="submitbuttonbig vsbuttondisabled"
				id="vs_contact_submitbutton"
				title="<?= $WEBSITE_not_robot_to_validate ?>"
				value="Envoyer le message">

		<br/><br/>
    	<i style="color:#999;font-size:11px;">
    		Vos droits sur vos informations&nbsp;: <a style="color:#333;" href="<?= $web_path ?>politique-de-confidentialite/" target="_blank">politique de confidentialité</a>.
    	</i>
	</div>


	<input type="hidden" name="vscontok" value="<?= $vscontok_key ?>">

<?php /*
	<div class="g-recaptcha" data-sitekey="6LdNXwgcAAAAAKM-_yFPlP2TCcjKDRt8jFXJdEOP"></div>
*/ ?>

<?php /*
  		<script src="https://www.google.com/recaptcha/api.js?render=6LdNXwgcAAAAAKM-_yFPlP2TCcjKDRt8jFXJdEOP"></script>

        <script>
            grecaptcha.ready(function() {
            // do request for recaptcha token
            // response is promise with passed token
                grecaptcha.execute('6LdNXwgcAAAAAKM-_yFPlP2TCcjKDRt8jFXJdEOP', {action:'validate_captcha'})
                          .then(function(token) {
                    // add token value to form
                    document.getElementById('g-recaptcha-response').value = token;
                });
            });
		</script>
*/ ?>
		<script>
        if ($('#form_demo_starting')!=null)
			$('#form_demo_starting').html('<input onclick="vsActiveSubmitbutton(this,\'vs_contact_submitbutton\');" title="<?= addslashes($WEBSITE_not_robot_to_validate) ?>" tabindex=10 type="checkbox" name="contactnobot" id="contactnobot_id" required="true"><label id="label_for_nobot_id" style="color:#ac3939" for="contactnobot_id"><b>Je ne suis pas un robot&nbsp;&nbsp;</b><i class="fad fa-robot"></i></label>');

         </script>



	</form>

</div>


<div class="divbgimg-contact-bottom">

	<div class="divhorizontalforcols-2cols divalignright" style="max-width:360px;color:#fff;">

		<img src="<?= $web_path ?>images/logoVS2019bnw.svg" style="height:175px" title="<?= $corporate_name ?>" alt="<?= $corporate_name ?>" />

		<br/>
		<?= $COMPANY_address_3lines ?>
		<br/><br/>
		Tél. <?= ($COMPANY_phone!=""?$COMPANY_phone:'') ?>

	</div>

	<div class="divhorizontalforcols-2cols divalignleft" id="vs_map_iframe_header">

		<iframe id="vs_map_iframe" src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d2628.5132047513953!2d2.1488677156523006!3d48.79118307928095!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x47e67c3ae5c8ba35%3A0xaf800eaab32e1e6f!2s143b+Rue+Yves+le+Coz%2C+78000+Versailles!5e0!3m2!1sfr!2sfr!4v1563782854866!5m2!1sfr!2sfr" width="400" height="300" frameborder="0" style="border:0" allowfullscreen></iframe>

	</div>
</div>



<?php
// ## FOOTER
require $root_path.'inc/footer.inc.php';
