PHP RETRIEVE_PENGHAPUSAN::retrieve_penetapan_penghapusan_filter_psbの例

コード例 #1

ファイル: dftr_usulan_aset_psb.php プロジェクト: TrinataBhayanaka/simbada-tangsel

            $USERAUTH->FrontEnd_check_akses_menu($menu_id, $Session);

// $get_data_filter = $RETRIEVE->retrieve_kontrak();
// //////pr($get_data_filter);
?>

<?php
	include"$path/meta.php";
	include"$path/header.php";
	include"$path/menu.php";
	
?>
	<!-- SQL Sementara -->
	<?php
	// ////pr($_POST);
	$data = $PENGHAPUSAN->retrieve_penetapan_penghapusan_filter_psb($_POST);
	// ////pr($data);

		$POST['page'] = intval($_GET['pid']);
	// pr($POST);
	    $par_data_table="bup_pp_sp_tglusul={$_POST['bup_pp_sp_tglusul']}&bup_pp_sp_nousulan={$_POST['bup_pp_sp_nousulan']}&kodeSatker={$_POST['kodeSatker']}&page={$POST['page']}";

	if($_POST['kodeSatker']){
		$_SESSION['kdSatkerFilterPMDp']=$_POST['kodeSatker'];
		$kdSatkerFilter=$_SESSION['kdSatkerFilterPMDp'];
	}else{
		$kdSatkerFilter=$_SESSION['kdSatkerFilterPMDp'];
	}
		 $sql = mysql_query("SELECT * FROM kontrak ORDER BY id ");
        while ($dataKontrak = mysql_fetch_assoc($sql)){
                $kontrak[] = $dataKontrak;

コード例 #2

ファイル: api_usulan_aset_psb.php プロジェクト: TrinataBhayanaka/simbada-tangsel

               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_penetapan_penghapusan_filter_psb($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 );