<tr> <td style="height:25px; font-weight:bold;" colspan="3"><u style="font-weight:bold;">Daftar aset yang akan dibuatkan Daftar Usulan penghapusan :</u></td> </tr> <tr> <?php $id=$_GET['id']; // pr($id); if (isset($id)) { unset($_SESSION['ses_retrieve_filter_'.$menu_id.'_'.$SessionUser['ses_uid']]); $parameter = array('id'=>$id); // $data = $RETRIEVE->retrieve_penetapan_penghapusan_edit_data($parameter); // pr($_POST); $data = $PENGHAPUSAN->retrieve_daftar_usulan_penghapusan_edit_data_psb($_GET); // pr($data); } $no = 1; // pr($data); $coo=count($data['dataArr']); // pr($coo); foreach ($data['dataArr'] as $keys => $nilai) { if ($nilai[Aset_ID] !='') { if ($nilai->AsetOpr == 0) $select="selected='selected'"; if ($nilai->AsetOpr ==1)
from mahasiswa M left join ijin I on I.mahasiswa_idmahasiswa=M.idmahasiswa left join universitas U on U.kodeUniversitas=M.universitas_iduniversitas left join status S on S.idstatus=I.status_idstatus left join jurusan J on J.idjurusan=M.jurusan_idjurusan left join prodi F on F.idprodi=M.prodi_idprodi $sWhere $sOrder $sLimit";*/ //echo $sQuery; //echo $sWhere; $dataParam['condition'] = "{$sWhere} "; $dataParam['order'] = $sOrder; $dataParam['limit'] = "{$sLimit}"; //pr($dataParam); // list($dataSESSION,$iFilteredTotal ) = $PENGHAPUSAN->retrieve_usulan_penghapusan_pmd($dataParam); $dataSESSION = $PENGHAPUSAN->retrieve_daftar_usulan_penghapusan_edit_data_psb($dataParam); // pr($data); //exit; //$rResult = $DBVAR->query($sQuery); // /* Data set length after filtering */ $sQuery = "\n\t\tSELECT FOUND_ROWS()\n\t"; $rResultFilterTotal = $DBVAR->query($sQuery); $aResultFilterTotal = $DBVAR->fetch_array($rResultFilterTotal); $iFilteredTotal = $aResultFilterTotal[0]; //echo $iFilteredTotal ; /* Total data set length */ $sQuery = "\n\t\tSELECT COUNT(`" . $sIndexColumn . "`)\n\t\tFROM {$sTable}\n\t"; //echo "$sQuery"; $rResultTotal = $DBVAR->query($sQuery); $aResultTotal = $DBVAR->fetch_array($rResultTotal); ////pr($aResultTotal );