31 lines
769 B
PHP
31 lines
769 B
PHP
<?php
|
|
$status1='PROSES PENGECEKAN KELENGKAPAN';
|
|
$posisi1=$ketpembpptk;
|
|
$dj=pg_query("SELECT
|
|
COALESCE(n.tanggal,l.tgl_setor_pptk) as tanggal,
|
|
COALESCE(n.keterangan,'Proses Pembuatan NPD') as status,
|
|
COALESCE(n.admin,l.adm_setor_pptk) as admin,
|
|
COALESCE(n.posisi,'TIM VALIDASI PENGADAAN') as posisi
|
|
FROM pengerjaan_npd n
|
|
RIGHT OUTER JOIN (SELECT * FROM vr_pelunasan WHERE status_npd IS NOT NULL) l ON (l.id=n.vr_pelunasan_id)
|
|
WHERE l.id=$vrprlid
|
|
ORDER BY tanggal DESC
|
|
LIMIT 1");
|
|
while($rj=pg_fetch_array($dj)) {
|
|
$status_npd=$rj['status'];
|
|
$posisi_npd=$rj['posisi'];
|
|
}
|
|
|
|
if (($status_npd==NULL) || ($status_npd=='')) {
|
|
$status=$status1;
|
|
} else {
|
|
$status=$status_npd;
|
|
}
|
|
|
|
if (($posisi_npd==NULL) || ($posisi_npd=='')) {
|
|
$posisi=$posisi1;
|
|
} else {
|
|
$posisi=$posisi_npd;
|
|
}
|
|
|
|
?>
|