318 lines
20 KiB
PHP
318 lines
20 KiB
PHP
<?php
|
|
include("../koneksi.php");
|
|
//$thn='2022';
|
|
|
|
$thn=$_POST['thn'];
|
|
$kegiatan=$_POST['kegiatan'];
|
|
$kpa=$_POST['kpa'];
|
|
$pptk=$_POST['pptk'];
|
|
$pgn=$_POST['pgn'];
|
|
$kom=$_POST['kom'];
|
|
$pejabat_pengadaan_id=$_POST['pejabat_pengadaan_id'];
|
|
$rh=$_POST['rh'];
|
|
|
|
?>
|
|
|
|
<script type="text/javascript">
|
|
$("#tabel_data_laporan").DataTable({"stateSave": false,"paging": true,"lengthChange": true,"searching": true,"ordering": false,"info": true,"autoWidth": false});
|
|
</script>
|
|
<input type="hidden" id="awal">
|
|
<input type="hidden" id="temp_data" style="width:600px" value="<?php echo $tempdata; ?>">
|
|
|
|
<table id="tabel_data_laporan" class="table table-striped table-condensed table-bordered" cellpadding="1" style="font-family:Arial;font-size:12px">
|
|
<thead>
|
|
<tr style="color:grey;font-weight:bold">
|
|
<td style="display:none" align="center">KPA</td>
|
|
<td style="display:none" align="center">PTk</td>
|
|
<td style="display:none" align="center">Pgn</td>
|
|
<td style="display:none" align="center">Kom</td>
|
|
<!--<td align="center">Jenis</td>-->
|
|
<td align="center" style="display:none">Kd</td>
|
|
<td align="center" width="80px" style="display:none">Rek</td>
|
|
<td align="center">Sub / Kegiatan</td>
|
|
<td align="center">Anggaran</td>
|
|
<td align="center" style="color:black" width="90px">RL TW-1</td>
|
|
<td align="center" style="color:black" width="90px">RL TW-2</td>
|
|
<td align="center" style="color:black" width="90px">RL TW-3</td>
|
|
<td align="center" style="color:black" width="90px">RL TW-4</td>
|
|
<!--<td align="center">Σ Paket</td>-->
|
|
<!--<td align="center">Hutang</td>-->
|
|
<td align="center">Total</td>
|
|
<td align="center" width="120px">Sisa</td>
|
|
<td align="center">%</td>
|
|
<td align="center"width="50px">% Sisa</td>
|
|
</tr>
|
|
</thead>
|
|
<tbody style="color:black">
|
|
<?php
|
|
|
|
$ca=pg_query("SELECT anggaran FROM sub_kegiatan WHERE id=1436");
|
|
while($rca=pg_fetch_array($ca)) {$angg=$rca[0];}
|
|
|
|
$cb=pg_query("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 IN (1436,1437,1438)
|
|
AND EXTRACT(YEAR FROM DATE(a.tanggal_lunas))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(a.tanggal_lunas)) BETWEEN '1' AND '3' AND a.tanggal_lunas IS NOT NULL
|
|
");
|
|
while($rcb=pg_fetch_array($cb)) {$l1=$rcb[0];}
|
|
|
|
$cc=pg_query("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 IN (1436,1437,1438)
|
|
AND EXTRACT(YEAR FROM DATE(a.tanggal_lunas))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(a.tanggal_lunas)) BETWEEN '4' AND '6' AND a.tanggal_lunas IS NOT NULL");
|
|
while($rcc=pg_fetch_array($cc)) {$l2=$rcc[0];}
|
|
|
|
$cd=pg_query("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 IN (1436,1437,1438)
|
|
AND EXTRACT(YEAR FROM DATE(a.tanggal_lunas))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(a.tanggal_lunas)) BETWEEN '7' AND '9' AND a.tanggal_lunas IS NOT NULL");
|
|
while($rcd=pg_fetch_array($cd)) {$l3=$rcd[0];}
|
|
|
|
$ce=pg_query("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 IN (1436,1437,1438)
|
|
AND EXTRACT(YEAR FROM DATE(a.tanggal_lunas))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(a.tanggal_lunas)) BETWEEN '10' AND '12' AND a.tanggal_lunas IS NOT NULL");
|
|
while($rce=pg_fetch_array($ce)) {$l4=$rce[0];}
|
|
|
|
/* ======================= */
|
|
|
|
$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,
|
|
(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 EXTRACT(YEAR FROM DATE(a.tanggal_lunas))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(a.tanggal_lunas)) BETWEEN '1' AND '3' AND a.tanggal_lunas IS NOT NULL
|
|
),
|
|
(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 EXTRACT(YEAR FROM DATE(a.tanggal_lunas))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(a.tanggal_lunas)) BETWEEN '4' AND '6' AND a.tanggal_lunas IS NOT NULL
|
|
),
|
|
(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 EXTRACT(YEAR FROM DATE(a.tanggal_lunas))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(a.tanggal_lunas)) BETWEEN '7' AND '9' AND a.tanggal_lunas IS NOT NULL
|
|
),
|
|
(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 EXTRACT(YEAR FROM DATE(a.tanggal_lunas))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(a.tanggal_lunas)) BETWEEN '10' AND '12' AND a.tanggal_lunas IS NOT NULL
|
|
),k.id,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.thn='$thn' AND k.anggaran IS NOT NULL
|
|
".($pejabat_pengadaan_id == null ? "" : "AND k.pejabat_pengadaan_id='$pejabat_pengadaan_id'")."
|
|
".($kegiatan == null ? "" : "AND k.kegiatan='$kegiatan' AND k.rh='$rh'")."
|
|
".($kpa == null ? "" : "AND k.kpa_id='$kpa'")."
|
|
".($pptk == null ? "" : "AND k.pptk_id='$pptk'")."
|
|
".($pgn == null ? "" : "AND k.pejabat_pengadaan_id='$pgn'")."
|
|
".($kom == null ? "" : "
|
|
".($kom == "ALL" ? "AND (k.ppkom_id IS NOT NULL AND o.inisial <> 'PPK')" : "
|
|
".($kom == "NON" ? "AND (k.ppkom_id IS NULL OR o.inisial = 'PPK')" : "AND k.ppkom_id='$kom'")."
|
|
")."
|
|
")."
|
|
ORDER BY k.id ASC
|
|
");
|
|
while($r=pg_fetch_array($data)) {
|
|
?>
|
|
<tr>
|
|
<td class="kiri" style="display:none"><?php echo $r[2]; ?></td>
|
|
<td style="display:none"><?php echo $r[3]; ?></td>
|
|
<td style="display:none"><?php echo $r[19]; ?></td>
|
|
<td style="display:none"><?php echo $r[20]; ?></td>
|
|
<!--<td><?php echo $r[20]; ?></td>-->
|
|
<td align="center" class="kiri" style="display:none"><?php
|
|
if (!empty($r[12])) {
|
|
$no_pinjam=(int) substr($r[12],0,2);
|
|
$kode=sprintf("%02s",$no_pinjam);
|
|
echo $kode;
|
|
} else {echo "-";}
|
|
?></td>
|
|
<td style="display:none"><?php echo $r[5].' '.$r[6].' '.$r[7].' '.$r[8].' '.$r[9].' '.$r[10].' '.$r[11]; ?></td>
|
|
<td class="kiri">
|
|
<span style="font-weight:bold"><?php echo $r[13]; ?></span><br>
|
|
<span><?php echo $r[20]; ?></span>
|
|
</td>
|
|
<td align="right"><span style="color:black"><?php echo number_format($r[14],0,',','.'); ?></span></td> <!-- anggaran -->
|
|
<td align="right"><button class="btn btn-block btn-xs res1" style="font-family:Arial;font-size:12px" id="<?php echo $r['id'];?>"><?php echo number_format($r[15],0,',','.'); ?></button></td> <!-- tw-1 -->
|
|
<td align="right"><button class="btn btn-block btn-xs res2" style="font-family:Arial;font-size:12px" id="<?php echo $r['id'];?>"><?php echo number_format($r[16],0,',','.'); ?></button></td> <!-- tw-2 -->
|
|
<td align="right"><button class="btn btn-block btn-xs res3" style="font-family:Arial;font-size:12px" id="<?php echo $r['id'];?>"><?php echo number_format($r[17],0,',','.'); ?></button></td> <!-- tw-3 -->
|
|
<td align="right"><button class="btn btn-block btn-xs res4" style="font-family:Arial;font-size:12px" id="<?php echo $r['id'];?>"><?php echo number_format($r[18],0,',','.'); ?></button></td> <!-- tw-4 -->
|
|
<!--<td align="center"><button class="btn btn-block btn-xs res" style="font-family:Arial;font-size:12px" id="<?php echo $r['id'];?>"><?php echo $r[21]; ?></button></td>-->
|
|
<!--<td align="right"><button class="btn btn-block btn-xs hut" style="font-family:Arial;font-size:12px" id="<?php echo $r['id'];?>"><?php echo number_format($r[16],0,',','.'); ?></button></td>--> <!-- hutang -->
|
|
<td align="right" class="tot" id="<?php echo $r['id'];?>" ><span style="color:blue"><?php echo number_format($r[15]+$r[16]+$r[17]+$r[18],0,',','.'); ?></span></td> <!-- total -->
|
|
|
|
<td align="right"><span
|
|
<?php if($r[18]<0) {?>style="color:red"<?php } else { ?>style="color:green"<?php } ?>
|
|
><?php
|
|
if (($r['id']=='1436') || ($r['id']=='1437') || ($r['id']=='1438')) {
|
|
echo number_format($angg-($l1+$l2+$l3+$l4),0,',','.');
|
|
} else {
|
|
echo number_format($r[14]-($r[15]+$r[16]+$r[17]+$r[18]),0,',','.');
|
|
}
|
|
?></span>
|
|
</td>
|
|
|
|
<td align="center">
|
|
<?php
|
|
if (($r['id']=='1436') || ($r['id']=='1437') || ($r['id']=='1438')) {
|
|
$p=@((($l1+$l2+$l3+$l4))/$angg);
|
|
} else {
|
|
$p=@((($r[15]+$r[16]+$r[17]+$r[18]))/$r[14]);
|
|
}
|
|
echo number_format($p*100, 0, '.', '');
|
|
?>
|
|
</td> <!-- sisa -->
|
|
|
|
<td align="center" class="kanan"><span
|
|
<?php
|
|
if(($r[14]-($r[15]+$r[16]+$r[17]+$r[18]))<0) {?>style="color:red"<?php } else { ?>style="color:green"<?php } ?>
|
|
>
|
|
<?php
|
|
if (($r['id']=='1436') || ($r['id']=='1437') || ($r['id']=='1438')) {
|
|
$p1=@(($angg-($l1+$l2+$l3+$l4))/$angg);
|
|
} else {
|
|
$p1=@(($r[14]-($r[15]+$r[16]+$r[17]+$r[18]))/$r[14]);
|
|
}
|
|
echo number_format($p1*100, 0, '.', '');
|
|
?>
|
|
</span></td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
|
|
|
|
|
|
|
|
<script>
|
|
$("#tabel_data_laporan").on('click','.res1',function(){
|
|
var id = $(this).attr('id');
|
|
var thn=$("#thn_dpa option:selected").text();
|
|
var currentRow=$(this).closest("tr");
|
|
var subkg = currentRow.find("td:eq(7)").text();
|
|
var kg = currentRow.find("td:eq(6)").text();
|
|
var rek = 'KODE REKENING: '+currentRow.find("td:eq(5)").text();
|
|
var angg = 'TOTAL: '+currentRow.find("td:eq(8)").text();
|
|
var cek = kg.substring(0, 2);
|
|
var key = 'tw1';
|
|
if (cek=='**') {var rk='SUBSIDI';} else {var rk='FUNGSIONAL';}
|
|
$('#modal_resmi').modal('show');
|
|
$('#modal_body_resmi').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/lap_realisasi/modal_resmi.php",
|
|
data: 'id='+id
|
|
+'&thn='+thn
|
|
+'&key='+key,
|
|
success: function(data){
|
|
$('#modal_body_resmi').html(data);
|
|
$('#modal_head_resmi').html('<span style="color:black"><b>'+subkg+'</b></span><br><span><b>'+kg+'</b></span><br><span><b>'+rek+'</b></span><br><span><b>'+angg+'</b></span> <span style="color:red"><b>'+rk+'</b></span>');
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#tabel_data_laporan").on('click','.res2',function(){
|
|
var id = $(this).attr('id');
|
|
var thn=$("#thn_dpa option:selected").text();
|
|
var currentRow=$(this).closest("tr");
|
|
var subkg = currentRow.find("td:eq(7)").text();
|
|
var kg = currentRow.find("td:eq(6)").text();
|
|
var rek = 'KODE REKENING: '+currentRow.find("td:eq(5)").text();
|
|
var angg = 'TOTAL: '+currentRow.find("td:eq(9)").text();
|
|
var cek = kg.substring(0, 2);
|
|
var key = 'tw2';
|
|
if (cek=='**') {var rk='SUBSIDI';} else {var rk='FUNGSIONAL';}
|
|
$('#modal_resmi').modal('show');
|
|
$('#modal_body_resmi').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/lap_realisasi/modal_resmi.php",
|
|
data: 'id='+id
|
|
+'&thn='+thn
|
|
+'&key='+key,
|
|
success: function(data){
|
|
$('#modal_body_resmi').html(data);
|
|
$('#modal_head_resmi').html('<span style="color:black"><b>'+subkg+'</b></span><br><span><b>'+kg+'</b></span><br><span><b>'+rek+'</b></span><br><span><b>'+angg+'</b></span> <span style="color:red"><b>'+rk+'</b></span>');
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#tabel_data_laporan").on('click','.res3',function(){
|
|
var id = $(this).attr('id');
|
|
var thn=$("#thn_dpa option:selected").text();
|
|
var currentRow=$(this).closest("tr");
|
|
var subkg = currentRow.find("td:eq(7)").text();
|
|
var kg = currentRow.find("td:eq(6)").text();
|
|
var rek = 'KODE REKENING: '+currentRow.find("td:eq(5)").text();
|
|
var angg = 'TOTAL: '+currentRow.find("td:eq(10)").text();
|
|
var cek = kg.substring(0, 2);
|
|
var key = 'tw3';
|
|
if (cek=='**') {var rk='SUBSIDI';} else {var rk='FUNGSIONAL';}
|
|
$('#modal_resmi').modal('show');
|
|
$('#modal_body_resmi').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/lap_realisasi/modal_resmi.php",
|
|
data: 'id='+id
|
|
+'&thn='+thn
|
|
+'&key='+key,
|
|
success: function(data){
|
|
$('#modal_body_resmi').html(data);
|
|
$('#modal_head_resmi').html('<span style="color:black"><b>'+subkg+'</b></span><br><span><b>'+kg+'</b></span><br><span><b>'+rek+'</b></span><br><span><b>'+angg+'</b></span> <span style="color:red"><b>'+rk+'</b></span>');
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#tabel_data_laporan").on('click','.res4',function(){
|
|
var id = $(this).attr('id');
|
|
var thn=$("#thn_dpa option:selected").text();
|
|
var currentRow=$(this).closest("tr");
|
|
var subkg = currentRow.find("td:eq(7)").text();
|
|
var kg = currentRow.find("td:eq(6)").text();
|
|
var rek = 'KODE REKENING: '+currentRow.find("td:eq(5)").text();
|
|
var angg = 'TOTAL: '+currentRow.find("td:eq(11)").text();
|
|
var cek = kg.substring(0, 2);
|
|
var key = 'tw4';
|
|
if (cek=='**') {var rk='SUBSIDI';} else {var rk='FUNGSIONAL';}
|
|
$('#modal_resmi').modal('show');
|
|
$('#modal_body_resmi').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/lap_realisasi/modal_resmi.php",
|
|
data: 'id='+id
|
|
+'&thn='+thn
|
|
+'&key='+key,
|
|
success: function(data){
|
|
$('#modal_body_resmi').html(data);
|
|
$('#modal_head_resmi').html('<span style="color:black"><b>'+subkg+'</b></span><br><span><b>'+kg+'</b></span><br><span><b>'+rek+'</b></span><br><span><b>'+angg+'</b></span> <span style="color:red"><b>'+rk+'</b></span>');
|
|
}
|
|
});
|
|
});
|
|
</script>
|
|
|
|
|