<?php 
include('../koneksi.php');
$key=$_POST['key'];
if ($key=='simpan_sm') {
$jenis_disposisi=$_POST['jenis_disposisi'];
$id=$_POST['id'];
$jenis_disposisi_id=$_POST['jenis_disposisi_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'];
$untuk=$_POST['untuk'];
//$no_kendali=$_POST['no_kendali'];   
$surat_dari=$_POST['surat_dari'];   
$sifat_surat_id=$_POST['sifat_surat_id'];   
$lampiran=$_POST['lampiran'];   
$perihal=$_POST['perihal'];
$satuan_kerja_id=$_POST['satuan_kerja_id'];
$kode_id=$_POST['kode_id'];
$satuan_kerja_dari=$_POST['satuan_kerja_dari'];
$thn_skrg=date('Y');
if ($jenis_disposisi=='Disposisi') {
			$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 kode_id='$kode_id',tgl_surat_masuk='$t-$b-$h', perihal='$perihal', 
 				surat_dari='$surat_dari', sifat_surat_id='$sifat_surat_id', no_surat='$no_surat' WHERE id='$id'");
 			echo $id;	
 			} else {
			/*$urut=pg_query("SELECT COALESCE(MAX(no_urut),0) FROM surat WHERE date_part('YEAR', tgl_diterima)='$thn_skrg' AND jenis_disposisi_id='$jenis_disposisi_id' 
				AND satuan_kerja_id IS NOT NULL"); */
            $urut=pg_query("SELECT DISTINCT COALESCE(MAX(s.no_urut),0)
                                        FROM surat s
                                        LEFT OUTER JOIN kirim k ON (s.id=k.surat_id)
                                        LEFT OUTER JOIN arsip a ON (a.surat_id=s.id)
                                        WHERE k.satuan_kerja_tujuan='66' AND a.id IS NULL
                                        AND s.jenis_disposisi_id='1' AND date_part('YEAR', s.tgl_diterima)='$thn_skrg'");
			while($rurut=pg_fetch_array($urut)) {$no_urut=$rurut[0]+1;}
			$no_agenda=$no_urut;
            
			/*cek no surat*/
			//$cek1=pg_query("SELECT COUNT(id) FROM surat WHERE no_surat='$no_surat' AND no_surat <> ''");
            $cek1=pg_query("SELECT COUNT(id) FROM surat WHERE no_surat='$no_surat' AND no_surat NOT IN ('','/') AND jenis_surat_id=4 AND jenis_disposisi_id=1");
			while($rcek1=pg_fetch_array($cek1)) {$j1=$rcek1[0];}
 			if ($j1>0) {echo "salah";} else {
 			$ins = pg_query("INSERT into surat (
 				no_surat,
 				tgl_surat_masuk,
 				tgl_diterima,
 				jam_diterima,
 				no_agenda,
 				perihal,
 				surat_dari,
 				jenis_disposisi_id,
 				satuan_kerja_id,
 				jenis_surat_id,
 				no_urut,
 				kode_id,
 				sifat_surat_id
 				) values(
 				'$no_surat',
 				'$t-$b-$h',
 				NOW(),
 				NOW(),
 				'$no_agenda',
 				'$perihal',
 				'$surat_dari',
 				'1',
 				'$satuan_kerja_id',
 				'4',
 				'$no_urut',
 				'$kode_id',
 				'$sifat_surat_id'
 				)
 				");
 			$cek_id=pg_query("SELECT MAX(id) FROM surat");
 			while($rc=pg_fetch_array($cek_id)) {$sud=$rc[0];}
 			$ins_dis=pg_query("INSERT INTO kirim (
 			surat_id,
 			tgl_input,
 			jam_input,
 			satuan_kerja_tujuan,
 			satuan_kerja_penginput
 			) VALUES (
 			'$sud',
 			NOW(),
 			NOW(),
 			'$satuan_kerja_id',
 			'$satuan_kerja_id'
 			)");
 			echo $sud;
            }
 		}
} else
if ($jenis_disposisi=='Kendali Surat') {

	$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 satuan_kerja_dari='$satuan_kerja_dari', sifat_surat_id='$sifat_surat_id', lampiran='$lampiran', perihal='$perihal' WHERE id='$id'");
 			echo $id;	
 			} else {

	$kendali=pg_query("SELECT COALESCE(MAX(no_kendali),0) FROM surat WHERE date_part('YEAR', tgl_diterima)='$thn_skrg' AND jenis_disposisi_id='$jenis_disposisi_id'");
	while($rkendali=pg_fetch_array($kendali)) {$no_kendali=$rkendali[0]+1;}
 			$ins = pg_query("INSERT into surat (
 				satuan_kerja_dari,
 				sifat_surat_id,
 				lampiran,
 				perihal,
 				tgl_diterima,
 				jam_diterima,
 				jenis_disposisi_id,
 				satuan_kerja_id,
 				jenis_surat_id,
 				no_kendali
 				) values(
 				'$satuan_kerja_dari',
 				'$sifat_surat_id',
 				'$lampiran',
 				'$perihal',
 				NOW(),
 				NOW(),
 				'2',
 				'$satuan_kerja_id',
 				'4',
 				'$no_kendali'
 				)
 				");
 			$cek_id=pg_query("SELECT MAX(id) FROM surat");
 			while($rc=pg_fetch_array($cek_id)) {$sud=$rc[0];}
 			$ins_dis=pg_query("INSERT INTO kirim (
 			surat_id,
 			tgl_input,
 			jam_input,
 			satuan_kerja_tujuan,
 			satuan_kerja_penginput
 			) VALUES (
 			'$sud',
 			NOW(),
 			NOW(),
 			'$satuan_kerja_id',
 			'$satuan_kerja_id'
 			)");
 			echo $sud;
 	}
} else
if ($jenis_disposisi=='Biasa') {
	$cek=pg_query("SELECT id FROM surat WHERE id='$id'");
 		$row_cek = pg_fetch_row($cek);
 		if ($row_cek[0] > 0) {
			$upd = pg_query("UPDATE surat SET
			    surat_dari='$surat_dari',
			    tgl_surat_masuk='$t-$b-$h' 
 				no_surat='$no_surat',
 				lampiran='$lampiran',
 				perihal='$perihal',
 				no_agenda='$no_agenda',
				untuk='$untuk'
 				WHERE id='$id'");
 		} else {
 			$ins = pg_query("INSERT into surat (
 				surat_dari,
 				tgl_surat_masuk,
 				no_surat,
 				lampiran,
 				perihal,
 				no_agenda,
 				untuk,
 				tgl_diterima,
 				jam_diterima,
 				jenis_disposisi_id,
 				satuan_kerja_id,
 				jenis_surat_id
 				) values(
 				'$surat_dari',
 				'$t-$b-$h',
 				'$no_surat',
 				'$lampiran',
 				'$perihal',
 				'$no_agenda',
 				'$untuk',
 				NOW(),
 				NOW(),
 				'3',
 				'$satuan_kerja_id',
 				'4'
 				)
 				");
 		}
}
} else
if ($key=='cek_no') {
	$no_surat=$_POST['no_surat'];
	$d=pg_query("SELECT surat_dari,lampiran,perihal,tgl_surat_masuk,id FROM surat WHERE no_surat='$no_surat'");
	while($rd=pg_fetch_array($d)) {$surat_dari=$rd[0];$lampiran=$rd[1];$perihal=$rd[2];$tgl_surat=$rd[3];$surat_id=$rd[4];}
	echo $surat_dari.'$%^'.$lampiran.'$%^'.$perihal.'$%^'.date('d-m-Y',strtotime($tgl_surat)).'$%^'.$surat_id;
}
?>