75 lines
3.0 KiB
PHP
75 lines
3.0 KiB
PHP
<?php
|
|
include('../koneksi.php');
|
|
$key=$_POST['key'];
|
|
if ($key=='cek_lkp') {
|
|
$stpeg=$_POST['stpeg'];
|
|
$riwayat_ibel_id=$_POST['riwayat_ibel_id'];
|
|
$d=pg_query("SELECT COUNT(*)
|
|
FROM syarat_ibel s
|
|
LEFT OUTER JOIN (
|
|
SELECT r1.*,r2.syarat_ibel_id
|
|
FROM riwayat_ibel r1
|
|
INNER JOIN riwayat_syarat_ibel r2 ON (r1.id=r2.riwayat_ibel_id)
|
|
WHERE r1.id=$riwayat_ibel_id
|
|
) a ON (s.id=a.syarat_ibel_id)
|
|
LEFT OUTER JOIN (
|
|
SELECT r2.*
|
|
FROM riwayat_ibel r1
|
|
INNER JOIN riwayat_syarat_ibel r2 ON (r1.id=r2.riwayat_ibel_id)
|
|
WHERE r1.id=$riwayat_ibel_id
|
|
) b ON (s.id=b.syarat_ibel_id)
|
|
WHERE
|
|
".($stpeg== 'pns' ? "s.pns='y'" : "s.blud='y'")."
|
|
AND COALESCE(b.id,0)=0");
|
|
while($r=pg_fetch_array($d)) {echo $r[0];}
|
|
} else
|
|
if ($key=='proses_pengajuan') {
|
|
$riwayat_ibel_id=$_POST['riwayat_ibel_id'];
|
|
pg_query("UPDATE riwayat_ibel SET tgl_usulan=NOW(), status=NULL WHERE id=$riwayat_ibel_id");
|
|
} else
|
|
if ($key=='kirim_rev') {
|
|
$riwayat_ibel_id=$_POST['riwayat_ibel_id'];
|
|
$d=pg_query("SELECT ket FROM riwayat_ibel WHERE id=$riwayat_ibel_id");
|
|
while($r=pg_fetch_array($d)) {$kt=$r[0];}
|
|
if (($kt==NULL) || ($kt=='')) {
|
|
pg_query("UPDATE riwayat_ibel SET status=NULL,tgl_verifikasi=NULL,ket=NULL WHERE id=$riwayat_ibel_id");
|
|
} else {
|
|
$ket1=str_replace(" (SUDAH DI-REVISI)","",$kt);
|
|
$ket=$kt.' (SUDAH DI-REVISI)';
|
|
pg_query("UPDATE riwayat_ibel SET status=NULL,tgl_verifikasi=NULL,ket='$ket' WHERE id=$riwayat_ibel_id");
|
|
}
|
|
} else
|
|
if ($key=='jumlah_nonjpg') {
|
|
if ($_POST['riwayat_syarat_ibel_id']) {
|
|
$riwayat_syarat_ibel_id=$_POST['riwayat_syarat_ibel_id'];
|
|
$k=pg_query("SELECT COUNT(*)
|
|
FROM dok_syarat_ibel k INNER JOIN riwayat_syarat_ibel s ON (k.riwayat_syarat_ibel_id=s.id)
|
|
WHERE k.riwayat_syarat_ibel_id='$riwayat_syarat_ibel_id' AND k.file NOT IN ('')");
|
|
while($rk=pg_fetch_array($k)) {echo $rk[0];}
|
|
} else {
|
|
$syarat_ibel_id=$_POST['syarat_ibel_idzz'];
|
|
$riwayat_ibel_id=$_POST['riwayat_ibel_idzz'];
|
|
$d1=pg_query("SELECT id FROM riwayat_syarat_ibel WHERE riwayat_ibel_id=$riwayat_ibel_id AND syarat_ibel_id=$syarat_ibel_id");
|
|
while($r1=pg_fetch_array($d1)) {$riwayat_syarat_ibel_idxx=$r1[0];}
|
|
$riwayat_syarat_ibel_id=$riwayat_syarat_ibel_idxx;
|
|
$k=pg_query("SELECT COUNT(*)
|
|
FROM dok_syarat_ibel k INNER JOIN riwayat_syarat_ibel s ON (k.riwayat_syarat_ibel_id=s.id)
|
|
WHERE k.riwayat_syarat_ibel_id='$riwayat_syarat_ibel_id' AND k.file NOT IN ('')");
|
|
while($rk=pg_fetch_array($k)) {echo $rk[0].'$%^'.$riwayat_syarat_ibel_id;}
|
|
}
|
|
} else
|
|
if ($key=='tambah_ibel') {
|
|
$data_pegawai_id=$_POST['data_pegawai_id'];
|
|
pg_query("INSERT INTO riwayat_ibel (data_pegawai_id,tgl_usulan,status) VALUES ($data_pegawai_id,NOW(),'PROSES PENGAJUAN')");
|
|
$d1=pg_query("SELECT id,tgl_usulan FROM riwayat_ibel WHERE data_pegawai_id=$data_pegawai_id AND tgl_verifikasi IS NULL");
|
|
while($r1=pg_fetch_array($d1)) {
|
|
$riwayat_ibel_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_ibel_id.'$%^'.$nm_tgl_usulan.' '.'$%^'.$tgl_usulan;
|
|
}
|
|
?>
|