360 lines
14 KiB
PHP
360 lines
14 KiB
PHP
<script type="text/javascript">
|
||
var userTarget = "";
|
||
var exit = false;
|
||
$('.input-daterange').datepicker({
|
||
format: "dd/mm/yyyy",
|
||
weekStart: 1,
|
||
orientation: "bottom auto",
|
||
autoclose: true,
|
||
showOnFocus: true,
|
||
maxViewMode: 'days',
|
||
keepEmptyValues: true,
|
||
templates: {
|
||
leftArrow: '<',
|
||
rightArrow: '>'
|
||
}
|
||
});
|
||
$('.input-daterange').focusin(function(e) {
|
||
userTarget = e.target.name;
|
||
});
|
||
$('.input-daterange').on('changeDate', function(e) {
|
||
if (exit) return;
|
||
if (e.target.name != userTarget) {
|
||
exit = true;
|
||
$(e.target).datepicker('clearDates');
|
||
}
|
||
exit = false;
|
||
});
|
||
var thn_dpa=$('#thn_dpa').val();
|
||
</script>
|
||
<style type="text/css">
|
||
.modal-backdrop {
|
||
visibility: hidden !important;
|
||
}
|
||
.modal.in {
|
||
background-color: rgba(0,0,0,0.5);
|
||
}
|
||
</style>
|
||
<?php
|
||
include("../koneksi.php");
|
||
$thn=$_POST['thn_dpa'];
|
||
$jenis=$_POST['jenis'];
|
||
$nama_verifikator=$_POST['nampeg'];
|
||
?>
|
||
<br>
|
||
<br>
|
||
<br>
|
||
<br>
|
||
<p class="judul_page"><i class="mdi mdi-tag-text-outline m-r-5"></i>Laporan Proses PBJ</p>
|
||
|
||
<div class="row">
|
||
<div class="col-lg-1">
|
||
<select id="c1" name="c1" class="form-control" data-content="KPA" rel="popover" data-placement="top" data-trigger="hover">
|
||
<option></option>
|
||
<?php
|
||
$d=pg_query("SELECT DISTINCT a1.id,a1.inisial
|
||
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)
|
||
WHERE s.thn='$thn' AND l.tanggal_setor IS NULL
|
||
AND l.st_setor_verif IS NULL AND l.tgl_setor_verif IS NULL AND p.status_setor IS NULL
|
||
");
|
||
while($r=pg_fetch_array($d)) {
|
||
|
||
?>
|
||
<option value="<?php echo $r[0];?>"><?php echo $r[1];?></option>
|
||
<?php } ?>
|
||
</select>
|
||
</div>
|
||
<div class="col-lg-1">
|
||
<select id="c2" name="c2" class="form-control" data-content="PPKOM" rel="popover" data-placement="top" data-trigger="hover">
|
||
<option></option>
|
||
<?php
|
||
$d=pg_query("SELECT DISTINCT a1.id,a1.inisial
|
||
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 ppkom a1 ON (s.ppkom_id=a1.id)
|
||
WHERE s.thn='$thn' AND l.tanggal_setor IS NULL
|
||
AND l.st_setor_verif IS NULL AND l.tgl_setor_verif IS NULL AND p.status_setor IS NULL
|
||
");
|
||
while($r=pg_fetch_array($d)) {
|
||
|
||
?>
|
||
<option value="<?php echo $r[0];?>"><?php echo $r[1];?></option>
|
||
<?php } ?>
|
||
</select>
|
||
</div>
|
||
<div class="col-lg-2">
|
||
<select id="c3" name="c3" class="form-control" data-content="PPTK" rel="popover" data-placement="top" data-trigger="hover">
|
||
<option></option>
|
||
<?php
|
||
$d=pg_query("SELECT DISTINCT a1.id,a1.inisial
|
||
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 pptk a1 ON (s.pptk_id=a1.id)
|
||
WHERE s.thn='$thn' AND l.tanggal_setor IS NULL
|
||
AND l.st_setor_verif IS NULL AND l.tgl_setor_verif IS NULL AND p.status_setor IS NULL
|
||
");
|
||
while($r=pg_fetch_array($d)) {
|
||
|
||
?>
|
||
<option value="<?php echo $r[0];?>"><?php echo $r[1];?></option>
|
||
<?php } ?>
|
||
</select>
|
||
</div>
|
||
<div class="col-lg-4">
|
||
<div class="input-group input-daterange" style="width:100%;" name="pd1" id="pd1">
|
||
<input type="text" id="tgl_mulai1" name="start" class="form-control" style="border-radius: 0px;border-color:#f3f3f3;text-align: center;" data-content="Tanggal Input" rel="popover" data-placement="top" data-trigger="hover">
|
||
<span class="input-group-addon">s/d</span>
|
||
<input type="text" id="tgl_selesai1" name="finish" class="form-control" style="border-radius: 0px;border-color:#f3f3f3;text-align: center;" data-content="Tanggal Input" rel="popover" data-placement="top" data-trigger="hover">
|
||
</div>
|
||
</div>
|
||
<div class="col-lg-4">
|
||
<div class="input-group my-group">
|
||
<span><input type="text" class="form-control total_sg" style="width:100%;text-align:right" id="total_proses" disabled></span>
|
||
<span class="input-group-btn">
|
||
<button type="button" id="excel" name="excel" class="btn btn-success"><i class="fa fa-arrow-down m-r-5"></i>EXCEL</button>
|
||
</span>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
|
||
<br>
|
||
<select class="form-control" name="cari_adm_pengadaan" id="cari_adm_pengadaan"
|
||
style="font-family:Arial;margin-top:-2px;border:0px;border-radius:0px;border-bottom: 1px solid #ccd3d6;font-weight:bold">
|
||
<option><span>-- Pilih Admin --</span></option>
|
||
<option value=""><span>-- ALL --</span></option>
|
||
<?php
|
||
|
||
$d=pg_query("SELECT DISTINCT l.adm_pengadaan
|
||
FROM pekerjaan p
|
||
INNER JOIN sub_kegiatan s ON (s.id=p.sub_kegiatan_id)
|
||
INNER JOIN rekanan k ON (k.id=p.rekanan_id)
|
||
INNER JOIN vr_realisasi r ON (p.id=r.pekerjaan_id)
|
||
INNER JOIN vr_pelunasan l ON (r.id=l.vr_realisasi_id)
|
||
WHERE l.st_setor_verif IS NULL AND l.tgl_setor_verif IS NULL AND p.status_setor IS NULL
|
||
");
|
||
while($r=pg_fetch_array($d)) {
|
||
?>
|
||
<option value="<?php echo $r[0];?>"><?php echo $r[0];?></option>
|
||
<?php } ?>
|
||
</select>
|
||
<br>
|
||
<div id="tabel_laporan"></div>
|
||
|
||
<div id="modal_sub" 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">Sub Kegiatan</h4>
|
||
</div>
|
||
<div class="modal-body" id="modal_body_sub"></div>
|
||
<div class="modal-footer no-border">
|
||
<button type="button" class="btn btn-default waves-effect" data-dismiss="modal" id="keluar_sub">Keluar</button>
|
||
</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">Info Kelengkapan Berkas</h4>
|
||
</div>
|
||
<div class="modal-body" id="modal_body_kelengkapan"></div>
|
||
<div class="modal-footer no-border">
|
||
<button type="button" class="btn btn-default waves-effect" data-dismiss="modal" id="keluar_kelengkapan">Keluar</button>
|
||
<!--<button type="button" class="btn btn-teal waves-effect waves-light" id="simpan_verifikasi">Simpan</button>-->
|
||
</div>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
|
||
|
||
|
||
<script>
|
||
/*
|
||
var cari_adm_pengadaan=$('#cari_adm_pengadaan').val();
|
||
$('#tabel_laporan').load("app/lap_proses_pbj/tabel.php",{cari_adm_pengadaan:cari_adm_pengadaan});
|
||
*/
|
||
|
||
$('#cari_adm_pengadaan').change(function(){
|
||
var thn=$('#thn_dpa').val();
|
||
var cari_adm_pengadaan=$('#cari_adm_pengadaan').val();
|
||
$('#tabel_laporan').load("app/lap_proses_pbj/tabel.php",{cari_adm_pengadaan:cari_adm_pengadaan, thn:thn});
|
||
});
|
||
</script>
|
||
<script>
|
||
|
||
$('select[name="c1"]').popover();
|
||
$('select[name="c2"]').popover();
|
||
$('select[name="c3"]').popover();
|
||
$('input[name="start"]').popover();
|
||
$('input[name="finish"]').popover();
|
||
|
||
|
||
var thn=$('#thn_dpa').val();
|
||
var axx = $('#c1').val();
|
||
var bxx = $('#c2').val();
|
||
var cxx = $('#c3').val();
|
||
var cari_adm_pengadaan=$('#cari_adm_pengadaan').val();
|
||
var key = 'total_proses';
|
||
$.ajax({
|
||
type: "POST",
|
||
url: "app/lap_proses_pbj/crud.php",
|
||
data: 'thn='+thn
|
||
+'&axx='+axx
|
||
+'&bxx='+bxx
|
||
+'&cxx='+cxx
|
||
+'&cari_adm_pengadaan='+cari_adm_pengadaan
|
||
+'&key='+key,
|
||
success: function(data){
|
||
$('#total_proses').val(data);
|
||
}
|
||
});
|
||
|
||
$('#c1').change(function(){
|
||
var axx = $('#c1').val();
|
||
var bxx = $('#c2').val();
|
||
var cxx = $('#c3').val();
|
||
var m = $('#tgl_mulai1').val();
|
||
var s = $('#tgl_selesai1').val();
|
||
var cari_adm_pengadaan=$('#cari_adm_pengadaan').val();
|
||
$('#tabel_laporan').load('app/lap_proses_pbj/tabel.php',{cari_adm_pengadaan:cari_adm_pengadaan,m:m,s:s,axx:axx,bxx:bxx,cxx:cxx,thn:thn});
|
||
var key = 'total_proses';
|
||
$.ajax({
|
||
type: "POST",
|
||
url: "app/lap_proses_pbj/crud.php",
|
||
data: 'thn='+thn
|
||
+'&axx='+axx
|
||
+'&bxx='+bxx
|
||
+'&cxx='+cxx
|
||
+'&cari_adm_pengadaan='+cari_adm_pengadaan
|
||
+'&m='+m
|
||
+'&s='+s
|
||
+'&key='+key,
|
||
success: function(data){
|
||
$('#total_proses').val(data);
|
||
}
|
||
});
|
||
});
|
||
|
||
$('#c2').change(function(){
|
||
var axx = $('#c1').val();
|
||
var bxx = $('#c2').val();
|
||
var cxx = $('#c3').val();
|
||
var m = $('#tgl_mulai1').val();
|
||
var s = $('#tgl_selesai1').val();
|
||
var cari_adm_pengadaan=$('#cari_adm_pengadaan').val();
|
||
$('#tabel_laporan').load('app/lap_proses_pbj/tabel.php',{cari_adm_pengadaan:cari_adm_pengadaan,m:m,s:s,axx:axx,bxx:bxx,cxx:cxx,thn:thn});
|
||
var key = 'total_proses';
|
||
$.ajax({
|
||
type: "POST",
|
||
url: "app/lap_proses_pbj/crud.php",
|
||
data: 'thn='+thn
|
||
+'&axx='+axx
|
||
+'&bxx='+bxx
|
||
+'&cxx='+cxx
|
||
+'&cari_adm_pengadaan='+cari_adm_pengadaan
|
||
+'&m='+m
|
||
+'&s='+s
|
||
+'&key='+key,
|
||
success: function(data){
|
||
$('#total_proses').val(data);
|
||
}
|
||
});
|
||
});
|
||
|
||
$('#c3').change(function(){
|
||
var axx = $('#c1').val();
|
||
var bxx = $('#c2').val();
|
||
var cxx = $('#c3').val();
|
||
var m = $('#tgl_mulai1').val();
|
||
var s = $('#tgl_selesai1').val();
|
||
var cari_adm_pengadaan=$('#cari_adm_pengadaan').val();
|
||
$('#tabel_laporan').load('app/lap_proses_pbj/tabel.php',{cari_adm_pengadaan:cari_adm_pengadaan,axx:axx,bxx:bxx,cxx:cxx,m:m,s:s,thn:thn});
|
||
var key = 'total_proses';
|
||
$.ajax({
|
||
type: "POST",
|
||
url: "app/lap_proses_pbj/crud.php",
|
||
data: 'thn='+thn
|
||
+'&axx='+axx
|
||
+'&bxx='+bxx
|
||
+'&cxx='+cxx
|
||
+'&cari_adm_pengadaan='+cari_adm_pengadaan
|
||
+'&m='+m
|
||
+'&s='+s
|
||
+'&key='+key,
|
||
success: function(data){
|
||
$('#total_proses').val(data);
|
||
}
|
||
});
|
||
});
|
||
|
||
$('#cari_adm_pengadaan').change(function(){
|
||
var axx = $('#c1').val();
|
||
var bxx = $('#c2').val();
|
||
var cxx = $('#c3').val();
|
||
var m = $('#tgl_mulai1').val();
|
||
var s = $('#tgl_selesai1').val();
|
||
var cari_adm_pengadaan=$('#cari_adm_pengadaan').val();
|
||
$('#tabel_laporan').load('app/lap_proses_pbj/tabel.php',{cari_adm_pengadaan:cari_adm_pengadaan,axx:axx,bxx:bxx,cxx:cxx,m:m,s:s,thn:thn});
|
||
var key = 'total_proses';
|
||
$.ajax({
|
||
type: "POST",
|
||
url: "app/lap_proses_pbj/crud.php",
|
||
data: 'thn='+thn
|
||
+'&axx='+axx
|
||
+'&bxx='+bxx
|
||
+'&cxx='+cxx
|
||
+'&cari_adm_pengadaan='+cari_adm_pengadaan
|
||
+'&m='+m
|
||
+'&s='+s
|
||
+'&key='+key,
|
||
success: function(data){
|
||
$('#total_proses').val(data);
|
||
}
|
||
});
|
||
});
|
||
|
||
$('#tgl_selesai1').change(function(){
|
||
$('#c1').trigger('change');
|
||
});
|
||
|
||
$("#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');
|
||
});
|
||
|
||
$('#excel').click(function(){
|
||
var w = 600;
|
||
var h = 300;
|
||
var thn=$('#thn_dpa').val();
|
||
var a = $('#c1').val();
|
||
var b = $('#c2').val();
|
||
var c = $('#c3').val();
|
||
var m = $('#tgl_mulai1').val();
|
||
var s = $('#tgl_selesai1').val();
|
||
var cari_adm_pengadaan=$('#cari_adm_pengadaan').val();
|
||
var left = Number((screen.width/2)-(w/2));
|
||
var tops = Number((screen.height/2)-(h/2));
|
||
window.open('app/lap_proses_pbj/excel.php?cari_adm_pengadaan='+cari_adm_pengadaan+"&a="+a+"&b="+b+"&c="+c+"&thn="+thn+"&m="+m+"&s="+s,'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);
|
||
});
|
||
|
||
</script>
|