85 lines
2.6 KiB
PHP
85 lines
2.6 KiB
PHP
<?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'");
|
|
}
|
|
?>
|