<?php session_start(); include('login_inc.php'); ?>
<?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 Restrict Access To Page
$restrict = new tNG_RestrictAccess($conn_azzurra, "");
//Grand Levels: Any
$restrict->Execute();
//End Restrict Access To Page

if (isset($_POST['submit_ftp'])) {
	$_POST['file_ftp'] = basename($_POST['file_ftp']);
}

//start Trigger_Custom trigger
function Trigger_Custom(&$tNG) {
	$filename_ftp = 'files_ftp/'.$_POST['file_ftp'];
	if (file_exists($filename_ftp)) {
		//rename($filename_ftp, "files/".$tNG->GetColumnValue('ID_file')."_".$_SESSION['kt_key']);
		copy($filename_ftp, "files/".$_POST['ID_order']."_".$tNG->GetColumnValue('ID_file')."_".$_SESSION['kt_key']);
		unlink($filename_ftp);
	} else { 
		$myErrorObjectName = new tNG_error("Il nome del file indicato non è presente nello spazio FTP.", array(), array());
		return $myErrorObjectName;
	}
}
//end Trigger_Custom trigger

// Start trigger
$formValidation = new tNG_FormValidation();
$formValidation->addField("filename", true, "text", "", "", "", "");
$tNGs->prepareValidation($formValidation);
// End trigger

if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $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;
}
}

$currentPage = $_SERVER["PHP_SELF"];

$maxRows_Rs_orders = 5;
$pageNum_Rs_orders = 0;
if (isset($_GET['pageNum_Rs_orders'])) {
  $pageNum_Rs_orders = $_GET['pageNum_Rs_orders'];
}
$startRow_Rs_orders = $pageNum_Rs_orders * $maxRows_Rs_orders;

$KTColParam1_Rs_orders = "0";
if (isset($_SESSION["kt_login_id"])) {
  $KTColParam1_Rs_orders = $_SESSION["kt_login_id"];
}
mysql_select_db($database_azzurra, $azzurra);
$query_Rs_orders = sprintf("SELECT orders.ID_order, orders.descr, orders.data, states.state_desc FROM (orders LEFT JOIN states ON states.ID_state=orders.ID_state) WHERE orders.ID_user=%s ORDER BY orders.ID_order DESC ", GetSQLValueString($KTColParam1_Rs_orders, "int"));
$query_limit_Rs_orders = sprintf("%s LIMIT %d, %d", $query_Rs_orders, $startRow_Rs_orders, $maxRows_Rs_orders);
$Rs_orders = mysql_query($query_limit_Rs_orders, $azzurra) or die(mysql_error());
$row_Rs_orders = mysql_fetch_assoc($Rs_orders);

if (isset($_GET['totalRows_Rs_orders'])) {
  $totalRows_Rs_orders = $_GET['totalRows_Rs_orders'];
} else {
  $all_Rs_orders = mysql_query($query_Rs_orders);
  $totalRows_Rs_orders = mysql_num_rows($all_Rs_orders);
}
$totalPages_Rs_orders = ceil($totalRows_Rs_orders/$maxRows_Rs_orders)-1;

$queryString_Rs_orders = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Rs_orders") == false && 
        stristr($param, "totalRows_Rs_orders") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Rs_orders = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_Rs_orders = sprintf("&totalRows_Rs_orders=%d%s", $totalRows_Rs_orders, $queryString_Rs_orders);

// Make an insert transaction instance
$ins_files1 = new tNG_insert($conn_azzurra);
$tNGs->addTransaction($ins_files1);
// Register triggers
$ins_files1->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "submit_ftp");
$ins_files1->registerTrigger("END", "Trigger_Default_Redirect", 99, "area_files.php?ID_order={POST.ID_order}&ID_user={GET.ID_user}");
$ins_files1->registerTrigger("AFTER", "Trigger_Custom", 50);
$ins_files1->registerTrigger("BEFORE", "Trigger_Default_FormValidation", 10, $formValidation);
// Add columns
$ins_files1->setTable("files");
$ins_files1->addColumn("ID_order", "NUMERIC_TYPE", "POST", "ID_order");
$ins_files1->addColumn("filename", "STRING_TYPE", "POST", "file_ftp", "");
$ins_files1->addColumn("descr", "STRING_TYPE", "POST", "desc_ftp", "");
$ins_files1->addColumn("ID_user", "NUMERIC_TYPE", "SESSION", "kt_login_id", "");
$ins_files1->setPrimaryKey("ID_file", "NUMERIC_TYPE");

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

