303 lines
19 KiB
PHP
303 lines
19 KiB
PHP
<?php
|
|
include("../koneksi.php");
|
|
$thn=$_POST['thn'];
|
|
|
|
$r1=strtolower($_POST['r1']);
|
|
$p1=strtolower($_POST['p1']);
|
|
$s1=strtolower($_POST['s1']);
|
|
$key=$_POST['key'];
|
|
|
|
$rk_sopo_id=$_POST['rk_sopo_id'];
|
|
$jenis=$_POST['jenis'];
|
|
|
|
if (($jenis=='kepala instalasi') || ($jenis=='kpa') || ($jenis=='admin utama') || ($jenis=='kabag keu')) {$nb='';} else
|
|
if ($jenis=='pptk') {$bn='s.pptk_id';$nb='INNER JOIN pptk t ON (t.id=s.pptk_id)';} else
|
|
if ($jenis=='ppkom') {$bn='s.ppkom_id';$nb='INNER JOIN ppkom o ON (o.id=s.ppkom_id)';} else
|
|
if ($jenis=='pejabat') {$bn='s.pejabat_pengadaan_id';$nb='INNER JOIN pejabat_pengadaan g ON (g.id=s.pejabat_pengadaan_id)';}
|
|
|
|
?>
|
|
|
|
<script type="text/javascript">$("#tabel_data_tb1").DataTable({"paging": true,"lengthChange": true,"searching": true,"ordering": false,"info": true,"autoWidth": false});</script>
|
|
<input type="hidden" id="key_jm1" value="<?php echo $key; ?>">
|
|
|
|
<span><button type="button" class="btn btn-success" id="excel_jm1">Excel</button></span><br><br>
|
|
<table id="tabel_data_tb1" class="table table-bordered table-striped table-condensed" style="font-size:13px" cellpadding="1">
|
|
<thead style="color:grey;font-family:InterSB">
|
|
<tr align="center">
|
|
<td width="20px;">KPA</td>
|
|
<td width="20px;">PPTK</td>
|
|
<td width="20px;">KOM</td>
|
|
<td width="120px;" style="display:none">Sub Kg</td>
|
|
<td>Kegiatan</td>
|
|
<td width="130px;">Nilai</td>
|
|
<td width="140px;" style="display:none">Kwi/SP/SPK</td>
|
|
<td width="90px;" style="display:none">Masa</td>
|
|
<td width="130px;">Track</td>
|
|
<td width="130px;">Progress</td>
|
|
<td width="90px;">Tanggal</td>
|
|
<td width="80px;">Tools</td>
|
|
<td width="50px;" style="display:none"></td>
|
|
</tr>
|
|
</thead>
|
|
<tbody style="color:black;font-family:Inter">
|
|
<?php
|
|
|
|
$data=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,
|
|
COALESCE(l.nilai_pelunasan,p.nilai_sp),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_lunas,COALESCE(n.nama,p.cad1),k.inisial,l.status_berkas,t.inisial,m.inisial,
|
|
COALESCE(l.tanggal_lunas,
|
|
COALESCE(l.tanggal_setor,
|
|
COALESCE(l.tgl_terima_verif,
|
|
COALESCE(l.tgl_setor_verif,
|
|
COALESCE(l.tgl_setor_pptk,
|
|
COALESCE(l.tanggal_input,
|
|
COALESCE(p.tgl_setor,
|
|
COALESCE((SELECT a1.tanggal FROM pengerjaan_adminers a1 WHERE a1.id=MAX(a.id)),
|
|
p.tgl_input)
|
|
))))))),
|
|
l.nilai_pelunasan,p.nilai_sp,
|
|
(SELECT a1.keterangan FROM pengerjaan_adminers a1 WHERE a1.id=MAX(a.id)),p.status,p.id,r.stum,l.st_setor_verif,l.tgl_terima_verif,l.tgl_setor_verif,l.tgl_setor_pptk,p.id as pek_id
|
|
FROM pekerjaan p
|
|
LEFT OUTER JOIN sub_kegiatan s ON (p.sub_kegiatan_id=s.id)
|
|
LEFT OUTER JOIN vr_realisasi r ON (r.pekerjaan_id=p.id)
|
|
LEFT OUTER JOIN vr_pelunasan l ON (l.vr_realisasi_id=r.id)
|
|
LEFT OUTER JOIN rekanan n ON (n.id=p.rekanan_id)
|
|
LEFT OUTER JOIN kpa k ON (k.id=s.kpa_id)
|
|
LEFT OUTER JOIN pptk t ON (t.id=s.pptk_id)
|
|
LEFT OUTER JOIN ppkom m ON (m.id=s.ppkom_id)
|
|
LEFT OUTER JOIN pengerjaan_adminers a ON (a.pekerjaan_id=p.id)
|
|
WHERE s.thn='$thn' AND COALESCE(l.st_hutang,'') = 'H' AND COALESCE(p.user_nama,'')<>'HUTANG TERMIN' AND p.status_setor IS NULL
|
|
".($key == null ? "" : "
|
|
".($key == 'siji' ? "AND p.user_nama IS NULL AND p.tgl_setor IS NULL AND l.tgl_terima_verif IS NULL AND st_setor_verif IS NULL AND l.tanggal_lunas IS NULL" : "
|
|
".($key == 'loro' ? "AND p.user_nama IS NULL AND p.tgl_setor IS NOT NULL AND l.tgl_terima_verif IS NULL AND st_setor_verif IS NULL AND l.tanggal_lunas IS NULL" : "
|
|
".($key == 'papat' ? "AND p.user_nama IS NULL AND p.tgl_setor IS NOT NULL 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" : "
|
|
".($key == 'enem' ? "AND p.user_nama IS NULL AND p.tgl_setor IS NOT NULL 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" : "
|
|
".($key == 'pitu' ? "AND p.user_nama IS NULL AND p.tgl_setor IS NULL AND l.tgl_terima_verif IS NOT NULL AND st_setor_verif IS NOT NULL" : "
|
|
".($key == 'telu' ? "AND p.user_nama IS NULL AND l.tgl_terima_verif IS NULL AND st_setor_verif IS NOT NULL AND l.tanggal_lunas IS NULL" : "
|
|
".($key == 'limo' ? "AND p.user_nama IS NULL AND p.tgl_setor IS NOT NULL 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" : "
|
|
")."
|
|
")."
|
|
")."
|
|
")."
|
|
")."
|
|
")."
|
|
")."
|
|
")."
|
|
GROUP BY
|
|
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,
|
|
COALESCE(l.nilai_pelunasan,p.nilai_sp),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_lunas,COALESCE(n.nama,p.cad1),k.inisial,l.status_berkas,t.inisial,m.inisial,
|
|
l.nilai_pelunasan,p.nilai_sp,p.id,p.status,r.stum,l.st_setor_verif,p.user_nama,l.tgl_terima_verif,l.tgl_setor_verif,l.tgl_setor_pptk,p.id
|
|
ORDER BY p.id DESC
|
|
");
|
|
while($r=pg_fetch_array($data)) {
|
|
$vrprlid=$r[28];
|
|
$pekerjaan_id=$r['pek_id'];
|
|
$d2=pg_query("SELECT EXTRACT('Year' FROM tgl_input::TIMESTAMP) FROM pekerjaan WHERE id=$pekerjaan_id");
|
|
while($r2=pg_fetch_array($d2)) {$thn_set=$r2[0];}
|
|
|
|
$d1=pg_query("SELECT status FROM set_pemb_pptk WHERE thn='$thn_set'");
|
|
while($r1=pg_fetch_array($d1)) {$status_pemb_pptk=$r1[0];}
|
|
|
|
if ($status_pemb_pptk=='t') {
|
|
$ketpembpptk='PEMBANTU PPTK';
|
|
} else {
|
|
$ketpembpptk='TIM VALIDASI PENGADAAN';
|
|
}
|
|
if (($r['tanggal_lunas']==NULL) || ($r['tanggal_lunas']=='') || (date('Y-m-d',strtotime($r['tanggal_lunas']))=='1970-01-01')) {
|
|
if (($r['tanggal_setor']==NULL) || ($r['tanggal_setor']=='') || (date('Y-m-d',strtotime($r['tanggal_setor']))=='1970-01-01')) {
|
|
if (($r['tgl_terima_verif']==NULL) || ($r['tgl_terima_verif']=='') || (date('Y-m-d',strtotime($r['tgl_terima_verif']))=='1970-01-01')) {
|
|
if (($r['tgl_setor_verif']==NULL) || ($r['tgl_setor_verif']=='') || (date('Y-m-d',strtotime($r['tgl_setor_verif']))=='1970-01-01')) {
|
|
if (($r['tgl_setor_pptk']==NULL) || ($r['tgl_setor_pptk']=='') || (date('Y-m-d',strtotime($r['tgl_setor_pptk']))=='1970-01-01')) {
|
|
if (($r['tanggal_input']==NULL) || ($r['tanggal_input']=='') || (date('Y-m-d',strtotime($r['tanggal_input']))=='1970-01-01')) {
|
|
if ($r[40]==NULL) {
|
|
$posisi='PENGADAAN';
|
|
$st_pbj='Penerbitan SP/SPK/Kwi';
|
|
} else {
|
|
if (strtolower($r['status'])=='selesai adminers') {
|
|
$posisi='PENGADAAN';
|
|
$st_pbj='Selesai Admin';
|
|
} else
|
|
if (strtolower($r[40])=='selesai') {
|
|
$posisi='PENGADAAN';
|
|
$st_pbj='Selesai Proses';
|
|
} else {
|
|
$posisi='PENGADAAN';
|
|
$st_pbj=$r[40];
|
|
}
|
|
}
|
|
$status=$st_pbj;
|
|
$nilai=$r[39];
|
|
} else {
|
|
$status='PROSES VALIDASI';
|
|
$posisi='TIM VALIDASI';
|
|
$nilai=$r[38];
|
|
}
|
|
} else {
|
|
//$status='PROSES PENGECEKAN KELENGKAPAN';
|
|
//$posisi='PEMBANTU PPTK';
|
|
include("../pencarian/progress_npd.php");
|
|
$nilai=$r[38];
|
|
}
|
|
} else {
|
|
$status='SETOR VERIFIKASI';
|
|
$posisi='PEMBANTU PPTK';
|
|
$nilai=$r[38];
|
|
}
|
|
} else {
|
|
$status='PROSES VERIFIKASI';
|
|
$posisi='VERIFIKASI';
|
|
$nilai=$r[38];
|
|
}
|
|
} else {
|
|
$status='SETOR SIAP PELUNASAN';
|
|
$posisi='VERIFIKASI';
|
|
$nilai=$r[38];
|
|
}
|
|
} else {
|
|
$status='LUNAS';
|
|
$posisi='PERBENDAHARAAN';
|
|
$nilai=$r[38];
|
|
}
|
|
$stum=$r['stum'];
|
|
if ($r[30]=='0') {
|
|
if ($stum=='uang_muka') {$trm='UANG MUKA';} else {$trm='';}
|
|
} else {$trm=strtoupper(($r['st_termin'].' '.$r[30]));}
|
|
|
|
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"><?php echo $r[33]; ?></td>
|
|
<td align="center"><?php echo $r[35]; ?></td>
|
|
<td align="center"><?php echo $r[36]; ?></td>
|
|
<td style="display:none"><?php echo strtoupper($r['sub_kegiatan']);?></td>
|
|
<!--<td><?php echo strtoupper($r['kegiatan'].' - '.$r['kegiatan_pengadaan'].' - '.$r[32]);?></td>-->
|
|
<td>
|
|
<span style="color:black;font-family:InterSB"><?php echo $r[32]; ?></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 (($trm==NULL) || ($trm=='')) {} else { ?><br><span style="font-family:InterSB;color:red"><?php echo $trm; ?></span><?php }?>
|
|
</span>
|
|
</td>
|
|
<td align="right"><?php echo number_format($nilai,0,',','.'); ?></td>
|
|
<td align="center" style="display:none"><?php echo $r['no_sp'].'<br><span style="color:red">'.$trm.'</span>'; ?></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 <br>'.date('d-m-Y',strtotime($r['tgl_selesai_sp'])); }
|
|
?></td>
|
|
<td align="center"><?php echo $posisi; ?></td>
|
|
<td align="center"><span style="font-family:InterSB;<?php if (strtolower($status)=='selesai proses') {echo 'color:red';} else {}?>"><?php echo strtoupper($status); ?></span></td>
|
|
<td align="center"><?php echo date('d-m-Y',strtotime($r[37])); ?></td>
|
|
<td align="center" class="kanan">
|
|
<button type="button" name="track" style="height:22px;"class="btn btn-purple btn-xs track" id="<?php echo $r[42];?>" data-content="Track Proses" rel="popover" data-placement="top" data-trigger="hover"
|
|
>
|
|
<i class="fa fa-car"></i>
|
|
</button>
|
|
<button type="button" name="kelengkapan" style="height:22px;"class="btn btn-success btn-xs kelengkapan" id="<?php echo $r[28];?>" data-content="Verifikasi" rel="popover" data-placement="top" data-trigger="hover"
|
|
>
|
|
<i class="fa fa-ellipsis-h"></i>
|
|
</button>
|
|
</td>
|
|
<td width="50px;" style="display:none"><?php echo $r[28];?></td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
|
|
<script>
|
|
$('button[name="track"]').popover();
|
|
$('button[name="kelengkapan"]').popover();
|
|
|
|
|
|
$("#tabel_data_tb1").on('click','.track',function(){
|
|
var pekerjaan_id = $(this).attr('id');
|
|
var currentRow=$(this).closest("tr");
|
|
var id=currentRow.find("td:eq(12)").text();
|
|
$('#modal_track').modal('show');
|
|
$('#modal_body_track').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/kios/tracking.php",
|
|
data: 'vr_pelunasan_id='+id
|
|
+'&id='+pekerjaan_id,
|
|
success: function(data){
|
|
$('#modal_body_track').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#tabel_data_tb1").on('click','.kelengkapan',function(){
|
|
var id = $(this).attr('id');
|
|
$('#modal_kelengkapan').modal('show');
|
|
$('#modal_body_kelengkapan').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/kendali/modal_verifikasi.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_body_kelengkapan').html(data);
|
|
$("#form_verifikasi *").prop("disabled", true);
|
|
$("#rek_so").hide();
|
|
}
|
|
});
|
|
});
|
|
|
|
/*
|
|
$("#tabel_data_tb1").on('click','.track',function(){
|
|
var id = $(this).attr('id');
|
|
$('#modal_track').modal('show');
|
|
$('#modal_body_track').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/laporan/tracking.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_body_track').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#tabel_data_tb1").on('click','.kelengkapan',function(){
|
|
var id = $(this).attr('id');
|
|
$('#modal_kelengkapan').modal('show');
|
|
$('#modal_body_kelengkapan').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/laporan/modal_verifikasi.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_body_kelengkapan').html(data);
|
|
$("#form_verifikasi *").prop("disabled", true);
|
|
$("#rek_so").hide();
|
|
}
|
|
});
|
|
});
|
|
*/
|
|
function excel_jm1() {
|
|
var thn_dpa = $('#thn_dpa').val();
|
|
var rk_sopo_id = $('#rk_sopo_id').val();
|
|
var jenis = $('#rk_jenis').val();
|
|
var key = $('#key_jm1').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_jm1.php?key='+key+'&thn='+thn_dpa+'&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);
|
|
}
|
|
|
|
$('#excel_jm1').click(function(){
|
|
excel_jm1();
|
|
});
|
|
</script>
|