105 lines
5.3 KiB
PHP
105 lines
5.3 KiB
PHP
<?php
|
|
include('../koneksi.php');
|
|
$tempdata=$_POST['tempdata'];
|
|
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
|
|
?>
|
|
<style type="text/css">
|
|
input[type=checkbox] {
|
|
transform: scale(1.5);
|
|
}
|
|
|
|
.table > tbody > tr > td {
|
|
vertical-align: middle;
|
|
}
|
|
</style>
|
|
|
|
<input type="hidden" value="<?php echo $riwayat_kegiatan_id; ?>">
|
|
<input type="hidden" id="temp_data" style="width:600px" value="<?php echo $tempdata; ?>">
|
|
<table id="tabel_data_pegawais" class="table table-striped table-condensed table-bordered" cellpadding="1" style="font-family:Arial;font-size:12px;color:black">
|
|
<thead>
|
|
<tr><center>
|
|
<td align="center">
|
|
<input type="checkbox" name="checkAll" id="checkAll" class="checkbox cb_data" aria-label="Single checkbox Two" >
|
|
</td>
|
|
<td align="center">Nama</td>
|
|
<td align="center">NIP</td>
|
|
<td align="center">Gol</td>
|
|
<td align="center">Sex</td>
|
|
<td align="center">Satker</td>
|
|
<td align="center">Jab</td></center>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
/*
|
|
$data = pg_query("SELECT p.*,s.nama,j.nama,r.kehadiran
|
|
FROM data_pegawai p
|
|
INNER JOIN satuan_kerja s ON (s.id=p.satuan_kerja)
|
|
INNER JOIN jabatan_pegawai j ON (j.id=p.jabatan_pegawai_id)
|
|
INNER JOIN riwayat_peserta r ON (p.id=r.data_pegawai_id)
|
|
INNER JOIN riwayat_kegiatan k ON (k.id=r.riwayat_kegiatan_id)
|
|
WHERE p.id IS NOT NULL AND p.aktif='t'
|
|
AND k.id='$riwayat_kegiatan_id'
|
|
ORDER BY r.id ASC");
|
|
*/
|
|
$data = pg_query("SELECT p.id,
|
|
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),
|
|
COALESCE(NULL,t.jabtim,l.jabatan) as jabtim,t.kehadiran
|
|
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=$riwayat_kegiatan_id ORDER BY COALESCE(t.penerimaan_undangan,0) ASC");
|
|
while($row=pg_fetch_array($data)) {
|
|
?>
|
|
<tr>
|
|
<td align="center" class="kiri">
|
|
<input type="checkbox" id='checkDelete' name='checkDelete[]' class="checkbox cb_data" value="<?php echo $row['id']; ?>" aria-label="Single checkbox Two" <?php if($row['kehadiran']=='Hadir') {echo "checked";} else {} ?>>
|
|
</td>
|
|
<td style="font-family:InterSB"><?php echo $row[1]; ?></td>
|
|
<td><?php echo $row[2]; ?></td>
|
|
<td><?php if ($row[3]=='-') {echo "-";} else {echo $row[3].'/'.$row[4];} ?></td>
|
|
<td align="center"><?php if ($row[5]=='Laki-laki') {echo "L";} else {echo "P";} ?></td>
|
|
<td><?php echo $row[6]; ?></td>
|
|
<td class="kanan"><?php echo $row[7]; ?></td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
|
|
<script type="text/javascript">
|
|
function getSelectedVal(){
|
|
var ID={};
|
|
ID.values=[];
|
|
$("input#checkDelete").each(function(){
|
|
var $this = $(this);
|
|
if($this.is(":checked")){
|
|
ID.values.push($this.attr("value"));
|
|
}
|
|
$("#temp_data").val(ID.values);
|
|
// $("#awal").val(ID.values);
|
|
// $("#awal").trigger('input');
|
|
});
|
|
}
|
|
|
|
|
|
|
|
|
|
$("#checkAll").click(function () {
|
|
$('input:checkbox').not(this).prop('checked', this.checked);
|
|
});
|
|
|
|
$("input[type='checkbox']").change(function() {
|
|
getSelectedVal();
|
|
});
|
|
</script>
|
|
|
|
|
|
|