78 lines
2.2 KiB
PHP
78 lines
2.2 KiB
PHP
<?php
|
|
include('../koneksi.php');
|
|
$key=$_POST['key'];
|
|
if ($key=='delete_kepada_kr') {
|
|
$id=$_POST['id'];
|
|
$del=pg_query("DELETE FROM kirim WHERE id='$id'");
|
|
} else
|
|
if ($key=='simpan_kirim') {
|
|
$id=$_POST['surat_id'];
|
|
$satuan_kerja_id=$_POST['satuan_kerja_id'];
|
|
$perihal=$_POST['perihal'];
|
|
$cek_satker=pg_query("SELECT id FROM surat WHERE id='$id'");
|
|
$row_satker = pg_fetch_row($cek_satker);
|
|
if ($row_satker[0] > 0) {
|
|
$upd_satker = pg_query("UPDATE surat SET
|
|
perihal='$perihal'
|
|
WHERE id='$id'");
|
|
} else {
|
|
$ins_satker = pg_query("INSERT into surat (
|
|
satuan_kerja_id,
|
|
perihal,
|
|
tgl_surat_keluar,
|
|
jenis_surat_id,
|
|
jenis_disposisi_id
|
|
) values(
|
|
'$satuan_kerja_id',
|
|
'$perihal',
|
|
NOW(),
|
|
3,
|
|
3
|
|
)
|
|
");
|
|
}
|
|
} else
|
|
if ($key=='simpan_kepada_kr') {
|
|
$surat_id=$_POST['surat_id'];
|
|
$kepada=$_POST['kepada'];
|
|
$satuan_kerja_penginput=$_POST['satuan_kerja_penginput'];
|
|
$sat=pg_query("SELECT satuan_kerja FROM data_pegawai WHERE jabatan_pegawai_id='$kepada'");
|
|
while($r=pg_fetch_array($sat)) {$satuan_kerja_tujuan=$r[0];}
|
|
$inp=pg_query("INSERT INTO kirim (
|
|
surat_id,
|
|
kepada,
|
|
tgl_input,
|
|
jam_input,
|
|
satuan_kerja_tujuan,
|
|
satuan_kerja_penginput
|
|
) VALUES (
|
|
'$surat_id',
|
|
'$kepada',
|
|
NOW(),
|
|
NOW(),
|
|
'$satuan_kerja_tujuan',
|
|
'$satuan_kerja_penginput'
|
|
)");
|
|
} else
|
|
if ($key=='jumlah_kepada') {
|
|
$surat_id=$_POST['surat_id'];
|
|
$k=pg_query("SELECT COUNT(*)
|
|
FROM kirim k INNER JOIN surat s ON (k.surat_id=s.id)
|
|
WHERE k.kepada IS NOT NULL AND k.surat_id='$surat_id'");
|
|
while($rk=pg_fetch_array($k)) {echo $rk[0];}
|
|
} else
|
|
if ($key=='jumlah_jpg') {
|
|
$surat_id=$_POST['surat_id'];
|
|
$k=pg_query("SELECT COUNT(*)
|
|
FROM scan k INNER JOIN surat s ON (k.surat_id=s.id)
|
|
WHERE k.surat_id='$surat_id' AND LOWER(k.file) LIKE '%jpg'");
|
|
while($rk=pg_fetch_array($k)) {echo $rk[0];}
|
|
} else
|
|
if ($key=='jumlah_nonjpg') {
|
|
$surat_id=$_POST['surat_id'];
|
|
$k=pg_query("SELECT COUNT(*)
|
|
FROM scan k INNER JOIN surat s ON (k.surat_id=s.id)
|
|
WHERE k.surat_id='$surat_id' AND LOWER(k.file) NOT LIKE '%.jpg'");
|
|
while($rk=pg_fetch_array($k)) {echo $rk[0];}
|
|
}
|
|
?>
|