116 lines
6.1 KiB
PHP
116 lines
6.1 KiB
PHP
<?php
|
|
include('../koneksi.php');
|
|
$thn_skrg=date('Y');
|
|
$bln2=$_POST['bln2'];
|
|
$thn2=$_POST['thn2'];
|
|
$status_fl=$_POST['status_fl'];
|
|
?>
|
|
|
|
<script type="text/javascript">$("#tabel_data_undtu").DataTable({"stateSave": true,"paging": true,"lengthChange": true,"searching": true,"ordering": false,"info": true,"autoWidth": false});</script>
|
|
<table id="tabel_data_undtu" class="table table-striped table-bordered table-condensed" cellpadding="1" style="font-family:Arial;font-size:12px">
|
|
<thead>
|
|
<tr style="text-align:center;">
|
|
|
|
<td width="100px;">Tgl Acara</td>
|
|
<td>Penanggungjawab / Kegiatan</td>
|
|
<td width="120px;">Ruangan</td>
|
|
<td width="170px;">No Undangan</td>
|
|
<td width="80px;">Status</td>
|
|
<td width="80px;">Peserta</td>
|
|
<!--<td width="190px;">Tools</td>-->
|
|
<!--<td width="80px;">Kirim<i class="mdi mdi-account-multiple m-l-5"></i></td>-->
|
|
</tr>
|
|
</thead>
|
|
<tbody style="color:black">
|
|
<?php
|
|
$data = pg_query("SELECT (SELECT r.nama FROM data_ruangan r WHERE r.id=k.tempat),
|
|
k.tgl_acara,k.waktu_mulai,k.waktu_selesai,k.tujuan,k.st_persiapan,
|
|
k.no_undangan,k.id,
|
|
(SELECT s.nama FROM satuan_kerja s WHERE s.id=k.penanggungjawab),
|
|
k.st_batal,p.tanggal_kirim,
|
|
(SELECT COUNT(*) FROM riwayat_peserta ps WHERE ps.riwayat_kegiatan_id=k.id)
|
|
FROM riwayat_kegiatan k
|
|
LEFT OUTER JOIN kirim_permintaan p ON (k.id=p.riwayat_kegiatan_id)
|
|
WHERE k.id IS NOT NULL
|
|
".($thn2 == '' ? "" : "AND EXTRACT(YEAR FROM DATE(k.tgl_acara))='$thn2'")."
|
|
".($bln2 == '0' ? "" : "AND EXTRACT(MONTH FROM DATE(k.tgl_acara))='$bln2'")."
|
|
".($status_fl == '' ? "AND k.st_persiapan IN ('Pending','Ready','Close')" : "AND k.st_persiapan='$status_fl'")."
|
|
ORDER BY k.tgl_acara DESC");
|
|
while($row=pg_fetch_array($data)) {
|
|
?>
|
|
<tr
|
|
<?php
|
|
if ($row['st_batal']=='Batal') {
|
|
echo "style='color:#dddddd'";
|
|
} else {
|
|
echo "";
|
|
}
|
|
?>
|
|
>
|
|
|
|
<td class="kiri"><?php echo date('d-m-Y',strtotime($row['tgl_acara'])).'<br>'.
|
|
'<span style="color:red;">'.date('H:i',strtotime($row['waktu_mulai'])).' - '.date('H:i',strtotime($row['waktu_selesai'])).'</span>'
|
|
; ?></td>
|
|
<td>
|
|
<span style="font-family:InterSB">
|
|
<?php echo $row[8]; ?>
|
|
</span><br>
|
|
<span>
|
|
<?php echo $row['tujuan']; ?>
|
|
</span>
|
|
</td>
|
|
<td><?php echo $row[0]; ?></td>
|
|
<td align="center">
|
|
<?php
|
|
if ($row['no_undangan']==NULL) {
|
|
echo '';
|
|
} else {
|
|
echo '005 / '.$row['no_undangan'].' / 102.7 / '.date('Y',strtotime($row['tgl_acara']));
|
|
}
|
|
?>
|
|
</td>
|
|
<td align="center">
|
|
<?php
|
|
if ($row['st_persiapan']=='Pending') {
|
|
echo 'PROSES';
|
|
} else
|
|
if ($row['st_persiapan']=='Ready') {
|
|
echo 'READY';
|
|
} else
|
|
if ($row['st_persiapan']=='Close') {
|
|
echo 'ARSIP';
|
|
}
|
|
?>
|
|
</td>
|
|
|
|
<td class="kanan" align="center">
|
|
<button class="btn btn-block btn-xs pes_xx" style="font-family:Arial;font-size:12px;;" id="<?php echo $row['id'];?>">
|
|
<?php if ($row[11]=='0') {echo '-';} else {echo $row[11];} ?>
|
|
</button>
|
|
</td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
|
|
|
|
|
|
<script type="text/javascript">
|
|
$("#tabel_data_undtu").on('click','.pes_xx',function(){
|
|
var id = $(this).attr('id');
|
|
$('#modal_undtu_peserta').modal('show');
|
|
$('#modal_body_undtu_peserta').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/laporan/modal_peserta.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_body_undtu_peserta').html(data);
|
|
}
|
|
});
|
|
});
|
|
</script>
|
|
|