Devilzc0de Forum Follow @devilzc0de
  • Home
  • Hacking
  • Networking
  • Programming
  • O.S
  • Server
  • Tweets
  • Search
  • Member List
  • Calendar
Current time: 05-20-2013, 07:55 AM Hello There, Guest! (Login — Register)
Devilzc0de Forum › Information Technology › Programming › PHP v
« Previous 1 ... 14 15 16 17 18 ... 31 Next »

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

Home General Computer Multimedia Business Lounge

Post Reply 
Tweet
Threaded Mode | Linear Mode
Ask Script untuk menampilkan sisa saldo pada program kredit motor..
04-04-2012, 09:18 PM
Post: #1
zard22 Offline
./Devilz Officer
Posts: 157
Joined: Jul 2011
Reputation: 4
Script untuk menampilkan sisa saldo pada program kredit motor..
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]
Find all posts by this user
Quote this message in a reply
04-05-2012, 07:08 PM
Post: #2
ditatompel Offline
Administrator
*******
Administrators
Posts: 2,168
Joined: Dec 2010
Reputation: 367
RE: Script untuk menampilkan sisa saldo pada program kredit motor..
pusing
ini pokok permasalahannya di mana omz? bingung
Find all posts by this user
Quote this message in a reply
05-17-2012, 11:45 AM
Post: #3
Bluecozza Offline
./Devilz 1st Cadet
Posts: 5
Joined: May 2012
Reputation: 0
RE: Script untuk menampilkan sisa saldo pada program kredit motor..
ini share apa ask???


gagagagaggggg
Find all posts by this user
Quote this message in a reply
« Next Oldest | Next Newest »
Post Reply 


Topic Tools
Topic Link :
BBCode :
HTML Code :
View a Printable Version Send Thread to a Friend Subscribe to this thread
Submit Google Submit Face book Submit to Digg Submit to Reddit Submit to Furl Submit to Del.icio.us Submit to Jeqq

Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  [Ask] cara membuat data mining pada php? Keonx 2 57 Yesterday 06:12 PM
Last Post: Keonx
  [Ask] Ada Gk script auto unfollow all following? wildan123456 12 138 05-14-2013 12:58 PM
Last Post: Coziboy
  [Tutor] PHP untuk pemula bagian 1 777r 9 206 05-06-2013 03:47 PM
Last Post: Motaro Irhaby
  [Tutor] Membuat MP3 Player Pada Website dengan php Lucious Lawliet 18 259 05-01-2013 05:41 PM
Last Post: kenta
  [Tutor] script untuk import excel ke MySQL dellacroug 9 146 04-29-2013 11:33 AM
Last Post: Sixmart
  [Ask] Script file zip selalu muncul peringantan "Class 'ZipArchive' not found" Tamp4h 6 103 04-23-2013 11:04 AM
Last Post: Tamp4h
  [Tutor] [basic PHP] Operator pada PHP [newbie only] kidofdream 18 2,081 04-20-2013 10:55 PM
Last Post: kidofdream
Question [Solved] Fungsi Untuk PHP Shell abuabu_hat10 6 178 03-12-2013 01:53 PM
Last Post: abuabu_hat10
  [Tutor] Tipe Data Array pada PHP [basic PHP] kidofdream 22 1,318 02-20-2013 03:53 PM
Last Post: kidofdream
  [Tutor] [php] Did You Mean PHP Script Google hakimoxz 3 203 02-18-2013 11:50 AM
Last Post: sotbot

Users Browsing
1 Guest(s)

  • Contact Us
  • devilzc0de
  • Return to Top
  • Mobile Version
  • RSS Syndication
  • Help
Current time: 05-20-2013, 07:55 AM Powered By MyBB, © 2002-2013 MyBB Group. Theme created by Justin S. | Mixed By Chaer.Newbie | Fixed By Aditya

USING THIS SITE INDICATES THAT YOU HAVE READ AND ACCEPT OUR TERMS. IF YOU DO NOT ACCEPT THESE TERMS, YOU ARE NOT AUTHORIZED TO USE THIS SITE