Samuele E. Locatelli
156 lines
4.8 KiB
PHP
156 lines
4.8 KiB
PHP
<!DOCTYPE html>
|
|
<html>
|
|
<head>
|
|
<?php include 'header.php'; ?>
|
|
</head>
|
|
<body>
|
|
<div data-role="page" id="page1" data-title="Comanda">
|
|
<?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 vallori da URL
|
|
$reqReset=$_GET[btnReset];
|
|
$newCID=$_GET[selCID];
|
|
$newArt=$_GET[selArt];
|
|
$newQta=$_GET[newQta];
|
|
$newNote=$_GET[newNote];
|
|
$note="";
|
|
$qta=$newQta;
|
|
$mode="";
|
|
|
|
if ( $reqReset == 'Reset') {
|
|
$cmd="";
|
|
$newCID="";
|
|
}
|
|
|
|
if($oid!="" && $cmd=="edit" && $mode=="")
|
|
{
|
|
$mode="upd";
|
|
$sql = "SELECT * FROM Ordini WHERE ID =$oid;";
|
|
$ret = $db->query($sql);
|
|
while($row = $ret->fetchArray(SQLITE3_ASSOC) ){
|
|
$note=$row['Note'];
|
|
$qta=$row['Qta'];
|
|
}
|
|
}
|
|
?>
|
|
<ul data-role="listview" data-inset="true">
|
|
<li class="ui-field-contain">
|
|
<fieldset data-role="controlgroup" data-type="horizontal" data-mini="true">
|
|
<button id=btnSet" class="ui-btn ui-icon-arrow-r ui-btn-icon-right">sel</button>
|
|
<select name="selCID" id="selCID" onchange="this.form.submit();">
|
|
<?php
|
|
if($newCID!="")
|
|
{
|
|
echo "<option value=".$newCID.">".$newCID."</option>";
|
|
}
|
|
else
|
|
{
|
|
$sql="SELECT * FROM Tipi ORDER BY ID;";
|
|
$ret = $db->query($sql);
|
|
while($row = $ret->fetchArray(SQLITE3_ASSOC) ){
|
|
echo "<option value=".$row['ID'].">".$row['ID']."</option>";
|
|
}
|
|
}
|
|
?>
|
|
</select>
|
|
<select name="selArt" id="selArt">
|
|
<?php
|
|
$sql="SELECT * FROM Listino WHERE TipoID='$newCID' ORDER BY Articolo;";
|
|
$ret = $db->query($sql);
|
|
while($row = $ret->fetchArray(SQLITE3_ASSOC) ){
|
|
echo "<option value=".$row['ID'].">".$row['Articolo']."</option>";
|
|
}
|
|
?>
|
|
</select>
|
|
<button name="btnReset" value="Reset" class="ui-btn ui-icon-delete ui-btn-icon-left">res</button>
|
|
</fieldset>
|
|
</li>
|
|
<li class="ui-field-contain">
|
|
<label for="newQta">Quantità</label>
|
|
<input name="newQta" id="newQta" value="<?php echo $qta; ?>" type="number" min="0.1" max="99" step="0.1">
|
|
<input name="oID" id="oID" value="<?php echo $oid; ?>" type="hidden">
|
|
<input name="cmd" id="cmd" value="<?php echo $cmd; ?>" type="hidden">
|
|
<input name="mode" id="mode" value="<?php echo $mode; ?>" type="hidden">
|
|
</li>
|
|
<li class="ui-field-contain">
|
|
<label for="newNote">Note:</label>
|
|
<textarea name="newNote" rows="3" id="newNote" value="<?php echo $note; ?>"></textarea>
|
|
</li>
|
|
<li class="ui-body ui-body-a">
|
|
<fieldset class="ui-grid-a">
|
|
<div class="ui-block-a"><button class="ui-btn ui-corner-all ui-btn-a" type="reset">Annulla</button></div>
|
|
<div class="ui-block-b"><button class="ui-btn ui-corner-all ui-btn-a" type="submit">Salva</button></div>
|
|
</fieldset>
|
|
</li>
|
|
<?php
|
|
|
|
// verifico se devo fare operazioni
|
|
if($oid!="" && $cmd=="del")
|
|
{
|
|
$sql = "DELETE FROM Ordini WHERE ID = '$oid';";
|
|
$ret = $db->exec($sql);
|
|
if(!$ret){
|
|
error_log($db->lastErrorMsg());
|
|
} else {
|
|
echo "Articolo eliminato!";
|
|
}
|
|
}
|
|
// altrimenti verifico se devo aggiungere o modificare qualcosa
|
|
else if($newArt!="" && $newQta!="")
|
|
{
|
|
if($mode=="upd")
|
|
{
|
|
//$sql = "UPDATE Listino SET Articolo='$newArt',Prezzo='$newQta' WHERE ID = $oid;";
|
|
//$ret = $db->exec($sql);
|
|
//if(!$ret){
|
|
// error_log($db->lastErrorMsg());
|
|
//} else {
|
|
// echo "Articolo modificato!";
|
|
//}
|
|
}
|
|
else
|
|
{
|
|
$sql = "INSERT INTO Ordini (TavID,Cameriera,ArtID,Qta,Note) Values ($_SESSION[tavolo],'$_SESSION[cameriera]','$newArt',$newQta,'$newNote');";
|
|
$ret = $db->exec($sql);
|
|
if(!$ret){
|
|
error_log($db->lastErrorMsg());
|
|
} else {
|
|
echo "Articolo aggiunto!";
|
|
}
|
|
}
|
|
}
|
|
$sql = "SELECT o.*, l.Articolo FROM Ordini o INNER JOIN Listino l ON o.ArtID = l.ID WHERE TavID=$_SESSION[tavolo] ORDER BY Articolo;";
|
|
$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=\"comanda.php?cID=".$cid."&cmd=edit&oID=".$row['ID']."\">".$row['Articolo']." (".$row['Note'].")<p class=\"ui-li-aside\"><strong>".$row['Qta']."</strong></p></a><a href=\"?cID=".$cid."&cmd=del&oID=".$row['ID']."\" data-icon=\"delete\" onclick=\"return confirm('Sicuro di voler cancellare?');\"></a></li>";
|
|
}
|
|
echo "</ul>";
|
|
|
|
$db->close();
|
|
}
|
|
|
|
|
|
?>
|
|
</form>
|
|
</div>
|
|
<?php include 'footer.php'; ?>
|
|
</div>
|
|
<script>
|
|
//App custom javascript
|
|
</script>
|
|
</body>
|
|
</html>
|