<?php require_once('Connections/azzurra.php'); ?><?php
// Load the common classes
require_once('includes/common/KT_common.php');

// Load the tNG classes
require_once('includes/tng/tNG.inc.php');

// Make a transaction dispatcher instance
$tNGs = new tNG_dispatcher("");

// Make unified connection variable
$conn_azzurra = new KT_connection($azzurra, $database_azzurra);

//start Trigger_CheckPasswords trigger
//remove this line if you want to edit the code by hand
function Trigger_CheckPasswords(&$tNG) {
  $myThrowError = new tNG_ThrowError($tNG);
  $myThrowError->setErrorMsg("Passwords do not match.");
  $myThrowError->setField("password");
  $myThrowError->setFieldErrorMsg("Le due password non coincidono.");
  return $myThrowError->Execute();
}
//end Trigger_CheckPasswords trigger

//start Trigger_WelcomeEmail trigger
//remove this line if you want to edit the code by hand
function Trigger_WelcomeEmail(&$tNG) {
  $emailObj = new tNG_Email($tNG);
  $emailObj->setFrom("{KT_defaultSender}");
  $emailObj->setTo("{email}");
  $emailObj->setCC("");
  $emailObj->setBCC("");
  $emailObj->setSubject("Registrazione Azzurra Print");
  //FromFile method
  $emailObj->setContentFile("email_welcome.html");
  $emailObj->setEncoding("ISO-8859-1");
  $emailObj->setFormat("HTML/Text");
  $emailObj->setImportance("Normal");
  return $emailObj->Execute();
}
//end Trigger_WelcomeEmail trigger

// Start trigger
$formValidation = new tNG_FormValidation();
$formValidation->addField("username", true, "text", "", "", "", "");
$formValidation->addField("password", true, "text", "", "", "", "");
$formValidation->addField("email", true, "text", "email", "", "", "");
$formValidation->addField("tipo_cliente", true, "numeric", "", "", "", "");
$formValidation->addField("codfisc", true, "text", "", "", "", "");
$formValidation->addField("nome", true, "text", "", "", "", "");
$formValidation->addField("cognome", true, "text", "", "", "", "");
$formValidation->addField("indirizzo", true, "text", "", "", "", "");
$formValidation->addField("cap", true, "text", "", "", "", "");
$formValidation->addField("citta", true, "text", "", "", "", "");
$formValidation->addField("provincia", true, "text", "", "", "", "");
$formValidation->addField("consenso", true, "numeric", "int", "1", "1", "Per registrarsi occorre dare il consenso.");
$tNGs->prepareValidation($formValidation);
// End trigger

// Make an insert transaction instance
$userRegistration = new tNG_insert($conn_azzurra);
$tNGs->addTransaction($userRegistration);
// Register triggers
$userRegistration->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Insert1");
$userRegistration->registerTrigger("BEFORE", "Trigger_Default_FormValidation", 10, $formValidation);
$userRegistration->registerTrigger("END", "Trigger_Default_Redirect", 99, "registrazione_ok.php");
$userRegistration->registerConditionalTrigger("{POST.password} != {POST.re_password}", "BEFORE", "Trigger_CheckPasswords", 50);
$userRegistration->registerTrigger("AFTER", "Trigger_WelcomeEmail", 40);
// Add columns
$userRegistration->setTable("users");
$userRegistration->addColumn("username", "STRING_TYPE", "POST", "username");
$userRegistration->addColumn("password", "STRING_TYPE", "POST", "password");
$userRegistration->addColumn("email", "STRING_TYPE", "POST", "email");
$userRegistration->addColumn("ragsoc", "STRING_TYPE", "POST", "ragsoc");
$userRegistration->addColumn("tipo_cliente", "NUMERIC_TYPE", "POST", "tipo_cliente", "0");
$userRegistration->addColumn("codfisc", "STRING_TYPE", "POST", "codfisc");
$userRegistration->addColumn("piva", "STRING_TYPE", "POST", "piva");
$userRegistration->addColumn("nome", "STRING_TYPE", "POST", "nome");
$userRegistration->addColumn("cognome", "STRING_TYPE", "POST", "cognome");
$userRegistration->addColumn("indirizzo", "STRING_TYPE", "POST", "indirizzo");
$userRegistration->addColumn("cap", "STRING_TYPE", "POST", "cap");
$userRegistration->addColumn("citta", "STRING_TYPE", "POST", "citta");
$userRegistration->addColumn("provincia", "STRING_TYPE", "POST", "provincia");
$userRegistration->addColumn("telefono", "STRING_TYPE", "POST", "telefono");
$userRegistration->addColumn("cellulare", "STRING_TYPE", "POST", "cellulare");
$userRegistration->addColumn("fax", "STRING_TYPE", "POST", "fax");
$userRegistration->addColumn("consenso", "NUMERIC_TYPE", "POST", "consenso", "1");
$userRegistration->setPrimaryKey("ID_user", "NUMERIC_TYPE");

