<?php 
include('../koneksi.php');
$key=$_POST['key'];
if ($key=='close_rapat') {
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
$sifat_notulen=$_POST['sifat_notulen'];
$upd_notulen=pg_query("UPDATE riwayat_kegiatan SET st_persiapan='Close',sifat_notulen='$sifat_notulen' WHERE id='$riwayat_kegiatan_id'");
} 
if ($key=='simpan_dok_notulen') {
$id=$_POST['id'];
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
$pembahasan=$_POST['pembahasan'];
$tindak_lanjut=$_POST['tindak_lanjut'];
$cek_notulen=pg_query("SELECT id FROM riwayat_notulen WHERE id='$id'");
 $row_notulen = pg_fetch_row($cek_notulen);
 if ($row_notulen[0] > 0) {
		$upd_notulen=pg_query("UPDATE riwayat_notulen SET riwayat_kegiatan_id='$riwayat_kegiatan_id',pembahasan='$pembahasan',tindak_lanjut='$tindak_lanjut' WHERE id='$id'");
 } else {
 		$ins_notulen=pg_query("INSERT INTO riwayat_notulen (riwayat_kegiatan_id,pembahasan,tindak_lanjut) VALUES ('$riwayat_kegiatan_id','$pembahasan','$tindak_lanjut')");
 }

} else
if ($key=='data_kegiatan') {
 $riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
 $dkeg=pg_query("SELECT (SELECT nama FROM data_pegawai WHERE id=notulis),materi,st_batal FROM riwayat_kegiatan WHERE id='$riwayat_kegiatan_id' AND st_batal IS NULL");
 while($rdkeg=pg_fetch_array($dkeg)) {
	$notulis=$rdkeg[0];
	$materi=$rdkeg[1];
 }

 $a=pg_query("SELECT COUNT(*) FROM uman WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND jenis='notulen'");
 while($ra=pg_fetch_array($a)) {$ttl_notulen=$ra[0];}
 $b=pg_query("SELECT COUNT(*) FROM uman WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND jenis='materi'");
 while($rb=pg_fetch_array($b)) {$ttl_materi=$rb[0];}
 $c=pg_query("SELECT COUNT(*) FROM uman WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND jenis='absensi'");
 while($rc=pg_fetch_array($c)) {$ttl_absensi=$rc[0];}
 $d=pg_query("SELECT COUNT(*) FROM uman WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND jenis='undangan'");
 while($rd=pg_fetch_array($d)) {$ttl_undangan=$rd[0];}
 $e=pg_query("SELECT COUNT(*) FROM riwayat_notulen WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id'");
 while($re=pg_fetch_array($e)) {$ttl_rnotulen=$re[0];}

 echo $notulis.'$%^'.$materi.'$%^'.$ttl_notulen.'$%^'.$ttl_materi.'$%^'.$ttl_absensi.'$%^'.$ttl_undangan.'$%^'.$ttl_rnotulen;
} else
if ($key=='simpan_notulis') {
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
$notulis=$_POST['notulis'];
	$upd_notulis=pg_query("UPDATE riwayat_kegiatan SET notulis='$notulis' WHERE id='$riwayat_kegiatan_id'");
} else
if ($key=='hapus_notulen') {
$id=$_POST['id'];
$hapus_notulen=pg_query("DELETE FROM riwayat_notulen WHERE id='$id'");
}
?>