<?php 
include('../../koneksi.php');
$key=$_POST['key'];
if ($key=='konfirm_on') {
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
pg_query("UPDATE riwayat_kegiatan SET kode_pelatihan='BID' WHERE id='$riwayat_kegiatan_id'");
} else
if ($key=='konfirm_off') {
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
pg_query("UPDATE riwayat_kegiatan SET kode_pelatihan=NULL WHERE id='$riwayat_kegiatan_id'");
} else
if ($key=='nama_satker') {
$satuan_kerja_id=$_POST['satuan_kerja_id'];
$s=pg_query("SELECT nama FROM satuan_kerja WHERE id='$satuan_kerja_id'");
while($rs=pg_fetch_array($s)) {$n=$rs[0];}
echo $n;
} else
if ($key=='simpan_nd1') {
$id=$_POST['id'];
$no_nd=$_POST['no_nd'];
$permintaan_nd=$_POST['permintaan_nd'];
$tgl_nd=$_POST['tgl_nd'];
$tgl_nd=str_replace('/','-',$tgl_nd);
$tm=date('Y',strtotime($tgl_nd));
$bm=date('m',strtotime($tgl_nd));
$hm=date('d',strtotime($tgl_nd));
$tgl_paling_lambat_nd=$_POST['tgl_paling_lambat_nd'];
$tgl_paling_lambat_nd=str_replace('/','-',$tgl_paling_lambat_nd);
$ts=date('Y',strtotime($tgl_paling_lambat_nd));
$bs=date('m',strtotime($tgl_paling_lambat_nd));
$hs=date('d',strtotime($tgl_paling_lambat_nd));
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
$upd2=pg_query("UPDATE riwayat_quota SET no_nd='$no_nd',tgl_nd='$tm-$bm-$hm',tgl_paling_lambat_nd='$ts-$bs-$hs' WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id'");
$upd=pg_query("UPDATE riwayat_quota SET permintaan_nd='$permintaan_nd' WHERE id='$id'");
} else
if ($key=='simpan_quota') {
$satuan_kerja_id=$_POST['satuan_kerja_id'];
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
$id=$_POST['id'];
if (($_POST['quota1']=='') || ($_POST['quota1']==null)) {$quota1=0;} else {$quota1=$_POST['quota1'];}
if (($_POST['quota2']=='') || ($_POST['quota2']==null)) {$quota2=0;} else {$quota2=$_POST['quota2'];}
if (($_POST['quota3']=='') || ($_POST['quota3']==null)) {$quota3=0;} else {$quota3=$_POST['quota3'];}
if (($_POST['quota4']=='') || ($_POST['quota4']==null)) {$quota4=0;} else {$quota4=$_POST['quota4'];}
if (($_POST['quota5']=='') || ($_POST['quota5']==null)) {$quota5=0;} else {$quota5=$_POST['quota5'];}
$quota=$quota1+$quota2+$quota3+$quota4+$quota5;

$max_quota=$_POST['max_quota'];
$tot_quota=$_POST['tot_quota'];			
  $cek=pg_query("SELECT id FROM riwayat_quota WHERE id='$id'");
  $row_cek = pg_fetch_row($cek);
 	if ($row_cek[0] > 0) {
 		$cek1=pg_query("SELECT COALESCE(SUM(quota1),0)+COALESCE(SUM(quota2),0)+COALESCE(SUM(quota3),0)+COALESCE(SUM(quota4),0)+COALESCE(SUM(quota5),0) FROM riwayat_quota WHERE id='$id'");
 		while($c=pg_fetch_array($cek1)) {$quo=$c[0];}
 		$hasil=($tot_quota-$quo)+$quota;
 		if($hasil>$max_quota) {echo "false";} else {
 			if ($quota==0) {
 				$upd=pg_query("DELETE FROM riwayat_quota WHERE id='$id'");
 			} else {
 				$upd=pg_query("UPDATE riwayat_quota SET quota1='$quota1',quota2='$quota2',quota3='$quota3',quota4='$quota4',quota5='$quota5' WHERE id='$id'");
 			}
 		}
 	} else {
 		$hasil=($tot_quota+$quota);
 		if($hasil>$max_quota) {echo "false";} else {
 		$inp=pg_query("INSERT INTO riwayat_quota (
 			satuan_kerja_id,
 			riwayat_kegiatan_id,
 			quota1,
 			quota2,
 			quota3,
 			quota4,
 			quota5
 			) VALUES (
 			'$satuan_kerja_id',
 			'$riwayat_kegiatan_id',
 			'$quota1',
 			'$quota2',
 			'$quota3',
 			'$quota4',
 			'$quota5'
 			)");
 		}
 	}
} else
if ($key=='count_quota') {
$id=$_POST['riwayat_kegiatan_id'];
$max_quota=$_POST['max_quota'];
$j=pg_query("SELECT COALESCE(SUM(quota1),0)+COALESCE(SUM(quota2),0)+COALESCE(SUM(quota3),0)+COALESCE(SUM(quota4),0)+COALESCE(SUM(quota5),0) FROM riwayat_quota WHERE riwayat_kegiatan_id='$id'");
while($rj=pg_fetch_array($j)) {$tot_quod=$rj[0];}
if ($tot_quod=='') {$tot_quo=0;} else {$tot_quo=$tot_quod;}
echo $max_quota.'/'.$tot_quo;
} else
if ($key=='open') {
$id=$_POST['riwayat_kegiatan_id'];
$u=pg_query("UPDATE riwayat_kegiatan SET status='Open' WHERE id='$id'");
echo "open";
} else
if ($key=='batal_open') {
$id=$_POST['riwayat_kegiatan_id'];
$u=pg_query("UPDATE riwayat_kegiatan SET status=NULL WHERE id='$id'");
}
?>