'Extra' AND j.user_nama='HUTANG' AND j.sub_kegiatan_id=k.id) as hutang,
(SELECT COALESCE(SUM(j.nilai_sp),0) FROM pekerjaan j WHERE j.status_setor IS NULL AND j.status<>'Extra' AND j.sub_kegiatan_id=k.id) AS proses,
(SELECT COALESCE(SUM(a.nilai_pelunasan),0) FROM vr_pelunasan a
LEFT OUTER JOIN vr_realisasi r ON (r.id=a.vr_realisasi_id)
LEFT OUTER JOIN pekerjaan p ON (p.id=r.pekerjaan_id)
WHERE p.sub_kegiatan_id=k.id
AND a.tanggal_lunas IS NOT NULL
) as terbayar
FROM sub_kegiatan k
WHERE k.id=$sub_kegiatan_id");
while($rz=pg_fetch_array($dz)) {
$anggaran=$rz[0];
$hutang=$rz[1];
$proses=$rz[2]-$rz[1];
$terbayar=$rz[3];
$sisa_proses=($hutang+$proses)-$terbayar;
$sisa_anggaran=$anggaran-$terbayar;
}
*/
$dz=pg_query("SELECT k.anggaran,
(SELECT COALESCE(SUM(a.nilai_pelunasan),0) FROM vr_pelunasan a
LEFT OUTER JOIN vr_realisasi r ON (r.id=a.vr_realisasi_id)
LEFT OUTER JOIN pekerjaan p ON (p.id=r.pekerjaan_id)
WHERE p.sub_kegiatan_id=k.id AND p.status_setor IS NULL
AND EXTRACT(YEAR FROM DATE(a.tanggal_lunas))='$thn'
AND EXTRACT(MONTH FROM DATE(a.tanggal_lunas)) BETWEEN '1' AND '12' AND a.tanggal_lunas IS NOT NULL
) as terbayar
FROM sub_kegiatan k
LEFT OUTER JOIN kpa a ON (a.id=k.kpa_id)
LEFT OUTER JOIN pptk t ON (t.id=k.pptk_id)
LEFT OUTER JOIN pejabat_pengadaan p ON (p.id=k.pejabat_pengadaan_id)
LEFT OUTER JOIN ppkom o ON (o.id=k.ppkom_id)
LEFT OUTER JOIN subkategori_kegiatan g ON (g.id=k.kategori_id)
WHERE k.thn='$thn'
AND k.id=$sub_kegiatan_id
ORDER BY k.id DESC");
while($rz=pg_fetch_array($dz)) {
$anggaran=$rz[0];
$terbayar=$rz[1];
$sisa_anggaran=$anggaran-$terbayar;
}
if ($sisa_anggaran<0) {$over='OVER';} else {$over='';}
?>
DPA
KPA
Kom
PTK
PP
Jenis
Sub Kegiatan/Belanja
Rek
H
Sub Kegiatan
Anggaran
Terbayar
Sisa
'Extra' AND j.sub_kegiatan_id=k.id)+
(SELECT COALESCE(SUM(j.nilai_sp),0) FROM pekerjaan j WHERE j.status_setor IS NULL AND j.status='Extra' AND j.sub_kegiatan_id=k.id)
),k.id,k.thn,k.kegiatan
FROM sub_kegiatan k
LEFT OUTER JOIN kpa a ON (a.id=k.kpa_id)
LEFT OUTER JOIN pptk t ON (t.id=k.pptk_id)
LEFT OUTER JOIN pejabat_pengadaan p ON (p.id=k.pejabat_pengadaan_id)
LEFT OUTER JOIN ppkom o ON (o.id=k.ppkom_id)
LEFT OUTER JOIN subkategori_kegiatan g ON (g.id=k.kategori_id)
WHERE k.anggaran IS NOT NULL
AND k.id='$sub_kegiatan_id'
");
*/
$data=pg_query("SELECT a.inisial,o.inisial,t.inisial,p.inisial,g.nama,
k.ra,k.rb,k.rc,k.rd,k.re,k.rf,k.rg,k.rh,k.sub_kegiatan,k.anggaran,k.id,k.thn,k.kegiatan
FROM sub_kegiatan k
LEFT OUTER JOIN kpa a ON (a.id=k.kpa_id)
LEFT OUTER JOIN pptk t ON (t.id=k.pptk_id)
LEFT OUTER JOIN pejabat_pengadaan p ON (p.id=k.pejabat_pengadaan_id)
LEFT OUTER JOIN ppkom o ON (o.id=k.ppkom_id)
LEFT OUTER JOIN subkategori_kegiatan g ON (g.id=k.kategori_id)
WHERE k.anggaran IS NOT NULL
AND k.id='$sub_kegiatan_id'
");
while($r=pg_fetch_array($data)) {
?>