Samuele E. Locatelli
121 lines
3.9 KiB
PHP
121 lines
3.9 KiB
PHP
<!DOCTYPE html>
|
|
<html>
|
|
<head>
|
|
<?php include 'header.php'; ?>
|
|
</head>
|
|
<body>
|
|
<div data-role="page" id="page1" data-title="Listino">
|
|
<?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
|
|
$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'];
|
|
}
|
|
}
|
|
?>
|
|
<div class="ui-grid-a">
|
|
<div class="ui-block-a"><a href="categorie.php" class="ui-btn ui-btn-icon-left ui-icon-arrow-l">Ritorna</a></div>
|
|
<div class="ui-block-b"><h2><?php echo $cid; ?></h2></div>
|
|
</div><!-- /grid-a -->
|
|
<div class="ui-field-contain">
|
|
<label for="newArt"><?php if($cmd=="edit") { echo "Modifica"; } else { echo "Nuovo"; } ?></label>
|
|
<input name="newArt" id="newArt" value="<?php echo $articolo; ?>" type="text">
|
|
<input name="cID" id="cID" value="<?php echo $cid; ?>" type="hidden">
|
|
<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">
|
|
</div>
|
|
<div class="ui-field-contain">
|
|
<label for="newPrezzo">Prezzo:</label>
|
|
<input name="newPrezzo" id="newPrezzo" value="<?php echo $prezzo; ?>" type="number" min="1" max="99" step="0.1">
|
|
</div>
|
|
<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 Listino 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!="" && $newPrezzo!="")
|
|
{
|
|
if($mode=="upd")
|
|
{
|
|
$sql = "UPDATE Listino SET Articolo='$newArt',Prezzo='$newPrezzo' WHERE ID = $oid;";
|
|
$ret = $db->exec($sql);
|
|
if(!$ret){
|
|
error_log($db->lastErrorMsg());
|
|
} else {
|
|
echo "Articolo modificato!";
|
|
}
|
|
}
|
|
else
|
|
{
|
|
$sql = "INSERT INTO Listino (TipoID,Articolo,Prezzo) Values ('$cid','$newArt','$newPrezzo');";
|
|
$ret = $db->exec($sql);
|
|
if(!$ret){
|
|
error_log($db->lastErrorMsg());
|
|
} else {
|
|
echo "Articolo aggiunto!";
|
|
}
|
|
}
|
|
}
|
|
$sql = "SELECT * FROM Listino where TipoID='$cid' 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=\"listino.php?cID=".$cid."&cmd=edit&oID=".$row['ID']."\">".$row['Articolo']."<p class=\"ui-li-aside\"><strong>".number_format($row['Prezzo'],2)."</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>
|