249 lines
16 KiB
PHP
249 lines
16 KiB
PHP
<?php
|
|
include("../koneksi.php");
|
|
$thn=$_POST['thn'];
|
|
$text_cari=$_POST['text_cari'];
|
|
$c1=$_POST['c1'];
|
|
if ($c1=='Nama Rekanan') {
|
|
$r1=strtolower($text_cari);
|
|
} else
|
|
if ($c1=='Pekerjaan') {
|
|
$p1=strtolower($text_cari);
|
|
}
|
|
?>
|
|
|
|
|
|
<script type="text/javascript">$("#tabel_data_tb1").DataTable({"paging": true,"lengthChange": true,"searching": true,"ordering": false,"info": true,"autoWidth": false});</script>
|
|
|
|
<table id="tabel_data_tb1" class="table table-bordered table-striped table-condensed" style="font-family:Inter;font-size:13px" cellpadding="1">
|
|
<thead>
|
|
<tr align="center" style="font-family:InterSB;font-size:13px">
|
|
<td width="20px;">KPA</td>
|
|
<td width="20px;">PPTK</td>
|
|
<td width="20px;">KOM</td>
|
|
<td width="220px;">Kegiatan</td>
|
|
<td width="150px;">Kwi/SP/SPK</td>
|
|
<td width="100px;">Nilai Pekerjaan</td>
|
|
<td width="100px;">Nilai Pembayaran</td>
|
|
|
|
<td width="90px;">Masa</td>
|
|
<td width="80px;">Track</td>
|
|
<td width="40px;">Progress</td>
|
|
<td width="70px;">Tanggal</td>
|
|
<td width="60px;">Tools</td>
|
|
<td style="display:none"></td>
|
|
<td style="display:none"></td>
|
|
</tr>
|
|
</thead>
|
|
<tbody style="color:black">
|
|
<?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,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 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)
|
|
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'
|
|
GROUP BY b1.pekerjaan_id,b1.st_termin)
|
|
b ON (p.id=b.pekerjaan_id)
|
|
WHERE s.thn='$thn'
|
|
".($r1 == null ? "" : "AND lower(COALESCE(n.nama,p.cad1)) LIKE '%$r1%'")."
|
|
".($p1 == null ? "" : "AND lower(p.kegiatan_pengadaan) LIKE '%$p1%'")."
|
|
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,l.tgl_terima_verif,l.tgl_setor_verif,l.tgl_setor_pptk,p.id,p.no_spp,b.pekerjaan_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];
|
|
}
|
|
}
|
|
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[39];
|
|
} else {
|
|
$status='PROSES VALIDASI';
|
|
$posisi='TIM VALIDASI PENGADAAN';
|
|
$nilai=$r[38];
|
|
}
|
|
} else {
|
|
//$status='PROSES PENGECEKAN KELENGKAPAN';
|
|
//$posisi=$ketpembpptk;
|
|
include("../pencarian/progress_npd.php");
|
|
$nilai=$r[38];
|
|
}
|
|
} else {
|
|
$status='SETOR VERIFIKASI';
|
|
$posisi=$ketpembpptk;
|
|
$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]));}
|
|
?>
|
|
<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><?php echo strtoupper($r['kegiatan'].' - '.$r['kegiatan_pengadaan'].' - '.$r[32]);?>
|
|
<?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 }?>
|
|
</td>
|
|
<td align="center"><?php echo $r['no_sp'].'<br><span style="color:red">'.$trm.'</span>'; ?></td>
|
|
<td align="right"><?php echo number_format($r['nilai_sp'],0,',','.'); ?></td>
|
|
<td align="right"><?php echo number_format($nilai,0,',','.'); ?></td>
|
|
<td align="center"><?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="<?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 style="display:none"><?php echo $r[42]; ?></td>
|
|
<td 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 currentRow=$(this).closest("tr");
|
|
var sid=currentRow.find("td:eq(13)").text();
|
|
var pekerjaan_id=currentRow.find("td:eq(12)").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_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();
|
|
}
|
|
});
|
|
});
|
|
|
|
|
|
</script>
|
|
|
|
|
|
|
|
|
|
|