'$thn' AND p1.status_setor IS NULL AND l1.id IS NOT NULL AND COALESCE(p1.no_sp,'')<>''
GROUP BY p1.no_sp
) l2 ON (l2.no_sp=p.no_sp)
WHERE s.id=$sub_kegiatan_id AND p.status_setor IS NULL
GROUP BY
k.inisial,t.inisial,m.inisial,p1.inisial,b1.inisial,
s.kpa,s.pptk,s.ra,s.rb,s.rc,s.rd,s.re,s.rf,s.rg,s.rh,
s.kd_panggil,
s.p1,s.k1,s.sk1,s.sub_kegiatan,s.kegiatan,s.anggaran,s.id
");
while($r=pg_fetch_array($data)) {
$tot_penyerapan=$r['tot_nilai_pekerjaan']-$r['tot_termin_terbayar'];
}
*/
/*
$data=pg_query("SELECT COALESCE(SUM(l.nilai_pelunasan),0) FROM vr_pelunasan l
INNER JOIN vr_realisasi r ON (r.id=l.vr_realisasi_id)
INNER JOIN pekerjaan p ON (p.id=r.pekerjaan_id)
WHERE l.status_npd='v' AND p.sub_kegiatan_id=$sub_kegiatan_id
");
*/
$data=pg_query("SELECT COALESCE(SUM(l.nilai_pelunasan),0) FROM vr_pelunasan l
INNER JOIN vr_realisasi r ON (r.id=l.vr_realisasi_id)
INNER JOIN pekerjaan p ON (p.id=r.pekerjaan_id)
WHERE p.sub_kegiatan_id=$sub_kegiatan_id AND l.id <> $vr_pelunasan_id
");
while($r=pg_fetch_array($data)) {$tot_penyerapan1=$r[0];}
if (($akumulasi_npd==NULL) || ($akumulasi_npd=='')) {$tot_penyerapan=$tot_penyerapan1;} else {$tot_penyerapan=$akumulasi_npd;}
?>