<?
session_set_cookie_params(SESSION_TIME);
session_start();
$idutente = null;
if(isset($_SESSION['idutente'])) {
	$idutente = $_SESSION['idutente'];
}
#### FUNZIONI ##
function login($username,$password) {
	global $idutente, $db;
	$query = "select id,nome,cognome,email from utentiweb where username='$username' 
	and password='".md5($password)."' and attivo=1 limit 0,1";
	$stmt = $db->prepare($query);
	$stmt->execute();
	if($stmt->rowCount() > 0) {
		$nomecol = $stmt->fetch();
		$_SESSION['idutente'] = $idutente = $nomecol[0];
		$_SESSION['nome'] = $nomecol[1];
		$_SESSION['cognome'] = $nomecol[2];
		$_SESSION['email'] = $nomecol[3];
		$login = true;
	} else
		$login = false;
	return $login;
}

function logout() {
	global $idutente;
	$idutente = null;
	$_SESSION['idutente'] = null;
}
## END FUNZIONI ##
?><?
## FUNZIONI ##
function formattaStringaDb($str) {
	return utf8_decode(rawurldecode(stripslashes($str)));
}

function formattaStringaToDb($str) {
	return utf8_encode(addslashes($str));
}

function get_include_contents($filename) {
	global $lang,$idutente,$idordine,$user,$login,$cart,$articolo;
	if (is_file($filename)) {
		ob_start();
		include $filename;
		$contents = ob_get_contents();
		ob_end_clean();
		return $contents;
	}
	return false;
}

function generatePassword ($length=8) {
	$password = "";
	$possible = "0123456789bcdfghjkmnpqrstvwxyz";
	$i = 0;
	while ($i < $length) {
		$char = substr($possible, mt_rand(0, strlen($possible)-1), 1);
		if (!strstr($password, $char)) {
			$password .= $char;
			$i++;
		}
	}
	return $password;
}

function getIva() {
	global $db;
	$query = "select valore from settaggi where nome='iva' limit 1;";
	$stmt = $db->prepare($query);
	$stmt->execute();
	$nomecol = $stmt->fetch();
	return $nomecol['valore'];
}

function ControlloCodiceFiscale($cf) {
	if( $cf == '' )  return false;
	if( strlen($cf) != 16 )
	return false;
	$cf = strtoupper($cf);
	if( ! ereg("^[A-Z0-9]+$", $cf) ){
		return false;
	}
	$s = 0;
	for( $i = 1; $i <= 13; $i += 2 ){
		$c = $cf[$i];
		if( '0' <= $c && $c <= '9' )
		$s += ord($c) - ord('0');
		else
		$s += ord($c) - ord('A');
	}
	for( $i = 0; $i <= 14; $i += 2 ){
		$c = $cf[$i];
		switch( $c ){
			case '0':  $s += 1;  break;
			case '1':  $s += 0;  break;
			case '2':  $s += 5;  break;
			case '3':  $s += 7;  break;
			case '4':  $s += 9;  break;
			case '5':  $s += 13;  break;
			case '6':  $s += 15;  break;
			case '7':  $s += 17;  break;
			case '8':  $s += 19;  break;
			case '9':  $s += 21;  break;
			case 'A':  $s += 1;  break;
			case 'B':  $s += 0;  break;
			case 'C':  $s += 5;  break;
			case 'D':  $s += 7;  break;
			case 'E':  $s += 9;  break;
			case 'F':  $s += 13;  break;
			case 'G':  $s += 15;  break;
			case 'H':  $s += 17;  break;
			case 'I':  $s += 19;  break;
			case 'J':  $s += 21;  break;
			case 'K':  $s += 2;  break;
			case 'L':  $s += 4;  break;
			case 'M':  $s += 18;  break;
			case 'N':  $s += 20;  break;
			case 'O':  $s += 11;  break;
			case 'P':  $s += 3;  break;
			case 'Q':  $s += 6;  break;
			case 'R':  $s += 8;  break;
			case 'S':  $s += 12;  break;
			case 'T':  $s += 14;  break;
			case 'U':  $s += 16;  break;
			case 'V':  $s += 10;  break;
			case 'W':  $s += 22;  break;
			case 'X':  $s += 25;  break;
			case 'Y':  $s += 24;  break;
			case 'Z':  $s += 23;  break;
		}
	}
	if( chr($s%26 + ord('A')) != $cf[15] )
	return false;
	return true;
}

