コード例 #1
0
$dataParam['jenisaset'][0] = $_GET['jenisaset'];
if ($_GET['jenisaset'] == "2") {
    $merk = "m.Merk";
} else {
    $merk = "";
}
$aColumns = array('P.Penghapusan_ID', 'P.Usulan_ID', 'P.SatkerUsul', 'P.SatkerUsul', 'P.NoSKHapus', 'P.TglHapus', 'P.AlasanHapus', 'P.Penghapusan_ID');
/* Indexed column (used for fast and accurate table cardinality) */
$sIndexColumn = "Penghapusan_ID";
/* DB table to use */
$sTable = "penghapusan";
$dataParam['bup_nokontrak'] = $_GET['bup_nokontrak'];
$dataParam['jenisaset'][0] = $_GET['jenisaset'];
$dataParam['kodeSatker'] = $_GET['kodeSatker'];
$dataParam['page'] = $_GET['page'];
$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") {
            //$sOrder .= "'" . $aColumns[intval($_GET['iSortCol_' . $i])] . "' " .
<?php
include "../../config/config.php";

	$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;
	
    $menu_id = 39;
    ($SessionUser['ses_uid']!='') ? $Session = $SessionUser : $Session = $SESSION->get_session(array('title'=>'GuestMenu', 'ses_name'=>'menu_without_login')); 
    $SessionUser = $SESSION->get_session_user();
    $USERAUTH->FrontEnd_check_akses_menu($menu_id, $SessionUser);
?>

<?php
	include"$path/meta.php";
	include"$path/header.php";
	include"$path/menu.php";
	
