<?php 
include('../koneksi.php');
$key=$_POST['key'];
if ($key=='simpan_komen') {
$surat_id=$_POST['surat_id'];
$jabatan_pegawai_id=$_POST['jabatan_pegawai_id'];
$satuan_kerja_penginput=$_POST['satuan_kerja_penginput'];
$komen=$_POST['komen'];
if (($komen=='') || ($komen==NULL)) {} else {
pg_query("INSERT INTO komen (surat_id,jabatan_pegawai_id,tanggal,komen) VALUES ($surat_id,$jabatan_pegawai_id,NOW(),'$komen')");
}

$db=pg_query("SELECT k.id FROM komen k WHERE k.surat_id=$surat_id AND k.jabatan_pegawai_id=$jabatan_pegawai_id AND k.komen='$komen' AND k.id=(SELECT MAX(k1.id) FROM komen k1
WHERE k1.surat_id=$surat_id AND k1.jabatan_pegawai_id=$jabatan_pegawai_id AND k1.komen='$komen'
)");
while($rdb=pg_fetch_array($db)) {
$komen_id=$rdb[0];
}

$d=pg_query("SELECT id,kepada FROM kirim WHERE surat_id='$surat_id' AND satuan_kerja_tujuan IS NULL AND lama IS NULL AND satuan_kerja_penginput=$satuan_kerja_penginput");
while(($r=pg_fetch_array($d)) !== FALSE) {
    $kirim_id=$r[0];
    $kepada=$r[1];
    $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];}
	pg_query("UPDATE kirim SET dis_baca='SM' WHERE surat_id=$surat_id AND satuan_kerja_tujuan=$satuan_kerja_tujuan");
    pg_query("UPDATE kirim SET satuan_kerja_tujuan='$satuan_kerja_tujuan', lama=NOW() WHERE id='$kirim_id' AND satuan_kerja_tujuan IS NULL AND lama IS NULL");

    pg_query("INSERT INTO teruskan (surat_id,komen_id,jabatan_dari,kirim_id_untuk,jabatan_untuk) VALUES (
    $surat_id,$komen_id,$jabatan_pegawai_id,$kirim_id,$kepada
    )"); 
}
echo $surat_id.' '.$komen_id.' '.$jabatan_pegawai_id.' '.$kirim_id.' '.$kepada;
} else
if ($key=='hapus_komen') {
$id=$_POST['id'];
$d=pg_query("SELECT file FROM scan_komen WHERE komen_id='$id'");
while($r=pg_fetch_array($d)) {
$fil=$r[0];
$path = "/var/www/simdistu/app/tindaklanjut/dok/".$fil;
if(file_exists($path)){unlink($path);}
$path1 = "/var/www/simdistu/app/tindaklanjut/pdf/pdf/".$fil;
if(file_exists($path1)){unlink($path1);}
}
$del_pr=pg_query("DELETE FROM scan_komen WHERE komen_id='$id'");
pg_query("DELETE FROM komen WHERE id=$id");
} else
if ($key=='jumlah_jpg') {
$komen_id=$_POST['komen_id'];
$k=pg_query("SELECT COUNT(*)
FROM scan_komen k INNER JOIN komen s ON (k.komen_id=s.id)
WHERE k.komen_id='$komen_id' AND LOWER(k.file) LIKE ANY (ARRAY['%jpg','%jpeg','%png']) AND k.file NOT IN ('')");
while($rk=pg_fetch_array($k)) {echo $rk[0];}
} else
if ($key=='jumlah_nonjpg') {
$komen_id=$_POST['komen_id'];
$k=pg_query("SELECT COUNT(*)
FROM scan_komen k INNER JOIN komen s ON (k.komen_id=s.id)
WHERE k.komen_id='$komen_id' AND LOWER(k.file) NOT LIKE ALL (ARRAY['%jpg','%jpeg','%png']) AND k.file NOT IN ('')");
while($rk=pg_fetch_array($k)) {echo $rk[0];}
} else
if ($key=='edit_komen') {
$id=$_POST['id'];
$komen=$_POST['komen'];
$surat_id=$_POST['surat_id'];
$jabatan_pegawai_id=$_POST['jabatan_pegawai_id'];
pg_query("UPDATE komen SET komen='$komen',status=NULL WHERE id=$id");
} else
if ($key=='hapus_arahan') {
$kirim_id=$_POST['id'];
$d=pg_query("SELECT surat_id,isi FROM kirim WHERE id=$kirim_id");
while($r=pg_fetch_array($d)) {$surat_id=$r['surat_id'];$isi=$r['isi'];}
	if ($isi=='SM') {
    	pg_query("DELETE FROM teruskan WHERE kirim_id_untuk IN (SELECT id FROM kirim WHERE surat_id=$surat_id AND id=$kirim_id)");
        pg_query("DELETE FROM kirim WHERE surat_id=$surat_id AND id=$kirim_id");
    } else {
    	pg_query("DELETE FROM scan_komen WHERE komen_id IN (SELECT komen_id FROM teruskan WHERE kirim_id_untuk IN (SELECT id FROM kirim WHERE surat_id=$surat_id AND id>=$kirim_id))");
        pg_query("DELETE FROM komen WHERE surat_id=$surat_id AND id IN (SELECT komen_id FROM teruskan WHERE kirim_id_untuk IN (SELECT id FROM kirim WHERE surat_id=$surat_id AND id>=$kirim_id))");
    	pg_query("DELETE FROM teruskan WHERE kirim_id_untuk IN (SELECT id FROM kirim WHERE surat_id=$surat_id AND id>=$kirim_id)");
        pg_query("DELETE FROM kirim WHERE surat_id=$surat_id AND id>=$kirim_id");
    }
}
?>