<?php 
include('../../koneksi.php');
$key=$_POST['key'];

if ($key=='simpan_rekening') {
$id=$_POST['id'];
$sub_kegiatan_id=$_POST['sub_kegiatan_id'];
$jenis_anggaran=$_POST['jenis_anggaran'];
$jenis_sppd=$_POST['jenis_sppd'];
$aktif=$_POST['aktif'];

$cek_user=pg_query("SELECT id FROM sp_rek WHERE id='$id'");
 $row_user = pg_fetch_row($cek_user);
 if ($row_user[0] > 0) {
 $upd_user = pg_query("UPDATE sp_rek SET
 	sub_kegiatan_id='$sub_kegiatan_id',
 	jenis_anggaran='$jenis_anggaran',    	
 	jenis_sppd='$jenis_sppd',
 	aktif='$aktif'
 	WHERE id='$id'");
 } else {
 $ins_user = pg_query("INSERT into sp_rek (
 	sub_kegiatan_id,
 	jenis_anggaran,
 	jenis_sppd,
 	aktif
 	) values(
 	'$sub_kegiatan_id',
 	'$jenis_anggaran',
 	'$jenis_sppd',
 	'$aktif'
 	)
 "); 
 }
} else
if ($key=='list_peserta') {
$id_ms_pegawai=$_POST['id_ms_pegawai'];
$list=pg_query("SELECT p.nipb FROM data_pegawai p WHERE p.id='$id_ms_pegawai'");
while($rlist=pg_fetch_array($list)) {
	$nipb=$rlist[0];
	echo $nipb;
}
} else
if ($key=='delete_rekening') {
$id=$_POST['id'];
 $del_user = pg_query("DELETE FROM sp_rek WHERE id='$id'");
}
?>