383 lines
17 KiB
PHP
383 lines
17 KiB
PHP
<script>
|
|
$('button[name="jpg_kirim_tl"]').popover();
|
|
$('button[name="file_kirim_tl"]').popover();
|
|
$('button[name="hapus_arahan"]').popover();
|
|
</script>
|
|
<?php
|
|
include('../koneksi.php');
|
|
$surat_id=$_POST['surat_id'];
|
|
$jabatan_pegawai_id_tl=$_POST['jabatan_pegawai_id_tl'];
|
|
$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'
|
|
);
|
|
|
|
?>
|
|
<ul class="media-list" id="tabel_data_komen">
|
|
<?php
|
|
$d=pg_query("SELECT k.id,k.jabatan_pegawai_id,k.tanggal,k.komen,k.induk_id,j.nama as nama_jabatan,t.jabatan_untuk,j1.nama as jabuntuk,r.isi,r.id as kirimid
|
|
FROM komen k
|
|
INNER JOIN teruskan t ON (k.id=t.komen_id)
|
|
INNER JOIN jabatan_pegawai j ON (j.id=k.jabatan_pegawai_id)
|
|
INNER JOIN jabatan_pegawai j1 ON (j1.id=t.jabatan_untuk)
|
|
INNER JOIN kirim r ON (r.id=t.kirim_id_untuk)
|
|
WHERE k.surat_id=$surat_id AND k.induk_id IS NULL
|
|
AND r.isi IS NULL
|
|
ORDER BY id DESC,t.kirim_id_untuk ASC");
|
|
while($r=pg_fetch_array($d)) {
|
|
$komen_id=$r['id'];
|
|
$tanggal=$r['tanggal'];
|
|
$jbid=$r['jabatan_pegawai_id'];
|
|
$jabatan_untuk=$r['jabuntuk'];
|
|
$kirimid=$r['kirimid'];
|
|
$hari_komen=$dayList[date('D',strtotime($tanggal))];
|
|
if (($tanggal==null) || ($tanggal=='')) {$tanggal='';} else {$tanggal1= date('d',strtotime($tanggal)).' '.$bulan[date('m',strtotime($tanggal))].' '.date('Y',strtotime($tanggal)).' '.date('H:i',strtotime($tanggal));}
|
|
|
|
$l=pg_query("SELECT COUNT(*)
|
|
FROM scan_komen k INNER JOIN komen s ON (k.komen_id=s.id)
|
|
WHERE k.komen_id=$komen_id AND LOWER(k.file) LIKE ANY (ARRAY['%jpg','%jpeg','%png']) AND k.file NOT IN ('')");
|
|
while($rl=pg_fetch_array($l)) {$tj=$rl[0];}
|
|
|
|
$m=pg_query("SELECT COUNT(*)
|
|
FROM scan_komen k INNER JOIN komen s ON (k.komen_id=s.id)
|
|
WHERE k.komen_id=$komen_id AND LOWER(k.file) NOT LIKE ALL (ARRAY['%jpg','%jpeg','%png']) AND k.file NOT IN ('')");
|
|
while($rm=pg_fetch_array($m)) {$tm=$rm[0];}
|
|
|
|
?>
|
|
<li class="media">
|
|
<!--<a class="pull-left" href="#">
|
|
<img class="media-object img-circle"
|
|
src="assets/images/no_profile2.png" alt="img">
|
|
</a>-->
|
|
<div class="media-body">
|
|
<h5 class="media-heading" style="font-family:InterSB;color:#576CBC">
|
|
<?php
|
|
echo 'Dari '.$r['nama_jabatan'];
|
|
?>
|
|
<?php if ($jabatan_pegawai_id_tl==$jbid) {?>
|
|
<button type="button" class="btn btn-default btn-rounded btn-xs hapus_arahan pull-right" style="font-family:InterSB;font-size:12px;color:black" name="hapus_arahan" id="<?php echo $kirimid; ?>"
|
|
data-content="Hapus Arahan dan Tindak Lanjut" name="jpg_kirim_tl" rel="popover" data-placement="top" data-trigger="hover"
|
|
><i class="fa fa-remove"></i></button>
|
|
<?php } ?>
|
|
</h5>
|
|
<h6 class="text-muted m-t-0" style="font-family:InterSB;"><?php echo $hari_komen.', '.$tanggal1; ?></h6>
|
|
<table style="color:black;font-family:Inter;font-size:14px" border=0>
|
|
<?php
|
|
$d2=pg_query("SELECT j1.nama,r.isi
|
|
FROM komen k
|
|
INNER JOIN teruskan t ON (k.id=t.komen_id)
|
|
INNER JOIN jabatan_pegawai j ON (j.id=k.jabatan_pegawai_id)
|
|
INNER JOIN jabatan_pegawai j1 ON (j1.id=t.jabatan_untuk)
|
|
INNER JOIN kirim r ON (r.id=t.kirim_id_untuk)
|
|
WHERE k.surat_id=$surat_id AND k.induk_id IS NULL AND t.jabatan_dari=$jbid AND k.id=$komen_id
|
|
ORDER BY k.id DESC,t.kirim_id_untuk ASC
|
|
");
|
|
while($rd2=pg_fetch_array($d2)) {
|
|
$isi=$rd2['isi'];
|
|
?>
|
|
<tr>
|
|
<td width="20"><i class="mdi mdi-apps m-r-5"></i></td><td>
|
|
<?php
|
|
echo 'Kepada '.$rd2[0];
|
|
if ($isi=='SM') {} else {echo '<span style="color:red"><i class="mdi mdi-map-marker m-l-5"></i></span>';}
|
|
?>
|
|
</td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</table><br>
|
|
<div class="isi_komen" id="isi_komen<?php echo $r['id'];?>">
|
|
|
|
|
|
<div class="portlet">
|
|
<div id="bg-default" class="panel-collapse collapse in">
|
|
<div class="portlet-body">
|
|
<p id="txtkomen<?php echo $r['id'];?>" style="font-family:InterSB;color:black"><?php echo '" '.$r['komen'].' "'; ?></p>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<?php if ($jabatan_pegawai_id_tl==$jbid) {?>
|
|
<!-- <button type="button" class="btn btn-default btn-rounded btn-xs hapus_komen" style="font-family:InterSB;font-size:12px;color:red" id="<?php echo $r['id']; ?>"><i class="fa fa-remove m-r-5"></i>Hapus</button>-->
|
|
<button type="button" class="btn btn-default btn-rounded btn-xs edit_komen" style="font-family:InterSB;font-size:12px;color:blue" id="<?php echo $r['id']; ?>"><i class="fa fa-pencil m-r-5"></i>Edit</button>
|
|
<?php } else {?>
|
|
<!--<button type="button" class="btn btn-default btn-rounded btn-xs balas_komen" style="font-family:InterSB;font-size:12px;color:green;" id="balas_komen<?php echo $r['id']; ?>" idls="<?php echo $r['id']; ?>"><i class="mdi mdi-reply m-r-5"></i>Balas</button>-->
|
|
<?php } ?>
|
|
|
|
<?php if (($jabatan_pegawai_id_tl==$jbid) || ($tj!=0)) {?>
|
|
<button type="button" class="btn btn-default btn-rounded btn-xs jpg_kirim_tl" style="font-family:Inter;font-size:12px;color:black" id="<?php echo $r['id']; ?>"
|
|
idne="<?php echo $jabatan_pegawai_id_tl; ?>" idna="<?php echo $jbid; ?>"
|
|
data-content="Add Lampiran JPG" name="jpg_kirim_tl" rel="popover" data-placement="top" data-trigger="hover"
|
|
><i class="fa fa-file-picture-o"></i>
|
|
<?php if ($tj==0) {} else {echo ' '.$tj;} ?>
|
|
</button>
|
|
<?php } if (($jabatan_pegawai_id_tl==$jbid) || ($tm!=0)) {?>
|
|
<button type="button" class="btn btn-default btn-rounded btn-xs file_kirim_tl" style="font-family:Inter;font-size:12px;color:black" id="<?php echo $r['id']; ?>"
|
|
idno="<?php echo $jabatan_pegawai_id_tl; ?>" idnu="<?php echo $jbid; ?>"
|
|
data-content="Add Lampiran File" name="file_kirim_tl" rel="popover" data-placement="top" data-trigger="hover"
|
|
><i class="fa fa-file"></i>
|
|
<?php if ($tm==0) {} else {echo ' '.$tm;} ?>
|
|
</button>
|
|
<?php } else {} ?>
|
|
</div>
|
|
<div class="isi_edit" id="isi_edit<?php echo $r['id'];?>">
|
|
<div class="input-group my-group">
|
|
<span class="input-group-input">
|
|
<input type="text" class="form-control edit_txtkomen" Placeholder="Edit komentar / tanggapan" id="edit_txtkomen<?php echo $r['id'];?>">
|
|
</span>
|
|
<!--<span class="input-group-btn">
|
|
<button type="button" class="btn btn-default btn-block teruskan_edit" style="font-family:InterSB" id="<?php echo $r['id'];?>">Teruskan ke..</button>
|
|
</span>-->
|
|
<span class="input-group-btn">
|
|
<button type="button" class="btn btn-default btn-block simpan_edit" style="font-family:InterSB" id="<?php echo $r['id'];?>">Simpan</button>
|
|
</span>
|
|
<span class="input-group-btn">
|
|
<button type="button" class="btn btn-default btn-block batal_edit" style="font-family:InterSB" id="<?php echo $r['id'];?>">Batal</button>
|
|
</span>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="isi_balas" id="isi_balas<?php echo $r['id'];?>">
|
|
<br>
|
|
<div class="input-group my-group">
|
|
<span class="input-group-input">
|
|
<input type="text" class="form-control edit_txtbalas" Placeholder="Tulis balasan.." id="edit_txtbalas<?php echo $r['id'];?>">
|
|
</span>
|
|
<span class="input-group-btn">
|
|
<button type="button" class="btn btn-default btn-block simpan_balas" style="font-family:InterSB" id="<?php echo $r['id'];?>">Simpan</button>
|
|
</span>
|
|
<span class="input-group-btn">
|
|
<button type="button" class="btn btn-default btn-block batal_balas" style="font-family:InterSB" id="<?php echo $r['id'];?>">Batal</button>
|
|
</span>
|
|
</div>
|
|
</div>
|
|
<!-- nested here -->
|
|
|
|
<!-- end of nested -->
|
|
|
|
</div>
|
|
</li>
|
|
|
|
<?php
|
|
}
|
|
?>
|
|
</ul>
|
|
<?php
|
|
$kmn=pg_query("SELECT COUNT(*) FROM komen WHERE surat_id=$surat_id");
|
|
while($rkmn=pg_fetch_array($kmn)) {
|
|
$jmlkmn=$rkmn[0];
|
|
}
|
|
?>
|
|
<input type="hidden" id="jmlkmn" value="<?php echo $jmlkmn; ?>">
|
|
<input type="hidden" value="<?php echo $jabatan_pegawai_id_tl; ?>">
|
|
<input type="hidden" value="<?php echo $jbid; ?>">
|
|
|
|
<script>
|
|
$('.edit_txtbalas').val('');
|
|
$('.edit_txtkomen').val('');
|
|
$('.balas_komen').show();
|
|
$('.isi_balas').hide();
|
|
$('.isi_edit').hide();
|
|
$('.isi_komen').show();
|
|
|
|
var jmlkmn=$('#jmlkmn').val();
|
|
$('#total_komen').html(jmlkmn+' Komentar');
|
|
|
|
$("#tabel_data_komen").on('click','.hapus_arahan',function(){
|
|
var x = confirm("Anda yakin ingin menghapus ?");
|
|
if (x) {
|
|
var key = "hapus_arahan";
|
|
var id = $(this).attr('id');
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/tindaklanjut/crud.php",
|
|
data: 'id='+id
|
|
+'&key='+key,
|
|
success: function(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});
|
|
}
|
|
});
|
|
} else {}
|
|
});
|
|
|
|
$("#tabel_data_komen").on('click','.balas_komen',function(){
|
|
$('.balas_komen').show();
|
|
$('.isi_balas').hide();
|
|
$('.isi_edit').hide();
|
|
$('.isi_komen').show();
|
|
var id = $(this).attr('idls');
|
|
$('#balas_komen'+id).hide();
|
|
$('#isi_balas'+id).show();
|
|
$('.edit_txtbalas').val('');
|
|
$('#edit_txtbalas'+id).val('');
|
|
$('#edit_txtbalas'+id).focus();
|
|
});
|
|
|
|
$("#tabel_data_komen").on('click','.edit_komen',function(){
|
|
$('.balas_komen').show();
|
|
$('.isi_balas').hide();
|
|
$('.isi_edit').hide();
|
|
$('.isi_komen').show();
|
|
var id = $(this).attr('id');
|
|
$('.edit_txtkomen').val('');
|
|
var txtkomen = $('#txtkomen'+id).html();
|
|
var new_text1 = txtkomen.replace('" ', '');
|
|
var new_text2 = new_text1.replace(' "', '');
|
|
$('#edit_txtkomen'+id).val(new_text2);
|
|
$('#isi_edit'+id).show();
|
|
$('#isi_komen'+id).hide();
|
|
$('#edit_txtkomen'+id).focus();
|
|
});
|
|
|
|
$("#tabel_data_komen").on('click','.simpan_edit',function(){
|
|
var id = $(this).attr('id');
|
|
var surat_id=$('#surat_id_tl').val();
|
|
var jabatan_pegawai_id_tl=$('#jabatan_pegawai_id_tl').val();
|
|
var komen=$('#edit_txtkomen'+id).val();
|
|
var key='edit_komen';
|
|
if (!komen) {alert('isikan komentarnya..');} else {
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/tindaklanjut/crud.php",
|
|
data: 'id='+id
|
|
+'&surat_id='+surat_id
|
|
+'&jabatan_pegawai_id='+jabatan_pegawai_id_tl
|
|
+'&komen='+komen
|
|
+'&key='+key,
|
|
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});
|
|
$('.balas_komen').show();
|
|
$('.isi_balas').hide();
|
|
$('.isi_edit').hide();
|
|
$('.isi_komen').show();
|
|
}
|
|
});
|
|
}
|
|
});
|
|
|
|
$("#tabel_data_komen").on('click','.batal_balas',function(){
|
|
$('.balas_komen').show();
|
|
$('.isi_balas').hide();
|
|
$('.isi_edit').hide();
|
|
$('.isi_komen').show();
|
|
});
|
|
|
|
$("#tabel_data_komen").on('click','.batal_edit',function(){
|
|
$('.balas_komen').show();
|
|
$('.isi_balas').hide();
|
|
$('.isi_edit').hide();
|
|
$('.isi_komen').show();
|
|
});
|
|
|
|
$("#tabel_data_komen").on('click','.hapus_komen',function(){
|
|
var x = confirm("Anda yakin ingin menghapus ?");
|
|
if (x) {
|
|
var key = "hapus_komen";
|
|
var id = $(this).attr('id');
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/tindaklanjut/crud.php",
|
|
data: 'id='+id
|
|
+'&key='+key,
|
|
success: function(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});
|
|
}
|
|
});
|
|
} else {}
|
|
});
|
|
|
|
$("#tabel_data_komen").on('click','.jpg_kirim_tl',function(){
|
|
var id = $(this).attr('id');
|
|
var idne = $(this).attr('idne');
|
|
var idna = $(this).attr('idna');
|
|
$('#modal_pic').modal('show');
|
|
$('#modal_body_pic').html("");
|
|
if (idne==idna) {
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/tindaklanjut/modal_dok.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_body_pic').html(data);
|
|
$('#judul_modal_pic').html('Add Lampiran JPG');
|
|
}
|
|
});
|
|
} else {
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/tindaklanjut/modal_vpic.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_body_pic').html(data);
|
|
$('#judul_modal_pic').html('View Lampiran JPG');
|
|
}
|
|
});
|
|
}
|
|
});
|
|
|
|
$("#tabel_data_komen").on('click','.file_kirim_tl',function(){
|
|
var id = $(this).attr('id');
|
|
var idno = $(this).attr('idno');
|
|
var idnu = $(this).attr('idnu');
|
|
$('#modal_file').modal('show');
|
|
$('#modal_body_file').html("");
|
|
if (idno==idnu) {
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/tindaklanjut/upd_file.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_body_file').html(data);
|
|
$('#judul_modal_file').html('Add Lampiran File');
|
|
}
|
|
});
|
|
} else {
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/tindaklanjut/modal_vfile.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_body_file').html(data);
|
|
$('#judul_modal_file').html('View Lampiran File');
|
|
}
|
|
});
|
|
}
|
|
});
|
|
|
|
|
|
$("#tabel_data_komen").on('click','.teruskan_edit',function(){
|
|
$('#forward_tl').trigger('click');
|
|
});
|
|
</script>
|
|
|
|
|
|
|
|
|
|
|