<?php
include "conn/koneksi.php";

$id =$_POST['id'];
$judul= $_POST['judul'];
$denda=$_POST['denda'];

if ($_POST['submit1']){
$us=mysql_query("UPDATE tbl_transaksi SET status='Kembali', denda='$denda' WHERE id='$id'")or die ("Gagal update".mysql_error());
$uj=mysql_query("UPDATE tbl_buku SET jumlah_buku=(jumlah_buku+1) WHERE judul='$judul'")or die ("Gagal update".mysql_error());

    if ($us || $uj) {
        echo "<script>alert('Berhasil Dikembalikan')</script>";
        echo "<meta http-equiv='refresh' content='0; url=?page=transaksi'>";
    } else {
        echo "<script>alert('Gagal Dikembalikan')</script>";
        echo "<meta http-equiv='refresh' content='0; url=?page=transaksi'>";
    }
    }
    else if ($_POST['submit2']){
$us=mysql_query("UPDATE tbl_transaksi SET status='hilang', denda=($denda+50000) WHERE id='$id'")or die ("Gagal update".mysql_error());

    if ($us) {
        echo "<script>alert('Buku hilang')</script>";
        echo "<meta http-equiv='refresh' content='0; url=?page=transaksi'>";
    } else {
        echo "<script>alert('Gagal Dikembalikan')</script>";
        echo "<meta http-equiv='refresh' content='0; url=?page=transaksi'>";
    }
    }
?>