445 lines
18 KiB
PHP
445 lines
18 KiB
PHP
<?php
|
|
include ('../koneksi.php');
|
|
$id=$_POST['id'];
|
|
if (($id==null) || ($id=='') || ($id==0)) {} else {
|
|
$d=pg_query("SELECT id,date_part('YEAR', tgl_diterima),no_kendali,perihal,
|
|
satuan_kerja_dari,
|
|
kode_id,
|
|
kepada,uraian,tgl_surat_keluar,tgl_kirim,tujuan_id,balasan,
|
|
(SELECT kode_satker FROM satuan_kerja WHERE id=satuan_kerja_dari),
|
|
(SELECT nama FROM satuan_kerja WHERE id=satuan_kerja_dari),
|
|
(SELECT kode FROM kode WHERE id=kode_id),
|
|
(SELECT keterangan FROM kode WHERE id=kode_id),
|
|
(SELECT tujuan FROM tujuan WHERE id=tujuan_id)
|
|
FROM surat WHERE id='$id'");
|
|
while($r=pg_fetch_array($d)) {
|
|
$id=$r[0];
|
|
$thn=$r[1];
|
|
$no_kendali2=$r[2];
|
|
$perihal=$r[3];
|
|
$pengolah=$r[4];
|
|
$kode_id=$r[5];
|
|
$kepada=$r[6];
|
|
$uraian=$r[7];
|
|
$tgl_surat_keluar=$r[8];
|
|
$tgl_kirim=$r[9];
|
|
$tujuan_id=$r[10];
|
|
$balasan=$r[11];
|
|
$kode_satker=$r[12];
|
|
$nama=$r[13];
|
|
$kode=$r[14];
|
|
$keterangan=$r[15];
|
|
$tujuan=$r[16];
|
|
}
|
|
if (($no_kendali2==null) || ($no_kendali2=='')) {
|
|
$no_kendali='';$kod='';
|
|
} else {
|
|
$no_pinjam=(int) substr($no_kendali2,0,5);
|
|
$no_kendali=sprintf("%05s",$no_pinjam);
|
|
}
|
|
$kod=$kode.' - '.$keterangan;
|
|
$pengolah2=$kode_satker.' / '.$nama;
|
|
}
|
|
|
|
$sat=$_POST['sess_jenis'];
|
|
$nm=$_POST['sess_nama'];
|
|
?>
|
|
|
|
|
|
<script type="text/javascript">
|
|
$('.date').datepicker({format: 'dd/mm/yyyy',todayHighlight:'TRUE',autoclose: true,orientation: 'top'});
|
|
|
|
</script>
|
|
|
|
<style type="text/css">
|
|
.no-border{
|
|
border:none;
|
|
}
|
|
</style>
|
|
|
|
<form role="form">
|
|
|
|
<div class="form-group">
|
|
<label>Tahun</label>
|
|
<input type="text" class="form-control" id="thn_ser" value="<?php echo $thn; ?>">
|
|
</div>
|
|
<div class="form-group">
|
|
<label>No Kendali</label>
|
|
<input type="text" class="form-control" id="no_kendali_ser" value="<?php echo $no_kendali; ?>">
|
|
</div>
|
|
|
|
|
|
<hr>
|
|
<h4>Add Sertifikat</h4>
|
|
<br>
|
|
|
|
<div class="form-group">
|
|
<label>Perihal</label>
|
|
<input type="text" class="form-control" id="perihal_ser" value="<?php echo $perihal; ?>">
|
|
</div>
|
|
<div class="form-group">
|
|
<label>Pengolah</label>
|
|
<input type="hidden" class="form-control" list="browsers2_ser" name="browser2_ser" id="pengolahid_ser" value="<?php echo $pengolah; ?>">
|
|
<input type="text" class="form-control" list="browsers2_ser" name="browser2_ser" id="pengolah_ser" value="<?php echo $pengolah2; ?>">
|
|
<datalist id="browsers2_ser">
|
|
<?php
|
|
$userpeg=pg_query("SELECT * FROM satuan_kerja WHERE kode_satker IS NOT NULL ORDER BY id ASC");
|
|
/*$userpeg=pg_query("SELECT *,
|
|
SPLIT_PART(CASE WHEN kode_satker='' THEN '0.0' ELSE kode_satker END,'.',1),
|
|
CAST(SPLIT_PART(CASE WHEN kode_satker='' THEN '0.0' ELSE kode_satker END,'.',2) AS INTEGER)
|
|
FROM satuan_kerja
|
|
WHERE kode_satker !=''
|
|
ORDER BY
|
|
SPLIT_PART(CASE WHEN kode_satker='' THEN '0.0' ELSE kode_satker END,'.',1) ASC,
|
|
CAST(SPLIT_PART(CASE WHEN kode_satker='' THEN '0.0' ELSE kode_satker END,'.',2) AS INTEGER) ASC
|
|
");*/
|
|
while($rows=pg_fetch_array($userpeg)) {
|
|
?>
|
|
<?php
|
|
if(strpos($_SERVER['HTTP_USER_AGENT'], 'Chrome') !== false) {
|
|
?>
|
|
<option id_jab2_ser="<?php echo($rows['id']);?>" value="<?php echo $rows[2].' - '.$rows[1]; ?>"></option>
|
|
<?php
|
|
} else
|
|
if(strpos($_SERVER['HTTP_USER_AGENT'], 'Firefox') !== false) {
|
|
?>
|
|
<option id_jab2_ser="<?php echo($rows['id']);?>" value="<?php echo $rows[2].' - '.$rows[1]; ?>"><?php echo $rows[2].' - '.$rows[1]; ?></option>
|
|
<?php
|
|
}
|
|
}
|
|
?>
|
|
</datalist>
|
|
</div>
|
|
|
|
<input type="hidden" id="surat_id_ser" value="<?php echo $id; ?>">
|
|
|
|
|
|
|
|
|
|
<div class="form-group sm-tgl_surat">
|
|
<label>Kode Surat</label>
|
|
<input type="text" class="form-control" list="browsers_ser" name="browser_ser" id="kode_id_ser" value="<?php echo $kod; ?>">
|
|
<datalist id="browsers_ser">
|
|
<?php
|
|
$userpeg=pg_query("SELECT * FROM kode ORDER BY id ASC");
|
|
while($rows=pg_fetch_array($userpeg)) {
|
|
?>
|
|
<?php
|
|
if(strpos($_SERVER['HTTP_USER_AGENT'], 'Chrome') !== false) {
|
|
?>
|
|
<option id_jab_ser="<?php echo($rows['id']);?>" value="<?php echo $rows[1].' - '.$rows[2]; ?>"></option>
|
|
<?php
|
|
} else
|
|
if(strpos($_SERVER['HTTP_USER_AGENT'], 'Firefox') !== false) {
|
|
?>
|
|
<option id_jab_ser="<?php echo($rows['id']);?>" value="<?php echo $rows[1].' - '.$rows[2]; ?>"><?php echo $rows[1].' - '.$rows[2]; ?></option>
|
|
<?php
|
|
}
|
|
}
|
|
?>
|
|
</datalist>
|
|
</div>
|
|
<div class="form-group">
|
|
<label>Tujuan Surat</label>
|
|
<input type="text" class="form-control" list="browsers4_ser" name="browser4_ser" id="tujuan_id_ser" value="<?php echo $tujuan; ?>">
|
|
<datalist id="browsers4_ser">
|
|
<?php
|
|
$userpeg=pg_query("SELECT * FROM tujuan ORDER BY id ASC");
|
|
while($rows=pg_fetch_array($userpeg)) {
|
|
?>
|
|
<?php
|
|
if(strpos($_SERVER['HTTP_USER_AGENT'], 'Chrome') !== false) {
|
|
?>
|
|
<option id_jab4_ser="<?php echo($rows['id']);?>" value="<?php echo $rows[1]; ?>"></option>
|
|
<?php
|
|
} else
|
|
if(strpos($_SERVER['HTTP_USER_AGENT'], 'Firefox') !== false) {
|
|
?>
|
|
<option id_jab4_ser="<?php echo($rows['id']);?>" value="<?php echo $rows[1]; ?>"><?php echo $rows[1]; ?></option>
|
|
<?php
|
|
}
|
|
}
|
|
?>
|
|
</datalist>
|
|
</div>
|
|
|
|
|
|
<div class="form-group">
|
|
<label for="exampleInputEmail1">Tgl Surat Keluar</label>
|
|
<input type="text" class="date form-control" id="tgl_surat_keluar_ser" placeholder="dd/mm/yyyy"
|
|
onkeyup="
|
|
var v = this.value;
|
|
if (v.match(/^\d{2}$/) !== null) {
|
|
this.value = v + '/';
|
|
} else if (v.match(/^\d{2}\/\d{2}$/) !== null) {
|
|
this.value = v + '/';
|
|
}
|
|
"
|
|
value="<?php
|
|
$tpk=date('d-m-Y',strtotime($tgl_surat_keluar));
|
|
if (($tpk=="01-01-1970") || ($tpk==NULL) || ($tpk=="")) {
|
|
echo "";
|
|
} else {
|
|
echo date('d/m/Y',strtotime($tpk));
|
|
}
|
|
?>"
|
|
>
|
|
</div>
|
|
|
|
<hr>
|
|
<h4>Add Kepada</h4>
|
|
<br>
|
|
|
|
|
|
<div class="form-group">
|
|
<label for="exampleInputEmail1">Nama Pegawai</label>
|
|
<input type="text" class="form-control" list="browsers_nm_ser" name="browser" id="user_nama_nm_ser" value="<?php echo $nama; ?>">
|
|
<datalist id="browsers_nm_ser">
|
|
<?php
|
|
$userpeg=pg_query("SELECT p.nama,p.id,s.nama
|
|
FROM data_pegawai p
|
|
INNER JOIN satuan_kerja s ON (s.id=p.satuan_kerja)
|
|
WHERE p.aktif='t'
|
|
ORDER BY p.nama ASC");
|
|
while($rows=pg_fetch_array($userpeg)) {
|
|
?>
|
|
|
|
<?php
|
|
if(strpos($_SERVER['HTTP_USER_AGENT'], 'Chrome') !== false) {
|
|
?>
|
|
<option id_ms_pegawai2_nm_ser="<?php echo($rows['id']);?>" value="<?php echo $rows[0]; ?>"><?php echo $rows[2]; ?></option>
|
|
<?php
|
|
} else
|
|
if(strpos($_SERVER['HTTP_USER_AGENT'], 'Firefox') !== false) {
|
|
?>
|
|
<option id_ms_pegawai2_nm_ser="<?php echo($rows['id']);?>" value="<?php echo $rows[0]; ?>"><?php echo $rows[0].' ------ '.$rows[2]; ?></option>
|
|
<?php
|
|
}
|
|
}
|
|
?>
|
|
</datalist>
|
|
</div>
|
|
|
|
|
|
<button type="button" class="btn btn-success btn-block md_kpd" id="simpan_kepada_ser">Simpan</button>
|
|
|
|
</form>
|
|
<!--<br>
|
|
<div id="tabel_kepada_ser"></div>-->
|
|
<script type="text/javascript">
|
|
|
|
function angka(e) {
|
|
if (!/^[0-9\.,()-/\a-zA-Z \b]+$/.test(e.value)) {
|
|
e.value = e.value.substring(0,e.value.length-1);
|
|
}
|
|
}
|
|
|
|
$("#perihal_ser").keyup(function(){
|
|
angka(this);
|
|
});
|
|
|
|
|
|
$('#no_kendali_ser').focusout(function(){
|
|
var no_kendali=$('#no_kendali_ser').val();
|
|
if (no_kendali) {
|
|
var thn=$('#thn_ser').val();
|
|
var key='cari_kendali';
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/skeluar/crud.php",
|
|
data: 'thn='+thn
|
|
+'&no_kendali='+no_kendali
|
|
+'&key='+key,
|
|
success: function(data){
|
|
if (data=='^#*^#*^#*00000^#*') {
|
|
$('#surat_id_ser').val('');
|
|
$('#no_kendali_ser').val('');
|
|
$('#perihal_ser').val('');
|
|
$('#pengolah_ser').val('');
|
|
$('#kode_id_ser').val('');
|
|
$('#kepada_ser').val('');
|
|
$('#uraian_ser').val('');
|
|
$('#tgl_surat_keluar_ser').val('');
|
|
$('#tgl_kirim_ser').val('');
|
|
$('#tujuan_id_ser').val('');
|
|
$('#balasan_ser').val('');
|
|
$('#pengolah_ser').prop('disabled',false);
|
|
$('#perihal_ser').prop('disabled',false);
|
|
} else {
|
|
var inp=data.split('^#*');
|
|
var w = inp[5];
|
|
if (w=='-') {
|
|
var x = confirm("Nomor kendali sudah digunakan untuk sertifikat.. ?");
|
|
$('#no_kendali_ser').val('');
|
|
$('#no_kendali_ser').first().focus().selected();
|
|
} else {
|
|
$('#perihal_ser').val(inp[0]);
|
|
$('#pengolah_ser').val(inp[1]+' / '+inp[2]);
|
|
$('#no_kendali_ser').val(inp[3]);
|
|
$('#surat_id_ser').val(inp[4]);
|
|
$('#pengolah_ser').prop('disabled',true);
|
|
$('#perihal_ser').prop('disabled',true);
|
|
}
|
|
}
|
|
}
|
|
});
|
|
} else {}
|
|
});
|
|
|
|
|
|
$("#pengolah_ser").change(function(){
|
|
var satuan_kerja_dari2 = $('#pengolah_ser').val();
|
|
var z32 = $('#browsers2_ser');
|
|
var val32 = $(z32).find('option[value="' + satuan_kerja_dari2 + '"]');
|
|
var e = val32.attr('id_jab2_ser');
|
|
var key = "list_tujuan";
|
|
if (!e) {
|
|
alert('Satuan kerja tidak terdaftar..');
|
|
$('#pengolah_ser').val('');
|
|
$('#pengolah_ser').first().focus().selected();
|
|
} else {
|
|
}
|
|
});
|
|
|
|
$("#kode_id_ser").change(function(){
|
|
var imp3 = $("#kode_id_ser").val();
|
|
var z3 = $('#browsers_ser');
|
|
var val3 = $(z3).find('option[value="' + imp3 + '"]');
|
|
var g = val3.attr('id_jab_ser');
|
|
var key = "list_kode";
|
|
if (!g) {
|
|
alert('Kode tidak terdaftar..');
|
|
$('#kode_id_ser').val('');
|
|
$('#kode_id_ser').first().focus().selected();
|
|
} else {
|
|
}
|
|
});
|
|
$("#tujuan_id_ser").focusin(function(){
|
|
var imp3 = $("#kode_id_ser").val();
|
|
var z3 = $('#browsers_ser');
|
|
var val3 = $(z3).find('option[value="' + imp3 + '"]');
|
|
var g = val3.attr('id_jab_ser');
|
|
if (!g) {
|
|
$('#kode_id_ser').first().focus().selected();
|
|
}
|
|
});
|
|
|
|
|
|
|
|
$("#tujuan_id_ser").change(function(){
|
|
var imp4 = $("#tujuan_id_ser").val();
|
|
var z4 = $('#browsers4_ser');
|
|
var val4 = $(z4).find('option[value="' + imp4 + '"]');
|
|
var h = val4.attr('id_jab4_ser');
|
|
var key = "list_tujuan";
|
|
if (!h) {
|
|
alert('Satuan kerja tidak terdaftar..');
|
|
$('#tujuan_id_ser').val('');
|
|
$('#tujuan_id_ser').first().focus().selected();
|
|
} else {
|
|
}
|
|
});
|
|
$("#balasan_ser").focusin(function(){
|
|
var imp4 = $("#tujuan_id_ser").val();
|
|
var z4 = $('#browsers4_ser');
|
|
var val4 = $(z4).find('option[value="' + imp4 + '"]');
|
|
var h = val4.attr('id_jab4_ser');
|
|
if (!h) {$('#tujuan_id_ser').first().focus().selected();}
|
|
});
|
|
/*
|
|
$("#user_nama_nm_ser").change(function(){
|
|
var nm_kpd = $('#user_nama_nm_ser').val();
|
|
var znm = $('#browsers_nm_ser');
|
|
var valnm = $(znm).find('option[value="' + nm_kpd + '"]');
|
|
var ea = valnm.attr('id_ms_pegawai2_nm_ser');
|
|
var key = "list_kepada";
|
|
if (!ea) {
|
|
alert('Pegawai tidak terdaftar..');
|
|
$('#user_nama_nm_ser').val('');
|
|
$('#user_nama_nm_ser').first().focus().selected();
|
|
} else {
|
|
}
|
|
});
|
|
*/
|
|
|
|
|
|
|
|
var surat_id = $('#surat_id_ser').val();
|
|
var uraian = $('#perihal_ser').val();
|
|
//$('#tabel_kepada_ser').load('app/skeluar/tabel_kepada_ser.php',{surat_id:surat_id, uraian:uraian});
|
|
|
|
$('#simpan_kepada_ser').click(function(){
|
|
var surat_id2 = $('#surat_id_ser').val();
|
|
if (!surat_id2) {surat_id='0';} else {surat_id=surat_id2;}
|
|
|
|
var imp3 = $("#kode_id_ser").val();
|
|
var z3 = $('#browsers_ser');
|
|
var val3 = $(z3).find('option[value="' + imp3 + '"]');
|
|
var kode_id = val3.attr('id_jab_ser');
|
|
|
|
|
|
var kepada = $('#user_nama_nm_ser').val();
|
|
var uraian = $('#perihal_ser').val();
|
|
|
|
var tgl_surat_keluar = $('#tgl_surat_keluar_ser').val();
|
|
|
|
var imp4 = $("#tujuan_id_ser").val();
|
|
var z4 = $('#browsers4_ser');
|
|
var val4 = $(z4).find('option[value="' + imp4 + '"]');
|
|
var tujuan_id = val4.attr('id_jab4_ser');
|
|
|
|
var perihal = $('#perihal_ser').val();
|
|
|
|
var satuan_kerja_dari2 = $('#pengolah_ser').val();
|
|
var z32 = $('#browsers2_ser');
|
|
var val32 = $(z32).find('option[value="' + satuan_kerja_dari2 + '"]');
|
|
var satuan_kerja_daris = val32.attr('id_jab2_ser');
|
|
|
|
if (!satuan_kerja_daris) {
|
|
var satuan_kerja_dari = $('#pengolahid_ser').val();
|
|
} else {
|
|
var satuan_kerja_dari=satuan_kerja_daris;
|
|
}
|
|
|
|
var no_kendali = $('#no_kendali').val();
|
|
if (!no_kendali) {
|
|
var j = 'smasuk';
|
|
} else {
|
|
var j = 'kndl';
|
|
}
|
|
|
|
var key="simpan_kepada_ser";
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/skeluar/crud.php",
|
|
data: 'surat_id='+surat_id
|
|
+'&kode_id='+kode_id
|
|
+'&kepada='+kepada
|
|
+'&uraian='+uraian
|
|
+'&tgl_surat_keluar='+tgl_surat_keluar
|
|
+'&tujuan_id='+tujuan_id
|
|
+'&satuan_kerja_id='+sess_satker
|
|
+'&satuan_kerja_dari='+satuan_kerja_dari
|
|
+'&perihal='+perihal
|
|
+'&j='+j
|
|
+'&key='+key,
|
|
success: function(data){alert(data);
|
|
alert('Data tersimpan..');
|
|
var co = $('#no_kendali_ser').val();
|
|
if (!co) {
|
|
$('#user_nama_nm_ser').val('');
|
|
} else {
|
|
$('#modal_sertifikat').modal('hide');
|
|
$('body').removeClass('modal-open');
|
|
$('.modal-backdrop').remove();
|
|
}
|
|
$('#tabel_skeluar').load("app/skeluar/tabel.php",{satker:sess_satker,jenis:sess_jenis,sess_nama:sess_nama});
|
|
}
|
|
});
|
|
});
|
|
|
|
|
|
</script>
|
|
|
|
|