176 lines
10 KiB
PHP
176 lines
10 KiB
PHP
<?php
|
|
include('../koneksi.php');
|
|
$satker=$_POST['satker'];
|
|
?>
|
|
<script>var sess_satker = $('#cek_satker').val();</script>
|
|
|
|
<script type="text/javascript">
|
|
$('button[name="edit_arsip"]').popover();
|
|
$("#tabel_data_arsip").DataTable({"stateSave": true,"paging": true,"lengthChange": true,"searching": true,"ordering": false,"info": true,"autoWidth": false});
|
|
</script>
|
|
<table id="tabel_data_arsip" class="table table-striped table-condensed table-bordered" cellpadding="1" style="font-family:Arial;font-size:12px">
|
|
<thead>
|
|
<tr style="color:black;text-align:center">
|
|
<td width="270px;">Nama / Jabatan</td>
|
|
<!--<td>Jabatan</td>-->
|
|
<td width="100px;">Tgl Acara</td>
|
|
<!--<td width="90px;">Jam</td>-->
|
|
<td width="110px;">Ruangan</td>
|
|
<td width="370px;">Acara</td>
|
|
<td width="80px;">Terkirim</td>
|
|
<td align="center" width="40px;">Terima</td>
|
|
<td width="60px;">Doc</td>
|
|
</tr>
|
|
</thead>
|
|
<tbody style="color:black">
|
|
<?php
|
|
$data = pg_query("SELECT DISTINCT w.nama,
|
|
(SELECT j.nama FROM jabatan_pegawai j WHERE j.id=w.jabatan_pegawai_id),
|
|
k.tgl_acara,p.waktu_mulai,p.waktu_selesai,
|
|
(SELECT r.nama FROM data_ruangan r WHERE r.id=k.tempat),
|
|
k.tujuan,p.st_terima,p.id,k.st_batal,k.und_kirim,p.riwayat_kegiatan_id
|
|
FROM riwayat_kegiatan k
|
|
INNER JOIN riwayat_peserta p ON (p.riwayat_kegiatan_id=k.id)
|
|
INNER JOIN data_pegawai w ON (w.id=p.data_pegawai_id)
|
|
WHERE k.st_persiapan='Close'
|
|
AND w.satuan_kerja='$satker'
|
|
ORDER BY k.tgl_acara DESC");
|
|
while($row=pg_fetch_array($data)) {
|
|
|
|
$riwayat_kegiatan_id=$row['riwayat_kegiatan_id'];
|
|
$lm=pg_query("SELECT COUNT(*) FROM lampiran WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id'");
|
|
while($rlm=pg_fetch_array($lm)) {$jlam=$rlm[0];}
|
|
|
|
?>
|
|
<tr
|
|
<?php
|
|
if ($row['st_batal']=='Batal') {
|
|
echo "style='color:#dddddd'";
|
|
} else {
|
|
echo "";
|
|
}
|
|
?>
|
|
>
|
|
<td class="kiri">
|
|
<span style="font-family:InterSB">
|
|
<?php echo $row[0]; ?>
|
|
</span><br>
|
|
<span>
|
|
<?php echo $row[1]; ?>
|
|
</span>
|
|
</td>
|
|
<td><?php echo date('d-m-Y',strtotime($row['tgl_acara'])).'<br>'.
|
|
'<span style="color:red;font-family:InterSB">'.date('H:i',strtotime($row['waktu_mulai'])).' - '.date('H:i',strtotime($row['waktu_selesai'])).'</span>'
|
|
; ?></td>
|
|
<!--<td class="kiri"><?php echo $row[0]; ?></td>
|
|
<td><?php echo $row[1]; ?></td>
|
|
<td><?php echo date('d-m-Y',strtotime($row['tgl_acara'])); ?></td>
|
|
<td><?php echo date('H:i',strtotime($row['waktu_mulai'])).' - '.date('H:i',strtotime($row['waktu_selesai'])); ?></td>-->
|
|
<td><?php echo $row[5]; ?></td>
|
|
<td><?php echo $row['tujuan']; ?></td>
|
|
<td><?php
|
|
if ($row['und_kirim']==NULL) {echo "";} else {
|
|
echo date('d-m-Y H:i',strtotime($row['und_kirim']));
|
|
}
|
|
?></td>
|
|
<td align="center">
|
|
<?php
|
|
if ($row['st_terima']=='Terima') {
|
|
?>
|
|
<i class="ion-checkmark-round"></i>
|
|
<?php
|
|
} else {
|
|
?>
|
|
<?php
|
|
}
|
|
?>
|
|
</td>
|
|
<td class="kanan" align="center">
|
|
<!--<button type="button" name="info_peserta" style="height:22px;"
|
|
class="btn btn-inverse btn-xs info_peserta"
|
|
id="<?php echo $row['id'];?>" data-content="Edit Data" rel="popover" data-placement="bottom" data-trigger="hover">
|
|
<i class="fa fa-user"></i>
|
|
</button>-->
|
|
<button type="button" name="edit_arsip" style="height:22px;" class="btn btn-danger btn-xs edit_arsip" id="<?php echo $row['id'];?>" data-content="Terima Undangan" rel="popover" data-placement="top" data-trigger="hover"
|
|
<?php
|
|
if ($row['st_batal']=='Batal') {
|
|
echo "disabled";
|
|
} else {
|
|
echo "";
|
|
}
|
|
?>
|
|
>
|
|
<i class="fa fa-envelope"></i>
|
|
</button>
|
|
<?php if ($jlam==0) {} else { ?>
|
|
<button type="button" name="lampiran_arsip" style="height:22px;" class="btn btn-teal btn-xs lampiran_arsip" id="<?php echo $row['riwayat_kegiatan_id'];?>" data-content="Dokumen Lampiran Undangan" rel="popover" data-placement="top" data-trigger="hover"
|
|
>
|
|
<i class="fa fa-file"></i>
|
|
</button>
|
|
<?php } ?>
|
|
</td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
|
|
|
|
|
|
<script type="text/javascript">
|
|
|
|
$("#tabel_data_arsip").on('click','.edit_arsip',function(){
|
|
var id = $(this).attr('id');
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/arsip/undangan.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
var key = "terima_undangan";
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/arsip/crud.php",
|
|
data: 'id='+id
|
|
+'&key='+key,
|
|
success: function(data){
|
|
alert('Undangan telah diterima.. Silakan cetak..');
|
|
$('#tabel_arsip').load("app/arsip/tabel.php",{satker:sess_satker});
|
|
var nmf = data;
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/arsip/del_und.php",
|
|
data: 'nmf='+nmf
|
|
+'&id='+id,
|
|
success: function(data){
|
|
}
|
|
});
|
|
|
|
}
|
|
});
|
|
|
|
var ling = 'app/arsip/'+id+'/'+data;
|
|
window.open(ling);
|
|
window.close();
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#tabel_data_arsip").on('click','.lampiran_arsip',function(){
|
|
var id = $(this).attr('id');
|
|
$('#modal_file_inbox').modal('show');
|
|
$('#modal_body_file_inbox').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/arsip/modal_file.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_body_file_inbox').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
|
|
</script>
|
|
|