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

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

require_once('includes/phpmailer/class.phpmailer.php');

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

// Make unified connection variable
$conn_database = new KT_connection($database, $database_database);

if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

function calcolaNome( $nome )
{
	$colname_rsLingua = "1";
	if (isset($_SESSION['idLanguage'])) {
  		$colname_rsLingua = $_SESSION['idLanguage'];
	}	
	
	if( strpos( $nome, "/" ) == FALSE )
		return $nome;
		
	// Italiano
	if( $colname_rsLingua == 1 )
	{
		$position = strpos( $nome, "/" );
		
		$nomereturned = substr( $nome, 0, $position - 1 );
	}
	// INglese
	if( $colname_rsLingua == 2 )
	{
		$position = strstr( $nome, "/" );
		
		$nomereturned = substr( $position, 2, strlen( $position ) - 2 );
	}
	
	return $nomereturned;
}

if( !isset($_SESSION['idLanguage']) )
	$_SESSION['idLanguage'] = 1;

$colname_rsLingua = "1";
if (isset($_SESSION['idLanguage'])) {
  $colname_rsLingua = $_SESSION['idLanguage'];
}
mysql_select_db($database_database, $database);
$query_rsLingua = sprintf("SELECT sitelabels_static.*, sitelabels.* FROM sitelabels_static JOIN sitelabels on sitelabels_static.key_label = sitelabels.id WHERE sitelabels_static.language_label = %s", GetSQLValueString($colname_rsLingua, "int"));
$rsLingua = mysql_query($query_rsLingua, $database) or die(mysql_error());
$row_rsLingua = mysql_fetch_assoc($rsLingua);
$totalRows_rsLingua = mysql_num_rows($rsLingua);

// Trasformare resultSet in Array
$labels = array();
for( $i = 0; $i < $totalRows_rsLingua; $i++ )
{
	// Array
	$labels[$row_rsLingua['labelname']] = $row_rsLingua['value_label'];
	
	// Go on
	$row_rsLingua = mysql_fetch_assoc($rsLingua);
}

//start Trigger_SendEmail trigger
//remove this line if you want to edit the code by hand
function Trigger_SendEmail(&$tNG) {
  $emailObj = new tNG_Email($tNG);
  $emailObj->setFrom("{KT_defaultSender}");
  $emailObj->setTo("{SESSION.kt_login_email}");
  $emailObj->setCC("");
  $emailObj->setBCC("{KT_defaultSender}");
  $emailObj->setSubject("Prenotazione acquisto");
  //WriteContent method
  $emailObj->setContent("");
  $emailObj->setEncoding("ISO-8859-1");
  $emailObj->setFormat("HTML/Text");
  $emailObj->setImportance("Normal");
  return $emailObj->Execute();
}
//end Trigger_SendEmail trigger

$subjectMail = $labels['KEY_SUBJECTMAIL'];

