<?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'");
$sat=pg_query("SELECT satuan_kerja_id FROM data_user 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];}
} else
if ($key=='hapus_kirim') {
$id=$_POST['id'];
pg_query("DELETE FROM scan WHERE surat_id='$id'");
pg_query("DELETE FROM kirim WHERE surat_id='$id'");
pg_query("DELETE FROM surat WHERE id='$id'");
}
?>