<?php
include_once '../config/config_admin.php';

//If the form is submitted
if(isset($_POST['submit'])) {

	$msg = "Contacto.";

	//Check to make sure that the name field is not empty
	if(trim($_POST['registername']) == '') {
		$hasError = true;
	} else {
		$registername = trim($_POST['registername']);
	}

	//Check to make sure that the subject field is not empty
	if(trim($_POST['registercognoms']) == '') {
		$hasError = true;
	} else {
		$registercognoms = trim($_POST['registercognoms']);
	}

	//Check to make sure that the subject field is not empty
	if(trim($_POST['codi']) == '') {
		$hasError = true;
	} else {
		$codi = trim($_POST['codi']);
	}

	//Check to make sure that the subject field is not empty
	if(trim($_POST['clau']) == '') {
		$hasError = true;
	} else {
		$clau = trim($_POST['clau']);
	}

	//Check to make sure that the subject field is not empty
	if(trim($_POST['clau2']) == '') {
		$hasError = true;
	} else {
		$clau2 = trim($_POST['clau2']);
	}

	if ($clau <> $clau2){
		$msg = "La confirmació de la clau no correspon amb la clau";
		$hasError = true;
	}

	//Check to make sure sure that a valid email address is submitted
	if(trim($_POST['email']) == '')  {
		$hasError = true;
	} else if (!eregi("^[A-Z0-9._%-]+@[A-Z0-9._%-]+\.[A-Z]{2,4}$", trim($_POST['email']))) {
		$hasError = true;
	} else {
		$email = trim($_POST['email']);
	}

	if(trim($_POST['telf']) == '')  {
		$hasError = true;
	} else if (!eregi("^\(?[0-9]{3}\)?|[0-9]{3}[-. ]? [0-9]{3}[-. ]?[0-9]{4}$", trim($_POST['telf']))) {
		$hasError = true;
	} else {
		$telf = trim($_POST['telf']);
	}

	//Check to make sure sure that a register_residencia is submitted
	if(trim($_POST['register_residencia']) == '') {
		$hasError = true;
	} else {
		$radio_residencia = trim($_POST['register_residencia']);
	}

	//Check to make sure sure that a register_ocupacio is submitted
	if(trim($_POST['register_ocupacio']) == '') {
		$hasError = true;
	} else {
		if (trim($_POST['register_ocupacio']) == '99' && trim($_POST['registre_ocupacio_altres_text']) == ''){
			$hasError = true;
		}else{
			$register_ocupacio = trim($_POST['register_ocupacio']);
		}
	}

	//Check to make sure sure that a register_idioma is submitted
	if(trim($_POST['register_idioma']) == '') {
		$hasError = true;
	} else {
		$register_idioma = trim($_POST['register_idioma']);
	}

	//If there is no error, send the email
	if(!isset($hasError)) {
		//create de user in the DB
		//include con la información de conexión a la BD del Server
		@mysql_connect("localhost", $CONFIG['db_user'], $CONFIG['db_pass'])
			or die("No se ha podido conectar con el servidor BD");

		// include con la información de conexión a la BD de la WS
		@mysql_select_db($CONFIG['db_base'])
			or die("No se ha podido abrir la BD");

		$query = "SELECT codi FROM usuaris WHERE codi=\"$codi\"";
		$result = mysql_query($query);
		if (mysql_num_rows($result) <> 0){
			$msg = "Usuari ja existeix. Seleccioni un altre nom d'usuari.";
			$hasError = true;
		}else{
			$query = "SELECT email FROM usuaris WHERE email=\"$email\"";
			$result = mysql_query($query);
			if (mysql_num_rows($result) <> 0){
				$msg = "Ja existeix un usuari registrat amb aquesta adreça electrònica. Seleccioneu una altra adreça electrònica.";
				$hasError = true;
			}else{
				$query = "INSERT INTO usuaris SET codi=\"$codi\", clau=\"$clau\", email=\"$email\", telf=\"$telf\", nom=\"$registername $registercognoms\", perfil=\"$register_ocupacio\", residente=\"$radio_residencia\", lang=\"$register_idioma\"";
				$result = mysql_query($query);
				$id = mysql_insert_id();
				$msg = "Missatge enviat correctament!";
				$resp['msg'] = $msg;
			}
		}

		if(!isset($hasError)) {
			switch ($register_ocupacio) {
    			case 1:
    				$register_ocupacio = "Consumidor";
    				$txt_perfil = $register_ocupacio;
        			break;
    			case 2:
    				$register_ocupacio = "Botiguer";
    				$txt_perfil = $register_ocupacio;
       				break;
       			case 3:
       				$register_ocupacio = "Emprenedor";
       				$txt_perfil = $register_ocupacio;
       				break;
       			case 4:
       				$register_ocupacio = "Agent immobiliari";
       				$txt_perfil = $register_ocupacio;
       				break;
       			case 5:
       				$register_ocupacio = "Empresari";
       				$txt_perfil = $register_ocupacio;
       				break;
       			case 6:
       				$register_ocupacio = "Inversor";
       				$txt_perfil = $register_ocupacio;
       				break;
       			case 99:
       				$register_ocupacio = "Altres - ".trim($_POST['registre_ocupacio_altres_text']);
       				$txt_perfil = trim($_POST['registre_ocupacio_altres_text']);
       				break;		
			}

			//update perfil and perfil_txt in db
			$query = "UPDATE usuaris SET txt_perfil=\"$txt_perfil\" WHERE Id = $id";
			$result = mysql_query($query);
						
			switch ($radio_residencia) {
    			case 0:
        			$radio_residencia = "No";
       				break;
    			case 1:
        			$radio_residencia = "Si";
        			break;
			}

			if ($idioma == "cat"){
				$idioma = "Català";
			}else if ($idioma == "cas"){
				$idioma = "Castellano";
			}else if ($idioma == "eng"){
				$idioma = "English";
			}else if ($idioma == "xin"){
				$idioma = "Xinés";
			}

			//mail to planol
			$subject = 'Dades del formulari de registre';
			$emailTo = 'gsevilla@planol.info, dnogue@planol.info';
			$body = "Nom: $registername $registercognoms \n\nEmail: $email \n\nViu a CIUTAT?: $radio_residencia \n\nOcupació: $register_ocupacio \n\nIdioma: $idioma";
			//$header_ = 'MIME-Version: 1.0' . "\r\n" . 'Content-type: text/plain; charset=UTF-8' . "\r\n";
			//$headers = 'From: Eixos.cat <no-responder@eixos.cat>' . "\r\n" . 'Reply-To: ' . $email;
			require_once "/var/www/htdocs/llibreries/class.PlanolMail.php";
			$mail = new PlanolMail(array(
				"From" => $email,
				"FromName" => $registername.' '.$registercognoms,
				"Subject" => $subject,
				"Body" => $body,
				"To" => $emailTo
			));
			if ($mail->send()) $emailSent = true;
			else $emailSent = false;

			//mail to user
			$subject = 'Registro';
			$body = "Us heu enregistrat.\\n\\nSi us heu donat d'alta com a \"comerciant\" o bé \"agent immobiliari\", en breu l'administració del web es posarà en contacte amb vosaltres.";
			$mail = new PlanolMail(array(
				"From" => 'no-reply@eixos.cat',
				"FromName" => "Web Eixos.cat",
				"Subject" => $subject,
				"Body" => $body,
				"To" => $email
			));
			if ($mail->send()) $emailSent = true;
			else $emailSent = false;
		}

	}
}
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head profile="http://gmpg.org/xfn/11">
	<!-- Global site tag (gtag.js) - Google Analytics -->
