384 lines
15 KiB
PHP
384 lines
15 KiB
PHP
<script src="assets/vendor/sweetalert2/sweetalert2.all.min.js"></script>
|
|
<style>
|
|
.modal-backdrop {
|
|
visibility: hidden !important;
|
|
}
|
|
|
|
.modal.in {
|
|
background-color: rgba(0, 0, 0, 0.5);
|
|
}
|
|
</style>
|
|
<?php
|
|
$bulan = array(
|
|
'01' => 'Januari',
|
|
'02' => 'Februari',
|
|
'03' => 'Maret',
|
|
'04' => 'April',
|
|
'05' => 'Mei',
|
|
'06' => 'Juni',
|
|
'07' => 'Juli',
|
|
'08' => 'Agustus',
|
|
'09' => 'September',
|
|
'10' => 'Oktober',
|
|
'11' => 'Nopember',
|
|
'12' => 'Desember',
|
|
);
|
|
|
|
$dayList = array(
|
|
'Sun' => 'Minggu',
|
|
'Mon' => 'Senin',
|
|
'Tue' => 'Selasa',
|
|
'Wed' => 'Rabu',
|
|
'Thu' => 'Kamis',
|
|
'Fri' => 'Jumat',
|
|
'Sat' => 'Sabtu'
|
|
);
|
|
?>
|
|
|
|
<?php
|
|
include('../koneksi.php');
|
|
$id = $_POST['id'];
|
|
$kirimid = $_POST['kirimid'];
|
|
$d = pg_query($koneksi, "SELECT tgl_surat_keluar,satuan_kerja_id FROM surat WHERE id=$id");
|
|
while ($r = pg_fetch_array($d)) {
|
|
$tgl_surat_keluar = $r['tgl_surat_keluar'];
|
|
$satker_pemilik_surat = $r['satuan_kerja_id'];
|
|
}
|
|
|
|
$perihal = $_POST['perihal'];
|
|
$cek_satker = $_POST['cek_satker'];
|
|
$key = $_POST['key'];
|
|
$hari_surat_keluar = $dayList[date('D', strtotime($tgl_surat_keluar))];
|
|
if (($tgl_surat_keluar == null) || ($tgl_surat_keluar == '')) {
|
|
$tgl_surat_keluar = '';
|
|
} else {
|
|
$tgl_surat_keluar1 = date('d', strtotime($tgl_surat_keluar)) . ' ' . $bulan[date('m', strtotime($tgl_surat_keluar))] . ' ' . date('Y', strtotime($tgl_surat_keluar)) . ' ' . date('H:i', strtotime($tgl_surat_keluar));
|
|
}
|
|
|
|
$jb = pg_query($koneksi, "SELECT j.id,j.nama
|
|
FROM data_user k
|
|
INNER JOIN jabatan_pegawai j ON (j.id=k.jabatan_pegawai_id)
|
|
INNER JOIN satuan_kerja s ON (s.id=k.satuan_kerja_id)
|
|
WHERE s.id=$cek_satker");
|
|
while ($rjb = pg_fetch_array($jb)) {
|
|
$jabatan_pegawai_id = $rjb[0];
|
|
}
|
|
|
|
$jb1 = pg_query($koneksi, "SELECT j.id,j.nama
|
|
FROM data_user k
|
|
INNER JOIN jabatan_pegawai j ON (j.id=k.jabatan_pegawai_id)
|
|
INNER JOIN satuan_kerja s ON (s.id=k.satuan_kerja_id)
|
|
WHERE s.id=$satker_pemilik_surat");
|
|
while ($rjb1 = pg_fetch_array($jb1)) {
|
|
$namaku = $rjb1[1];
|
|
}
|
|
|
|
$jb2 = pg_query($koneksi, "SELECT t.jabatan_untuk,k.isi FROM teruskan t INNER JOIN kirim k ON (k.id=t.kirim_id_untuk) WHERE t.surat_id=$id AND k.isi IS NULL ORDER BY t.id DESC LIMIT 1");
|
|
while ($rjb2 = pg_fetch_array($jb2)) {
|
|
$jab_terakir = $rjb2[0];
|
|
}
|
|
|
|
$jb3 = pg_query($koneksi, "SELECT COUNT(*) FROM teruskan WHERE surat_id=$id");
|
|
while ($rjb3 = pg_fetch_array($jb3)) {
|
|
$jmlter = $rjb3[0];
|
|
}
|
|
|
|
$jsm = pg_query($koneksi, "SELECT isi FROM kirim WHERE id=$kirimid");
|
|
while ($rjsm = pg_fetch_array($jsm)) {
|
|
$jmlsm = $rjsm[0];
|
|
}
|
|
|
|
$d9 = pg_query($koneksi, "SELECT COUNT(*)
|
|
FROM kirim k INNER JOIN surat s ON (k.surat_id=s.id)
|
|
INNER JOIN data_user u ON (u.satuan_kerja_id=k.satuan_kerja_penginput)
|
|
WHERE k.kepada IS NOT NULL AND k.surat_id=$id AND u.jabatan_pegawai_id=$jabatan_pegawai_id AND k.satuan_kerja_tujuan IS NULL");
|
|
while ($r9 = pg_fetch_array($d9)) {
|
|
$jd9 = $r9[0];
|
|
}
|
|
|
|
$k = pg_query($koneksi, "SELECT COUNT(*)
|
|
FROM kirim k INNER JOIN surat s ON (k.surat_id=s.id)
|
|
LEFT OUTER JOIN teruskan t ON (k.id=t.kirim_id_untuk)
|
|
WHERE k.kepada IS NOT NULL AND k.surat_id=$id AND t.jabatan_dari IS NULL AND k.satuan_kerja_penginput=$satker_pemilik_surat");
|
|
while ($rk = pg_fetch_array($k)) {
|
|
$kpdxxxx = $rk[0];
|
|
}
|
|
|
|
$l = pg_query($koneksi, "SELECT COUNT(*)
|
|
FROM scan k INNER JOIN surat s ON (k.surat_id=s.id)
|
|
WHERE k.surat_id=$id
|
|
-- AND LOWER(k.file) LIKE '%jpg'
|
|
-- AND LOWER(k.file) LIKE '%png'
|
|
-- AND LOWER(k.file) LIKE '%jpeg'
|
|
AND LOWER(file) NOT IN ('%.jpg', '%.jpeg', '%.png')
|
|
");
|
|
while ($rl = pg_fetch_array($l)) {
|
|
$tj = $rl[0];
|
|
}
|
|
|
|
$m = pg_query($koneksi, "SELECT COUNT(*)
|
|
FROM scan k INNER JOIN surat s ON (k.surat_id=s.id)
|
|
WHERE k.surat_id=$id AND LOWER(file) NOT LIKE '%.jpg'
|
|
AND LOWER(file) NOT LIKE '%.png'
|
|
AND LOWER(file) NOT LIKE '%.jpeg'
|
|
");
|
|
while ($rm = pg_fetch_array($m)) {
|
|
$tk = $rm[0];
|
|
}
|
|
?>
|
|
<!--
|
|
<div class="alert alert-icon alert-danger alert-dismissible fade in" role="alert" style="color:red" id="info_setor">
|
|
<i class="mdi mdi-information"></i>
|
|
<span><strong>PERHATIAN!</strong></span><br>
|
|
<span>" FITUR INI MASIH DALAM TAHAP UJICOBA "</span><br>
|
|
</div>
|
|
-->
|
|
<input type="hidden" id="surat_id_tl" value="<?php echo $id; ?>">
|
|
<input type="hidden" id="jabatan_pegawai_id_tl" value="<?php echo $jabatan_pegawai_id; ?>">
|
|
<input type="hidden" id="kirim_id_dari" value="<?php echo $kirimid; ?>">
|
|
<input type="hidden" id="jab_terakir" value="<?php echo $jab_terakir; ?>">
|
|
<input type="hidden" id="jmlter" value="<?php echo $jmlter; ?>">
|
|
<input type="hidden" id="jmlsm" value="<?php echo $jmlsm; ?>">
|
|
<input type="hidden" id="csatker" value="<?php echo $cek_satker; ?>">
|
|
<input type="hidden" id="jd9" value="<?php echo $jd9; ?>">
|
|
<input type="hidden" id="satker_pemilik_surat" value="<?php echo $satker_pemilik_surat; ?>">
|
|
<div class="m-t-0">
|
|
|
|
<div class="media">
|
|
|
|
<!--<div class="media-left">
|
|
<a href="#"> <img class="media-object m-r-10" alt="64x64" src="assets/images/no_profile.png" style="width: 96px; height: 96px;"> </a>
|
|
</div>-->
|
|
<div class="media-body">
|
|
<h5 class="media-heading" style="font-family:InterSB;color:black"><?php echo $namaku; ?></h5>
|
|
<h6 class="text-muted m-t-0" style="font-family:InterSB"><?php echo $hari_surat_keluar . ', ' . $tgl_surat_keluar1; ?></h6>
|
|
<p style="font-family:Inter;color:black"><?php echo $perihal; ?></p>
|
|
<button type="button" name="file_inbox" style="font-family:InterSB" class="btn btn-default file_inbox btn-rounded" id="<?php echo $id; ?>" data-content="Lihat Gambar" rel="popover" data-placement="top" data-trigger="hover"><i class="fa fa-file-picture-o"></i>
|
|
<span><?php echo $tj; ?></span>
|
|
</button>
|
|
<button type="button" name="lampiran_inbox" style="font-family:InterSB" class="btn btn-default lampiran_inbox btn-rounded" id="<?php echo $id; ?>" data-content="Lihat File" rel="popover" data-placement="top" data-trigger="hover"><i class="fa fa-file"></i>
|
|
<span><?php echo $tk; ?></span>
|
|
</button>
|
|
<button type="button" name="kepada_inbox" style="font-family:InterSB" class="btn btn-default kepada_inbox btn-rounded" id="<?php echo $id; ?>" data-content="Kepada" rel="popover" data-placement="top" data-trigger="hover"><i class="fa fa-user"></i>
|
|
<span><?php echo $kpdxxxx; ?></span>
|
|
</button>
|
|
<br>
|
|
</div>
|
|
<br>
|
|
<div id="inkomen">
|
|
<?php if ($key == 'kirim_awal') {
|
|
} else { ?>
|
|
<div class="row">
|
|
<div class="col-lg-12">
|
|
<button type="button" class="btn btn-default btn-block pull-right" name="forward_tl" id="forward_tl"><i class="fa fa-user m-r-5"></i>Teruskan ke..
|
|
<?php if ($jd9 == 0) {
|
|
echo '<span class="label label-danger" id="notif_jd9" style="margin-top:2px"></span>';
|
|
} else {
|
|
echo '<span class="label label-danger" id="notif_jd9" style="margin-top:2px">' . $jd9 . '</span>';
|
|
} ?>
|
|
</button>
|
|
</div>
|
|
</div><br>
|
|
<?php } ?>
|
|
|
|
<div class="form-group">
|
|
<textarea class="form-control" id="komen" name="message" rows="2" placeholder="Bagaimana tanggapan anda ?" required=""></textarea>
|
|
</div>
|
|
<div class="row">
|
|
<div class="col-lg-8">
|
|
</div>
|
|
<div class="col-lg-2" style="display: flex; justify-content: space-between;">
|
|
<button type="button" class="btn btn-danger btn-rounded" id="kembalikan_komen" style="margin-right: 10px;"><i class="mdi mdi-undo-variant m-r-5"></i>Kembalikan</button>
|
|
<button type="button" class="btn btn-success btn-rounded" id="simpan_komen"><i class="mdi mdi-send m-r-5"></i>Kirim</button>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
|
|
<div class="m-t-20 blog-post-comment">
|
|
<!--<span style="font-family:Arial;font-weight:bold;color:black" id="total_komen"></span><br><br>-->
|
|
<div id="tabel_komen"></div>
|
|
</div>
|
|
|
|
|
|
|
|
<script>
|
|
$('button[name="file_inbox"]').popover();
|
|
$('button[name="lampiran_inbox"]').popover();
|
|
$('button[name="kepada_inbox"]').popover();
|
|
|
|
$('button[name="file_inbox"]').click(function() {
|
|
var id = $(this).attr('id');
|
|
$('#modal_inbox').modal('show');
|
|
$('#modal_body_inbox').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/inbox/modal.php",
|
|
data: 'id=' + id,
|
|
success: function(data) {
|
|
$('#modal_body_inbox').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
$('button[name="lampiran_inbox"]').click(function() {
|
|
var id = $(this).attr('id');
|
|
$('#modal_file_inbox').modal('show');
|
|
$('#modal_body_file_inbox').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/inbox/modal_file.php",
|
|
data: {
|
|
id: id
|
|
},
|
|
success: function(data) {
|
|
$('#modal_body_file_inbox').html(data);
|
|
}
|
|
});
|
|
});
|
|
$('button[name="kepada_inbox"]').click(function() {
|
|
var id = $(this).attr('id');
|
|
var satker_pemilik_surat = $('#satker_pemilik_surat').val();
|
|
var jabatan_pegawai_id_tl = $('#jabatan_pegawai_id_tl').val();
|
|
$('#modal_kpdxxxx').modal('show');
|
|
$('#modal_body_kpdxxxx').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/tindaklanjut/modal_kepada_awal.php",
|
|
data: {
|
|
id: id,
|
|
satker_pemilik_surat: satker_pemilik_surat,
|
|
jabatan_pegawai_id: jabatan_pegawai_id_tl
|
|
},
|
|
success: function(data) {
|
|
$('#modal_body_kpdxxxx').html(data);
|
|
}
|
|
});
|
|
});
|
|
var surat_id = $('#surat_id_tl').val();
|
|
var jabatan_pegawai_id_tl = $('#jabatan_pegawai_id_tl').val();
|
|
$('#tabel_komen').load("app/tindaklanjut/tabel_komen.php", {
|
|
surat_id: surat_id,
|
|
jabatan_pegawai_id_tl: jabatan_pegawai_id_tl
|
|
});
|
|
var jmlsm = $('#jmlsm').val();
|
|
var jmlter = $('#jmlter').val();
|
|
var jab_terakir = $('#jab_terakir').val();
|
|
if (jmlsm == 'SM') {
|
|
$('#inkomen').hide();
|
|
} else {
|
|
if ((jabatan_pegawai_id_tl == jab_terakir) || (jmlter == 0)) {
|
|
$('#inkomen').show();
|
|
} else {
|
|
$('#inkomen').hide();
|
|
}
|
|
}
|
|
|
|
/*
|
|
var jmlter=$('#jmlter').val();
|
|
var jab_terakir=$('#jab_terakir').val();
|
|
if ((jabatan_pegawai_id_tl==jab_terakir) || (jmlter==0)) {
|
|
$('#inkomen').show();
|
|
} else {
|
|
$('#inkomen').hide();
|
|
}
|
|
|
|
var jmlsm=$('#jmlsm').val();
|
|
if (jmlsm=='SM') {$('#inkomen').hide();} else {$('#inkomen').show();}
|
|
*/
|
|
|
|
$('#simpan_komen').click(function() {
|
|
var surat_id = $('#surat_id_tl').val();
|
|
var jabatan_pegawai_id = $('#jabatan_pegawai_id_tl').val();
|
|
var komen = $('#komen').val();
|
|
var jd9 = $('#jd9').val();
|
|
var satuan_kerja_penginput = $('#csatker').val();
|
|
if ((!komen) || (jd9 == 0)) {
|
|
// alert('Tanggapan atau Teruskan mohon ditentukan lebih dahulu..');
|
|
infoToast('error','Tanggapan atau Teruskan mohon ditentukan lebih dahulu..!!');
|
|
} else {
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/tindaklanjut/crud.php",
|
|
data: {
|
|
surat_id: surat_id,
|
|
jabatan_pegawai_id: jabatan_pegawai_id,
|
|
satuan_kerja_penginput: satuan_kerja_penginput,
|
|
komen: komen,
|
|
key: 'simpan_komen'
|
|
},
|
|
success: function(data) {
|
|
alert('Tersimpan..');
|
|
$('#tabel_komen').load("app/tindaklanjut/tabel_komen.php", {
|
|
surat_id: surat_id,
|
|
jabatan_pegawai_id_tl: jabatan_pegawai_id_tl
|
|
});
|
|
$('#komen').val('');
|
|
$('#inkomen').hide();
|
|
}
|
|
});
|
|
}
|
|
});
|
|
|
|
$('button[name="jpg_kirim_tl"]').click(function() {
|
|
var id = $(this).attr('id');
|
|
$('#modal_pic').modal('show');
|
|
$('#modal_body_pic').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/tindaklanjut/modal_dok.php",
|
|
data: 'id=' + id,
|
|
success: function(data) {
|
|
$('#modal_body_pic').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
$('button[name="file_kirim_tl"]').click(function() {
|
|
var id = $(this).attr('id');
|
|
$('#modal_file').modal('show');
|
|
$('#modal_body_file').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/tindaklanjut/upd_file.php",
|
|
data: 'id=' + id,
|
|
success: function(data) {
|
|
$('#modal_body_file').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
|
|
$(document).on('hidden.bs.modal', function(event) {
|
|
if ($('.modal:visible').length) {
|
|
$('body').addClass('modal-open');
|
|
}
|
|
});
|
|
|
|
$('#forward_tl').click(function() {
|
|
var id = $('#surat_id_tl').val();
|
|
var jabatan_pegawai_id_tl = $('#jabatan_pegawai_id_tl').val();
|
|
$('#modal_kepada').modal('show');
|
|
$('#modal_body_kepada').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/tindaklanjut/modal_kepada.php",
|
|
data: {id:id,jabatan_pegawai_id_tl:jabatan_pegawai_id_tl},
|
|
success: function(data) {
|
|
$('#modal_body_kepada').html(data);
|
|
$('#kepada_k').first().focus().selected();
|
|
}
|
|
});
|
|
});
|
|
|
|
function infoToast(icone, infone) {
|
|
Swal.fire({
|
|
// position: posisine,
|
|
icon: icone,
|
|
title: infone,
|
|
showConfirmButton: false,
|
|
timer: 2500
|
|
});
|
|
}
|
|
</script>
|