simpro-rssa/app/st_spo/main.php

<style type="text/css">
.no-border{
  border:none;
}
.modal-backdrop {
    visibility: hidden !important;
}
.modal.in {
    background-color: rgba(0,0,0,0.5);
}
</style>
<?php 
include('../koneksi.php');

$data_pegawai_id=$_POST['data_pegawai_id'];
$d=pg_query("SELECT p.nama,p.nipb,p.golongan,p.ruang,s.nama 
FROM data_pegawai p 
INNER JOIN satuan_kerja s ON (s.id=p.satuan_kerja)
WHERE p.id=$data_pegawai_id
");
while($r=pg_fetch_array($d)) {
$nampeg=$r[0];
$nipb=$r[1];
$golongan=$r[2];
$ruang=$r[3];
$satker=$r[4];
}

if (($golongan=='I') && ($ruang=='a')) {$pangkat='Juru Muda';} else
if (($golongan=='I') && ($ruang=='b')) {$pangkat='Juru Muda Tingkat 1';} else
if (($golongan=='I') && ($ruang=='c')) {$pangkat='Juru';} else
if (($golongan=='I') && ($ruang=='d')) {$pangkat='Juru Tingkat 1';} else
if (($golongan=='II') && ($ruang=='a')) {$pangkat='Pengatur Muda';} else
if (($golongan=='II') && ($ruang=='b')) {$pangkat='Pengatur Muda Tingkat 1';} else
if (($golongan=='II') && ($ruang=='c')) {$pangkat='Pengatur';} else
if (($golongan=='II') && ($ruang=='d')) {$pangkat='Pengatur Tingkat 1';} else
if (($golongan=='III') && ($ruang=='a')) {$pangkat='Penata Muda';} else
if (($golongan=='III') && ($ruang=='b')) {$pangkat='Penata Muda Tingkat 1';} else
if (($golongan=='III') && ($ruang=='c')) {$pangkat='Penata';} else
if (($golongan=='III') && ($ruang=='d')) {$pangkat='Penata Tingkat 1';} else
if (($golongan=='IV') && ($ruang=='a')) {$pangkat='Pembina';} else
if (($golongan=='IV') && ($ruang=='b')) {$pangkat='Pembina Tingkat 1';} else
if (($golongan=='IV') && ($ruang=='c')) {$pangkat='Pembina Utama Muda';} else
if (($golongan=='IV') && ($ruang=='d')) {$pangkat='Pembina Utama Madya';} else
if (($golongan=='IV') && ($ruang=='e')) {$pangkat='Pembina Utama';}


$d1=pg_query("SELECT COUNT(*) FROM riwayat_spo WHERE data_pegawai_id=$data_pegawai_id AND status='PROSES PENGAJUAN'");
while($r1=pg_fetch_array($d1)) {$j1=$r1[0];}

$d2=pg_query("SELECT id,tgl_usulan,tujuan_spo FROM riwayat_spo WHERE data_pegawai_id=$data_pegawai_id AND status='PROSES PENGAJUAN'");
while($r2=pg_fetch_array($d2)) {$riwayat_spo_id=$r2[0];
$tgl_usulan=$r2[1];
if (($r2[1]==null) || ($r2[1]=='1970-01-01 00:00:00')) {$tgl_usulan='';$nm_tgl_usulan='';} else {
$nm_tgl_usulan='Tanggal usulan: ';
$tgl_usulan=date('d-m-Y',strtotime($r2[1]));
$tujuan_spo=$r2[2];
if ($tujuan_spo=='dn') {$tspo='DALAM NEGERI';} else
if ($tujuan_spo=='ln') {$tspo='LUAR NEGERI';}
}
}



?>
<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: '&lt;',
    rightArrow: '&gt;'
  }
});
$('.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>

<br>
<br>
<br>
<br>
<input type="hidden" id="riwayat_spo_id" value="<?php echo $riwayat_spo_id; ?>">
<input type="hidden" id="data_pegawai_id" value="<?php echo $data_pegawai_id; ?>">
<input type="hidden" id="jumlah_spo" value="<?php echo $j1; ?>">
<p class="judul_page"><i class="mdi mdi-lightbulb-outline m-r-5"></i>Sponsorship</p>

<div class="alert alert-icon alert-danger alert-dismissible fade in" role="alert" style="color:red" id="info_setor">
 <!--<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button>-->
  <i class="mdi mdi-information"></i>
<span style="font-family:InterSB;font-size:15px"><?php echo $nampeg.' / '.$nipb; ?></span>
<button type="button" class="btn btn-inverse btn-xs btn-rounded pull-right bat" id="proses_pengajuan">KIRIM</button><span class="pull-right bat">&nbsp;&nbsp;</span>
<button type="button" class="btn btn-danger btn-xs btn-rounded pull-right bat" id="batal_registrasi">BATAL</button><span class="pull-right bat">&nbsp;&nbsp;</span>
<span class="pull-right badge badge-teal" style="font-family:Arial;font-size:14px;font-weight:bold" id="sp_tgl_usulan"><?php echo $tgl_usulan; ?></span>
<span class="pull-right" style="font-family:Arial;font-size:14px;font-weight:bold;" id="sp_nm_tgl_usulan"><?php echo $nm_tgl_usulan.'&nbsp;'; ?></span><br>

<!--<span style="font-family:Inter;font-size:15px"><?php echo $pangkat.' - '.$golongan.'/'.$ruang; ?></span>-->
<span style="font-family:InterSB;font-size:15px;color:black"><?php echo 'Mohon upload semua persyaratan, lalu klik tombol "KIRIM" di pojok kanan berwarna hitam'; ?></span>
</div>


<div class="row" style="color:black" id="tes1">
<div class="col-lg-2">
<select class="form-control" id="tujuan_spo">
<option value="0" <?php if ($tujuan_spo=='0') {echo 'selected';} ?>>-- Dalam/Luar Negeri --</option>
<option value="dn" <?php if ($tujuan_spo=='dn') {echo 'selected';} ?>>DALAM NEGERI</option>
<option value="ln" <?php if ($tujuan_spo=='ln') {echo 'selected';} ?>>LUAR NEGERI</option>
</select>
</div>
<div class="col-lg-4">
<button class="btn btn-default btn-block" id="btn_tambah_ijin" style="font-family:Arial;font-weight:bold"><i class="fa fa-plus m-r-5"></i>
Registrasi Kelengkapan dan Persyaratan Sponsorship
</button>
</div>
<div class="col-lg-2">
<button class="btn btn-default btn-block" id="btn_tgg1" style="font-family:Arial;font-weight:bold"><i class="mdi mdi-timer-sand m-r-5"></i>
Tunggu&nbsp;
<span class="label label-purple" style="margin-top:2px" id="spotggbg_notif"></span>
</button>
</div>
<div class="col-lg-2">
<button class="btn btn-default btn-block" id="btn_rev1" style="font-family:Arial;font-weight:bold"><i class="mdi mdi-backup-restore m-r-5"></i>
Revisi&nbsp;
<span class="label label-danger" style="margin-top:2px" id="sporevbg_notif"></span>
</button>
</div>
<div class="col-lg-2">
<button class="btn btn-default btn-block" id="btn_riwayat1" style="font-family:Arial;font-weight:bold"><i class="mdi mdi-apps m-r-5"></i>
Riwayat&nbsp;
<span class="label label-success" style="margin-top:2px" id="spobg_notif"></span>
</button>
</div>
</div>

<div class="row" style="color:black" id="tes2">
<div class="col-lg-6">
<span style="font-family:Arial;font-weight:bold" id="hdrspo">
Daftar Kelengkapan dan Persyaratan Sponsorship <?php echo $tspo; ?>
</span>
</div>
<div class="col-lg-2">
<button class="btn btn-default btn-block" id="btn_tgg2" style="font-family:Arial;font-weight:bold"><i class="mdi mdi-timer-sand m-r-5"></i>
Tunggu&nbsp;
<span class="label label-purple pull-right" style="margin-top:2px" id="spotggbg_notif2"></span>
</button>
</div>
<div class="col-lg-2">
<button class="btn btn-default btn-block" id="btn_rev2" style="font-family:Arial;font-weight:bold"><i class="mdi mdi-backup-restore m-r-5"></i>
Revisi&nbsp;
<span class="label label-danger pull-right" style="margin-top:2px" id="sporevbg_notif2"></span>
</button>
</div>
<div class="col-lg-2">
<button class="btn btn-default btn-block" id="btn_riwayat2" style="font-family:Arial;font-weight:bold"><i class="mdi mdi-apps m-r-5"></i>
Riwayat&nbsp;
<span class="label label-success pull-right" style="margin-top:2px" id="spobg_notif2"></span>
</button>
</div>
</div>
<div id="tabel_kelengkapan"></div>


                            

                            <div id="modal_riwayat" 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="judul_modal_riwayat"></h4>
                                        </div>
                                        <div class="modal-body" id="modal_body_riwayat"></div>
                                        <!--<div class="modal-footer no-border">
                                            <button type="button" class="btn btn-success btn-block waves-effect" data-dismiss="modal" id="keluar_riwayat">Keluar</button>
                                        </div>-->
                                    </div>
                                </div>
                            </div>

<div id="modal_verifikasi" 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="modal_head_verifikasi"></h4>
   </div>
   <div class="modal-body" id="modal_body_verifikasi"></div>
  </div>
 </div>
</div>

        <div class="modal" id="modal_view">
          <div class="modal-dialog">
            <div class="modal-content">
              <div class="modal-header no-border">
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                  <span aria-hidden="true">&times;</span></button>
                <h4 class="modal-title" id="modal_head_view"></h4>
              </div>
              <div class="modal-body md_input_bd" id="modal_body_view"></div>
            </div>
          </div>
        </div>

<div id="modal_file" 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">Upload</h4>
                                        </div>
                                        <div class="modal-body" id="modal_body_file"></div>
                                        <div class="modal-footer no-border">
                                            <button type="button" class="btn btn-success btn-block waves-effect" data-dismiss="modal" id="keluar_file">Keluar</button>
                                        </div>
                                    </div>
                                </div>
                            </div>

<script>
var data_pegawai_id=$('#data_pegawai_id').val();
$.ajax({
  type: "POST",
  url:'app/st_spo/not_notif.php',
  data: 'data_pegawai_id='+data_pegawai_id,
  success: function(data){
    if (data==0) {$('#spobg_notif').hide();$('#spobg_notif2').hide();} else {
    $('#spobg_notif').show();
    $('#spobg_notif').html(data);
    $('#spobg_notif2').show();
    $('#spobg_notif2').html(data);
    }
  }
});

$.ajax({
  type: "POST",
  url:'app/st_spo/not_revnotif.php',
  data: 'data_pegawai_id='+data_pegawai_id,
  success: function(data){
    if (data==0) {$('#sporevbg_notif').hide();$('#sporevbg_notif2').hide();} else {
    $('#sporevbg_notif').show();
    $('#sporevbg_notif').html(data);
    $('#sporevbg_notif2').show();
    $('#sporevbg_notif2').html(data);
    }
  }
});

function nottgg() {
$.ajax({
  type: "POST",
  url:'app/st_spo/not_tggnotif.php',
  data: 'data_pegawai_id='+data_pegawai_id,
  success: function(data){
    if (data==0) {$('#spotggbg_notif').hide();$('#spotggbg_notif2').hide();} else {
    $('#spotggbg_notif').show();
    $('#spotggbg_notif').html(data);
    $('#spotggbg_notif2').show();
    $('#spotggbg_notif2').html(data);
    }
  }
});
}

nottgg();

$('#btn_riwayat1,#btn_riwayat2').click(function(){
var data_pegawai_id=$('#data_pegawai_id').val();
	$('#modal_riwayat').modal('show');
	$('#modal_body_riwayat').html("");
	$.ajax({
		type: "POST",
		url: "app/st_spo/modal_riwayat.php",
		data: 'data_pegawai_id='+data_pegawai_id,
		success: function(data){
			$('#modal_body_riwayat').html(data);
        	$('#judul_modal_riwayat').html('Riwayat Usulan Sponsorship');
		}
	});
});

$('#btn_rev1,#btn_rev2').click(function(){
var data_pegawai_id=$('#data_pegawai_id').val();
	$('#modal_riwayat').modal('show');
	$('#modal_body_riwayat').html("");
	$.ajax({
		type: "POST",
		url: "app/st_spo/modal_revisi.php",
		data: 'data_pegawai_id='+data_pegawai_id,
		success: function(data){
			$('#modal_body_riwayat').html(data);
        	$('#judul_modal_riwayat').html('Revisi Usulan Sponsorship');
		}
	});
});

$('#btn_tgg1,#btn_tgg2').click(function(){
var data_pegawai_id=$('#data_pegawai_id').val();
	$('#modal_riwayat').modal('show');
	$('#modal_body_riwayat').html("");
	$.ajax({
		type: "POST",
		url: "app/st_spo/modal_tgg.php",
		data: 'data_pegawai_id='+data_pegawai_id,
		success: function(data){
			$('#modal_body_riwayat').html(data);
        	$('#judul_modal_riwayat').html('Tunggu Proses Sponsorship');
		}
	});
});

var jumlah_spo=$('#jumlah_spo').val();
if (jumlah_spo=='0') {
$('#tes1').show();
$('#tes2').hide();
$('.bat').hide();
} else {
$('#tes1').hide();
$('#tes2').show();
$('.bat').show();
var riwayat_spo_id=$('#riwayat_spo_id').val();
var data_pegawai_id=$('#data_pegawai_id').val();
var tujuan_spo=$('#tujuan_spo').val();
$('#tabel_kelengkapan').load('app/st_spo/tabel_daftar.php',{riwayat_spo_id:riwayat_spo_id, data_pegawai_id:data_pegawai_id, tujuan_spo:tujuan_spo});
}

$('#batal_registrasi').click(function(){
     var x = confirm("Anda yakin ingin membatalkan ?");
     if (x) {    
     var key = "hapus_verifikasi";
     var riwayat_spo_id=$('#riwayat_spo_id').val();
     $.ajax({
        type: "POST",
        url: "app/spo_inbox/crud.php",
        data: 'riwayat_spo_id='+riwayat_spo_id
        +'&key='+key,
        success: function(data){
			$('#riwayat_spo_id').val('');
      		$('#sp_nm_tgl_usulan').html('');
      		$('#sp_tgl_usulan').html('');
        	$('#jumlah_spo').val('0');
			var data_pegawai_id=$('#data_pegawai_id').val();
			$('#tabel_kelengkapan').empty();
			$('#tes1').show();
			$('#tes2').hide();
			$('.bat').hide();
        	$('#tujuan_spo').val('0');
         }
      });  
    } else {}
});

$('#proses_pengajuan').click(function(){
var tujuan_spo=$('#tujuan_spo').val();
if (tujuan_spo=='0') {
	alert('Tentukan dalam / luar negeri ?');
	$('#tujuan_spo').focus();
} else {
     var key1='cek_lkp';
     var riwayat_spo_id=$('#riwayat_spo_id').val();
     $.ajax({
        type: "POST",
        url: "app/st_spo/crud.php",
        data: 'riwayat_spo_id='+riwayat_spo_id
     	+'&tujuan_spo='+tujuan_spo
        +'&key='+key1,
        success: function(data){
       //   if (data=='0') {
           var x = confirm("Apakah anda yakin akan mengirim sekarang ?");
     	   if (x) {
			var key = "proses_pengajuan";    
     		var riwayat_spo_id=$('#riwayat_spo_id').val();
     		$.ajax({
        		type: "POST",
        		url: "app/st_spo/crud.php",
        		data: 'riwayat_spo_id='+riwayat_spo_id
        		+'&key='+key,
        		success: function(data){
					$('#riwayat_spo_id').val('');
      				$('#sp_nm_tgl_usulan').html('');
      				$('#sp_tgl_usulan').html('');
        			$('#jumlah_spo').val('0');
					var data_pegawai_id=$('#data_pegawai_id').val();
					$('#tabel_kelengkapan').empty();
					$('#tes1').show();
					$('#tes2').hide();
					$('.bat').hide();
                	$('#tujuan_spo').val('0');
        			nottgg();
         		}
      		});
           } else {}
     //     } else {alert('Berkas persyaratan masih kurang lengkap, Mohon di-upload semua');}
         }
      });
}
});

$('#btn_tambah_ijin').click(function(){
var tujuan_spo=$('#tujuan_spo').val();
if (tujuan_spo=='0') {
	alert('Tentukan dalam / luar negeri ?');
	$('#tujuan_spo').focus();
} else {
var data_pegawai_id=$('#data_pegawai_id').val();
$.ajax({
  type: "POST",
  url:'app/st_spo/not_tmbnotif.php',
  data: 'data_pegawai_id='+data_pegawai_id,
  success: function(data){
  	var ch = data.split('$%^');
  	var j1=Number(ch[0]).toString();
    var j2=Number(ch[1]).toString();
    if ((j1=='0') && (j2=='0')) {
  	var data_pegawai_id=$('#data_pegawai_id').val();
	var key='tambah_spo';
    var x = confirm("Anda yakin ingin menambah ?");
    if (x) {  
	$.ajax({
      type: "POST",
      url: "app/st_spo/crud.php",
      data: 'data_pegawai_id='+data_pegawai_id
      +'&tujuan_spo='+tujuan_spo
      +'&key='+key,
      success: function(data){
        var chars = data.split('$%^');
        var riwayat_spo_idvv=chars[0];
      	var nm_tgl_usulan=chars[1];
      	var tgl_usulan=chars[2];
      	$('#riwayat_spo_id').val(riwayat_spo_idvv);
      	$('#sp_nm_tgl_usulan').html(nm_tgl_usulan);
      	$('#sp_tgl_usulan').html(tgl_usulan);
        $('#jumlah_spo').val('1');
      	var riwayat_spo_id=$('#riwayat_spo_id').val();
		var data_pegawai_id=$('#data_pegawai_id').val();
      	var tujuan_spo=$('#tujuan_spo').val();
		$('#tabel_kelengkapan').load('app/st_spo/tabel_daftar.php',{riwayat_spo_id:riwayat_spo_id, data_pegawai_id:data_pegawai_id, tujuan_spo:tujuan_spo});
      	$('#tes1').hide();
		$('#tes2').show();
        $('.bat').show();
      	if (tujuan_spo=='dn') {var tspo='DALAM NEGERI';} else if (tujuan_spo=='ln') {var tspo='LUAR NEGERI';}
      	$('#hdrspo').html('Daftar Kelengkapan dan Persyaratan Sponsorship '+tspo);
      }
    });
    } else {}
	} else {alert('Anda memiliki pengajuan yang belum di-proses, silakan klik tombol TUNGGU untuk melihat detailnya.\nAtau anda memiliki pengajuan yang masih revisi, silakan klik tombol REVISI');}
  }
});
}
});


				
            
                var callAjax_spounasan_notif = function(){
                	var data_pegawai_id=$('#data_pegawai_id').val();
                    $.ajax({
                        type: "POST",
                        url:'app/st_spo/not_notif.php',
                    	data: 'data_pegawai_id='+data_pegawai_id,
                        success: function(data){
                            if (data==0) {$('#spobg_notif').hide();$('#spobg_notif2').hide();} else {
                                $('#spobg_notif').show();
                                $('#spobg_notif').html(data);
                                $('#spobg_notif2').show();
                                $('#spobg_notif2').html(data);
                            }
                        }
                    });
                }
                setInterval(callAjax_spounasan_notif,5000);

				var callAjax_rev_notif = function(){
                	var data_pegawai_id=$('#data_pegawai_id').val();
                    $.ajax({
                        type: "POST",
                        url:'app/st_spo/not_revnotif.php',
                    	data: 'data_pegawai_id='+data_pegawai_id,
                        success: function(data){
                            if (data==0) {$('#sporevbg_notif').hide();$('#sporevbg_notif2').hide();} else {
                                $('#sporevbg_notif').show();
                                $('#sporevbg_notif').html(data);
                                $('#sporevbg_notif2').show();
                                $('#sporevbg_notif2').html(data);
                                
                            }
                        }
                    });
                }
                setInterval(callAjax_rev_notif,5000);

				var callAjax_tgg_notif = function(){
                	var data_pegawai_id=$('#data_pegawai_id').val();
                    $.ajax({
                        type: "POST",
                        url:'app/st_spo/not_tggnotif.php',
                    	data: 'data_pegawai_id='+data_pegawai_id,
                        success: function(data){
                            if (data==0) {$('#spotggbg_notif').hide();$('#spotggbg_notif2').hide();} else {
    							$('#spotggbg_notif').show();
    							$('#spotggbg_notif').html(data);
    							$('#spotggbg_notif2').show();
    							$('#spotggbg_notif2').html(data);
    						}
                        }
                    });
                }
                setInterval(callAjax_tgg_notif,5000);





$(document).on('hidden.bs.modal', function (event) {
  if ($('.modal:visible').length) {
    $('body').addClass('modal-open');
  }
});
</script>