$iFilteredTotal = $aResultFilterTotal[0];
// echo $iFilteredTotal ;
/* Total data set length */
$sQuery = "\n\t\tSELECT COUNT(`" . $sIndexColumn . "`)\n\t\tFROM {$sTable} {$sWhere}\n\t";
$rResultTotal = $DBVAR->query($sQuery) or fatal_error('MySQL Error: ' . mysql_errno());
$aResultTotal = $DBVAR->fetch_array($rResultTotal);
$iTotal = $aResultTotal[0];
/*
* Output
*/
$output = array("sEcho" => intval($_GET['sEcho']), "iTotalRecords" => $iTotal, "iTotalDisplayRecords" => $iFilteredTotal, "aaData" => array());
$PENYUSUTAN = new RETRIEVE_PENYUSUTAN();
$no = $_GET['iDisplayStart'] + 1;
while ($value = $DBVAR->fetch_array($rResult)) {
// pr($value);
$NamaSatker = $PENYUSUTAN->getNamaSatker($value['SatkerUsul']);
$jumlahAset = $PENYUSUTAN->getJmlAset($value['Penyusutan_ID']);
if ($jumlahAset[0] == 0) {
$FixjmlAset = 0;
} else {
$FixjmlAset = $jumlahAset[0];
}
// pr($jumlahAset);
$change = $value['TglPenyusutan'];
$change2 = format_tanggal_db3($change);
// echo "$change2";
if ($value['SatkerUsul']) {
$SatkerUsul = "[" . $value['SatkerUsul'] . "] " . $NamaSatker[0]['NamaSatker'];
// echo ;
} else {
$SatkerUsul = $NamaSatker[0]['NamaSatker'];
$data[$key]['checked'] = "";
} else {
$data[] = $value;
$data[$key]['checked'] = "checked";
}
}
// }
} else {
$data = $rResultGetDataApluserlist;
}
if (!empty($data)) {
foreach ($data as $key => $aRow) {
// pr($aRow);
//DAFTAR FIELD
$row = array();
$NamaSatker = $PENYUSUTAN->getNamaSatker($aRow[SatkerUsul]);
$id = $aRow[Usulan_ID];
// pr($NamaSatker);
// pr($totalNilaiPerolehan);
if (!empty($aRow[Aset_ID])) {
$jmlh = explode(",", $aRow[Aset_ID]);
$jumlahAset = count($jmlh);
} else {
$jumlahAset = 0;
}
$change = $aRow[TglUpdate];
$change2 = format_tanggal_db3($change);
// echo "$change2";
$NoUsulan = $aRow['NoUsulan'];
$checkbox = "<input type=\"checkbox\" class =\"icheck-input checkbox\" name=\"id_usulanPenetapan[]\" value=\"{$id}\" onchange=\"return AreAnyCheckboxesChecked();\" {$aRow['checked']}>";
$row[] = "<center>" . $no . "</center>";
