90 lines
3.7 KiB
PHP
90 lines
3.7 KiB
PHP
<?php
|
|
include("../koneksi.php");
|
|
$pekerjaan_id=$_POST['pekerjaan_id'];
|
|
$vr_pelunasan_id=$_POST['vr_pelunasan_id'];
|
|
|
|
$d1=pg_query("SELECT s.id,s.thn FROM sub_kegiatan s WHERE s.id=(SELECT p.sub_kegiatan_id FROM pekerjaan p WHERE p.id=$pekerjaan_id)");
|
|
while($rd1=pg_fetch_array($d1)) {$sub_kegiatan_id=$rd1[0];$thn=$rd1[1];}
|
|
|
|
$d2=pg_query("SELECT nilai_pelunasan,COALESCE(id_npd,0) as id_npd,akumulasi_npd FROM vr_pelunasan WHERE id=$vr_pelunasan_id");
|
|
while($rd2=pg_fetch_array($d2)) {$nilai_pelunasan=$rd2[0];$id_npd=$rd2[1];$akumulasi_npd=$rd2[2];}
|
|
|
|
|
|
/*
|
|
$data=pg_query("SELECT
|
|
SUM(p.nilai_sp) as tot_nilai_pekerjaan,s.id,
|
|
SUM(COALESCE(l2.tot,0)) as tot_termin_terbayar
|
|
FROM sub_kegiatan s
|
|
LEFT OUTER JOIN pekerjaan p ON (p.sub_kegiatan_id=s.id)
|
|
LEFT OUTER JOIN kpa k ON (k.id=s.kpa_id)
|
|
LEFT OUTER JOIN pptk t ON (t.id=s.pptk_id)
|
|
LEFT OUTER JOIN ppkom m ON (m.id=s.ppkom_id)
|
|
LEFT OUTER JOIN pejabat_pengadaan p1 ON (p1.id=s.pejabat_pengadaan_id)
|
|
LEFT OUTER JOIN subkategori_kegiatan g ON (g.id=s.kategori_id)
|
|
LEFT OUTER JOIN bp b1 ON (b1.id=s.bp_id)
|
|
LEFT OUTER JOIN (
|
|
SELECT p1.no_sp,SUM(l1.nilai_pelunasan) as tot FROM pekerjaan p1
|
|
INNER JOIN sub_kegiatan s1 ON (s1.id=p1.sub_kegiatan_id)
|
|
INNER JOIN vr_realisasi r1 ON (p1.id=r1.pekerjaan_id)
|
|
INNER JOIN vr_pelunasan l1 ON (r1.id=l1.vr_realisasi_id)
|
|
WHERE s1.thn<>'$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;}
|
|
?>
|
|
<input type="hidden" value="<?php echo $pekerjaan_id;?>" id="pekerjaan_id_npd">
|
|
<input type="hidden" value="<?php echo $vr_pelunasan_id;?>" id="vr_pelunasan_id_npd">
|
|
<input type="hidden" value="<?php echo $id_npd;?>" id="id_npd">
|
|
|
|
<input type="hidden" value="<?php echo $sub_kegiatan_id; ?>" id="sub_kegiatan_id_npd">
|
|
<input type="hidden" value="<?php echo $thn; ?>">
|
|
<div class="form-group">
|
|
<label for="exampleInputName2">Jenis NPD</label>
|
|
<select class="form-control" id="jenis_npd">
|
|
<option value="Tanpa Uang Panjar">TANPA UANG PANJAR</option>
|
|
<option value="Uang Panjar">UANG PANJAR</option>
|
|
</select>
|
|
</div>
|
|
|
|
<div class="form-group" id="singit">
|
|
<label for="exampleInputName2">Akumulasi Pencairan Sebelumnya</label>
|
|
<input type="text" class="form-control" id="akumulasi_sebelumnya_npd" onkeyup="formatAngka(this,'.')" value="<?php echo number_format($tot_penyerapan,0,',','.'); ?>" disabled>
|
|
</div>
|
|
|
|
<script type="text/javascript">
|
|
function formatAngka(objek, separator) {
|
|
a = objek.value;b = a.replace(/[^\d]/g,"");c="";panjang=b.length;j=0;
|
|
for(i=panjang;i>0;i--) {j=j+1;if(((j%3)==1)&&(j!=1)) {c=b.substr(i-1,1)+separator+c;} else {c=b.substr(i-1,1)+c;}}objek.value=c;
|
|
}
|
|
|
|
$('#singit').hide();
|
|
</script>
|