<script async src="https://www.googletagmanager.com/gtag/js?id=UA-17832234-8"></script>
<script>
	window.dataLayer = window.dataLayer || [];
	function gtag(){dataLayer.push(arguments);}
	gtag('js', new Date());

	gtag('config', 'UA-17832234-8');
</script>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Eixos.cat</title>
<link rel="shortcut icon" href="/img/favicon.ico" />
<link href="/css/reset.css" media="screen" rel="stylesheet" type="text/css" />
<link href="/css/general.css" media="screen" rel="stylesheet" type="text/css" />
<link href="/css/principal.css" media="screen" rel="stylesheet" type="text/css" />
<link href="/css/panels.css" media="screen" rel="stylesheet" type="text/css" />
<link href="/css/skins/custom/skin.css" rel="stylesheet" type="text/css" />
<link href="/css/color.css" rel="stylesheet" type="text/css" />
<link href="//lib.planol.info/jquery/css/jquery.popeye.style.css" media="screen" rel="stylesheet" type="text/css" />
<link href="//lib.planol.info/jquery/css/jquery.popeye.css" media="screen" rel="stylesheet" type="text/css" />
<link href="//lib.planol.info/jquery/css/jquery.ui.core.css" media="screen" rel="stylesheet" type="text/css" />
<link href="//lib.planol.info/jquery/css/jquery.ui.selectmenu.css" media="screen" rel="stylesheet" type="text/css" />
<link href="//lib.planol.info/jquery/css/smoothness/jquery-ui.custom.css" rel="stylesheet" type="text/css" />
<link href="//lib.planol.info/jquery/css/fancybox/jquery.fancybox.css" rel="stylesheet" type="text/css" />
<link href="//lib.planol.info/jquery/css/chosen/chosen.css" rel="stylesheet" type="text/css" />
<link href="/css/principal-1.css" media="screen" rel="stylesheet" type="text/css" />
<link href="/css/staticpage.css" media="screen" rel="stylesheet" type="text/css" />

