function Check($va)
{
global $scDb;
$cUserName = strtolower($va['cUser']);
$cPassword = $va['cPassword'];
$cPassword = scCrypt::CryptPass($cPassword);
$dbData = $scDb->Browse("username", "*", "UserName = '******' and Password like '{$cPassword}%'");
if ($dbRow = $scDb->GetRow($dbData)) {
$cNama = "Administrator";
SaveSession("cSession_UserName", $cUserName);
SaveSession("cSession_FullName", $dbRow['FullName']);
SaveSession("cSession_Foto", $dbRow['Foto']);
SaveSession("cSession_UserName_Target", $dbRow['UserName_Target']);
//new sc levelup
$cLevel = scCrypt::GetLevelPass($dbRow['Password']);
SaveSession("cSession_SCLevel", $cLevel);
SaveSession("cSession_SCLevelmd5", scSys::GetKeteranganOne("Isi", "Kode = '{$cLevel}'", "username_level"));
//update login and last login
$vaArray = array("LastLogin" => date("Y-m-d h:i:s"));
$scDb->Edit("username", $vaArray, "UserName = '******' and Password like '{$cPassword}%'");
SaveSession("bismillahauth", md5(time() . $cUserName));
//reload me
echo '
window.location = "./" ;
';
} else {
echo '
$("#login.panel .panel-body .error").slideDown(800,function(){
$(this).html("User or Password not found") ;
}) ;
';
}
}
function GetData($va)
{
global $scDb;
$cKode = $va['cUserName'];
$dbData = $scDb->Browse("username", "*", "UserName = '******'");
if ($dbRow = $scDb->GetRow($dbData)) {
$cLevel = scCrypt::GetLevelPass($dbRow['Password']);
$UserName_Target = "";
if ($dbRow['UserName_Target'] !== "") {
$UserName_Target = array("id" => $dbRow['UserName_Target'], "text" => scSys::GetKeteranganOne("nama", "nip = '{$dbRow['UserName_Target']}'", "pegawai"));
}
echo '
with(document.oForm){
cUserName.value = "' . $dbRow['UserName'] . '" ;
cUserName.readOnly = 1 ;
cFullName.value = "' . $dbRow['FullName'] . '" ;
}
$("#UserName_Target").select2("data",' . json_encode($UserName_Target) . ')
$("#cUserName").select2("data",{id: "' . $dbRow['UserName'] . '", text: "' . $dbRow['UserName'] . '"}) ;
$("#cLevel").select2("data",{id: "' . $cLevel . '", text: "' . $cLevel . '"}) ;
';
} else {
echo '
alert("Data not found ' . $cKode . '") ;
scLoadPage("sc-content-load","sys/sysuser_grid.php") ;
';
}
}
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 SetDefine()
{
//set define harus dipanggil setiap saat karena define jika direload akan hilang
//ex define("sapeltu","isi",true) ;
//location
if (!defined("SYS_Url")) {
define("SYS_Url", scSys::GetConfig("sc_front_url"));
}
if (!defined("SYS_UrlCore")) {
define("SYS_UrlCore", SYS_Url . "sapeltucore/");
}
if (!defined("SYS_UrlImages")) {
define("SYS_UrlImages", SYS_Url . "/uploaded/");
}
if (!defined("SYS_Title")) {
define("SYS_Title", scSys::GetConfig("sc_front_title"));
}
if (!defined("SYS_ImgHeader")) {
define("SYS_ImgHeader", scSys::GetConfig("sc_header"));
}
if (!defined("SYSCORE_VER")) {
define("SYSCORE_VER", "0.0.1");
}
if (!defined("SYCORE_MAIL")) {
define("SYCORE_MAIL", "SMTP");
}
//pdf setup
if (!defined('PDF_MARGIN_FOOTER')) {
define('PDF_MARGIN_FOOTER', 10);
}
if (!defined('PDF_MARGIN_TOP')) {
define('PDF_MARGIN_TOP', 10);
}
if (!defined('PDF_MARGIN_BOTTOM')) {
define('PDF_MARGIN_BOTTOM', 10);
}
if (!defined('PDF_MARGIN_LEFT')) {
define('PDF_MARGIN_LEFT', 13);
}
if (!defined('PDF_MARGIN_RIGHT')) {
define('PDF_MARGIN_RIGHT', 7);
}
if (!defined('SYSCORE_VER')) {
define('SYSCORE_VER', '0.0.2');
}
if (GetSession("scDatabase") == "") {
SCDatabase();
SaveSession("scDatabase", "oke");
}
}
function Load($nLevel)
{
$cIsi = scSys::GetKeteranganOne("Isi", "Kode = '{$nLevel}'", "username_level");
$cTreeMenu = scSys::GetTreeMenu($cIsi);
echo ' var oTree = ' . $cTreeMenu . ' ;
$("#sc-sys-tree-uesrlevel").dynatree("getRoot").removeChildren() ;
$("#sc-sys-tree-uesrlevel").dynatree("getRoot").addChild(oTree) ;
var selKeys = $("#sc-sys-tree-uesrlevel").dynatree("getSelectedNodes") ;
selKeys = $.map(selKeys,function(node){
return node.data.key ;
}) ;
$("#cLevel").val(selKeys.join(", "));
';
}
function GetData($va)
{
global $scDb;
$dTglAwal = $va['dTglAwal'] !== "" ? $va['dTglAwal'] : date("Y-m-d");
$dTglAKhir = $va['dTglAKhir'] !== "" ? $va['dTglAKhir'] : date("Y-m-d");
$dTglAwal = scDate::Date2String($dTglAwal);
$dTglAKhir = scDate::Date2String($dTglAKhir);
$cUser = $va['cUser'];
$nLimit = (int) $va['nLimit'];
$cSearch = $va['cSearch'];
$cWhere = "DATE_FORMAT(LogWaktu,'%Y-%m-%d') >= '{$dTglAwal}' and DATE_FORMAT(LogWaktu,'%Y-%m-%d') <= '{$dTglAKhir}'";
if ($cUser !== "") {
$cWhere .= " and LogKeterangan like '%{$cUser}%'";
}
if ($cSearch !== "") {
$cWhere .= " and (LogKeterangan like '%{$cSearch}%' or LogTable like '%{$cSearch}%' or LogCrud like '%{$cSearch}%')";
}
//oCrudBodyTable
$dbData = $scDb->Browse("sc_config_log", "*", $cWhere, "", "", "Id desc", "0," . $nLimit);
$cTable = "";
while ($dbRow = $scDb->GetRow($dbData)) {
$vaContent = unserialize($dbRow['LogKeterangan']);
if (!isset($vaContent['Sql'])) {
$vaContent['Sql'] = $dbRow['LogSQL'];
}
if (!isset($vaContent['Username'])) {
$vaContent['Username'] = $dbRow['LogUserName'];
}
$cRawSQL = rawurlencode($vaContent['Sql']);
$cUserName = scSys::GetKeteranganOne("FullName", "UserName = '******'Username']}'", "username");
$cUserName = $cUserName == "" ? "System page Login" : $cUserName;
$cTable .= '<tr>';
$cTable .= ' <td>' . date("d-m-Y h:i:s", strtotime($dbRow['LogWaktu'])) . '</td>';
$cTable .= ' <td>' . $dbRow['LogCrud'] . '</td>';
$cTable .= ' <td>' . $dbRow['LogTable'] . '</td>';
$cTable .= ' <td>' . $cUserName . '</td>';
$cTable .= ' <td>' . DetectKeterangan($vaContent['Sql']) . ' [' . $dbRow['LogIp'] . ']</td>';
$cTable .= ' <td align=\\"center\\"><button onClick=\\"ViewSQL("' . $cRawSQL . '")\\" class=\\"btn btn-primary\\"><i class=\\"fa fa-stack-exchange\\"></i></button></td>';
$cTable .= '</tr>';
}
echo '
$("#oCrudBodyTable").html("' . $cTable . '") ;
';
}
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);
}
public static function SendMail($cMailTo, $cSubject, $vaData)
{
//set table
$cBodyTable = "";
foreach ($vaData as $key => $value) {
$cBodyTable .= ' <tr>
<td class="head" style="border-bottom: 1px solid #eaeaea;font-size: 16px ; font-weight: 600; padding: 10px 5px 5px 5px;">' . $key . '</td>
</tr>
<tr>
<td class="child" style="padding: 5px 10px ;">' . $value . '</td>
</tr>';
}
$cUrl = scSys::GetConfig("sc_front_url");
$cImage = $cUrl . str_replace("./", "", scSys::GetConfig("sc_logo_mail"));
$vaReplace = array("cTitle_Prg" => scSys::GetConfig("sc_front_title"), "cImage" => $cImage, "cUrl" => $cUrl, "cTitle" => $cSubject, "vaData" => $cBodyTable, "nYear" => date("Y"));
$cData = @file_get_contents("./pages/ajaxload/theme_mail.php");
$cData = scSys::ReplaceString($vaReplace, $cData);
$cData = trim(str_replace(array('\\r', '\\n'), '', $cData));
scSys::SendMail($cMailTo, $cSubject, $cData);
}
function Saving($va)
{
scSys::SaveConfig("sc_front_url", $va['cUrl']);
scSys::SaveConfig("sc_front_title", $va['cTitle']);
scSys::SaveConfig("sc_admin", $va['sc_admin']);
scSys::SaveConfig("sc_company", $va['sc_company']);
scSys::SaveConfig("sc_kepala_dinas", $va['sc_kepala_dinas']);
//foto
$cFoto = GetSession("fileFoto1");
if (trim($cFoto) !== "") {
unlink($cFoto);
scSys::SaveConfig("sc_logo", GetSession("fileFoto1"));
}
$cFoto = GetSession("fileFoto2");
if (trim($cFoto) !== "") {
unlink($cFoto);
scSys::SaveConfig("sc_header", GetSession("fileFoto2"));
}
echo "alert('Data have been saved');";
}
function Saving($va)
{
global $scDb;
$code = $va['code'];
$cResult = scSys::GetKeteranganOne("result", "code = '{$code}'", "sppd");
$vaArray = array("result" => $va['result'], "status" => "2");
if ($cResult !== "") {
$vaArray['result_username_update'] = GetSession("cSession_UserName");
} else {
$vaArray["result_date"] = date("Y-m-d");
$vaArray['result_username'] = GetSession("cSession_UserName");
}
$scDb->Update("sppd", $vaArray, "code = '{$va['code']}'");
$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 LoadPie($va)
{
global $scDb;
//1. Priority
//2. Category
$dTglAwal = date("Y-m-d", strtotime($va['bulan_tahun']));
$dTglAkhir = scDate::EOM($dTglAwal);
$cGroup = "status";
$cWhere = "date >= '{$dTglAwal}' AND date <= '{$dTglAkhir}' ";
$dbData = $scDb->Browse("sppd", "COUNT(code) Jml,DATE_FORMAT(date,'%M %Y') bulan_tahun," . $cGroup, $cWhere, "", $cGroup, $cGroup . " DESC");
$vaData = array();
while ($dbRow = $scDb->GetRow($dbData)) {
$color = $dbRow[$cGroup] == "1" ? "#2ecc71" : ($dbRow[$cGroup] == "2" ? "#3498db" : "#e74c3c");
$vaData[] = array("value" => $dbRow['Jml'], "color" => $color, "highlight" => $color, "label" => sppd::GetStatus($dbRow[$cGroup]));
}
$chtml = ' <ul class="nav nav-tabs" id="myTabs2">
<li class="active"><a href="#otab_1" data-toggle="tab" id="otab__1">Status</a></li>
</ul>
<div class="tab-content">
<div class="tab-pane active" id="otab_1">
<canvas id="wrapdash_pie" height="300"></canvas>
</div>
</div>';
echo '
$("#wrap_myTabs2").find(".me-loading").remove() ;
';
$vachart = array();
if (!empty($vaData)) {
echo '
$("#wrap_myTabs2").html("' . scSys::CheckText($chtml) . '") ;
setTimeout(function(){
OBJFORM_NEW.frmdash.grid2 =
new Chart($("#wrapdash_pie")[0].getContext("2d")).Pie(' . json_encode($vaData) . ') ;
},50) ;
';
}
}
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") ;
';
}
}
$dbData = $scDb->Browse("username", "*");
while ($dbRow = $scDb->GetRow($dbData)) {
$cLevel = scCrypt::GetLevelPass($dbRow['Password']);
?>
<tr>
<td width="100" align="center"><?php
echo $dbRow['UserName'];
?>
</td>
<td ><?php
echo $dbRow['FullName'];
?>
</td>
<td width="100">
<?php
echo scSys::GetKeteranganOne("Keterangan", "Kode = '{$cLevel}'", "username_level");
?>
</td>
<td width="80" align="center">
<button class="btn btn-success" title="Edit"
onClick="scEdit('<?php
echo $dbRow['UserName'];
?>
')">
<i class="fa fa-pencil-square-o"></i>
</button>
<button class="btn btn-danger" title="Hapus"
onClick="scDelete('<?php
echo $dbRow['UserName'];
?>
')">
<div class="checkbox">
<!--
<label>Ingat Saya
<input type="checkbox" name="ckRemember">
</label>
-->
</div>
<button id="btnSubmit" class="btn btn-default btn-block">Login</button>
</form>
</div>
</div>
<div class="footer">
<?php
echo scSys::GetConfig("sc_front_title");
?>
| <a href="./pages/log.php" target="_blank">Ver : <?php
echo GetSession("SYS.ver");
?>
</a>
</div>
</div>
</div>
</div>
<script type="text/javascript" src="./sapeltucore/sc_credits/jquery/jquery.js"></script>
<script type="text/javascript" src="./sapeltucore/sc_credits/bootstrap/bootstrap.min.js"></script>
<script type="text/javascript" src="./sapeltucore/sc_include/sc.core.js"></script>
<script type="text/javascript">
$('document').ready(function(){
public static function NomHoliday($dTglAwal, $dTglAkhir)
{
$vaStart = explode("-", $dTglAwal);
$vaEnd = explode("-", $dTglAkhir);
$cLibur = scSys::GetConfig("sc_harilibur_" . $vaStart[0]);
if ($vaEnd[0] != $vaStart[0]) {
$cLibur .= scSys::GetConfig("sc_harilibur_" . $vaEnd[0]);
}
$nLiburan = 0;
for ($i = strtotime($dTglAwal); $i <= strtotime($dTglAkhir); $i += 86400) {
$dDate = date("Y-m-d", $i);
$vaGetDate = getdate($i);
$lValid = strpos($cLibur, $dDate) > -1 ? true : false;
$lValid = $vaGetDate['wday'] == 0 ? true : $lValid;
if ($lValid) {
$nLiburan++;
}
}
return $nLiburan;
}
$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("");
$pdf->ezTable($vaTable2, "", "", array("showLines" => 0, "showHeadings" => 0, "fontSize" => $nFont, "cols" => array("1" => array("width" => 4, "wrap" => 1), "2" => array("width" => 40, "wrap" => 1), "3" => array("width" => 56, "wrap" => 1))));
$pdf->ezText("");
$pdf->ezText("");
$pdf->ezTable($vaTanggal, "", "", array("showLines" => 0, "showHeadings" => 0, "fontSize" => $nFont, "cols" => array("x" => array("width" => 50, "wrap" => 1), "1" => array("width" => 25, "wrap" => 1), "2" => array("width" => 2), "3" => array("width" => 23, "wrap" => 1))));
$pdf->ezText("");
$pdf->ezTable($vaTtd, "", "", array("showLines" => 0, "showHeadings" => 0, "fontSize" => $nFont, "cols" => array("x" => array("width" => 50, "wrap" => 1, "justification" => "center"), "1" => array("width" => 40, "wrap" => 1, "justification" => "center"))));
$pdf->ezNewPage();
$pdf->ezImage(scSys::GetConfig("sc_header"), false, 100, 600);
$pdf->ezText("<u><b>SURAT PERINTAH TUGAS</b></u>", $nFont + 2, array("justification" => "center"));
$pdf->ezText("NOMOR : ", $nFont + 2, array("justification" => "center"));
$pdf->ezText("");
$pdf->ezTable($vaDasar, "", "", array("showLines" => 0, "showHeadings" => 0, "fontSize" => $nFont, "cols" => array("1" => array("width" => 20, "wrap" => 1), "2" => array("width" => 2), "3" => array("wrap" => 1))));
$pdf->ezText("");
$pdf->ezText("MEMERINTAHKAN :", $nFont + 2, array("justification" => "center"));
$pdf->ezText("");
$pdf->ezTable($vaKepada, "", "", array("showLines" => 0, "showHeadings" => 0, "fontSize" => $nFont, "cols" => array("1" => array("width" => 20, "wrap" => 1), "2" => array("width" => 2), "3" => array("width" => 4), "4" => array("width" => 20, "wrap" => 1), "5" => array("width" => 2), "6" => array("wrap" => 1))));
$pdf->ezText("");
$pdf->ezTable($vaUntuk, "", "", array("showLines" => 0, "showHeadings" => 0, "fontSize" => $nFont, "cols" => array("1" => array("width" => 20, "wrap" => 1), "2" => array("width" => 2), "3" => array("wrap" => 1))));
$pdf->ezText("");
$pdf->ezText("");
$pdf->ezTable($vaTanggal, "", "", array("showLines" => 0, "showHeadings" => 0, "fontSize" => $nFont, "cols" => array("x" => array("width" => 50, "wrap" => 1), "1" => array("width" => 25, "wrap" => 1), "2" => array("width" => 2), "3" => array("width" => 23, "wrap" => 1))));
$pdf->ezText("");
$pdf->ezTable($vaTtd, "", "", array("showLines" => 0, "showHeadings" => 0, "fontSize" => $nFont, "cols" => array("x" => array("width" => 50, "wrap" => 1, "justification" => "center"), "1" => array("width" => 40, "wrap" => 1, "justification" => "center"))));
</div>
</div>
<div class="form-group">
<div class="row">
<div class="col-sm-6">
<label>Kantor</label>
<input type="text" placeholder="Kantor" value="<?php
echo scSys::GetConfig("sc_company");
?>
"
name="sc_company" id="sc_company" class="form-control sc-input-required">
</div>
<div class="col-sm-3">
<label>Nip Kepala Kantor</label>
<input type="text" placeholder="Kantor" value="<?php
echo scSys::GetConfig("sc_kepala_dinas");
?>
"
name="sc_kepala_dinas" id="sc_kepala_dinas" class="form-control sc-input-required">
</div>
</div>
</div>
</div><!-- /.tab-pane -->
<div class="tab-pane" id="tab_2">
<div class="form-group">
<div class="row">
<div class="col-sm-6">
<input type="file" placeholder="Logo" name="cFileLogo" id="cFileLogo"
class="form-control" accept="image/*">
<div class="text-center">Logo</div>
</div>
public static function InitWrapInfo($dbRowAll, $cId, $oOSX)
{
$dbRowAll['DatetimeInsert_Maker'] = $dbRowAll['DatetimeInsert_Maker'] < $dbRowAll['DatetimeUpdate_Maker'] ? $dbRowAll['DatetimeUpdate_Maker'] : $dbRowAll['DatetimeInsert_Maker'];
$cAlasan1 = "";
$cAlasan2 = "";
if (GetSession("cSession_UserName") == $dbRowAll['UserName_Maker']) {
if ($dbRowAll['Penolakan_Checker'] !== "") {
$vaPenolakan = @json_decode($dbRowAll['Penolakan_Checker'], true);
if (!is_array($vaPenolakan)) {
$vaPenolakan = unserialize($dbRowAll['Penolakan_Checker']);
}
$cAlasan1 .= "<li>Penolakan Oleh Pemeriksa : <b>" . scSys::GetKeteranganOne("FullName", "UserName = '******'UserName']}'", "username") . "</b>";
$cAlasan1 .= " Pada : <b>" . $vaPenolakan['Tgl'] . "</b> , Dengan Alasan : <br />";
$cAlasan1 .= ""<i>" . scSys::CheckText($vaPenolakan['Alasan'], true) . "</i>"</li>";
}
if ($dbRowAll['Penolakan_Signer'] !== "") {
$vaPenolakan = @json_decode($dbRowAll['Penolakan_Signer'], true);
if (!is_array($vaPenolakan)) {
$vaPenolakan = unserialize($dbRowAll['Penolakan_Signer']);
}
$cAlasan2 .= "<li>Penolakan Oleh Penyetuju : <b>" . scSys::GetKeteranganOne("FullName", "UserName = '******'UserName']}'", "username") . "</b>";
$cAlasan2 .= " Pada : <b>" . $vaPenolakan['Tgl'] . "</b> , Dengan Alasan : <br />";
$cAlasan2 .= ""<i>" . scSys::CheckText($vaPenolakan['Alasan'], true) . "</i>"</li>";
}
if ($cAlasan1 !== "" || $cAlasan2 !== "") {
$cAlasan2 .= "<li><a onClick=\"" . $oOSX . ".cmdBatal('" . $cId . "')\" style=\"cursor:pointer\">\n Klik disini untuk pembatalan permintaan Mutasi</a> </li>";
}
}
$cHtml = '<br />
<div class="alert alert-danger alert-dismissable">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
<b>
<ul style="padding-left:5px;">
<li>
Pembuat : ' . scSys::GetKeteranganOne("FullName", "UserName = '******'UserName_Maker']}'", "username") . ' (' . scDate::String2DateTime($dbRowAll['DatetimeInsert_Maker']) . ')' . '</li>
<li>
Pemeriksa : ' . scSys::GetKeteranganOne("FullName", "UserName = '******'UserName_Checker']}'", "username") . ' (' . scDate::String2DateTime($dbRowAll['DatetimeUpdate_Checker']) . ')' . '</li> ' . $cAlasan1 . '
<li>
Penyetuju : ' . scSys::GetKeteranganOne("FullName", "UserName = '******'UserName_Signer']}'", "username") . ' (' . scDate::String2DateTime($dbRowAll['DatetimeInsert_Signer']) . ')' . '</li> ' . $cAlasan2 . '
</ul>
</b>
</div>';
return $cHtml;
}
public static function InitNotification($cType, $nRow, $cTitle, $cPage, $cId, $nKe, $cIconIo, $cIcon = "")
{
//pdam
if ($nRow > 0) {
$cTypeClass = "info";
$cTitleClass = "";
$cIcon = "fa fa-info";
switch ($cType) {
case 0:
$cHtml = '<strong>Permintaan Pemeriksaan</strong><br/>';
$cHtml .= 'Jumlah : ' . $nRow;
$cHtml .= '<br />Mohon segera dikonfirmasi, terimakasih';
$cTitleClass = "Permintaan Permeriksaan";
break;
case 1:
$cHtml = '<strong>Permintaan Persetujuan</strong><br/>';
$cHtml .= 'Jumlah : ' . $nRow;
$cHtml .= '<br />Mohon segera dikonfirmasi, terimakasih';
$cTitleClass = "Permintaan Persetujuan";
break;
case 3:
$cHtml = '<strong>Penolakan</strong><br/>';
$cHtml .= 'Jumlah : ' . $nRow;
$cHtml .= '<br />Mohon diteliti kembali , terimakasih';
$cTypeClass = "error";
$cTitleClass = "Penolakan";
$cIcon = "fa fa-ban";
break;
default:
$cHtml = '<strong>Please Review and Execute</strong><br/>';
$cHtml .= 'Count : ' . $nRow;
$cTitleClass = $cTitleClass;
break;
}
echo '
new PNotify({
title: "' . $cTitle . '",
text: "' . $cHtml . '",
type: "' . $cTypeClass . '",
icon: "' . $cIcon . '", animation : "slide" ,
before_open: function(PNotify){
$("#wrapAudioNotif")[0].play();
},buttons: {
closer: false
}
})
.get().click(function(){
ChangePage("#' . $cPage . '") ;
}) ;
';
//add to notif top
$cHtml = '<li id="notifTop-' . $cId . $nKe . '">
<a href="#" onClick="ChagePage("#' . $cPage . '")">
<i class="ion ' . $cIconIo . '"></i>' . $nRow . ' ' . $cTitleClass . ' ' . $cTitle . '</a></li>';
echo '
$("#oNotif_Body").find("#notifTop-' . $cId . $nKe . '").remove() ;
$("#oNotif_Body").prepend("' . scSys::CheckText($cHtml) . '") ;
';
} else {
echo '$("#oNotif_Body").find("#notifTop-' . $cId . $nKe . '").remove() ; ';
}
}
$aResultTotal = $scDb->GetRow($dbDataCount);
$iTotal = $aResultTotal['Jml'];
/*
* Output
*/
$output = array("sEcho" => intval($_GET['sEcho']), "iTotalRecords" => $iTotal, "iTotalDisplayRecords" => $iTotal, "aaData" => array(), "SQL" => $cSql);
while ($dbRow = $scDb->GetRow($dbData)) {
$row = array();
for ($i = 0; $i < count($vaColumns); $i++) {
switch ($vaColumns[$i]) {
case 'Act':
$cButton = '<button class="btn btn-success" title="Edit Data"
onClick="cmdEditLevel("' . $dbRow['Kode'] . '")">
<i class="fa fa-edit"></i>
</button>
<button class="btn btn-danger" title="Delete Data"
onClick="cmdDeleteLevel("' . $dbRow['Kode'] . '")">
<i class="fa fa-minus-circle"></i>
</button>';
$row[] = $cButton;
break;
default:
$row[] = htmlspecialchars(scSys::CheckText($dbRow[$vaColumns[$i]]));
break;
}
}
$output['aaData'][] = $row;
}
echo json_encode($output);
?>
</ul>
</li>
</ul>
</div>
</nav>
</header>
<div class="wrapper row-offcanvas row-offcanvas-left">
<!-- Left side column. contains the logo and sidebar -->
<aside class="left-side sidebar-offcanvas">
<!-- sidebar: style can be found in sidebar.less -->
<section class="sidebar">
<!-- Sidebar user panel -->
<div class="user-panel">
<div class="pull-left image">
<img src="<?php
echo scSys::GetAvatar();
?>
" class="img-thumbails" alt="User Image" />
</div>
<div class="pull-left info">
<?php
$cFullName = substr(GetSession("cSession_FullName"), 0, strpos(GetSession("cSession_FullName"), " "));
if ($cFullName == "") {
$cFullName = GetSession("cSession_FullName");
}
?>
<p>Hello, <?php
echo $cFullName;
?>
</p>
*/
$va = array();
$cPage = "";
$objFunction = "";
$vaPost = array($_GET, $_POST);
foreach ($vaPost as $_key => $_ME) {
foreach ($_ME as $cKey => $cValue) {
if (strtolower($cKey) == "cpar") {
$cPage = $cValue;
} else {
if (strtolower($cKey) == "cfunction") {
$objFunction = $cValue;
} else {
if (!is_array($cValue)) {
$cValue = trim($cValue);
if (!scSys::IsJson($cValue)) {
$cValue = addslashes($cValue);
}
if (strpos($cValue, "base64") === false) {
$cValue = urldecode($cValue);
}
}
$va[trim($cKey)] = $cValue;
}
}
}
}
if (isset($_FILES)) {
$va['file'] = $_FILES;
}
if (GetSession("cSession_UserName") !== "" || $cPage == './login.ajax.php') {
public static function GetLevelKet($cPass)
{
$cLv = self::GetLevelPass($cPass);
return scSys::GetKeteranganOne("Keterangan", "Kode = '{$cLv}'", "username_level");
}
public static function GetChildMenu($cJs = "")
{
$vaArray = array();
$vaFile = file(self::$cFileLoc);
$nBertingkat = 0;
$lValid = false;
foreach ($vaFile as $nKey => $cValue) {
$cIdentifier = strpos($cValue, "#");
if ($cIdentifier === false && trim($cValue) !== "" && strpos($cValue, "<?php die('Sapeltu Inc.'); ?>") !== 0) {
//jika diawal value terisi # maka tidak dieksekusi
//ambil posisi [ karna untuk menentukan sub sub menu
$nPos = strpos($cValue, "[");
$lTop = $nPos == 0 ? true : false;
$vaMenu = scArray::Menu2Array($cValue);
if (strpos($vaMenu["cNama"], "-MOBILE-") === false) {
$lParent = false;
$lParentEnd = false;
$lBertingkatEnd = false;
$nNextKey = scSys::CekSelanjutnya($nKey);
if (isset($vaFile[$nNextKey])) {
$nPosNext = strpos($vaFile[$nNextKey], "[");
$lParent = $nPosNext > $nPos ? true : false;
$lParentEnd = $nPosNext >= $nPos ? false : true;
$lBertingkatEnd = $nPosNext == 0 ? true : false;
} else {
$nPosNext = -1;
$lBertingkatEnd = true;
}
//isi
$cNamaMenu = $vaMenu['cNama'];
if ($lParent) {
$lValid = md5($cJs) == $vaMenu['cMd5'] ? true : false;
$nBertingkat++;
} else {
if ($lValid) {
$vaArray[$vaMenu['cMd5']] = $vaMenu;
}
}
if ($lParentEnd) {
//ditutup parent end
$nBertingkat--;
}
if ($nBertingkat > 0 && $lBertingkatEnd) {
while ($nBertingkat > 0) {
$nBertingkat--;
}
}
}
}
}
return $vaArray;
}
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'] . '") ;
}
';
}
}
