98 lines
4.2 KiB
PHP
98 lines
4.2 KiB
PHP
<?php
|
|
include('../koneksi.php');
|
|
$key=$_POST['key'];
|
|
if ($key=='hapus_verifikasi') {
|
|
$riwayat_spo_id=$_POST['riwayat_spo_id'];
|
|
|
|
/*
|
|
$d=pg_query("SELECT file_bkd FROM riwayat_dokbkd_spo WHERE id=$riwayat_spo_id");
|
|
while($r=pg_fetch_array($d)) {$fil=$r[0];}
|
|
$del_pr=pg_query("DELETE FROM riwayat_dokbkd_spo WHERE id=$riwayat_spo_id");
|
|
$path = "app/spo_inbox/pdf_bkd/pdf/".$fil;
|
|
if(file_exists($path)){unlink($path);}
|
|
|
|
$d=pg_query("SELECT file_dir FROM riwayat_dokdir_spo WHERE id=$riwayat_spo_id");
|
|
while($r=pg_fetch_array($d)) {$fil=$r[0];}
|
|
$del_pr=pg_query("DELETE FROM riwayat_dokdir_spo WHERE id=$riwayat_spo_id");
|
|
$path = "app/spo_inbox/pdf_dir/pdf/".$fil;
|
|
if(file_exists($path)){unlink($path);}
|
|
|
|
$c=pg_query("SELECT id FROM riwayat_syarat_spo WHERE id=$riwayat_spo_id");
|
|
while($rc=pg_fetch_array($c)) {$riwayat_syarat_spo_id=$rc[0];}
|
|
$d=pg_query("SELECT file FROM dok_syarat_spo WHERE riwayat_syarat_spo_id=$riwayat_syarat_spo_id");
|
|
while($r=pg_fetch_array($d)) {$fil=$r[0];}
|
|
$del_pr=pg_query("DELETE FROM dok_syarat_spo WHERE riwayat_syarat_spo_id=$riwayat_syarat_spo_id");
|
|
$path = "app/st_spo/pdf/pdf/".$fil;
|
|
if(file_exists($path)){unlink($path);}
|
|
|
|
pg_query("DELETE FROM riwayat_syarat_spo WHERE riwayat_spo_id=$riwayat_spo_id");
|
|
pg_query("DELETE FROM riwayat_spo WHERE id=$riwayat_spo_id");
|
|
*/
|
|
$d2=pg_query("SELECT file_bkd FROM riwayat_dokbkd_spo WHERE riwayat_spo_id=$riwayat_spo_id");
|
|
while(($r2=pg_fetch_array($d2)) !== FALSE) {
|
|
$fil2=$r2[0];
|
|
$path2 = "/var/www/simpro/app/spo_inbox/pdf_bkd/pdf/".$fil2;
|
|
if(file_exists($path2)){unlink($path2);}
|
|
}
|
|
$del_pr=pg_query("DELETE FROM riwayat_dokbkd_spo WHERE riwayat_spo_id=$riwayat_spo_id");
|
|
|
|
$d1=pg_query("SELECT file_dir FROM riwayat_dokdir_spo WHERE riwayat_spo_id=$riwayat_spo_id");
|
|
while(($r1=pg_fetch_array($d1)) !== FALSE) {
|
|
$fil1=$r1[0];
|
|
$path1 = "/var/www/simpro/app/spo_inbox/pdf_dir/pdf/".$fil1;
|
|
if(file_exists($path1)){unlink($path1);}
|
|
}
|
|
$del_pr=pg_query("DELETE FROM riwayat_dokdir_spo WHERE riwayat_spo_id=$riwayat_spo_id");
|
|
|
|
$d=pg_query("SELECT file FROM dok_syarat_spo WHERE riwayat_syarat_spo_id IN (SELECT id FROM riwayat_syarat_spo WHERE riwayat_spo_id=$riwayat_spo_id)");
|
|
while(($r=pg_fetch_array($d)) !== FALSE) {
|
|
$fil=$r[0];
|
|
$path = "/var/www/simpro/app/st_spo/pdf/pdf/".$fil;
|
|
if(file_exists($path)){unlink($path);}
|
|
}
|
|
$del_pr=pg_query("DELETE FROM dok_syarat_spo WHERE riwayat_syarat_spo_id IN (SELECT id FROM riwayat_syarat_spo WHERE riwayat_spo_id=$riwayat_spo_id)");
|
|
|
|
pg_query("DELETE FROM riwayat_syarat_spo WHERE riwayat_spo_id=$riwayat_spo_id");
|
|
pg_query("DELETE FROM riwayat_spo WHERE id=$riwayat_spo_id");
|
|
} else
|
|
if ($key=='simpan_edit_verifikasi') {
|
|
$riwayat_syarat_spo_id=$_POST['riwayat_syarat_spo_id'];
|
|
$status=$_POST['status'];
|
|
$ket=$_POST['ket'];
|
|
$tgl_cek_dok=$_POST['tgl_cek_dok'];
|
|
$tgl_cek_dok=str_replace('/','-',$tgl_cek_dok);
|
|
$t=date('Y',strtotime($tgl_cek_dok));
|
|
$b=date('m',strtotime($tgl_cek_dok));
|
|
$h=date('d',strtotime($tgl_cek_dok));
|
|
pg_query("UPDATE riwayat_syarat_spo SET status='$status',ket='$ket',tgl_cek_dok='$t-$b-$h' WHERE id=$riwayat_syarat_spo_id");
|
|
} else
|
|
if ($key=='simpan_edit_spo') {
|
|
$riwayat_spo_id=$_POST['riwayat_spo_id'];
|
|
$status=$_POST['status'];
|
|
$ket=$_POST['ket'];
|
|
$ket_dokdir=$_POST['ket_dokdir'];
|
|
$ket_dokbkd=$_POST['ket_dokbkd'];
|
|
if ($status=='SELESAI VERIFIKASI') {
|
|
$tgl_verifikasi=$_POST['tgl_verifikasi'];
|
|
$tgl_verifikasi=str_replace('/','-',$tgl_verifikasi);
|
|
$t=date('Y',strtotime($tgl_verifikasi));
|
|
$b=date('m',strtotime($tgl_verifikasi));
|
|
$h=date('d',strtotime($tgl_verifikasi));
|
|
pg_query("UPDATE riwayat_spo SET status='$status',tgl_verifikasi='$t-$b-$h',ket='$ket',
|
|
ket_dokdir='$ket_dokdir',ket_dokbkd='$ket_dokbkd'
|
|
WHERE id=$riwayat_spo_id");
|
|
} else
|
|
if (($status=='BELUM VERIFIKASI') || ($status=='step')) {
|
|
pg_query("UPDATE riwayat_spo SET status=NULL,tgl_verifikasi=NULL,ket=NULL WHERE id=$riwayat_spo_id");
|
|
} else {
|
|
$tgl_verifikasi=$_POST['tgl_verifikasi'];
|
|
$tgl_verifikasi=str_replace('/','-',$tgl_verifikasi);
|
|
$t=date('Y',strtotime($tgl_verifikasi));
|
|
$b=date('m',strtotime($tgl_verifikasi));
|
|
$h=date('d',strtotime($tgl_verifikasi));
|
|
pg_query("UPDATE riwayat_spo SET status='$status',ket='$ket',
|
|
ket_dokdir='$ket_dokdir',ket_dokbkd='$ket_dokbkd',tgl_verifikasi='$t-$b-$h'
|
|
WHERE id=$riwayat_spo_id");
|
|
}
|
|
}
|
|
?>
|