PHP RETRIEVE_PEROLEHAN::get_tmpData Examples

Example #1

File: api_import_xls_kibc.php Project: 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($dataSESSION,$iFilteredTotal ) = $PENGHAPUSAN->retrieve_usulan_penghapusan_pmd($dataParam);
$dataSESSION = $RETRIEVE_PEROLEHAN->get_tmpData($dataParam, 'tmp_bangunan');
//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 );

Example #2

File: api_import_xls_kibb.php Project: 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($dataSESSION,$iFilteredTotal ) = $PENGHAPUSAN->retrieve_usulan_penghapusan_pmd($dataParam);
$dataSESSION = $RETRIEVE_PEROLEHAN->get_tmpData($dataParam, 'tmp_mesin');
//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 );

Example #3

File: api_import_xls_kibd.php Project: 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($dataSESSION,$iFilteredTotal ) = $PENGHAPUSAN->retrieve_usulan_penghapusan_pmd($dataParam);
$dataSESSION = $RETRIEVE_PEROLEHAN->get_tmpData($dataParam, 'tmp_jaringan');
//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 );