function ControlloPIVA($pi){
	if( $pi == '' )  return false;
	if( strlen($pi) != 11 )
	return false;
	if( ! ereg("^[0-9]+$", $pi) )
	return false;
	$s = 0;
	for( $i = 0; $i <= 9; $i += 2 )
	$s += ord($pi[$i]) - ord('0');
	for( $i = 1; $i <= 9; $i += 2 ){
		$c = 2*( ord($pi[$i]) - ord('0') );
		if( $c > 9 )  $c = $c - 9;
		$s += $c;
	}
	if( ( 10 - $s%10 )%10 != ord($pi[10]) - ord('0') )
	return false;
	return true;
}

function TagliaStringa($stringa, $max_char){
		$stringa = strip_tags($stringa);
		if(strlen($stringa)>$max_char){
			$stringa_tagliata=substr($stringa, 0,$max_char);
			$last_space=strrpos($stringa_tagliata," ");
			$stringa_ok=substr($stringa_tagliata, 0,$last_space);
			return $stringa_ok.'...';
		}else{
			return $stringa;
		}
}

function codeLang($lang) {
	switch($lang) {
		case "ita":
			$res = 1;
			break;
			
			case "eng":
				$res = 2;
				break;
				
				case "fra":
					$res = 3;
					break;
					
					case "ger":
						$res = 5;
						break;
						
						case "spa":
							$res = 4;
							break;
	}
	return $res;
}
######
?><!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>
        <title>
            Eurotec Cooking Service - Reserved Area
        </title>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
        <meta name="description" content="Eurotec Cooking Service - Reserved Area" />
        <meta name="robots" content="index, follow" />
        <link type="text/css" href="/css/reset.css" rel="Stylesheet" />
        <link type="text/css" href="/css/stili.css" rel="Stylesheet" />
        <link rel="stylesheet" href="/js/jquery-tooltip/jquery.tooltip.css" />
        <!-- jquery e jquery ui -->
        <script src="/js/jquery-1.8.2.min.js" type="text/javascript"></script>
        <script src="/js/jquery-ui-1.8.23.custom.min.js" type="text/javascript"></script>        
        <!-- validate -->
        <script src="/js/validate/dist/jquery.validate.min.js" type="text/javascript"></script>        
        <!-- CryptoJs -->
        <script src="/js/cryptojs/rollups/md5.js" type="text/javascript"></script>
        <!-- fancy -->
		<script type="text/javascript" src="/js/fancybox/jquery.fancybox-1.3.4.pack.js"></script>
		<script type="text/javascript" src="/js/fancybox/jquery.easing-1.3.pack.js"></script>
		<script type="text/javascript" src="/js/fancybox/jquery.mousewheel-3.0.4.pack.js"></script>
		<!-- jquery tooltip -->
        <script src="/js/jquery-tooltip/jquery.tooltip.js" type="text/javascript"></script>
		<link rel="stylesheet" href="/js/fancybox/jquery.fancybox-1.3.4.css" type="text/css" media="screen" />				
        <!-- funzioni -->
        <script src="/js/functions.js" type="text/javascript"></script>
    </head> 
    <body>
        <div class="top">
    <div class="top_cnt">
        <div class="logo">
            <a href="/spa/"><img src="/immagini/logo.jpg" /></a>
        </div>
        <div class="lingua"><a href="/ita/"><img src="/immagini/ita.png" /></a><a href="/eng/"><img src="/immagini/eng.png" /></a><a href="/fra/"><img src="/immagini/fra.png" /></a><a href="/spa/"><img src="/immagini/spa.png" /></a><a href="/ger/"><img src="/immagini/ger.png" /></a></div>
        <div id="menu-out" class="menu_top" >
            <a href="javascript:;" onclick="javascript:scorri1();">Login</a>            <a href="javascript:;" onclick="javascript:scorri2();" id="top_reg">Incripción</a>            <a href="javascript:;" onclick="javascript:scorri3();">¿Has olvidado tu password?</a>                    
        </div>
		<div id="menu-in" class="menu_top" style="display:none;">
			<a href="javascript:;" onclick="modificaPw();">¿Modifica tu password?</a>            <a href="/index.php?submit=logout">Logout</a>                    
        </div>
    </div>
