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'] . '") ; } '; } }