<?
php
include '[Link]';
session_start();
if (!isset($_SESSION['loginpa'])) {
header("Location: [Link]");
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Contoh Website</title>
<link rel="stylesheet" href="[Link]" />
</head>
<body>
<header>
<h1>Selamat Datang di Website Kami</h1>
</header>
<ul>
<li><a href="#">About</a></li>
<li><a href="kelola_produk.php">Kelola Produk</a></li>
<li><a href="kelola_petugas.php">Kelola Petugas</a></li>
<li><a href="kelola_penjualan.php">Kelola Penjualan</a></li>
<li><a href="[Link]">Beranda</a></li>
<li><a href="logout_petugas.php">Logout</a></li>
</ul>
<h2 align="center">DATA PRODUK</h2>
<div class="table-container">
<div>
<a href="input_penjualan.php"><input type="submit" value="TAMBAH"></a>
</div>
<table>
<thead>
<tr>
<th>No</th>
<th>Nama Produk</th>
<th>Jumlah Produk</th>
<th>Total Bayar</th>
<th>Tanggal Beli</th>
<th>Nama Petugas</th>
<th>Aksi</th>
</tr>
</thead>
<tbody>
<?php
$no = 1;
$query = mysqli_query($koneksi, "SELECT tbl_penjualan.*,
tbl_produk.nama_produk, tbl_petugas.nama_petugas
FROM tbl_penjualan
INNER JOIN tbl_produk ON tbl_penjualan.id_produk =
tbl_produk.id_produk
INNER JOIN tbl_petugas ON tbl_penjualan.id_petugas =
tbl_petugas.id_petugas
ORDER BY tbl_penjualan.id_penjualan DESC");
while ($data = mysqli_fetch_assoc($query)) {
?>
<tr>
<td><?php echo $no++; ?></td>
<td><?php echo $data['nama_produk']; ?></td>
<td><?php echo $data['jumlah_produk']; ?></td>
<td><?php echo $data['total_bayar']; ?></td>
<td><?php echo $data['tgl_beli']; ?></td>
<td><?php echo $data['nama_petugas']; ?></td>
<td>
<a href="ubah_penjualan.php?id_penjualan=<?php echo
$data['id_penjualan']; ?>">
<input type="submit" value="UBAH" name="btnUbah">
</a>
<a class="tombol" href="hapus_penjualan.php?
id_penjualan=<?php echo $data['id_penjualan']; ?>"
onclick="return confirm('Yakin akan menghapus
Data?')">Hapus</a>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
<footer>
<p>© 2024 WebsiteKu. All rights reserved.</p>
</footer>
</body>
</html>