<?

	include('config.php');
	include(PATH_ROOT.'ssi/EngineFwk/DB.php');

	$site_key   = '6LdYRt4UAAAAAKjggPW3lsqKL5hCo2K9RtFkajka';
	$secret_key = '6LdYRt4UAAAAADshO-an5fPFtbZzd8TkqlnwJEGn';

	if(!empty($_POST)) {
		$con = \EngineFwk\DB::getInstance();
		$con->open();

		$firstname = isset($_POST['firstname']) ? $_POST['firstname'] : '';
		$surname   = isset($_POST['surname'])   ? $_POST['surname']   : '';
		$email     = isset($_POST['email'])     ? $_POST['email']     : '';
		$phonenum  = isset($_POST['phonenum'])  ? $_POST['phonenum']  : '';
		$address   = isset($_POST['address'])   ? $_POST['address']   : '';
		$city      = isset($_POST['city'])      ? $_POST['city']      : '';
		$zipcode   = isset($_POST['zipcode'])   ? $_POST['zipcode']   : '';
		$idnumber  = isset($_POST['idnumber'])  ? $_POST['idnumber']  : '';
		$pharmacy  = isset($_POST['pharmacy'])  ? $_POST['pharmacy']  : '';
		$promocode = isset($_POST['promocode']) ? $_POST['promocode'] : '';
		$terms     = isset($_POST['terms'])     ? $_POST['terms']     : FALSE;
		$privacy   = isset($_POST['privacy'])   ? $_POST['privacy']   : FALSE;

		$promocode = $con->escape($promocode);
		$id_code   = $con->get_value("SELECT id_code FROM codes WHERE code='{$promocode}' AND assigned is null");

		$err = array();
		if(empty($firstname))     $err[] = 'Por favor, introduce tu nombre';
		if(empty($surname))       $err[] = 'Por favor, introduce tus apellidos';
		if(empty($email))         $err[] = 'Por favor, introduce tu correo electrónico';
		if(empty($phonenum))      $err[] = 'Por favor, introduce tu número de teléfono';
		if(empty($address))       $err[] = 'Por favor, introduce tu dirección postal';
		if(empty($city))          $err[] = 'Por favor, introduce tu ciudad';
		if(empty($zipcode))       $err[] = 'Por favor, introduce tu código postal';
		if(empty($idnumber))      $err[] = 'Por favor, introduce tu DNI';
		if(empty($promocode))     $err[] = 'Por favor, introduce tu código promocional';
		if($id_code===null)       $err[] = 'El código promocional es incorrecto o ha sido usado ya';
		if(!check_dni($idnumber)) $err[] = 'El DNI no es válido';
		if(empty($terms))         $err[] = 'Debes aceptar los términos y condiciones';
		if(empty($privacy))       $err[] = 'Debes aceptar la política de privacidad';

		if(empty($err)) {
			$safe_email    = $con->escape($email);
			$safe_phonenum = $con->escape($phonenum);
			$safe_idnumber = $con->escape($idnumber);
			$toomanytimes  = $con->get_value("SELECT count(*) FROM users WHERE email='$safe_email' OR phonenum='$safe_phonenum' OR idnumber='$safe_idnumber'");
			if(intval($toomanytimes)>2) $err[] = 'Sólo puedes participar 3 veces';
		}

		if(empty($err)) {
			$grcr = isset($_POST['kpxa']) ? $_POST['kpxa'] : '';
			if($ch = curl_init('https://www.google.com/recaptcha/api/siteverify')) {
				curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
				curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
				curl_setopt($ch, CURLOPT_POST, true);
				curl_setopt($ch, CURLOPT_POSTFIELDS, array(
					'secret'   => $secret_key,
					'response' => $grcr,
					'remoteip' => $_SERVER['REMOTE_ADDR'],
				));
				$rs = curl_exec($ch) or die(curl_error($ch));
				$in = curl_getinfo($ch);
				$rs = json_decode($rs);
				curl_close($ch);
				$kpxa = $rs->success;
			} else {
				$kpxa = false;
			}
			if($kpxa) {
				$data = [
					'firstname'   => $firstname,
					'surname'     => $surname,
					'email'       => $email,
					'phonenum'    => $phonenum,
					'address'     => $address,
					'city'        => $city,
					'zipcode'     => $zipcode,
					'idnumber'    => $idnumber,
					'pharmacy'    => $pharmacy,
					'promocode'   => $promocode,
					'inserted_ip' => $_SERVER['REMOTE_ADDR'],
				//	'lopd'        => $lopd,
				];
				$con->insert('users', $data);
				$id_user = $con->insert_id();
				/*
				$data = [
					'id_code'  => $id_code,
					'assigned' => $id_user,
				];
				$con->insert('codes', $data);
				*/
				$headers = implode(PHP_EOL, array(
					'Content-Type: text/html; charset=UTF-8',
					'BCC: albinworld@gmail.com,userim.info@gmail.com,uresimbolos@gmail.com',
				//	'From: '.SITE_NAME.' <'.MAIL_TO.'>',
				));
				$chk    = md5('CR3!'.$id_user.'!M1T4S');
				$url    = $_SERVER['REQUEST_SCHEME'].'://'.$_SERVER['HTTP_HOST'].'/paris/gracias.php?id='.$id_user.'&chk='.$chk;
				$mbody  = '';
			//	$mbody .= '<div style="margin-bottom: 30px; padding: 10px; text-align: center; background: #F0F0F0;"><img src="'.$logo[0].'" /></div>';
				$mbody .= '<div style="font-family: Arial; font-size: 14px;">';
				$mbody .= '<h2>Último paso:</h2><p>Para terminar el registro al concurso "Uresim Iluminador | Viaja a la ciudad de la luz" pulsa el siguiente enlace para validar tus datos: <a href="'.$url.'">'.$url.'</a>.</p><p>¡Mucha suerte!</p>';
				$mbody .= '</div>';
				if(!mail($email, 'Concurso Uresim: Confirma tu dirección de correo electrónico', $mbody, $headers)) {
					$err[] = 'Lo siento, no se pudo enviar el mensaje.';
				}
			} else {
				$err[] = 'Lo siento, no resolviste correctamente el reto del captcha.';
			}
		}
		if(!empty($err)) {
			http_response_code(500);
			die(implode(PHP_EOL, $err));
		} else {
			http_response_code(200);
			die('Ok');
		}
	}

	if(!empty($_GET['itsme'])) {
		$firstname = 'Mario';
		$surname   = 'Rocafull Cercós';
		$email     = 'albinworld@gmail.com';
		$phonenum  = '629373166';
		$address   = 'Fonteta 5-3';
		$city      = 'Vlc';
		$zipcode   = '46013';
		$idnumber  = '22568954C';
		$pharmacy  = 'Fons d´Ocón';
		$promocode = '';
	}