<script type="text/javascript" src="//lib.planol.info/jquery/js/jquery.min.js"></script>
<script type="text/javascript" src="//lib.planol.info/jquery/js/jquery.messagebar.js"></script>
<script type="text/javascript" src="//lib.planol.info/jquery/js/jquery.popeye.min.js" ></script>
<script type="text/javascript" src="//lib.planol.info/jquery/js/jquery-ui.custom.min.js" ></script>
<script type="text/javascript" src="//lib.planol.info/jquery/js/jquery.url.js" ></script>
<script type="text/javascript" src="//lib.planol.info/jquery/js/redirection_mobile.min.js" ></script>
<script type="text/javascript" src="//lib.planol.info/jquery/js/slides.min.jquery.js"></script>
<script type="text/javascript" src="//lib.planol.info/jquery/js/jquery.ui.core.js"></script>
<script type="text/javascript" src="//lib.planol.info/jquery/js/jquery.ui.widget.js"></script>
<script type="text/javascript" src="//lib.planol.info/jquery/js/jquery.ui.position.js"></script>
<script type="text/javascript" src="//lib.planol.info/jquery/js/jquery.ui.selectmenu.js"></script>
<script type="text/javascript" src="//lib.planol.info/jquery/js/jquery.fancybox.pack.js"></script>
<script type="text/javascript" src="//lib.planol.info/jquery/js/chosen.jquery.min.js"></script>

<script type="text/javascript" src="//twitter.com/javascripts/blogger.js"></script>

<script type="text/javascript" src="/js/language.js" ></script>
<script type="text/javascript" src="/js/dragbox.js" ></script>
<script type="text/javascript" src="/config/config_map.js" ></script>
<script type="text/javascript" src="/config/config_usuaris.js" ></script>
<script type="text/javascript" src="/js/registre.js" ></script>
<!-- <script type="text/javascript" src="/js/search.js" ></script> -->
<!-- <script type="text/javascript" src="/js/google_analytics.js" ></script> -->
<script type="text/javascript" src="//lib.planol.info/jquery/js/jquery.validate.min.js"></script>

