$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>";