Samuele E. Locatelli
72 lines
1.8 KiB
PHP
72 lines
1.8 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>
|
|
<div class="ui-field-contain">
|
|
<label for="newCat">Nuova categoria:</label>
|
|
<input name="newCat" id="newCat" value="" type="text">
|
|
</div>
|
|
<?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.*, COUNT(l.ID) as num FROM Tipi t LEFT OUTER JOIN Listino l ON t.ID=l.TipoID GROUP BY t.ID ORDER 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=\"listino.php?cID=".$row['ID']."\">".$row['ID']."<span class=\"ui-li-count\">".$row['num']."</span></a><a href=\"?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>
|