//start Trigger_Custom trigger
function Trigger_Custom(&$tNG) {
	// Global Variable
	global $database_database, $database, $subjectMail, $database_catalogo, $catalogo;
	
	// Send Email
	$mail = new PHPMailer();
	$mail->Mailer = "smtp";
	$mail->Host = "authsmtp.fnm-marine.com";
	$mail->SMTPAuth = TRUE;
	$mail->Username = "smtp@fnm-marine.com";
	$mail->Password = "65CLAUDIO";
	$mail->From = "noreply@fnm-marine.com";
	$mail->FromName = "FNM Marine";
	$mail->Sender = "noreply@fnm-marine.com";
	$mail->AddAddress($_SESSION['kt_login_email']);
	$mail->AddAddress("info@cmdengine.com");
	
	$colname_rsLingua = "1";
if (isset($_SESSION['idLanguage'])) {
  $colname_rsLingua = $_SESSION['idLanguage'];
}
mysql_select_db($database_database, $database);
$query_rsLingua = sprintf("SELECT sitelabels_static.*, sitelabels.* FROM sitelabels_static JOIN sitelabels on sitelabels_static.key_label = sitelabels.id WHERE sitelabels_static.language_label = %s", GetSQLValueString($_SESSION['idLanguage'], "int"));
$rsLingua = mysql_query($query_rsLingua, $database) or die(mysql_error());
$row_rsLingua = mysql_fetch_assoc($rsLingua);
$totalRows_rsLingua = mysql_num_rows($rsLingua);

// Trasformare resultSet in Array
$labels = array();
for( $i = 0; $i < $totalRows_rsLingua; $i++ )
{
	// Array
	$labels[$row_rsLingua['labelname']] = $row_rsLingua['value_label'];
	
	// Go on
	$row_rsLingua = mysql_fetch_assoc($rsLingua);
}
	
	// Get Message
	$fileHandler = fopen("messaggio_".$_SESSION['idLanguage'].".html", "r");
	$stringaMessaggio = fread($fileHandler, filesize("messaggio_".$_SESSION['idLanguage'].".html"));
	
	// Prepare new Message
	mysql_select_db($database_database, $database);
	$query_rsCarrello = sprintf("SELECT * FROM carrello WHERE carrello.utente_carrello = %s", GetSQLValueString($_SESSION['kt_login_id'], "int"));
	$rsCarrello = mysql_query($query_rsCarrello, $database) or die(mysql_error());
	$row_rsCarrello = mysql_fetch_assoc($rsCarrello);
	$totalRows_rsCarrello = mysql_num_rows($rsCarrello);
	
	$newText = "<table width=\"100%\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\">";
	$newText .= "<tr>";
	$newText .= "<td width=\"10%\" bgcolor=\"#CCCCCC\" style=\"border:1px solid black\"><strong>".$labels['KEY_QUANTITA']."</strong></td>";
	$newText .= "<td width=\"20%\" bgcolor=\"#CCCCCC\" style=\"border:1px solid black\"><strong>".$labels['KEY_CODICE']."</strong></td>";
	$newText .= "<td width=\"40%\" bgcolor=\"#CCCCCC\" style=\"border:1px solid black\"><strong>".ucfirst($labels['KEY_DESCRIZIONE'])."</strong></td>";	
	$newText .= "<td bgcolor=\"#CCCCCC\" style=\"border:1px solid black\"><strong>".$labels['KEY_PREZZO']."</strong></td>";
	$newText .= "<td bgcolor=\"#CCCCCC\" style=\"border:1px solid black\"><strong>".$labels['KEY_TOTALE']."</strong></td>";
	$newText .= "</tr>";
	
	$totale = 0.00;
	$totaleA = 0.00;
	for( $i = 0; $i < $totalRows_rsCarrello; $i++ )
	{
		if( $row_rsCarrello['type_carrello'] == "articoli" )
		{
			mysql_select_db($database_catalogo, $catalogo);
			$query_rsArticoliCarrello = sprintf("SELECT * FROM articolo WHERE ID = %s", GetSQLValueString($row_rsCarrello['articolo_carrello'], "int"));
			$rsArticoliCarrello = mysql_query($query_rsArticoliCarrello, $catalogo) or die(mysql_error());
			$row_rsArticoliCarrello = mysql_fetch_assoc($rsArticoliCarrello);
			$totalRows_rsArticoliCarrello = mysql_num_rows($rsArticoliCarrello);	

			$prezzo_unitario = $row_rsArticoliCarrello['prezzo'];
			$codice = $row_rsArticoliCarrello['codice'];
			$descrizione = calcolaNome( $row_rsArticoliCarrello['descrizione'] );
			$prezzo = $row_rsArticoliCarrello['prezzo'];
			$totale = number_format( $row_rsCarrello['quantita_carrello'] * $row_rsArticoliCarrello['prezzo'], 2, ".", "," );
		}
		else if( $row_rsCarrello['type_carrello'] == "accessori" )
		{
			mysql_select_db($database_database, $database);
			$query_rsArticoliCarrello = sprintf("SELECT accessori.*, accessori_details.* FROM accessori JOIN accessori_details ON accessori_details.idaccessori_details = accessori.id_accessori WHERE language_details = %s AND id_accessori = %s", GetSQLValueString($_SESSION['idLanguage'], "int"), GetSQLValueString($row_rsCarrello['articolo_carrello'], "int"));
			$rsArticoliCarrello = mysql_query($query_rsArticoliCarrello, $database) or die(mysql_error());
			$row_rsArticoliCarrello = mysql_fetch_assoc($rsArticoliCarrello);
			$totalRows_rsArticoliCarrello = mysql_num_rows($rsArticoliCarrello);					

			$prezzo_unitario = $row_rsArticoliCarrello['prezzo_accessori'];
			$codice = $row_rsArticoliCarrello['codice_accessori'];
			$descrizione = calcolaNome( $row_rsArticoliCarrello['titolo_details'] );
			$prezzo = $row_rsArticoliCarrello['prezzo_accessori'];
			$totale = number_format( $row_rsCarrello['quantita_carrello'] * $row_rsArticoliCarrello['prezzo_accessori'], 2, ".", "," );
		}
		else if( $row_rsCarrello['type_carrello'] == "motore" )
		{
			mysql_select_db($database_database, $database);
			$query_rsArticoliCarrello = sprintf("SELECT * FROM motore WHERE ID = %s", GetSQLValueString($row_rsCarrello['articolo_carrello'], "int"));
			$rsArticoliCarrello = mysql_query($query_rsArticoliCarrello, $database) or die(mysql_error());
			$row_rsArticoliCarrello = mysql_fetch_assoc($rsArticoliCarrello);
			$totalRows_rsArticoliCarrello = mysql_num_rows($rsArticoliCarrello);					

			$prezzo_unitario = $row_rsArticoliCarrello['prezzo_motore'];
			$codice = $row_rsArticoliCarrello['codice_motore'];
			$descrizione = calcolaNome( $row_rsArticoliCarrello['nome'] );
			$prezzo = $row_rsArticoliCarrello['prezzo_motore'];
			$totale = number_format( $row_rsCarrello['quantita_carrello'] * $row_rsArticoliCarrello['prezzo_motore'], 2, ".", "," );
		}

		$newText .= "<tr>";
		$newText .= "<td style=\"border:1px solid black\">".$row_rsCarrello['quantita_carrello']."</td>";
		$newText .= "<td style=\"border:1px solid black\">".$codice."</td>";
		$newText .= "<td style=\"border:1px solid black\">".$descrizione."</td>";
		$newText .= "<td style=\"border:1px solid black\">&euro; ".$prezzo_unitario."</td>";
		$newText .= "<td style=\"border:1px solid black\">&euro; ".$totale."</td>";
		$newText .= "</tr>";

		$totaleA += $row_rsCarrello['quantita_carrello'] * $prezzo_unitario;
		$row_rsCarrello = mysql_fetch_assoc($rsCarrello);
	}

	$newText .= "<tr>";
	$newText .= "<td colspan=\"8\" align=\"right\" class=\"testoGen\"><hr size=\"1\" /></td>";
	$newText .= "</tr>";

	$newText .= "<tr>";
	$newText .= "<td colspan=\"3\">&nbsp;</td>";
	$newText .= "<td style=\"border:1px solid black\">".$labels['KEY_SUBTOTALE']."</td>";
	$newText .= "<td style=\"border:1px solid black\">&euro; ".number_format($totaleA, 2, ",", ".")."</td>";
	$newText .= "</tr>";

	$iva = $totaleA * 0.20;
	$tot = $totaleA + $iva;
	$newText .= "<tr>";
	$newText .= "<td colspan=\"3\">&nbsp;</td>";
	$newText .= "<td style=\"border:1px solid black\">".$labels['KEY_IVA']."</td>";
	$newText .= "<td style=\"border:1px solid black\">&euro; ".number_format($iva, 2, ",", ".")."</td>";
	$newText .= "</tr>";

	$newText .= "<tr>";
	$newText .= "<td colspan=\"3\">&nbsp;</td>";
	$newText .= "<td style=\"border:1px solid black\">".$labels['KEY_TOTALE']."</td>";
	$newText .= "<td style=\"border:1px solid black\">&euro; ".number_format($tot, 2, ",", ".")."</td>";
	$newText .= "</tr>";
	
	$newText .= "</table>";

	fclose($fileHandler);
	
	// Cliente
	mysql_select_db($database_database, $database);
	$query_rsUtente = sprintf("SELECT * FROM utenti WHERE id = %s", GetSQLValueString($_SESSION['kt_login_id'], "int"));
	$rsUtente = mysql_query($query_rsUtente, $database) or die(mysql_error());
	$row_rsUtente = mysql_fetch_assoc($rsUtente);
	$totalRows_rsUtente = mysql_num_rows($rsUtente);	
	
	// Substitute new Message
	$stringaMessaggio = str_replace("[CLIENTE_HERE]", $row_rsUtente['cognome_utente']." ".$row_rsUtente['nome_utente'], $stringaMessaggio);
	$stringaMessaggio = str_replace("[INDIRIZZO_HERE]", $row_rsUtente['indirizzo_utente'], $stringaMessaggio);
	$stringaMessaggio = str_replace("[CITTA_HERE]", $row_rsUtente['citta_utente']." (".$row_rsUtente['provincia_utente'].")", $stringaMessaggio);
	$htmlBody = str_replace("[MESSAGE_HERE]", $newText, $stringaMessaggio);
	
	// Message
	$mail->Subject = $subjectMail;
	$mail->MsgHTML($htmlBody);
	
	if( $mail->Send() )
	{
		// Prepare new Message
		mysql_select_db($database_database, $database);
		$query_rsCarrello = sprintf("DELETE FROM carrello WHERE carrello.utente_carrello = %s", GetSQLValueString($_SESSION['kt_login_id'], "int"));
		mysql_query($query_rsCarrello, $database) or die(mysql_error());
	}
}
//end Trigger_Custom trigger

// Make a custom transaction instance
$customTransaction = new tNG_custom($conn_database);
$tNGs->addTransaction($customTransaction);
// Register triggers
$customTransaction->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "GET", "op");
$customTransaction->registerTrigger("END", "Trigger_Default_Redirect", 99, "ok.php");
$customTransaction->registerTrigger("AFTER", "Trigger_Custom", 50);
// Add columns
// End of custom transaction instance

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

// Get the transaction recordset
$rscustom = $tNGs->getRecordset("custom");
$row_rscustom = mysql_fetch_assoc($rscustom);
$totalRows_rscustom = mysql_num_rows($rscustom);
?>
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Documento senza titolo</title>
<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>
<script language="javascript">
function cercanews()
{
	if( document.getElementById("search").value != "" )
		document.form3.submit();	
}

function clearCerca()
{
	document.getElementById( "search" ).value='';
}
</script>

</head>

<body>
<?php
	echo $tNGs->getErrorMsg();
?>
</body>
</html>