<?
include_once("dblibsec.inc");
include("clublibsec.inc");
$form["Data_Ordine"] = date("Y.m.d");
$form["Data_Scadenza"] = "0000-00-00";
// recupero i dati del cliente
$form = array_merge ($form, getRow($customers_table, "Ragione_Sociale", $form['Ragione_Sociale']));
$result = orderInsert($form['ID_Cliente'], $form['Protocollo'], $form['Cat_Ogg'], $form['Oggetto'], $form['Data_Ordine'], $form['Data_Scadenza'], $form['Tipo_Pagamento'], $form['Prezzo'], $form['Iva'], $form['Ragione_Sociale'], $form['Cognome'], $form['Nome'], $form['PI'], $form['CF'], $form['Indirizzo'], $form['Citta'], $form['CAP'], $form['Provincia'], $form['Telefono'], $form['Fax'], $form['E_mail'], $form['Status']);
if (! $result ){
die (" Error: ".mysql_error());
} else
{
echo "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\">
<html>
<head>
<title>Gestione Magazzino</title>
<link rel=\"stylesheet\" type=\"text/css\" href=\"stylesheet.css\">
</head>
<body bgcolor=\"#FFFFFF\" link=\"#504C43\" alink=\"#000000\" vlink=\"#504C43\" text=\"#000000\">";
include ("langselect.php");
include("Header.php");
echo"<p> </p>
<p> </p><table width=250 height=50 border=1 align=center cellpadding=1 cellspacing=0>
<td align=center>$lang0011 $form[Oggetto]</td>
<td align=center>$lang0010 $form[Protocollo]</td>
<td align=center>$lang0015 $form[Data_Ordine]</td>
</table>
<p></p>";
}
include ("config18.php");
mysql_connect("$hhost","$login","$pass") or die ("Problem connecting to DataBase");
$query = "SELECT * FROM $connect where oggnom='$oggnom' ";
$result = mysql_db_query("$dbname", $query);
if ($result) {
while ($r = mysql_fetch_array($result)) {
$quant = $r["quant"];
$oggnom = $r["oggnom"];
}
}
$tot = $quant - $form['Protocollo'];
$query = "update $connect set
quant='$tot' where
oggnom='$oggnom'";
?>
<form method="post" action="nuricbarcod.php" >
<!-- flag di invio del modulo -->
<input type="Hidden" name="actionflag" value="Invia">
<div align="center"><font class="FacetFormHeaderFont">Scegli il Catalogo e inserisci Codice a Barre </font></div>
<table border="0" cellpadding="3" cellspacing="1" class="FacetFormTABLE" align="center">
<!-- BEGIN Error -->
<tr>
<td colspan="2" class="FacetDataTD">
<?php
if (! $message == "")
{
print $message;
}
?>
</td>
</tr>
<!-- END Error -->
<input name="form[ID_Cliente]" type="hidden" value="<? echo $form['ID_Cliente']; ?>">
<tr><td>Scegli Catalogo</td>
<td><select name="form[connect]">
<option value="Nessuno" selected>Selezionare Prego</option>
<? include ("Admin_gestcatag.php"); ?>
</select></td>
</tr>
<tr><td>Codice a barre</td>
<td><input name="form[idart]" type="text" size="13" maxlength="13" ></td>
</tr>
<td colspan="2" align="right" nowrap class="FacetFooterTD">
<!-- BEGIN Button Insert --><input name="Insert" type="submit" value="Prosegui" class="FacetButton"><!-- END Button Insert -->
</td>
</table>
</form>
</body>
</html>