416 lines
23 KiB
PHP
416 lines
23 KiB
PHP
<?php
|
|
include('../koneksi.php');
|
|
$thn_skrg=date('Y');
|
|
$bln2=$_POST['bln2'];
|
|
$thn2=$_POST['thn2'];
|
|
$r1=strtolower($_POST['r1']);
|
|
$p1=strtolower($_POST['p1']);
|
|
$s1=strtolower($_POST['s1']);
|
|
$na1=strtolower($_POST['na1']);
|
|
$nb1=strtolower($_POST['nb1']);
|
|
?>
|
|
|
|
<script type="text/javascript">
|
|
$('button[name="edit_artu"]').popover();
|
|
$('button[name="pr_und"]').popover();
|
|
$('button[name="info_peserta"]').popover();
|
|
$('button[name="tambah_peserta"]').popover();
|
|
$('button[name="tambah_peserta_luar"]').popover();
|
|
$('button[name="batal_artu"]').popover();
|
|
$('button[name="ars_notulen"]').popover();
|
|
$('button[name="ars_absensi"]').popover();
|
|
$("#tabel_data_artu").DataTable({"stateSave": true,"paging": true,"lengthChange": true,"searching": true,"ordering": false,"info": true,"autoWidth": false});
|
|
</script>
|
|
<table id="tabel_data_artu" class="table table-striped table-condensed table-bordered" cellpadding="1" style="font-family:Arial;font-size:12px">
|
|
<thead>
|
|
<tr style="text-align:center">
|
|
<td width="120px;">Ruangan</td>
|
|
<td width="100px;">Tgl Acara</td>
|
|
<!--<td width="90px;">Waktu</td>-->
|
|
<td>Acara</td>
|
|
<td>Penanggungjawab</td>
|
|
<td width="50px;">Status</td>
|
|
<td width="170px;">No Undangan</td>
|
|
<td width="20px;" style="font-family:InterSB;color:black;">U</td>
|
|
<td width="20px;" style="font-family:InterSB;color:black;">M</td>
|
|
<td width="20px;" style="font-family:InterSB;color:black;">A</td>
|
|
<td width="20px;" style="font-family:InterSB;color:black;">N</td>
|
|
<td width="160px;">Tools</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,COUNT(l.file),n.riwayat_kegiatan_id,
|
|
COALESCE(n.riwayat_kegiatan_id,(SELECT COUNT(*) FROM uman u WHERE u.riwayat_kegiatan_id=k.id AND u.jenis='notulen')) as jml_file_notulen,
|
|
(SELECT COUNT(*) FROM uman u WHERE u.riwayat_kegiatan_id=k.id AND u.jenis='undangan') as jml_file_undangan,
|
|
(SELECT COUNT(*) FROM uman u WHERE u.riwayat_kegiatan_id=k.id AND u.jenis='materi') as jml_file_materi,
|
|
(SELECT COUNT(*) FROM uman u WHERE u.riwayat_kegiatan_id=k.id AND u.jenis='absensi') as jml_file_absensi
|
|
FROM riwayat_kegiatan k
|
|
LEFT OUTER JOIN lampiran l ON (k.id=l.riwayat_kegiatan_id)
|
|
LEFT OUTER JOIN riwayat_notulen n ON (k.id=n.riwayat_kegiatan_id)
|
|
WHERE (k.st_persiapan='Close' AND k.st_persiapan <> 'PJ')
|
|
".($thn2 == '' ? "" : "AND EXTRACT(YEAR FROM DATE(k.tgl_acara))='$thn2'")."
|
|
".($bln2 == '' ? "" : "AND EXTRACT(MONTH FROM DATE(k.tgl_acara))='$bln2'")."
|
|
".($r1 == null ? "" : "AND lower(k.tujuan) LIKE '%$r1%'")."
|
|
".($p1 == null ? "" : "AND lower((SELECT s.nama FROM satuan_kerja s WHERE s.id=k.penanggungjawab)) LIKE '%$p1%'")."
|
|
".($s1 == null ? "" : "AND lower(k.no_undangan) LIKE '%$s1%'")."
|
|
".($na1 == null ? "" : "AND n.riwayat_kegiatan_id IS NOT NULL")."
|
|
".($nb1 == null ? "" : "AND n.riwayat_kegiatan_id IS NULL")."
|
|
GROUP BY
|
|
(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,n.riwayat_kegiatan_id
|
|
ORDER BY 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">'.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"><?php if (($row['no_undangan']!=null) && ($row['st_persiapan']=='Pending')) {echo 'Siap kirim';} else {echo $row['st_persiapan'];} ?></td>
|
|
<td align="center">
|
|
<?php
|
|
if ($row['no_undangan']==NULL) {
|
|
echo '';
|
|
} else {
|
|
echo '000.1 / '.$row['no_undangan'].' / 102.7 / '.date('Y',strtotime($row['tgl_acara']));
|
|
}
|
|
?>
|
|
</td>
|
|
<td style="color:red" align="center">
|
|
<?php if ($row['jml_file_undangan']==0) {} else {echo "<i class='fa fa-check'></i>";} ?>
|
|
</td>
|
|
<td style="color:red" align="center">
|
|
<?php if ($row['jml_file_materi']==0) {} else {echo "<i class='fa fa-check'></i>";} ?>
|
|
</td>
|
|
<td style="color:red" align="center">
|
|
<?php if ($row['jml_file_absensi']==0) {} else {echo "<i class='fa fa-check'></i>";} ?>
|
|
</td>
|
|
<td style="color:red" align="center">
|
|
<?php if ($row['jml_file_notulen']==0) {} else {echo "<i class='fa fa-check'></i>";} ?>
|
|
</td>
|
|
<td class="kanan" align="center">
|
|
<span>
|
|
<button type="button" name="edit_artu" style="height:22px;" class="btn btn-default btn-xs edit_artu" id="<?php echo $row['id'];?>" data-content="Cetak Undangan" rel="popover" data-placement="top" data-trigger="hover"
|
|
<?php
|
|
if ($row['st_batal']=='Batal') {
|
|
echo "disabled";
|
|
} else {
|
|
echo "";
|
|
}
|
|
?>
|
|
>
|
|
<i class="glyphicon glyphicon-print"></i>
|
|
</button>
|
|
<button type="button" name="ars_notulen" style="height:22px;" class="btn btn-default btn-xs ars_notulen" id="<?php echo $row['id'];?>" data-content="Notulen" rel="popover" data-placement="top" data-trigger="hover"
|
|
<?php
|
|
if ($row['st_batal']=='Batal') {
|
|
echo "disabled";
|
|
} else {
|
|
echo "";
|
|
}
|
|
?>
|
|
>
|
|
<i class="fa fa-file-text"></i>
|
|
</button>
|
|
<button type="button" name="ars_absensi" style="height:22px;" class="btn btn-default btn-xs ars_absensi" id="<?php echo $row['id'];?>" data-content="Upload Absensi" rel="popover" data-placement="top" data-trigger="hover"
|
|
<?php
|
|
if ($row['st_batal']=='Batal') {
|
|
echo "disabled";
|
|
} else {
|
|
echo "";
|
|
}
|
|
?>
|
|
>
|
|
<i class="fa fa-arrow-up"></i>
|
|
</button>
|
|
<button type="button" name="info_peserta" style="height:22px;"
|
|
class="btn btn-inverse btn-xs info_peserta"
|
|
id="<?php echo $row['id'];?>" data-content="List Peserta" rel="popover" data-placement="top" data-trigger="hover"
|
|
<?php
|
|
if ($row['st_batal']=='Batal') {
|
|
echo "disabled";
|
|
} else {
|
|
echo "";
|
|
}
|
|
?>
|
|
>
|
|
<i class="fa fa-user"></i>
|
|
</button>
|
|
<!--
|
|
<button type="button" name="tambah_peserta" style="height:22px;"
|
|
class="btn btn-primary btn-xs tambah_peserta"
|
|
id="<?php echo $row['id'];?>" data-content="Peserta Dalam" rel="popover" data-placement="top" data-trigger="hover"
|
|
<?php
|
|
if ($row['st_batal']=='Batal') {
|
|
echo "disabled";
|
|
} else {
|
|
echo "";
|
|
}
|
|
?>
|
|
>
|
|
<i class="fa fa-plus"></i>
|
|
</button>
|
|
<button type="button" name="tambah_peserta_luar" style="height:22px;"
|
|
class="btn btn-default btn-xs tambah_peserta_luar"
|
|
id="<?php echo $row['id'];?>" data-content="Peserta Luar" rel="popover" data-placement="top" data-trigger="hover"
|
|
<?php
|
|
if ($row['st_batal']=='Batal') {
|
|
echo "disabled";
|
|
} else {
|
|
echo "";
|
|
}
|
|
?>
|
|
>
|
|
<i class="fa fa-plus"></i>
|
|
</button>
|
|
|
|
<button type="button" name="pr_und" style="height:22px;" class="btn btn-purple btn-xs pr_und" id="<?php echo $row['id'];?>" data-content="Print Undangan Peserta Luar" 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>
|
|
-->
|
|
<button type="button" name="batal_artu" style="height:22px;" class="btn btn-danger btn-xs batal_artu" id="<?php echo $row['id'];?>" data-content="Batal" rel="popover" data-placement="top" data-trigger="hover"
|
|
<?php
|
|
if ($row['st_batal']=='Batal') {
|
|
echo "disabled";
|
|
} else {
|
|
echo "";
|
|
}
|
|
?>
|
|
>
|
|
<i class="fa fa-remove"></i>
|
|
</button>
|
|
</span>
|
|
<?php if ($row[10]==0) {} else { ?>
|
|
<br><br><span><button type="button" name="lampiran_undtu" style="height:22px;font-family:InterSB;color:red"class="btn btn-default btn-xs lampiran_undtu" id="<?php echo $row['id'];?>" >Dokumen Lampiran Undangan
|
|
</button></span>
|
|
<?php } ?>
|
|
</td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
|
|
|
|
|
|
<script type="text/javascript">
|
|
|
|
|
|
|
|
var cek_jenis = $('#cek_jenis').val();
|
|
if (cek_jenis=='Sie Kegiatan') {
|
|
$('button[name="edit_artu"]').hide();
|
|
$('button[name="batal_artu"]').hide();
|
|
} else {
|
|
$('button[name="batal_artu"]').show();
|
|
$('button[name="edit_artu"]').show();
|
|
}
|
|
|
|
$("#tabel_data_artu").on('click','.edit_artu',function(){
|
|
var id = $(this).attr('id');
|
|
$('#modal_artu').modal('show');
|
|
$('#modal_body_artu').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/arsiptu/modal.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_body_artu').html(data);
|
|
$('#nama').first().focus().selected();
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#tabel_data_artu").on('click','.tambah_peserta',function(){
|
|
var id = $(this).attr('id');
|
|
$('#modal_tambah').modal('show');
|
|
$('#modal_body_tambah').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/arsiptu/modal_tambah.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_body_tambah').html(data);
|
|
$('#peserta_nama').first().focus().selected();
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#tabel_data_artu").on('click','.tambah_peserta_luar',function(){
|
|
var id = $(this).attr('id');
|
|
$('#modal_tambah_luar').modal('show');
|
|
$('#modal_body_tambah_luar').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/arsiptu/modal_tambah_luar.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_body_tambah_luar').html(data);
|
|
$('#peserta_nama_l').first().focus().selected();
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#tabel_data_artu").on('click','.pr_und',function(){
|
|
var id = $(this).attr('id');
|
|
$('#modal_pr_und').modal('show');
|
|
$('#modal_body_pr_und').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/arsiptu/modal_prund.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_body_pr_und').html(data);
|
|
$('#peserta_nama_u').first().focus().selected();
|
|
}
|
|
});
|
|
});
|
|
|
|
|
|
$("#tabel_data_artu").on('click','.info_peserta',function(){
|
|
var id = $(this).attr('id');
|
|
$('#modal_artu_peserta').modal('show');
|
|
$('#modal_body_artu_peserta').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/arsiptu/modal_peserta.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_body_artu_peserta').html(data);
|
|
var key = "cek_jam";
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/arsiptu/crud.php",
|
|
data: 'id='+id
|
|
+'&key='+key,
|
|
success: function(data){
|
|
$('#jam_main').html(data);
|
|
}
|
|
});
|
|
}
|
|
});
|
|
//$.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);});
|
|
});
|
|
|
|
$("#tabel_data_artu").on('click','.batal_artu',function(){
|
|
var x = confirm("Anda yakin ingin membatalkan ?");
|
|
if (x) {
|
|
var key = "batal_artu";
|
|
var id = $(this).attr('id');
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/arsiptu/crud.php",
|
|
data: 'id='+id
|
|
+'&key='+key,
|
|
success: function(data){
|
|
$('#tabel_artu').load("app/arsiptu/tabel.php");
|
|
}
|
|
});
|
|
} else {}
|
|
});
|
|
|
|
|
|
|
|
$("#tabel_data_artu").on('click','.ars_notulen',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
|
|
+'&cek_jenis='+cek_jenis
|
|
+'&satker='+satker,
|
|
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);
|
|
}
|
|
});
|
|
}
|
|
});
|
|
});
|
|
|
|
|
|
$('#simpan_editnotulen').click(function(){
|
|
var satker = $('#satker').val();
|
|
var cek_jenis = $('#cek_jenis').val();
|
|
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});
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#tabel_data_artu").on('click','.ars_absensi',function(){
|
|
var id = $(this).attr('id');
|
|
var key = 'absensi';
|
|
$('#modal_file').modal('show');
|
|
$('#modal_body_file').html("");
|
|
$('#judul_modal_file').html('Upload Absensi Rapat');
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/notulen/upd_file.php",
|
|
data: 'riwayat_kegiatan_id='+id
|
|
+'&key='+key,
|
|
success: function(data){
|
|
$('#modal_body_file').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
</script>
|
|
|