89 lines
3.5 KiB
PHP
89 lines
3.5 KiB
PHP
<?php
|
|
include('../koneksi.php');
|
|
$key=$_POST['key'];
|
|
if ($key=='cek_lkp') {
|
|
$riwayat_spo_id=$_POST['riwayat_spo_id'];
|
|
$tujuan_spo=$_POST['tujuan_spo'];
|
|
$d=pg_query("SELECT COUNT(*)
|
|
FROM syarat_spo s
|
|
LEFT OUTER JOIN (
|
|
SELECT r1.*,r2.syarat_spo_id
|
|
FROM riwayat_spo r1
|
|
INNER JOIN riwayat_syarat_spo r2 ON (r1.id=r2.riwayat_spo_id)
|
|
WHERE r1.id=$riwayat_spo_id
|
|
) a ON (s.id=a.syarat_spo_id)
|
|
LEFT OUTER JOIN (
|
|
SELECT r2.*
|
|
FROM riwayat_spo r1
|
|
INNER JOIN riwayat_syarat_spo r2 ON (r1.id=r2.riwayat_spo_id)
|
|
WHERE r1.id=$riwayat_spo_id
|
|
) b ON (s.id=b.syarat_spo_id)
|
|
WHERE COALESCE(b.id,0)=0
|
|
".($tujuan_spo== 'dn' ? "AND s.dn='y'" : "
|
|
".($tujuan_spo== 'ln' ? "AND s.ln='y'" : "")."
|
|
")."
|
|
");
|
|
while($r=pg_fetch_array($d)) {echo $r[0];}
|
|
} else
|
|
if ($key=='proses_pengajuan') {
|
|
$riwayat_spo_id=$_POST['riwayat_spo_id'];
|
|
pg_query("UPDATE riwayat_spo SET tgl_usulan=NOW(), status=NULL WHERE id=$riwayat_spo_id");
|
|
} else
|
|
if ($key=='kirim_rev') {
|
|
$riwayat_spo_id=$_POST['riwayat_spo_id'];
|
|
$d=pg_query("SELECT ket FROM riwayat_spo WHERE id=$riwayat_spo_id");
|
|
while($r=pg_fetch_array($d)) {$kt=$r[0];}
|
|
if (($kt==NULL) || ($kt=='')) {
|
|
pg_query("UPDATE riwayat_spo SET status=NULL,tgl_verifikasi=NULL,ket=NULL WHERE id=$riwayat_spo_id");
|
|
} else {
|
|
$ket1=str_replace(" (SUDAH DI-REVISI)","",$kt);
|
|
$ket=$kt.' (SUDAH DI-REVISI)';
|
|
pg_query("UPDATE riwayat_spo SET status=NULL,tgl_verifikasi=NULL,ket='$ket' WHERE id=$riwayat_spo_id");
|
|
}
|
|
} else
|
|
if ($key=='simpan_spo') {
|
|
$riwayat_spo_id=$_POST['riwayat_spo_id'];
|
|
$jenis_data='_spo';
|
|
$jenis_spo=$_POST['jenis_spo'];
|
|
$nama_spo=$_POST['nama_spo'];
|
|
$cek=pg_query("SELECT id FROM riwayat_spo WHERE id=$riwayat_spo_id");
|
|
$row = pg_fetch_row($cek);
|
|
if ($row[0] > 0) {
|
|
$upd=pg_query("UPDATE riwayat_spo SET jenis_data='$jenis_data',jenis_spo='$jenis_spo',nama_spo='$nama_spo' WHERE id=$riwayat_spo_id");
|
|
} else {}
|
|
} else
|
|
if ($key=='jumlah_nonjpg') {
|
|
if ($_POST['riwayat_syarat_spo_id']) {
|
|
$riwayat_syarat_spo_id=$_POST['riwayat_syarat_spo_id'];
|
|
$k=pg_query("SELECT COUNT(*)
|
|
FROM dok_syarat_spo k INNER JOIN riwayat_syarat_spo s ON (k.riwayat_syarat_spo_id=s.id)
|
|
WHERE k.riwayat_syarat_spo_id='$riwayat_syarat_spo_id' AND k.file NOT IN ('')");
|
|
while($rk=pg_fetch_array($k)) {echo $rk[0];}
|
|
} else {
|
|
$syarat_spo_id=$_POST['syarat_spo_idzz'];
|
|
$riwayat_spo_id=$_POST['riwayat_spo_idzz'];
|
|
$d1=pg_query("SELECT id FROM riwayat_syarat_spo WHERE riwayat_spo_id=$riwayat_spo_id AND syarat_spo_id=$syarat_spo_id");
|
|
while($r1=pg_fetch_array($d1)) {$riwayat_syarat_spo_idxx=$r1[0];}
|
|
$riwayat_syarat_spo_id=$riwayat_syarat_spo_idxx;
|
|
$k=pg_query("SELECT COUNT(*)
|
|
FROM dok_syarat_spo k INNER JOIN riwayat_syarat_spo s ON (k.riwayat_syarat_spo_id=s.id)
|
|
WHERE k.riwayat_syarat_spo_id='$riwayat_syarat_spo_id' AND k.file NOT IN ('')");
|
|
while($rk=pg_fetch_array($k)) {echo $rk[0].'$%^'.$riwayat_syarat_spo_id;}
|
|
}
|
|
} else
|
|
if ($key=='tambah_spo') {
|
|
$data_pegawai_id=$_POST['data_pegawai_id'];
|
|
$tujuan_spo=$_POST['tujuan_spo'];
|
|
pg_query("INSERT INTO riwayat_spo (data_pegawai_id,tgl_usulan,status,tujuan_spo) VALUES ($data_pegawai_id,NOW(),'PROSES PENGAJUAN','$tujuan_spo')");
|
|
$d1=pg_query("SELECT id,tgl_usulan FROM riwayat_spo WHERE data_pegawai_id=$data_pegawai_id AND tgl_verifikasi IS NULL");
|
|
while($r1=pg_fetch_array($d1)) {
|
|
$riwayat_spo_id=$r1[0];
|
|
$tgl_usulan=$r1[1];
|
|
if (($r1[1]==null) || ($r1[1]=='1970-01-01 00:00:00')) {$tgl_usulan='';$nm_tgl_usulan='';} else {
|
|
$nm_tgl_usulan='Tanggal usulan: ';
|
|
$tgl_usulan=date('d-m-Y',strtotime($r1[1]));
|
|
}
|
|
}
|
|
echo $riwayat_spo_id.'$%^'.$nm_tgl_usulan.' '.'$%^'.$tgl_usulan;
|
|
}
|
|
?>
|