Files
simak/app/setor/tabel.php
2025-10-10 09:25:05 +07:00

477 lines
27 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'];
$nama_verifikator=$_POST['nama_verifikator'];
$cari_verifikator=$_POST['cari_verifikator'];
$a=strtoupper($_POST['a']);
$b=strtoupper($_POST['b']);
$c=strtoupper($_POST['c']);
$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));
$tempdata=$_POST['tempdata'];
?>
<style type="text/css">
input[type=checkbox] {
transform: scale(1.5);
}
.table > tbody > tr > td {
vertical-align: middle;
}
.modal-backdrop {
visibility: hidden !important;
}
.modal.in {
background-color: rgba(0,0,0,0.5);
}
</style>
<script type="text/javascript">
$('button[name="sub"]').popover();
$('button[name="input_ba"]').popover();
$('button[name="detail"]').popover();
$('button[name="print"]').popover();
$('button[name="batal"]').popover();
$("#tabel_data_laporan").DataTable({"stateSave": true,"paging": false,"lengthChange": true,"searching": false,"ordering": false,"info": true,"autoWidth": false});
</script>
<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" 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="80px;">Panggil</td>
<td align="center">Uraian</td>
<td align="center" width="150px;" style="display:none">Kwi/SP/SPK</td>
<td align="center" width="100px;" style="display:none">Periode</td>
<td align="center" width="90px;" style="display:none">Model</td>
<td align="center" width="130px;">Nilai</td>
<td align="center" width="90px;">Tgl Setor</td>
<td align="center" width="90px;">Tgl Lunas</td> <!-- 8 -->
<!--<td align="center" width="70px;">Diterima</td>-->
<td align="center" width="130px;">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
/*
$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,COALESCE(n.nama,p.cad1),l.tanggal_dokumen,l.idx_kwi_bend
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)
LEFT OUTER JOIN rekanan n ON (n.id=p.rekanan_id)
WHERE s.thn='$thn' AND l.nama_verfikator='$nama_verifikator' AND l.status_berkas='FIX'
".($tm1 == null ? "" : "AND l.tanggal_setor::DATE BETWEEN '$tt1-$bb1-$hh1' AND '$tt2-$bb2-$hh2'")."
".($a == 'ALL' ? "" : "
".($a == 'FUNGSIONAL' ? "AND LEFT(s.kegiatan,2) NOT IN ('**')" : "AND LEFT(s.kegiatan,2) IN ('**')")."
")."
".($b == 'ALL' ? "" : "
".($b == 'NON UANG MUKA' ? "AND l.status_um='Non Uang Muka'" : "AND l.status_um='Uang Muka'")."
")."
".($c == 'ALL' ? "AND l.tanggal_setor IS NOT NULL" : "AND l.tanggal_setor IS NULL")."
ORDER BY l.tanggal_setor DESC
");
*/
$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,COALESCE(n.nama,p.cad1),l.tanggal_dokumen,l.idx_kwi_bend,r.stum,l.ket,l.tanggal_lunas,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)
LEFT OUTER JOIN rekanan n ON (n.id=p.rekanan_id)
WHERE s.thn='$thn' AND l.status_berkas='FIX'
".($cari_verifikator == '' ? "" : "AND l.nama_verfikator='$cari_verifikator'")."
".($tm1 == null ? "" : "AND l.tanggal_setor::DATE BETWEEN '$tt1-$bb1-$hh1' AND '$tt2-$bb2-$hh2'")."
".($a == 'ALL' ? "" : "
".($a == 'FUNGSIONAL' ? "AND LEFT(s.kegiatan,2)!='**'" : "AND LEFT(s.kegiatan,2)='**'")."
")."
".($b == 'ALL' ? "" : "
".($b == 'NON UANG MUKA' ? "AND l.status_um='Non Uang Muka'" : "AND l.status_um='Uang Muka'")."
")."
".($c == 'ALL' ? "AND l.tanggal_setor IS NOT NULL" : "AND l.tanggal_setor IS NULL")."
ORDER BY l.tanggal_setor DESC
");
$totjml=0;
$totnilai=0;
while($r=pg_fetch_array($d)) {
$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
<?php
/* if (($tgl_maxbast==NULL) || ($tgl_maxbast=='') || ($tgl_maxbast=='1970-01-01 00:00:00')) {} else {
if (date('Y-m-d',strtotime($r['tgl_selesai_sp']))<date('Y-m-d',strtotime($tgl_maxbast))) {
echo "style='color:red'";
}
}*/
?>
>
<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">
</td>
<td align="center"><?php echo $r['kd_panggil'];?></td>
<!--<td><?php echo strtoupper($r['kegiatan'].' - '.$r['kegiatan_pengadaan'].' - '.$r[31].''.$ket2);?></td>-->
<!--<td>
<span style="color:black"><?php echo $r[31].''.$ket2; ?></span><br>
<span><?php echo strtoupper($r['sub_kegiatan'].' - '.$r['kegiatan'].' - '.$r['kegiatan_pengadaan']);?></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[31].''.$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 align="center" 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><?php
if ($r[30]=='0') {echo strtoupper($r['st_buku'].'<br>'.$trm);} else {
echo strtoupper($r['st_buku'].'<br>'.$trm);
}
?></td>-->
<td align="center" style="display:none"><?php
if ($r[30]=='0') {echo strtoupper($r['st_buku']);} else {
echo strtoupper($r['st_buku']);
}
?></td>
<td align="right"><?php echo number_format($r['nilai_pelunasan'],0,',','.'); ?></td>
<td align="center" style="color:blue"><span style="font-family:InterSB" class="tangset" id="<?php echo $r['id'];?>" ><?php if ($r['tanggal_setor']==NULL) {} else {echo date('d-m-Y',strtotime($r['tanggal_setor']));} ?></span></td>
<td align="center" style="color:purple"><?php if ($r['tanggal_lunas']==NULL) {} else {echo date('d-m-Y',strtotime($r['tanggal_lunas']));} ?></td>
<!--<td align="center"><?php if ($r['tanggal_dokumen']==NULL) {} else {echo date('d-m-Y H:i',strtotime($r['tanggal_dokumen']));} ?></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 ((($r['idx_kwi_bend']==NULL) || ($r['idx_kwi_bend']=='')) && ($nama_verifikator==$cari_verifikator)) { ?>
<button type="button" name="batal" style="height:22px;"class="btn btn-inverse btn-xs batal" id="<?php echo $r['id'];?>" data-content="Batal Setor" rel="popover" data-placement="top" data-trigger="hover"
>
<i class="fa fa-remove"></i>
</button>
<?php } else {} ?>
</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
$totjml=$totjml+1;
$totnilai=$totnilai+$r['nilai_pelunasan'];
}
?>
</tbody>
</table>
<input type="hidden" id="totjml" value="<?php echo $totjml; ?>">
<input type="hidden" id="totnilai" value="<?php echo number_format($totnilai,0,',','.'); ?>">
<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>
var totjml=$('#totjml').val();
var totnilai=$('#totnilai').val();
$('#setor_totjml').val(totjml+' Data');
$('#setor_totnilai').val(totnilai);
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();
});
$("#tabel_data_laporan").on('click','.batal',function(){
var x = confirm("Anda yakin ingin membatalkan ?");
if (x) {
var id = $(this).attr('id');
var key = 'batal';
$.ajax({
type: "POST",
url: "app/lap_setor/crud.php",
data: 'id='+id
+'&key='+key,
success: function(data){
alert('Pembatalan Peyetoran sukses..');
var thn=$('#thn_dpa').val();
var a = $('#c1').val();
var b = $('#c2').val();
var c = $('#c3').val();
var m = $('#tgl_mulai1').val();
var s = $('#tgl_selesai1').val();
var nama_verifikator=$('#cek_nampeg').val();
var cari_verifikator=$('#cari_verifikator').val();
$('#tabel_laporan').load('app/setor/tabel.php',{cari_verifikator:cari_verifikator,nama_verifikator:nama_verifikator,a:a,b:b,c:c,m:m,s:s,thn:thn});
}
});
}
});
$("#tabel_data_laporan").on('click','.tangset',function(){
$('#modal_edit_tgl_setor').modal('show');
$('#modal_body_edit_tgl_setor').html("");
var id = $(this).attr('id');
$.ajax({
type: "POST",
url: "app/setor/modal_edit_setor.php",
data: 'id='+id,
success: function(data){
$('#modal_body_edit_tgl_setor').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(10)").text();
var nilai_pelunasan = currentRow.find("td:eq(11)").text();
var vr_pelunasan_id = currentRow.find("td:eq(12)").text();
var tglselsp = currentRow.find("td:eq(13)").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');
}
});
</script>