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 = $PERENCANAAN->retrieve_daftar_perencanaan_pengadaan($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 );
<?php
include"$path/meta.php";
include"$path/header.php";
include"$path/menu.php";
?>
<!-- SQL Sementara -->
<?php
// //pr($_SESSION);
// $POST['page'] = intval($_GET['pid']);
// pr($_POST);
// $par_data_table="kodeKelompok={$POST['kodeKelompok']}&kdRekening={$POST['kdRekening']}";
if($_POST){
$data = $PERENCANAAN->retrieve_daftar_perencanaan_pengadaan($_POST);
}else{
$data = $PERENCANAAN->retrieve_daftar_perencanaan_pengadaan($_GET);
}
// $data = $PENGHAPUSAN->retrieve_daftar_penetapan_penghapusan_pmd($_POST);
//////pr($data);
// $sql = mysql_query("SELECT * FROM kontrak ORDER BY id ");
// while ($dataKontrak = mysql_fetch_assoc($sql)){
// $kontrak[] = $dataKontrak;
// }
?>
<!-- End Sql -->
<script>
// $(document).ready(function() {
// $('#penetapan_pmd_table').dataTable(
