191 lines
6.3 KiB
PHP
191 lines
6.3 KiB
PHP
<?php include('../../koneksi.php');
|
|
$id=$_POST['riwayat_kegiatan_id'];
|
|
$d=pg_query("SELECT nama_pelatihan,(SELECT nama FROM jenis_pelatihan WHERE id=jenis_pelatihan_id),tanggal_mulai,tanggal_selesai
|
|
FROM riwayat_kegiatan WHERE id='$id'");
|
|
while($rd=pg_fetch_array($d)) {
|
|
$nama_pelatihan=$rd[0];
|
|
$jenis_pelatihan=$rd[1];
|
|
$tanggal_mulai=$rd[2];
|
|
$tanggal_selesai=$rd[3];
|
|
}
|
|
|
|
$tgl_mulai=$tanggal_mulai;
|
|
$tgl_mulai=str_replace('/','-',$tgl_mulai);
|
|
$tm=date('Y',strtotime($tgl_mulai));
|
|
$bm=date('m',strtotime($tgl_mulai));
|
|
$hm=date('d',strtotime($tgl_mulai));
|
|
|
|
$tgl_selesai=$tanggal_selesai;
|
|
$tgl_selesai=str_replace('/','-',$tgl_selesai);
|
|
$ts=date('Y',strtotime($tgl_selesai));
|
|
$bs=date('m',strtotime($tgl_selesai));
|
|
$hs=date('d',strtotime($tgl_selesai));
|
|
|
|
$date1="$tm-$bm-$hm";
|
|
$date2="$ts-$bs-$hs";
|
|
?>
|
|
|
|
<script>
|
|
var sess_satker = $('#cek_satker').val();
|
|
var sess_jenis = $('#cek_jenis').val();
|
|
</script>
|
|
|
|
<style type="text/css">
|
|
.btn-circle.btn-md {
|
|
width: 40px;
|
|
height: 40px;
|
|
padding: 7px 10px;
|
|
border-radius: 25px;
|
|
font-size: 15px;
|
|
text-align: center;
|
|
border: 3px solid #66b5fb;
|
|
}
|
|
|
|
#sidebar-menu ul li a:hover {
|
|
background:#f1f3f4 !important;
|
|
font-color:white;
|
|
}
|
|
|
|
#sidebar-menu ul li a:focus {
|
|
background:#fce8e6 !important;
|
|
color:#d93025 !important;
|
|
font-weight: bold;
|
|
}
|
|
</style>
|
|
|
|
|
|
<br>
|
|
<br>
|
|
<br>
|
|
<br>
|
|
<div class="row">
|
|
<div class="col-md-12 col-sm-12 col-xs-12">
|
|
<span><b>
|
|
<?php echo 'Daftar Hadir : '.strtoupper($jenis_pelatihan); ?><br>
|
|
<?php echo strtoupper($nama_pelatihan) ?></b>
|
|
</span>
|
|
</div>
|
|
</div> <!-- end row -->
|
|
<br>
|
|
<input type="hidden" id="riwayat_kegiatan_id" value="<?php echo $id; ?>">
|
|
|
|
|
|
<div class="row">
|
|
<div class="col-lg-1 m-r-10">
|
|
<button type="button" class="btn btn-default btn-rounded" id="back"><i class="fa fa-arrow-left m-r-5"></i>Back</button>
|
|
</div>
|
|
|
|
<div class="col-lg-3">
|
|
<select class="form-control" id="ceksebagai" style="margin-top:-2px;border:0px;border-radius:0px;border-bottom: 1px solid;">
|
|
<option></option>
|
|
<?php
|
|
$s=pg_query("SELECT DISTINCT p.sebagai_id,s.nama FROM riwayat_peserta p
|
|
INNER JOIN sebagai s ON (s.id=p.sebagai_id)
|
|
WHERE p.riwayat_kegiatan_id='$id'
|
|
ORDER BY p.sebagai_id ASC
|
|
");
|
|
while($r=pg_fetch_array($s)) {
|
|
?>
|
|
<option value="<?php echo $r[0]; ?>"><?php echo $r[1]; ?></option>
|
|
<?php } ?>
|
|
</select>
|
|
</div>
|
|
|
|
<div class="col-lg-1">
|
|
<button type="button" class="btn btn-default btn-rounded" id="print_dh"><i class="glyphicon glyphicon-print m-r-5"></i>Print</button>
|
|
</div>
|
|
<!--
|
|
<div class="col-lg-3">
|
|
<select class="form-control" id="ceksatker" style="margin-top:-2px;border:0px;border-radius:0px;border-bottom: 1px solid;">
|
|
<option></option>
|
|
<?php
|
|
$s=pg_query("SELECT p.satuan_kerja_id,(SELECT s.nama FROM satuan_kerja s WHERE s.id=p.satuan_kerja_id) FROM riwayat_peserta p
|
|
WHERE p.riwayat_kegiatan_id='$id'
|
|
GROUP BY p.satuan_kerja_id");
|
|
while($r=pg_fetch_array($s)) {
|
|
?>
|
|
<option value="<?php echo $r[0]; ?>"><?php echo $r[1]; ?></option>
|
|
<?php } ?>
|
|
</select>
|
|
</div>
|
|
-->
|
|
<!--<div class="col-lg-1">
|
|
<button type="button" class="btn btn-success btn-rounded" id="absen"><i class="fa fa-check m-r-5"></i>Hadir</button>
|
|
</div>-->
|
|
|
|
</div>
|
|
<input type="hidden" id="date1" value="<?php echo $date1; ?>">
|
|
<input type="hidden" id="date2" value="<?php echo $date2; ?>">
|
|
<div id="tabel_vpeserta"></div>
|
|
|
|
</div>
|
|
|
|
|
|
|
|
<script type="text/javascript">
|
|
var riwayat_kegiatan_id=$('#riwayat_kegiatan_id').val();
|
|
$('#tabel_vpeserta').load("app/kehadiran/hadir/tabel.php",{riwayat_kegiatan_id:riwayat_kegiatan_id});
|
|
$('#print_dh').prop('disabled',true);
|
|
|
|
$('#ceksatker').change(function(){
|
|
var s = $('#ceksatker').val();
|
|
var t = $('#ceksebagai').val();
|
|
if (!s) {$('#tabel_vpeserta').load("app/kehadiran/hadir/tabel.php",{riwayat_kegiatan_id:riwayat_kegiatan_id});} else {
|
|
$('#tabel_vpeserta').load("app/kehadiran/hadir/tabel.php",{riwayat_kegiatan_id:riwayat_kegiatan_id,str:s,sbg:t});
|
|
}
|
|
});
|
|
|
|
$('#ceksebagai').change(function(){
|
|
var s = $('#ceksatker').val();
|
|
var t = $('#ceksebagai').val();
|
|
if (!t) {$('#print_dh').prop('disabled',true);$('#tabel_vpeserta').load("app/kehadiran/hadir/tabel.php",{riwayat_kegiatan_id:riwayat_kegiatan_id});} else {
|
|
$('#print_dh').prop('disabled',false);
|
|
$('#tabel_vpeserta').load("app/kehadiran/hadir/tabel.php",{riwayat_kegiatan_id:riwayat_kegiatan_id,str:s,sbg:t});
|
|
}
|
|
});
|
|
|
|
$('#back').click(function(){
|
|
$.post('app/kehadiran/main.php',function(html){$("#main_tag").html(html);});
|
|
});
|
|
|
|
|
|
$('#print_dh').click(function(){
|
|
var riwayat_kegiatan_id=$('#riwayat_kegiatan_id').val();
|
|
var t = $('#ceksebagai').val();
|
|
var w = 1000;
|
|
var h = 800;
|
|
var left = Number((screen.width/2)-(w/2));
|
|
var tops = Number((screen.height/2)-(h/2));
|
|
var listDate = [];
|
|
var startDate =$('#date1').val();
|
|
var endDate = $('#date2').val();
|
|
var dateMove = new Date(startDate);
|
|
var strDate = startDate;
|
|
|
|
if (strDate==endDate) {
|
|
$.post('app/kehadiran/hadir/print_dh.php', {riwayat_kegiatan_id:riwayat_kegiatan_id, strDate:strDate, sebagai:t}, function (result) {
|
|
WinId = window.open('', 'newwin', 'toolbar=no, location=no, directories=no, status=no, menubar=yes, scrollbars=yes, resizable=no, copyhistory=no, width='+w+', height='+h+', top='+tops+', left='+left);
|
|
WinId.document.open();
|
|
WinId.document.write(result);
|
|
WinId.document.close();
|
|
WinId.focus();
|
|
});
|
|
} else {
|
|
while (strDate < endDate) {
|
|
var strDate = dateMove.toISOString().slice(0,10);
|
|
listDate.push(strDate);
|
|
dateMove.setDate(dateMove.getDate()+1);
|
|
$.post('app/kehadiran/hadir/print_dh.php', {riwayat_kegiatan_id:riwayat_kegiatan_id, strDate:strDate, sebagai:t}, function (result) {
|
|
WinId = window.open('', 'newwin', 'toolbar=no, location=no, directories=no, status=no, menubar=yes, scrollbars=yes, resizable=no, copyhistory=no, width='+w+', height='+h+', top='+tops+', left='+left);
|
|
WinId.document.open();
|
|
WinId.document.write(result);
|
|
WinId.document.close();
|
|
WinId.focus();
|
|
});
|
|
};
|
|
}
|
|
|
|
|
|
});
|
|
|
|
</script>
|