PHP RETRIEVE_PEROLEHAN Exemples

Exemple #1

Fichier : api_import_xls_kibb.php Projet : TrinataBhayanaka/simbada-tangsel

/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
 * Easy set variables
 */
/* Array of database columns which should be read and sent back to DataTables. Use a space where
 * you want to insert a non-database field (for example a counter or static image)
 */
$aColumns = array('temp_Mesin_ID', 'tmp_Mesin_ID', 'kodeKelompok', 'uraian', 'kodeLokasi', 'Jumlah', 'NilaiPerolehan', 'tmp_Mesin_ID');
/* Indexed column (used for fast and accurate table cardinality) */
$sIndexColumn = "tmp_Mesin_ID";
/* DB table to use */
$sTable = "tmp_mesin";
$dataParam['bup_nokontrak'] = $_GET['bup_nokontrak'];
$dataParam['jenisaset'][0] = $_GET['jenisaset'];
$dataParam['kodeSatker'] = $_GET['kodeSatker'];
$dataParam['page'] = $_GET['page'];
$RETRIEVE_PEROLEHAN = new RETRIEVE_PEROLEHAN();
$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN();
////pr($data);
//exit;
$sLimit = "";
if (isset($_GET['iDisplayStart']) && $_GET['iDisplayLength'] != '-1') {
    $sLimit = " " . intval($_GET['iDisplayStart']) . ", " . intval($_GET['iDisplayLength']);
}
/*
 * Ordering
 */
