Files
2025-10-10 09:25:05 +07:00

474 lines
28 KiB
PHP
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
<?php
include("../koneksi.php");
$thn=$_POST['thn'];
$cari_verifikator=$_POST['cari_verifikator'];
$nama_verifikator=$_POST['nama_verifikator'];
$jenis=$_POST['jenis'];
$axx=$_POST['axx'];
$bxx=$_POST['bxx'];
$cxx=$_POST['cxx'];
$tm1=$_POST['m'];
$tm1=str_replace('/','-',$tm1);
$tt1=date('Y',strtotime($tm1));
$bb1=date('m',strtotime($tm1));
$hh1=date('d',strtotime($tm1));
$ts1=$_POST['s'];
$ts1=str_replace('/','-',$ts1);
$tt2=date('Y',strtotime($ts1));
$bb2=date('m',strtotime($ts1));
$hh2=date('d',strtotime($ts1));
?>
<script type="text/javascript">
$("#tabel_data_laporanc").DataTable({"stateSave": true,"paging": true,"lengthChange": true,"searching": true,"ordering": false,"info": true,"autoWidth": false});
</script>
<style>
.modal-backdrop {
visibility: hidden !important;
}
.modal.in {
background-color: rgba(0,0,0,0.5);
}
</style>
<input type="hidden" id="temp_data" style="width:600px" value="<?php echo $tempdata; ?>"><br>
<table id="tabel_data_laporan" class="table table-striped table-condensed table-bordered" style="font-size:13px" cellpadding="1">
<thead style="color:grey;font-family:InterSB">
<tr>
<td align="center" width="30">
<input type="checkbox" name="checkAll" id="checkAll" class="checkbox cb_data" aria-label="Single checkbox Two" ></td>
<td align="center" width="20px;">KPA</td>
<td align="center" width="20px;">KOM</td>
<td align="center" width="20px;">PPTK</td>
<td align="center">Panggil</td>
<td align="center">Uraian</td>
<td align="center" width="150px;" style="display:none">Kwi/SP/SPK</td>
<td align="center" width="110px;" style="display:none">Periode</td>
<td align="center" width="100px;" style="display:none">Model</td>
<td align="center" width="90px;">Tgl Verif</td>
<td align="center" width="110px;">Nilai</td>
<td align="center" width="120px;">Detail</td>
<td style="display:none"></td>
<td style="display:none"></td>
<td style="display:none"></td>
<td style="display:none"></td>
</tr>
</thead>
<tbody style="color:black;font-family:Inter">
<?php
$c=pg_query("SELECT DISTINCT s.sub_kegiatan
FROM pekerjaan p
INNER JOIN sub_kegiatan s ON (p.sub_kegiatan_id=s.id)
INNER JOIN vr_realisasi r ON (r.pekerjaan_id=p.id)
INNER JOIN vr_pelunasan l ON (l.vr_realisasi_id=r.id)
INNER JOIN kpa a1 ON (s.kpa_id=a1.id)
INNER JOIN ppkom a2 ON (s.ppkom_id=a2.id)
INNER JOIN pptk a3 ON (s.pptk_id=a3.id)
WHERE s.thn='$thn' AND l.status_berkas IN ('FIX','PROSES') AND l.tanggal_setor IS NULL AND p.status_setor IS NULL
".($tm1 == null ? "" : "AND l.tgl_terima_verif::DATE BETWEEN '$tt1-$bb1-$hh1' AND '$tt2-$bb2-$hh2'")."
".($axx == '' ? "" : "AND s.kpa_id='$axx'")."
".($bxx == '' ? "" : "AND s.ppkom_id='$bxx'")."
".($cxx == '' ? "" : "AND s.pptk_id='$cxx'")."
".($cari_verifikator == '' ? "" : "AND COALESCE(p.user_nama,l.nama_verfikator)='$cari_verifikator'")."
");
while($v=pg_fetch_array($c)) {
$skg=$v[0];
?>
<tr><td colspan="10"><span style="font-family:InterSB;color:orange"><?php echo strtoupper($skg);?></span></td></tr>
<?php
$e=pg_query("SELECT DISTINCT s.kegiatan
FROM pekerjaan p
INNER JOIN sub_kegiatan s ON (p.sub_kegiatan_id=s.id)
INNER JOIN vr_realisasi r ON (r.pekerjaan_id=p.id)
INNER JOIN vr_pelunasan l ON (l.vr_realisasi_id=r.id)
INNER JOIN kpa a1 ON (s.kpa_id=a1.id)
INNER JOIN ppkom a2 ON (s.ppkom_id=a2.id)
INNER JOIN pptk a3 ON (s.pptk_id=a3.id)
WHERE s.thn='$thn' AND l.status_berkas IN ('FIX','PROSES') AND l.tanggal_setor IS NULL
AND s.sub_kegiatan='$skg'
".($tm1 == null ? "" : "AND l.tgl_terima_verif::DATE BETWEEN '$tt1-$bb1-$hh1' AND '$tt2-$bb2-$hh2'")."
".($axx == '' ? "" : "AND s.kpa_id='$axx'")."
".($bxx == '' ? "" : "AND s.ppkom_id='$bxx'")."
".($cxx == '' ? "" : "AND s.pptk_id='$cxx'")."
".($cari_verifikator == '' ? "" : "AND COALESCE(p.user_nama,l.nama_verfikator)='$cari_verifikator'")."
");
while($b=pg_fetch_array($e)) {
$blh=$b[0];
?>
<?php
$tot=0;
$d=pg_query("SELECT s.no_angg,s.kd_panggil,s.sub_kegiatan,s.ra,s.rb,s.rc,s.rd,s.re,s.rf,s.rg,s.rh,s.kd_sibaku,s.kegiatan,
p.kegiatan_pengadaan,l.tanggal_setor,
l.nilai_pelunasan,l.ppn,l.pph_21,l.pph_22,l.pph_23,l.pph_final,
p.no_sp,l.no_faktur,p.tgl_mulai_sp,p.tgl_selesai_sp,r.st_buku,r.st_termin,l.tanggal_input,l.id,r.pekerjaan_id,
CASE WHEN r.st_termin='termin' THEN
l.data_ke
ELSE '0' END,l.tanggal_input,a1.inisial,a2.inisial,a3.inisial,p.cad1,COALESCE(n.nama,p.cad1),r.stum,l.tgl_terima_verif,l.ket,p.no_spp
FROM pekerjaan p
INNER JOIN sub_kegiatan s ON (p.sub_kegiatan_id=s.id)
INNER JOIN vr_realisasi r ON (r.pekerjaan_id=p.id)
INNER JOIN vr_pelunasan l ON (l.vr_realisasi_id=r.id)
INNER JOIN kpa a1 ON (s.kpa_id=a1.id)
INNER JOIN ppkom a2 ON (s.ppkom_id=a2.id)
INNER JOIN pptk a3 ON (s.pptk_id=a3.id)
LEFT OUTER JOIN rekanan n ON (n.id=p.rekanan_id)
WHERE s.thn='$thn' AND l.status_berkas IN ('FIX','PROSES') AND l.tanggal_setor IS NULL
AND s.sub_kegiatan='$skg' AND s.kegiatan='$blh'
".($tm1 == null ? "" : "AND l.tgl_terima_verif::DATE BETWEEN '$tt1-$bb1-$hh1' AND '$tt2-$bb2-$hh2'")."
".($axx == '' ? "" : "AND s.kpa_id='$axx'")."
".($bxx == '' ? "" : "AND s.ppkom_id='$bxx'")."
".($cxx == '' ? "" : "AND s.pptk_id='$cxx'")."
".($cari_verifikator == '' ? "" : "AND COALESCE(p.user_nama,l.nama_verfikator)='$cari_verifikator'")."
");
while($r=pg_fetch_array($d)) {
$vrprlid=$r['id'];
$drev=pg_query("SELECT COUNT(*) FROM vr_revisi WHERE vr_pelunasan_id=$vrprlid");
while($rdrev=pg_fetch_array($drev)) {$jrev=$rdrev[0];}
$pekerjaan_id=$r['pekerjaan_id'];
$stum=$r['stum'];
if ($r[30]=='0') {
if ($stum=='uang_muka') {$trm='UANG MUKA';} else {$trm='';}
} else {$trm=strtoupper(($r['st_termin'].' '.$r[30]));}
$ket1=strtoupper($r['ket']);
if ($ket1=='KURANG BAYAR') {$ket2=' ('.$ket1.')';} else {$ket2='';}
if (($r['tgl_mulai_sp']==null) || ($r['tgl_mulai_sp']=='1970-01-01 00:00:00')) {$tglkn='';} else {
$tglkn=date('d-m-Y',strtotime($r['tgl_mulai_sp'])).' s/d '.date('d-m-Y',strtotime($r['tgl_selesai_sp'])); }
?>
<tr>
<td align="center" class="kiri">
<input
type="checkbox" id='checkDelete' name='checkDelete[]' class="checkbox cb_data" value="<?php echo $r['id']; ?>"
aria-label="Single checkbox Two"
<?php
if($tempdata) {
$pizza = "$tempdata";
$pieces = explode(",", $pizza);
foreach ($pieces as $value) {
if ($r['id']==$value) {echo "checked";} else {}
}
} else {}
?>
>
</td>
<td align="center"><?php echo $r[32];?></td>
<td align="center"><?php echo $r[33];?></td>
<td align="center"><?php echo $r[34];?></td>
<td align="center"><?php echo $r['kd_panggil'];?></td>
<!--<td>
<?php
if ($r[35]==NULL) {
echo strtoupper($r['kegiatan'].' - '.$r['kegiatan_pengadaan'].' - '.$r[36]);
} else {
echo strtoupper($r['kegiatan'].' - a.n. '.$r[35]);
}
?></td>-->
<!--<td>
<span style="color:black"><?php echo $r[36].''.$ket2; ?></span><br>
<span><?php echo strtoupper($r['sub_kegiatan'].' - '.$r['kegiatan'].' - '.$r['kegiatan_pengadaan']);?></span><br>
<span style="color:blue"><i class="mdi mdi-apps m-r-5"></i><?php if (($r['tgl_mulai_sp']==null) || ($r['tgl_mulai_sp']=='1970-01-01 00:00:00')) {} else {
echo 'Tanggal. '.date('d-m-Y',strtotime($r['tgl_mulai_sp'])).' s/d '.date('d-m-Y',strtotime($r['tgl_selesai_sp'])); }
?></span><br>
<span style="color:green"><i class="mdi mdi-apps m-r-5"></i><?php echo $r['no_sp'].'<br><span style="color:red">'.$trm.'</span>';?></span>
</td>-->
<td>
<span style="color:black;font-family:InterSB"><?php echo $r[36].''.$ket2; ?></span><br>
<span><?php echo $r['sub_kegiatan'].' - '.$r['kegiatan'].' - '.$r['kegiatan_pengadaan'];?></span><br>
<span style="color:blue;font-family:InterSB"><i class="mdi mdi-apps m-r-5"></i><?php echo $r['no_sp'].' <span style="color:green"><i class="mdi mdi-play m-r-5"></i>'.$tglkn.'</span>';?>
<?php if (($r['no_spp']==NULL) || ($r['no_spp']=='')) {} else { ?><br><span style="font-family:Arial;font-weight:bold;color:violet;font-size:14px"><?php echo 'SPP/SPMK.'.$r['no_spp']; ?></span><?php }?>
<?php if (($trm==NULL) || ($trm=='')) {} else { ?><br><span style="font-family:InterSB;color:red"><?php echo $trm; ?></span><?php }?>
</span>
</td>
<td style="display:none"><?php echo $r['no_sp'];?></td>
<td style="display:none"><?php
if (($r['tgl_mulai_sp']==null) || ($r['tgl_mulai_sp']=='1970-01-01 00:00:00')) {} else {
echo date('d-m-Y',strtotime($r['tgl_mulai_sp'])).' s/d '.date('d-m-Y',strtotime($r['tgl_selesai_sp'])); }
?></td>
<td style="display:none"><?php
if ($r[30]=='0') {echo strtoupper($r['st_buku'].'<br>'.$trm);} else {
echo strtoupper($r['st_buku'].'<br>'.$trm);
}
?></td>
<td align="center"><?php if ($r['tgl_terima_verif']==NULL) {} else {echo date('d-m-Y H:i',strtotime($r['tgl_terima_verif']));} ?></td>
<td align="right"><?php echo number_format($r['nilai_pelunasan'],0,',','.'); ?></td>
<td align="center" class="kanan">
<button type="button" name="print" style="height:22px;"class="btn btn-default btn-xs print" id="<?php echo $r['id'];?>" data-content="Ceklist" rel="popover" data-placement="top" data-trigger="hover"
>
<i class="glyphicon glyphicon-print"></i>
</button>
<button type="button" name="sub" style="height:22px;"class="btn btn-primary btn-xs sub" id="<?php echo $r['pekerjaan_id'];?>" data-content="Sub" rel="popover" data-placement="top" data-trigger="hover"
>
<i class="fa fa-ellipsis-h"></i>
</button>
<button type="button" name="detail" style="height:22px;"class="btn btn-success btn-xs detail" id="<?php echo $r['id'];?>" data-content="Verifikasi" rel="popover" data-placement="top" data-trigger="hover"
>
<i class="fa fa-ellipsis-h"></i>
</button>
<button type="button" name="input_ba" style="height:22px;"class="btn btn-orange btn-xs input_ba" id="<?php echo $r['pekerjaan_id'];?>" data-content="Data BA" rel="popover" data-placement="top" data-trigger="hover"
>
<i class="fa fa-ellipsis-h"></i>
</button>
<?php if (($jrev==0) || ($vrprlid==NULL)) {} else { ?>
<br>
<span>
<button type="button" name="revdat" style="margin-top:5px;height:22px;font-family:Arial;font-weight:bold;color:red"class="btn btn-default btn-xs revdat" id="<?php echo $r['id'];?>" data-content="Riwayat Revisi" rel="popover" data-placement="top" data-trigger="hover"
><?php echo '<span>'.$jrev.' Data Revisi</span>'; ?>
</button>
</span>
<?php } ?>
</td>
<td style="display:none" class="stmin"><?php echo $r['st_termin'];?></td>
<td style="display:none" class="stmin"><?php echo $r['nilai_pelunasan'];?></td>
<td style="display:none" class="stmin"><?php echo $r['id'];?></td>
<td style="display:none" class="tglselsp"><?php echo $r['tgl_selesai_sp']; ?></td>
</tr>
<?php
$tot=$tot+$r['nilai_pelunasan'];
}
?>
<tr>
<td colspan="7" align="right"><span style="font-family:InterSB;color:green"><?php echo strtoupper($blh);?></span></td>
<td colspan="3" align="right"><span style="font-family:InterSB;color:green"><?php echo number_format($tot,0,',','.'); ?></span></td>
<!--<td colspan="1"><span style="font-family:InterSB;color:red"></span></td>-->
</tr>
<?php
}
?>
<tr><td colspan="10"><span style="font-family:InterSB;color:red">&nbsp;</span></td></tr>
<?php
}
?>
</tbody>
</table>
<div id="modal_bac" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header no-border">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4 class="modal-title" id="myModalLabel">Berita Acara</h4>
</div>
<div class="modal-body" id="modal_body_bac"></div>
<div class="modal-footer no-border">
<button type="button" class="btn btn-default waves-effect" data-dismiss="modal" id="keluar_bac">Keluar</button>
</div>
</div>
</div>
</div>
<div id="modal_databa_baruc" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header no-border">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4 class="modal-title" id="myModalLabel">Input BA</h4>
</div>
<div class="modal-body" id="modal_body_databa_baruc"></div>
<div class="modal-footer no-border">
<button type="button" class="btn btn-default waves-effect" data-dismiss="modal" id="keluar_databa_baruc">Keluar</button>
<button type="button" class="btn btn-primary waves-effect waves-light" id="simpan_databa_baruc">Simpan</button>
</div>
</div>
</div>
</div>
<div id="modal_databa_caric" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header no-border">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4 class="modal-title" id="myModalLabel">CARI DATA BA YANG DI-INPUT PENGADAAN</h4>
</div>
<div class="modal-body" id="modal_body_databa_caric"></div>
<div class="modal-footer no-border">
<button type="button" class="btn btn-default waves-effect" data-dismiss="modal" id="keluar_databa_caric">Keluar</button>
<button type="button" class="btn btn-primary waves-effect waves-light" id="simpan_databa_caric">Masukkan ke tabel BA</button>
</div>
</div>
</div>
</div>
<script>
$('button[name="sub"]').popover();
$('button[name="input_ba"]').popover();
$('button[name="detail"]').popover();
$('button[name="print"]').popover();
$("#tabel_data_laporan").on('click','.revdat',function(){
var vr_pelunasan_id = $(this).attr('id');
$('#modal_revdat').modal('show');
$('#modal_body_revdat').html("");
$.ajax({
type: "POST",
url: "app/pencarian/modal_revdat.php",
data: 'vr_pelunasan_id='+vr_pelunasan_id,
success: function(data){
$('#modal_body_revdat').html(data);
}
});
});
$("#tabel_data_laporan").on('click','.sub',function(){
var pekerjaan_id = $(this).attr('id');
$('#modal_sub').modal('show');
$('#modal_body_sub').load("app/kendali/konten_kendali.php #abc",{pekerjaan_id:pekerjaan_id});
});
$("#tabel_data_laporan").on('click','.detail',function(){
var id = $(this).attr('id');
$('#modal_verifikasi').modal('show');
$('#modal_body_verifikasi').html("");
$.ajax({
type: "POST",
url: "app/kendali/modal_verifikasi.php",
data: 'id='+id,
success: function(data){
$('#modal_body_verifikasi').html(data);
$("#form_verifikasi *").prop("disabled", true);
}
});
});
$("#tabel_data_laporan").on('click','.print',function(){
var id = $(this).attr('id');
var w = 1050;
var h = 500;
var left = Number((screen.width/2)-(w/2));
var tops = Number((screen.height/2)-(h/2));
window.open('app/kendali/ceklist/print.php?id='+id,'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);
});
$("#tabel_data_laporan").on('click','.input_ba',function(){
var id = $(this).attr('id');
var currentRow=$(this).closest("tr");
var st_termin = currentRow.find("td:eq(12)").text();
var nilai_pelunasan = currentRow.find("td:eq(13)").text();
var vr_pelunasan_id = currentRow.find("td:eq(14)").text();
var tglselsp = currentRow.find("td:eq(15)").text();
$('#modal_bac').modal('show');
$('#modal_body_bac').html("");
$.ajax({
type: "POST",
url: "app/input_ba/modal_ba.php",
data: 'pekerjaan_id='+id
+'&st_termin='+st_termin
+'&nilai_pelunasan='+nilai_pelunasan
+'&vr_pelunasan_id='+vr_pelunasan_id
+'&tglselsp='+tglselsp,
success: function(data){
$('#modal_body_bac').html(data);
}
});
});
$('#simpan_databa_baruc').click(function(){
var id = $('#riwayat_ba_id').val();
var pekerjaan_id = $('#pekerjaan_idv').val();
var berita_acara_id = $('#berita_acara_id').val();
var nomor_ba = $('#nomor_ba').val();
var tanggal_ba = $('#tanggal_ba').val();
var nilai_ba = $('#nilai_ba').val();
var vr_pelunasan_id = $('#vr_pelunasan_idv').val();
var st_termin = $('#st_termin_ba').val();
var termin_ke = $('#termin_ke').val();
var key = 'simpan_databa_baru';
$.ajax({
type: "POST",
url: "app/kendali/crud.php",
data: 'id='+id
+'&pekerjaan_id='+pekerjaan_id
+'&berita_acara_id='+berita_acara_id
+'&nomor_ba='+nomor_ba
+'&tanggal_ba='+tanggal_ba
+'&nilai_ba='+nilai_ba
+'&vr_pelunasan_id='+vr_pelunasan_id
+'&st_termin='+st_termin
+'&termin_ke='+termin_ke
+'&key='+key,
success: function(data){
alert('Data tersimpan..');
$('#modal_databa_baruc').modal('hide');
$('body').removeClass('modal-open');
$('.modal-backdrop').remove();
//$('#tabel_databa').load("app/input_ba/tabel_ba.php",{pekerjaan_id:pekerjaan_id});
var nilai_pelunasan = $('#nilai_pelunasanv').val();
var tglselsp = $('#tglselspv').val();
$('#tabel_databa').load("app/input_ba/tabel_ba.php",{pekerjaan_id:pekerjaan_id, vr_pelunasan_id:vr_pelunasan_id, nilai_pelunasan:nilai_pelunasan, tglselsp:tglselsp});
}
});
});
$('#simpan_databa_caric').click(function(){
var a = $('#temp_data_c').val();
if (!a) {alert('Centanglah mana yang mau dimasukkan');} else {
var riwayat_ba_id = $('#temp_data_c').val();
var pekerjaan_id = $('#pekerjaan_idv').val();
var vr_pelunasan_id = $('#vr_pelunasan_idv').val();
var key = 'simpan_databa_cari';
$.ajax({
type: "POST",
url: "app/kendali/crud.php",
data: 'riwayat_ba_id='+riwayat_ba_id
+'&pekerjaan_id='+pekerjaan_id
+'&vr_pelunasan_id='+vr_pelunasan_id
+'&key='+key,
success: function(data){
alert('Data BA masuk ke tabel..');
$('#modal_databa_caric').modal('hide');
$('body').removeClass('modal-open');
$('.modal-backdrop').remove();
//$('#tabel_databa').load("app/input_ba/tabel_ba.php",{pekerjaan_id:pekerjaan_id, vr_pelunasan_id:vr_pelunasan_id});
var nilai_pelunasan = $('#nilai_pelunasanv').val();
var tglselsp = $('#tglselspv').val();
$('#tabel_databa').load("app/input_ba/tabel_ba.php",{pekerjaan_id:pekerjaan_id, vr_pelunasan_id:vr_pelunasan_id, nilai_pelunasan:nilai_pelunasan,tglselsp:tglselsp});
}
});
}
});
$("#tabel_data_laporan").on('click','.print',function(){
var id = $(this).attr('id');
var w = 1050;
var h = 500;
var left = Number((screen.width/2)-(w/2));
var tops = Number((screen.height/2)-(h/2));
window.open('app/ceklist/pdf_ceklist.php?id='+id,'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);
});
$(document).on('hidden.bs.modal', function (event) {
if ($('.modal:visible').length) {
$('body').addClass('modal-open');
}
});
function getSelectedVal(){
var ID={};
ID.values=[];
$("input#checkDelete").each(function(){
var $this = $(this);
if($this.is(":checked")){
ID.values.push($this.attr("value"));
}
$("#temp_data").val(ID.values);
});
}
$("#checkAll").click(function () {
$('input:checkbox').not(this).prop('checked', this.checked);
});
$("input[type='checkbox']").change(function() {
getSelectedVal();
});
</script>