transaksi-apotik.php

<div align="center">
<a href="index.php" align="center">Kembali Ke Menu</a>
    <h2>Transaksi Toko Apotik Surya</h2>
        <form action="" method="post">
        <div>
            <label for="idtrans">Id Transaksi</label>
            <input type="text" name="idtrans">
        </div></p>
        <div>
            <label for="tgltrans">Tanggal Transaksi</label>
            <input type="datetime-local" name="tgltrans">
        </div></p>
        <div>
            <label for="kdobat">Kode Obat</label>
            <select name="kdobat" id="kdobat" onchange="getObat(this.value)">
            <option value="">-Pilih Kode Obat-</option>
                <?php

                    $getKodeObat = mysqli_query($koneksi, "SELECT * FROM obat");
                    $kodeArray = "var kdObat = new Array();\n";
                    while($rowKodeObat = mysqli_fetch_array($getKodeObat)) {
                        echo "<option name='kdobat' id='kdobat' value='$rowKodeObat[kdobat]'>$rowKodeObat[kdobat]</option>";
                        $kodeArray .= "kdObat['" . $rowKodeObat['kdobat'] . "'] = {nmobat:'" . addslashes($rowKodeObat['nmobat']) ."', hrgobat:'" . addslashes($rowKodeObat['hrgobat']) . "', stokobat:'" . addslashes($rowKodeObat['stokobat']) . "'};\n";
                    }

                ?>
            </select>
        </div></p>
        <div>
            <label for="nmobat">Nama Obat</label>
            <input type="text" name="nmobat" id="nmobat" readonly>
        </div></p>
        <div>
            <label for="hrgobat">Harga Obat</label>
            <input type="number" name="hrgobat" id="hrgobat" readonly>
        </div></p>
        <div>
            <label for="stokobat">Stok Obat</label>
            <input type="number" name="stokobat" id="stokobat" readonly>
        </div></p>
        <div>
            <label for="jmlbeli">Jumlah Beli</label>
            <input type="number" name="jmlbeli" id="jmlbeli" onkeyup="hitung()">
        </div></p>
        <div>
            <label for="total">Total</label>
            <input type="number" name="total" id="total" readonly>
        </div></p>
        <div>
            <label for="diskon">Diskon</label>
            <input type="number" name="diskon" id="diskon" readonly>
        </div></p>
        <div>
            <label for="totalbayar">Total Bayar</label>
            <input type="number" name="totalbayar" id="totalbayar" readonly>
        </div></p>
        <div>
            <input type="submit" name="simpan" value="Simpan Data Obat">
        </div></p>
    </form>
</div>
<br>
<p></p>
<h3 align="center">Daftar Obat Toko Apotik Surya</h3></p>
<div align="center">
    <table border="3">
        <tr>
            <th>No</th>
            <th>Id Transaksi</th>
            <th>Tanggal Transaksi</th>
            <th>Kode Obat</th>
            <th>Nama Obat</th>
            <th>Harga Obat</th>
            <th>Jumlah Beli</th>
            <th>Total</th>
            <th>Diskon</th>
            <th>Total Bayar</th>
            <th>Aksi</th>
        </tr>
        <?php

            $query = mysqli_query($koneksi, "SELECT obat.*, transaksi.* FROM transaksi JOIN obat ON transaksi.kdobat=obat.kdobat");
            $no = 1;

            while($row = mysqli_fetch_array($query)) {
                    echo "
                    <tr>
                        <td>$no</td>
                        <td>$row[idtrans]</td>
                        <td>$row[tgltrans]</td>
                        <td>$row[kdobat]</td>
                        <td>$row[nmobat]</td>
                        <td>$row[hrgobat]</td>
                        <td>$row[jmlbeli]</td>
                        <td>$row[total]</td>
                        <td>$row[diskon]</td>
                        <td>$row[totalbayar]</td>
                        <td>
                            <a href='?page=transaksidelete&idtrans=$row[kdobat]'>Hapus</a>
                        </td>
                    </tr>
                ";
                $no++;
            }

        ?>
    </table>
</div></p>

<script type="text/javascript">
    <?php echo $kodeArray; ?>

    function getObat(id) {
        document.getElementById('nmobat').value = kdObat[id].nmobat;
        document.getElementById('hrgobat').value = kdObat[id].hrgobat;
        document.getElementById('stokobat').value = kdObat[id].stokobat;

        // var namaObat = document.getElementById('nmobat').value
        // var hargaObat = document.getElementById('hrgobat').value
        // var jumlahBeli = document.getElementById('jmlbeli').value
        // var diskon = parseInt(hargaObat) + parseInt(jumlahBeli);

        // console.log(diskon);
    }

    function hitung() {
        var kodeObats = document.getElementById('kdobat').value
        var namaObat = document.getElementById('nmobat').value
        var hargaObat = document.getElementById('hrgobat').value
        var jumlahBeli = document.getElementById('jmlbeli').value
        var totals = parseInt(hargaObat) * parseInt(jumlahBeli);

        if(kodeObats === "P001") {
            var diskon = ((10 * parseInt(hargaObat) / 100) * parseInt(jumlahBeli));
        } else if(kodeObats ==="P002") {
            var diskon = ((15 * parseInt(hargaObat) / 100) * parseInt(jumlahBeli));
        } else if(kodeObats === "P003") {
            var diskon = ((20 * parseInt(hargaObat) / 100) * parseInt(jumlahBeli));
        }

        var totalBayar = (hargaObat * jumlahBeli) - diskon

        document.getElementById('total').value = totals
        document.getElementById('diskon').value = diskon
        document.getElementById('totalbayar').value = totalBayar
    }

</script>

<?php

if(isset($_POST['simpan'])) {
    $beli = $_POST['jmlbeli'];
    $query = mysqli_query($koneksi, "INSERT INTO transaksi (idtrans, tgltrans, kdobat, jmlbeli, total, diskon, totalbayar) VALUES ('$_POST[idtrans]', '$_POST[tgltrans]', '$_POST[kdobat]', '$_POST[jmlbeli]', '$_POST[total]', '$_POST[diskon]', '$_POST[totalbayar]')");


    if($query) {
        $updateStock = mysqli_query($koneksi, "UPDATE obat SET stokobat=stokobat-$beli WHERE kdobat='$_POST[kdobat]'");
        header("Refresh:0; url=index.php?page=transaksi");
        echo "Transaksi Berhasil";
    } else {
        echo "Transaksi Gagal";
    }

    header("Refresh:0; url=index.php?page=transaksi");
}