?><script type="text/javascript" src="<?php echo "$url_rewrite/"; ?>JS/jquery.min.js"></script>
                    <script type="text/javascript" src="<?php echo "$url_rewrite/"; ?>JS/jquery-ui.min.js"></script> 
                    <script type="text/javascript" src="<?php echo "$url_rewrite/"; ?>JS/jquery.ui.datepicker-id.js"></script>
                    <script>
                    $(function()
                    {
                    $('#tanggal1').datepicker($.datepicker.regional['id']);
                    $('#tanggal2').datepicker($.datepicker.regional['id']);
                    $('#tanggal3').datepicker($.datepicker.regional['id']);
                    $('#tanggal4').datepicker($.datepicker.regional['id']);
                    $('#tanggal5').datepicker($.datepicker.regional['id']);
                    $('#tanggal6').datepicker($.datepicker.regional['id']);
                    $('#tanggal7').datepicker($.datepicker.regional['id']);
                    $('#tanggal8').datepicker($.datepicker.regional['id']);
                    $('#tanggal9').datepicker($.datepicker.regional['id']);
<?php
include "../../config/config.php";

$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;

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

// $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
	// if($_POST['submit']==''){
	// $dataPost=$_SESSION['dataPost'];
	// }else{
	// $_SESSION['dataPost']=$_POST;
	// $dataPost=$_SESSION['dataPost'];
	// }
	// $data = $PENGHAPUSAN->retrieve_penetapan_penghapusan_eksekusi_pmd($_POST);
	$idPenetapan=$_GET['id'];
	////pr($idPenetapan);
<?php
include "../../config/config.php";


$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;

        $menu_id = 38;
        ($SessionUser['ses_uid']!='') ? $Session = $SessionUser : $Session = $SESSION->get_session(array('title'=>'GuestMenu', 'ses_name'=>'menu_without_login')); 
        $SessionUser = $SESSION->get_session_user();
        $USERAUTH->FrontEnd_check_akses_menu($menu_id, $SessionUser);

        $nmaset=$_POST['penghapusan_nama_aset'];
        $UserNm=$_SESSION['ses_uoperatorid'];// usernm akan diganti jika session di implementasikan
        $usulan_id=get_auto_increment("Usulan");
        $date=date('Y-m-d');
        $ses_uid=$_SESSION['ses_uid'];
		// pr($nmaset);
		// echo "jml=".$nmaset;
        // exit;
        // $data = $STORE->store_usulan_penghapusan(
                // $UserNm,
                // $nmaset,
                // $usulan_id,
                // $date,
                // $ses_uid
                // );
        $data_post=$PENGHAPUSAN->apl_userasetlistHPS("USPMD");
        $POST=$_POST;
        // //pr($POST);
        $POST_data=$PENGHAPUSAN->apl_userasetlistHPS_filter($data_post);
        $POST['penghapusan_nama_aset']=$POST_data;
<?php
include "../../config/config.php";

$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;

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

// $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
	// if($_POST['submit']==''){
	// $dataPost=$_SESSION['dataPost'];
	// }else{
	// $_SESSION['dataPost']=$_POST;
	// $dataPost=$_SESSION['dataPost'];
	// }
	// $data = $PENGHAPUSAN->retrieve_penetapan_penghapusan_eksekusi_pmd($_POST);
	$idPenetapan=$_GET['id'];
	////pr($idPenetapan);
コード例 #6
0
<?php

include "../../config/config.php";

$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;

$menu_id = 38;
($SessionUser['ses_uid']!='') ? $Session = $SessionUser : $Session = $SESSION->get_session(array('title'=>'GuestMenu', 'ses_name'=>'menu_without_login')); 
$SessionUser = $SESSION->get_session_user();
$USERAUTH->FrontEnd_check_akses_menu($menu_id, $SessionUser);

$id=$_GET['id'];

// $dataArr = $DELETE->delete_daftar_usulan_penghapusan($id);

		$data = $PENGHAPUSAN->delete_daftar_usulan_penghapusan_pms($_GET);

    $DBVAR->log(7, $_POST);
/*
$query="UPDATE Usulan SET FixUsulan=0 WHERE Usulan_ID='$id' AND Jenis_Usulan='HPS'";
$exec=mysql_query($query) or die(mysql_error());


$query2="UPDATE Aset SET NotUse=0 WHERE Usulan_Penghapusan_ID='$id'";
$exec2=mysql_query($query2) or die(mysql_error());


$query3="DELETE FROM UsulanAset WHERE Usulan_ID='$id' AND Jenis_Usulan='HPS'";
$exec3=mysql_query($query3) or die(mysql_error());

$query4="UPDATE Aset SET Usulan_Penghapusan_ID=NULL WHERE Usulan_Penghapusan_ID='$id'";
コード例 #7
0
<?php
include "../../config/config.php";

	// $KIR = new RETRIEVE_KIR;
	$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;
	// pr($_POST);
	$kodeRuang = $_POST['kodeRuang'];
	$kodeSatker = $_POST['kodeSatker'];
	$tgl = $_POST['tglPerubahan'];
	// EXIT;
	$menu_id = 59;
	($SessionUser['ses_uid']!='') ? $Session = $SessionUser : $Session = $SESSION->get_session(array('title'=>'GuestMenu', 'ses_name'=>'menu_without_login')); 
	$SessionUser = $SESSION->get_session_user();
	$USERAUTH->FrontEnd_check_akses_menu($menu_id, $SessionUser);
		
	//select Aset_ID dari tabel apl_userasetlist
	$data_post=$PENGHAPUSAN->apl_userasetlistHPS("KIRASET");
	$addExplode = explode(",",$data_post[0]['aset_list']);
	$cleanArray = array_filter($addExplode);
	
	//implode Aset_ID
	$implodeAset_ID = implode(",",$cleanArray);
	// echo "implode ".$implodeAset_ID;
	// exit;
	
	//sql sementara
	//update ruangan di tabel aset
	$QueryAset	  = "UPDATE aset SET kodeRuangan = '$kodeRuang' WHERE Aset_ID in ($implodeAset_ID)";
	// pr($QueryAset);
	$ExeQueryAset = $DBVAR->query($QueryAset);
	$POST=$_POST;
<?php
include "../../config/config.php";

$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;

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

// $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
	// if($_POST['submit']==''){
	// $dataPost=$_SESSION['dataPost'];
	// }else{
	// $_SESSION['dataPost']=$_POST;
	// $dataPost=$_SESSION['dataPost'];
	// }

	$data_post=$PENGHAPUSAN->apl_userasetlistHPS("RVWPTUSPMD");
	// $
コード例 #9
0
<?php
include "../../config/config.php";

$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;
		$menu_id = 38;
        ($SessionUser['ses_uid']!='') ? $Session = $SessionUser : $Session = $SESSION->get_session(array('title'=>'GuestMenu', 'ses_name'=>'menu_without_login')); 
        $SessionUser = $SESSION->get_session_user();
        $USERAUTH->FrontEnd_check_akses_menu($menu_id, $SessionUser);
        
        $paging = $LOAD_DATA->paging($_GET['pid']);

// $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
			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());
コード例 #10
0
<?php
include "../../config/config.php";

$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;

            $asetid=$_GET['fleg'];
            pr($asetid);
if($_POST){

$data=$PENGHAPUSAN->cekdataPenghapusan($asetid,$_POST);
}else{

$data=$PENGHAPUSAN->cekdataPenghapusan($asetid);
}


pr($data);

?>
<form method="POST" action="<?php echo $url_rewrite;?>/module/penghapusan/datacekpenghapusan.php?fleg=<?php echo $asetid;?>">

<input type="text" name="asetidpost" value="<?php echo $asetid;?>" readonly/>
<table border="1">
	<thead>
		<tr>
			<td>Tabel</td>
			<td>Status Data Yang sudah Divalidasi Penghapusan</td>
		</tr>
	</thead>
	<tbody>
		<tr>
<?php
include "../../config/config.php";


$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;

        $menu_id = 38;
        ($SessionUser['ses_uid']!='') ? $Session = $SessionUser : $Session = $SESSION->get_session(array('title'=>'GuestMenu', 'ses_name'=>'menu_without_login')); 
        $SessionUser = $SESSION->get_session_user();
        $USERAUTH->FrontEnd_check_akses_menu($menu_id, $SessionUser);
?>

<?php
	include"$path/meta.php";
	include"$path/header.php";
	include"$path/menu.php";
	
?>
	<script type="text/javascript" src="<?php echo "$url_rewrite";?>/JS/script.js"></script>
    <script type="text/javascript" src="<?php echo "$url_rewrite";?>/JS2/simbada.js"></script>
	<script type="text/javascript" src="<?php echo "$url_rewrite";?>/JS2/simbada.js"></script>
		<!--[if IE]>
		<link rel="stylesheet" type="text/css" href="ie_office.css" />
		<![endif]-->
	<script type="text/javascript">
		function spoiler(obj)
		{
		var inner = obj.parentNode.parentNode.parentNode.parentNode.getElementsByTagName("tfoot")[0];
		//alert(obj.parentNode.parentNode.parentNode.parentNode.nodeName);
		if (inner.style.display =="none") {
		inner.style.display = "";
コード例 #12
0
<?php
include "../../config/config.php";
	
	$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;
	// pr($_POST);
	$kodepemilik = $_POST['kodepemilik'];
	$kodeSatker = $_POST['kodeSatker'];
	$tgl = $_POST['tglPerubahan'];
	// EXIT;
	$menu_id = 69;
	($SessionUser['ses_uid']!='') ? $Session = $SessionUser : $Session = $SESSION->get_session(array('title'=>'GuestMenu', 'ses_name'=>'menu_without_login')); 
	$SessionUser = $SESSION->get_session_user();
	$USERAUTH->FrontEnd_check_akses_menu($menu_id, $SessionUser);
		
	//select Aset_ID dari tabel apl_userasetlist
	$data_post=$PENGHAPUSAN->apl_userasetlistHPS("koreksipemilik");
	$addExplode = explode(",",$data_post[0]['aset_list']);
	$cleanArray = array_filter($addExplode);
	
	
	// pr($cleanArray);exit;
	
	foreach ($cleanArray as $key => $value) {
		$sql = "SELECT * FROM aset WHERE Aset_ID = '{$value}'";
		$exec = $DBVAR->query($sql);
		$aset = $DBVAR->fetch_array($exec);
		// pr($aset);exit;
		$old = explode(".", $aset['kodeLokasi']);
		$old[0] = $kodepemilik;
		$new = implode(".", $old);
		
コード例 #13
0
<?php
    include "../../config/config.php";
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
    
$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;

    $menu_id = 40;
    ($SessionUser['ses_uid']!='') ? $Session = $SessionUser : $Session = $SESSION->get_session(array('title'=>'GuestMenu', 'ses_name'=>'menu_without_login')); 
    $SessionUser = $SESSION->get_session_user();
    $USERAUTH->FrontEnd_check_akses_menu($menu_id, $SessionUser);
    
    $id=$_POST['usulanID'];
    
    // $data=$DELETE->delete_update_daftar_validasi_penghapusan($id);
	// //pr($_POST);
 //    exit;
		$data = $PENGHAPUSAN->update_usulan_penghapusan_asetid_pms($_POST);
    
    $DBVAR->log(7, $_POST);
    /*
    
    echo "$id";

    $query="UPDATE Penghapusan SET Status=0 WHERE Penghapusan_ID='$id'";
    $exec=mysql_query($query) or die(mysql_error());
    
    $query2="UPDATE PenghapusanAset SET Status=0 WHERE Penghapusan_ID='$id'";
    $exec=mysql_query($query2) or die(mysql_error());
コード例 #14
0
<?php
include "../../config/config.php";

	$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;
$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);

$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
		// $data = $PENGHAPUSAN->retrieve_daftar_penetapan_penghapusan($_POST);
		$data = $PENGHAPUSAN->retrieve_daftar_penetapan_penghapusan_validasi_psb($_POST);
		 $sql = mysql_query("SELECT * FROM kontrak ORDER BY id ");
        while ($dataKontrak = mysql_fetch_assoc($sql)){
                $kontrak[] = $dataKontrak;
            }
	?>
	<!-- End Sql -->

	<script>
<?php
include "../../config/config.php";


$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;

         $submit=$_POST['submit2'];
   //open_connection();
    $menu_id = 38;
    ($SessionUser['ses_uid']!='') ? $Session = $SessionUser : $Session = $SESSION->get_session(array('title'=>'GuestMenu', 'ses_name'=>'menu_without_login')); 
    $SessionUser = $SESSION->get_session_user();
    $USERAUTH->FrontEnd_check_akses_menu($menu_id, $SessionUser);
    
    $submit=$_POST['submit'];
	$id = $_POST['penghapusanfilter'];
	// pr($id);
    if (isset($submit))
	{
		unset($_SESSION['ses_retrieve_filter_'.$menu_id.'_'.$SessionUser['ses_uid']]);
		// $data = $RETRIEVE->retrieve_usulan_penghapusan_eksekusi($id);
	} else {

		$sessi = $_SESSION['ses_retrieve_filter_'.$menu_id.'_'.$SessionUser['ses_uid']];
		$parameter = array('menuID'=>$menu_id,'type'=>'checkbox','param'=>$sessi,'paging'=>$paging);
		// $data = $RETRIEVE->retrieve_usulan_penghapusan_eksekusi($id);
	}
                                
	echo '<pre>';
	// print_r($data['dataArr']);
	echo '</pre>';
?>
<?php
include "../../config/config.php";
	
	$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;

	$menu_id = 39;
    ($SessionUser['ses_uid']!='') ? $Session = $SessionUser : $Session = $SESSION->get_session(array('title'=>'GuestMenu', 'ses_name'=>'menu_without_login')); 
    $SessionUser = $SESSION->get_session_user();
    $USERAUTH->FrontEnd_check_akses_menu($menu_id, $SessionUser);
    
		if($_POST['jenis_hapus']){
			$_SESSION['jenis_hapus']=$_POST['jenis_hapus'];
		}
		
        $tgl_awal=$_POST['bup_pu_tanggalawal'];
        $tgl_akhir=$_POST['bup_pu_tanggalakhir'];
        $tgl_awal_fix=format_tanggal_db2($tgl_awal);
        $tgl_akhir_fix=format_tanggal_db2($tgl_akhir);
        $no_penetapan=$_POST['bup_pu_noskpenghapusan'];
        $satker=$_POST['skpd_id'];
        $submit=$_POST['tampil_filter'];

        
            if (isset($submit)){
                if ($tgl_awal=="" && $tgl_akhir=="" && $no_penetapan=="" && $satker==""){
    ?>
                <script>var r=confirm('Tidak ada isian filter');
                            if (r==false){
                                document.location="<?php echo "$url_rewrite/module/pemusnahan/"; ?>penetapan_pemusnahan_filter.php";
                            }
                    </script>
<?php
include "../../config/config.php"; 


$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;

$menu_id = 39;
($SessionUser['ses_uid']!='') ? $Session = $SessionUser : $Session = $SESSION->get_session(array('title'=>'GuestMenu', 'ses_name'=>'menu_without_login')); 
$SessionUser = $SESSION->get_session_user();
$USERAUTH->FrontEnd_check_akses_menu($menu_id, $SessionUser);
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
$id=$_POST['id'];
$no=$_POST['bup_pp_noskpenghapusan'];
$tgl=$_POST['bup_pp_tanggal'];
$olah_tgl=  format_tanggal_db2($tgl);
$keterangan=$_POST['bup_pp_get_keterangan'];
$submit=$_POST['btn_action'];
// pr($_POST);
// exit;

// $data=$UPDATE->update_daftar_penetapan_penghapusan($id,$no,$tgl,$olah_tgl,$keterangan,$submit);
	
	$data = $PENGHAPUSAN->update_daftar_penetapan_penghapusan($_POST);

/*
echo "$id";
echo "$no";
echo "$olah_tgl";
<?php
include "../../config/config.php";

$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;
$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);

// $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

	$id=$_GET['id'];
				// //////pr($id);
				if (isset($id))
				{
					unset($_SESSION['ses_retrieve_filter_'.$menu_id.'_'.$SessionUser['ses_uid']]);
					$parameter = array('id'=>$id);
					// $data = $RETRIEVE->retrieve_penetapan_penghapusan_edit_data($parameter);
					
						// //////pr($_POST);
コード例 #19
0
 * 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") {
            //$sOrder .= "'" . $aColumns[intval($_GET['iSortCol_' . $i])] . "' " .
<?php
include "../../config/config.php";

	$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;
	
    $menu_id = 39;
    ($SessionUser['ses_uid']!='') ? $Session = $SessionUser : $Session = $SESSION->get_session(array('title'=>'GuestMenu', 'ses_name'=>'menu_without_login')); 
    $SessionUser = $SESSION->get_session_user();
    $USERAUTH->FrontEnd_check_akses_menu($menu_id, $SessionUser);
?>

<?php
	include"$path/meta.php";
	include"$path/header.php";
	include"$path/menu.php";
	
?><script type="text/javascript" src="<?php echo "$url_rewrite/"; ?>JS/jquery.min.js"></script>
                    <script type="text/javascript" src="<?php echo "$url_rewrite/"; ?>JS/jquery-ui.min.js"></script> 
                    <script type="text/javascript" src="<?php echo "$url_rewrite/"; ?>JS/jquery.ui.datepicker-id.js"></script>
                    <script>
                    $(function()
                    {
                    $('#tanggal1').datepicker($.datepicker.regional['id']);
                    $('#tanggal2').datepicker($.datepicker.regional['id']);
                    $('#tanggal3').datepicker($.datepicker.regional['id']);
                    $('#tanggal4').datepicker($.datepicker.regional['id']);
                    $('#tanggal5').datepicker($.datepicker.regional['id']);
                    $('#tanggal6').datepicker($.datepicker.regional['id']);
                    $('#tanggal7').datepicker($.datepicker.regional['id']);
                    $('#tanggal8').datepicker($.datepicker.regional['id']);
                    $('#tanggal9').datepicker($.datepicker.regional['id']);
<?php
    include "../../config/config.php";
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
    
$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;

    $menu_id = 40;
    ($SessionUser['ses_uid']!='') ? $Session = $SessionUser : $Session = $SESSION->get_session(array('title'=>'GuestMenu', 'ses_name'=>'menu_without_login')); 
    $SessionUser = $SESSION->get_session_user();
    $USERAUTH->FrontEnd_check_akses_menu($menu_id, $SessionUser);
    
    

    $data_post=$PENGHAPUSAN->apl_userasetlistHPS("DELUSPMD");
    $POST=$_POST;

    $POST_data=$PENGHAPUSAN->apl_userasetlistHPS_filter($data_post);
    $POST['penghapusan_nama_aset']=$POST_data;
    // pr($POST);
    // $data=$DELETE->delete_update_daftar_validasi_penghapusan($id);
	// pr($_POST);
    // exit;
		$data = $PENGHAPUSAN->delete_usulan_penghapusan_asetid_pmd($POST);
    $id=$POST['usulanID'];

    $data_delete=$PENGHAPUSAN->apl_userasetlistHPS_del("DELUSPMD");
    /*
    
コード例 #22
0
$dataParam['jenisaset'][0] = $_GET['jenisaset'];
if ($_GET['jenisaset'] == "2") {
    $merk = "m.Merk";
} else {
    $merk = "";
}
$aColumns = array('Usl.Usulan_ID', 'Usl.NoUsulan', 'Usl.SatkerUsul', 'Usl.SatkerUsul', 'Usl.TglUpdate', 'Usl.SatkerUsul', 'Usl.KetUsulan', 'Usl.SatkerUsul');
/* Indexed column (used for fast and accurate table cardinality) */
$sIndexColumn = "Usulan_ID";
/* DB table to use */
$sTable = "usulan";
$dataParam['bup_pp_sp_nousulan'] = $_GET['bup_pp_sp_nousulan'];
// $dataParam['jenisaset'][0]=$_GET['jenisaset'];
$dataParam['kodeSatker'] = $_GET['kodeSatker'];
$dataParam['page'] = $_GET['page'];
$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") {
            //$sOrder .= "'" . $aColumns[intval($_GET['iSortCol_' . $i])] . "' " .
コード例 #23
0
<?php
include "../../config/config.php";

$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;
$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);

// $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
	if($_SESSION['kdSatkerFilterPMD']){
		$kdSatkerFilter=$_SESSION['kdSatkerFilterPMD'];
	}

	// if(isset($_POST['reviewAsetUsulan']) && $_POST['reviewAsetUsulan']==1){
	// 	$_SESSION['reviewAsetUsulan']=$_POST;
	// 	$POST=$_SESSION['reviewAsetUsulan'];
	// 	pr($POST);
	// 	pr("!");
	// }else{
コード例 #24
0
<?php
include "../../config/config.php";


$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;
//////pr($_SESSION);
$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);

