require("connect.inc.php");?>
MUTASI SAHAM A KE B
$q_awal = "SELECT id,reg_kk,tgl_saham,nama,klp,jml_saham,seri FROM master_saham where id=".$_GET[id]."" ;
$hasil_awal = mysql_db_query($db, $q_awal, $koneksi) or
die("Kesalahan pada query!");
list($id,$reg_kk,$tgl_saham,$nama,$klp,$jml_saham,$seri) = mysql_fetch_row($hasil_awal);
if($seri=="A"){
// Setting Font
// Setting Form
if (!$_POST[tambah]) {
$q_kat = "SELECT max(reg_kk) reg_ FROM kk_saham where seri='B'" ;
$hasil_kat = mysql_db_query($db, $q_kat, $koneksi) or
die("Kesalahan pada query!");
list($reg_) = mysql_fetch_row($hasil_kat);
$reg_akir = substr($reg_,-7)+1;
$reg_kk_final = 'SB'.substr(('000000'.$reg_akir),-7);
//echo $_SESSION['username'];
$q = "SELECT nama_kk FROM kk_saham where reg_kk ='".$reg_kk."' " ;
$hasil_q = mysql_db_query($db, $q, $koneksi) or
die("Kesalahan pada query!");
list($nama_kk) = mysql_fetch_row($hasil_q);
?>
}
else
{
require("connect.inc.php");
$tanggal_mutasi = $_POST[thn_beli]."-".$_POST[bln_beli]."-".$_POST[tgl_beli];
$id = $_POST[id];
$seri = $_POST[seri];
$jml_saham = $_POST[jml_saham];
$reg_kk_asal = $_POST[reg_kk];
$tgl_saham = $_POST[tgl_saham];
$nama_saham = $_POST[nama_saham];
$jml_mutasi = $_POST[jml_mutasi];
$kk = $_POST[kk];
$query = "INSERT INTO kk_saham (reg_kk,nama_kk,nama_klp,seri) VALUES (
'".addslashes(strtoupper($kk))."',
'".addslashes(strtoupper($_POST[nama_kk]))."',
'".addslashes(strtoupper($_POST[klp]))."',
'B')";
//echo $query;
$hasil = mysql_db_query($db,$query,$koneksi)
or die('Kesalahan Query!');
// if ($seri=="A") {
// $nilai_saham=25000;
// } else {
// $nilai_saham=5000;
// }
$q_kk = "SELECT reg_kk,nama_kk,nama_klp FROM kk_saham where reg_kk='".$kk."' " ;
$hasil_kk = mysql_db_query($db, $q_kk, $koneksi) or
die("Kesalahan pada query!");
list($reg_kk,$nama_kk,$nama_klp) = mysql_fetch_row($hasil_kk);
// $jml_saham_mutasi =$jml_saham-$jml_mutasi;
$rp_saham=$jml_saham_mutasi*$nilai_saham;
$rp_mutasi=$jml_mutasi*5000;
$q_upd2 = "INSERT INTO master_saham (reg_kk,tgl_saham,nama,kk,klp,jml_saham,rp_saham,seri,status_print) VALUES (
'$kk',
'$tgl_saham',
'".addslashes(strtoupper($nama_saham))."',
'$_POST[nama_kk]',
'$nama_klp',
$jml_mutasi,
$rp_mutasi,
'B','' )";
// echo $q_upd2."
";
// echo $q_upd2;
$hasil_upd2 = mysql_db_query($db, $q_upd2, $koneksi) or
die("Kesalahan pada query!");
$q_upd5 = "INSERT INTO mutasi (tgl_mutasi,tgl_saham,nama_asal,nama_tujuan,saham_asal,saham_tujuan,jml_saham,jenis_saham,userid) VALUES (
'$tanggal_mutasi',
'$tgl_saham',
'".addslashes(strtoupper($_POST[nama_asal]))."',
'".addslashes(strtoupper($_POST[nama_saham]))."',
'$reg_kk_asal',
'$kk',
$jml_saham,
'AB','$_POST[userid]' )";
// echo $q_upd5."
";
// echo $q_upd2;
$hasil_upd5 = mysql_db_query($db, $q_upd5, $koneksi) or
die("Kesalahan pada query!");
$query_del = "DELETE FROM master_saham WHERE id=$id";
//echo $query;
$hasil_del = mysql_db_query($db,$query_del,$koneksi)
or die('Kesalahan pada proses query!');
?>
}
} else {
die('SAHAM YANG DIMUTASI HARUS SERI A. Silah kan Cek Kembali sebelum mutasi');
}
?>