199 lines
9.8 KiB
PHP
199 lines
9.8 KiB
PHP
<?php
|
|
include("../../koneksi.php");
|
|
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
|
|
$satuan_kerja_id=$_POST['satuan_kerja_id'];
|
|
$thn_skrg=date('Y');
|
|
$tot=$_POST['tot'];
|
|
$req=$_POST['req'];
|
|
$tenaga_id=$_POST['tenaga_id'];
|
|
$ket=$_POST['ket'];
|
|
$jenis_user=$_POST['jenis_user'];
|
|
$ket_id=$_POST['ket_id'];
|
|
if ($jenis_user=='Bidang') {
|
|
$d=pg_query("SELECT nama_pelatihan,(SELECT nama FROM jenis_pelatihan WHERE id=jenis_pelatihan_id)
|
|
FROM riwayat_kegiatan WHERE id='$riwayat_kegiatan_id'");
|
|
while($rd=pg_fetch_array($d)) {
|
|
$nama_pelatihan=$rd[0];
|
|
$jenis_pelatihan=$rd[1];
|
|
}
|
|
$s=pg_query("SELECT nama FROM satuan_kerja WHERE id='$satuan_kerja_id'");
|
|
while($rs=pg_fetch_array($s)) {$skr=$rs[0];}
|
|
?>
|
|
<br>
|
|
<br>
|
|
<br>
|
|
<br>
|
|
<span><b>
|
|
<?php echo $skr.' - '.$ket; ?><br>
|
|
<?php echo 'Tambah Peserta : '.strtoupper($jenis_pelatihan); ?><br>
|
|
<?php echo strtoupper($nama_pelatihan) ?></b>
|
|
</span>
|
|
<br>
|
|
<br>
|
|
<?php } else {} ?>
|
|
<input type="hidden" value="<?php echo $jenis_user; ?>" id="jenis_user">
|
|
<input type="hidden" value="<?php echo $ket_id; ?>" id="ket_id">
|
|
<input type="hidden" value="<?php echo $riwayat_kegiatan_id; ?>" id="riwayat_kegiatan_id">
|
|
<input type="hidden" value="<?php echo $ket; ?>" id="ket">
|
|
<input type="hidden" value="<?php echo $satuan_kerja_id; ?>" id="satuan_kerja_id">
|
|
<input type="hidden" id="temp_data" style="width:600px" value="<?php echo $tempdata; ?>">
|
|
<input type="hidden" id="sisa" style="width:600px" value="<?php echo $tot; ?>">
|
|
<input type="hidden" id="req" style="width:600px" value="<?php echo $req; ?>">
|
|
<input type="hidden" id="temp_jml" style="width:600px">
|
|
<input type="hidden" id="awal">
|
|
<button type="button" class="btn btn-default btn-rounded" id="back"><i class="fa fa-arrow-left m-r-5"></i>Back</button>
|
|
<button type="button" class="btn btn-success btn-rounded" id="approve"><i class="fa fa-check m-r-5"></i>Approve</button>
|
|
<span id="ket_quo"></span>
|
|
<br>
|
|
<br>
|
|
<table id="tabel_data_pendaftaran" class="table table-striped table-condensed" cellpadding="1">
|
|
<thead>
|
|
<tr>
|
|
<td align="center">
|
|
<!-- <input type="checkbox" name="checkAll" id="checkAll" class="checkbox cb_data" aria-label="Single checkbox Two" >-->
|
|
</td>
|
|
<td><b>Nama</b></td>
|
|
<!--<td><b>NIP</b></td>-->
|
|
<td><b>Gol</b></td>
|
|
<td><b>Sex</b></td>
|
|
<td><b>Jab</b></td>
|
|
<td><b>Count</b></td>
|
|
<td><b>Tools</b></td>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
$data = pg_query("SELECT p.*,s.nama,j.nama,
|
|
(SELECT COUNT(r.id) FROM riwayat_peserta r
|
|
INNER JOIN riwayat_kegiatan k ON (k.id=r.riwayat_kegiatan_id)
|
|
WHERE r.data_pegawai_id=p.id AND k.thn='$thn_skrg'
|
|
AND r.status='SELESAI')
|
|
FROM data_pegawai p
|
|
INNER JOIN satuan_kerja s ON (s.id=p.satuan_kerja)
|
|
INNER JOIN jabatan_pegawai j ON (j.id=p.jabatan_pegawai_id)
|
|
WHERE p.id IS NOT NULL AND p.aktif='t' AND p.tenaga_id='$tenaga_id'
|
|
".($satuan_kerja_id == null ? "" : "AND p.satuan_kerja='$satuan_kerja_id'")."
|
|
ORDER BY p.nama ASC");
|
|
while($row=pg_fetch_array($data)) {
|
|
?>
|
|
<tr>
|
|
<td align="center" class="kiri">
|
|
<input type="checkbox" id='checkDelete' name='checkDelete[]' class="checkbox cb_data" value="<?php echo $row['id']; ?>" aria-label="Single checkbox Two">
|
|
</td>
|
|
<td><b><?php echo $row[1]; ?></b></td>
|
|
<!--<td><?php echo $row[2]; ?></td>-->
|
|
<td><b><?php if ($row[3]=='-') {echo "-";} else {echo $row[3].'/'.$row[4];} ?></b></td>
|
|
<td><b><?php if ($row[5]=='Laki-laki') {echo "L";} else {echo "P";} ?></b></td>
|
|
<td><b><?php echo $row[21]; ?></b></td>
|
|
<td align="center"><b><?php echo $row[22]; ?></b></td>
|
|
<td align="center" class="kanan">
|
|
<button type="button" name="rw_pelatihan" style="height:22px;"class="btn btn-primary btn-xs rw_pelatihan" id="<?php echo $row['id'];?>" data-content="Riwayat" rel="popover" data-placement="top" data-trigger="hover">
|
|
<i class="fa fa-ellipsis-h"></i>
|
|
</button>
|
|
</td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
|
|
<script type="text/javascript">
|
|
var jenis_user = $('#jenis_user').val();
|
|
var ket_id = $('#ket_id').val();
|
|
|
|
var ket = $('#ket').val();
|
|
$('button[name="rw_pelatihan"]').popover();
|
|
$('input:checkbox').prop("checked", false);
|
|
$('#approve').attr("disabled", "disabled");
|
|
var sisa = $('#sisa').val();
|
|
var req = $('#req').val();
|
|
if (req==sisa) {
|
|
$("input#checkDelete").prop("disabled", true);
|
|
$("#checkAll").prop("disabled", true);
|
|
$("#ket_quo").html("Quota "+ket+" habis");
|
|
} else {
|
|
$("input#checkDelete").prop("disabled", false);
|
|
$("#checkAll").prop("disabled", false);
|
|
$("#ket_quo").html("Quota "+ket+": "+sisa+"/"+req);
|
|
}
|
|
function getSelectedVal(){
|
|
var ID={};
|
|
ID.values=[];
|
|
$("input#checkDelete").each(function(){
|
|
var $this = $(this);
|
|
if($this.is(":checked")){
|
|
ID.values.push($this.attr("value"));
|
|
}
|
|
$("#temp_data").val(ID.values);
|
|
$("#awal").val(ID.values);
|
|
$("#awal").trigger('input');
|
|
});
|
|
}
|
|
|
|
$("#checkAll").click(function () {
|
|
$('input:checkbox').not(this).prop('checked', this.checked);
|
|
});
|
|
|
|
$("input[type='checkbox']").change(function() {
|
|
getSelectedVal();
|
|
var sisax = $('#sisa').val();
|
|
var sisa2 = $('#req').val();
|
|
var sisa = parseInt(sisax)-parseInt(sisa2);
|
|
var temp_jml = $('input[type="checkbox"]:checked').length;
|
|
$('#temp_jml').val(temp_jml);
|
|
var h = parseInt(sisa2)+parseInt(temp_jml);
|
|
if (sisa == temp_jml) {
|
|
getSelectedVal();
|
|
$("#ket_quo").html("Quota "+ket+": "+sisax+"/"+(h));
|
|
$("input#checkDelete").prop("disabled", true);
|
|
$("#checkAll").prop("disabled", true);
|
|
alert('Quota penuh.. Silakan klik approve');
|
|
$(document).scrollTop(0);
|
|
} else {
|
|
$("#ket_quo").html("Quota "+ket+": "+sisax+"/"+(h));
|
|
}
|
|
});
|
|
|
|
$("#back").click(function(){
|
|
var riwayat_kegiatan_id = $('#riwayat_kegiatan_id').val();
|
|
var x = $('#satuan_kerja_id').val();
|
|
if (jenis_user=='Bidang') {
|
|
$.post('app/cekpeserta/peserta/main.php',{satuan_kerja_id:ket_id,riwayat_kegiatan_id : riwayat_kegiatan_id,x:x},function(html){$("#main_tag").html(html);
|
|
$('#ceksatker').trigger('change');});
|
|
} else {
|
|
var satuan_kerja_id = $('#satuan_kerja_id').val();
|
|
$.post('app/info/pendaftaran/tabel.php',{satuan_kerja_id : satuan_kerja_id, riwayat_kegiatan_id : riwayat_kegiatan_id},function(html){$("#tabel_quota").html(html);});
|
|
}
|
|
});
|
|
|
|
$('#approve').click(function(){
|
|
var riwayat_kegiatan_id = $('#riwayat_kegiatan_id').val();
|
|
var satuan_kerja_id = $('#satuan_kerja_id').val();
|
|
var pegawai_id = $('#temp_data').val();
|
|
var key = 'approve';
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/info/pendaftaran/crud.php",
|
|
data: 'pegawai_id='+pegawai_id
|
|
+'&riwayat_kegiatan_id='+riwayat_kegiatan_id
|
|
+'&satuan_kerja_id='+satuan_kerja_id
|
|
+'&key='+key,
|
|
success: function(data){
|
|
alert('tersimpan..');
|
|
$('#back').trigger('click');
|
|
$('#tabel_quota').load("app/info/pendaftaran/tabel.php",{riwayat_kegiatan_id:riwayat_kegiatan_id, satuan_kerja_id:satuan_kerja_id});
|
|
}
|
|
});
|
|
});
|
|
|
|
$('#awal').on('input',function(e){
|
|
var awal=$('#awal').val();
|
|
if (awal) {
|
|
$('#approve').removeAttr("disabled");
|
|
} else {
|
|
$('#approve').attr("disabled", "disabled");
|
|
}
|
|
});
|
|
</script>
|