}
echo "\t</table>\n\t\t\t\t\t\t\t\t\t\t<p><br /><br /></p>";
}
} else {
if ($_GET['link'] == 'conferma') {
$queryAcquistiIntest = "\tSELECT a.CodiceID, a.Data, a.Carrello, a.Registrato, a.Amministratore\n\t\t\t\t\t\t\t\t\t\t\t\t\tFROM Acquisti a JOIN Carrelli ca ON a.Carrello=ca.CodiceID JOIN Contiene co ON ca.CodiceID=co.Carrello JOIN Prodotti p ON co.Prodotto=p.CodiceID\n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE a.Amministratore IS NULL\n\t\t\t\t\t\t\t\t\t\t\t\t\tGROUP BY a.CodiceID;";
$acquistiIntest = mysql_query($queryAcquistiIntest, $conn) or die("Query fallita " . mysql_error($conn));
while ($row = mysql_fetch_row($acquistiIntest)) {
echo "\t<table>\n\t\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t<th>CodiceID</th>\n\t\t\t\t\t\t\t\t\t\t\t<th>Data</th>\n\t\t\t\t\t\t\t\t\t\t\t<th>Carrello</th>\n\t\t\t\t\t\t\t\t\t\t\t<th>Registrato</th>\n\t\t\t\t\t\t\t\t\t\t\t<th>Amministratore</th>\n\t\t\t\t\t\t\t\t\t\t</tr>";
echo_row($row);
echo "\t</table>\n\t\t\t\t\t\t\t\t\t\t<table>\n\t\t\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<th>CodiceProdotto</th>\n\t\t\t\t\t\t\t\t\t\t\t\t<th>Nome</th>\n\t\t\t\t\t\t\t\t\t\t\t\t<th>Quantita</th>\n\t\t\t\t\t\t\t\t\t\t\t</tr>";
$codiceAcquisto = $row[0];
$queryAcquisti = "\tSELECT p.CodiceID AS CodiceProdotto, p.Nome, co.Quantita\n\t\t\t\t\t\t\t\t\t\t\t\t\tFROM Acquisti a JOIN Carrelli ca ON a.Carrello=ca.CodiceID JOIN Contiene co ON ca.CodiceID=co.Carrello JOIN Prodotti p ON co.Prodotto=p.CodiceID\n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE a.Amministratore IS NULL;";
$acquisti = mysql_query($queryAcquisti, $conn) or die("Query fallita " . mysql_error($conn));
while ($row2 = mysql_fetch_row($acquisti)) {
echo_row($row2);
}
echo "\t</table>\n\t\t\t\t\t\t\t\t\t\t<p><br /><br /></p>";
}
echo "\n\t\t\t\t\t\t\t\t<form action=\"php/confirmpurchase.php\" method=\"get\">\n\t\t\t\t\t\t\t\t<fieldset>\n\t\t\t\t\t\t\t\t<legend>Inserisci Codice Acquisto da confermare</legend>\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t\t<label for=\"codice\">CodiceID</label>\n\t\t\t\t\t\t\t\t<input type=\"text\" id=\"codice\" name=\"codice\">\n\t\t\t\t\t\t\t\t</p>\n\n\t\t\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t\t<input type=\"submit\" value=\"Invia\">\n\t\t\t\t\t\t\t\t</p>\n\n\t\t\t\t\t\t\t\t</fieldset>\n\t\t\t\t\t\t\t\t</form>\n\t\t\t\t\t\t\t\t";
}
}
}
}
}
}
}
?>
</div>
<div id="push"></div>
echo_row('Help', 'Help', 'bt11', '1');
echo_row('Stop Proofreading', 'Stop Proofreading without Saving', 'bt1', '9');
echo_row("Save as 'Done'", "Save as 'Done'", 'bt13', '');
echo_row("Save as 'Done' & Proofread Next Page", "Save as 'Done' & Proofread Next Page", 'bt2', '8');
echo_row("Save as 'In Progress'", "Save as 'In Progress'", 'bt3', '7');
echo_row('Report Bad Page', 'Report Bad Page', 'bt14', '');
echo_row('Return Page to Current Round', 'Return Page to Current Round', 'bt15', '');
echo_row('Change Interface Layout', 'Change Interface Layout', 'bt4+bt5', '6');
// echo_row( 'Check for Common Errors', 'Check for Common Errors', 'bt6', '' );
echo_row('Run WordCheck', 'Run WordCheck', 'bt16', '');
echo_row('View Project Comments', 'View Project Comments', 'bt12', '');
echo_row('Show All Text', 'Show All Text', 'bt9', '');
echo_row('Undo Revert', 'Undo Revert', 'bt7', '');
echo_row('Revert to Original Document', 'Revert to Original Document', 'bt8', '');
echo_row('Refresh Image', 'Refresh Image', 'bt6', '');
echo_row('Set Image Zoom Percent', 'Set Image Zoom Percent', 'bt10', '');
?>
<TR><TD><B>Font Size</B>
<BR>Selection Menu</TD><TD>Select a point size (pt) for the current font
from the dropdown menu to change the font size of the proofreading text.
</TD></TR>
<TR><TD VALIGN="TOP"><B>Font Face</B>
<BR>Selection Menu</TD><TD>Select a named font from the dropdown menu. If the font is
installed on your system, the proofreading text will change to the selected font. If the
font is not installed on your system, your system will either automatically select a
font in the same family or leave the current font unchanged.
</TD></TR>
<p><input name="Elimina" type="submit" value="Elimina" /> <p>
</fieldset>
</form>
<?php
$ut = $_SESSION["username"];
$query = "SELECT Descrizione, Dataacquisto, Valore, Nomenegozio FROM Acquisto WHERE UtentePropr='{$ut}'";
$acq1 = mysql_query($query, $conn) or die("Query fallita" . mysql_error($conn));
function echo_row($row)
{
echo "<tr>";
foreach ($row as $field) {
echo "<td>{$field}</td>";
}
echo "</tr>";
}
echo "\n\t\t<table border=\"1\"><tr>\n\t\t<th>Descrizione</th>\n\t\t<th>Data</th>\n\t\t<th>Valore</th>\n\t\t<th>Negozio</th>\n\t\t</tr>";
while ($row = mysql_fetch_row($acq1)) {
echo_row($row);
}
echo "</table>";
?>
<?php
mysql_close($conn);
?>
</body>
</html>
