<?php 
include('../../koneksi.php');
$key=$_POST['key'];
if ($key=='koreksi_arahan') {
$id=$_POST['id'];
$upd=pg_query("UPDATE kirim SET proses_tu='K' WHERE id='$id'");
} else
if ($key=='koreksi_batal') {
$id=$_POST['id'];
$upd=pg_query("UPDATE kirim SET proses_tu=null WHERE id='$id'");
} else
if ($key=='simpan_arahan') {
$id=$_POST['id'];
$surat_id=$_POST['surat_id'];
$isi=$_POST['isi'];
$satuan_kerja_penginput=$_POST['satuan_kerja_penginput'];
$satuan_kerja_tujuan=$_POST['satuan_kerja_tujuan'];

$cek=pg_query("SELECT id FROM kirim WHERE id='$id'");
  $row_cek = pg_fetch_row($cek);
 	if ($row_cek[0] > 0) {
 		$upd=pg_query("UPDATE kirim SET isi='$isi',
 			tgl_input=NOW(),jam_input=NOW()
 			WHERE id='$id'");
 	} else {
 		$inp=pg_query("INSERT INTO kirim (
 			surat_id,
 			isi,
 			tgl_diterima,
 			jam_diterima,
 			satuan_kerja_tujuan,
 			satuan_kerja_penginput
 			) VALUES (
 			'$surat_id',
 			'$isi',
 			NOW(),
 			NOW(),
 			'$satuan_kerja_tujuan',
 			'$satuan_kerja_penginput'
 			)");
 	}
} else
if ($key=='delete_arahan') {
$id=$_POST['id'];
$del=pg_query("DELETE FROM kirim WHERE id='$id'");
}
?>