// $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
		$paging = $LOAD_DATA->paging($_GET['pid']);
		unset($_SESSION['ses_retrieve_filter_'.$menu_id.'_'.$SessionUser['ses_uid']]);
		$parameter = array('menuID'=>$menu_id,'type'=>'','paging'=>$paging);
		// $data = $RETRIEVE->retrieve_daftar_validasi_penghapusan($parameter);
        // //////pr($data);        
	// //////pr($_POST);
	$data = $PENGHAPUSAN->retrieve_validasi_penghapusan_pmd($_POST);
	// ////pr($data);
<?php
include "../../config/config.php"; 


$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;

$menu_id = 39;
($SessionUser['ses_uid']!='') ? $Session = $SessionUser : $Session = $SESSION->get_session(array('title'=>'GuestMenu', 'ses_name'=>'menu_without_login')); 
$SessionUser = $SESSION->get_session_user();
$USERAUTH->FrontEnd_check_akses_menu($menu_id, $SessionUser);

$id=$_GET['id'];

// $data=$DELETE->delete_daftar_penetapan_penghapusan($id);
		$data = $PENGHAPUSAN->delete_daftar_penetapan_penghapusan($id);
// pr($id);exit;
/*
$querytampil="SELECT * FROM PenghapusanAset WHERE Penghapusan_ID='$id'";
$exectampil=  mysql_query($querytampil) or die(mysql_error());
while($row=  mysql_fetch_array($exectampil)){

$asetid = $row['Aset_ID'];

$query4="UPDATE Aset SET Dihapus=0 WHERE Aset_ID='$asetid'";
$exec4=mysql_query($query4) or die(mysql_error());
}   

$query="UPDATE Penghapusan SET FixPenghapusan=0 WHERE Penghapusan_ID='$id'";
$exec=mysql_query($query) or die(mysql_error());

$query2="UPDATE UsulanAset SET StatusPenetapan=0 WHERE Penetapan_ID='$id' AND Jenis_Usulan='HPS'";
コード例 #26
0
    $merk = "m.Merk";
} else {
    $merk = "ast.Aset_ID";
}
$aColumns = array('ast.Aset_ID', 'ast.Aset_ID', 'ast.noRegister', 'ast.noKontrak', 'k.Uraian', 'ast.kodeSatker', 'ast.TglPerolehan', 'ast.NilaiPerolehan', 'ast.AsalUsul', $merk);
/* Indexed column (used for fast and accurate table cardinality) */
$sIndexColumn = "Aset_ID";
/* DB table to use */
$sTable = "aset";
$dataParam['bup_nokontrak'] = $_GET['bup_nokontrak'];
$dataParam['bup_tahun'] = $_GET['bup_tahun'];
$dataParam['jenisaset'][0] = $_GET['jenisaset'];
$dataParam['kodeSatker'] = $_GET['kodeSatker'];
$dataParam['kodeKelompok'] = $_GET['kodeKelompok'];
$dataParam['page'] = $_GET['page'];
$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") {
            //$sOrder .= "'" . $aColumns[intval($_GET['iSortCol_' . $i])] . "' " .
