388 lines
24 KiB
PHP
388 lines
24 KiB
PHP
<?php
|
|
include("../koneksi.php");
|
|
$thn=$_POST['thn'];
|
|
$axx=$_POST['axx'];
|
|
$bxx=$_POST['bxx'];
|
|
$cxx=$_POST['cxx'];
|
|
$axxx=$_POST['axxx'];
|
|
$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">
|
|
$('button[name="sub"]').popover();
|
|
$('button[name="input_ba"]').popover();
|
|
$('button[name="detail"]').popover();
|
|
$('button[name="pelunasan"]').popover();
|
|
$('button[name="batal"]').popover();
|
|
$('button[name="cnv"]').popover();
|
|
|
|
$("#tabel_data_laporan").DataTable({"stateSave": true,"paging": true,"lengthChange": true,"searching": true,"ordering": false,"info": true,"autoWidth": false});
|
|
</script>
|
|
<input type="hidden" id="thn" value="<?php echo $thn; ?>">
|
|
<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="20px;">KPA</td>
|
|
<td align="center" width="50px;">Kd</td>
|
|
<td align="center">Uraian</td>
|
|
|
|
<td align="center" width="150px;" style="display:none">Kwi/SP/SPK</td>
|
|
<td align="center" width="98px;" style="display:none">Periode</td>
|
|
|
|
<td align="center" width="90px;" style="display:none">Model</td>
|
|
<td align="center" width="120px;">Nilai</td>
|
|
<td align="center" width="80px;">PPN</td>
|
|
<td align="center" width="80px;">PPH</td>
|
|
<td align="center" width="10px;">:::</td>
|
|
<td align="center" width="90px;">Tgl Setor</td>
|
|
<td align="center" width="110px;">Verifikator</td>
|
|
<td align="center" width="100px;">Detail</td>
|
|
<td align="center" width="100px;" style="display:none">Status UM</td>
|
|
<td align="center" width="100px;" style="display:none">Status UM</td>
|
|
<td align="center" width="100px;" style="display:none">Status UM</td>
|
|
<td align="center" width="100px;" style="display:none">Status UM</td>
|
|
<td align="center" width="100px;" style="display:none">Status UM</td>
|
|
<td align="center" width="100px;" style="display:none">Status UM</td>
|
|
<td align="center" width="100px;" style="display:none">Status UM</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.nama_verfikator,l.status_um,r.stum,l.ket,
|
|
(SELECT pg.nama_non FROM sp_peg pg WHERE pg.pekerjaan_id=p.id),p.status_setor,k.inisial,b.inisial as bp,l.nama_verfikator
|
|
FROM pekerjaan p
|
|
INNER JOIN sub_kegiatan s ON (p.sub_kegiatan_id=s.id)
|
|
INNER JOIN kpa k ON (k.id=s.kpa_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 bp b ON (b.id=s.bp_id)
|
|
LEFT OUTER JOIN rekanan n ON (n.id=p.rekanan_id)
|
|
WHERE s.thn='$thn' AND l.status_berkas='FIX' AND l.tanggal_setor IS NOT NULL AND l.tanggal_lunas IS NULL
|
|
".($tm1 == null ? "" : "AND l.tanggal_setor::DATE BETWEEN '$tt1-$bb1-$hh1' AND '$tt2-$bb2-$hh2'")."
|
|
".($axx == '' ? "" : "AND s.kpa_id='$axx'")."
|
|
".($cxx == 'ALL' ? "" : "
|
|
".($cxx == 'FARMASI' ? "AND lower(s.sub_kegiatan) LIKE '%farmasi%'" : "AND lower(s.sub_kegiatan) NOT LIKE '%farmasi%'")."
|
|
")."
|
|
".($bxx == 'ALL' ? "" : "
|
|
".($bxx == 'NON UANG MUKA' ? "AND l.status_um='Non Uang Muka'" : "AND l.status_um='Uang Muka'")."
|
|
")."
|
|
".($axxx == 'ALL' ? "" : "
|
|
".($axxx == 'FUNGSIONAL' ? "AND LEFT(s.kegiatan,2)!='**'" : "AND LEFT(s.kegiatan,2)='**'")."
|
|
")."
|
|
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.nama_verfikator,l.status_um,r.stum,l.ket,
|
|
(SELECT pg.nama_non FROM sp_peg pg WHERE pg.pekerjaan_id=p.id),p.status_setor,k.inisial,b.inisial as bp,l.nama_verfikator,
|
|
rb.nomor_ba,rb.nilai_ba,p.no_spp
|
|
FROM pekerjaan p
|
|
INNER JOIN sub_kegiatan s ON (p.sub_kegiatan_id=s.id)
|
|
INNER JOIN kpa k ON (k.id=s.kpa_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 bp b ON (b.id=s.bp_id)
|
|
LEFT OUTER JOIN rekanan n ON (n.id=p.rekanan_id)
|
|
LEFT OUTER JOIN (SELECT * FROM riwayat_ba WHERE berita_acara_id=8) rb ON (l.id=rb.vr_pelunasan_id)
|
|
WHERE s.thn='$thn' AND l.status_berkas='FIX' AND l.tanggal_setor IS NOT NULL AND l.tanggal_lunas IS NULL
|
|
".($tm1 == null ? "" : "AND l.tanggal_setor::DATE BETWEEN '$tt1-$bb1-$hh1' AND '$tt2-$bb2-$hh2'")."
|
|
".($axx == '' ? "" : "AND s.kpa_id='$axx'")."
|
|
".($cxx == 'ALL' ? "" : "
|
|
".($cxx == 'FARMASI' ? "AND lower(s.sub_kegiatan) LIKE '%farmasi%'" : "AND lower(s.sub_kegiatan) NOT LIKE '%farmasi%'")."
|
|
")."
|
|
".($bxx == 'ALL' ? "" : "
|
|
".($bxx == 'NON UANG MUKA' ? "AND l.status_um='Non Uang Muka'" : "AND l.status_um='Uang Muka'")."
|
|
")."
|
|
".($axxx == 'ALL' ? "" : "
|
|
".($axxx == 'FUNGSIONAL' ? "AND LEFT(s.kegiatan,2)!='**'" : "AND LEFT(s.kegiatan,2)='**'")."
|
|
")."
|
|
ORDER BY l.tanggal_setor DESC
|
|
");
|
|
while($r=pg_fetch_array($d)) {
|
|
$bp=$r['bp'];
|
|
$nama_verfikator=$r['nama_verfikator'];
|
|
$ssetor=$r['status_setor'];
|
|
if($r[31]=='') {$soporek=$r[36];} else {$soporek=$r[31];}
|
|
$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='';}
|
|
$cek_sppd=substr($r['no_sp'],0,4);
|
|
if ($cek_sppd=='SPPD') {
|
|
$pekerjaan_id=$r['pekerjaan_id'];
|
|
$un=pg_query("SELECT s.untuk,s.tgl_berangkat,s.tgl_kembali FROM sp_spt s INNER JOIN sp_peg p ON (s.id=p.sp_spt_id) WHERE p.pekerjaan_id=$pekerjaan_id");
|
|
while($run=pg_fetch_array($un)) {$drangka=$run[0];$sbrk=$run[1];$skbl=$run[2];}
|
|
} else {}
|
|
if ((isset($r['pph_21'])) && ($r['pph_21']!=0)) {
|
|
$pph=$r['pph_21'];
|
|
$pasal='21';
|
|
} else
|
|
if ((isset($r['pph_22'])) && ($r['pph_22']!=0)) {
|
|
$pph=$r['pph_22'];
|
|
$pasal='22';
|
|
} else
|
|
if ((isset($r['pph_23'])) && ($r['pph_23']!=0)) {
|
|
$pph=$r['pph_23'];
|
|
$pasal='23';
|
|
} else
|
|
if ((isset($r['pph_final'])) && ($r['pph_final']!=0)) {
|
|
$pph=$r['pph_final'];
|
|
$pasal='FNL';
|
|
} else {$pph=0;$pasal='';}
|
|
|
|
if ((isset($r['ppn'])) && ($r['ppn']!=0)) {$ppn=$r['ppn'];} else {$ppn=0;}
|
|
?>
|
|
<tr>
|
|
<td align="center" class="kiri"><?php echo $r['inisial'];?></td>
|
|
<td align="center">
|
|
<span><?php echo $r['kd_panggil'];?></span>
|
|
</td>
|
|
<td>
|
|
|
|
<?php
|
|
if ($cek_sppd=='SPPD') {
|
|
$tglsppd=date('d-m-Y',strtotime($sbrk)).' s/d '.date('d-m-Y',strtotime($skbl));
|
|
echo '<span style="color:green;font-family:InterSB">'.$r['no_sp'].'</span><br>';
|
|
echo $r['kegiatan'].' dalam rangka '.$drangka;
|
|
echo '<br><span style="color:brown;"><i class="mdi mdi-check-circle-outline m-r-5"></i>'.$bp.'/'.$nama_verfikator.'</span>';
|
|
echo '<br><span style="color:blue;font-family:InterSB"><i class="mdi mdi-apps m-r-5"></i>Tanggal. '.$tglsppd.'</span>';
|
|
echo '<br><span style="color:black;font-family:InterSB"><i class="mdi mdi-apps m-r-5"></i>a.n. '.$soporek.'</span>';
|
|
} else {
|
|
?>
|
|
<span style="color:black;font-family:InterSB"><?php echo $soporek.''.$ket2; ?></span><br>
|
|
<span><?php echo $r['sub_kegiatan'].' - '.$r['kegiatan'].' - '.$r['kegiatan_pengadaan'];?></span><br>
|
|
<span style="color:brown"><i class="mdi mdi-check-circle-outline m-r-5"></i><?php echo $bp.'/'.$nama_verfikator;?></span><br>
|
|
<span style="color:green;font-family:InterSB"><i class="mdi mdi-apps m-r-5"></i><?php echo $r['no_sp'].'<br><span style="color:red;font-family:InterSB">'.$trm.'</span>';?></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 ($ssetor==NULL) {} else { ?>
|
|
<span style="color:red;font-family:InterSB"><i class="mdi mdi-alert-circle-outline m-r-5"></i>DIREVISI / DIBATALKAN PENGADAAN</span>
|
|
<?php } ?>
|
|
<?php
|
|
}
|
|
?>
|
|
<?php if (($r['nomor_ba']=='') || ($r['nomor_ba']==NULL)) {} else { ?>
|
|
<br><span style="font-family:Arial;color:red;font-weight:bold;font-size:14px">
|
|
<i class="mdi mdi-alert-circle-outline m-r-5"></i>BA DENDA :: <?php echo $r['nomor_ba'].' - Rp. '.number_format($r['nilai_ba'],0,',','.');?>
|
|
</span>
|
|
<?php } ?>
|
|
</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']);} else {
|
|
echo strtoupper($r['st_buku'].' - '.$r['st_termin'].' '.$r[30]);
|
|
}
|
|
|
|
?></td>
|
|
<td align="right"><?php echo number_format($r['nilai_pelunasan'],0,',','.'); ?></td>
|
|
<td align="right"><?php echo number_format($ppn,0,',','.'); ?></td>
|
|
<td align="right"><?php echo number_format($pph,0,',','.'); ?></td>
|
|
<td align="center"><?php echo $pasal; ?></td>
|
|
<td align="center"><?php if ($r['tanggal_setor']==NULL) {} else {echo date('d-m-Y',strtotime($r['tanggal_setor']));} ?></td>
|
|
<td align="center"><?php echo $r['nama_verfikator']; ?></td>
|
|
<td align="center" class="kanan">
|
|
<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>-->
|
|
<button type="button" name="cnv" style="height:22px;"class="btn btn-inverse btn-xs cnv" id="<?php echo $r['id'];?>" data-content="Conversasi Data Hutang" rel="popover" data-placement="top" data-trigger="hover"
|
|
<?php if ($ssetor==NULL) {} else {echo 'disabled';} ?>>
|
|
<i class="fa fa-recycle"></i>
|
|
</button>
|
|
<button type="button" name="pelunasan" style="height:22px;"class="btn btn-danger btn-xs pelunasan" id="<?php echo $r['id'];?>" data-content="Pelunasan" rel="popover" data-placement="top" data-trigger="hover"
|
|
<?php if ($ssetor==NULL) {} else {echo 'disabled';} ?>>
|
|
<i class="fa fa-arrow-right"></i>
|
|
</button>
|
|
</td>
|
|
<td style="display:none"><?php echo $r['status_um']; ?></td>
|
|
<td style="display:none"><?php echo $r['sub_kegiatan']; ?></td>
|
|
<td style="display:none"><?php echo $r['kegiatan']; ?></td>
|
|
<td style="display:none"><?php echo $r['st_termin']; ?></td>
|
|
<td style="display:none"><?php echo $r['no_sp'];?></td>
|
|
<td style="display:none"><?php echo $r['st_buku'];?></td>
|
|
<td style="display:none"><?php echo $r['pekerjaan_id'];?></td>
|
|
</tr>
|
|
<?php } ?>
|
|
</tbody>
|
|
</table>
|
|
|
|
<script>
|
|
var thn=$('#thn').val();
|
|
|
|
|
|
$("#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','.cnv',function(){
|
|
var id = $(this).attr('id');
|
|
var currentRow=$(this).closest("tr");
|
|
var sub_kegiatan = currentRow.find("td:eq(14)").text();
|
|
var kegiatan = currentRow.find("td:eq(15)").text();
|
|
var st_termin = currentRow.find("td:eq(16)").text();
|
|
var no_sp = currentRow.find("td:eq(17)").text();
|
|
var st_buku = currentRow.find("td:eq(18)").text();
|
|
var pekerjaan_id = currentRow.find("td:eq(19)").text();
|
|
// if (st_termin=='non-termin') {
|
|
var thn=$('#thn').val();
|
|
$('#modal_cnv').modal('show');
|
|
$('#modal_body_cnv').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/pelunasan/modal_cnv.php",
|
|
data: 'id='+id
|
|
+'&sub_kegiatan='+sub_kegiatan
|
|
+'&kegiatan='+kegiatan
|
|
+'&no_sp='+no_sp
|
|
+'&st_termin='+st_termin
|
|
+'&st_buku='+st_buku
|
|
+'&pekerjaan_id='+pekerjaan_id
|
|
+'&thn='+thn,
|
|
success: function(data){
|
|
$('#modal_body_cnv').html(data);
|
|
}
|
|
});
|
|
// } else {alert('Untuk yang termin masih dalam tahap pengujian.. Tunggu ya');}
|
|
});
|
|
|
|
$("#tabel_data_laporan").on('click','.input_ba',function(){
|
|
var id = $(this).attr('id');
|
|
$('#modal_ba').modal('show');
|
|
$('#modal_body_ba').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/kendali/modal_ba.php",
|
|
data: 'pekerjaan_id='+id,
|
|
success: function(data){
|
|
$('#modal_body_ba').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#tabel_data_laporan").on('click','.pelunasan',function(){
|
|
var d = new Date(),n = d.getMonth(),y = d.getFullYear();
|
|
$('#bulan option:eq('+n+')').prop('selected', true);
|
|
$('#thn_dpa option[value="'+y+'"]').prop('selected', true);
|
|
var id = $(this).attr('id');
|
|
var currentRow=$(this).closest("tr");
|
|
var status_um = currentRow.find("td:eq(13)").text();
|
|
var sub_kegiatan = currentRow.find("td:eq(14)").text();
|
|
var kegiatan = currentRow.find("td:eq(15)").text();
|
|
var bulan = $('#bulan').val();
|
|
var cek_nama = $('#cek_nama').val();
|
|
$('#modal_pelunasan').modal('show');
|
|
$('#modal_body_pelunasan').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/pelunasan/modal_pelunasan.php",
|
|
data: 'id='+id
|
|
+'&cek_nama='+cek_nama
|
|
+'&bulan='+bulan
|
|
+'&status_um='+status_um
|
|
+'&sub_kegiatan='+sub_kegiatan
|
|
+'&kegiatan='+kegiatan
|
|
+'&thn='+thn,
|
|
success: function(data){
|
|
$('#modal_body_pelunasan').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#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/pelunasan/crud.php",
|
|
data: 'id='+id
|
|
+'&key='+key,
|
|
success: function(data){
|
|
alert('Pembatalan Pelunasan sukses..');
|
|
$('#tabel_laporan').load('app/pelunasan/tabel.php',{thn:thn});
|
|
}
|
|
});
|
|
}
|
|
});
|
|
|
|
$("#modal_sub").on("hidden.bs.modal", function () {
|
|
$(this).off('hidden.bs.modal');
|
|
});
|
|
|
|
$("#modal_verifikasi").on("hidden.bs.modal", function () {
|
|
$(this).off('hidden.bs.modal');
|
|
});
|
|
|
|
$("#modal_ba").on("hidden.bs.modal", function () {
|
|
$(this).off('hidden.bs.modal');
|
|
});
|
|
|
|
$("#modal_pelunasan").on("hidden.bs.modal", function () {
|
|
$(this).off('hidden.bs.modal');
|
|
});
|
|
|
|
</script>
|