</div>
<div class="box_registrati" id="slider2">
    <div style="font-size: 1.2em; font-weight:bolder; margin-bottom:20px; text-align:center;">Compile el form para obtener el acceso al Cooking Service</div>
    <form method="post" action="" id="formreg">
        <input type="hidden" name="lingua" id="lingua" value="spa" />
        <div id="msg-error" class="msg-error"></div>
        <div class="dati_sx">
            C&Oacute;DIGO DE CLIENTE        </div>
        <div class="dati_dx">
            <input type="text" name="codice" id="codice" class="required" />
        </div>
        <div class="chiudi"></div>
        
        <div class="dati_sx">
            NUEVO CLIENTE        </div>
        <div class="dati_dx">
            <input type="checkbox" style="width: 20px;height: 20px;border: 0px;" name="chiedicodice" id="chiedicodice" value="1" onclick="setCodice();" class="box_login_dx_checkbox" />
        </div>
        <div class="chiudi"></div>
        
        <div class="dati_sx">
            NOME        </div>
        <div class="dati_dx">
            <input type="text" name="nome" id="nome" class="required" />
        </div>
        <div class="chiudi"></div>
        <div class="dati_sx">
            COGNOME        </div>
        <div class="dati_dx">
            <input type="text" name="cognome" id="cognome" class="required" />
        </div>
        <div class="chiudi"></div>
        <div class="dati_sx">
            NOMBRE DE LA COMPAÑÍA        </div>
        <div class="dati_dx">
            <input type="text" name="ragionesociale" id="ragionesociale" />
        </div>
        <div class="chiudi"></div>

        <div class="dati_sx">
            IVA        </div>
        <div class="dati_dx">
            <input type="text" name="piva" id="piva" />
        </div>
        <div class="chiudi"></div>
        <div class="dati_sx">
            DIRECCI&Oacute;N        </div>
        <div class="dati_dx">
            <input type="text" name="indirizzo" id="indirizzo" class="required" />
        </div>
        <div class="chiudi"></div>
        <div class="dati_sx">
            C&Oacute;DIGO POSTAL        </div>
        <div class="dati_dx">
            <input type="text" name="cap" id="cap" class="required" />
        </div>
        <div class="chiudi"></div>
        <div class="dati_sx">
            CIUDAD        </div>
        <div class="dati_dx">
            <input type="text" name="citta" id="citta" class="required" />
        </div>
        <div class="chiudi"></div>
        <div class="dati_sx">
            ESTADO        </div>
        <div class="dati_dx">
            <select id="stato" name="stato">
<?
$nazioni = utente::arrayNazioni();
if(count($nazioni) > 0) {
	foreach ($nazioni as $nazione) {
		echo '<option value="'.$nazione['sigla'].'">'.($lang=="ita" ? $nazione['nazione'] : $nazione['naz_eng']).'</option>';
	}
}
?>
</select>
        </div>
        <div class="chiudi"></div>
        <div class="dati_sx">
            TEL&Eacute;FONO        </div>
        <div class="dati_dx">
            <input type="text" name="tel" id="tel"  />
        </div>
        <div class="chiudi"></div>
        <div class="dati_sx">
            M&Oacute;VIL        </div>
        <div class="dati_dx">
            <input type="text" name="cell" id="cell" />
        </div>
        <div class="chiudi"></div>
        <div class="dati_sx">
            E-MAIL        </div>
        <div class="dati_dx">
            <input type="text" name="email" id="email" class="required" /><span id="checkemail" style="color: #ff0000;"></span>
        </div>                         
        <div class="chiudi"></div>
        <div class="dati_sx">
            P&Aacute;GINA WEB        </div>
        <div class="dati_dx">
            <input type="text" name="sito" id="sito" />
        </div>
        <div class="chiudi"></div>
        <div class="dati_sx">
            USERNAME        </div>      
        <div class="dati_dx">
            <input type="text" name="username" id="username" class="required" />
        </div>
        <div class="chiudi"></div>
        <div class="dati_sx">
            ANTISPAM
        </div>
        <div class="dati_dx" style="height: auto;">
            <img alt="CAPTCHA Image" id="captcha" src="/library/securimage/securimage_show.php" /><br />
            <input id="captcha_code" maxlength="6" name="captcha_code" type="text" style="width: 215px;" class="required" /> <span id="error_captcha" style="font-weight: normal; color: #ff0000;"></span> [ <a href="#" onclick="document.getElementById('captcha').src = '/library/securimage/securimage_show.php?' + Math.random(); return false">Recarga la imagen</a> ]                                                            
        </div>                    
        <div class="chiudi"></div> 
        <div class="dati_sx">
            PRIVACY
        </div>
        <div class="dati_dx" style="height: auto;">
            <input type="checkbox" style="width: 20px;height: 20px;border: 0px;" name="privacy" id="privacy" class="required" class="box_login_dx_checkbox" />  Declaro de haber leído el informe sobre la privacy art.13 D.lgs 196/2003        </div>                    
        <div class="chiudi"></div> 
        <div class="dati_sx">
            &nbsp;
        </div>
        <div class="dati_dx">
            <input type="submit" name="submit" value="Registro" id="mandareg" style="height: 30px; width: 150px; font-weight: bolder;"  />                    
        </div>
    </form>
    <div class="chiudi"></div>
    <div id="loader" class="loading-reg"><img src="/immagini/loader.gif" /></div>
