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 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 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) . '") ;
';
}
$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'];
?>
')">
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 GetCabang($cUserName)
{
$cCabang = scSys::GetKeteranganOne("Cabang", "UserName = '******'", "username");
if ($cCabang == "") {
$cCabang = scSys::GetCabangInduk();
}
return $cCabang;
}
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 GetLevelKet($cPass)
{
$cLv = self::GetLevelPass($cPass);
return scSys::GetKeteranganOne("Keterangan", "Kode = '{$cLv}'", "username_level");
}
