53 lines
2.6 KiB
PHP
53 lines
2.6 KiB
PHP
<?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'");
|
|
}
|
|
?>
|