407 lines
24 KiB
PHP
407 lines
24 KiB
PHP
<style>
|
||
body{
|
||
background-color: #f7f7ff;
|
||
}
|
||
.btn_bunder {
|
||
height: 80px;
|
||
line-height: 80px;
|
||
width: 80px;
|
||
font-size: 2em;
|
||
font-weight: bold;
|
||
border-radius: 50%;
|
||
background-color: #4CAF50;
|
||
color: white;
|
||
text-align: center;
|
||
cursor: pointer;
|
||
}
|
||
</style>
|
||
<?php
|
||
include('../koneksi.php');
|
||
$pekerjaan_id=$_POST['pekerjaan_id'];
|
||
$nm_rekanan=$_POST['nm_rekanan'];
|
||
$rekanan_id=$_POST['rekanan_id'];
|
||
|
||
|
||
$d=pg_query("SELECT EXTRACT('Year' FROM tgl_input::TIMESTAMP) FROM pekerjaan WHERE id=$pekerjaan_id");
|
||
while($r=pg_fetch_array($d)) {$thn_set=$r[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';
|
||
}
|
||
|
||
$bulan = array(
|
||
'01' => 'Jan',
|
||
'02' => 'Feb',
|
||
'03' => 'Mar',
|
||
'04' => 'Apr',
|
||
'05' => 'Mei',
|
||
'06' => 'Jun',
|
||
'07' => 'Jul',
|
||
'08' => 'Ags',
|
||
'09' => 'Sep',
|
||
'10' => 'Okt',
|
||
'11' => 'Nop',
|
||
'12' => 'Des',
|
||
);
|
||
|
||
$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,
|
||
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_lunas,COALESCE(n.nama,p.cad1),k.inisial,l.status_berkas,
|
||
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.no_spp,b.pekerjaan_id as pekerjaanid
|
||
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 pengerjaan_adminers a ON (a.pekerjaan_id=p.id)
|
||
LEFT OUTER JOIN
|
||
(SELECT b1.pekerjaan_id,b1.st_termin FROM riwayat_ba b1
|
||
INNER JOIN pekerjaan p1 ON (p1.id=b1.pekerjaan_id)
|
||
INNER JOIN sub_kegiatan s1 ON (s1.id=p1.sub_kegiatan_id)
|
||
WHERE s1.thn='$thn_set'
|
||
GROUP BY b1.pekerjaan_id,b1.st_termin)
|
||
b ON (p.id=b.pekerjaan_id)
|
||
WHERE p.id='$pekerjaan_id'
|
||
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,
|
||
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_lunas,COALESCE(n.nama,p.cad1),k.inisial,l.status_berkas,
|
||
l.nilai_pelunasan,p.nilai_sp,p.id,p.status,r.stum,l.st_setor_verif,l.tgl_terima_verif,l.tgl_setor_verif,l.tgl_setor_pptk,p.no_spp,b.pekerjaan_id
|
||
ORDER BY p.id DESC
|
||
");
|
||
|
||
$res=array();
|
||
while($r=pg_fetch_array($data)) {
|
||
$res[]=$r;
|
||
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[38]==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[38])=='selesai') {
|
||
$posisi='PENGADAAN';
|
||
$st_pbj='Selesai Proses';
|
||
} else {
|
||
$posisi='PENGADAAN';
|
||
$st_pbj=$r[38];
|
||
}
|
||
}
|
||
if (($r['pekerjaanid']==NULL) && ($r['status']!='Selesai Adminers')) {$stba=null;} else {
|
||
if (($r['pekerjaanid']==NULL) && ($r['status']=='Selesai Adminers')) {$stba='<br><span style="color:red;font-family:Arial;font-weight:bold;font-size:12px">BA Belum Proses</span>';} else {$stba='<br><span style="color:green;font-family:Arial;font-weight:bold;font-size:12px">BA Sedang Proses</span>';}
|
||
}
|
||
$status=$st_pbj.$stba;
|
||
$nilai=$r[37];
|
||
} else {
|
||
$status='PROSES VALIDASI';
|
||
$posisi='TIM VALIDASI PENGADAAN';
|
||
$nilai=$r[36];
|
||
}
|
||
} else {
|
||
$status='PROSES PENGECEKAN KELENGKAPAN';
|
||
$posisi=$ketpembpptk;
|
||
$nilai=$r[36];
|
||
}
|
||
} else {
|
||
$status='SETOR VERIFIKASI';
|
||
$posisi=$ketpembpptk;
|
||
$nilai=$r[36];
|
||
}
|
||
} else {
|
||
$status='PROSES VERIFIKASI';
|
||
$posisi='VERIFIKASI';
|
||
$nilai=$r[36];
|
||
}
|
||
} else {
|
||
$status='SETOR SIAP PELUNASAN';
|
||
$posisi='VERIFIKASI';
|
||
$nilai=$r[36];
|
||
}
|
||
} else {
|
||
$status='LUNAS';
|
||
$posisi='PERBENDAHARAAN';
|
||
$nilai=$r[36];
|
||
}
|
||
$kegiatan=$r['kegiatan'];
|
||
$kegiatan_pengadaan=$r['kegiatan_pengadaan'];
|
||
$no_sp=$r['no_sp'];
|
||
$tgl_mulai_sp=$r['tgl_mulai_sp'];
|
||
$tgl_selesai_sp=$r['tgl_selesai_sp'];
|
||
$tanggal=$r[35];
|
||
$nilai_sp=$r['nilai_sp'];
|
||
$jter=$r[30];
|
||
$sub_kegiatan=$r['sub_kegiatan'];
|
||
$no_spp=$r['no_spp'];
|
||
}
|
||
?>
|
||
<br>
|
||
<br>
|
||
<br>
|
||
<br>
|
||
|
||
|
||
|
||
|
||
<script type="text/javascript">$("#tabel_data_kios").DataTable({"paging": true,"lengthChange": true,"searching": true,"ordering": false,"info": true,"autoWidth": false});</script>
|
||
|
||
<div class="container" id="indah_prihatini">
|
||
|
||
<div class="row">
|
||
<div class="col-lg-12">
|
||
<table class="table table-condensed">
|
||
<tr>
|
||
<td id="nm_penyedia" style="font-family:RubMed;font-size:24px;color:black"></td>
|
||
<td id="tmbl"><button class="btn btn-default pull-right" id="riwayat" style="border-width:0px;color:grey;"><i class="mdi mdi-menu m-r-5"></i>Riwayat Belanja
|
||
<span class="badge up badge-danger badge-pill" style="background:red" id="jml_belanja"></span>
|
||
</button></td>
|
||
</tr>
|
||
</table>
|
||
</div>
|
||
</div>
|
||
|
||
<div class="row">
|
||
<div class="col-lg-12">
|
||
<table class="table table-condensed">
|
||
<tbody>
|
||
<tr style="color:black;font-family:Inter;font-size:18px">
|
||
<td>
|
||
<span style="font-family:InterSB;color:blue"><?php echo strtoupper($kegiatan_pengadaan);?></span><br>
|
||
<span style="color:green;font-family:GSans"><i class="mdi mdi-apps"></i> <?php echo $no_sp; ?></span><span style="color:red;font-family:GSans"> <i class="mdi mdi-apps"></i> <?php
|
||
if (($tgl_mulai_sp==null) || ($tgl_mulai_sp=='1970-01-01 00:00:00')) {} else {
|
||
echo date('d-m-Y',strtotime($tgl_mulai_sp)).' s/d '.date('d-m-Y',strtotime($tgl_selesai_sp)); }
|
||
?>
|
||
</span>
|
||
</td>
|
||
<td align="right" style="font-family:GSans;font-size:26px"><?php echo number_format($nilai_sp,0,',','.'); ?></td>
|
||
</tr>
|
||
</tbody>
|
||
</table>
|
||
</div>
|
||
</div>
|
||
|
||
|
||
|
||
<table class="table table-striped" id="tabel_kios">
|
||
<thead>
|
||
<tr style="color:grey;font-family:Inter;">
|
||
<td class="detily">Termin</td>
|
||
<td class="detily">POSISI DI</td>
|
||
<td class="detily">PROGRESS</td>
|
||
<td class="detily">Tanggal</td>
|
||
<td class="detily"></td>
|
||
<td class="detily" width="320"></td>
|
||
<td class="detily" width="300" style="display:none">#</td>
|
||
</tr>
|
||
</thead>
|
||
<tbody style="color:black;font-family:Inter">
|
||
<?php foreach ($res as $value){
|
||
$id=$value[28];
|
||
$pekerjaan_id=$value[40];
|
||
$jter2=$value[30];
|
||
if (($value['tanggal_lunas']==NULL) || ($value['tanggal_lunas']=='') || (date('Y-m-d',strtotime($value['tanggal_lunas']))=='1970-01-01')) {
|
||
if (($value['tanggal_setor']==NULL) || ($value['tanggal_setor']=='') || (date('Y-m-d',strtotime($value['tanggal_setor']))=='1970-01-01')) {
|
||
if (($value['tgl_terima_verif']==NULL) || ($value['tgl_terima_verif']=='') || (date('Y-m-d',strtotime($value['tgl_terima_verif']))=='1970-01-01')) {
|
||
if (($value['tgl_setor_verif']==NULL) || ($value['tgl_setor_verif']=='') || (date('Y-m-d',strtotime($value['tgl_setor_verif']))=='1970-01-01')) {
|
||
if (($value['tgl_setor_pptk']==NULL) || ($value['tgl_setor_pptk']=='') || (date('Y-m-d',strtotime($value['tgl_setor_pptk']))=='1970-01-01')) {
|
||
if (($value['tanggal_input']==NULL) || ($value['tanggal_input']=='') || (date('Y-m-d',strtotime($value['tanggal_input']))=='1970-01-01')) {
|
||
if ($value[38]==NULL) {
|
||
$posisi='PENGADAAN';
|
||
$st_pbj='Penerbitan SP/SPK/Kwi';
|
||
} else {
|
||
if (strtolower($value['status'])=='selesai adminers') {
|
||
$posisi='PENGADAAN';
|
||
$st_pbj='Selesai Admin';
|
||
} else
|
||
if (strtolower($value[38])=='selesai') {
|
||
$posisi='PENGADAAN';
|
||
$st_pbj='Selesai Proses';
|
||
} else {
|
||
$posisi='PENGADAAN';
|
||
$st_pbj=$value[38];
|
||
}
|
||
}
|
||
if (($value['pekerjaanid']==NULL) && ($value['status']!='Selesai Adminers')) {$stba=null;} else {
|
||
if (($value['pekerjaanid']==NULL) && ($value['status']=='Selesai Adminers')) {$stba='<br><span style="color:red;font-family:Arial;font-weight:bold;font-size:12px">BA Belum Proses</span>';} else {$stba='<br><span style="color:green;font-family:Arial;font-weight:bold;font-size:12px">BA Sedang Proses</span>';}
|
||
}
|
||
$status=$st_pbj.$stba;
|
||
$nilai=$value[37];
|
||
} else {
|
||
$status='PROSES VALIDASI';
|
||
$posisi='TIM VALIDASI PENGADAAN';
|
||
$nilai=$value[36];
|
||
}
|
||
} else {
|
||
$status='PROSES PENGECEKAN KELENGKAPAN';
|
||
$posisi=$ketpembpptk;
|
||
$nilai=$value[36];
|
||
}
|
||
} else {
|
||
$status='SETOR VERIFIKASI';
|
||
$posisi=$ketpembpptk;
|
||
$nilai=$value[36];
|
||
}
|
||
} else {
|
||
$status='PROSES VERIFIKASI';
|
||
$posisi='VERIFIKASI';
|
||
$nilai=$value[36];
|
||
}
|
||
} else {
|
||
$status='SETOR SIAP PELUNASAN';
|
||
$posisi='VERIFIKASI';
|
||
$nilai=$value[36];
|
||
}
|
||
} else {
|
||
$status='LUNAS';
|
||
$posisi='PERBENDAHARAAN';
|
||
$nilai=$value[36];
|
||
}
|
||
?>
|
||
<tr style="font-size:15px">
|
||
<td class="detil"><p><i class="mdi mdi-play-circle m-r-5" style="color:#E4AEC5"></i><?php
|
||
/*if ($jter=='0') {echo 'Non-Termin';} else {
|
||
echo $r['st_termin'].' '.$jter;
|
||
} */
|
||
$stum=$value['stum'];
|
||
if ($jter2=='0') {
|
||
if ($stum=='uang_muka') {$trm='UANG MUKA';} else {$trm='';}
|
||
} else {$trm=strtoupper(($value['st_termin'].' '.$jter2));}
|
||
echo $trm;
|
||
?></p></td>
|
||
<td class="detil"><p><?php echo strtoupper($posisi); ?></p></td>
|
||
<td class="detil"><p><?php echo ucwords(strtoupper($status)); ?></p></td>
|
||
<td class="detil"><p><?php echo date('d-m-Y',strtotime($tanggal)); ?></p></td>
|
||
<td class="detil" align="right"><p><?php echo number_format($nilai,0,',','.'); ?></p></td>
|
||
<td class="detil" align="right"><p style="margin-top:4px;margin-bottom:1px;">
|
||
<button name="kios_track" id="<?php echo $id;?>" class="btn btn-pink waves-effect waves-light m-b-5 kios_track"> <span style="font-family:Arial;font-weight:bold">Track Proses</span> <i class="fa fa-car m-l-5"></i> </button>
|
||
<button name="kios_kelengkapan" id="<?php echo $id;?>" class="btn btn-orange waves-effect waves-light m-b-5 kios_kelengkapan"> <span style="font-family:Arial;font-weight:bold">Kelengkapan</span> <i class="fa fa-check m-l-5"></i> </button>
|
||
</p>
|
||
</td>
|
||
<td style="display:none"><?php echo $pekerjaan_id; ?></td>
|
||
</tr>
|
||
<?php } ?>
|
||
</tbody>
|
||
</table>
|
||
</div>
|
||
|
||
|
||
|
||
<div id="modal_track" 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">Tracking</h4>
|
||
</div>
|
||
<div class="modal-body" id="modal_body_track"></div>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
|
||
<div id="modal_kelengkapan" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
|
||
<div class="modal-dialog modal-full">
|
||
<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">Kelengkapan Verifikasi</h4>
|
||
</div>
|
||
<div class="modal-body" id="modal_body_kelengkapan"></div>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
|
||
<script>
|
||
|
||
$("#tabel_kios").on('click','.kios_track',function(){
|
||
var sid = $(this).attr('id');
|
||
var currentRow=$(this).closest("tr");
|
||
var pekerjaan_id=currentRow.find("td:eq(6)").text();
|
||
if (!sid) {var id=0} else {var id=sid;}
|
||
$('#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_kios").on('click','.kios_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();
|
||
}
|
||
});
|
||
});
|
||
|
||
var timeout = null;
|
||
var timee = '100000';
|
||
$(document).bind('click keyup mousemove', function(event) {
|
||
if (timeout !== null) {
|
||
clearTimeout(timeout);
|
||
}
|
||
timeout = setTimeout(function() {
|
||
timeout = null;
|
||
console.log('Document Idle since '+timee+' ms');
|
||
$('#home').trigger('click');
|
||
}, timee);
|
||
});
|
||
|
||
$('#riwayat').click(function(){
|
||
var rekanan_id = $('#rekanan_id').val();
|
||
$('#modal_riwayat_belanja').modal('show');
|
||
$('#modal_body_riwayat_belanja').html("");
|
||
$.ajax({
|
||
type: "POST",
|
||
url: "app/kios/riwayat.php",
|
||
data: 'rekanan_id='+rekanan_id,
|
||
success: function(data){
|
||
$('#modal_body_riwayat_belanja').html(data);
|
||
}
|
||
});
|
||
});
|
||
</script>
|