339 lines
16 KiB
PHP
339 lines
16 KiB
PHP
<?php
|
|
include("../koneksi.php");
|
|
$satuan_kerja_id = $_POST['satker'];
|
|
$jenis_user = $_POST['jenis'];
|
|
$sess_nama = $_POST['sess_nama'];
|
|
|
|
$bln2 = $_POST['bln2'];
|
|
$thn2 = $_POST['thn2'];
|
|
|
|
?>
|
|
|
|
<script type="text/javascript">
|
|
$('button[name="edit_kirim"]').popover();
|
|
$('button[name="hapus_kirim"]').popover();
|
|
$('button[name="proses_tl"]').popover();
|
|
$("#tabel_data_kirim").DataTable({
|
|
"paging": true,
|
|
"lengthChange": true,
|
|
"searching": true,
|
|
"ordering": false,
|
|
"info": true,
|
|
"autoWidth": false
|
|
});
|
|
</script>
|
|
|
|
<input type="hidden" id="jenis" value="<?php echo $jenis_user; ?>">
|
|
<input type="hidden" id="sess_nama" value="<?php echo $sess_nama; ?>">
|
|
<input type="hidden" id="satuan_kerja_id" value="<?php echo $satuan_kerja_id; ?>">
|
|
|
|
<input type="hidden" id="disp_bln" value="<?php echo $bln2; ?>">
|
|
<input type="hidden" id="disp_thn" value="<?php echo $thn2; ?>">
|
|
<input type="hidden" id="satuan_kerja_idcek" value="<?php echo $satuan_kerja_id; ?>">
|
|
<table id="tabel_data_kirim" class="table table-striped table-condensed table-bordered">
|
|
<thead>
|
|
<tr>
|
|
<td width="200px;">No Surat</td>
|
|
<td>Perihal</td>
|
|
<td width="120px;">Tgl Kirim</td>
|
|
<td width="120px;" style="display:none">No Surat</td>
|
|
<td style="display:none"></td>
|
|
<td width="80px;">Tools</td>
|
|
<td style="display:none"></td>
|
|
<td style="display:none"></td>
|
|
<td style="display:none"></td>
|
|
<td style="display:none"></td>
|
|
<td style="display:none"></td>
|
|
</tr>
|
|
</thead>
|
|
<tbody style="color:black">
|
|
<?php
|
|
$data = pg_query($koneksi, "SELECT tgl_surat_keluar,perihal,satuan_kerja_id,id,tgl_kirim,no_surat FROM surat WHERE satuan_kerja_id='$satuan_kerja_id'
|
|
AND jenis_surat_id='3' AND jenis_disposisi_id='3' AND COALESCE(tahun,'') <> 'batal'
|
|
" . ($thn2 == '' ? "" : "AND EXTRACT(YEAR FROM DATE(tgl_surat_keluar))='$thn2'") . "
|
|
" . ($bln2 == '0' ? "" : "AND EXTRACT(MONTH FROM DATE(tgl_surat_keluar))='$bln2'") . "
|
|
ORDER BY tgl_surat_keluar DESC
|
|
");
|
|
while ($r = pg_fetch_array($data)) {
|
|
$surat_id = $r[3];
|
|
$satuan_kerja_id = $r['satuan_kerja_id'];
|
|
/*
|
|
$k=pg_query("SELECT COUNT(*)
|
|
FROM kirim k INNER JOIN surat s ON (k.surat_id=s.id)
|
|
WHERE k.kepada IS NOT NULL AND k.surat_id='$surat_id'");
|
|
while($rk=pg_fetch_array($k)) {$kpd=$rk[0];}
|
|
*/
|
|
|
|
/*
|
|
$k=pg_query("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=$surat_id AND t.jabatan_dari IS NULL AND k.satuan_kerja_penginput=$satuan_kerja_id");
|
|
while($rk=pg_fetch_array($k)) {$kpd=$rk[0];}
|
|
|
|
$l=pg_query("SELECT COUNT(*)
|
|
FROM scan k INNER JOIN surat s ON (k.surat_id=s.id)
|
|
WHERE k.surat_id='$surat_id' AND LOWER(k.file) LIKE '%jpg' AND k.file NOT IN ('')");
|
|
while($rl=pg_fetch_array($l)) {$tj=$rl[0];}
|
|
|
|
$m=pg_query("SELECT COUNT(*)
|
|
FROM scan k INNER JOIN surat s ON (k.surat_id=s.id)
|
|
WHERE k.surat_id='$surat_id' AND LOWER(k.file) NOT LIKE '%jpg' AND k.file NOT IN ('')");
|
|
while($rm=pg_fetch_array($m)) {$tm=$rm[0];}
|
|
|
|
$n=pg_query("SELECT COUNT(*) FROM kirim WHERE surat_id=$surat_id AND satuan_kerja_tujuan IS NULL AND satuan_kerja_penginput=$satuan_kerja_id");
|
|
while($rn=pg_fetch_array($n)) {$tn=$rn[0];}
|
|
*/
|
|
$to = '';
|
|
/*$o=pg_query("SELECT jabatan_untuk FROM teruskan WHERE surat_id=$surat_id AND id=(SELECT MAX(id) FROM teruskan WHERE surat_id=$surat_id)");
|
|
while($ro=pg_fetch_array($o)) {$to=$ro[0];}*/
|
|
|
|
$o = pg_query($koneksi, "SELECT t.jabatan_untuk FROM teruskan t INNER JOIN kirim k ON (k.id=t.kirim_id_untuk) WHERE t.surat_id=$surat_id
|
|
AND k.isi IS NULL AND t.id=(SELECT MAX(t2.id) FROM teruskan t2 INNER JOIN kirim k2 ON (k2.id=t2.kirim_id_untuk) WHERE t2.surat_id=$surat_id
|
|
AND k2.isi IS NULL)");
|
|
while ($ro = pg_fetch_array($o)) {
|
|
$to = $ro[0];
|
|
}
|
|
|
|
$p = pg_query($koneksi, "SELECT u.jabatan_pegawai_id FROM data_user u INNER JOIN jabatan_pegawai j ON (j.id=u.jabatan_pegawai_id) WHERE u.satuan_kerja_id=$satuan_kerja_id");
|
|
while ($rp = pg_fetch_array($p)) {
|
|
$tp = $rp[0];
|
|
}
|
|
?>
|
|
|
|
<tr>
|
|
<!--<td class="kiri" style="display:none"><?php echo date('d-m-Y H:i', strtotime($r['tgl_surat_keluar'])); ?></td>-->
|
|
<td class="kiri"><?php echo $r['no_surat']; ?></td>
|
|
<td><?php echo $r['perihal']; ?></td>
|
|
<td align="center"><?php echo ($r['tgl_kirim'] == NULL) ? '<span style="color:red">Belum Dikirim</span>' : '<span style="color:green">'.date('d-m-Y H:i', strtotime($r['tgl_kirim'])).'</span>'; ?></td>
|
|
<td style="display:none"><?php echo $r['no_surat']; ?></td> <!-- 3 -->
|
|
<td style="display:none"><?php echo $r['perihal']; ?></td> <!-- 4 -->
|
|
<td class="kanan" align="center">
|
|
|
|
<button type="button" name="jpg_kirim" style="height:22px;display:none" class="btn btn-default btn-xs jpg_kirim" id="<?php echo $r[3]; ?>" data-content="File" rel="popover" data-placement="top" data-trigger="hover">
|
|
<i class="fa fa-file-picture-o m-r-5"></i>Scan Surat<span class="sq<?php echo $r[3]; ?>" idne="jpg<?php echo $r[3]; ?>"> <?php echo '(' . $tj . ')' ?></span>
|
|
</button>
|
|
<button type="button" name="file_kirim" style="height:22px;display:none" class="btn btn-default btn-xs file_kirim" id="<?php echo $r[3]; ?>" data-content="File" rel="popover" data-placement="top" data-trigger="hover">
|
|
<i class="fa fa-file m-r-5"></i>Lampiran<span class="sr<?php echo $r[3]; ?>" idne="pdf<?php echo $r[3]; ?>"> <?php echo '(' . $tm . ')' ?></span>
|
|
</button>
|
|
<button type="button" name="kepada_kirim" style="height:22px;display:none" class="btn btn-default btn-xs kepada_kirim" id="<?php echo $r[3]; ?>" data-content="Kepada" rel="popover" data-placement="top" data-trigger="hover">
|
|
<i class="fa fa-user m-r-5"></i>Kepada<span class="sp<?php echo $r[3]; ?>" idne="kpd<?php echo $r[3]; ?>"> <?php echo '(' . $kpd . ')' ?></span>
|
|
</button>
|
|
<button type="button" name="edit_kirim" style="height:22px;" class="btn btn-success btn-xs edit_kirim" id="<?php echo $r[3]; ?>" data-content="Edit" rel="popover" data-placement="top" data-trigger="hover">
|
|
<i class="fa fa-pencil"></i>
|
|
</button>
|
|
<button type="button" name="hapus_kirim" style="height:22px;" class="btn btn-danger btn-xs hapus_kirim" id="<?php echo $r[3]; ?>" data-content="Hapus" rel="popover" data-placement="top" data-trigger="hover">
|
|
<i class="fa fa-remove"></i>
|
|
</button>
|
|
<button type="button" name="proses_tl" style="height:22px;" class="btn btn-default btn-xs proses_tl" id="<?php echo $r[3]; ?>" data-content="Info Tindak Lanjut" rel="popover" data-placement="top" data-trigger="hover">
|
|
<?php
|
|
if ($to != $tp) {
|
|
$jko = pg_query($koneksi, "SELECT COUNT(*) FROM komen WHERE surat_id=$surat_id");
|
|
while ($rjko = pg_fetch_array($jko)) {
|
|
$tjko = $rjko[0];
|
|
}
|
|
?>
|
|
<?php if ($tjko == 0) { ?>
|
|
<i class="fa fa-ellipsis-h"></i>
|
|
<?php } else { ?>
|
|
<span style="color:red;font-family:Arial;font-weight:bold"><?php echo $tjko; ?></span>
|
|
<?php } ?>
|
|
<?php
|
|
} else {
|
|
?>
|
|
<i class="fa fa-check"></i>
|
|
<?php } ?>
|
|
</button>
|
|
<!--
|
|
<button type="button" name="coba_edit" style="height:22px;"class="btn btn-default btn-xs coba_edit" id="<?php echo $r[3]; ?>" data-content="?" rel="popover" data-placement="top" data-trigger="hover"
|
|
><i class="fa fa-question"></i>
|
|
</button>
|
|
-->
|
|
|
|
|
|
<!--<button type="button" name="start_kirim" style="height:22px;"class="btn btn-inverse btn-xs start_kirim" id="<?php echo $r[3]; ?>" data-content="File" rel="popover" data-placement="top" data-trigger="hover"
|
|
><i class="fa fa-arrow-right m-r-5"></i>KIRIM
|
|
</button>-->
|
|
|
|
</td>
|
|
<td style="display:none" class="xq<?php echo $r[3]; ?>"><?php echo $tj; ?></td> <!-- 6 -->
|
|
<td style="display:none" class="xr<?php echo $r[3]; ?>"><?php echo $tm; ?></td> <!-- 7 -->
|
|
<td style="display:none" class="xp<?php echo $r[3]; ?>"><?php echo $kpd; ?></td> <!-- 8 -->
|
|
<td style="display:none" class="xs<?php echo $r[3]; ?>"><?php echo $r['no_surat']; ?></td> <!-- 9 -->
|
|
<td style="display:none" class="xt<?php echo $r[3]; ?>"><?php echo $r['perihal']; ?></td> <!-- 10 -->
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
|
|
|
|
|
|
<script type="text/javascript">
|
|
/*$('button[name="file_kirim"]').popover();
|
|
$('button[name="kepada_kirim"]').popover();*/
|
|
|
|
$("#tabel_data_kirim").on('click', '.edit_kirim', function() {
|
|
var id = $(this).attr('id');
|
|
var satuan_kerja_id = $('#satuan_kerja_idcek').val();
|
|
$('#modal_kirim2').modal('show');
|
|
$('#modal_body_kirim2').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/kirim/modal_edit.php",
|
|
data: { id: id, satuan_kerja_id: satuan_kerja_id },
|
|
success: function(data) {
|
|
$('#modal_body_kirim2').html(data);
|
|
$('#perihal').first().focus().selected();
|
|
}
|
|
});
|
|
});
|
|
|
|
/*
|
|
$("#tabel_data_kirim").on('click','.edit_kirim',function(){
|
|
var id = $(this).attr('id');
|
|
var satuan_kerja_id = $('#satuan_kerja_idcek').val();
|
|
$('#modal_kirim').modal('show');
|
|
$('#modal_body_kirim').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/kirim/modal.php",
|
|
data: 'id='+id
|
|
+'&satuan_kerja_id='+satuan_kerja_id,
|
|
success: function(data){
|
|
$('#modal_body_kirim').html(data);
|
|
$('#perihal').first().focus().selected();
|
|
}
|
|
});
|
|
});
|
|
*/
|
|
$("#tabel_data_kirim").on('click', '.kepada_kirim', function() {
|
|
var id = $(this).attr('id');
|
|
var satuan_kerja_id = $('#satuan_kerja_idcek').val();
|
|
$('#modal_kepada').modal('show');
|
|
$('#modal_body_kepada').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/kirim/modal_kepada.php",
|
|
data: { id: id, satuan_kerja_id: satuan_kerja_id },
|
|
success: function(data) {
|
|
$('#modal_body_kepada').html(data);
|
|
$('#kepada_k').first().focus().selected();
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#tabel_data_kirim").on('click', '.jpg_kirim', function() {
|
|
var id = $(this).attr('id');
|
|
$('#modal_pic').modal('show');
|
|
$('#modal_body_pic').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/kirim/modal_dok.php",
|
|
data: 'id=' + id,
|
|
success: function(data) {
|
|
$('#modal_body_pic').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#tabel_data_kirim").on('click', '.file_kirim', function() {
|
|
var id = $(this).attr('id');
|
|
$('#modal_file').modal('show');
|
|
$('#modal_body_file').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/kirim/upd_file.php",
|
|
data: 'id=' + id,
|
|
success: function(data) {
|
|
$('#modal_body_file').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#tabel_data_kirim").on('click', '.proses_tl', function() {
|
|
var currentRow = $(this).closest("tr");
|
|
var perihal = currentRow.find("td:eq(4)").text();
|
|
var id = $(this).attr('id');
|
|
var cek_satker = $('#satuan_kerja_idcek').val();
|
|
// var key = 'kirim_awal';
|
|
$('#modal_tl').modal('show');
|
|
$('#modal_body_tl').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/tindaklanjut/main.php",
|
|
data: {
|
|
id: id,
|
|
perihal: perihal,
|
|
cek_satker: cek_satker,
|
|
key: 'kirim_awal'
|
|
},
|
|
success: function(data) {
|
|
$('#modal_body_tl').html(data);
|
|
$('#inkomen').hide();
|
|
}
|
|
});
|
|
});
|
|
|
|
|
|
$("#tabel_data_kirim").on('click', '.hapus_kirim', function() {
|
|
var x = confirm("Anda yakin ingin menghapus ?");
|
|
if (x) {
|
|
var key = "hapus_kirim";
|
|
var id = $(this).attr('id');
|
|
var rowElement = $(this).parent().parent();
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/kirim/crud.php",
|
|
data: 'id=' + id +
|
|
'&key=' + key,
|
|
success: function(data) {
|
|
rowElement.fadeOut(500).remove();
|
|
// $('#tabel_data_kirim').load("app/kirim/tabel.php"); // memuat ulang tabel dengan id yang sama
|
|
}
|
|
});
|
|
} else {}
|
|
});
|
|
|
|
/*
|
|
$("#tabel_data_kirim").on('click','.start_kirim',function(){
|
|
var currentRow=$(this).closest("tr");
|
|
var no_surat = currentRow.find("td:eq(3)").text();
|
|
var perihal = currentRow.find("td:eq(4)").text();
|
|
var jml_pic = currentRow.find("td:eq(6)").text();
|
|
var jml_file = currentRow.find("td:eq(7)").text();
|
|
var jml_kpd = currentRow.find("td:eq(8)").text();
|
|
var satuan_kerja_id = $('#satuan_kerja_idcek').val();
|
|
if ((!no_surat) || (!perihal) || ((jml_pic=='0') && (jml_file=='0')) || (jml_kpd=='0')) {
|
|
alert('No surat, Perihal, Lampiran, dan Kepada harus di-isi, Mohon dicek kembali..');
|
|
} else {
|
|
var x = confirm("Anda yakin ingin mengirim ?");
|
|
if (x) {
|
|
var key = "start_kirim";
|
|
var id = $(this).attr('id');
|
|
var thn2 = $('#disp_thn').val();
|
|
var bln2 = $('#disp_bln').val();
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/kirim/crud.php",
|
|
data: 'id='+id
|
|
+'&satuan_kerja_id='+satuan_kerja_id
|
|
+'&key='+key,
|
|
success: function(data){
|
|
alert('Surat terkirim ke tujuan..');
|
|
var thn2 = $('#disp_thn').val();
|
|
var bln2 = $('#disp_bln').val();
|
|
var sat = $('#satuan_kerja_id').val();
|
|
if (sat=='172') {
|
|
$('#tabel_kirim').load("app/kirim/tabel.php",{satker:sat,jenis:sess_jenis,sess_nama:sess_nama,thn2:thn2,bln2:bln2});
|
|
} else {
|
|
$('#tabel_kirim').load("app/kirim/tabel.php",{satker:sess_satker,jenis:sess_jenis,sess_nama:sess_nama,thn2:thn2,bln2:bln2});
|
|
}
|
|
}
|
|
});
|
|
} else {}
|
|
}
|
|
});
|
|
*/
|
|
</script>
|