189 lines
10 KiB
PHP
189 lines
10 KiB
PHP
<?php
|
|
include('../../koneksi.php');
|
|
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
|
|
$satuan_kerja_id=$_POST['satuan_kerja_id'];
|
|
?>
|
|
|
|
<script type="text/javascript">$("#tabel_data_vmentor").DataTable({"stateSave": true,"paging": true,"lengthChange": true,"searching": true,"ordering": true,"info": true,"autoWidth": false});</script>
|
|
<br>
|
|
<input type="hidden" value="<?php echo $riwayat_kegiatan_id?>" id="riwayat_kegiatan_id">
|
|
<input type="hidden" value="<?php echo $satuan_kerja_id?>" id="satuan_kerja_id">
|
|
<table id="tabel_data_vmentor" class="table table-striped table-condensed" cellpadding="1" >
|
|
<thead>
|
|
<tr>
|
|
<td><b>Permohonan Mentor</b></td>
|
|
<td><b>Gol</b></td>
|
|
<td><b>Sex</b></td>
|
|
<td><b>Tenaga</b></td>
|
|
<td><b>Sebagai</b></td>
|
|
<td><b>Status</b></td>
|
|
<td align="center" width="110px;"><b>Tools</b></td>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
$data = pg_query("SELECT
|
|
p.nama,
|
|
p.golongan,
|
|
p.ruang,
|
|
p.jenis_kelamin,
|
|
j.nama,
|
|
t.id,
|
|
t.tanggal_reg,
|
|
s.nama,
|
|
t.status_mentor,
|
|
g.nama
|
|
FROM riwayat_peserta t
|
|
INNER JOIN data_pegawai p ON (p.id=t.data_pegawai_id)
|
|
INNER JOIN tenaga s ON (s.id=p.tenaga_id)
|
|
INNER JOIN tenaga2 j ON (j.id=p.tenaga2_id)
|
|
INNER JOIN bidang b ON (t.tenaga_id=b.tenaga_id)
|
|
INNER JOIN sebagai g ON (g.id=t.sebagai_id)
|
|
WHERE t.riwayat_kegiatan_id='$riwayat_kegiatan_id'
|
|
AND t.satuan_kerja_id='$satuan_kerja_id'
|
|
AND t.sebagai_id NOT IN ('1','3','5','6')
|
|
ORDER BY t.id DESC");
|
|
while($row=pg_fetch_array($data)) {
|
|
?>
|
|
<tr>
|
|
<td class="kiri"><b><?php echo $row[0]; ?></b></td>
|
|
<td><b><?php if ($row[1]=='-') {echo "-";} else {echo $row[1].'/'.$row[2];} ?></b></td>
|
|
<td><b><?php if ($row[3]=='Laki-laki') {echo "L";} else {echo "P";} ?></b></td>
|
|
<td><b><?php echo $row[7].' / '.$row[4]; ?></b></td>
|
|
<td><b><?php echo $row[9]; ?></b></td>
|
|
<td><b><?php echo $row['status_mentor']; ?></b></td>
|
|
<!--<td><b><?php echo date('d-m-Y',strtotime($row['tanggal_reg'])); ?></b></td>-->
|
|
<td align="center" class="kanan">
|
|
<button type="button" name="nd_permohonan_mentor" style="height:22px;"class="btn btn-primary btn-xs nd_permohonan_mentor" id="<?php echo $row['id'];?>" data-content="Nota Dinas Permohonan Mentor" rel="popover" data-placement="top" data-trigger="hover"
|
|
><i style="margin-top:3px" class="fa fa-envelope"></i>
|
|
</button>
|
|
<button type="button" name="cek_vmentor" style="height:22px;"class="btn btn-teal btn-xs cek_vmentor" id="<?php echo $row['id'];?>" data-content="Ready" rel="popover" data-placement="top" data-trigger="hover">
|
|
<i class="fa fa-check"></i>
|
|
</button>
|
|
<button type="button" name="ditolak_vmentor" style="height:22px;"class="btn btn-danger btn-xs ditolak_vmentor" id="<?php echo $row['id'];?>" data-content="Tolak" rel="popover" data-placement="top" data-trigger="hover">
|
|
<i class="fa fa-remove"></i>
|
|
</button>
|
|
<button type="button" name="batal_vmentor" style="height:22px;"class="btn btn-inverse btn-xs batal_vmentor" id="<?php echo $row['id'];?>" data-content="Batal" rel="popover" data-placement="top" data-trigger="hover">
|
|
<i class="fa fa-remove"></i>
|
|
</button>
|
|
<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>
|
|
<!-- <button type="button" name="delete_vmentor" style="height:22px;"class="btn btn-danger btn-xs delete_vmentor" id="<?php echo $row['id'];?>" data-content="Hapus" rel="popover" data-placement="top" data-trigger="hover">
|
|
<i class="fa fa-remove"></i>
|
|
</button> -->
|
|
</td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
|
|
|
|
|
|
<script type="text/javascript">
|
|
var riwayat_kegiatan_id=$('#riwayat_kegiatan_id').val();
|
|
var satuan_kerja_id=$('#satuan_kerja_id').val();
|
|
|
|
$('button[name="cek_vmentor"]').popover();
|
|
$('button[name="ditolak_vmentor"]').popover();
|
|
$('button[name="batal_vmentor"]').popover();
|
|
$('button[name="rw_pelatihan"]').popover();
|
|
$('button[name="nd_permohonan_mentor"]').popover();
|
|
|
|
$("#tabel_data_vmentor").on('click','.cek_vmentor',function(){
|
|
var key='cek_vmentor';
|
|
var id = $(this).attr('id');
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/cekmentor/mentor/crud.php",
|
|
data: 'id='+id
|
|
+'&key='+key,
|
|
success: function(data){
|
|
$('#tabel_vmentor').load("app/cekmentor/mentor/tabel.php",{riwayat_kegiatan_id:riwayat_kegiatan_id, satuan_kerja_id:satuan_kerja_id});
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#tabel_data_vmentor").on('click','.ditolak_vmentor',function(){
|
|
var key='ditolak_vmentor';
|
|
var id = $(this).attr('id');
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/cekmentor/mentor/crud.php",
|
|
data: 'id='+id
|
|
+'&key='+key,
|
|
success: function(data){
|
|
$('#tabel_vmentor').load("app/cekmentor/mentor/tabel.php",{riwayat_kegiatan_id:riwayat_kegiatan_id, satuan_kerja_id:satuan_kerja_id});
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#tabel_data_vmentor").on('click','.batal_vmentor',function(){
|
|
var key='batal_vmentor';
|
|
var id = $(this).attr('id');
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/cekmentor/mentor/crud.php",
|
|
data: 'id='+id
|
|
+'&key='+key,
|
|
success: function(data){
|
|
$('#tabel_vmentor').load("app/cekmentor/mentor/tabel.php",{riwayat_kegiatan_id:riwayat_kegiatan_id, satuan_kerja_id:satuan_kerja_id});
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#tabel_data_vmentor").on('click','.rw_pelatihan',function(){});
|
|
|
|
|
|
$("#tabel_data_vmentor").on('click','.delete_vmentor',function(){
|
|
var x = confirm("Anda yakin ingin menghapus ?");
|
|
if (x) {
|
|
var key = "delete_peserta";
|
|
var id = $(this).attr('id');
|
|
var rowElement = $(this).parent().parent();
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/info/pendaftaran/crud.php",
|
|
data: 'id='+id
|
|
+'&key='+key,
|
|
success: function(data){
|
|
rowElement.fadeOut(500).remove();
|
|
var riwayat_kegiatan_id=$('#riwayat_kegiatan_id').val();
|
|
var satuan_kerja_id=$('#satuan_kerja_id').val();
|
|
var s=$('#str').val();
|
|
$('#tabel_vmentor').load("app/cekpeserta/peserta/tabel.php",{riwayat_kegiatan_id:riwayat_kegiatan_id, satuan_kerja_id:satuan_kerja_id,str:s});
|
|
$('#ceksatker').trigger('change');
|
|
}
|
|
});
|
|
} else {}
|
|
});
|
|
|
|
|
|
$("#tabel_data_vmentor").on('click','.nd_permohonan_mentor',function(){
|
|
var riwayat_peserta_id = $(this).attr('id');
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/cekmentor/mentor/nd.php",
|
|
data: 'riwayat_peserta_id='+riwayat_peserta_id,
|
|
success: function(data){
|
|
alert('Nota Dinas permohonan mentor telah diterima.. Silakan cetak..');
|
|
var ling = 'app/cekmentor/mentor/'+riwayat_peserta_id+'/'+data;
|
|
window.open(ling);
|
|
window.close();
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/cekmentor/mentor/del_nd.php",
|
|
data: 'id='+riwayat_peserta_id,
|
|
success: function(data){}
|
|
});
|
|
}
|
|
});
|
|
});
|
|
|
|
|
|
|
|
</script>
|
|
|