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_pms($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 );
<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_pms($_POST);
// pr($data);
?>
<ul>
<li>
<a href="<?php echo "$url_rewrite/module/penghapusan/"; ?>daftar_usulan_penghapusan_filter_pms.php" class="btn">
Kembali ke Form Filter</a>
</li>
<!-- <li>
<a href="<?php echo "$url_rewrite/module/penghapusan/"; ?>daftar_usulan_penghapusan_lanjut_pms.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']?>">
