76 lines
5.0 KiB
PHP
76 lines
5.0 KiB
PHP
<?php
|
|
include('../koneksi.php');
|
|
$id=$_POST['id_rw_kegiatan'];
|
|
?>
|
|
<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-bordered 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 align="center" width="110px;">Terima</td>
|
|
<td align="center">Urut</td>
|
|
</tr>
|
|
</thead>
|
|
<tbody style="color:black">
|
|
<?php
|
|
$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,
|
|
COALESCE(t.penerimaan_undangan,0),t.id,t.tgl_terima
|
|
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 COALESCE(t.penerimaan_undangan,0) 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 align="center"><?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 align="center"><?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>-->
|
|
<td align="center"><?php
|
|
if ($row['tgl_terima']==NULL) {
|
|
if ($row['st_terima']=='Terima') { echo "<i class='ion-checkmark-round'></i>"; } else {}
|
|
} else {
|
|
echo date('d-m-Y H:i',strtotime($row['tgl_terima']));
|
|
}
|
|
?></td>
|
|
<td align="center" class="kanan" id="<?php echo $row['id']; ?>"><?php echo $row[11]; ?></td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
|