<?php
if (!empty($_GET['message']) && $_GET['message'] == 'success') {
	echo '<h3>Berhasil meng-update data!</h3>';
} else if (!empty($_GET['message']) && $_GET['message'] == 'delete') {
	echo '<h3>Berhasil menghapus data!</h3>';
}
?>


<h3 align="center"><b>DATA PEMBELIAN CASH</b></h3>
<table border="1" cellpadding="5" cellspacing="0">
	<thead>
    	<tr bgcolor="#666666">
        	<td><font color="#FFFFFF">No</font></td>
        	<td><font color="#FFFFFF">Kode Cash</font></td>
        	<td><font color="#FFFFFF">Tanggal</font></td>
        	<td><font color="#FFFFFF">Pelanggan</font></td>
        	<td><font color="#FFFFFF">Merk Mobil</font></td>
        	<td><font color="#FFFFFF">Harga</font></td>
            <td><font color="#FFFFFF">Bayar</font></td>
            <td><font color="#FFFFFF">Keterangan</font></td>
			<td colspan="2" align="center"><font color="#FFFFFF">Opsi</font></td>
        </tr>
    </thead>
    <tbody>
    <?php
	$sql = ("select a.Kode_Cash, a.TanggalCash, b.Nama, c.Merk, c.Harga, a.Bayar, a.Keterangan from belicash a inner join pelanggan b using(Kode_Pelanggan) inner join mobil c using(Kode_Mobil) ORDER BY `a`.`Kode_Cash`");
$query = mysql_query($sql);

	$no = 1;
	while ($data = mysql_fetch_array($query)) {
	?>
    	<tr>
        	<td><?php echo $no; ?></td>
            <td>CSH<?php echo $data['Kode_Cash']; ?></td>
        	<td><?php echo $data['TanggalCash']; ?></td>
        	<td><?php echo $data['Nama']; ?></td>
        	<td><?php echo $data['Merk']; ?></td>
        	<td>Rp. <?php echo $data['Harga']; ?></td>
            <td>Rp. <?php echo $data['Bayar']; ?></td>
            <td><?php echo $data['Keterangan']; ?></td>
             <td align="center">
           	<a href="edit_cash.php?id=<?php echo $data['Kode_Cash']; ?>"><img src="images/atribut/edit.png" title="Ubah">
            </a>
            </td>
            <td align="center">
            <a href="delete_cash.php?id=<?php echo $data['Kode_Cash']; ?>"><img src="images/atribut/hapus.png" title="Hapus">
            </a>
            </td>
        </tr>
    <?php
		$no++;
	}
	?>
    </tbody>
</table>

<a href="input_belicash.php">+ Tambah Data Pembelian Cash</a>  ||  <a href="pengelolaan.php">Pengelolaan Admin</a>