205 lines
5.9 KiB
PHP
205 lines
5.9 KiB
PHP
<?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;
|
|
}
|
|
?>
|