[Ask] Script untuk menampilkan sisa saldo pada program kredit motor..

[zard22]

Buat Para om PHP mohon bantuanya untuk script sisa saldo pda kredit motor...

Quote:<?php

switch($_GET['act']){
default:
?>
<h4>Data Pembelian Kredit</h4><p><form method='post' action="laporan.php?act=kredit" target='_blank'>
<input type='submit' value='Cetak Data'></form></p>
<form method='post' action="?mod=kredit&act=input">
<input type='submit' value='Tambah Data'></form>

<p></p>
<?php
$kredit = mysql_query("select * from belikredit order by kodekredit");
$row = mysql_num_rows($kredit);

if($row==0){
echo"Belum ada data";
}else{
?>
<table align='center' width='95%' border='1' cellpadding='0' cellspacing='0'>
<tr>
<td bgcolor="#FFFFFF" align="center">No</td>
<td bgcolor="#FFFFFF" align="center">Tanggal</td>
<td bgcolor="#FFFFFF" align="center">Nama</td>
<td bgcolor="#FFFFFF" align="center">Merk Motor</td>
<td bgcolor="#FFFFFF" align="center">Harga</td>
<td bgcolor="#FFFFFF" align="center">Detail</td>
</tr>
<?php
$co=1;
while($dat=mysql_fetch_row($kredit)){
$cust = mysql_fetch_array(mysql_query("select * from pelanggan where unik='$dat[6]'"));
$motr = mysql_fetch_array(mysql_query("select * from motor where unik='$dat[6]'"));
echo"
<tr>
<td align='center'>$co</td>
<td align='center'>$dat[1]</td>
<td>&nbsp;$cust[nama]</td>
<td>&nbsp;$motr[merk]</td>
<td align='right'>Rp. $motr[harga]</td>
<td align='center'><a href='?mod=kredit&act=detail&unik=$dat[6]'><u>Lihat</u></a></td>
</tr>
";
$co++;
}
echo"</table>";
}
break;

case"input":
?>
<form method="post" action="?mod=kredit_aksi&act=input">
<table width="95%">
<tr>
<td width="50%"><h4>Data Pelanggan</h4>
<table>
<tr>
<td>Nama</td>
<td>:</td>
<td><input type="text" name="nama"></td>
</tr><tr>
<td>Alamat</td>
<td>:</td>
<td><textarea name="alamat"></textarea></td>
</tr><tr>
<td>Telepon</td>
<td>:</td>
<td><input type="text" name="telepon"></td>
</tr><tr>
<td>HP</td>
<td>:</td>
<td><input type="text" name="hp"></td>
</tr><tr>
<td>Nomor KTP</td>
<td>:</td>
<td><input type="text" name="noktp"></td>
</tr><tr>
<td>KK</td>
<td>:</td>
<td><input type="checkbox" name="kk" value='Ya'>Ya</td>
</tr><tr>
<td>Slip Gaji</td>
<td>:</td>
<td><input type="checkbox" name="slip" value='Ya'>Ya</td>
</tr><tr>
<td>Ket</td>
<td>:</td>
<td><textarea name="ket"></textarea></td>
</tr>
</table>
</td>
<td><h4>Data Motor</h4>
<table>
<tr>
<td>Merk</td>
<td>:</td>
<td><input type="text" name="merk"></td>
</tr><tr>
<td>Warna</td>
<td>:</td>
<td><input type="text" name="warna"></td>
</tr><tr>
<td>Harga</td>
<td>:</td>
<td>Rp. <input type="text" name="harga"></td>
</tr><tr>
<td>Uang Muka</td>
<td>:</td>
<td>Rp. <input type="text" name="um"></td>
</tr><tr>
<td>Bunga</td>
<td>:</td>
<td><input type="text" name="bunga" size='3'> %</td>
</tr><tr>
<td>Lama Cicilan</td>
<td>:</td>
<td><input type='radio' name='lama' value='10'>10 Bulan <input type='radio' name='lama' value='20'>20 Bulan <input type='radio' name='lama' value='30'>30 Bulan </td>
</tr><tr>
<td>Ket</td>
<td>:</td>
<td><textarea name="ket2"></textarea></td>
</tr>
</table>
</td>
</tr>
</table>
<select name='dd'>
<option>Hari</option>
<?php
/*tanggal otomatis*/
for($i=1; $i<=31; $i++){
echo"<option value='$i'>$i</option>";
}
?>
</select>

<select name='mm'>
<option>Bulan</option>
<?php
/*tanggal otomatis*/
for($i=1; $i<=12; $i++){
echo"<option value='$i'>$i</option>";
}
?>
</select>

<select name='yy'>
<option>Tahun</option>
<?php
/*tanggal otomatis*/
for($i=2000; $i<=2020; $i++){
echo"<option value='$i'>$i</option>";
}
?>
</select><br />Catatan: <br /><textarea name="ket3"></textarea><br />
<input type="submit" value="Simpan">
</form>
<?php
break;

case"detail":
$cust = mysql_fetch_row(mysql_query("select * from pelanggan where unik='$_GET[unik]'"));
$motr = mysql_fetch_row(mysql_query("select * from motor where unik='$_GET[unik]'"));
$kredit = mysql_fetch_row(mysql_query("select * from belikredit where unik='$_GET[unik]'"));
echo"
<p> <a href='?mod=kredit&act=edit&unik=$_GET[unik]'>Edit Data</a> | <a href='?mod=kredit&act=hapus&unik=$_GET[unik]'>Hapus Data</a> | <a href='laporan.php?act=lap2&unik=$_GET[unik]' target='_blank'>Cetak Data</a> </p>
<table width='95%'>
<tr>
<td width='50%'><h4 align>Data Pelanggan $cust[1]</h4>
<table>
<tr>
<td>Nama</td>
<td>:</td>
<td>$cust[1]</td>
</tr><tr>
<td>Alamat</td>
<td>:</td>
<td>$cust[2]</td>
</tr><tr>
<td>Telepon</td>
<td>:</td>
<td>$cust[3]</td>
</tr><tr>
<td>HP</td>
<td>:</td>
<td>$cust[4]</td>
</tr><tr>
<td>Nomor KTP</td>
<td>:</td>
<td>$cust[5]</td>
</tr><tr>
<td>KK</td>
<td>:</td>
<td>$cust[6]</td>
</tr><tr>
<td>Slip Gaji</td>
<td>:</td>
<td>$cust[7]</td>
</tr><tr>
<td>Ket</td>
<td>:</td>
<td>$cust[8]</td>
</tr>
</table>
</td>
<td><h4 align='center'>Data Motor<br><br>
<table>
<tr>
<td>Merk</td>
<td>:</td>
<td>$motr[1]</td>
</tr><tr>
<td>Warna</td>
<td>:</td>
<td>$motr[2]</td>
</tr><tr>
<td>Harga</td>
<td>:</td>
<td>Rp. $motr[3]</td>
</tr><tr>
<td>Uang Muka</td>
<td>:</td>
<td>Rp. $kredit[2]</td>
</tr><tr>
<td>Bunga</td>
<td>:</td>
<td>$kredit[3] %</td>
</tr><tr>
<td>Lama Cicilan</td>
<td>:</td>
<td>$kredit[4] bulan</td>
</tr><tr>
<td>Ket</td>
<td>:</td>
<td>$motr[4]</td>
</tr>
</table>
</td>
</tr>
</table>
<p>Tanggal : $kredit[1]</p>
<p>Ket : $kredit[5]</p>
<h4 align='center'>Detail Cicilan</h4></p>
<table border='1' cellpadding='0' cellspacing='0' width='90%' align='center'>
<tr>
<th>Cicilan Ke</th>
<th>Pokok</th>
<th>Bunga</th>
<th>Total</th>
<th>Bayar</th>
</tr>
";
$sisa = $motr[3] - $kredit[2];
$pokok = $sisa / $kredit[4];
$bunga = ($sisa*$kredit[3])/100;
$total = $pokok + $bunga;
for($i=1; $i<=$kredit['4']; $i++){
$look = mysql_num_rows(mysql_query("select * from cicilan where unik='$_GET[unik]' and ke='$i'"));

echo"
<tr>
<td align='center'>$i</td>
<td align='right'>Rp. $pokok &nbsp;</td>
<td align='right'>Rp. $bunga &nbsp;</td>
<td align='right'>Rp. $total &nbsp;</td>
<td align='center'>";
if($look==0){
echo"<a href='?mod=bayar&act=input&ke=$i&unik=$_GET[unik]&bunga=$bunga&pokok=$pokok'>Bayar</a>";
}else{
echo"<a href='?mod=bayar&act=detail&ke=$i&unik=$_GET[unik]'>Sudah</a>";
}
echo"
</td>
</tr>
";
}
echo"</table>
";

break;

case"edit":
$cust = mysql_fetch_row(mysql_query("select * from pelanggan where unik='$_GET[unik]'"));
$motr = mysql_fetch_row(mysql_query("select * from motor where unik='$_GET[unik]'"));
$kredit = mysql_fetch_row(mysql_query("select * from belikredit where unik='$_GET[unik]'"));
$tgl = substr($kredit['1'],8,2);
$bln = substr($kredit['1'],5,2);
$thn = substr($kredit['1'],0,4);
echo"
<form method='post' action='?mod=kredit_aksi&act=edit'>
<input type=hidden name='unik' value='$_GET[unik]'>
<table width='95%'>
<tr>
<td width='50%'><h4>Edit Data Pelanggan $cust[1]</h4>
<table>
<tr>
<td>Nama</td>
<td>:</td>
<td><input type='text' name='nama' value='$cust[1]'></td>
</tr><tr>
<td>Alamat</td>
<td>:</td>
<td><textarea name='alamat'>$cust[2]</textarea></td>
</tr><tr>
<td>Telepon</td>
<td>:</td>
<td><input type='text' name='telepon' value='$cust[3]'></td>
</tr><tr>
<td>HP</td>
<td>:</td>
<td><input type='text' name='hp' value='$cust[4]'></td>
</tr><tr>
<td>Nomor KTP</td>
<td>:</td>
<td><input type='text' name='noktp' value='$cust[5]'></td>
</tr><tr>
<td>KK</td>
<td>:</td>
<td>$cust[6]</td>
</tr><tr>
<td>Slip Gaji</td>
<td>:</td>
<td>$cust[7]</td>
</tr><tr>
<td>Ket</td>
<td>:</td>
<td><textarea name='ket'>$cust[8]</textarea></td>
</tr>
</table>
</td>
<td><h4>Data Motor</h4>
<table>
<tr>
<td>Merk</td>
<td>:</td>
<td><input type='text' name='merk' value='$motr[1]'></td>
</tr><tr>
<td>Warna</td>
<td>:</td>
<td><input type='text' name='warna' value='$motr[2]'></td>
</tr><tr>
<td>Harga</td>
<td>:</td>
<td>Rp. <input type='text' name='harga' value='$motr[3]'></td>
</tr><tr>
<td>Uang Muka</td>
<td>:</td>
<td>Rp. <input type='text' name='um' value='$kredit[2]'></td>
</tr><tr>
<td>Bunga</td>
<td>:</td>
<td><input type='text' name='bunga' value='$kredit[3]' size='3'> %</td>
</tr><tr>
<td>Lama Cicilan</td>
<td>:</td>
<td><input type='text' name='lama' value='$kredit[4]' size='3'> bulan</td>
</tr><tr>
<td>Ket</td>
<td>:</td>
<td><textarea name='ket2'>$motr[4]</textarea></td>
</tr>
</table>
</td>
</tr>
</table>
<p>Tanggal :</p>
<p>
<select name='dd'>
<option>Hari</option>
";
/*tanggal otomatis*/
for($i=1; $i<=31; $i++){
if($i==$tgl){
echo"<option value='$i' selected>$i</option>";
}else{
echo"<option value='$i'>$i</option>";
}
}
echo"
</select>

<select name='mm'>
<option>Bulan</option>
";
/*tanggal otomatis*/
for($i=1; $i<=12; $i++){
if($i==$bln){
echo"<option value='$i' selected>$i</option>";
}else{
echo"<option value='$i'>$i</option>";
}
}
echo"
</select>

<select name='yy'>
<option>Tahun</option>
";
/*tanggal otomatis*/
for($i=2000; $i<=2020; $i++){
if($i==$thn){
echo"<option value='$i' selected>$i</option>";
}else{
echo"<option value='$i'>$i</option>";
}
}
echo"
</select>
</p>
<p>Ket : </p><p><textarea name='ket3'>$kredit[5]</textarea></p>
<input type='submit' value='Update'>
</form>
";
break;

case"hapus":
$cust = mysql_fetch_row(mysql_query("select * from pelanggan where unik='$_GET[unik]'"));
$motr = mysql_fetch_row(mysql_query("select * from motor where unik='$_GET[unik]'"));
$kredit = mysql_fetch_row(mysql_query("select * from belikredit where unik='$_GET[unik]'"));
echo"
<table width='95%'>
<tr>
<td width='50%'><h4>Hapus Data Pelanggan $cust[1]</h4>
<table>
<tr>
<td>Nama</td>
<td>:</td>
<td>$cust[1]</td>
</tr><tr>
<td>Alamat</td>
<td>:</td>
<td>$cust[2]</td>
</tr><tr>
<td>Telepon</td>
<td>:</td>
<td>$cust[3]</td>
</tr><tr>
<td>HP</td>
<td>:</td>
<td>$cust[4]</td>
</tr><tr>
<td>Nomor KTP</td>
<td>:</td>
<td>$cust[5]</td>
</tr><tr>
<td>KK</td>
<td>:</td>
<td>$cust[6]</td>
</tr><tr>
<td>Slip Gaji</td>
<td>:</td>
<td>$cust[7]</td>
</tr><tr>
<td>Ket</td>
<td>:</td>
<td>$cust[8]</td>
</tr>
</table>
</td>
<td><h4>Data Motor</h4>
<table>
<tr>
<td>Merk</td>
<td>:</td>
<td>$motr[1]</td>
</tr><tr>
<td>Warna</td>
<td>:</td>
<td>$motr[2]</td>
</tr><tr>
<td>Harga</td>
<td>:</td>
<td>Rp. $motr[3]</td>
</tr><tr>
<td>Ket</td>
<td>:</td>
<td>$motr[4]</td>
</tr>
</table>
</td>
</tr>
</table>
<p>Tanggal : $kredit[1]</p>
<p>Ket : $kredit[2]</p>
<p><em>Data yang dihapus tidak dapat dikembalikan lagi !!</em></p>
<p> <a href='?mod=kredit_aksi&act=hapus&unik=$_GET[unik]'>Ya</a> | <a href='?mod=kredit&act=detail&unik=$_GET[unik]'>Tidak</a> </p>
";
break;

}
?>

[/php]

[ditatompel]

ini pokok permasalahannya di mana omz?

[Bluecozza]

ini share apa ask???


gagagagaggggg