|
|
|
|
$query6 = "SELECT sum(rupiah_simpanan) tabungan FROM simpanan where substring(kode_rek,6,3)='001' and tgl_simpanan<='$tgl_transaksi' and substring(keterangan,8,7)<>'$thnbln' and id_pel='$kode_custamer'" ;
// echo $query6;
$hasil6 = mysqli_query($koneksi, $query6) or
die("Kesalahan pada query!");
list($tabungan) = mysqli_fetch_row($hasil6);
//echo $tariktabungan;
echo number_format($tabungan);?> |
$q_nis ="SELECT sum(rupiah_simpanan) nisbah FROM simpanan where substring(kode_rek,6,3)='001' and substring(keterangan,8,7)='$thnbln' and id_pel='$kode_custamer'";
//echo $q_nis;
$hasil_nis = mysqli_query($koneksi,$q_nis)
or die('Kode Barang Sudah Ada!');
list($nisbah) = mysqli_fetch_row($hasil_nis) ;
echo number_format($nisbah);
//echo $telp_custamer;?> |
|
$q_tab2 ="SELECT sum(rupiah_simpanan) tabungan2 FROM simpanan where substring(kode_rek,6,3)='002' and tgl_simpanan<='$tgl_transaksi' and substring(keterangan,8,7)<>'$thnbln' and id_pel='$kode_custamer'";
//echo $q_tab2;
$hasil_tab2 = mysqli_query($koneksi,$q_tab2)
or die('Kode Barang Sudah Ada!');
list($tabungan2) = mysqli_fetch_row($hasil_tab2) ;
echo number_format($tabungan2);?> |
$q_nis2 ="SELECT sum(rupiah_simpanan) nisbah2 FROM simpanan where substring(kode_rek,6,3)='002' and substring(keterangan,8,7)='$thnbln' and id_pel='$kode_custamer'";
$hasil_nis2 = mysqli_query($koneksi,$q_nis2)
or die('Kode Barang Sudah Ada!');
list($nisbah2) = mysqli_fetch_row($hasil_nis2) ;
echo number_format($nisbah2);
//echo $telp_custamer;?> |
|
$q_tab3 ="SELECT sum(rupiah_simpanan) tabungan3 FROM simpanan where substring(kode_rek,6,3)='003' and tgl_simpanan<='$tgl_transaksi' and substring(keterangan,8,7)<>'$thnbln' and id_pel='$kode_custamer'";
//echo $q_tab2;
$hasil_tab3 = mysqli_query($koneksi,$q_tab3)
or die('Kode Barang Sudah Ada!');
list($tabungan3) = mysqli_fetch_row($hasil_tab3) ;
echo number_format($tabungan3);?> |
$q_nis3 ="SELECT sum(rupiah_simpanan) nisbah3 FROM simpanan where substring(kode_rek,6,3)='003' and substring(keterangan,8,7)='$thnbln' and id_pel='$kode_custamer'";
$hasil_nis3 = mysqli_query($koneksi,$q_nis3)
or die('Kode Barang Sudah Ada!');
list($nisbah3) = mysqli_fetch_row($hasil_nis3) ;
echo number_format($nisbah3);?> |
|
$q_tab4 ="SELECT sum(rupiah_simpanan) tabungan4 FROM simpanan where substring(kode_rek,6,3)='004' and tgl_simpanan<='$tgl_transaksi' and substring(keterangan,8,7)<>'$thnbln' and id_pel='$kode_custamer'";
//echo $q_tab2;
$hasil_tab4 = mysqli_query($koneksi,$q_tab4)
or die('Kode Barang Sudah Ada!');
list($tabungan4) = mysqli_fetch_row($hasil_tab4) ;
echo number_format($tabungan4);?> |
$q_nis4 ="SELECT sum(rupiah_simpanan) nisbah4 FROM simpanan where substring(kode_rek,6,3)='004' and substring(keterangan,8,7)='$thnbln' and id_pel='$kode_custamer'";
$hasil_nis4 = mysqli_query($koneksi,$q_nis4)
or die('Kode Barang Sudah Ada!');
list($nisbah4) = mysqli_fetch_row($hasil_nis4) ;
echo number_format($nisbah4);
//echo $telp_custamer;?> |
|
|
$tottab=$tottab+($tabungan);
$totnis=$totnis+$nisbah;
$tottab2=$tottab2+$tabungan2;
$totnis2=$totnis2+$nisbah2;
$tottab3=$tottab3+$tabungan3;
$totnis3=$totnis3+$nisbah3;
$tottab4=$tottab4+$tabungan4;
$totnis4=$totnis4+$nisbah4;
$no++;
}
}
mysqli_free_result($hasil);
?>