189 lines
9.3 KiB
PHP
189 lines
9.3 KiB
PHP
<?php
|
|
include('../koneksi.php');
|
|
$satker=$_POST['satker'];
|
|
?>
|
|
|
|
<input type="hidden" id="satker" value="<?php echo $satker; ?>">
|
|
<script type="text/javascript">$("#tabel_data_hasil").DataTable({"stateSave": true,"paging": true,"lengthChange": true,"searching": true,"ordering": false,"info": true,"autoWidth": false});</script>
|
|
<table id="tabel_data_hasil" 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="110px;">Ruangan</td>
|
|
<td width="110px;">Tgl Acara</td>
|
|
<!--<td width="90px;">Waktu</td>-->
|
|
<td>Acara</td>
|
|
<td>Perencana Rapat</td>
|
|
<td width="20px;">Lihat</td>
|
|
<td width="20px;">Status</td>
|
|
</tr>
|
|
</thead>
|
|
<tbody style="color:black">
|
|
<?php
|
|
/* $data = pg_query("SELECT DISTINCT
|
|
(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=penanggungjawab),
|
|
k.st_batal,
|
|
(SELECT d.satuan_kerja FROM data_pegawai d WHERE d.id=p.data_pegawai_id)
|
|
FROM riwayat_kegiatan k
|
|
INNER JOIN riwayat_peserta p ON (k.id=p.riwayat_kegiatan_id)
|
|
WHERE k.st_persiapan='Close'
|
|
AND
|
|
(SELECT d.satuan_kerja FROM data_pegawai d WHERE d.id=p.data_pegawai_id)='$satker'
|
|
ORDER BY k.tgl_acara DESC"); */
|
|
$data = pg_query("SELECT
|
|
r.nama,
|
|
k.tgl_acara,k.waktu_mulai,k.waktu_selesai,k.tujuan,k.st_persiapan,k.no_undangan,k.id,
|
|
h1.nama,
|
|
k.st_batal,
|
|
h.id,p.st_hadir
|
|
FROM riwayat_kegiatan k
|
|
INNER JOIN riwayat_peserta p ON (k.id=p.riwayat_kegiatan_id)
|
|
INNER JOIN data_pegawai g ON (g.id=p.data_pegawai_id)
|
|
LEFT OUTER JOIN satuan_kerja h ON (h.id=g.satuan_kerja)
|
|
LEFT OUTER JOIN satuan_kerja h1 ON (h1.id=k.penanggungjawab)
|
|
LEFT OUTER JOIN data_ruangan r ON (r.id=k.tempat)
|
|
WHERE k.st_persiapan='Close'
|
|
AND
|
|
h.id='$satker'
|
|
GROUP BY
|
|
r.nama,
|
|
k.tgl_acara,k.waktu_mulai,k.waktu_selesai,k.tujuan,k.st_persiapan,k.no_undangan,k.id,
|
|
h1.nama,
|
|
k.st_batal,
|
|
h.id,p.st_hadir
|
|
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 $row[0]; ?></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><?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['tujuan']; ?></td>
|
|
<td><?php echo $row[8]; ?></td>
|
|
<td align="center">
|
|
<button type="button" name="edit_hasil" style="height:22px;" class="btn btn-inverse btn-xs edit_hasil" id="<?php echo $row[7];?>" data-content="Rincian Hasil Rapat" rel="popover" data-placement="top" data-trigger="hover"
|
|
<?php
|
|
if ($row['st_batal']=='Batal') {
|
|
echo "disabled";
|
|
} else {
|
|
echo "";
|
|
}
|
|
?>
|
|
>
|
|
<i class="fa fa-info-circle"></i>
|
|
</button>
|
|
</td>
|
|
<td class="kanan" align="center"><?php if ($row['st_hadir']=='Baca') {echo '<i class="fa fa-eye"></i>';} else {} ?></td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
|
|
|
|
|
|
|
|
|
|
<script type="text/javascript">
|
|
var satker = $('#satker').val();
|
|
var cek_jenis = $('#cek_jenis').val();
|
|
$('button[name="edit_hasil"]').popover();
|
|
|
|
$('#keluar_editnotulen').click(function(){
|
|
//alert('data hasil rapat ter-edit..');
|
|
// var id = $('#riwayat_kegiatan_idcc').val();
|
|
// $("#tabel_data_hasil .edit_hasil").trigger('click');
|
|
});
|
|
|
|
$("#tabel_data_hasil").on('click','.edit_hasil',function(){
|
|
var id = $(this).attr('id');
|
|
var satker = $('#satker').val();
|
|
var cek_jenis = $('#cek_jenis').val();
|
|
$('#modal_hasil').modal('show');
|
|
$('#modal_body_hasil').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/hasil/modal.php",
|
|
data: 'id='+id
|
|
+'&satker='+satker
|
|
+'&cek_jenis='+cek_jenis,
|
|
success: function(data){
|
|
$('#modal_body_hasil').html(data);
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/hasil/status.php",
|
|
data: 'id='+id
|
|
+'&satker='+satker,
|
|
success: function(data) {
|
|
$('#fotnot').html(data);
|
|
}
|
|
});
|
|
|
|
var key = "Baca";
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/hasil/crud.php",
|
|
data: 'id='+id
|
|
+'&satker='+satker
|
|
+'&key='+key,
|
|
success: function(data){
|
|
$.ajax({
|
|
method:'get',
|
|
url:'app/notif/hasil_notif.php',
|
|
success:function(data_notif_hasil){
|
|
if(data_notif_hasil != ""){
|
|
$('#hasil').load('app/notif/hasil_slide.php',{satker:sess_satker});
|
|
}
|
|
}
|
|
});
|
|
}
|
|
});
|
|
}
|
|
});
|
|
});
|
|
|
|
|
|
$('#simpan_editnotulen').click(function(){
|
|
var pembahasan = $('#pembahasan').val();
|
|
var tindak_lanjut = $('#tindak_lanjut').val();
|
|
var riwayat_kegiatan_id = $('#riwayat_kegiatan_idcc').val();
|
|
var id = $('#id').val();
|
|
var key = 'simpan_dok_notulen';
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/notulen/crud.php",
|
|
data: 'riwayat_kegiatan_id='+riwayat_kegiatan_id
|
|
+'&pembahasan='+pembahasan
|
|
+'&tindak_lanjut='+tindak_lanjut
|
|
+'&id='+id
|
|
+'&key='+key,
|
|
success: function(data){
|
|
alert('Notulen tersimpan..');
|
|
$('#modal_editnotulen').modal('hide');
|
|
$('body').removeClass('modal-open');
|
|
$('.modal-backdrop').remove();
|
|
$('#tabel_notalen').load("app/hasil/tabel_notalen.php",{satker:satker,riwayat_kegiatan_id:riwayat_kegiatan_id,cek_jenis:cek_jenis});
|
|
}
|
|
});
|
|
});
|
|
|
|
//$.post('app/peserta/main.php',{id : id, tujuan_rapat : tujuan_rapat, nm_ruangan : nm_ruangan, tgl_kegiatan : tgl_kegiatan, jam : jam, st_persiapan : st_persiapan},function(html){$("#main_tag").html(html);});
|
|
|
|
|
|
|
|
</script>
|
|
|