293 lines
11 KiB
PHP
293 lines
11 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">
|
|
<thead>
|
|
<tr>
|
|
<td align="center" width="200">PROSES PBJ <span style="color:#3282B8"><br><i class="mdi mdi-apps m-r-5"></i>PENGADAAN</span></td>
|
|
<td align="center" width="200">SELESAI ADMIN <span style="color:#3282B8"><br><i class="mdi mdi-apps m-r-5"></i>PENGADAAN</span></td>
|
|
<td align="center" width="200">SETOR VERIFIKASI <span style="color:#3282B8"><br><i class="mdi mdi-apps m-r-5"></i>PEMBANTU PPTK</span></td>
|
|
<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>
|
|
<td align="center" width="280"><span style="color:red"><i class="mdi mdi-alert-circle-outline m-r-5"></i>BELUM DIVALIDASI<br>SUDAH DIVERIFIKASI </span></td>
|
|
<tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
|
|
$d=pg_query("(
|
|
SELECT 1 AS urut,COUNT(*),SUM(p.nilai_sp) 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.tgl_setor IS NULL AND COALESCE(l.st_hutang,'') = 'H' AND COALESCE(p.user_nama,'')='HUTANG TERMIN'
|
|
AND l.tgl_terima_verif IS NULL AND st_setor_verif IS NULL
|
|
AND l.tanggal_lunas IS NULL AND p.status_setor IS NULL
|
|
) UNION
|
|
(
|
|
SELECT 2 AS urut,COUNT(*),SUM(p.nilai_sp) 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.tgl_setor IS NOT NULL AND COALESCE(l.st_hutang,'') = 'H' AND COALESCE(p.user_nama,'')='HUTANG TERMIN'
|
|
AND l.tgl_terima_verif IS NULL AND st_setor_verif IS 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 COALESCE(l.st_hutang,'') = 'H' AND COALESCE(p.user_nama,'')='HUTANG TERMIN'
|
|
AND l.tgl_terima_verif IS NULL AND st_setor_verif IS NOT NULL
|
|
AND l.tanggal_lunas IS NULL AND p.status_setor IS NULL
|
|
) UNION
|
|
(
|
|
SELECT 4 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.tgl_setor IS NOT NULL AND COALESCE(l.st_hutang,'') = 'H' AND COALESCE(p.user_nama,'')='HUTANG TERMIN'
|
|
AND l.tgl_terima_verif IS NOT NULL AND st_setor_verif IS NOT NULL AND l.tanggal_setor IS NULL
|
|
AND l.tanggal_lunas IS NULL AND p.status_setor IS NULL
|
|
) UNION
|
|
(
|
|
SELECT 5 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.tgl_setor IS NOT NULL AND COALESCE(l.st_hutang,'') = 'H' AND COALESCE(p.user_nama,'')='HUTANG TERMIN'
|
|
AND l.tgl_terima_verif IS NOT NULL AND st_setor_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 6 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.tgl_setor IS NOT NULL AND COALESCE(l.st_hutang,'') = 'H' AND COALESCE(p.user_nama,'')='HUTANG TERMIN'
|
|
AND l.tgl_terima_verif IS NOT NULL AND st_setor_verif IS NOT NULL AND l.tanggal_setor IS NOT NULL AND l.tanggal_lunas IS NOT NULL AND p.status_setor IS NULL
|
|
) UNION
|
|
(
|
|
SELECT 7 AS urut,COUNT(*),SUM(COALESCE(l.nilai_pelunasan,p.nilai_sp)) 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.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 st_setor_verif 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_tm"><?php echo $jml[0]; ?></button></td>
|
|
<td align="center"><button class="btn btn-block btn-xs" id="loro_tm"><?php echo $jml[1]; ?></button></td>
|
|
<td align="center"><button class="btn btn-block btn-xs" id="telu_tm"><?php echo $jml[2]; ?></button></td>
|
|
<td align="center"><button class="btn btn-block btn-xs" id="papat_tm"><?php echo $jml[3]; ?></button></td>
|
|
<td align="center"><button class="btn btn-block btn-xs" id="limo_tm"><?php echo $jml[4]; ?></button></td>
|
|
<td align="center"><button class="btn btn-block btn-xs" id="enem_tm"><?php echo $jml[5]; ?></button></td>
|
|
<td align="center"><button class="btn btn-block btn-xs" id="pitu_tm" style="color:red"><?php echo $jml[6]; ?></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>
|
|
<td align="center"><?php echo number_format($total[3],0,',','.'); ?></td>
|
|
<td align="center"><?php echo number_format($total[4],0,',','.'); ?></td>
|
|
<td align="center"><?php echo number_format($total[5],0,',','.'); ?></td>
|
|
<td align="center" style="color:red"><?php echo number_format($total[6],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">EXCEL</button>
|
|
</div>
|
|
<div class="col-lg-6">
|
|
<button type="button" class="btn btn-default btn-block" id="grafik_jml"><i class="mdi mdi-chart-pie m-r-5"></i>GRAFIK</button>
|
|
</div>
|
|
</div>
|
|
-->
|
|
<script>
|
|
/*
|
|
$('#grafik_jml').click(function(){
|
|
var siji=$('#siji_tm').html();
|
|
var loro=$('#loro_tm').html();
|
|
var telu=$('#telu_tm').html();
|
|
var papat=$('#papat_tm').html();
|
|
var limo=$('#limo').html();
|
|
var enem=$('#enem').html();
|
|
var pitu=$('#pitu').html();
|
|
$('#modal_chart').modal('show');
|
|
$('#modal_body_chart').html("");
|
|
$('#modal_head_chart').html("Grafik - Jumlah Pekerjaan");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/rekap_hutang/chart_jumlah.php",
|
|
data: 'siji='+siji
|
|
+'&loro='+loro
|
|
+'&telu='+telu
|
|
+'&papat='+papat
|
|
+'&limo='+limo
|
|
+'&enem='+enem,
|
|
success: function(data){
|
|
$('#modal_body_chart').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
$('#excel_jml').click(function(){
|
|
var thn = $('#thn_dpa').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.php?thn='+thn,'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_tm').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 TERMIN PROSES PBJ</b>');
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/rekap_hutang/tabel_jm1_tm.php",
|
|
data: 'thn='+thn_dpa
|
|
+'&key='+key,
|
|
success: function(data){
|
|
$('#modal_body_jumlah').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
$('#loro_tm').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 TERMIN SELESAI ADMIN</b>');
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/rekap_hutang/tabel_jm1_tm.php",
|
|
data: 'thn='+thn_dpa
|
|
+'&key='+key,
|
|
success: function(data){
|
|
$('#modal_body_jumlah').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
$('#telu_tm').click(function(){
|
|
var thn_dpa = $('#thn_dpa').val();
|
|
var rk_sopo_id = $('#rk_sopo_id').val();
|
|
var jenis = $('#rk_jenis').val();
|
|
var key = 'telu';
|
|
$('#modal_jumlah').modal('show');
|
|
$('#modal_body_jumlah').html('');
|
|
$('#modal_head_jumlah').html('<b>DATA HUTANG TERMIN SETOR VERIFIKASI</b>');
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/rekap_hutang/tabel_jm1_tm.php",
|
|
data: 'thn='+thn_dpa
|
|
+'&rk_sopo_id='+rk_sopo_id
|
|
+'&jenis='+jenis
|
|
+'&key='+key,
|
|
success: function(data){
|
|
$('#modal_body_jumlah').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
$('#papat_tm').click(function(){
|
|
var thn_dpa = $('#thn_dpa').val();
|
|
var key = 'papat';
|
|
$('#modal_jumlah').modal('show');
|
|
$('#modal_body_jumlah').html('');
|
|
$('#modal_head_jumlah').html('<b>DATA HUTANG TERMIN PROSES VERIFIKASI</b>');
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/rekap_hutang/tabel_jm1_tm.php",
|
|
data: 'thn='+thn_dpa
|
|
+'&key='+key,
|
|
success: function(data){
|
|
$('#modal_body_jumlah').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
$('#limo_tm').click(function(){
|
|
var thn_dpa = $('#thn_dpa').val();
|
|
var key = 'limo';
|
|
$('#modal_jumlah').modal('show');
|
|
$('#modal_body_jumlah').html('');
|
|
$('#modal_head_jumlah').html('<b>DATA HUTANG TERMIN PROSES PELUNASAN</b>');
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/rekap_hutang/tabel_jm1_tm.php",
|
|
data: 'thn='+thn_dpa
|
|
+'&key='+key,
|
|
success: function(data){
|
|
$('#modal_body_jumlah').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
$('#enem_tm').click(function(){
|
|
var thn_dpa = $('#thn_dpa').val();
|
|
var key = 'enem';
|
|
$('#modal_jumlah').modal('show');
|
|
$('#modal_body_jumlah').html('');
|
|
$('#modal_head_jumlah').html('<b>DATA HUTANG TERMIN TERBAYAR</b>');
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/rekap_hutang/tabel_jm1_tm.php",
|
|
data: 'thn='+thn_dpa
|
|
+'&key='+key,
|
|
success: function(data){
|
|
$('#modal_body_jumlah').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
$('#pitu_tm').click(function(){
|
|
var thn_dpa = $('#thn_dpa').val();
|
|
var key = 'pitu';
|
|
$('#modal_jumlah').modal('show');
|
|
$('#modal_body_jumlah').html('');
|
|
$('#modal_head_jumlah').html('<b>DATA HUTANG TERMIM BELUM DIVALIDASI SUDAH DIVERIFIKASI</b>');
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/rekap_hutang/tabel_jm1_tm.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>
|