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 Saving($va)
{
global $scDb;
$cUserName = GetSession("cSession_UserName");
$cFullName = $va['cFullName'];
$cPassword = $va['cPassword'];
$cImages = GetSession("g" . GetSession("cSession_UserName"));
$vaArray = array("FullName" => $cFullName);
if ($cPassword !== "") {
$cPassword = scCrypt::CryptPass($cPassword);
$vaArray['Password'] = $cPassword . GetSession("cSession_SCLevel");
}
if ($cImages !== "") {
$vaArray['Foto'] = $cImages;
}
$scDb->Update("username", $vaArray, "UserName = '******'");
echo '
alert("Data have been saved") ;
scLoadPage("sc-content-load","sys/mee.php") ;
';
}
public static function GetUserAccess($cKey, $cCabang)
{
global $scDb;
$vaUserSigner = array("UserName" => "", "FullName" => "");
$cMd5Signer = md5($cKey);
$lAda = false;
$dbDLv = $scDb->Browse("username_level", "Kode", "Isi like '%{$cMd5Signer}%'");
while ($dbRLv = $scDb->GetRow($dbDLv)) {
if (!$lAda) {
$cLvSigner = $dbRLv['Kode'];
$dbSigner = $scDb->Browse("username", "UserName,FullName,Nik NIK,Password", "Cabang = '{$cCabang}' AND Password LIKE '%{$cLvSigner}'", "", "", "UserName asc", "0,1");
if ($scDb->Rows($dbSigner) > 0) {
if ($dbR = $scDb->GetRow($dbSigner)) {
$dbR['Lv'] = scCrypt::GetLevelKet($dbR['Password']);
unset($dbR['Password']);
$vaUserSigner = $dbR;
$lAda = true;
}
}
}
}
return $vaUserSigner;
}
</div>
<div class="box-body pad table-responsive">
<table class="table table-striped table-bordered table-hover sc-DataTable" id="sc-DataTable">
<thead>
<tr>
<td width="100" align="center">UserName</td>
<td>FullName</td>
<td width="100" align="center">Level</td>
<td width="80" align="center">Action</td>
</tr>
</thead>
<tbody>
<?php
$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>
