Samuele E. Locatelli (WEB DEV)
97 lines
2.8 KiB
PHP
97 lines
2.8 KiB
PHP
<!DOCTYPE html>
|
|
<html>
|
|
<head>
|
|
<?php include 'header.php'; ?>
|
|
</head>
|
|
<body>
|
|
<div data-role="page" id="page1" data-title="Cassa">
|
|
<?php include 'navbar.php'; ?>
|
|
<div data-role="content" style="padding: 5px">
|
|
<form>
|
|
<?php
|
|
$cid=$_GET[cID];
|
|
$cmd=$_GET[cmd];
|
|
$oid=$_GET[oID];
|
|
|
|
include 'db.php';
|
|
$db = new MyDB();
|
|
if(!$db){
|
|
echo $db->lastErrorMsg();
|
|
} else {
|
|
// gestione valori da URL
|
|
$newArt=$_GET[newArt];
|
|
$newPrezzo=$_GET[newPrezzo];
|
|
$articolo="";
|
|
$prezzo=$newPrezzo;
|
|
$mode="";
|
|
|
|
if($oid!="" && $cmd=="edit" && $mode=="")
|
|
{
|
|
$mode="upd";
|
|
$sql = "SELECT * FROM Listino WHERE ID =$oid;";
|
|
$ret = $db->query($sql);
|
|
while($row = $ret->fetchArray(SQLITE3_ASSOC) ){
|
|
$articolo=$row['Articolo'];
|
|
$prezzo=$row['Prezzo'];
|
|
}
|
|
}
|
|
else if($cid!="" && $cmd=="svuota" && $mode=="")
|
|
{
|
|
// eseguo query x svuotare il tavolo...
|
|
$sql = "DELETE FROM Ordini WHERE TavID=$cid";
|
|
$ret = $db->exec($sql);
|
|
if(!$ret){
|
|
error_log($db->lastErrorMsg());
|
|
} else {
|
|
echo "Tavolo liberato!";
|
|
}
|
|
}
|
|
?>
|
|
<div class="ui-grid-b">
|
|
<div class="ui-block-a"><p><a href="cassa.php" class="ui-btn ui-btn-icon-left ui-icon-arrow-l">Cassa</a></p></div>
|
|
<div class="ui-block-b" data-theme="b" data-role="header"><h4><?php echo "T.$cid"; ?></h4></div>
|
|
<div class="ui-block-c"><p><a href="comanda.php?setTav=<?php echo $cid; ?>" class="ui-btn ui-btn-icon-right ui-icon-arrow-r">Comanda</a></p></div>
|
|
</div><!-- /grid-b -->
|
|
<?php
|
|
|
|
// ora i dettagli
|
|
$sql = "SELECT l.Articolo, l.TipoID, SUM(o.Qta) as QtaTot, SUM(l.Prezzo*o.Qta) as Importo FROM Ordini o INNER JOIN Listino l ON o.ArtID = l.ID WHERE o.TavID=$cid GROUP BY Articolo,TipoID ORDER BY TipoID, Articolo;";
|
|
|
|
|
|
$ret = $db->query($sql);
|
|
|
|
echo "<ul data-role=\"listview\" data-mini=\"true\" data-inset=\"true\">";
|
|
while($row = $ret->fetchArray(SQLITE3_ASSOC) ){
|
|
echo "<li>".$row['TipoID']." | ".$row['QtaTot']." x ".$row['Articolo']."<p class=\"ui-li-aside\"><strong>".number_format($row['Importo'],2)."</strong> €</p></li>";
|
|
}
|
|
echo "</ul>";
|
|
|
|
// riporto il totale
|
|
$sql = "SELECT o.TavID, SUM(l.Prezzo*o.Qta) as Tot FROM Ordini o INNER JOIN Listino l ON o.ArtID = l.ID WHERE TavID=$cid;";
|
|
|
|
$ret = $db->query($sql);
|
|
|
|
echo "<ul data-role=\"listview\" data-mini=\"true\" data-inset=\"true\" data-theme=\"b\">";
|
|
while($row = $ret->fetchArray(SQLITE3_ASSOC) ){
|
|
echo "<li><a href=\"?cID=".$row['TavID']."&cmd=svuota\">Totale Tavolo ".$row['TavID']." (premere per liberare)<span class=\"ui-li-count\">".number_format($row['Tot'],2)." €</span></a></li>";
|
|
}
|
|
echo "</ul>";
|
|
|
|
$db->close();
|
|
}
|
|
|
|
// aggiunta di un button x stampare conto
|
|
echo "<a data-role=\"button\" href=\"printspool.php?cID=".$cid."\">STAMPA CONTO</a>";
|
|
|
|
|
|
?>
|
|
</form>
|
|
</div>
|
|
<?php include 'footer.php'; ?>
|
|
</div>
|
|
<script>
|
|
//App custom javascript
|
|
</script>
|
|
</body>
|
|
</html>
|