// Get the transaction recordset
$rsfiles = $tNGs->getRecordset("files");
$row_rsfiles = mysql_fetch_assoc($rsfiles);
$totalRows_rsfiles = mysql_num_rows($rsfiles);
?>
<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">
        <?php include('tinymce_inc.php'); ?>
		<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" height="30"><img src="images/title_invio_ftp.gif" alt="" height="19" width="204" border="0"></td>
									  </tr>
										<tr>
											<td><img src="images/line_orizz.gif" alt="" height="33" width="435" border="0"></td>
										</tr>
                                      <form action="" method="post" name="form_ftp" id="form_ftp">
<tr>
											<td valign="top"><p><span class="grey12">Di seguito riportiamo i parametri per l'invio manuale dei files tramite FTP:<br>
                                                  <br>
                                                  <span class="orange12">Porta: </span>21<br>
                                                  <span class="orange12">Indirizzo:</span> ftp.azzurraprint.it<br>
                                                  <span class="orange12">Username:</span> azzurraftp <br>
                                                  <span class="orange12">Password:</span> azzurra<br>
                                                  <br>
                                                  <br>
Una volta inviati i files in FTP bisogna associarli al Vs. ordine tramite il seguente modulo: &egrave; necessario selezionare l'ordine, sfogliare il file inviato in FTP e dare una descrizione (opzionale). Per la gestione e la cancellazione dei files inviati basta andare nella sezione apposita <a class="box" href="area_orders.php"><strong>Gestione ordini</strong></a>.<br>
											  <br>
											  </span></p>
                                            <?php if ($totalRows_Rs_orders>0) {?>
                                            <table width="100%" border="0" cellspacing="0" cellpadding="3">
                                              <tr>
                                                <td align="right">Ordini visualizzati: da  <strong><?php echo ($startRow_Rs_orders + 1) ?></strong> a <strong><?php echo min($startRow_Rs_orders + $maxRows_Rs_orders, $totalRows_Rs_orders) ?></strong> per un totale di <strong><?php echo $totalRows_Rs_orders ?></strong> </td>
                                              </tr>
                                            </table>
											  <table width="100%" border="1" cellspacing="0" cellpadding="3">
                                              <tr bgcolor="#eeeeee">
                                                <td>&nbsp;</td>
                                                <td><strong>ID</strong></td>
                                                <td><strong>Data</strong></td>
                                                <td><strong>Stato</strong></td>
                                                <td><strong>Descrizione</strong></td>
                                                </tr>
                                                <?php $first_radio=1; ?>
											  <?php do { ?>
                                              <tr>
                                                <td valign="top" nowrap>
                                                  <input type="radio" name="ID_order" <?php if ($first_radio==1) { $first_radio=0; ?>checked<?php } ?> value="<?php echo $row_Rs_orders['ID_order']; ?>" id="RadioGroup_orders_<?php echo $row_Rs_orders['ID_order']; ?>">                                                </td>
                                                <td valign="top" nowrap><?php echo $row_Rs_orders['ID_order']; ?></td>
                                                <td valign="top" nowrap><?php echo $row_Rs_orders['data']; ?></td>
                                                <td valign="top" nowrap><?php echo $row_Rs_orders['state_desc']; ?></td>
                                                <td width="100%" valign="top"><?php echo $row_Rs_orders['descr']; ?></td>
                                              </tr>
                                                <?php } while ($row_Rs_orders = mysql_fetch_assoc($Rs_orders)); ?>
                                            </table>
										      <br>
                                              <table border="0" align="center">
                                            <tr>
                                              <td><?php if ($pageNum_Rs_orders > 0) { // Show if not first page ?>
                                                    <a href="<?php printf("%s?pageNum_Rs_orders=%d%s", $currentPage, 0, $queryString_Rs_orders); ?>"><img src="images/First.gif" title="Prima pagina" border=0></a>
                                                    <?php } // Show if not first page ?>
                                              </td>
                                              <td><?php if ($pageNum_Rs_orders > 0) { // Show if not first page ?>
                                                    <a href="<?php printf("%s?pageNum_Rs_orders=%d%s", $currentPage, max(0, $pageNum_Rs_orders - 1), $queryString_Rs_orders); ?>"><img src="images/Previous.gif" title="Pagina precedente" border=0></a>
                                                    <?php } // Show if not first page ?>
                                              </td>
                                              <td><?php if ($pageNum_Rs_orders < $totalPages_Rs_orders) { // Show if not last page ?>
                                                    <a href="<?php printf("%s?pageNum_Rs_orders=%d%s", $currentPage, min($totalPages_Rs_orders, $pageNum_Rs_orders + 1), $queryString_Rs_orders); ?>"><img src="images/Next.gif" title="Pagina successiva" border=0></a>
                                                    <?php } // Show if not last page ?>
                                              </td>
                                              <td><?php if ($pageNum_Rs_orders < $totalPages_Rs_orders) { // Show if not last page ?>
                                                    <a href="<?php printf("%s?pageNum_Rs_orders=%d%s", $currentPage, $totalPages_Rs_orders, $queryString_Rs_orders); ?>"><img src="images/Last.gif" title="Ultima pagina" border=0></a>
                                                    <?php } // Show if not last page ?>
                                              </td>
                                            </tr>
                                          </table>
                                          <br>
										  <table width="100%" border="0" cellspacing="0" cellpadding="0">
													<tr>
														<td><strong>Associazione file inviato in FTP (&gt; 10 MB):</strong></td>
													</tr>
											  </table>
												<table width="100%" border="1" cellspacing="0" cellpadding="3">
											  </table>
											<table width="100%" border="1" cellspacing="0" cellpadding="3">
                                            <tr>
                                              <td align="right" bgcolor="#eeeeee"><strong>File</strong></td>
                                              <td width="100%"><input type="file" name="file_ftp" id="file_ftp"></td>
                                            </tr>
                                            <tr>
                                              <td align="right" bgcolor="#eeeeee"><strong>Descrizione</strong></td>
                                              <td><textarea name="desc_ftp" id="desc_ftp" cols="50" rows="5" ></textarea></td>
                                            </tr>
                                            <tr>
                                              <td bgcolor="#eeeeee">&nbsp;</td>
                                              <td><input type="submit" name="submit_ftp" id="submit_ftp" value="Associa">
                                              <?php if (isset($_POST['submit_ftp'])) { echo $tNGs->getErrorMsg(); }; ?>
                                              </td>
                                            </tr>
                                          </table>											
            							    <span class="grey12">Le estensioni accettate sono: zip, rar, 7z, jpg, tif, doc, rtf, pdf, ai, ps, bmp, psd, txt, indd, cdr, ttf. <strong>Si consiglia in ogni caso di comprimere il/i file in formato ZIP.</strong><br>
                                            <br>
Utilizza prima la procedura di invio in FTP, poi sfoglia il file che hai trasferito, per associarlo al tuo ordine.</span>
            							    <?php } else { ?>
                                            	<br>
                                           	  <div align="center">Non ci sono ordini presenti.</div>
                                              <?php }; ?>
                              </td>
										</tr>
                                      </form>
									</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>
        <?php
	echo $tNGs->getErrorMsg();
?></body>

</html>
<?php
mysql_free_result($Rs_orders);
?>