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;
}
