489 lines
30 KiB
PHP
489 lines
30 KiB
PHP
<?php
|
||
include("../koneksi.php");
|
||
$thn=$_POST['thn'];
|
||
$cari_verifikator=$_POST['cari_verifikator'];
|
||
$nama_verifikator=$_POST['nama_verifikator'];
|
||
$jenis=$_POST['jenis'];
|
||
$axx=$_POST['axx'];
|
||
$bxx=$_POST['bxx'];
|
||
$cxx=$_POST['cxx'];
|
||
$dxx=$_POST['dxx'];
|
||
$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));
|
||
|
||
$cari_kd_panggil=$_POST['cari_kd_panggil'];
|
||
?>
|
||
<script type="text/javascript">
|
||
$("#tabel_data_laporanc").DataTable({"stateSave": true,"paging": true,"lengthChange": true,"searching": true,"ordering": false,"info": true,"autoWidth": false});
|
||
</script>
|
||
<style>
|
||
.modal-backdrop {
|
||
visibility: hidden !important;
|
||
}
|
||
.modal.in {
|
||
background-color: rgba(0,0,0,0.5);
|
||
}
|
||
</style>
|
||
<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="20px;">KOM</td>
|
||
<td align="center" width="20px;">PPTK</td>
|
||
<td align="center">Panggil</td>
|
||
<td align="center">Uraian</td>
|
||
|
||
<td align="center" width="150px;" style="display:none">Kwi/SP/SPK</td>
|
||
<td align="center" width="110px;" style="display:none">Periode</td>
|
||
|
||
<td align="center" width="90px;" style="display:none">Model</td>
|
||
<td align="center" width="90px;">Tgl Setor</td>
|
||
<td align="center" width="90px;">Tgl Lunas</td> <!-- 9 -->
|
||
<td align="center" width="120px;">Nilai</td>
|
||
<td align="center" width="140px;">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
|
||
$c=pg_query("SELECT DISTINCT s.sub_kegiatan
|
||
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)
|
||
INNER JOIN kpa a1 ON (s.kpa_id=a1.id)
|
||
INNER JOIN ppkom a2 ON (s.ppkom_id=a2.id)
|
||
INNER JOIN pptk a3 ON (s.pptk_id=a3.id)
|
||
LEFT OUTER JOIN bp a4 ON (s.bp_id=a4.id)
|
||
WHERE s.thn='$thn' AND l.tanggal_setor IS NOT NULL AND p.status_setor IS NULL
|
||
".($tm1 == null ? "" : "AND l.tanggal_setor::DATE BETWEEN '$tt1-$bb1-$hh1' AND '$tt2-$bb2-$hh2'")."
|
||
".($axx == '' ? "" : "AND s.kpa_id='$axx'")."
|
||
".($bxx == '' ? "" : "AND s.ppkom_id='$bxx'")."
|
||
".($cxx == '' ? "" : "AND s.pptk_id='$cxx'")."
|
||
".($dxx == '' ? "" : "AND s.bp_id='$dxx'")."
|
||
".($cari_verifikator == '' ? "" : "AND COALESCE(p.user_nama,l.nama_verfikator)='$cari_verifikator'")."
|
||
".($cari_kd_panggil == '' ? "" : "AND s.id='$cari_kd_panggil'")."
|
||
");
|
||
while($v=pg_fetch_array($c)) {
|
||
$skg=$v[0];
|
||
?>
|
||
<tr><td colspan="12"><span style="font-family:InterSB;color:orange"><?php echo strtoupper($skg);?></span></td></tr>
|
||
|
||
<?php
|
||
$e=pg_query("SELECT DISTINCT s.kegiatan
|
||
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)
|
||
INNER JOIN kpa a1 ON (s.kpa_id=a1.id)
|
||
INNER JOIN ppkom a2 ON (s.ppkom_id=a2.id)
|
||
INNER JOIN pptk a3 ON (s.pptk_id=a3.id)
|
||
LEFT OUTER JOIN bp a4 ON (s.bp_id=a4.id)
|
||
WHERE s.thn='$thn' AND l.tanggal_setor IS NOT NULL AND p.status_setor IS NULL
|
||
AND s.sub_kegiatan='$skg'
|
||
".($tm1 == null ? "" : "AND l.tanggal_setor::DATE BETWEEN '$tt1-$bb1-$hh1' AND '$tt2-$bb2-$hh2'")."
|
||
".($axx == '' ? "" : "AND s.kpa_id='$axx'")."
|
||
".($bxx == '' ? "" : "AND s.ppkom_id='$bxx'")."
|
||
".($cxx == '' ? "" : "AND s.pptk_id='$cxx'")."
|
||
".($dxx == '' ? "" : "AND s.bp_id='$dxx'")."
|
||
".($cari_verifikator == '' ? "" : "AND COALESCE(p.user_nama,l.nama_verfikator)='$cari_verifikator'")."
|
||
".($cari_kd_panggil == '' ? "" : "AND s.id='$cari_kd_panggil'")."
|
||
");
|
||
while($b=pg_fetch_array($e)) {
|
||
$blh=$b[0];
|
||
?>
|
||
|
||
<?php
|
||
$tot=0;
|
||
$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,l.tanggal_input,a1.inisial,a2.inisial,a3.inisial,l.tanggal_dokumen,p.cad1,COALESCE(n.nama,p.cad1),l.idx_kwi_bend,r.stum,
|
||
l.tanggal_lunas,l.ket,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)
|
||
INNER JOIN kpa a1 ON (s.kpa_id=a1.id)
|
||
INNER JOIN ppkom a2 ON (s.ppkom_id=a2.id)
|
||
INNER JOIN pptk a3 ON (s.pptk_id=a3.id)
|
||
LEFT OUTER JOIN bp a4 ON (s.bp_id=a4.id)
|
||
LEFT OUTER JOIN rekanan n ON (n.id=p.rekanan_id)
|
||
WHERE s.thn='$thn' AND l.tanggal_setor IS NOT NULL AND p.status_setor IS NULL
|
||
AND s.sub_kegiatan='$skg' AND s.kegiatan='$blh'
|
||
".($tm1 == null ? "" : "AND l.tanggal_setor::DATE BETWEEN '$tt1-$bb1-$hh1' AND '$tt2-$bb2-$hh2'")."
|
||
".($axx == '' ? "" : "AND s.kpa_id='$axx'")."
|
||
".($bxx == '' ? "" : "AND s.ppkom_id='$bxx'")."
|
||
".($cxx == '' ? "" : "AND s.pptk_id='$cxx'")."
|
||
".($dxx == '' ? "" : "AND s.bp_id='$dxx'")."
|
||
".($cari_verifikator == '' ? "" : "AND COALESCE(p.user_nama,l.nama_verfikator)='$cari_verifikator'")."
|
||
".($cari_kd_panggil == '' ? "" : "AND s.id='$cari_kd_panggil'")."
|
||
ORDER BY l.tanggal_setor DESC,l.id DESC
|
||
");
|
||
while($r=pg_fetch_array($d)) {
|
||
$pekerjaan_id=$r['pekerjaan_id'];
|
||
//if ($r[30]=='0') {$trm='';} else {$trm=' - '.strtoupper(($r['st_termin'].' '.$r[30]));}
|
||
$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 ($cek_sppd=='SPPD') {
|
||
$tglkn=date('d-m-Y',strtotime($sbrk)).' s/d '.date('d-m-Y',strtotime($skbl));
|
||
} else {
|
||
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[32];?></td>
|
||
<td align="center"><?php echo $r[33];?></td>
|
||
<td align="center"><?php echo $r[34];?></td>
|
||
<td align="center"><?php echo $r['kd_panggil'];?></td>
|
||
|
||
<td>
|
||
<span style="color:black;font-family:InterSB"><?php echo $r[37].''.$ket2; ?></span><br>
|
||
<span><?php if ($cek_sppd=='SPPD') {
|
||
echo $r['kegiatan'].' dalam rangka '.$drangka;
|
||
} else {
|
||
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>
|
||
<span style="color:black"><?php echo $r[37].''.$ket2; ?></span><br>
|
||
<span><?php
|
||
if ($cek_sppd=='SPPD') {
|
||
echo strtoupper($r['kegiatan'].' dalam rangka '.$drangka);
|
||
} else {
|
||
echo strtoupper($r['sub_kegiatan'].' - '.$r['kegiatan'].' - '.$r['kegiatan_pengadaan']);
|
||
}
|
||
?>
|
||
</span><br>
|
||
|
||
<span style="color:blue"><i class="mdi mdi-apps m-r-5"></i>
|
||
<?php
|
||
if ($cek_sppd=='SPPD') {
|
||
echo date('d-m-Y',strtotime($sbrk)).' s/d '.date('d-m-Y',strtotime($skbl));
|
||
} else {
|
||
if (($r['tgl_mulai_sp']==null) || ($r['tgl_mulai_sp']=='1970-01-01 00:00:00')) {} else {
|
||
echo 'Tanggal. '.date('d-m-Y',strtotime($r['tgl_mulai_sp'])).' s/d '.date('d-m-Y',strtotime($r['tgl_selesai_sp']));
|
||
}
|
||
}
|
||
?>
|
||
</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 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="center"><?php if ($r['tanggal_setor']==NULL) {} else {echo date('d-m-Y',strtotime($r['tanggal_setor']));} ?></td>
|
||
<td align="center"><?php if ($r['tanggal_lunas']==NULL) {} else {echo date('d-m-Y',strtotime($r['tanggal_lunas']));} ?></td>
|
||
<td align="right"><?php echo number_format($r['nilai_pelunasan'],0,',','.'); ?></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']=='')) { ?>
|
||
<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
|
||
$tot=$tot+$r['nilai_pelunasan'];
|
||
}
|
||
?>
|
||
<tr>
|
||
<td colspan="8" align="right"><span style="font-family:InterSB;color:green"><?php echo strtoupper($blh);?></span></td>
|
||
<td colspan="3" align="right"><span style="font-family:InterSB;color:green"><?php echo number_format($tot,0,',','.'); ?></span></td>
|
||
<!--<td colspan="1"><b style="color:red"></td>-->
|
||
</tr>
|
||
<?php
|
||
}
|
||
?>
|
||
<tr><td colspan="12"><span style="font-family:InterSB;color:red"> </span></td></tr>
|
||
<?php
|
||
}
|
||
?>
|
||
</tbody>
|
||
</table>
|
||
|
||
<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>
|
||
$('button[name="sub"]').popover();
|
||
$('button[name="input_ba"]').popover();
|
||
$('button[name="detail"]').popover();
|
||
$('button[name="print"]').popover();
|
||
$('button[name="batal"]').popover();
|
||
|
||
$("#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 axx = $('#c1').val();
|
||
var bxx = $('#c2').val();
|
||
var cxx = $('#c3').val();
|
||
var dxx = $('#c4').val();
|
||
var m = $('#tgl_mulai1').val();
|
||
var s = $('#tgl_selesai1').val();
|
||
var nama_verifikator=$('#cek_nampeg').val();
|
||
var jenis=$('#cek_jenis').val();
|
||
var cari_verifikator=$('#cari_verifikator').val();
|
||
var cari_kd_panggil=$('#cari_kd_panggil').val();
|
||
$('#tabel_laporan').load('app/lap_setor/tabel.php',{cari_kd_panggil:cari_kd_panggil,cari_verifikator:cari_verifikator,nama_verifikator:nama_verifikator,jenis:jenis,axx:axx,bxx:bxx,cxx:cxx,dxx:dxx,m:m,s:s,thn:thn});
|
||
}
|
||
});
|
||
}
|
||
});
|
||
|
||
$("#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(12)").text();
|
||
var nilai_pelunasan = currentRow.find("td:eq(13)").text();
|
||
var vr_pelunasan_id = currentRow.find("td:eq(14)").text();
|
||
var tglselsp = currentRow.find("td:eq(15)").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>
|