TUGAS TULIS WEB LAUNDRY

 

 

 

<?php

include "koneksi.php";

?>

<h1 class="mt-4">TRANSAKSI</h1>

    <form action="" method="POST">

    <div class="mb-3">

    Jenis Laundry  <select class="form-select" name="id_jenislaundry" id="">

            <?php

            $query = mysqli_query($koneksi, "select * from jenis_laundry");

            while ($data = mysqli_fetch_array($query)) {

                ?>

                <option value="<?php echo $data['id_jenislaundry']; ?>"><?php echo $data['nama_jenislaundry'] ?></option>

            <?php

            }

            ?>

        </select>

    </div>

    <div class="mb-3">

    <label class="form-label">Qty</label>

    <input type="text" class="form-control" name="qty">

    </div>

    <button class="btn btn-primary" name="simpan" type="submit">Simpan</button>

    </form>

    <form action="transaksi/cetak.php" method="POST">

    Nama  Konsumen:<div class="mb-3">

     <select class="form-select" name="kode_konsumen" id="">

            <?php

            $query = mysqli_query($koneksi, "select * from konsumen");

            while ($data = mysqli_fetch_array($query)) {

                ?>

                <option value="<?php echo $data['kode_konsumen']; ?>"><?php echo $data['nama_konsumen'] ?></option>

            <?php

            }

            ?>

        </select>

    </div>

<br>

        <button class="btn btn-danger" name="selesai" type="submit">Selesai</button>

    </form>

 

<?php

if (isset($_POST['simpan'])) {

    //menyimpan ke tabel

    $id_jenislaundry = $_POST['id_jenislaundry'];

    $qty = $_POST['qty'];

    $query = mysqli_query($koneksi, "insert into transaksi (id_jenislaundry,qty) values ('$id_jenislaundry','$qty')");

}

if (isset($_POST['selesai'])) {

    //membuat nota

    $kode_konsumen=$_POST['kode_konsumen'];

    $query=mysqli_query($koneksi,"select max(nota) as nota from transaksi");

    $data=mysqli_fetch_array($query);

    $nota=$data ['nota']+1;

    $user=$_SESSION['username'];  

    $query=mysqli_query($koneksi,"update transaksi set nota='$nota', status='1', username='$user' where status='0'");

}

?>

 

<hr>

<table class="table table-striped">

    <tr>

        <th>No</th>

        <th>Jenis Laundry</th>

        <th>Harga</th>

        <th>Qty</th>

        <th>Jumlah</th>

        <th>Aksi</th>

     </tr>

    <?php

    $query=mysqli_query($koneksi,"SELECT jenis_laundry.nama_jenislaundry, jenis_laundry.tarif, transaksi.id, transaksi.qty

    FROM jenis_laundry

    JOIN transaksi ON transaksi.id_jenislaundry = jenis_laundry.id_jenislaundry

    WHERE

    transaksi.status = 0");

    $total=0;

    $i = 1;

    while($data = mysqli_fetch_array($query)) {

    ?>

    <tr>

        <td><?php  echo  $i++ ?></td>

        <td><?php  echo  $data['nama_jenislaundry']  ?></td>

        <td><?php  echo  $data['tarif']  ?></td>

        <td><?php  echo  $data['qty']  ?></td>

        <td><?php  echo  $data['tarif']* $data['qty']  ?></td>

        <td><button class="btn btn-warning"><a style="color: white; text-decoration: none;" href="?page=transaksi/hapus&id=<?php echo $data['id']?>">Hapus</a></button></td>

    </tr>

<?php

    $total=$total + ($data['tarif']*$data['qty']);

    }

?>

<tr>

    <th colspan="4">Total</th>

    <th><?php echo $total; ?></th>

    <td></td>

</tr>

</table>

 

 

Perhatikan Tampilan web diatas

1.       Tuliskan dibuku tugas kalian skrip untuk menghasilkan form jenis laundry!

2.       Tuliskan dibuku tugas kalian skrip untuk menghasilkan tabel!

3.       Tuliskan dibuku tugas kalian skrip untuk menghasilkan form nama konsumen!

4.       Apa fungsi dari skrip yang tercetak berwarna kuning?