<?php 
include('../koneksi.php');
$key=$_POST['key'];
if ($key=='simpan_arsip_disposisi') {
$id=$_POST['id'];
$no_surat=$_POST['no_surat'];

$tgl_surat_masuk=$_POST['tgl_surat_masuk'];
$tgl_surat_masuk=str_replace('/','-',$tgl_surat_masuk);
$t=date('Y',strtotime($tgl_surat_masuk));
$b=date('m',strtotime($tgl_surat_masuk));
$h=date('d',strtotime($tgl_surat_masuk));

$no_agenda=$_POST['no_agenda'];  
$surat_dari=$_POST['surat_dari'];   
$perihal=$_POST['perihal'];
$kode_id=$_POST['kode_id'];

$tgl_arsip=$_POST['tgl_arsip'];
$tgl_arsip=str_replace('/','-',$tgl_arsip);
$ta=date('Y',strtotime($tgl_arsip));
$ba=date('m',strtotime($tgl_arsip));
$ha=date('d',strtotime($tgl_arsip));

			$cek=pg_query("SELECT COUNT(id) FROM surat WHERE id='$id'");
 			while($rcek=pg_fetch_array($cek)) {$j=$rcek[0];}
 			if ($j>0) {
 			$upd=pg_query("UPDATE surat SET no_surat='$no_surat', kode_id='$kode_id',tgl_surat_masuk='$t-$b-$h', perihal='$perihal', surat_dari='$surat_dari', no_agenda='$no_agenda', no_urut='$no_agenda' WHERE id='$id'");
            
            $upd_ar=pg_query("UPDATE arsip SET tgl_arsip='$ta-$ba-$ha' WHERE surat_id='$id'");
 			} else {
 			$ins = pg_query("INSERT into surat (
 				no_surat,
 				tgl_surat_masuk,
 				tgl_diterima,
 				jam_diterima,
 				no_agenda,
 				perihal,
 				surat_dari,
 				jenis_disposisi_id,
 				jenis_surat_id,
 				no_urut,
 				kode_id
 				) values(
 				'$no_surat',
 				'$t-$b-$h',
 				NOW(),
 				NOW(),
 				'$no_agenda',
 				'$perihal',
 				'$surat_dari',
 				'1',
 				'4',
 				'$no_agenda',
 				'$kode_id'
 				)
 				");
 			$d=pg_query("SELECT MAX(id) FROM surat WHERE jenis_disposisi_id='1' AND jenis_surat_id='4'");
 			while($r=pg_fetch_array($d)) {$id=$r['0'];}
            /*
 		   	$ars=pg_query("INSERT INTO arsip (surat_id,tgl_arsip) VALUES ('$id','$ta-$ba-$ha')");
 		    */
            $cek2=pg_query("SELECT COUNT(*) FROM arsip WHERE surat_id='$id'");
 			while($rcek2=pg_fetch_array($cek2)) {$j2=$rcek2[0];}
 			if ($j2>0) {
 				$upd_ars=pg_query("UPDATE arsip SET tgl_arsip='$ta-$ba-$ha' WHERE surat_id='$id'");
 			} else {
 				$ars=pg_query("INSERT INTO arsip (surat_id,tgl_arsip) VALUES ('$id','$ta-$ba-$ha')");
 			} 
           }
} else
if ($key=='batal_arsip') {
	$surat_id=$_POST['id'];
	pg_query("DELETE FROM arsip WHERE surat_id='$surat_id'");
	pg_query("UPDATE kirim SET dis_baca=NULL WHERE id=(SELECT MAX(k1.id) FROM kirim k1 WHERE k1.surat_id='$surat_id')");
} else
if ($key=='kabinet') {
	$surat_id=$_POST['id'];
	pg_query("UPDATE surat SET konten='X' WHERE id='$surat_id'");
} else
if ($key=='batal_kabinet') {
	$surat_id=$_POST['id'];
	pg_query("UPDATE surat SET konten=NULL WHERE id='$surat_id'");
}
?>