$ugbd = array(); $sql_ugbd = "SELECT\n \ta.*, b.id_pangkat\n FROM\n \ttbl_usulan_satya_lancana_detail a\n \tLEFT JOIN tbl_pegawai b ON a.id_pegawai = b.id_pegawai\n WHERE\n \tid_detail_satya_lencana='" . $_GET["id_detail_satya_lancana"] . "'"; $res_ugbd = mysql_query($sql_ugbd); $ds_ugbd = mysql_fetch_array($res_ugbd); $ugbd["id_detail_satya_lancana"] = $ds_ugbd["id_detail_satya_lencana"]; $ugbd["id_usulan"] = $ds_ugbd["id_usulan"]; $ugbd["id_sk"] = $ds_ugbd["id_sk"]; $ugbd["id_pegawai"] = $ds_ugbd["id_pegawai"]; $ugbd["status"] = $ds_ugbd["status"]; $ugbd["jenis_satya"] = $ds_ugbd["jenis_satya"]; $ugbd["id_pangkat"] = $ds_ugbd["id_pangkat"]; $ugbd["pangkat"] = apa_pangkat($ds_ugbd["id_pangkat"]); echo "var ugbd = " . json_encode($ugbd) . ";\n"; // DATA : sk_satya_lancana require_once "php/model/sk_satya_lancana_model.php"; $obj = new SKSatyaLancana_Model(); $obj->Record($ugbd["id_sk"]); $sk["id_sk"] = $obj->id_usulan; $sk["no_sk"] = $obj->no_usulan; $sk["tgl_sk"] = $obj->tgl_usulan; $sk["jabatan_ttd_sk"] = $obj->jabatan_ttd_usulan; $sk["nama_ttd_sk"] = $obj->nama_ttd_usulan; $sk["nip_ttd_sk"] = $obj->nip_ttd_usulan; $sk["id_pangkat_ttd_sk"] = $obj->id_pangkat_ttd_usulan; echo "var sk = " . json_encode($sk) . ";\n"; ?> </script> <!-- END OF CONTROLLER --> <!-- JAVASCRIPT PAGE --> <script type="text/javascript">
<?php
session_start();
include "../koneksi.php";
include "../fungsi.php";
require_once "../model/sk_satya_lancana_model.php";
$obj = new SKSatyaLancana_Model();
$obj->Record($_GET["id_usulan"]);
$obj->Delete();
$sql = "UPDATE tbl_usulan_satya_lancana_detail SET id_sk=null, status='1' WHERE id_sk='" . $_GET["id_usulan"] . "'";
mysql_query($sql);
header("location:../../?mod=sl_daftar_sk");
//echo("Data usulan telah disimpan");
<!-- CONTROLLER -->
<script type="text/javascript">
<?php
require_once "php/model/sk_satya_lancana_model.php";
$pangkat = array();
$sql_pangkat = "SELECT * FROM ref_pangkat";
$res_pangkat = mysql_query($sql_pangkat);
while ($ds_pangkat = mysql_fetch_array($res_pangkat)) {
$row_pangkat["id_pangkat"] = $ds_pangkat["id_pangkat"];
$row_pangkat["gol_ruang"] = $ds_pangkat["gol_ruang"];
$row_pangkat["pangkat"] = $ds_pangkat["pangkat"];
array_push($pangkat, $row_pangkat);
}
echo "var pangkat = " . json_encode($pangkat) . ";\n";
$obj = new SKSatyaLancana_Model();
$obj->Record($_GET["id_usulan"]);
$record["id_usulan"] = $obj->id_usulan;
$record["no_usulan"] = $obj->no_usulan;
$record["tgl_usulan"] = $obj->tgl_usulan;
$record["jabatan_ttd_usulan"] = $obj->jabatan_ttd_usulan;
$record["nama_ttd_usulan"] = $obj->nama_ttd_usulan;
$record["nip_ttd_usulan"] = $obj->nip_ttd_usulan;
$record["id_pangkat_ttd_usulan"] = $obj->id_pangkat_ttd_usulan;
echo "var record = " . json_encode($record) . ";\n";
?>
</script>
<!-- END OF CONTROLLER -->
<!-- JAVASCRIPT PAGE -->
<script type="text/javascript">
<?php
session_start();
include "../koneksi.php";
include "../fungsi.php";
require_once "../model/sk_satya_lancana_model.php";
function something_wrong($what_is_wrong)
{
echo "\n <script type='text/javascript'>\n window.parent.window.something_wrong(\"" . $what_is_wrong . "\");\n </script>\n ";
}
function success()
{
echo "\n <script type='text/javascript'>\n window.parent.window.success();\n </script>\n ";
}
$obj = new SKSatyaLancana_Model();
$obj->no_usulan = $_POST["no_usulan"];
$obj->tgl_usulan = $_POST["tgl_usulan"];
$obj->jabatan_ttd_usulan = $_POST["jabatan_ttd_usulan"];
$obj->nama_ttd_usulan = $_POST["nama_ttd_usulan"];
$obj->nip_ttd_usulan = $_POST["nip_ttd_usulan"];
$obj->id_pangkat_ttd_usulan = $_POST["id_pangkat_ttd_usulan"];
$obj->status = 1;
$validation_result = $obj->Validation();
if ($validation_result == "") {
$obj->Insert();
success();
} else {
something_wrong($validation_result);
}
//echo("Data usulan telah disimpan");
<?php
session_start();
include "../koneksi.php";
include "../fungsi.php";
require_once "../model/sk_satya_lancana_model.php";
function something_wrong($what_is_wrong)
{
echo "\n <script type='text/javascript'>\n window.parent.window.something_wrong(\"" . $what_is_wrong . "\");\n </script>\n ";
}
function success()
{
echo "\n <script type='text/javascript'>\n window.parent.window.success();\n </script>\n ";
}
$obj = new SKSatyaLancana_Model();
$obj->Record($_POST["id_usulan"]);
$obj->no_usulan = $_POST["no_usulan"];
$obj->tgl_usulan = $_POST["tgl_usulan"];
$obj->jabatan_ttd_usulan = $_POST["jabatan_ttd_usulan"];
$obj->nama_ttd_usulan = $_POST["nama_ttd_usulan"];
$obj->nip_ttd_usulan = $_POST["nip_ttd_usulan"];
$obj->id_pangkat_ttd_usulan = $_POST["id_pangkat_ttd_usulan"];
$validation_result = $obj->Validation();
if ($validation_result == "") {
$obj->Update();
success();
} else {
something_wrong($validation_result);
}
//echo("Data usulan telah disimpan");
<?php
ob_start();
session_start();
require_once "../../../php/dompdf_config.inc.php";
require_once "../../../php/koneksi.php";
require_once "../../../php/fungsi.php";
require_once "../../../php/model/sk_satya_lancana_model.php";
date_default_timezone_set("America/New_York");
/* CONTROLLER */
$sk = new SKSatyaLancana_Model();
$sk->Record($_GET["id_usulan"]);
$no_sk = $sk->no_usulan == "" ? " " : $sk->no_usulan;
$tgl_sk = $sk->tgl_usulan == "0000-00-00" ? " " : tglpjgindonesia($sk->tgl_usulan);
$daftar = array();
$sql_daftar = "SELECT\n \ta.id_pegawai, a.nama_pegawai, a.nip,\n \tCASE\n \t\tWHEN a.gelar_depan <> '' THEN CONCAT(a.gelar_depan, '. ')\n \t\tELSE ''\n \tEND AS gelar_depan,\n \tCASE\n \t\tWHEN a.gelar_belakang <> '' THEN CONCAT(', ', a.gelar_belakang)\n \t\tELSE ''\n \tEND AS gelar_belakang,\n \tb.status_kepegawaian, c.jenis_kepegawaian, d.kedudukan_kepegawaian,\n \te.jenis_kelamin, a.alamat, a.tanggal_lahir, f.skpd, g.pangkat, g.gol_ruang, h.jabatan,\n \ti.id_detail_satya_lencana, i.jenis_satya, i.status\n FROM\n \ttbl_pegawai a\n \tLEFT JOIN ref_status_kepegawaian b ON a.id_status_kepegawaian = b.id_status_kepegawaian\n \tLEFT JOIN ref_jenis_kepegawaian c ON a.id_jenis_kepegawaian = c.id_jenis_kepegawaian\n \tLEFT JOIN ref_kedudukan_kepegawaian d ON a.id_kedudukan_kepegawaian = d.id_kedudukan_kepegawaian\n \tLEFT JOIN ref_jenis_kelamin e ON a.id_jenis_kelamin = e.id_jenis_kelamin\n \tLEFT JOIN ref_skpd f ON a.id_satuan_organisasi = f.id_skpd\n \tLEFT JOIN ref_pangkat g ON a.id_pangkat = g.id_pangkat\n \tLEFT JOIN ref_jabatan h ON a.id_jabatan = h.id_jabatan\n \tINNER JOIN tbl_usulan_satya_lancana_detail i ON (a.id_pegawai = i.id_pegawai AND i.id_sk = '" . $_GET["id_usulan"] . "')\n ORDER BY\n \ti.id_detail_satya_lencana ASC";
$res_daftar = mysql_query($sql_daftar);
while ($ds_daftar = mysql_fetch_array($res_daftar)) {
$row_daftar["nama_pegawai"] = $ds_daftar["nama_pegawai"];
$row_daftar["gelar_depan"] = $ds_daftar["gelar_depan"];
$row_daftar["gelar_belakang"] = $ds_daftar["gelar_belakang"];
$row_daftar["nip"] = $ds_daftar["nip"];
$row_daftar["pangkat"] = $ds_daftar["pangkat"];
$row_daftar["gol_ruang"] = $ds_daftar["gol_ruang"];
$row_daftar["jabatan"] = $ds_daftar["jabatan"];
$row_daftar["jenis_satya"] = $ds_daftar["jenis_satya"];
array_push($daftar, $row_daftar);
}
/* END OF CONTROLLER */
$html = "<div style='font-family: sans-serif; font-size: 9pt;'>";
$html .= "<div style='height: 1cm;'> </div>";
