73 lines
4.8 KiB
PHP
73 lines
4.8 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 style="text-align:center">
|
|
<td>Nama Peserta</td>
|
|
<td width="195px;">NIP</td>
|
|
<td width="20px;">Gol</td>
|
|
<td width="20px;">L/P</td>
|
|
<td>Satuan Kerja</td>
|
|
<!--<td align="center">Jab</td>-->
|
|
<td>Jab Tim</td>
|
|
<td width="90px;">Jam</td>
|
|
<td width="30px;">Terima</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"><?php echo $row[0]; ?></td>
|
|
<td><?php echo $row[1]; ?></td>
|
|
<td><?php if (($row['golongan']=='-') || ($row['golongan']==''))
|
|
{} else {echo $row['golongan'].'/'.$row['ruang'];}
|
|
?></td>
|
|
<td><?php echo substr($row[4],0,1); ?></td>
|
|
<td><?php echo $row[5]; ?></td>
|
|
<!--<td><?php echo $row['jabatan']; ?></td>-->
|
|
<td><?php echo $row['jabtim']; ?></td>
|
|
<td><?php echo date('H:i',strtotime($row['waktu_mulai'])).' - '.date('H:i',strtotime($row['waktu_selesai'])); ?></td>
|
|
<td align="center">
|
|
<?php
|
|
if ($row['st_terima']=='Terima') {
|
|
?>
|
|
<i class="ion-checkmark-round"></i>
|
|
<?php
|
|
} else {
|
|
?>
|
|
<?php
|
|
}
|
|
?>
|
|
</td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|