Bunga Tabungan

"Yes") { //echo $_SESSION['username']; ?> '$tgl_transaksi'"; $hasil_2 = mysqli_query($koneksi, $query_2) or die("Kesalahan pada query!2"); list($total_simpanan) = mysqli_fetch_row($hasil_2); $per1rupiah=($_POST[nominal_dibagi])/$total_simpanan; //echo $per1rupiah."
"; switch ($_POST[kode_desa]){ case "001" : $query6 = "SELECT id_pel,sum(rupiah_simpanan) saldo FROM simpanan where substring(kode_rek,6,3)='001' and tgl_simpanan<='$tgl_transaksi' group by id_pel" ; //echo $query6; $hasil6 = mysqli_query($koneksi, $query6) or die("Kesalahan pada query!"); while (list($id_pel,$saldo) = mysqli_fetch_row($hasil6)) { // echo $saldo."--
"; $rp = $saldo*$per1rupiah; //echo $rp; $q_stok1 = "INSERT INTO tbl_bku (kode_rek,kode_rek_induk,kode_rek_detail,tgl_transaksi,uraian_transaksi,jenis_transaksi,rupiah_masuk,rupiah_keluar,asal_rekening,keterangan,userid) VALUES ( '2', '05', '".addslashes($_POST[kode_desa])."', '$tgl_transaksi', '$id_pel', 'DEBET', $rp, 0, '$asal_rekening', '".addslashes($_POST[keterangan])."', '".$_POST[userid]."' )"; //echo $q_stok1; $hasil_stok1 = mysqli_query($koneksi,$q_stok1) or die('Kesalahan Query Pada Query Stok!'); } $query7 = "SELECT tgl_transaksi,uraian_transaksi,rupiah_masuk FROM tbl_bku where tgl_transaksi='$tgl_transaksi' and kode_rek='2' and kode_rek_induk='05' and kode_rek_detail='001'" ; //echo $query6; $hasil7 = mysqli_query($koneksi, $query7) or die("Kesalahan pada query!"); while (list($tgl_transaksi,$uraian_transaksi,$rupiah_masuk) = mysqli_fetch_row($hasil7)) { $q_stok2 = "INSERT INTO simpanan (id_pel,kode_rek,tgl_simpanan,rupiah_simpanan,keterangan,userid) VALUES ( '$uraian_transaksi', '2.05.001', '$tgl_transaksi', $rupiah_masuk, 'nisbah.$tgl_transaksi', '".$_POST[userid]."' )"; //echo $q_stok1; $hasil_stok2 = mysqli_query($koneksi,$q_stok2) or die('Kesalahan Query Pada Query Stok!'); } break; case "002" : $query6 = "SELECT id_pel,sum(rupiah_simpanan) saldo FROM simpanan where substring(kode_rek,6,3)='002' and tgl_simpanan<='$tgl_transaksi' group by id_pel" ; //echo $query6; $hasil6 = mysqli_query($koneksi, $query6) or die("Kesalahan pada query!"); while (list($id_pel,$saldo) = mysqli_fetch_row($hasil6)) { $rp = $saldo*$per1rupiah; $q_stok1 = "INSERT INTO tbl_bku (kode_rek,kode_rek_induk,kode_rek_detail,tgl_transaksi,uraian_transaksi,jenis_transaksi,rupiah_masuk,rupiah_keluar,asal_rekening,keterangan,userid) VALUES ( '2', '05', '".addslashes($_POST[kode_desa])."', '$tgl_transaksi', '$id_pel', 'DEBET', $rp, 0, '$asal_rekening', '".addslashes($_POST[keterangan])."', '".$_POST[userid]."' )"; //echo $q_stok1; $hasil_stok1 = mysqli_query($koneksi,$q_stok1) or die('Kesalahan Query Pada Query Stok!'); } $query7 = "SELECT tgl_transaksi,uraian_transaksi,rupiah_masuk FROM tbl_bku where tgl_transaksi='$tgl_transaksi' and kode_rek='2' and kode_rek_induk='05' and kode_rek_detail='002'" ; //echo $query6; $hasil7 = mysqli_query($koneksi, $query7) or die("Kesalahan pada query!"); while (list($tgl_transaksi,$uraian_transaksi,$rupiah_masuk) = mysqli_fetch_row($hasil7)) { $q_stok2 = "INSERT INTO simpanan (id_pel,kode_rek,tgl_simpanan,rupiah_simpanan,keterangan,userid) VALUES ( '$uraian_transaksi', '2.05.002', '$tgl_transaksi', $rupiah_masuk, 'nisbah.$tgl_transaksi', '".$_POST[userid]."' )"; //echo $q_stok1; $hasil_stok2 = mysqli_query($koneksi,$q_stok2) or die('Kesalahan Query Pada Query Stok!'); } break; case "003" : $query6 = "SELECT id_pel,sum(rupiah_simpanan) saldo FROM simpanan where substring(kode_rek,6,3)='003' and tgl_simpanan<='$tgl_transaksi' group by id_pel" ; //echo $query6; $hasil6 = mysqli_query($koneksi, $query6) or die("Kesalahan pada query!"); while (list($id_pel,$saldo) = mysqli_fetch_row($hasil6)) { $rp = $saldo*$per1rupiah; $q_stok1 = "INSERT INTO tbl_bku (kode_rek,kode_rek_induk,kode_rek_detail,tgl_transaksi,uraian_transaksi,jenis_transaksi,rupiah_masuk,rupiah_keluar,asal_rekening,keterangan,userid) VALUES ( '2', '05', '".addslashes($_POST[kode_desa])."', '$tgl_transaksi', '$id_pel', 'DEBET', $rp, 0, '$asal_rekening', '".addslashes($_POST[keterangan])."', '".$_POST[userid]."' )"; //echo $q_stok1; $hasil_stok1 = mysqli_query($koneksi,$q_stok1) or die('Kesalahan Query Pada Query Stok!'); } $query7 = "SELECT tgl_transaksi,uraian_transaksi,rupiah_masuk FROM tbl_bku where tgl_transaksi='$tgl_transaksi' and kode_rek='2' and kode_rek_induk='05' and kode_rek_detail='003'" ; //echo $query6; $hasil7 = mysqli_query($koneksi, $query7) or die("Kesalahan pada query!"); while (list($tgl_transaksi,$uraian_transaksi,$rupiah_masuk) = mysqli_fetch_row($hasil7)) { $q_stok2 = "INSERT INTO simpanan (id_pel,kode_rek,tgl_simpanan,rupiah_simpanan,keterangan,userid) VALUES ( '$uraian_transaksi', '2.05.003', '$tgl_transaksi', $rupiah_masuk, 'nisbah.$tgl_transaksi', '".$_POST[userid]."' )"; //echo $q_stok1; $hasil_stok2 = mysqli_query($koneksi,$q_stok2) or die('Kesalahan Query Pada Query Stok!'); } break; case "004" : $query6 = "SELECT id_pel,sum(rupiah_simpanan) saldo FROM simpanan where substring(kode_rek,6,3)='004' and tgl_simpanan<='$tgl_transaksi' group by id_pel" ; //echo $query6; $hasil6 = mysqli_query($koneksi, $query6) or die("Kesalahan pada query!"); while (list($id_pel,$saldo) = mysqli_fetch_row($hasil6)) { $rp = $saldo*$per1rupiah; $q_stok1 = "INSERT INTO tbl_bku (kode_rek,kode_rek_induk,kode_rek_detail,tgl_transaksi,uraian_transaksi,jenis_transaksi,rupiah_masuk,rupiah_keluar,asal_rekening,keterangan,userid) VALUES ( '2', '05', '".addslashes($_POST[kode_desa])."', '$tgl_transaksi', '$id_pel', 'DEBET', $rp, 0, '$asal_rekening', '".addslashes($_POST[keterangan])."', '".$_POST[userid]."' )"; //echo $q_stok1; $hasil_stok1 = mysqli_query($koneksi,$q_stok1) or die('Kesalahan Query Pada Query Stok!'); } $query7 = "SELECT tgl_transaksi,uraian_transaksi,rupiah_masuk FROM tbl_bku where tgl_transaksi='$tgl_transaksi' and kode_rek='2' and kode_rek_induk='05' and kode_rek_detail='004'" ; //echo $query6; $hasil7 = mysqli_query($koneksi, $query7) or die("Kesalahan pada query!"); while (list($tgl_transaksi,$uraian_transaksi,$rupiah_masuk) = mysqli_fetch_row($hasil7)) { $q_stok2 = "INSERT INTO simpanan (id_pel,kode_rek,tgl_simpanan,rupiah_simpanan,keterangan,userid) VALUES ( '$uraian_transaksi', '2.05.004', '$tgl_transaksi', $rupiah_masuk, 'nisbah.$tgl_transaksi', '".$_POST[userid]."' )"; //echo $q_stok1; $hasil_stok2 = mysqli_query($koneksi,$q_stok2) or die('Kesalahan Query Pada Query Stok!'); } break; } echo " "; } ?>

Kode Rekening Nisbah Tabungan	:
Tanggal Update Nisbah	:
Nominal Rupiah yang di Bagi	:
catatan	:	<?echo $_POST[keterangan];?>