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