// Execute all the registered transactions
$tNGs->executeTransactions();

// Get the transaction recordset
$rsusers = $tNGs->getRecordset("users");
$row_rsusers = mysql_fetch_assoc($rsusers);
$totalRows_rsusers = mysql_num_rows($rsusers);
 session_start(); include('login_inc.php'); ?>
<html>

	<head>
		<meta http-equiv="content-type" content="text/html;charset=iso-8859-1">
		<meta name="generator" content="Adobe GoLive">
		<title>Azzurra Print | Tipografia - Litografia - Digital Print - Serigrafia</title>
		<link href="azzurra.css" type="text/css" rel="stylesheet">
		<script language="JavaScript" src="azzurra.js" type="text/javascript"></script>
		<link href="includes/skins/mxkollection3.css" rel="stylesheet" type="text/css" media="all" />
		<script src="includes/common/js/base.js" type="text/javascript"></script>
		<script src="includes/common/js/utility.js" type="text/javascript"></script>
		<script src="includes/skins/style.js" type="text/javascript"></script>
		<?php echo $tNGs->displayValidationRules();?>		
	</head>

	<body bgcolor="#d8d8d8" leftmargin="0" marginheight="0" marginwidth="0" topmargin="0" onLoad="MM_preloadImages('images/homepage_on.png','images/profilo_on.png','images/prodotti_on.png','images/servizi_on.png','images/listino_on.png','images/download_on.png','images/contatti_on.png')">
		 <div align="center">
			<?php include('top.php'); ?>
			<table width="990" border="0" cellspacing="0" cellpadding="0">
				<tr>
					<td align="center" background="images/bg_body.jpg"><br>
						<br>
						<table width="960" border="0" cellspacing="0" cellpadding="0">
							<tr>
								<td valign="top" width="240"><?php include('include_sx.php'); ?></td>
								<td align="center" valign="top" width="480">
									<table width="435" border="0" cellspacing="0" cellpadding="0">
										<tr height="30">
											<td valign="bottom" width="435" height="30"><img src="images/title_registrazione.gif" alt="" height="24" width="171" border="0"></td>
										</tr>
										<tr>
											<td width="435"><img src="images/line_orizz.gif" alt="" height="33" width="435" border="0"></td>
										</tr>
										<tr>
											<td valign="top" width="435">
<?php
	echo $tNGs->getErrorMsg();
