78 lines
5.0 KiB
PHP
78 lines
5.0 KiB
PHP
<?php
|
|
include('../koneksi.php');
|
|
$id=$_POST['id'];
|
|
?>
|
|
|
|
|
|
<input type="hidden" id="id_rw_kegiatan" value="<?php echo $id; ?>">
|
|
<script type="text/javascript">$("#tabel_data_peserta_un").DataTable({"stateSave": true,"paging": true,"lengthChange": true,"searching": true,"ordering": false,"info": true,"autoWidth": false});</script>
|
|
<table id="tabel_data_peserta_un" class="table table-striped table-condensed" cellpadding="1" >
|
|
<thead>
|
|
<tr>
|
|
<td><b>Nama Peserta</b></td>
|
|
<td width="195px;"><b>NIP</b></td>
|
|
<td width="20px;"><b>Gol</b></td>
|
|
<td width="20px;"><b>L/P</b></td>
|
|
<td><b>Satuan Kerja</b></td>
|
|
<!--<td align="center"><b>Jab</b></td>-->
|
|
<td><b>Jab Tim</b></td>
|
|
<td width="90px;"><b>Jam</b></td>
|
|
<td align="center" width="30px;"><b>Terima</b></td>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
/* $data = pg_query("SELECT p.nama,p.nipb,p.golongan,p.ruang,p.jenis_kelamin,
|
|
(SELECT s.nama FROM satuan_kerja s WHERE s.id=p.satuan_kerja),
|
|
r.waktu_mulai,r.waktu_selesai,r.st_terima
|
|
FROM riwayat_peserta r
|
|
INNER JOIN data_pegawai p ON (p.id=data_pegawai_id)
|
|
WHERE r.riwayat_kegiatan_id='$id' ORDER BY r.id ASC"); */
|
|
$data = pg_query("SELECT
|
|
COALESCE(NULL,p.nama,l.nama),
|
|
COALESCE(NULL,p.nipb,l.nipb),
|
|
p.golongan,p.ruang,
|
|
COALESCE(NULL,p.jenis_kelamin,l.jenis_kelamin),
|
|
COALESCE(NULL,(SELECT s.nama FROM satuan_kerja s WHERE s.id=p.satuan_kerja),l.instansi),
|
|
t.waktu_mulai,t.waktu_selesai,t.st_terima,t.peserta_luar,t.jabtim
|
|
FROM riwayat_peserta t
|
|
LEFT OUTER JOIN data_pegawai p ON (p.id=t.data_pegawai_id)
|
|
LEFT OUTER JOIN satuan_kerja s ON (s.id=p.satuan_kerja)
|
|
LEFT OUTER JOIN data_pegawai_luar l ON (l.id=t.peserta_luar)
|
|
WHERE t.riwayat_kegiatan_id='$id' ORDER BY t.id 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['golongan']=='-') || ($row['golongan']==''))
|
|
{} else {echo $row['golongan'].'/'.$row['ruang'];}
|
|
?></b></td>
|
|
<td><b><?php echo substr($row[4],0,1); ?></b></td>
|
|
<td><b><?php echo $row[5]; ?></b></td>
|
|
<!--<td><?php echo $row['jabatan']; ?></td>-->
|
|
<td><b><?php echo $row['jabtim']; ?></b></td>
|
|
<td><b><?php echo date('H:i',strtotime($row['waktu_mulai'])).' - '.date('H:i',strtotime($row['waktu_selesai'])); ?></b></td>
|
|
<td align="center" class="kanan">
|
|
<?php
|
|
if ($row['st_terima']=='Terima') {
|
|
?>
|
|
<i class="ion-checkmark-round"></i>
|
|
<?php
|
|
} else {
|
|
?>
|
|
<?php
|
|
}
|
|
?>
|
|
</td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
|
|
<script>
|
|
$('#edit_jam').hide();
|
|
$('#btn_edit_jam').hide();
|
|
</script>
|