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 Editing($va) { $vaLevel = scSys::GetKeterangan("Kode,Keterangan,Isi", "Kode = '{$va['cKode']}'", "username_level"); Load($va['cKode']); echo ' $("#cKeterangan").val("' . $vaLevel['Keterangan'] . '") ; $("#nLevel").val("' . $vaLevel['Kode'] . '") ; '; }
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") ; '; } }
$vaTtd[] = array("x" => "", "1" => ""); $vaTtd[] = array("x" => "", "1" => ""); $vaTtd[] = array("x" => "", "1" => "<u>" . $vaPejabat["nama"] . "</u>"); $vaTtd[] = array("x" => "", "1" => $vaPejabat_Gol['Description']); $vaTtd[] = array("" => "", "1" => "NIP : " . $vaPejabat["nip"]); $vaDasar = array(); $vaDate = scDate::Date2Var($dbRow['letter_date']); $vaDasar[] = array("1" => "Dasar", "2" => ":", "3" => $dbRow['letter_content']); $vaKepada = array(); $nRow = 1; $vaKepada[] = array("1" => "Kepada", "2" => ":", "3" => $nRow++ . ".", "4" => "Nama", "5" => ":", "6" => $vaLeader['nama']); $vaKepada[] = array("1" => "", "2" => "", "3" => "", "4" => "Pangkat / gol", "5" => ":", "6" => $vaLeader_Gol['Description'] . " / " . $vaLeader_Gol['Title']); $vaKepada[] = array("1" => "", "2" => "", "3" => "", "4" => "NIP", "5" => ":", "6" => $vaLeader['nip']); $vaKepada[] = array("1" => "", "2" => "", "3" => "", "4" => "Jabatan", "5" => ":", "6" => $vaLeader['jabatan']); foreach ($vaPengikut as $key => $vaData) { $vaPengikut_Gol = scSys::GetKeterangan("Title,Description", "Id = '{$vaData['golongan']}'", "sc_master"); $vaKepada[] = array("1" => "", "2" => "", "3" => $nRow++ . ".", "4" => "Nama", "5" => ":", "6" => $vaData['nama']); $vaKepada[] = array("1" => "", "2" => "", "3" => "", "4" => "Pangkat / gol", "5" => ":", "6" => $vaPengikut_Gol['Description'] . " / " . $vaPengikut_Gol['Title']); $vaKepada[] = array("1" => "", "2" => "", "3" => "", "4" => "NIP", "5" => ":", "6" => $vaData['nip']); $vaKepada[] = array("1" => "", "2" => "", "3" => "", "4" => "Jabatan", "5" => ":", "6" => $vaData['jabatan']); } $vaUntuk = array(); $vaUntuk[] = array("1" => "Untuk", "2" => ":", "3" => $dbRow['purpose']); $nFont = 11; $pdf = new Cezpdf("A4", "P", $vaOpt, '0'); $pdf->ezImage(scSys::GetConfig("sc_header"), false, 100, 600); $pdf->ezTable($vaTable1, "", "", array("showLines" => 0, "showHeadings" => 0, "fontSize" => $nFont, "cols" => array("x" => array("width" => 60, "wrap" => 1), "1" => array("width" => 20, "wrap" => 1), "2" => array("width" => 2), "3" => array("width" => 18, "wrap" => 1)))); $pdf->ezText(""); $pdf->ezText("<u><b>PERINTAH PERJALANAN DINAS</b></u>", $nFont + 2, array("justification" => "center")); $pdf->ezText("(SPPD)", $nFont + 2, array("justification" => "center")); $pdf->ezText("");
<?php $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();
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'] . '") ; } '; } }
public static function CheckKode($cFileLoc, $cTable, $cTableId, $lAllow = false) { global $scDb; $vaReturn = array("Id" => "", "Pesan" => ""); $cWhere = !$lAllow ? " and (Status <> '2' and Status <> '4' and Status <> '5') " : ""; $dbRow = scSys::GetKeterangan("Id,UserName_Maker,StatusOnView", "TableName = '{$cTable}' and TableId = '{$cTableId}' " . $cWhere, "sc_access_input"); $vaReturn['Id'] = $dbRow['Id']; $vaAccess = self::GetLvAccess($cFileLoc); if ($vaAccess['lMaker']) { if (GetSession("cSession_UserName") !== $dbRow['UserName_Maker']) { $vaReturn['Pesan'] .= "Maaf Transaksi sudah dikerjakan oleh" . '\\n' . scSys::GetKeteranganOne("FullName", "UserName = '******'UserName_Maker']}'", "username") . '\\n' . "Dan sedang menunggu persetujuan Terimakasih"; } } return $vaReturn; }