Files
eletter-backup/app/kirim/modal_kepada.php
2024-06-06 05:45:02 +07:00

266 lines
11 KiB
PHP

<script type="text/javascript">
var sess_satker = $('#cek_satker').val();
</script>
<?php
include('../koneksi.php');
$surat_id = $_POST['id'];
$satuan_kerja_id = $_POST['satuan_kerja_id'];
?>
<input type="hidden" id="surat_idg" value="<?php echo $surat_id; ?>">
<input type="hidden" id="satuan_kerja_idg" value="<?php echo $satuan_kerja_id; ?>">
<form role="form">
<div class="form-group md_kpd">
<!--<label>Kepada</label>-->
<input type="text" class="form-control" list="browsers" name="browser" id="kepada_kr" Placeholder="Pilih tujuan..">
<datalist id="browsers">
<?php
//$userpeg=pg_query("SELECT id,nama FROM jabatan_pegawai ORDER BY id ASC");
/*$userpeg=pg_query("SELECT DISTINCT j.id,s.kode_satker,j.nama
FROM data_kepala k
INNER JOIN data_pegawai p ON (p.id=k.data_pegawai_id)
INNER JOIN jabatan_pegawai j ON (j.id=p.jabatan_pegawai_id)
INNER JOIN satuan_kerja s ON (s.id=p.satuan_kerja)
ORDER BY j.nama ASC
");*/
/*$userpeg=pg_query("SELECT DISTINCT j.id,s.kode_satker,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)
ORDER BY j.nama ASC");*/
$userpeg = pg_query($koneksi, "SELECT DISTINCT j.id, s.kode_satker, j.nama,
SPLIT_PART(CASE WHEN s.kode_satker='' THEN '999.0' ELSE s.kode_satker END,'.',1) AS kode1,
CAST(SPLIT_PART(CASE WHEN s.kode_satker='' THEN '999.0' ELSE s.kode_satker END,'.',2) AS INTEGER) AS kode2
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 LOWER(j.nama) NOT LIKE '%akun lama%' AND k.aktif='t'
ORDER BY kode1 ASC, kode2 ASC");
while ($rows = pg_fetch_array($userpeg)) {
?>
<?php
if (strpos($_SERVER['HTTP_USER_AGENT'], 'Chrome') !== false) {
?>
<option id_jab="<?php echo ($rows['id']); ?>" value="<?php echo $rows['kode1'] . ' - ' . $rows['nama']; ?>"></option>
<?php
} else if (strpos($_SERVER['HTTP_USER_AGENT'], 'Firefox') !== false) {
?>
<option id_jab="<?php echo ($rows['id']); ?>" value="<?php echo $rows['kode1'] . ' - ' . $rows['nama']; ?>"><?php echo $rows['kode1'] . ' - ' . $rows['nama']; ?></option>
<?php
}
}
?>
</datalist>
</div>
<button type="button" style="display:none" class="btn btn-success btn-block md_kpd" id="simpan_kepada_kr">Simpan</button>
</form>
<div class="row">
<div class="col-lg-6">
<button type="button" class="btn btn-default btn-block" id="kirim_semua"><i class="fa fa-arrow-down m-r-5"></i>SEMUA SATKER</button>
</div>
<div class="col-lg-6">
<button type="button" class="btn btn-default btn-block" id="clear_kepada"><i class="fa fa-remove m-r-5"></i>CLEAR LIST</button>
</div>
</div>
<br>
<div id="tabel_kepada_kr"></div>
<script>
$('#kepada_kr').focusin(function() {
var no_surat = $('#no_surat').val();
var perihal = $('#perihal').val();
if ((!no_surat) || (!perihal)) {
alert('No Surat dan Perihal harus ter-isi semua..');
$('#no_surat').focus();
} else {}
});
var surat_id = $('#surat_idg').val();
var satuan_kerja_id = $('#satuan_kerja_idg').val();
$('#tabel_kepada_kr').load('app/kirim/tabel_kepada.php', {
surat_id: surat_id,
satuan_kerja_id: satuan_kerja_id
});
$('#simpan_kepada_kr').click(function() {
var surat_id = $('#surat_idg').val();
var kepada_kr = $('#kepada_kr').val();
if (!kepada_kr) {
alert('Tentukan tujuannya..');
} else {
var imp3 = $("#kepada_kr").val();
var z3 = $('#browsers');
var val3 = $(z3).find('option[value="' + imp3 + '"]');
var kepada = val3.attr('id_jab');
var key = "simpan_kepada_kr";
$.ajax({
type: "POST",
url: "app/kirim/crud.php",
data: 'surat_id=' + surat_id +
'&kepada=' + kepada +
'&satuan_kerja_penginput=' + satuan_kerja_id +
'&key=' + key,
success: function(data) {
//alert('Data tersimpan..');
$('#kepada_kr').val('');
var sat = $('#sat').val();
var thn2 = $('#thn').val();
var bln2 = $('#bln').val();
if (sat == '172') {
$('#tabel_kirim').load("app/kirim/tabel.php", {
satker: sat,
jenis: sess_jenis,
sess_nama: sess_nama,
thn2: thn2,
bln2: bln2
});
var stk = sat;
} else {
$('#tabel_kirim').load("app/kirim/tabel.php", {
satker: sess_satker,
jenis: sess_jenis,
sess_nama: sess_nama,
thn2: thn2,
bln2: bln2
});
var stk = sess_satker;
}
$('#tabel_kepada_kr').load('app/kirim/tabel_kepada.php', {
surat_id: surat_id,
satuan_kerja_id: stk
});
var key = "jumlah_kepada";
$.ajax({
type: "POST",
url: "app/kirim/crud.php",
data: 'surat_id=' + surat_id +
'&satuan_kerja_id=' + stk +
'&key=' + key,
success: function(data) {
$('.sp' + surat_id).html(' (' + data + ')');
$('.xp' + surat_id).html(data);
$('#kepada_kr').first().focus().selected();
}
});
}
});
}
});
$('#kepada_kr').change(function() {
var kepada_kr = $('#kepada_kr').val();
if (!kepada_kr) {} else {
$('#simpan_kepada_kr').trigger('click');
}
});
$('#kirim_semua').click(function() {
var surat_id = $('#surat_idg').val();
var key = 'kirim_semua';
$.ajax({
type: "POST",
url: "app/kirim/crud.php",
data: 'surat_id=' + surat_id +
'&satuan_kerja_penginput=' + satuan_kerja_id +
'&key=' + key,
success: function(data) {
var sat = $('#sat').val();
var thn2 = $('#thn').val();
var bln2 = $('#bln').val();
if (sat == '172') {
$('#tabel_kirim').load("app/kirim/tabel.php", {
satker: sat,
jenis: sess_jenis,
sess_nama: sess_nama,
thn2: thn2,
bln2: bln2
});
var stk = sat;
} else {
$('#tabel_kirim').load("app/kirim/tabel.php", {
satker: sess_satker,
jenis: sess_jenis,
sess_nama: sess_nama,
thn2: thn2,
bln2: bln2
});
var stk = sess_satker;
}
$('#tabel_kepada_kr').load('app/kirim/tabel_kepada.php', {
surat_id: surat_id,
satuan_kerja_id: stk
});
var key = "jumlah_kepada";
$.ajax({
type: "POST",
url: "app/kirim/crud.php",
data: 'surat_id=' + surat_id +
'&satuan_kerja_id=' + stk +
'&key=' + key,
success: function(data) {
$('.sp' + surat_id).html(' (' + data + ')');
$('.xp' + surat_id).html(data);
$('#kepada_kr').first().focus().selected();
}
});
}
});
});
$('#clear_kepada').click(function() {
var x = confirm("Anda yakin ingin menghapus semuanya ?");
if (x) {
var surat_id = $('#surat_idg').val();
var key = 'clear_kepada';
$.ajax({
type: "POST",
url: "app/kirim/crud.php",
data: 'surat_id=' + surat_id +
'&satuan_kerja_penginput=' + satuan_kerja_id +
'&key=' + key,
success: function(data) {
var sat = $('#sat').val();
var thn2 = $('#thn').val();
var bln2 = $('#bln').val();
if (sat == '172') {
$('#tabel_kirim').load("app/kirim/tabel.php", {
satker: sat,
jenis: sess_jenis,
sess_nama: sess_nama,
thn2: thn2,
bln2: bln2
});
var stk = sat;
} else {
$('#tabel_kirim').load("app/kirim/tabel.php", {
satker: sess_satker,
jenis: sess_jenis,
sess_nama: sess_nama,
thn2: thn2,
bln2: bln2
});
var stk = sess_satker;
}
$('#tabel_kepada_kr').load('app/kirim/tabel_kepada.php', {
surat_id: surat_id,
satuan_kerja_id: stk
});
var key = "jumlah_kepada";
$.ajax({
type: "POST",
url: "app/kirim/crud.php",
data: 'surat_id=' + surat_id +
'&satuan_kerja_id=' + stk +
'&key=' + key,
success: function(data) {
$('.sp' + surat_id).html(' (' + data + ')');
$('.xp' + surat_id).html(data);
$('#kepada_kr').first().focus().selected();
}
});
}
});
} else {}
});
</script>