<div class="detailRight" align="right"> <?php unset($_SESSION['ses_retrieve_filter_'.$menu_id.'_'.$SessionUser['ses_uid']]); $parameter = array('menuID'=>$menu_id,'type'=>'','paging'=>$paging); // $data = $RETRIEVE->retrieve_daftar_usulan_penghapusan($parameter); // pr($data); $query = "select distinct Usulan_ID from UsulanAset where StatusPenetapan = 1 AND Jenis_Usulan = 'HPS'"; $result = mysql_query($query) or die (mysql_error()); while ($dataNew = mysql_fetch_object($result)) { $dataArr[] = $dataNew->Usulan_ID; } // pr($_POST); $data = $PENGHAPUSAN->retrieve_daftar_usulan_penghapusan_pmd($_POST); // pr($data); ?> <ul> <li> <a href="<?php echo "$url_rewrite/module/penghapusan/"; ?>daftar_usulan_penghapusan_filter_pmd.php" class="btn"> Kembali ke Form Filter</a> </li> <!-- <li> <a href="<?php echo "$url_rewrite/module/penghapusan/"; ?>daftar_usulan_penghapusan_lanjut_pmd.php?pid=1" class="btn"> Tambah Data</a> </li> --> <li> <input type="hidden" class="hiddenpid" value="<?php echo @$_GET['pid']?>"> <input type="hidden" class="hiddenrecord" value="<?php echo @$_SESSION['parameter_sql_total']?>">
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($data,$iFilteredTotal ) = $PENGHAPUSAN->retrieve_daftar_usulan_penghapusan_pmd($dataParam); $data = $PENGHAPUSAN->retrieve_daftar_usulan_penghapusan_pmd($dataParam); //pr($dataSESSION); //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 );