</div>
<div class="box_cambiapw" id="sliderpw">
    <div style="font-size: 1.2em; font-weight:bolder; margin-bottom:20px; text-align:center;">Modifica tu password</div>
    <div id="msg-error-modifica" class="msg-error"></div>
    <div id="msg-modifica" class="msg-ok"></div>
    <form method="post" action="" id="form-modificapw">
        <div id="msg-error" class="msg-error"></div>
        <div class="dati_sx">
            Crea nueva password        </div>
        <div class="dati_dx">
            <input type="password" name="newpw" id="newpw" class="required" /> 
        </div>
        <div class="chiudi"></div>
        <div class="dati_sx">
            &nbsp;
        </div>
        <div class="dati_dx">
            <input type="submit" name="submit" value="Salva" id="salvapw" style="height: 30px; width: 150px; font-weight: bolder;"  />                    
        </div>
        
    </form>
</div>        <div id="container" class="contlogin" style="">
            <div class="box_login" id="slider">
                <div class="box_login_sx">
                    <img src="/immagini/lock.png" />
                </div>
                <div class="box_login_dx">
                    <form method="post" action="" id="form-login">
                        <div style="float:left; margin-right:5px;"><img src="/immagini/user.png" /></div>
                        <div style="float:left;"><input type="text" name="user" id="user" placeholder="username" /></div>
                        <div class="chiudi"></div>
                        <div style="float:left; margin-right:5px;"><img src="/immagini/pass.png" /></div>
                        <div style="float:left;"><input type="password" name="pass" id="pass" placeholder="password"  /></div>
                        <div class="chiudi"></div>
                        <div style="float:left; width:32px; margin-right:5px;">&nbsp;</div>
                        <div style="float:left;"><input type="submit" name="submit" value="Login" id="entra" /></div>
                        <div class="chiudi"></div>
                        <div id="msg-error-login" class="msg-error"></div>
                    	<div class="chiudi"></div>
                    </form>
                </div>
            </div>
            <div class="box_login" id="slider3" style="display:none;">
                <div class="box_login_sx">
                    <img src="/immagini/unlock.png" />
                </div>
                <div class="box_login_dx">
                    Escribe el email utilizada en el momento de la incriptión y recibiras nueva password                    <form method="post" action="" id="form-recupera">
                        <div style="float:left; margin-right:5px;"><img src="/immagini/mail.png" /></div>
                        <div style="float:left;"><input type="text" name="emailrec" id="emailrec" placeholder="E-mail" /></div>
                        <div class="chiudi"></div>
                        <div style="float:left; width:32px; margin-right:5px;">&nbsp;</div>
                        <div style="float:left;"><input type="submit" name="submit" value="Envío" id="inviarec" /></div>
                        <div class="chiudi"></div>
                        <div id="msg-recupera" class="msg-ok"></div>
                        <div id="msg-error-recupera" class="msg-error"></div>
                    	<div class="chiudi"></div>
                    </form>
                </div>
            </div>
            <div class="box_login" id="slider4" style="display:none;">
            <div class="box_login_sx">
                    <img src="/immagini/unlock.png" />
                </div>
                <div class="box_login_dx">
                    <strong> Incriptión Cliente</strong><br />
                    Inscripción efectuada con éxito. Después de haber verificado los datos mandaremos un email de confirmación actualización                </div>
            </div>
            </div>
            	<div id="container-area" class="cont-area" style="display:none;">
	            	<div class="colonna-sx">
	            	<div class="box-cerca">
		            	<div class="tit-box-cerca" style="text-align:center;"><a href="/index.php?submit=getListino"><img src="/immagini/pdf.png" align="absmiddle" /> Descarga el listín de precios</a><br />
		            	<span style="font-size:.8em;font-weight:normal;text-transform:lowercase;">o</span>
		            	</div>
		            	<div class="tit-box-cerca" style="margin-top:10px;">Busca codígo listín</div>
		            	<div>
		            	<form method="post" action="" id="form-cerca">
		            	Busca codígo: <input type="text" id="search" name="search" /><input type="submit" id="btn-cerca" value="Busca" />
		            	</form>
		            	</div>
	            	</div>
	            	<div class="box-cerca">
	            		<div class="tit-box-cerca" style="margin-top:10px;">LINK</div>