function LoadGrid($va)
{
global $scDb;
$dTglAwal = scDate::Date2String($va['dTglAwal']);
$dTglAkhir = scDate::Date2String($va['dTglAkhir']);
$vaData = array("data" => array(), "key" => array());
$cWhere = "date >= '{$dTglAwal}' AND date <= '{$dTglAkhir}'";
$dbData = $scDb->Browse("sppd", "COUNT(code) Jml, DATE_FORMAT(date,'%M %Y') bulan_tahun", $cWhere, "", "bulan_tahun", "bulan_tahun desc", "0,12");
$vaColor = array("#1abc9c", "#2ecc71", "#3498db", "#9b59b6", "#34495e", "#16a085", "#27ae60", "#2980b9", "#8e44ad", "#2c3e50", "#f1c40f", "#e67e22");
$nRow = 0;
while ($dbRow = $scDb->GetRow($dbData)) {
$vaData['key'][] = $dbRow['bulan_tahun'];
$vaData['data'][] = intval($dbRow['Jml']);
}
//load chart
$vachart = array("labels" => $vaData['key'], "datasets" => array(array("fillColor" => "rgba(151,187,205,0.2)", "strokeColor" => "rgba(151,187,205,1)", "pointColor" => "rgba(151,187,205,1)", "pointStrokeColor" => "#fff", "pointHighlightFill" => "#fff", "pointHighlightStroke" => "rgba(151,187,205,1)", "data" => $vaData['data'])));
$chtml = '<canvas id="wrapdash_chart" height="300"></canvas>';
echo '
$("#tab_1").find(".me-loading").remove() ;
$("#tab_1").append("' . scSys::CheckText($chtml) . '") ;
setTimeout(function(){
OBJFORM_NEW.frmdash.grid1 =
new Chart($("#wrapdash_chart")[0].getContext("2d")).Line(' . json_encode($vachart) . ') ;
$("#wrapdash_chart").on("click",function(ev){
var activePoints = OBJFORM_NEW.frmdash.grid1.getPointsAtEvent(ev);
OBJFORM_NEW.frmdash.LoadPie(activePoints[0]["label"]) ;
}) ;
},50) ;
';
}
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 Saving($va)
{
global $scDb;
$cNip = $va['cNip'];
$vaArray = array("nip" => $va['cNip'], "nama" => $va['cNama'], "alamat" => $va['cAlamat'], "tanggal_lahir" => scDate::Date2String($va['dTempat_Tgl']), "tempat_lahir" => $va['cTempat'], "golongan" => $va['cGolongan'], "golongan_tanggal" => scDate::Date2String($va['dGolongan_Tgl']), "jabatan" => $va['cJabatan'], "jabatan_tanggal" => scDate::Date2String($va['dJabatan_Tgl']), "kerja_tahun" => $va['nKerjaTahun'], "kerja_bulan" => $va['nKerjaBulan'], "latihan_jabatan" => $va['cJabatan_Lat'], "latihan_jabatan_tanggal" => scDate::Date2String($va['dJabatan_Lat_Tgl']), "latihan_jabatan_jam" => $va['nJabatan_Lat'], "pendidikan" => $va['cPendidikan'], "pendidikan_lulus" => $va['nThLulus'], "pendidikan_ijazah" => $va['cIjazah'], "catatan_mutasi" => $va['cCatatan_Mutasi'], "keterangan" => $va['cKeterangan'], "no_hp" => $va['cno_hp']);
$vaInsert = array("username" => GetSession("cSession_UserName"));
$vaUpdate = array("username_update" => GetSession("cSession_UserName"));
$scDb->Update("pegawai", $vaArray, "nip = '{$cNip}'", true, $vaInsert, $vaUpdate);
echo '
alert("Data sudah disimpan") ;
OBJFORM_NEW.mstpegawai.Init() ;
';
}
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;
$cUserName = GetSession("cSession_UserName");
$cKode = $va['code'];
if ($cKode == "") {
$cKey = "-" . date("m") . "-" . date("y") . "/sppd/creative";
$cKode = scSys::GetLastInt($cKey, true, 3) . $cKey;
}
$vaArray = array("letter_content" => $va['letter_content'], "code" => $cKode, "nip_pejabat" => $va['nip_pejabat'], "nip_leader" => $va['nip_leader'], "rate_travel" => $va['rate_travel'], "nip" => $va['nip'], "purpose" => $va['purpose'], "transport" => $va['transport'], "place_from" => $va['place_from'], "place_to" => $va['place_to'], "length_journey" => $va['length_journey'], "date_go" => scDate::Date2String($va['date_go']), "date_back" => scDate::Date2String($va['date_back']), "government" => $va['government'], "budget_from" => $va['budget_from'], "description" => $va['description']);
$vaInsert = array("username" => $cUserName, "date" => date("Y-m-d"));
$vaUpdate = array("username_update" => $cUserName);
$scDb->Update("sppd", $vaArray, "code = '{$cKode}'", true, $vaInsert, $vaUpdate);
echo '
alert("Data sudah disimpan\\nNomor SPPD : ' . $cKode . '\\nCetak Surat Perintah dan Surat Perintah Perjalanan Dinas di daftar SPPD") ;
ChangePage("#' . str_replace("./pages/", "", $va['cPageSource']) . '") ;
';
}
public static function GetLastKode($cKey, $lUpdate = true, $dTgl = '', $nLen = 18)
{
global $scDb;
if ($dTgl == '') {
$dTglTransaksi = scDate::GetTglTransaksi();
$dTgl = $dTglTransaksi;
}
$dTgl = date("dmy", strtotime(scDate::Date2String($dTgl)));
$dTgl = str_replace("-", "", $dTgl);
$cCabang = scSys::GetCabangUser();
$cKey .= $cCabang . $dTgl;
//TBcabang2013100100001
$nKey = strlen($cKey);
$nRow = self::GetLastInt($cKey, $lUpdate);
$cLastKode = $cKey . str_repeat("0", $nLen - $nKey - strlen($nRow)) . $nRow;
return $cLastKode;
}
public static function SaveLvAccess($cFileLoc, $cTable, $cTableId, $cTableValue, $cId = "")
{
global $scDb;
$cUserName = GetSession("cSession_UserName");
$vaAccess = self::GetLvAccess($cFileLoc);
$cTableValue = json_encode($cTableValue);
$cMd5Val = md5($cTableValue);
$vaArray = array("TableName" => $cTable, "TableId" => $cTableId, "TableValue" => $cTableValue, "Md5Val" => md5($cTableValue));
$cReturn = false;
if ($cId == "") {
scArray::ArrayMe($vaArray, "DateInsert", scDate::Date2String(scDate::GetTglTransaksi()));
scArray::ArrayMe($vaArray, "UserName_Maker", $cUserName);
scArray::ArrayMe($vaArray, "DatetimeInsert_Maker", date("Y-m-d h:i:s"));
if ($vaAccess['lSigner'] || $vaAccess['lChecker']) {
//signer all
scArray::ArrayMe($vaArray, "Status", "1");
scArray::ArrayMe($vaArray, "UserName_Checker", $cUserName);
scArray::ArrayMe($vaArray, "DatetimeInsert_Checker", date("Y-m-d h:i:s"));
}
} else {
$dbRowLast = scSys::GetKeterangan("*", "Id = '{$cId}'", "sc_access_input");
$vaRowLog = @json_decode($dbRowLast['UserName_Log'], true);
if (!is_array($vaRowLog)) {
$vaRowLog = unserialize($dbRowLast['UserName_Log']);
}
if (!is_array($vaRowLog)) {
$vaRowLog = array();
}
if ($vaAccess['lMaker'] && !$vaAccess['lChecker'] && !$vaAccess['lSigner']) {
//edit maker
if ($dbRowLast['UserName_Maker'] !== $cUserName) {
scArray::ArrayMe($vaArray, "UserName_Maker", $cUserName);
if ($dbRowLast['UserName_Maker'] !== "") {
$vaRowLog[]['UserName_Maker@' . time()] = $dbRowLast['UserName_Maker'];
}
}
scArray::ArrayMe($vaArray, "Status", "0");
scArray::ArrayMe($vaArray, "DatetimeUpdate_Maker", date("Y-m-d h:i:s"));
}
if ($vaAccess['lChecker'] && !$vaAccess['lSigner']) {
//edit maker
if ($dbRowLast['UserName_Checker'] !== $cUserName) {
scArray::ArrayMe($vaArray, "UserName_Checker", $cUserName);
if ($dbRowLast['UserName_Checker'] !== "") {
$vaRowLog[]['UserName_Checker@' . time()] = $dbRowLast['UserName_Checker'];
}
}
scArray::ArrayMe($vaArray, "DatetimeUpdate_Checker", date("Y-m-d h:i:s"));
scArray::ArrayMe($vaArray, "Status", "1");
}
if (!empty($vaRowLog)) {
scArray::ArrayMe($vaArray, "UserName_Log", json_encode($vaRowLog));
}
}
scArray::ArrayMe($vaArray, "StatusOnView", "0");
if ($vaAccess['lSigner']) {
//signer all
$cReturn = true;
scArray::ArrayMe($vaArray, "UserName_Signer", $cUserName);
scArray::ArrayMe($vaArray, "DatetimeInsert_Signer", date("Y-m-d h:i:s"));
scArray::ArrayMe($vaArray, "Status", "2");
scArray::ArrayMe($vaArray, "StatusOnView", "2");
}
$scDb->Update("sc_access_input", $vaArray, "Id = '{$cId}'", false, array("Cabang" => GetSession("cSession_Cabang")));
if ($cReturn) {
$cReturn = scSys::GetKeteranganOne("Id", "TableName = '{$cTable}' and TableId = '{$cTableId}' and Md5Val = '{$cMd5Val}'", "sc_access_input");
} else {
$cReturn = "";
}
return $cReturn;
}