?>
												<form method="post" id="form2" action="<?php echo KT_escapeAttribute(KT_getFullUri()); ?>">
												<div style="PADDING-RIGHT: 10px; PADDING-LEFT: 0px; PADDING-BOTTOM: 10px; PADDING-TOP: 0px">
													<div class="mex_account_top" style="MARGIN-TOP: 10px">
														<span>Informazioni personali</span></div>
													<div class="mex_account" style="PADDING-BOTTOM: 15px">
														<table width="94%" border="0" cellspacing="0" cellpadding="3">
															<tbody>
																<tr>
																	<td class="grey12" valign="top" nowrap>
																		<div style="MARGIN-TOP: 4px" align="right"><label for="username">Username:</label></div>
																	</td>
																	<td>
																		<input type="text" name="username" id="username" style="MARGIN-BOTTOM: 0px" value="<?php echo KT_escapeAttribute($row_rsusers['username']); ?>" size="30" align="absMiddle" />
																		<?php echo $tNGs->displayFieldHint("username");?>
																		<?php echo $tNGs->displayFieldError("users", "username"); ?>
															      		<span style="COLOR: #666666">&nbsp;<font color="#cc0000"><strong>*</strong></font></span></td>
																</tr>
																<tr>
																	<td class="grey12" nowrap>
																		<div align="right">
																			<span class="arial"><label for="password">Password:</label></span></div>
																	</td>
																	<td>
																		<input type="password" name="password" id="password" style="MARGIN-BOTTOM: 0px" value="" size="30" align="absMiddle" />
																		<?php echo $tNGs->displayFieldHint("password");?>
																		<?php echo $tNGs->displayFieldError("users", "password"); ?>
																		<span style="COLOR: #666666">&nbsp;<font color="#cc0000"><strong>*</strong></font></span></td>
																</tr>
																<tr>
																	<td class="grey12" nowrap>
																		<div align="right">
																			<span class="arial"><label for="re_password">Conferma password:</label></span></div>
																	</td>
																	<td>
																		<input type="password" name="re_password" id="re_password" value="" style="MARGIN-BOTTOM: 0px" size="30" align="absMiddle" /></td>
																</tr>
																<tr>
																	<td class="grey12" valign="top" nowrap>
																		<div style="MARGIN-TOP: 4px" align="right"><label for="email">e-mail:</label></div>
																	</td>
																	<td>
																		<input type="text" name="email" id="email" style="MARGIN-BOTTOM: 0px" value="<?php echo KT_escapeAttribute($row_rsusers['email']); ?>" size="30" align="absMiddle" />
																		<?php echo $tNGs->displayFieldHint("email");?>
																		<?php echo $tNGs->displayFieldError("users", "email"); ?>
															      		<span style="COLOR: #666666">&nbsp;<font color="#cc0000"><strong>*</strong></font></span></td>
																</tr>
																<tr>
																	<td valign="top" nowrap>&nbsp;</td>
																	<td>
																		<div style="PADDING-RIGHT: 10px; MARGIN-TOP: 5px; COLOR: #666666">
																			<span class="orange"><strong>Inserire un indirizzo e-mail valido</strong></span><br>
																			<span class="grey10">Inserire un indirizzo e-mail valido &egrave; fondamentale sia per identificarti che per ricevere i messaggi automatici di sistema (conferma di registrazione, conferme ordini, ecc.).</span></div>
																	</td>
																</tr>
																<tr height="24">
																	<td colspan="2" valign="bottom" nowrap height="24"><span class="orange">&nbsp;<font color="#cc0000"><strong>*</strong></font> Campi obbligatori</span></td>
																</tr>
															</tbody>
														</table>
													</div>
													<div class="mex_account_top" style="MARGIN-TOP: 15px">
														<span>Forma giuridica e dati anagrafici</span></div>
													<div class="mex_account" style="PADDING-BOTTOM: 20px">
														<table width="94%" border="0" cellspacing="0" cellpadding="3">
															<tbody>
																<tr>
																	<td class="grey12" valign="top" width="150">
																		<div align="right">
																			<span class="arial"><label for="tipo_cliente_1">Tipo cliente:</label></span></div>
																	</td>
																	<td class="grey12">
																		<div>
																			<input <?php if (!(strcmp(KT_escapeAttribute($row_rsusers['tipo_cliente']),"0"))) {echo "CHECKED";} ?> type="radio" name="tipo_cliente" id="tipo_cliente_1" value="0" />
																			<span class="arial"><strong><label for="tipo_cliente_1">Privato</label></strong></span>
																		</div>
																	
																		<div>
																			<input <?php if (!(strcmp(KT_escapeAttribute($row_rsusers['tipo_cliente']),"1"))) {echo "CHECKED";} ?> type="radio" name="tipo_cliente" id="tipo_cliente_2" value="1" />
																			<span class="arial"><strong><label for="tipo_cliente_2">Azienda / Ente / Associazione</label></strong></span>
																		</div>
																		<?php echo $tNGs->displayFieldError("users", "tipo_cliente"); ?>
																	</td>
																</tr>
																<tr>
																	<td class="grey12" width="150">
																		<div align="right">
																			<span class="arial"><label for="ragsoc">Ragione Sociale:</label></span></div>
																	</td>
																	<td class="grey12">
																		<input type="text" name="ragsoc" id="ragsoc" style="MARGIN-BOTTOM: 0px" value="<?php echo KT_escapeAttribute($row_rsusers['ragsoc']); ?>" size="30" align="absMiddle" />
																		<?php echo $tNGs->displayFieldHint("ragsoc");?>
																		<?php echo $tNGs->displayFieldError("users", "ragsoc"); ?>
																		&nbsp;<font color="#cc0000"><strong>*</strong></font></td>
																</tr>
																<tr>
																	<td class="grey12" width="150">
																		<div align="right">
																			<span class="arial"><label for="codfisc">Codice fiscale:</label></span></div>
																	</td>
																	<td class="grey12" nowrap>
																		<input type="text" name="codfisc" id="codfisc" style="MARGIN-BOTTOM: 0px" value="<?php echo KT_escapeAttribute($row_rsusers['codfisc']); ?>" size="30" align="absMiddle" />
																		<?php echo $tNGs->displayFieldHint("codfisc");?>
																		<?php echo $tNGs->displayFieldError("users", "codfisc"); ?>
																		&nbsp;<font color="#cc0000"><strong>*</strong></font></td>
																</tr>
																<tr>
																	<td class="grey12" width="150">
																		<div align="right">
																			<span class="arial"><label for="piva">Partita IVA:</label></span></div>
																	</td>
																	<td class="grey12" nowrap>
																		<input type="text" name="piva" id="piva" style="MARGIN-BOTTOM: 0px" value="<?php echo KT_escapeAttribute($row_rsusers['piva']); ?>" size="30" align="absMiddle" />
																		<?php echo $tNGs->displayFieldHint("piva");?>
																		<?php echo $tNGs->displayFieldError("users", "piva"); ?>
																		&nbsp;<font color="#cc0000"><strong>*</strong></font></td>
																</tr>
																<tr>
																	<td class="grey12" width="150">
																		<div align="right">
																			<span class="arial"><label for="nome">Nome:</label></span></div>
																	</td>
																	<td class="grey12">
																		<input type="text" name="nome" id="nome" style="MARGIN-BOTTOM: 0px" value="<?php echo KT_escapeAttribute($row_rsusers['nome']); ?>" size="30" align="absMiddle" />
																		<?php echo $tNGs->displayFieldHint("nome");?>
																		<?php echo $tNGs->displayFieldError("users", "nome"); ?>
																		&nbsp;<font color="#cc0000"><strong>*</strong></font></td>
																</tr>
																<tr>
																	<td class="grey12" width="150">
																		<div align="right">
																			<span class="arial"><label for="cognome">Cognome:</label></span></div>
																	</td>
																	<td class="grey12">
																		<input type="text" name="cognome" id="cognome" style="MARGIN-BOTTOM: 0px" value="<?php echo KT_escapeAttribute($row_rsusers['cognome']); ?>" size="30" align="absMiddle" />
																		<?php echo $tNGs->displayFieldHint("cognome");?>
																		<?php echo $tNGs->displayFieldError("users", "cognome"); ?>
																		&nbsp;<font color="#cc0000"><strong>*</strong></font></td>
																</tr>
																<tr>
																	<td class="grey12" width="150">
																		<div align="right">
																			<span class="arial"><label for="indirizzo">Indirizzo:</label></span></div>
																	</td>
																	<td class="grey12">
																		<input type="text" name="indirizzo" id="indirizzo" style="MARGIN-BOTTOM: 0px" value="<?php echo KT_escapeAttribute($row_rsusers['indirizzo']); ?>" size="30" align="absMiddle" />
																		<?php echo $tNGs->displayFieldHint("indirizzo");?>
																		<?php echo $tNGs->displayFieldError("users", "indirizzo"); ?>
																		&nbsp;<font color="#cc0000"><strong>*</strong></font></td>
																</tr>
																<tr>
																	<td class="grey12" width="150">
																		<div align="right">
																			<span class="arial"><label for="cap">CAP:</label> / <label for="citta">Citt&agrave;:</label> / <label for="provincia">Provincia:</label></span></div>
																	</td>
																	<td class="grey12">
																		<table border="0" cellspacing="0" cellpadding="0">
																			<tr>
																				<td>
																					<input type="text" name="cap" id="cap" style="MARGIN-BOTTOM: 0px" value="<?php echo KT_escapeAttribute($row_rsusers['cap']); ?>" size="5" maxlength="10" align="absMiddle" />
																					<?php echo $tNGs->displayFieldHint("cap");?>
																					<?php echo $tNGs->displayFieldError("users", "cap"); ?>
                                                                                </td>
																				<td>&nbsp;</td>
																				<td>
																					<input type="text" name="citta" id="citta" style="MARGIN-BOTTOM: 0px" value="<?php echo KT_escapeAttribute($row_rsusers['citta']); ?>" size="13" align="absMiddle" />
																					<?php echo $tNGs->displayFieldHint("citta");?>
																					<?php echo $tNGs->displayFieldError("users", "citta"); ?>
																				</td>
																				<td>&nbsp;</td>
																				<td>
																					<input type="text" name="provincia" id="provincia" style="MARGIN-BOTTOM: 0px" value="<?php echo KT_escapeAttribute($row_rsusers['provincia']); ?>" size="2" align="absMiddle" />
																					<?php echo $tNGs->displayFieldHint("provincia");?>
																					<?php echo $tNGs->displayFieldError("users", "provincia"); ?>
																					&nbsp;<font color="#cc0000"><strong>*</strong></font></td>
																			</tr>
																		</table>
																	</td>
																</tr>
																<tr>
																	<td class="grey12" width="150">
																		<div align="right">
																			<span class="arial"><label for="telefono">Telefono fisso:</label></span></div>
																	</td>
																	<td class="grey12">
																		<input type="text" name="telefono" id="telefono" style="MARGIN-BOTTOM: 0px" value="<?php echo KT_escapeAttribute($row_rsusers['telefono']); ?>" size="30" align="absMiddle" />
																		<?php echo $tNGs->displayFieldHint("telefono");?>
																		<?php echo $tNGs->displayFieldError("users", "telefono"); ?>
																		&nbsp;<font color="#cc0000"><strong>*</strong></font></td>
																</tr>
																<tr>
																	<td class="grey12" width="150">
																		<div align="right">
																			<span class="arial"><label for="cellulare">Cellulare:</label></span></div>
																	</td>
																	<td class="grey12">
																		<input type="text" name="cellulare" id="cellulare" style="MARGIN-BOTTOM: 0px" value="<?php echo KT_escapeAttribute($row_rsusers['cellulare']); ?>" size="30" align="absMiddle" />
																		<?php echo $tNGs->displayFieldHint("cellulare");?>
																		<?php echo $tNGs->displayFieldError("users", "cellulare"); ?>
																	</td>
																</tr>
																<tr>
																	<td class="grey12" width="150">
																		<div align="right">
																			<span class="arial"><label for="fax">Fax:</label></span></div>
																	</td>
																	<td class="grey12">
																		<input type="text" name="fax" id="fax" style="MARGIN-BOTTOM: 0px" value="<?php echo KT_escapeAttribute($row_rsusers['fax']); ?>" size="30" align="absMiddle" />
																		<?php echo $tNGs->displayFieldHint("fax");?>
																		<?php echo $tNGs->displayFieldError("users", "fax"); ?>
																	</td>
																</tr>
																<tr height="24">
																	<td colspan="2" valign="bottom" nowrap height="24"><span class="orange">&nbsp;<font color="#cc0000"><strong>*</strong></font> Campi obbligatori</span></td>
																</tr>
															</tbody>
														</table>
													</div>
													<div class="mex_account_top" style="MARGIN-TOP: 15px">
														<span>Consenso dati personali</span></div>
													<div class="mex_account" style="PADDING-BOTTOM: 0px">
														<table width="94%" border="0" cellspacing="0" cellpadding="0">
															<tbody>
																<tr>
																	<td style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-BOTTOM: 15px; PADDING-TOP: 10px">
																		<table width="100%" border="0" cellspacing="0" cellpadding="0">
																			<tbody>
																				<tr>
																					<td style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px" valign="top">
																						<table width="100%" border="0" cellspacing="0" cellpadding="3">
																							<tbody>
																								<tr>
																									<td style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px"><span class="grey12"><span class="arial">Presti il consenso per il trattamento dei tuoi dati nei termini indicati nell'<a class="orangelink" style="FONT-SIZE: 12px; FONT-FAMILY: arial; LETTER-SPACING: 0px" href="#" onclick="window.open('informativa.htm','','scrollbars=yes,width=600,height=500')"><strong>informativa</strong></a> di cui hai preso piena visione (rispondendo No, non sar� possibile iscriversi)?</span></span>
																										<div style="MARGIN-TOP: 5px" align="center">
																											<span class="grey12"><span class="arial"><label for="consenso_1">Si</label> <input <?php if (!(strcmp(KT_escapeAttribute($row_rsusers['consenso']),"1"))) {echo "CHECKED";} ?> type="radio" name="consenso" id="consenso_1" value="1" /> <label for="consenso_2">No</label> <input <?php if (!(strcmp(KT_escapeAttribute($row_rsusers['consenso']),"0"))) {echo "CHECKED";} ?> type="radio" name="consenso" id="consenso_2" value="0" /></span></span>
																											<?php echo $tNGs->displayFieldError("users", "consenso"); ?>
																										</div>
																									</td>
																								</tr>
																							</tbody>
																						</table>
																					</td>
																				</tr>
																			</tbody>
																		</table>
																	</td>
																</tr>
															</tbody>
														</table>
													</div>
													<div style="MARGIN-TOP: 6px; PADDING-TOP: 6px" align="center">
														<input type="submit" name="KT_Insert1" id="KT_Insert1" value="Conferma registrazione" title="Procedi con la registrazione" class="mysubmit" />
													</div>
												</div>
												</form>
											</td>
										</tr>
									</table>
								</td>
								<td valign="top" width="240"><?php include('include_dx.php'); ?></td>
							</tr>
						</table>
						<br>
						<br>
					</td>
				</tr>
			</table>
			<?php include('bottom.php'); ?></div>
	</body>

</html>