require("connect.inc.php");?>
Untitled
| LIST MUTASI SAHAM TANGGAL s.d |
| No |
Tgl Saham |
Nama Asal |
Register KK Asal |
Tgl Mutasi |
Nama Tujuan |
Register KK Tujuan |
Jml |
Rp Saham |
Seri |
$seri = $_GET['seri'];
$klp = $_GET['klp'];
$tgl_awal = $_GET['tgl_awal'];
$tgl_akir = $_GET['tgl_akir'];
$q_kat = "SELECT * FROM mutasi where tgl_mutasi>='".$tgl_awal."' and tgl_mutasi<='".$tgl_akir."'" ;
$hasil_kat = mysqli_query($koneksi, $q_kat) or
die("Kesalahan pada query!");
//$num_rows = mysqli_num_rows($hasil_kat);
//echo $q_kat;
if ($_GET['seri']=="A"){
$nilai_saham=25000;
}else {
$nilai_saham=5000;
}
$no=1;
while (list($id,$tgl_mutasi,$tgl_saham,$nama_asal,$nama_tujuan,$saham_asal,$saham_tujuan,$jml_saham,$jenis_saham,$userid,$tgl_upd) = mysqli_fetch_row($hasil_kat))
{
if ($no % 2==0){
$warna="#F3F3F3";
} else {
$warna="#EAEAEA";
}
$q = "SELECT nama_kk FROM kk_saham where reg_kk ='".$saham_tujuan."' " ;
$hasil_q = mysqli_query($koneksi, $q) or
die("Kesalahan pada query!");
list($nama_kk) = mysqli_fetch_row($hasil_q);
$q1 = "SELECT nama_kk nm_asal FROM kk_saham where reg_kk ='".$saham_asal."' " ;
$hasil_q1 = mysqli_query($koneksi, $q1) or
die("Kesalahan pada query!");
list($nm_asal) = mysqli_fetch_row($hasil_q1);
?>
|
|
|
|
|
|
|
|
|
|
$no++;
$tot = $tot + $jml_saham;
$tot_rp = $tot_rp + ($nilai_saham*$jml_saham);
}
//echo $tot;
?>
| Jumlah Total |
|
|
|