60 lines
3.5 KiB
PHP
60 lines
3.5 KiB
PHP
<?php
|
|
include('../../koneksi.php');
|
|
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
|
|
$str=$_POST['str'];
|
|
$sbg=$_POST['sbg'];
|
|
?>
|
|
|
|
<script type="text/javascript">$("#tabel_data_vpeserta").DataTable({"stateSave": true,"paging": false,"lengthChange": false,"searching": false,"ordering": false,"info": false,"autoWidth": false});</script>
|
|
<br>
|
|
<input type="hidden" value="<?php echo $riwayat_kegiatan_id?>" id="riwayat_kegiatan_id">
|
|
<input type="hidden" value="<?php echo $str?>" id="str">
|
|
<input type="hidden" value="<?php echo $sbg?>" id="sbg">
|
|
<table id="tabel_data_vpeserta" class="table table-striped table-condensed" cellpadding="1" >
|
|
<thead>
|
|
<tr>
|
|
<td><b>Nama Peserta</b></td>
|
|
<td><b>NIP</b></td>
|
|
<td><b>Gol</b></td>
|
|
<td><b>Satuan Kerja</b></td>
|
|
<td><b>Sebagai</b></td>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
$data = pg_query("SELECT
|
|
p.nama,
|
|
p.nipb,
|
|
p.golongan,
|
|
p.ruang,
|
|
(SELECT s.nama FROM satuan_kerja s WHERE s.id=t.satuan_kerja_id),
|
|
(SELECT b.nama FROM sebagai b WHERE b.id=t.sebagai_id),
|
|
t.id
|
|
FROM riwayat_peserta t
|
|
INNER JOIN data_pegawai p ON (p.id=t.data_pegawai_id)
|
|
WHERE t.riwayat_kegiatan_id='$riwayat_kegiatan_id'
|
|
".($sbg == null ? "" : "AND t.sebagai_id='$sbg'")."
|
|
".($str == null ? "" : "AND p.satuan_kerja='$str'")."
|
|
ORDER BY (SELECT s.nama FROM satuan_kerja s WHERE s.id=t.satuan_kerja_id) ASC, p.nama ASC");
|
|
while($row=pg_fetch_array($data)) {
|
|
?>
|
|
<tr>
|
|
<td class="kiri"><b><?php echo $row[0]; ?></b></td>
|
|
<td><b><?php echo $row[1]; ?></b></td>
|
|
<td><b><?php if ($row[2]=='-') {echo "-";} else {echo $row[2].'/'.$row[3];} ?></b></td>
|
|
<td><b><?php echo $row[4]; ?></b></td>
|
|
<td class="kanan"><b><?php echo $row[5]; ?></b></td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
|
|
|
|
|
|
<script type="text/javascript">
|
|
$('button[name="rw_pelatihan"]').popover();
|
|
</script>
|
|
|