<?php 
include('../koneksi.php');
$key=$_POST['key'];

if ($key=='simpan_jbel_setting') {
$id=$_POST['id'];
$berkas=$_POST['berkas'];

$cek_jbel_setting=pg_query("SELECT id FROM syarat_jbel WHERE id='$id'");
 $row_jbel_setting = pg_fetch_row($cek_jbel_setting);
 if ($row_jbel_setting[0] > 0) {
 $upd_jbel_setting = pg_query("UPDATE syarat_jbel SET 
 	berkas='$berkas'
 	WHERE id=$id");
 } else {
 $ins_jbel_setting = pg_query("INSERT into syarat_jbel (
 	berkas
 	) values(
 	'$berkas'
 	)
 ");
 }
} else
if ($key=='delete_jbel_setting') {
 $id=$_POST['id'];
 $d=pg_query("SELECT file FROM syarat_jbel WHERE id='$id'");
 while($r=pg_fetch_array($d)) {$fil=$r[0];}
 $path = "pdf/pdf/".$fil;
 if(file_exists($path)){unlink($path);}
 $del_jbel_setting = pg_query("DELETE FROM syarat_jbel WHERE id='$id'");
}
else if ($key=='ch_asn') {
 $id=$_POST['id'];
 $d=pg_query("SELECT asn FROM syarat_jbel WHERE id='$id'");
 while($r=pg_fetch_array($d)) {$asn=$r[0];}
 if ($asn==NULL) {pg_query("UPDATE syarat_jbel SET asn='y' WHERE id=$id");} else {pg_query("UPDATE syarat_jbel SET asn=NULL WHERE id=$id");}
}
else if ($key=='ch_pppk') {
 $id=$_POST['id'];
 $d=pg_query("SELECT pppk FROM syarat_jbel WHERE id='$id'");
 while($r=pg_fetch_array($d)) {$pppk=$r[0];}
 if ($pppk==NULL) {pg_query("UPDATE syarat_jbel SET pppk='y' WHERE id=$id");} else {pg_query("UPDATE syarat_jbel SET pppk=NULL WHERE id=$id");}
}
?>