160 lines
8.8 KiB
PHP
160 lines
8.8 KiB
PHP
<?php
|
|
include('../../koneksi.php');
|
|
$satker=$_POST['satker'];
|
|
$jenis=$_POST['jenis'];
|
|
$surat_id=$_POST['surat_id'];
|
|
?>
|
|
<input type="hidden" value="<?php echo $surat_id; ?>" id="surat_id">
|
|
<script type="text/javascript">$("#tabel_data_arahan").DataTable({"stateSave": true,"paging": true,"lengthChange": false,"searching": false,"ordering": false,"info": true,"autoWidth": false});</script>
|
|
<table id="tabel_data_arahan" class="table table-striped table-condensed" cellpadding="1">
|
|
<thead style="color:black">
|
|
<tr>
|
|
<td width="120px;"><b>TGL-JAM MUTASI</b></td>
|
|
<td width="250px;"><b>TUJUAN</b></td>
|
|
<td width="120px;"><b>TGL-JAM PROSES</b></td>
|
|
<td><b>PROSES</b></td>
|
|
<td width="80px;"><b>TOOLS</b></td>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
$data=pg_query("SELECT k.tgl_diterima,k.jam_diterima,
|
|
(SELECT b.nama FROM satuan_kerja b WHERE b.id=k.satuan_kerja_tujuan),
|
|
k.dis_baca,
|
|
k.id,
|
|
k.satuan_kerja_penginput,
|
|
k.tgl_input,k.jam_input,
|
|
k.isi,
|
|
k.satuan_kerja_tujuan,
|
|
(SELECT MAX(id) FROM kirim WHERE surat_id='$surat_id' AND tgl_diterima IS NOT NULL),
|
|
k.proses_tu
|
|
FROM kirim k INNER JOIN surat s ON (k.surat_id=s.id)
|
|
WHERE k.surat_id='$surat_id'
|
|
AND k.tgl_diterima IS NOT NULL
|
|
ORDER BY k.id ASC
|
|
");
|
|
while($r=pg_fetch_array($data)) {
|
|
|
|
?>
|
|
<tr
|
|
<?php
|
|
if ($r['proses_tu']=='K') {echo "style='color:red'";} else {}
|
|
?>
|
|
>
|
|
<td class="kiri"><b><?php echo date('d-m-Y',strtotime($r['tgl_diterima'])).' '.date('H:i',strtotime($r['tgl_diterima'])); ?></b></td>
|
|
<td><b><?php echo $r[2]; ?></b></td>
|
|
<td><b><?php
|
|
if (($r['tgl_input']==NULL) || ($r['tgl_input']=='')) {} else {
|
|
echo date('d-m-Y H:i',strtotime($r['tgl_input'])); }
|
|
?></b></td>
|
|
<td><b><?php echo $r['isi']; ?></b></td>
|
|
<td class="kanan">
|
|
<?php if (($jenis=='Admin') || ($r[9]==$satker)) { ?>
|
|
<button type="button" name="edit_arahan" style="height:22px;" class="btn btn-teal btn-xs edit_arahan" id="<?php echo $r['id'];?>" data-content="Proses" rel="popover" data-placement="top" data-trigger="hover"
|
|
>
|
|
<i class="fa fa fa-pencil"></i>
|
|
</button>
|
|
<?php } if ($jenis=='Admin') { ?>
|
|
<button type="button" name="delete_arahan" style="height:22px;"class="btn btn-danger btn-xs delete_arahan" id="<?php echo $r['id'];?>" data-content="Hapus" rel="popover" data-placement="top" data-trigger="hover"
|
|
>
|
|
<i class="fa fa-remove"></i>
|
|
</button>
|
|
<?php } else {} ?>
|
|
|
|
<?php
|
|
if ($r['satuan_kerja_penginput']==$satker) {} else {
|
|
if ($r[4]==$r[10]) {
|
|
if ($r['proses_tu']==null) {
|
|
?>
|
|
<button type="button" name="koreksi_arahan" style="height:22px;"class="btn btn-inverse btn-xs koreksi_arahan" id="<?php echo $r['id'];?>" data-content="Koreksi" rel="popover" data-placement="top" data-trigger="hover"
|
|
>
|
|
<i class="fa fa-remove"></i>
|
|
</button>
|
|
<?php } else { ?>
|
|
<button type="button" name="koreksi_batal" style="height:22px;"class="btn btn-default btn-xs koreksi_batal" id="<?php echo $r['id'];?>" data-content="Batal koreksi" rel="popover" data-placement="top" data-trigger="hover"
|
|
>
|
|
<i class="fa fa-check"></i>
|
|
</button>
|
|
<?php } } } ?>
|
|
</td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
|
|
|
|
|
|
<script type="text/javascript">
|
|
var surat_id=$('#surat_id').val();
|
|
$('button[name="edit_arahan"]').popover();
|
|
$('button[name="delete_arahan"]').popover();
|
|
$('button[name="koreksi_arahan"]').popover();
|
|
$('button[name="koreksi_batal"]').popover();
|
|
|
|
$("#tabel_data_arahan").on('click','.koreksi_arahan',function(){
|
|
var id = $(this).attr('id');
|
|
var key = "koreksi_arahan";
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/kendali/arahan/crud.php",
|
|
data: 'id='+id
|
|
+'&key='+key,
|
|
success: function(data){
|
|
$('#tabel_arahan').load("app/kendali/arahan/tabel.php",{satker:sess_satker,jenis:sess_jenis,surat_id:surat_id});
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#tabel_data_arahan").on('click','.koreksi_batal',function(){
|
|
var id = $(this).attr('id');
|
|
var key = "koreksi_batal";
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/kendali/arahan/crud.php",
|
|
data: 'id='+id
|
|
+'&key='+key,
|
|
success: function(data){
|
|
$('#tabel_arahan').load("app/kendali/arahan/tabel.php",{satker:sess_satker,jenis:sess_jenis,surat_id:surat_id});
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#tabel_data_arahan").on('click','.edit_arahan',function(){
|
|
var id = $(this).attr('id');
|
|
$('#modal_arahan').modal('show');
|
|
$('#modal_body_arahan').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/kendali/arahan/modal.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_body_arahan').html(data);
|
|
$('#kepada').first().focus().selected();
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#tabel_data_arahan").on('click','.delete_arahan',function(){
|
|
var x = confirm("Anda yakin ingin menghapus ?");
|
|
if (x) {
|
|
var key = "delete_arahan";
|
|
var id = $(this).attr('id');
|
|
var rowElement = $(this).parent().parent();
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/kendali/arahan/crud.php",
|
|
data: 'id='+id
|
|
+'&key='+key,
|
|
success: function(data){
|
|
rowElement.fadeOut(500).remove();
|
|
$('#tabel_arahan').load("app/kendali/arahan/tabel.php",{satker:sess_satker,jenis:sess_jenis,surat_id:surat_id});
|
|
}
|
|
});
|
|
} else {}
|
|
});
|
|
|
|
</script>
|
|
|