<?php
    include "../../config/config.php";
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
    
$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;

    $menu_id = 40;
    ($SessionUser['ses_uid']!='') ? $Session = $SessionUser : $Session = $SESSION->get_session(array('title'=>'GuestMenu', 'ses_name'=>'menu_without_login')); 
    $SessionUser = $SESSION->get_session_user();
    $USERAUTH->FrontEnd_check_akses_menu($menu_id, $SessionUser);
    
    $id=$_GET['id'];
    
    // $data=$DELETE->delete_update_daftar_validasi_penghapusan($id);
	
		$data = $PENGHAPUSAN->delete_update_daftar_validasi_penghapusan_psb($_GET);
    
    /*
    
    echo "$id";

    $query="UPDATE Penghapusan SET Status=0 WHERE Penghapusan_ID='$id'";
    $exec=mysql_query($query) or die(mysql_error());
    
    $query2="UPDATE PenghapusanAset SET Status=0 WHERE Penghapusan_ID='$id'";
    $exec=mysql_query($query2) or die(mysql_error());
    */
    echo "<script>alert('Data Berhasil Dihapus'); document.location='$url_rewrite/module/penghapusan/penghapusan_validasi_daftar_valid.php?pid=1';</script>";
コード例 #28
0
<?php
include "../../config/config.php";