?>
<!DOCTYPE html>
<!--[if lt IE 7]><html class="no-js lt-ie10 lt-ie9 lt-ie8 lt-ie7"> <![endif]-->
<!--[if IE 7]><html class="no-js lt-ie10 lt-ie9 lt-ie8"> <![endif]-->
<!--[if IE 8]><html class="no-js lt-ie10 lt-ie9"> <![endif]-->
<!--[if IE 9]><html class="no-js lt-ie10"> <![endif]-->
<!--[if gt IE 8]><!-->
<html class="no-js">
<!--<![endif]-->

<head>

    <!-- Basic Page Needs -->
    <meta charset="utf-8">
    <title>Uresim Iluminador | Viaja a la ciudad de la luz</title>
    <meta name="description" content="">
    <meta name="author" content="">

    <!-- Mobile Specific Metas -->
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">

    <!-- Favicons -->
    <link rel="shortcut icon" href="content/app6/images/favicon.ico">

    <!-- FONTS -->
    <link href="https://fonts.googleapis.com/css?family=Raleway:300,400,500,600,700&display=swap" rel="stylesheet">

    <!-- CSS -->
    <link rel='stylesheet' href='css/global.css'>
    <link rel='stylesheet' href='content/app6/css/structure.css'>
    <link rel='stylesheet' href='content/app6/css/app6.css'>
    <link rel='stylesheet' href='content/app6/css/custom.css'>
    <style>
    .form {
    }
    .form.hidden {
        display: none;
    }
    .fback {
        display: none;
    }
    .fback.shown {
        display: block;
    }
    #features-1 .one-second.mcb-wrap {
        height: 150vh;
    }
		h4{
		font-size: 24px!important;
    line-height: 34px!important;
		}
		h3 {
    font-size: 30px!important;
    line-height: 40px!important;
}
		@media only screen and (max-width:480px){
			.minimovil{
			font-size:20px!important;
			line-height:24px!important;
				color:#9a7d49!important;
			}
		}
		@media only screen and (min-width:481px){
			.minimovil{
			font-size:26px!important;
			line-height:34px!important;
				color:#9a7d49!important;
			}
		}
    </style>