$sOrder = "";
if (isset($_GET['iSortCol_0'])) {
    $sOrder = "ORDER BY  ";
    for ($i = 0; $i < intval($_GET['iSortingCols']); $i++) {
        if ($_GET['bSortable_' . intval($_GET['iSortCol_' . $i])] == "true") {

Exemple #2

Fichier : api_import_xls_kibc.php Projet : TrinataBhayanaka/simbada-tangsel

/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
 * Easy set variables
 */
/* Array of database columns which should be read and sent back to DataTables. Use a space where
 * you want to insert a non-database field (for example a counter or static image)
 */
$aColumns = array('temp_Bangunan_ID', 'temp_Bangunan_ID', 'kodeKelompok', 'uraian', 'kodeLokasi', 'Jumlah', 'NilaiPerolehan', 'temp_Bangunan_ID');
/* Indexed column (used for fast and accurate table cardinality) */
$sIndexColumn = "temp_Bangunan_ID";
/* DB table to use */
$sTable = "tmp_bangunan";
$dataParam['bup_nokontrak'] = $_GET['bup_nokontrak'];
$dataParam['jenisaset'][0] = $_GET['jenisaset'];
$dataParam['kodeSatker'] = $_GET['kodeSatker'];
$dataParam['page'] = $_GET['page'];
$RETRIEVE_PEROLEHAN = new RETRIEVE_PEROLEHAN();
$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN();
////pr($data);
//exit;
$sLimit = "";
if (isset($_GET['iDisplayStart']) && $_GET['iDisplayLength'] != '-1') {
    $sLimit = " " . intval($_GET['iDisplayStart']) . ", " . intval($_GET['iDisplayLength']);
}
/*
 * Ordering
 */
$sOrder = "";
if (isset($_GET['iSortCol_0'])) {
    $sOrder = "ORDER BY  ";
    for ($i = 0; $i < intval($_GET['iSortingCols']); $i++) {
        if ($_GET['bSortable_' . intval($_GET['iSortCol_' . $i])] == "true") {

Exemple #3

Fichier : asetlain.php Projet : TrinataBhayanaka/simbada-tangsel

<?php
include "../../../config/config.php";
include "excel_reader.php";

include"$path/meta.php";
include"$path/header.php";
include"$path/menu.php";

$menu_id = 10;
            $SessionUser = $SESSION->get_session_user();
            ($SessionUser['ses_uid']!='') ? $Session = $SessionUser : $Session = $SESSION->get_session(array('title'=>'GuestMenu', 'ses_name'=>'menu_without_login')); 
            $USERAUTH->FrontEnd_check_akses_menu($menu_id, $Session);
$RETRIEVE_PEROLEHAN = new RETRIEVE_PEROLEHAN;
if(isset($_GET['id'])){
	$dataArr = $RETRIEVE_PEROLEHAN->get_kontrak($_GET['id']);
	// $xlsData = $RETRIEVE_PEROLEHAN->get_tmpData('tmp_asetlain');
	
	$POST['page'] = intval($_GET['pid']);
	$par_data_table="bup_tahun={$POST['bup_tahun']}&bup_nokontrak={$POST['bup_nokontrak']}&jenisaset={$POST['jenisaset'][0]}&kodeSatker={$POST['kodeSatker']}&page={$POST['page']}";

} else{
	$dataArr = $RETRIEVE_PEROLEHAN->importing_xls2html($_FILES,$_POST);

}

?>

	<script>
	$(function(){
		$body = $("body");
		$('#btn-dis').click(function(){

Exemple #4

Fichier : kibcheck.php Projet : TrinataBhayanaka/simbada-tangsel

<?php

include "../../config/config.php";
$menu_id = 99;
$SessionUser = $SESSION->get_session_user();
$SessionUser['ses_uid'] != '' ? $Session = $SessionUser : ($Session = $SESSION->get_session(array('title' => 'GuestMenu', 'ses_name' => 'menu_without_login')));
$USERAUTH->FrontEnd_check_akses_menu($menu_id, $Session);
include "{$path}/meta.php";
include "{$path}/header.php";
include "{$path}/menu.php";
$RETRIEVE_PEROLEHAN = new RETRIEVE_PEROLEHAN();
$dataArr = $RETRIEVE_PEROLEHAN->get_diagnose($_GET);
// pr($dataArr);
?>
	
	<section id="main">
		<ul class="breadcrumb">
			  <li><a href="#"><i class="fa fa-home fa-2x"></i>  Home</a> <span class="divider"><b>&raquo;</b></span></li>
			  <li class="active">Checker</li>
			  <?php 
SignInOut();
?>
			</ul>
			<div class="breadcrumb">
				<div class="title">PHP Checker</div>
				<div class="subtitle">Dont ever try without admin permission!!</div>
			</div>		

		<section class="formLegend">
		<div>
			

Exemple #5

Fichier : api_import_xls_kibd.php Projet : TrinataBhayanaka/simbada-tangsel

/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
 * Easy set variables
 */
/* Array of database columns which should be read and sent back to DataTables. Use a space where
 * you want to insert a non-database field (for example a counter or static image)
 */
$aColumns = array('temp_Jaringan_ID', 'temp_Jaringan_ID', 'kodeKelompok', 'uraian', 'kodeLokasi', 'Jumlah', 'NilaiPerolehan', 'temp_Jaringan_ID');
/* Indexed column (used for fast and accurate table cardinality) */
$sIndexColumn = "temp_Jaringan_ID";
/* DB table to use */
$sTable = "tmp_jaringan";
$dataParam['bup_nokontrak'] = $_GET['bup_nokontrak'];
$dataParam['jenisaset'][0] = $_GET['jenisaset'];
$dataParam['kodeSatker'] = $_GET['kodeSatker'];
$dataParam['page'] = $_GET['page'];
$RETRIEVE_PEROLEHAN = new RETRIEVE_PEROLEHAN();
$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN();
////pr($data);
//exit;
$sLimit = "";
if (isset($_GET['iDisplayStart']) && $_GET['iDisplayLength'] != '-1') {
    $sLimit = " " . intval($_GET['iDisplayStart']) . ", " . intval($_GET['iDisplayLength']);
}
/*
 * Ordering
 */
$sOrder = "";
if (isset($_GET['iSortCol_0'])) {
    $sOrder = "ORDER BY  ";
    for ($i = 0; $i < intval($_GET['iSortingCols']); $i++) {
        if ($_GET['bSortable_' . intval($_GET['iSortCol_' . $i])] == "true") {