<?php
session_start();
include "koneksi.php";
include "fungsi.php";
$pesan = 0;
selesaiDispSK($_POST["id_disposisi"]);
if (isset($_POST["terima"])) {
$ds_sk = mysql_fetch_array(mysql_query("SELECT * FROM myapp_maintable_suratkeluar WHERE id='" . $_POST["id_surat_keluar"] . "'"));
$peneken_nota = $_SESSION["id_level"];
if ($ds_sk["id_ttd"] == 1 || $ds_sk["id_ttd"] == 4) {
mysql_query("UPDATE myapp_maintable_suratkeluar SET no_nodin='" . nomor_nodin($peneken_nota, date("Y")) . "', tgl_nodin=CURDATE() WHERE id='" . $_POST["id_surat_keluar"] . "'");
}
if ($ds_sk["id_ttd"] == 4) {
mysql_query("UPDATE myapp_maintable_suratkeluar SET status=2 WHERE id='" . $_POST["id_surat_keluar"] . "'");
} else {
pushDispSK(anti_injection($_POST["id_surat_keluar"]), $_SESSION["id_level"], 2, anti_injection($_POST["catatan"]), 1);
}
header("location:../?mod=inform&pesan=30&redir=posisi_surat_keluar_kabid");
} else {
if (isset($_POST["tolak"])) {
$ds_id_dis = mysql_fetch_array(mysql_query("SELECT * FROM myapp_disptable_suratkeluar WHERE id='" . $_POST["id_disposisi"] . "'"));
pushDispSK(anti_injection($_POST["id_surat_keluar"]), $_SESSION["id_level"], levelBawahan(anti_injection($_POST["id_surat_keluar"]), 3), anti_injection($_POST["catatan"]), 2);
header("location:../?mod=inform&pesan=31&redir=posisi_surat_keluar_kabid");
}
}
}
// AMBIL noreg SURAT MASUK DAN KEMUDIAN UPDATE NOREG NYA DENGAN MENAMBAHKAN !
$ds_noreg = mysql_fetch_array(mysql_query("SELECT * FROM myapp_consttable_noreg WHERE id=1"));
$noreg = $ds_noreg["reg_sk"];
mysql_query("UPDATE myapp_consttable_noreg SET reg_sk=reg_sk+1 WHERE id=1");
$sql = "INSERT INTO myapp_maintable_suratkeluar (id, no_surat, tgl_surat, tgl_kirim, perihal_surat, tujuan_surat, alamat_tujuan, judul_surat, deskripsi_surat, catatan, id_skpd_tujuan, id_masalah, id_jenis_surat, id_level_pembuat, status, asal_disposisi, tujuan_disposisi, id_pengguna_pembuat, id_ttd, no_nodin, tgl_nodin, noreg) VALUES \n (NULL, '{$_POST['no_surat']}', '{$_POST['tgl_surat']}', '{$_POST['tgl_kirim']}', '{$_POST['perihal_surat']}', '{$_POST['tujuan_surat']}', '{$_POST['alamat_tujuan']}', '{$_POST['judul_surat']}', '{$_POST['deskripsi_surat']}', '{$_POST['catatan']}', '{$_POST['id_skpd_tujuan']}', '{$_POST['id_masalah']}', '{$_POST['id_jenis_surat']}', '{$_SESSION['id_level']}', 1, '{$_SESSION['id_level']}', '{$_SESSION['atasan']}', '{$_SESSION['id_pengguna']}', '{$_POST['id_ttd']}', '', CURDATE(), '" . $noreg . "')";
mysql_query($sql);
// MENCARI ID SURAT KELUAR YANG BARU DIMASUKKAN
$ds_id_max = mysql_fetch_array(mysql_query("SELECT MAX(id) AS id FROM myapp_maintable_suratkeluar"));
// PUSH KEDALAM myapp_disptable_suratkeluar
if ($_SESSION["id_level"] == 20 || $_SESSION["id_level"] == 21 || $_SESSION["id_level"] == 22 || $_SESSION["id_level"] == 23 || $_SESSION["id_level"] == 25) {
pushDispSK($ds_id_max["id"], $_SESSION["id_level"], $_POST["kasubbid"], "Surat keluar telah dibuat", 1, $_SESSION["id_pengguna"]);
} else {
if ($_SESSION["id_level"] >= 3 && $_SESSION["id_level"] <= 6) {
pushDispSK($ds_id_max["id"], $_SESSION["id_level"], 2, "Surat keluar telah dibuat", 1, $_SESSION["id_pengguna"]);
} else {
if ($_SESSION["id_level"] >= 7 && $_SESSION["id_level"] <= 17) {
pushDispSK($ds_id_max["id"], $_SESSION["id_level"], $_SESSION["atasan"], "Surat keluar telah dibuat", 1, $_SESSION["id_pengguna"]);
}
}
}
// PUSH KEDALAM DATA SURAT BALASAN
$id_surat_keluar = $ds_id_max["id"];
mysql_query("INSERT INTO myapp_maintable_balasan(id_surat_masuk, id_surat_keluar)\n SELECT id_surat_masuk, '" . $id_surat_keluar . "' FROM myapp_sessiontable_balasan WHERE session_id = '" . session_id() . "'");
// HAPUS TEMPORARY SURAT BALASAN
mysql_query("DELETE FROM myapp_sessiontable_balasan WHERE session_id='" . session_id() . "'");
//echo($sql);
header("location:../?mod=inform&pesan=12&redir=file_surat_keluar&id=" . $ds_id_max["id"]);
} else {
header("location:../?mod=buat_surat_keluar&err=Maaf, input anda belum lengkap. Masalah, Sub Masalah, Peneken Surat, Serta Tujuan disposisi kasubbid/kasubbag harus diisi");
}
<?php
session_start();
include "koneksi.php";
include "fungsi.php";
$pesan = 0;
selesaiDispSK($_POST["id_disposisi"]);
if (isset($_POST["terima"])) {
//pushDispSK($_POST["id_surat_keluar"], $_SESSION["id_level"], 1, $_POST["catatan"], 1);
$ds_sk = mysql_fetch_array(mysql_query("SELECT * FROM myapp_maintable_suratkeluar WHERE id='" . $_POST["id_surat_keluar"] . "'"));
$peneken_nota = 1;
if ($ds_sk["id_ttd"] == 2 || $ds_sk["id_ttd"] == 3) {
mysql_query("UPDATE myapp_maintable_suratkeluar SET no_nodin='" . nomor_nodin($peneken_nota, date("Y")) . "', tgl_nodin=CURDATE() WHERE id='" . $_POST["id_surat_keluar"] . "'");
}
mysql_query("UPDATE myapp_maintable_suratkeluar SET status=2 WHERE id='" . $_POST["id_surat_keluar"] . "'");
header("location:../?mod=inform&pesan=34&redir=posisi_surat_keluar_kaban");
} else {
if (isset($_POST["tolak"])) {
$ds_id_dis = mysql_fetch_array(mysql_query("SELECT * FROM myapp_disptable_suratkeluar WHERE id='" . $_POST["id_disposisi"] . "'"));
pushDispSK($_POST["id_surat_keluar"], $_SESSION["id_level"], 2, $_POST["catatan"], 2);
header("location:../?mod=inform&pesan=35&redir=posisi_surat_keluar_kaban");
}
}
<?php
session_start();
include "koneksi.php";
include "fungsi.php";
$pesan = 0;
selesaiDispSK($_POST["id_disposisi"]);
if (isset($_POST["terima"])) {
pushDispSK($_POST["id_surat_keluar"], $_SESSION["id_level"], $_SESSION["atasan"], $_POST["catatan"], 1);
header("location:../?mod=inform&pesan=27&redir=posisi_surat_keluar_kasubbid");
} else {
if (isset($_POST["tolak"])) {
$ds_id_dis = mysql_fetch_array(mysql_query("SELECT * FROM myapp_disptable_suratkeluar WHERE id='" . $_POST["id_disposisi"] . "'"));
pushDispSK($_POST["id_surat_keluar"], $_SESSION["id_level"], levelBawahan($_POST["id_surat_keluar"], 4), $_POST["catatan"], 2, $_SESSION["id_pengguna"], levelBawahan($_POST["id_surat_keluar"], 4, 1));
header("location:../?mod=inform&pesan=28&redir=posisi_surat_keluar_kasubbid");
}
}
<?php
session_start();
include "koneksi.php";
include "fungsi.php";
$pesan = 0;
selesaiDispSK($_POST["id_disposisi"]);
if (isset($_POST["terima"])) {
$ds_id_dis = mysql_fetch_array(mysql_query("SELECT * FROM myapp_disptable_suratkeluar WHERE id='" . $_POST["id_disposisi"] . "'"));
//function pushDispSK($id_surat_keluar, $id_level_asal, $id_level_tujuan, $catatan, $keadaan, $id_pengguna_asal=0, $id_pengguna_tujuan=0){
pushDispSK($_POST["id_surat_keluar"], $_SESSION["id_level"], $ds_id_dis["id_level_asal"], $_POST["catatan"], 1, $_SESSION["id_pengguna"]);
header("location:../?mod=inform&pesan=29&redir=posisi_surat_keluar_staff");
} else {
if (isset($_POST["benerin"])) {
$ds_id_dis = mysql_fetch_array(mysql_query("SELECT * FROM myapp_disptable_suratkeluar WHERE id='" . $_POST["id_disposisi"] . "'"));
//function pushDispSK($id_surat_keluar, $id_level_asal, $id_level_tujuan, $catatan, $keadaan, $id_pengguna_asal=0, $id_pengguna_tujuan=0){
pushDispSK($_POST["id_surat_keluar"], $_SESSION["id_level"], $ds_id_dis["id_level_asal"], $_POST["catatan"], 1, $_SESSION["id_pengguna"]);
header("location:../?mod=edit_surat_keluar&id=" . $_POST["id_surat_keluar"]);
}
}
