72 lines
2.9 KiB
PHP
72 lines
2.9 KiB
PHP
<?php
|
|
include('../koneksi.php');
|
|
$key=$_POST['key'];
|
|
if ($key=='cek_lkp') {
|
|
$riwayat_kbel_id=$_POST['riwayat_kbel_id'];
|
|
$d=pg_query("SELECT COUNT(*)
|
|
FROM syarat_kbel s
|
|
LEFT OUTER JOIN (
|
|
SELECT r1.*,r2.syarat_kbel_id
|
|
FROM riwayat_kbel r1
|
|
INNER JOIN riwayat_syarat_kbel r2 ON (r1.id=r2.riwayat_kbel_id)
|
|
WHERE r1.id=$riwayat_kbel_id
|
|
) a ON (s.id=a.syarat_kbel_id)
|
|
LEFT OUTER JOIN (
|
|
SELECT r2.*
|
|
FROM riwayat_kbel r1
|
|
INNER JOIN riwayat_syarat_kbel r2 ON (r1.id=r2.riwayat_kbel_id)
|
|
WHERE r1.id=$riwayat_kbel_id
|
|
) b ON (s.id=b.syarat_kbel_id)
|
|
WHERE COALESCE(b.id,0)=0");
|
|
while($r=pg_fetch_array($d)) {echo $r[0];}
|
|
} else
|
|
if ($key=='proses_pengajuan') {
|
|
$riwayat_kbel_id=$_POST['riwayat_kbel_id'];
|
|
pg_query("UPDATE riwayat_kbel SET tgl_usulan=NOW(), status=NULL WHERE id=$riwayat_kbel_id");
|
|
} else
|
|
if ($key=='kirim_rev') {
|
|
$riwayat_kbel_id=$_POST['riwayat_kbel_id'];
|
|
$d=pg_query("SELECT ket FROM riwayat_kbel WHERE id=$riwayat_kbel_id");
|
|
while($r=pg_fetch_array($d)) {$kt=$r[0];}
|
|
if (($kt==NULL) || ($kt=='')) {
|
|
pg_query("UPDATE riwayat_kbel SET status=NULL,tgl_verifikasi=NULL,ket=NULL WHERE id=$riwayat_kbel_id");
|
|
} else {
|
|
$ket1=str_replace(" (SUDAH DI-REVISI)","",$kt);
|
|
$ket=$kt.' (SUDAH DI-REVISI)';
|
|
pg_query("UPDATE riwayat_kbel SET status=NULL,tgl_verifikasi=NULL,ket='$ket' WHERE id=$riwayat_kbel_id");
|
|
}
|
|
} else
|
|
if ($key=='jumlah_nonjpg') {
|
|
if ($_POST['riwayat_syarat_kbel_id']) {
|
|
$riwayat_syarat_kbel_id=$_POST['riwayat_syarat_kbel_id'];
|
|
$k=pg_query("SELECT COUNT(*)
|
|
FROM dok_syarat_kbel k INNER JOIN riwayat_syarat_kbel s ON (k.riwayat_syarat_kbel_id=s.id)
|
|
WHERE k.riwayat_syarat_kbel_id='$riwayat_syarat_kbel_id' AND k.file NOT IN ('')");
|
|
while($rk=pg_fetch_array($k)) {echo $rk[0];}
|
|
} else {
|
|
$syarat_kbel_id=$_POST['syarat_kbel_idzz'];
|
|
$riwayat_kbel_id=$_POST['riwayat_kbel_idzz'];
|
|
$d1=pg_query("SELECT id FROM riwayat_syarat_kbel WHERE riwayat_kbel_id=$riwayat_kbel_id AND syarat_kbel_id=$syarat_kbel_id");
|
|
while($r1=pg_fetch_array($d1)) {$riwayat_syarat_kbel_idxx=$r1[0];}
|
|
$riwayat_syarat_kbel_id=$riwayat_syarat_kbel_idxx;
|
|
$k=pg_query("SELECT COUNT(*)
|
|
FROM dok_syarat_kbel k INNER JOIN riwayat_syarat_kbel s ON (k.riwayat_syarat_kbel_id=s.id)
|
|
WHERE k.riwayat_syarat_kbel_id='$riwayat_syarat_kbel_id' AND k.file NOT IN ('')");
|
|
while($rk=pg_fetch_array($k)) {echo $rk[0].'$%^'.$riwayat_syarat_kbel_id;}
|
|
}
|
|
} else
|
|
if ($key=='tambah_kbel') {
|
|
$data_pegawai_id=$_POST['data_pegawai_id'];
|
|
pg_query("INSERT INTO riwayat_kbel (data_pegawai_id,tgl_usulan,status) VALUES ($data_pegawai_id,NOW(),'PROSES PENGAJUAN')");
|
|
$d1=pg_query("SELECT id,tgl_usulan FROM riwayat_kbel WHERE data_pegawai_id=$data_pegawai_id AND tgl_verifikasi IS NULL");
|
|
while($r1=pg_fetch_array($d1)) {
|
|
$riwayat_kbel_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_kbel_id.'$%^'.$nm_tgl_usulan.' '.'$%^'.$tgl_usulan;
|
|
}
|
|
?>
|