function Editing($va)
{
$code = $va['code'];
$dbRow = scSys::GetKeterangan("*", "code = '{$code}'", "sppd");
if (!empty($dbRow)) {
echo '
with(OBJFORM_NEW.trsppd_laporan.Obj){
find("#purpose").html("' . $dbRow['purpose'] . '") ;
find("#place_to").html("' . $dbRow['place_to'] . '") ;
find("#length_journey").html("' . $dbRow['length_journey'] . ' (' . scSys::Terbilang($dbRow['length_journey']) . ') hari") ;
find("#date_go").html("' . scDate::String2Date($dbRow['date_go']) . '") ;
find("#result").val("' . scSys::CheckText($dbRow['result']) . '") ;
find("#result").focus() ;
}
';
if ($dbRow['result'] !== "") {
//echokan
$cButton = '<button type="button" class="btn btn-success" style="display:inline-block"
id="cmdCetak" name="cmdCetak"
onclick="OBJFORM_NEW.trsppd_laporan.Print("' . $va['code'] . '")">Cetak</button>';
echo '
OBJFORM_NEW.trsppd_laporan.Obj
.find("#wrapPrint").html("' . scSys::CheckText($cButton) . '") ;
';
}
}
}
function Grid1_Load($va)
{
global $scDb;
$cUserName = GetSession("cSession_UserName");
$cLv_Admin = scSys::GetConfig("sc_admin");
$cLv = GetSession("cSession_SCLevel");
$cLimit = $va['offset'] . "," . $va['limit'];
//limit
$vaOrder = array();
if (isset($va['sort'])) {
unset($va['sort'][13]);
unset($va['sort'][14]);
foreach ($va['sort'] as $key => $vaValue) {
$vaOrder[] = $vaValue['field'] . " " . $vaValue['direction'];
}
}
$cOrder = implode(",", $vaOrder);
if ($cOrder == "") {
$cOrder = "status ASC";
}
//init order grid
$dTglAwal = scDate::Date2String($va['dTglAwal']);
$dTglAkhir = scDate::Date2String($va['dTglAkhir']);
$cWhere_opt = "";
if ($va['optStatusF'] !== "-") {
$cWhere_opt = " AND status = '{$va['optStatusF']}' ";
}
$vaWhere = array();
if (isset($va['search'])) {
unset($va['search'][13]);
unset($va['search'][14]);
foreach ($va['search'] as $key => $vaValue) {
$vaWhere[] = $vaValue['field'] . " like '%" . $vaValue['value'] . "%'";
}
}
//init where grid
$cWhere = "date >= '{$dTglAwal}' AND date <= '{$dTglAkhir}' " . $cWhere_opt . (!empty($vaWhere) ? " AND (" . implode(" OR ", $vaWhere) . ")" : "");
$vaReturn = array();
$dbData = $scDb->Browse("sppd", "*", $cWhere, "", "", $cOrder, $cLimit);
$dbDataNL = $scDb->Browse("sppd", "*", $cWhere);
while ($dbRow = $scDb->GetRow($dbData)) {
$dbRow['recid'] = $dbRow['code'];
$cStatus = $dbRow['status'];
$dbRow['code'] = '<a class="a-click" onClick="OBJFORM_NEW.trsppd.Print(\'' . $dbRow['recid'] . '\')">' . $dbRow['recid'] . '</a>';
$dbRow['code'] = html_entity_decode($dbRow['code']);
$dbRow['status'] = html_entity_decode(sppd::GetStatus($dbRow['status'], true));
$dbRow['date'] = scDate::String2Date($dbRow['date']);
$dbRow['date_go'] = scDate::String2Date($dbRow['date_go']);
$dbRow['date_back'] = scDate::String2Date($dbRow['date_back']);
$dbRow['letter_date'] = scDate::String2Date($dbRow['letter_date']);
$dbRow['nip_pejabat'] = scSys::GetKeteranganOne("nama", "nip = '{$dbRow['nip_pejabat']}'", "pegawai");
$dbRow['nip_leader'] = scSys::GetKeteranganOne("nama", "nip = '{$dbRow['nip_leader']}'", "pegawai");
$dbRow['username'] = scSys::GetKeteranganOne("FullName", "UserName = '******'username']}'", "username");
$vaReturn[] = $dbRow;
}
$vaReturn = array("total" => $scDb->Rows($dbDataNL), "records" => $vaReturn);
echo json_encode($vaReturn);
}
function LoadSPPD_Pelaporan($va)
{
global $scDb;
$cUserName = GetSession("cSession_UserName");
$cLv_Admin = scSys::GetConfig("sc_admin");
$cLv = GetSession("cSession_SCLevel");
$cNip = GetSession("cSession_UserName_Target");
$cSearch = $va['cSearch'];
$vaArray = array();
$cWhere = strpos($cLv_Admin, $cLv) === false ? "code LIKE '%{$cSearch}%' AND (nip_leader = '{$cNip}')" : "code LIKE '%{$cSearch}%'";
$dbData = $scDb->Browse("sppd", "code,date", $cWhere);
while ($dbRow = $scDb->GetRow($dbData)) {
$vaArray[] = array("id" => $dbRow['code'], "text" => $dbRow['code'] . " pada tanggal " . scDate::String2Date($dbRow['date']));
}
if (empty($vaArray)) {
$vaArray[] = array("id" => "scnull", "text" => "Tidak ditemukan");
}
echo json_encode($vaArray);
}
$vaPengikut[] = scSys::GetKeterangan("nama,golongan,jabatan,nip", "nip = '{$value}'", "pegawai");
}
}
$vaTable2 = array();
$vaTable2[] = array("1" => "1.", "2" => "Pejabat yang memberi perintah", "3" => ": " . $vaPejabat['jabatan']);
$vaTable2[] = array("1" => "2.", "2" => "Nama Pegawai yang diperintah", "3" => ": " . $vaLeader['nama']);
$vaTable2[] = array("1" => "3.", "2" => "a. Pangkat dan Golongan", "3" => ": " . $vaLeader_Gol['Description'] . " / " . $vaLeader_Gol['Title']);
$vaTable2[] = array("1" => "", "2" => "b. Jabatan", "3" => ": " . $vaLeader['jabatan']);
$vaTable2[] = array("1" => "", "2" => "c. Tingkat menurut peraturan perjalanan", "3" => ": " . $dbRow['rate_travel']);
$vaTable2[] = array("1" => "4.", "2" => "Maksud Perjalanan Dinas", "3" => ": " . $dbRow['purpose']);
$vaTable2[] = array("1" => "5.", "2" => "Alat yang dipergunakan", "3" => ": " . $dbRow['transport']);
$vaTable2[] = array("1" => "6.", "2" => "a. Tempat Berangkat", "3" => ": " . $dbRow['place_from']);
$vaTable2[] = array("1" => "", "2" => "b. Tempat Tujuan", "3" => ": " . $dbRow['place_to']);
$vaTable2[] = array("1" => "7.", "2" => "a. Lamanya Perjalanan Dinas", "3" => ": " . $dbRow['length_journey'] . " (" . scSys::Terbilang($dbRow['length_journey']) . ") hari");
$vaTable2[] = array("1" => "", "2" => "b. Tanggal Berangkat", "3" => ": " . scDate::String2Date($dbRow['date_go']));
$vaTable2[] = array("1" => "", "2" => "b. Tanggal Harus Kembali", "3" => ": " . scDate::String2Date($dbRow['date_back']));
$nRow = 1;
foreach ($vaPengikut as $key => $vaData) {
$vaKu = array("1" => "", "2" => "", "3" => "");
if ($key == 0) {
$vaKu["1"] = "8.";
$vaKu["2"] = "Pengikut";
}
$vaKu["3"] = ": " . $nRow++ . ". " . $vaData['nama'] . "\n Nip." . $vaData['nip'];
$vaTable2[] = $vaKu;
}
$vaTable2[] = array("1" => "9.", "2" => "Pembebanan Anggaran", "3" => "");
$vaTable2[] = array("1" => "", "2" => "a. Instansi", "3" => ": " . $dbRow['government']);
$vaTable2[] = array("1" => "", "2" => "a. Mata Anggaran", "3" => ": " . $dbRow['budget_from']);
$vaTable2[] = array("1" => "10.", "2" => "Keterangan Lain-Lain", "3" => ": " . $dbRow['description']);
$vaDate = scDate::Date2Var($dbRow['date']);
$code = $_GET['code'];
$dbRow = scSys::GetKeterangan("*", "code = '{$code}'", "sppd");
if (!empty($dbRow)) {
$vaPejabat = scSys::GetKeterangan("nama,golongan,jabatan,nip", "nip = '{$dbRow['nip_pejabat']}'", "pegawai");
$vaPejabat_Gol = scSys::GetKeterangan("Title,Description", "Id = '{$vaPejabat['golongan']}'", "sc_master");
$vaLeader = scSys::GetKeterangan("nama,golongan,jabatan,nip", "nip = '{$dbRow['nip_leader']}'", "pegawai");
$vaLeader_Gol = scSys::GetKeterangan("Title,Description", "Id = '{$vaLeader['golongan']}'", "sc_master");
$vaPengikut = array();
foreach (explode(",", $dbRow['nip']) as $key => $value) {
if ($value !== "") {
$vaPengikut[] = scSys::GetKeterangan("nama,golongan,jabatan,nip", "nip = '{$value}'", "pegawai");
}
}
$vaTable1 = array();
$vaTable1[] = array("1" => "Kepada", "2" => ":", "3" => $vaPejabat['nama']);
$vaTable1[] = array("1" => "Tanggal", "2" => ":", "3" => scDate::String2Date($dbRow['result_date']));
$vaTable1[] = array("1" => "Perihal", "2" => ":", "3" => "Laporan Hasil perjalanan Dinas ke " . $dbRow['place_to']);
$vaTable2 = array();
$vaTable2[] = array("1" => "Nama / NIP", "2" => ":", "3" => $vaLeader['nama']);
$vaTable2[] = array("1" => "Pangkat / Gol", "2" => ":", "3" => $vaLeader_Gol['Description'] . " / " . $vaLeader_Gol['Title']);
$vaTable2[] = array("1" => "Jabatan", "2" => ":", "3" => $vaLeader['jabatan']);
$vaDate = scDate::Date2Var($dbRow['date_go']);
$vaTable3 = array();
$vaTable3[] = array("1" => "1.", "2" => "Maksud dan Tujuan", "3" => ":", "4" => $dbRow['purpose']);
$vaTable3[] = array("1" => "2.", "2" => "Tempat yang dituju", "3" => ":", "4" => $dbRow['place_to']);
$vaTable3[] = array("1" => "3.", "2" => "Untuk Selama", "3" => ":", "4" => $dbRow['length_journey'] . " (" . scSys::Terbilang($dbRow['length_journey']) . ") hari");
$vaTable3[] = array("1" => "4.", "2" => "Berangkat Tanggal", "3" => ":", "4" => $vaDate["Tgl"] . " " . $vaDate['Bulan'] . " " . $vaDate['Tahun']);
$vaDate = scDate::Date2Var($dbRow['result_date']);
$vaTtd = array();
$vaTtd[] = array("x" => "", "1" => "Singosari, " . $vaDate["Tgl"] . " " . $vaDate['Bulan'] . " " . $vaDate['Tahun']);
$vaTtd[] = array("x" => "", "1" => "PETUGAS");
function Editing($va)
{
$cKode = $va['code'];
$dbRow = scSys::GetKeterangan("*", "code = '{$cKode}'", "sppd");
if (!empty($dbRow)) {
$vaNip_Pejabat = array("id" => $dbRow['nip_pejabat'], "text" => scSys::GetKeteranganOne("nama", "nip = '{$dbRow['nip_pejabat']}'", "pegawai"));
$vaNip_Leader = array("id" => $dbRow['nip_leader'], "text" => scSys::GetKeteranganOne("nama", "nip = '{$dbRow['nip_leader']}'", "pegawai"));
$vaNip = array();
foreach (explode(",", $dbRow['nip']) as $key => $value) {
$vaNip[] = array("id" => $value, "text" => scSys::GetKeteranganOne("nama", "nip = '{$value}'", "pegawai"));
}
$dbRow['date_go'] = scDate::String2Date($dbRow['date_go']);
$dbRow['date_back'] = scDate::String2Date($dbRow['date_back']);
echo '
with(OBJFORM_NEW.trsppd.Obj){
find("#code").val("' . $cKode . '") ;
find("#letter_content").val("' . $dbRow['letter_content'] . '") ;
find("#nip_pejabat").select2("data",' . json_encode($vaNip_Pejabat) . ') ;
find("#nip_leader").select2("data",' . json_encode($vaNip_Leader) . ') ;
find("#rate_travel").val("' . $dbRow['rate_travel'] . '") ;
find("#nip").select2("data",' . json_encode($vaNip) . ') ;
find("#purpose").val("' . $dbRow['purpose'] . '") ;
find("#transport").val("' . $dbRow['transport'] . '") ;
find("#place_from").val("' . $dbRow['place_from'] . '") ;
find("#place_to").val("' . $dbRow['place_to'] . '") ;
find("#length_journey").val("' . $dbRow['length_journey'] . '") ;
find("#date_go").val("' . $dbRow['date_go'] . '") ;
find("#date_back").val("' . $dbRow['date_back'] . '") ;
find("#government").val("' . $dbRow['government'] . '") ;
find("#budget_from").val("' . $dbRow['budget_from'] . '") ;
find("#description").val("' . $dbRow['description'] . '") ;
}
';
}
}
function Editing($va)
{
$cNip = $va['cNip'];
$dbRow = scSys::GetKeterangan("*", "nip = '{$cNip}'", "pegawai");
if (!empty($dbRow)) {
$vaNip = array("id" => $dbRow['nip'], "text" => $dbRow['nip']);
$vaGolongan = scSys::GetKeterangan("Title,Description", "Id = '{$dbRow['golongan']}'", "sc_master");
$vaGolongan = array("id" => $dbRow['golongan'], "text" => $vaGolongan['Description'] . " / " . $vaGolongan['Title']);
echo '
with(OBJFORM_NEW.mstpegawai.Obj){
find("#cNip").select2("data",' . json_encode($vaNip) . ') ;
find("#cNip").select2("readonly",true) ;
find("#cNama").val("' . $dbRow['nama'] . '") ;
find("#cAlamat").val("' . $dbRow['alamat'] . '") ;
find("#cTempat").val("' . $dbRow['tempat_lahir'] . '") ;
find("#dTempat_Tgl").val("' . scDate::String2Date($dbRow['tanggal_lahir']) . '") ;
find("#cGolongan").val("' . $dbRow['golongan'] . '") ;
find("#dGolongan_Tgl").val("' . scDate::String2Date($dbRow['golongan_tanggal']) . '") ;
find("#cJabatan").val("' . $dbRow['jabatan'] . '") ;
find("#dJabatan_Tgl").val("' . scDate::String2Date($dbRow['jabatan_tanggal']) . '") ;
find("#nKerjaTahun").val("' . $dbRow['kerja_tahun'] . '") ;
find("#nKerjaBulan").val("' . $dbRow['kerja_bulan'] . '") ;
find("#cJabatan_Lat").val("' . $dbRow['latihan_jabatan'] . '") ;
find("#dJabatan_Lat_Tgl").val("' . scDate::String2Date($dbRow['latihan_jabatan_tanggal']) . '") ;
find("#nJabatan_Lat").val("' . $dbRow['latihan_jabatan_jam'] . '") ;
find("#cPendidikan").val("' . $dbRow['pendidikan'] . '") ;
find("#nThLulus").val("' . $dbRow['pendidikan_lulus'] . '") ;
find("#cIjazah").val("' . $dbRow['pendidikan_ijazah'] . '") ;
find("#cCatatan_Mutasi").val("' . $dbRow['catatan_mutasi'] . '") ;
find("#cKeterangan").val("' . $dbRow['keterangan'] . '") ;
find("#cno_hp").val("' . $dbRow['no_hp'] . '") ;
}
$("#myTabs li:eq(1) a").tab("show") ;
';
}
}
<?php
$vaData = array();
$dbData = $scDb->Browse("pegawai", "*");
$nRow = 1;
$vaData[] = array("NO" => 1, "NAMA" => 2, "NIP" => 3, "ALAMAT" => "", "PANGKAT;GOLONGAN / RUANG" => 4, "PANGKAT;TMT" => 5, "JABATAN;NAMA" => 6, "JABATAN;TMT" => 7, "MASA KERJA;THN" => 8, "MASA KERJA;BLN" => 9, "LATIHAN JABATAN;NAMA" => 10, "LATIHAN JABATAN;TGL LULUS" => 11, "LATIHAN JABATAN;JML JAM" => 12, "PENDIDIKAN;NAMA" => 13, "PENDIDIKAN;TAHUN LULUS" => 14, "PENDIDIKAN;TK IJAZAH" => 15, "TEMPAT TANGGAL LAHIR" => 16, "CATATAN MUTASI" => 17, "KETERANGAN" => 18);
while ($dbRow = $scDb->GetRow($dbData)) {
$vaData[] = array("NO" => $nRow++, "NAMA" => $dbRow['nama'], "NIP" => $dbRow['nip'], "ALAMAT" => $dbRow['alamat'], "PANGKAT;GOLONGAN / RUANG" => $dbRow['golongan'], "PANGKAT;TMT" => scDate::String2Date($dbRow['golongan_tanggal']), "JABATAN;NAMA" => $dbRow['jabatan'], "JABATAN;TMT" => scDate::String2Date($dbRow['jabatan_tanggal']), "MASA KERJA;THN" => $dbRow['kerja_tahun'], "MASA KERJA;BLN" => $dbRow['kerja_bulan'], "LATIHAN JABATAN;NAMA" => $dbRow['latihan_jabatan'], "LATIHAN JABATAN;TGL LULUS" => scDate::String2Date($dbRow['latihan_jabatan_tanggal']), "LATIHAN JABATAN;JML JAM" => $dbRow['latihan_jabatan_jam'], "PENDIDIKAN;NAMA" => $dbRow['pendidikan'], "PENDIDIKAN;TAHUN LULUS" => $dbRow['pendidian_lulus'], "PENDIDIKAN;TK IJAZAH" => $dbRow['pendidikan_ijazah'], "TEMPAT TANGGAL LAHIR" => $dbRow['tempat_lahir'] . " " . scDate::String2Date($dbRow['tanggal_lahir']), "CATATAN MUTASI" => $dbRow['catatan_mutasi'], "KETERANGAN" => $dbRow['ketrangan']);
}
$vaDate = scDate::Date2Var(date("Y-m-d"));
$nFont = 8;
$pdf = new Cezpdf("A3", "L", $vaOpt);
$pdf->ezHeader("<b>UNIT KERJA : DINAS KEHUTANAN DAN PERKEBUNAN KAB. PATI</b>", array("fontSize" => $nFont + 2));
$pdf->ezHeader("<b>KEADAAN : BULAN " . $vaDate['Bulan'] . " " . $vaDate['Tahun'] . "</b>", array("fontSize" => $nFont + 2));
$pdf->ezHeader("");
$pdf->ezTable($vaData, "", "", array("fontSize" => $nFont, "cols" => array("NO" => array("width" => 2, "justification" => "center"), "NAMA" => array("width" => 8, "wrap" => 1), "NIP" => array("width" => 8, "wrap" => 1, "justification" => "center"), "ALAMAT" => array("wrap" => 1), "PANGKAT;GOLONGAN / RUANG" => array("width" => 7, "wrap" => 1), "PANGKAT;TMT" => array("width" => 4, "wrap" => 1, "justification" => "center"), "JABATAN;NAMA" => array("width" => 7, "wrap" => 1), "JABATAN;TMT" => array("width" => 4, "wrap" => 1, "justification" => "center"), "MASA KERJA;THN" => array("width" => 3, "wrap" => 1, "justification" => "center"), "MASA KERJA;BLN" => array("width" => 3, "wrap" => 1, "justification" => "center"), "LATIHAN JABATAN;NAMA" => array("width" => 7, "wrap" => 1), "LATIHAN JABATAN;TGL LULUS" => array("width" => 5, "wrap" => 1, "justification" => "center"), "LATIHAN JABATAN;JML JAM" => array("width" => 4, "wrap" => 1, "justification" => "center"), "PENDIDIKAN;NAMA" => array("width" => 7, "wrap" => 1), "PENDIDIKAN;TAHUN LULUS" => array("width" => 4, "wrap" => 1, "justification" => "center"), "PENDIDIKAN;TK IJAZAH" => array("width" => 4, "wrap" => 1, "justification" => "center"), "TEMPAT TANGGAL LAHIR" => array("width" => 7, "wrap" => 1), "CATATAN MUTASI" => array("width" => 5, "wrap" => 1), "KETERANGAN" => array("width" => 5, "wrap" => 1))));
$pdf->ezStream();