<script>SA.redirection_mobile ({mobile_url : 'm.eixos.cat'});</script>
<script src='https://www.google.com/recaptcha/api.js'></script>
</head>
<body id="portada" class="beta">
	<img class="bg" src="/img/bg-1.jpg" alt="" onerror="this.src='/img/blank.gif';"/>
	<div id="message_bar"></div>
	<div id="ambits" class="top">
		<ul></ul>
	</div>

	<div class="top">
		<div id="opcions-generals">
			<ul id="llengua">
				<li><a href="/html/portada-1-cat.html">Català</a></li><li>Castellano</li><li><a href="/html/portada-1-eng.html">English</a></li><li><a href="/html/portada-1-xin.html">中文</a></li><li><a href="/html/portada-1-rus.html">Русский</a></li>
			</ul>
			<div class="xarxes-socials">
		        <p><strong>Síguenos en:</strong></p>
		        <a target="_blank" rel="nofollow" href="https://twitter.com/@Eixoscat" class="twitter">Twitter</a>
				<a target="_blank" rel="nofollow" href="http://www.facebook.com/pages/Eixoscat/234955693261009" class="fb">Facebook</a>
				<!-- <a class="layar" href="http://www.layar.com" rel="nofollow" target="_blank">Layar</a> -->
		    </div>
			<ul id="compartiu">
        		<li><strong>Comparte</strong>
					<ul>
						<li><a class="twitter" target="_blank" rel="nofollow" href="https://twitter.com/share?url=http://www.molletnegocis.cat&amp;via=@Eixoscat" title="Twitter">Twitter</a></li>
						<li><a class="fb" target="_blank" href="http://www.facebook.com/pages/Eixoscat/234955693261009">Facebook</a></li>
					</ul>
				</li>
			</ul>

			<div id="info-session">
				<span class="perfil">Perfil actual: <strong id="username">Visitante</strong></span>
				<span class="dades_empresa"><a href="/html/empresa-cas.php"></a></span>
				<span id="login"><a href="/usuaris/login-cas.html">Iniciar sesión</a> o <a href="/html/registre-cas.html">Registro</a></span>
				<span id="logout"><a href="/usuaris/php/logout_usuari.php">Finalizar sesión</a></span>
			</div>
		</div><!-- /opcions-generals -->
	</div> <!-- /top -->
	<div id="border">
		<div id="header">
			
			<ul id="menu-principal">
				<li class="on"><a id="home_link" href="/">Inicio</a></li>
				<li class="off"><a href="/html/contacte-cas.php">Contacto</a></li>
				<li class="off"><a href="/html/about-cas.html">¿Quiénes somos?</a></li>
				<li class="off"><a href="http://blog.eixos.cat/">Blog</a></li>
			</ul>
			<h1><a href="/"><img src="/img/logo-1.png" alt="eixos.cat" /></a></h1>
		</div>

		<div id="content">
	<div id="modul-mapa">
		<h2></h2>

		<div id="formulari" class="register">
			<h3>Formulari de registre</h3>

			<?php if(isset($hasError)) { //If errors are found ?>
			<p class="error">
				<?php echo $msg; ?>
			</p>
			<?php } ?>

			<?php if(isset($emailSent) && $emailSent == true) { //If email is sent ?>
			<p class="send-ok">
				<strong>
					<?php echo $msg; ?>
				</strong>
			</p>
			<?php } ?>

			<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"
				id="registerform">
				<div>
					<label for="registername">Nom:</label><br /> <input type="text"
						title="Introduïu el vostre nom" name="registername"
						id="registername" value="" class="required registername" size="30" />
				</div>

				<div>
					<label for="registercognoms">Cognoms:</label><br /> <input
						type="text" title="Introduïu els vostres cognoms"
						name="registercognoms" id="registercognoms" value=""
						class="required registercognoms" size="60" />
				</div>

				<div>
					<label for="email">Dirección electrónica:</label><br /> <input
						type="text" title="Introduzca una dirección electrónica válida"
						name="email" id="email" value="" class="required email" size="30" />
				</div>

				<div>
					<label for="telf">Telèfon:</label><br /> <input type="text"
						title="Introduïu un telèfon vàlid" name="telf" id="telf" value=""
						class="required telf" size="30" />
				</div>

				<div>
					<label for="codi">Nom d'usuari:</label><br /> <input type="text"
						title="Introduïu el vostre nom d'usuari" name="codi" id="codi"
						value="" class="required codi" size="30" maxlength="20" />
				</div>

				<div>
					<label for="clau">Clau:</label><br /> <input type="password"
						title="Introduïu la vostra clau" name="clau" id="clau" value=""
						class="required clau" size="30" maxlength="10" />
				</div>

				<div>
					<label for="clau2">Confimació clau:</label><br /> <input
						type="password" title="Introduïu la confirmació de la clau"
						name="clau2" id="clau2" value="" class="required clau2" size="30"
						maxlength="10" />
				</div>

				<fieldset>
					<legend>Vive en CIUDAD?</legend>
					<li>
						<div class="select">
							<input type="radio" id="register_residencia_si" value="1"
								name="register_residencia" class="radio"
								validate="required:true" checked="true"> <label
								for="register_residencia_si">Sí</label>
						</div>
						<div class="select">
							<input type="radio" id="register_residencia_no" value="0"
								name="register_residencia" class="radio"> <label
								for="register_residencia_no">No</label>
						</div></li>
				</fieldset>

				<fieldset>
					<legend>A qué te dedicas?</legend>
					<li>
						<div class="select">
							<input type="radio" id="register_ocupacio_consumidor" value="1"
								name="register_ocupacio" class="radio" validate="required:true"> 
							<label for="register_ocupacio_consumidor">Consumidor</label><br/>
							<input type="radio" id="register_ocupacio_botiguer" value="2"
								name="register_ocupacio" class="radio" validate="required:true"> 
							<label for="register_ocupacio_botiguer">Comerciante</label><br/>
							<input type="radio" id="register_ocupacio_emprenedor" value="3"
								name="register_ocupacio" class="radio" validate="required:true">
							<label for="register_ocupacio_emprenedor">Emprendedor</label><br/>
							<input type="radio" id="register_ocupacio_inmobiliari" value="4"
								name="register_ocupacio" class="radio" validate="required:true">
							<label for="register_ocupacio_inmobiliari">Agente inmobiliario</label><br/>
							<input type="radio" id="register_ocupacio_empresari" value="5"
								name="register_ocupacio" class="radio" validate="required:true">
							<label for="register_ocupacio_empresari">Empresario</label><br/>
							<input type="radio" id="register_ocupacio_inversor" value="6"
								name="register_ocupacio" class="radio" validate="required:true">
							<label for="register_ocupacio_inversor">Inversor</label><br/>
							<input type="radio" id="register_ocupacio_altres" value="99"
								name="register_ocupacio" class="radio" validate="required:true">
							<label for="register_ocupacio_altres">Otros</label>
							<input type="text" id="registre_ocupacio_altres_text" name="registre_ocupacio_altres_text" value="">
						</div></li>
				</fieldset>

				<fieldset>
					<legend>Idioma</legend>
					<li>
						<div class="select">
							<input type="radio" id="register_idioma_cat" value="cat"
								name="register_idioma" class="radio" validate="required:true"
								checked="true"> <label for="register_idioma_cat">Català</label>
						</div>
						<div class="select">
							<input type="radio" id="register_idioma_cas" value="cas"
								name="register_idioma" class="radio"> <label
								for="register_idioma_cas">Castellano</label>
						</div>
						<div class="select">
							<input type="radio" id="register_idioma_eng" value="eng"
								name="register_idioma" class="radio"> <label
								for="register_idioma_eng">English</label>
						</div></li>
				</fieldset>
				<input type="submit" value="Envía la consulta" name="submit"
					class="submit" />
			</form>
		</div>
	</div>
	    	<div id="customize"></div>

	  	</div><!-- #content -->

		<div id="peu">
			<div class="peu_left">
				<div class="xarxes-socials">
		        <p><strong>Síguenos en:</strong></p>
		        <a target="_blank" rel="nofollow" href="https://twitter.com/#!/@Eixoscat" class="twitter">Twitter</a>
				<a target="_blank" rel="nofollow" href="http://www.facebook.com/pages/Eixoscat/234955693261009" class="fb">Facebook</a>
				<div class="links">
		        	<p><strong>Encuéntranos en Layar:</strong></p>
		        	<a target="_blank" rel="nofollow" href="http://www.layar.com" class="layar">Layar</a>
		      	</div>
	      	</div>
				
			</div>
			<div id="logos_peu">
				<a class="planol" href="http://www.planol.info" target="_blank">Planol.info</a><a class="otp" href="http://www.otp.cat/cat/" target="_blank">OTP Enginyeria</a>
			</div>

			<p class="avis-legal"><strong><a href="/html/legal-cas.html" target="_blank">Aviso legal</a></strong></p>
		</div>
	</div> <!-- #border -->
	<script type="text/javascript">
	  // var _gaq = _gaq || [];
	  // _gaq.push(['_setAccount', 'UA-17832234-8']);
	  // _gaq.push(['_setDomainName', 'eixos.cat']);
	  // _gaq.push(['_setAllowLinker', true]);
	  // _gaq.push(['_trackPageview']);
		//
	  // (function() {
	  //   var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
	  //   ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
	  //   var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
	  // })();
	</script>
</body>
</html>