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) ; '; } }
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); ?>
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; }