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; }