<!-- Global site tag (gtag.js) - Google Analytics -->
<script async src="https://www.googletagmanager.com/gtag/js?id=UA-118969506-1"></script>
<script>
  window.dataLayer = window.dataLayer || [];
  function gtag(){dataLayer.push(arguments);}
  gtag('js', new Date());

  gtag('config', 'UA-118969506-1');
</script>


</head>

<body class="home page-template-default page color-custom style-default button-round layout-full-width one-page no-content-padding header-transparent minimalist-header-no sticky-header sticky-tb-color ab-hide subheader-both-center menu-line-below-80-1 menuo-right menuo-no-borders logo-no-margin footer-copy-center mobile-tb-center mobile-side-slide mobile-mini-mr-lc tablet-sticky mobile-header-mini mobile-sticky">
    <div id="Wrapper">
        <div id="Header_wrapper">
            <header id="Header">
                <div id="Top_bar">
                    <div class="container">
                        <div class="column one">
                            <div class="top_bar_left clearfix">
                                <div class="logo">
                                    <a id="logo" href="/paris/" title="Uresim" data-height="60" data-padding="30"><img class="logo-main scale-with-grid" src="content/logo.png" data-retina="content/logo.png" data-height="55" alt="app6" ><img class="logo-sticky scale-with-grid" src="content/logo.png" data-retina="content/logo.png" data-height="55" alt="app6" ><img class="logo-mobile scale-with-grid" src="content/logo.png" data-retina="content/logo.png" data-height="55" alt="app6" ><img class="logo-mobile-sticky scale-with-grid" src="content/logo.png" data-retina="content/logo.png" data-height="55" alt="app6" ></a>
                                </div>


                            </div>
                            <div class="top_bar_right">
                                <div class="top_bar_right_wrapper">
                                    <a href="https://uresim.es" class="action_button" target="_blank">Uresim <i class="icon-right-open"></i></a>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </header>
        </div>
        <div id="Content">
            <div class="content_wrapper clearfix">
                <div class="sections_group">
                    <div class="entry-content">
                        <div class="section mcb-section mcb-section-yrpdlzqh2 full-width" style="padding-top:7%;background-image:url(content/compo_eiffel_def.jpg);background-repeat:no-repeat;background-position:center bottom">
                            <div class="section_wrapper mcb-section-inner">
                                <div class="wrap mcb-wrap one valign-top clearfix">
                                    <div class="mcb-wrap-inner">
                                        <div class="column mcb-column one column_column">
                                            <div class="column_attr clearfix align_center">
                                                <!--<img src="content/titulo.png" alt="Titulo">-->
                                                <span class="minimovil">Debido a la crisis sanitaria del Covid-19 nos vemos obligados a cancelar el sorteo del viaje a París. Entendemos que en este momento lo más responsable y seguro para todos es suspender esta promoción.</span> <h3><span style="color:#000;"><a href="https://uresim.es/paris/comunicado-cancelacion-sorteo.pdf" target="_blank">Para más información pulsa aquí</a></span></h3>
                                                <!--<hr class="no_line" style="margin:0 auto 10px">
                                                <h5 style="color: #fff;">Fusce ut velit laoreet tempus arcu eu molestie tortor</h5>-->
                                            </div>
                                        </div>
                                        <div class="column mcb-column one column_divider">
                                            <hr class="no_line" style="margin:0 auto 20px">
                                        </div>
                                        <!--<div class="column mcb-column one column_button">
                                            <div class="button_align align_center">
                                                <a class="button scroll button_left button_size_2 button_theme button_js" href="#features"><span class="button_icon"><i class="icon-check"></i></span><span class="button_label">Check our features</span></a>
                                            </div>
                                        </div>-->
                                        <div class="column mcb-column one column_divider">
                                            <hr class="no_line" style="margin:0 auto 10px">
                                        </div>
                                    </div>
                                </div>
                                <div class="wrap mcb-wrap one valign-top clearfix">
                                    <div class="mcb-wrap-inner">
                                        <div class="column mcb-column one column_image">
                                            <div class="animate" data-anim-type="fadeInUp">
                                                <div class="image_frame image_item no_link scale-with-grid aligncenter no_border">
                                                    <div class="image_wrapper"><img src="content/concentrado-iluminador.png" class="super-img">
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                       <div class="section mcb-section mcb-section-89z4mweox" id="features" style="padding-top:60px">
                            <div class="section_wrapper mcb-section-inner">
                                <div class="wrap mcb-wrap one valign-middle clearfix">
                                    <div class="mcb-wrap-inner">
                                        <!--<div class="column mcb-column one column_column">
                                            <div class="column_attr clearfix align_center">
                                                <h2>Main features</h2>
                                            </div>
                                        </div>-->
                                        <div class="column mcb-column one column_divider">
                                            <hr class="no_line" style="margin:0 auto 20px">
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        

                        <div class="section mcb-section mcb-section-9vf0c4ejs equal-height-wrap">
                            <div class="section_wrapper mcb-section-inner">
                                <div class="wrap mcb-wrap valign-middle clearfix">
                                    <div class="mcb-wrap-inner">
                                        <div class="column mcb-column one column_image">
                                            <div class="image_frame image_item no_link scale-with-grid no_border align_center">


                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>


                    </div>
                </div>
            </div>
        </div>
        <footer id="Footer" class="clearfix">
            <div class="footer_copy">
                <div class="container">
                    <div class="column one">
                        <div class="copyright">
                            &copy; 2020 Copyright <a target="_blank" rel="nofollow" href="https://uresim.es">Uresim</a>
                        </div>
                    </div>
                </div>
            </div>
        </footer>
    </div>
    <div id="Side_slide" class="right dark" data-width="250">
        <div class="close-wrapper">
            <a href="#" class="close"><i class="icon-cancel-fine"></i></a>
        </div>

        <div class="menu_wrapper"></div>
    </div>
    <div id="body_overlay"></div>


    <!-- JS -->
    <script src="js/jquery-2.1.4.min.js"></script>

    <script src="js/mfn.menu.js"></script>
    <script src="js/jquery.plugins.js"></script>
    <script src="js/jquery.jplayer.min.js"></script>
    <script src="js/animations/animations.js"></script>
    <script src="js/translate3d.js"></script>
    <script src="js/scripts.js"></script>

    <script src="form.js"></script>

    <script defer src="https://www.google.com/recaptcha/api.js?hl=es"></script>
</body>

</html>
<?

	function check_dni($dni) {
		$dni     = str_replace('-', '', strtoupper($dni));
		$letras  = 'TRWAGMYFPDXBNJZSQVHLCKE';
		$letra   = substr($dni, -1);
		$numeros = substr($dni, 0, -1);
		$numeros = str_replace(array('X', 'Y', 'Z'), array(0, 1, 2), $numeros);
		if($letras[$numeros%23]==$letra && strlen($numeros)==8) {
			return true;
		}
		return false;
	}

?>