-
Notifications
You must be signed in to change notification settings - Fork 1
/
daftar_pembelian.php
37 lines (36 loc) · 1.58 KB
/
daftar_pembelian.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
<?php
include_once "library/inc.sesadmin.php";
include_once "library/inc.library.php";
?>
<h2> DAFTAR TRANSAKSI PEMBELIAN </h2>
<table class="table-list" width="600" border="0" cellspacing="1" cellpadding="2">
<tr>
<td width="23" align="center" bgcolor="#CCCCCC"><b>No</b></td>
<td width="66" bgcolor="#CCCCCC"><b>Tanggal</b></td>
<td width="84" bgcolor="#CCCCCC"><b>Nomor Beli </b> </td>
<td width="180" bgcolor="#CCCCCC"><b>Supplier </b></td>
<td width="92" bgcolor="#CCCCCC"><b>Petugas</b></td>
<td width="44" align="center" bgcolor="#CCCCCC"><b>View</b></td>
</tr>
<?php
# Perintah untuk menampilkan Semua Daftar Transaksi Pembelian
$beliSql = "SELECT pembelian.*, supplier.nm_supplier FROM pembelian, supplier
WHERE pembelian.kd_supplier=supplier.kd_supplier
ORDER BY pembelian.no_pembelian ASC";
$beliQry = mysql_query($beliSql, $koneksidb) or die ("Query pembelian salah : ".mysql_error());
$nomor = 0;
while ($beliRow = mysql_fetch_array($beliQry)) {
$nomor++;
# Membaca Kode Pembelian/ Nomor transaksi
$Kode = $beliRow['no_pembelian'];
?>
<tr>
<td align="center"><?php echo $nomor; ?></td>
<td><?php echo IndonesiaTgl($beliRow['tgl_transaksi']); ?></td>
<td><?php echo $beliRow['no_pembelian']; ?></td>
<td><?php echo $beliRow['nm_supplier']; ?></td>
<td><?php echo $beliRow['userid']; ?></td>
<td align="center"><a href="?page=Daftar-Pembelian-List&Kode=<?php echo $Kode; ?>" target="_self" alt="Daftar Pembelian"><img src="images/btn_view.png" width="20" height="20" border="0" /></a></td>
</tr>
<?php } ?>
</table>