166 lines
5.8 KiB
PHP
166 lines
5.8 KiB
PHP
<?php
|
|
include('../koneksi.php');
|
|
$thn=$_POST['thn_dpa'];
|
|
?>
|
|
|
|
<table class="table table-bordered table-striped table-condensed tabel_rekap" id="tabel_data_jumlah_sw">
|
|
<thead>
|
|
<tr>
|
|
<td align="center" width="200">PROSES VERIFIKASI <span style="color:#3282B8"><br><i class="mdi mdi-apps m-r-5"></i>VERIFIKASI</span></td>
|
|
<td align="center" width="200">PROSES PELUNASAN <span style="color:#3282B8"><br><i class="mdi mdi-apps m-r-5"></i>PERBENDAHARAAN</span></td>
|
|
<td align="center" width="200">TERBAYAR <span style="color:#3282B8"><br><i class="mdi mdi-apps m-r-5"></i>PERBENDAHARAAN</span></td>
|
|
<tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
$d=pg_query("
|
|
(
|
|
SELECT 1 AS urut,COUNT(*),SUM(l.nilai_pelunasan) FROM pekerjaan p
|
|
INNER JOIN sub_kegiatan s ON (s.id=p.sub_kegiatan_id)
|
|
LEFT OUTER JOIN vr_realisasi r ON (p.id=r.pekerjaan_id)
|
|
LEFT OUTER JOIN vr_pelunasan l ON (r.id=l.vr_realisasi_id)
|
|
WHERE s.thn='$thn' AND p.user_nama IS NOT NULL AND p.tgl_setor IS NULL AND COALESCE(l.st_hutang,'') = 'H' AND COALESCE(p.user_nama,'')<>'HUTANG TERMIN'
|
|
AND l.tgl_terima_verif IS NOT NULL AND l.tanggal_setor IS NULL
|
|
AND l.tanggal_lunas IS NULL AND p.status_setor IS NULL
|
|
) UNION
|
|
(
|
|
SELECT 2 AS urut,COUNT(*),SUM(l.nilai_pelunasan) FROM pekerjaan p
|
|
INNER JOIN sub_kegiatan s ON (s.id=p.sub_kegiatan_id)
|
|
LEFT OUTER JOIN vr_realisasi r ON (p.id=r.pekerjaan_id)
|
|
LEFT OUTER JOIN vr_pelunasan l ON (r.id=l.vr_realisasi_id)
|
|
WHERE s.thn='$thn' AND p.user_nama IS NOT NULL AND p.tgl_setor IS NULL AND COALESCE(l.st_hutang,'') = 'H' AND COALESCE(p.user_nama,'')<>'HUTANG TERMIN'
|
|
AND l.tgl_terima_verif IS NOT NULL AND l.tanggal_setor IS NOT NULL
|
|
AND l.tanggal_lunas IS NULL AND p.status_setor IS NULL
|
|
) UNION
|
|
(
|
|
SELECT 3 AS urut,COUNT(*),SUM(l.nilai_pelunasan) FROM pekerjaan p
|
|
INNER JOIN sub_kegiatan s ON (s.id=p.sub_kegiatan_id)
|
|
LEFT OUTER JOIN vr_realisasi r ON (p.id=r.pekerjaan_id)
|
|
LEFT OUTER JOIN vr_pelunasan l ON (r.id=l.vr_realisasi_id)
|
|
WHERE s.thn='$thn' AND p.user_nama IS NOT NULL AND p.tgl_setor IS NULL AND COALESCE(l.st_hutang,'') = 'H' AND COALESCE(p.user_nama,'')<>'HUTANG TERMIN'
|
|
AND l.tgl_terima_verif IS NOT NULL AND l.tanggal_setor IS NOT NULL
|
|
AND l.tanggal_lunas IS NOT NULL AND p.status_setor IS NULL
|
|
)
|
|
ORDER BY urut ASC
|
|
");
|
|
|
|
while($r=pg_fetch_array($d)) {
|
|
$urut[]=$r[0];
|
|
$jml[]=$r[1];
|
|
$total[]=$r[2];
|
|
}
|
|
?>
|
|
<tr>
|
|
<td align="center"><button class="btn btn-block btn-xs" id="siji_sw"><?php echo $jml[0]; ?></button></td>
|
|
<td align="center"><button class="btn btn-block btn-xs" id="loro_sw"><?php echo $jml[1]; ?></button></td>
|
|
<td align="center"><button class="btn btn-block btn-xs" id="telu_sw"><?php echo $jml[2]; ?></button></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="center"><?php echo number_format($total[0],0,',','.'); ?></td>
|
|
<td align="center"><?php echo number_format($total[1],0,',','.'); ?></td>
|
|
<td align="center"><?php echo number_format($total[2],0,',','.'); ?></td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
<!--
|
|
<div class="row">
|
|
<div class="col-lg-6">
|
|
<button type="button" class="btn btn-default btn-block" id="excel_jml_sw">EXCEL</button>
|
|
</div>
|
|
<div class="col-lg-6">
|
|
<button type="button" class="btn btn-default btn-block" id="grafik_jml_sw"><i class="mdi mdi-chart-pie m-r-5"></i>GRAFIK</button>
|
|
</div>
|
|
</div>
|
|
-->
|
|
<script>
|
|
/*
|
|
$('#grafik_jml_sw').click(function(){
|
|
var siji=$('#siji_sw').html();
|
|
var loro=$('#loro_sw').html();
|
|
$('#modal_chart').modal('show');
|
|
$('#modal_body_chart').html("");
|
|
$('#modal_head_chart').html("Grafik - Jumlah Pekerjaan Swakelola");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/rekap_hutang/chart_jumlah_sw.php",
|
|
data: 'siji='+siji
|
|
+'&loro='+loro,
|
|
success: function(data){
|
|
$('#modal_body_chart').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
$('#excel_jml_sw').click(function(){
|
|
var thn = $('#thn_dpa').val();
|
|
var rk_sopo_id = $('#rk_sopo_id').val();
|
|
var jenis = $('#rk_jenis').val();
|
|
var w = 600;
|
|
var h = 300;
|
|
var left = Number((screen.width/2)-(w/2));
|
|
var tops = Number((screen.height/2)-(h/2));
|
|
window.open('app/rekap_hutang/excel_din_sw.php?thn='+thn+'&rk_sopo_id='+rk_sopo_id+'&jenis='+jenis,'newwin','toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=yes, resizable=no, copyhistory=no, width='+w+', height='+h+', top='+tops+', left='+left);
|
|
});
|
|
*/
|
|
$('#siji_sw').click(function(){
|
|
var thn_dpa = $('#thn_dpa').val();
|
|
var key = 'siji';
|
|
$('#modal_jumlah').modal('show');
|
|
$('#modal_body_jumlah').html('');
|
|
$('#modal_head_jumlah').html('<b>DATA HUTANG PROSES VERIFIKASI</b>');
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/rekap_hutang/tabel_jm1_sw.php",
|
|
data: 'thn='+thn_dpa
|
|
+'&key='+key,
|
|
success: function(data){
|
|
$('#modal_body_jumlah').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
$('#loro_sw').click(function(){
|
|
var thn_dpa = $('#thn_dpa').val();
|
|
var key = 'loro';
|
|
$('#modal_jumlah').modal('show');
|
|
$('#modal_body_jumlah').html('');
|
|
$('#modal_head_jumlah').html('<b>DATA HUTANG PROSES PELUNASAN</b>');
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/rekap_hutang/tabel_jm1_sw.php",
|
|
data: 'thn='+thn_dpa
|
|
+'&key='+key,
|
|
success: function(data){
|
|
$('#modal_body_jumlah').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
$('#telu_sw').click(function(){
|
|
var thn_dpa = $('#thn_dpa').val();
|
|
var key = 'telu';
|
|
$('#modal_jumlah').modal('show');
|
|
$('#modal_body_jumlah').html('');
|
|
$('#modal_head_jumlah').html('<b>DATA HUTANG TERBAYAR</b>');
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/rekap_hutang/tabel_jm1_sw.php",
|
|
data: 'thn='+thn_dpa
|
|
+'&key='+key,
|
|
success: function(data){
|
|
$('#modal_body_jumlah').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
$('#modal_chart').on('off.bs.modal', function() {
|
|
$('#chart').css('visibility', 'hidden');
|
|
});
|
|
|
|
$('#modal_chart').on('shown.bs.modal', function() {
|
|
$('#chart').css('visibility', 'initial');
|
|
$('#chart').highcharts().reflow();
|
|
});
|
|
|
|
|
|
</script>
|