$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;
$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);

// $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
	// if($_SESSION['filterAsetUsulan'])
	// ////pr($_SESSION['filterAsetUsulan']);
	// pr($_SESSION);
	if ($_POST['submit']){
		// unset($_SESSION['ses_mutasi_filter']);
		// pr($_POST);
		$_SESSION['filterAsetUsulan'] = $_POST;

		$data_post=$PENGHAPUSAN->apl_userasetlistHPS("RVWUSPSB");
<?php
    include "../../config/config.php";
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
    
$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;

    $menu_id = 40;
    ($SessionUser['ses_uid']!='') ? $Session = $SessionUser : $Session = $SESSION->get_session(array('title'=>'GuestMenu', 'ses_name'=>'menu_without_login')); 
    $SessionUser = $SESSION->get_session_user();
    $USERAUTH->FrontEnd_check_akses_menu($menu_id, $SessionUser);
    
    $id=$_GET['id'];
    
    // $data=$DELETE->delete_update_daftar_validasi_penghapusan($id);
	
		$data = $PENGHAPUSAN->delete_usulan_penghapusan_asetid_psb($_GET);
    
    /*
    
    echo "$id";

    $query="UPDATE Penghapusan SET Status=0 WHERE Penghapusan_ID='$id'";
    $exec=mysql_query($query) or die(mysql_error());
    
    $query2="UPDATE PenghapusanAset SET Status=0 WHERE Penghapusan_ID='$id'";
    $exec=mysql_query($query2) or die(mysql_error());
    */
    echo "<script>alert('Data Berhasil Dihapus'); document.location='$url_rewrite/module/penghapusan/penghapusan_usulan_daftar_view_edit_pmd.php?id=$id';</script>";
<?php
include "../../config/config.php";

$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;

        $menu_id = 38;
        ($SessionUser['ses_uid']!='') ? $Session = $SessionUser : $Session = $SESSION->get_session(array('title'=>'GuestMenu', 'ses_name'=>'menu_without_login')); 
        $SessionUser = $SESSION->get_session_user();
        $USERAUTH->FrontEnd_check_akses_menu($menu_id, $SessionUser);
        
        $paging = $LOAD_DATA->paging($_GET['pid']);
	?>
	
<?php

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

?>


          <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><a href="#">Penghapusan</a><span class="divider"><b>&raquo;</b></span></li>
			  <li class="active">Daftar Usulan Penghapusan Pemindahtanganan</li>
			  <?php SignInOut();?>
			</ul>
			<div class="breadcrumb">