<?php
//dialog untuk edit
if ($_GET['edit'] == "true") {
include "page/pelanggan_edit.php";
}
//pembagian data per halaman 10 baris.
$halaman = get_Halaman("pelanggan");
$hal = get_NomorHalaman($_GET['hal']);
$query = mysql_query("select * from pelanggan LIMIT {$hal} , 10");
?>
<center>
<h1>
Data Pelanggan
</h1>
<table border='0' width='1100px'>
<tr class="tr_grid" align="center" height="40">
<td>Kode Pelanggan </td>
<td>Nama</td>
<td>Alamat</td>
<td>Telepon</td>
<td>HP</td>
<td>No KTP</td>
<td>KK</td>
<td width="100">Slip gaji</td>
<td>Action</td>
</tr>
<?php
$i = 1;
while ($data = mysql_fetch_array($query)) {
echo "<tr bgcolor='#CCCCCC' align='center' height='30' id='tabel'>\n \t\t<td>{$data['KodeCust']}</td>\n\t\t<td>{$data['Nama']}</td>\n\t\t<td>{$data['Alamat']}</td>\n\t\t<td>{$data['Telepon']}</td>\n\t\t<td>{$data['HP']}</td>\n\t\t<td>{$data['NoKTP']}</td>\n\t\t<td>{$data['KK']}</td>\n\t\t<td>Rp. {$data['SlipGaji']}</td>\n\t\t<td width='90'>\n\t\t<a href='?page=view_pelanggan&edit=true&id={$data['KodeCust']}'>[Edit]</a>\n\t\t<a href=proses.php?tipe=hapusPelanggan&id='{$data['KodeCust']}' onclick='return confirm(\"Hapus {$data['KodeCust']} ?\")'>[Hapus]</a></td>\n</tr>";
<?php
//pembagian data per halaman 10 baris.
$halaman = get_Halaman("mobil");
$hal = get_NomorHalaman($_GET['hal']);
//shorting
$short = $_GET['short'];
if ($short == "") {
$short = "ASC";
}
$cari = $_REQUEST['txtCari'];
$sql = "select * from mobil ORDER BY `mobil`.`Kodemobil` {$short} LIMIT {$hal} , 10";
if ($cari != "") {
$sql = "select * from mobil where Merk like '%{$cari}%' ORDER BY `mobil`.`Kodemobil` ASC";
}
if ($_GET['short'] && $_GET['by'] != "") {
$sql = "SELECT * FROM mobil ORDER BY mobil.{$_GET['by']} {$short} LIMIT {$hal} , 10";
}
switch ($short) {
case 'ASC':
$short = "DESC";
break;
case 'DESC':
$short = "ASC";
break;
}
$query = mysql_query($sql);
if ($_GET['edit'] == "true") {
include "page/mobil_edit.php";
}
?>
<?php
if ($_GET['edit'] == "true") {
include "page/belicash_edit.php";
}
$halaman = get_Halaman("belicash");
$hal = get_NomorHalaman($_GET['hal']);
$sql = "select a.KodeCash, a.Tanggalcash, b.Nama, c.Merk, a.Harga, a.Bayar, a.Keterangan from belicash a inner join pelanggan b using(KodeCust) inner join mobil c using(Kodemobil) ORDER BY `a`.`KodeCash` DESC LIMIT {$hal} , 10";
$query = mysql_query($sql);
?>
<center><h1>Data Beli Cash</h1></center>
<table border='0' width='1100px'>
<tr class="tr_grid" align="center" height="40">
<td>No</td>
<td>Kode Cash</td>
<td>Tanggal</td>
<td>Pelanggan</td>
<td>Merek</td>
<td>Harga</td>
<td>Bayar</td>
<td>Ket</td>
<td>Action</td>
</tr>
<?php
$i = 1 * $hal + 1;
while ($data = mysql_fetch_array($query)) {
$nomor = $i;
echo "<tr bgcolor='#CCCCCC' align='center' height='30' id='tabel'>\n \t\t<td>{$i}</td>\n \t\t<td>{$data['KodeCash']}</td>\n\t\t<td>{$data['Tanggalcash']}</td>\n\t\t<td>{$data['Nama']}</td>\n\t\t<td>{$data['Merk']}</td>\n\t\t<td>Rp. {$data['Harga']}</td>\n\t\t<td>Rp. {$data['Bayar']}</td>\n\t\t<td>{$data['Keterangan']}</td>\n\t\t<td>\n\t\t\t<a href='?page=belicash_view&id={$data['KodeCash']}&edit=true'>[Edit]</a>\n\t\t\t<a href=proses.php?tipe=hapusBeliCash&id={$data['KodeCash']} onclick='return confirm(\"Hapus {$data['KodeCash']}?\")'>[Hapus]</a></a>\n\t\t</td>\n</tr>";
$i++;
}
?>
<?php
$halaman = get_Halaman("belikredit");
$hal = get_NomorHalaman($_GET['hal']);
?>
<h1 align="center">Daftar Beli Kredit</h1>
<table width="1100" border="0" id="tabel">
<tr align="center" valign="middle" class="tr_grid" height="40">
<td>No</td>
<td>Kode Kredit</td>
<td>Tanggal Kredit</td>
<td>Nama Pelanggan</td>
<td>Merk</td>
<td>Harga</td>
<td>Uang Muka</td>
<td>Bunga</td>
<td>Cicilan</td>
<td>Angsuran ke</td>
<td>Telah Bayar</td>
<td>Sisa</td>
<td>Keterangan</td>
<td>Action</td>
</tr>
<?php
$sql = "select belikredit.KodeKredit,belikredit.TanggalKredit, pelanggan.Nama, mobil.Merk, belikredit.Harga, belikredit.UangMuka, belikredit.Bunga, belikredit.LamaCicilan, belikredit.AngsuranKe, belikredit.TelahBayar, belikredit.Sisa, Belikredit.Keterangan from belikredit inner join pelanggan using (KodeCust) inner join mobil using (Kodemobil)";
$query = mysql_query($sql);
$i = 1;
while ($data = mysql_fetch_array($query)) {
echo "\n \t<tr bgcolor='#CCCCCC' align='center' height='30'>\n <td>{$i}</td>\n\t<td>{$data['KodeKredit']}</td>\n <td>{$data['TanggalKredit']}</td>\n <td>{$data['Nama']}</td>\n <td>{$data['Merk']}</td>\n <td>Rp {$data['Harga']}</td>\n <td>Rp {$data['UangMuka']}</td>\n <td>{$data['Bunga']}%</td>\n <td>{$data['LamaCicilan']}x</td>\n <td>{$data['AngsuranKe']}</td>\n <td>Rp {$data['TelahBayar']}</td>\n <td>Rp {$data['Sisa']}</td>\n <td>{$data['Keterangan']}</td>\n\t<td><a href='?page=beliKredit_view&id={$data['KodeKredit']}&edit=true'>[Edit]</a><a href='#'>[Hapus]</a></td>\n </tr>";
$i++;
}
