<?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++; }