Samuele E. Locatelli
69 lines
1.6 KiB
PHP
69 lines
1.6 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
|
|
|
|
include 'db.php';
|
|
$db = new MyDB();
|
|
if(!$db){
|
|
echo $db->lastErrorMsg();
|
|
} else {
|
|
// gestione vallori da URL
|
|
$newCat=$_GET[newCat];
|
|
$cmd=$_GET[cmd];
|
|
$oid=$_GET[oID];
|
|
|
|
// verifico se devo cancellare qualcosa
|
|
if($cmd=="del" && $oid!="")
|
|
{
|
|
$sql = "DELETE FROM Tipi WHERE ID = '$oid';";
|
|
$ret = $db->exec($sql);
|
|
if(!$ret){
|
|
error_log($db->lastErrorMsg());
|
|
} else {
|
|
echo "Categoria eliminata!";
|
|
}
|
|
}
|
|
// altrimenti verifico se devo aggiungere qualcosa
|
|
else if($newCat!="")
|
|
{
|
|
$sql = "INSERT INTO Tipi (ID) Values ('$newCat');";
|
|
$ret = $db->exec($sql);
|
|
if(!$ret){
|
|
error_log($db->lastErrorMsg());
|
|
} else {
|
|
echo "Categoria aggiunta!";
|
|
}
|
|
}
|
|
$sql = "SELECT t.ID AS TavID, SUM(l.Prezzo*o.Qta) as Tot FROM Tavoli T LEFT OUTER JOIN Ordini o ON t.ID=o.TavID LEFT OUTER JOIN Listino l ON o.ArtID = l.ID GROUP BY t.ID;";
|
|
|
|
$ret = $db->query($sql);
|
|
|
|
echo "<ul data-role=\"listview\" data-mini=\"true\" data-inset=\"true\">";
|
|
while($row = $ret->fetchArray(SQLITE3_ASSOC) ){
|
|
echo "<li><a href=\"conto.php?cID=".$row['TavID']."\">Tavolo ".$row['TavID']."<span class=\"ui-li-count\">".number_format($row['Tot'],2)." €</span></a></li>";
|
|
}
|
|
echo "</ul>";
|
|
|
|
$db->close();
|
|
}
|
|
|
|
|
|
?>
|
|
</form>
|
|
</div>
|
|
<?php include 'footer.php'; ?>
|
|
</div>
|
|
<script>
|
|
//App custom javascript
|
|
</script>
|
|
</body>
|
|
</html>
|