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

$PEMANFAATAN = new RETRIEVE_PEMANFAATAN;


$data = $PEMANFAATAN->pemanfaatan_penetapan_hapus_proses($_GET);
if ($data){
	echo "<script>alert('Data Sudah Terhapus'); document.location='$url_rewrite/module/pemanfaatan/pemanfaatan_penetapan_daftar.php';</script>";
}
exit;
$id=$_GET['id'];

$query="UPDATE Pemanfaatan SET FixPemanfaatan=0 WHERE Pemanfaatan_ID='$id'";
$exec=mysql_query($query) or die(mysql_error());

$query2="UPDATE UsulanAset SET StatusPenetapan=0 WHERE Penetapan_ID='$id' AND Jenis_Usulan='MNF'";
$exec2=mysql_query($query2) or die(mysql_error());

$query3="DELETE FROM PemanfaatanAset WHERE Pemanfaatan_ID='$id' AND Status=0 AND StatusPengembalian=0";
$exec3=mysql_query($query3) or die(mysql_error());

$query4="UPDATE Aset SET CurrentPemanfaatan_ID=NULL, LastPemanfaatan_ID=NULL WHERE LastPemanfaatan_ID='$id'";
$exec4=mysql_query($query4) or die(mysql_error());

echo "<script>alert('Data Sudah Terhapus'); document.location='$url_rewrite/module/pemanfaatan/pemanfaatan_penetapan_daftar.php';</script>";
?>
<?php

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

$PEMANFAATAN = new RETRIEVE_PEMANFAATAN;

                                    /*
                                    $nama_aset=$_POST['peman_penet_nama_aset'];
                                    $no=$_POST['peman_penet_eks_nopenet'];
                                    $tgl=$_POST['peman_penet_eks_tglpenet'];
                                    $tipe=$_POST['peman_penet_eks_tipe'];
                                    $ket=$_POST['peman_penet_eks_ket'];
                                    $nama_partner=$_POST['peman_penet_eks_nmpartner'];
                                    $alamat_partner=$_POST['peman_penet_eks_alamatpartner'];
                                    $tgl_mulai=$_POST['peman_penet_eks_tglmulai'];
                                    $tgl_selesai=$_POST['peman_penet_eks_tglselesai'];
                                    $jangka_waktu=$_POST['peman_penet_eks_jangkawaktu'];
                                    */

$UserNm=$_SESSION['ses_uoperatorid'];// usernm akan diganti jika session di implementasikan
$nmaset=$_POST['peman_penet_nama_aset'];
$aseid=implode(",",$nmaset);

$asset_id=Array();
$no_reg=Array();
$nm_barang=Array();
$panjang=count($nmaset);

$no=$_POST['peman_penet_eks_nopenet'];
$tgl=$_POST['peman_penet_eks_tglpenet'];
$olah_tgl=  format_tanggal_db2($tgl);
<?php
include "../../config/config.php";
	
	$PEMANFAATAN = new RETRIEVE_PEMANFAATAN;

?>
<?php
	include"$path/meta.php";
	include"$path/header.php";
	include"$path/menu.php";
	

	$data = $PEMANFAATAN->pemanfaatan_validasi_daftar_valid($_POST);
	// pr($data);

			?>


          <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="#">Pemanfaatan</a><span class="divider"><b>&raquo;</b></span></li>
			  <li class="active">Daftar Validasi Barang Pemanfaatan</li>
			  <?php SignInOut();?>
			</ul>
			<div class="breadcrumb">
				<div class="title">Daftar Validasi Barang Pemanfaatan</div>
				<div class="subtitle">Daftar Data</div>
			</div>	
		<section class="formLegend">
			
<?php
include "../../config/config.php";


$PEMANFAATAN = new RETRIEVE_PEMANFAATAN;

$menu_id = 33;
($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['peman_usul_nama_aset'];
$UserNm=$_SESSION['ses_uname'];// usernm akan diganti jika session di implementasikan
$usulan_id=get_auto_increment("Usulan");
$date=date('Y-m-d');
$ses_uid=$_SESSION['ses_uid'];



$asset_id=Array();
$no_reg=Array();
$nm_barang=Array();

$panjang=count($nmaset);

 $query="insert into Usulan (Usulan_ID, Aset_ID, Penetapan_ID, 
                                    Jenis_Usulan, UserNm, TglUpdate, 
                                    GUID, FixUsulan) 
                                values ('', '', '', 'MNF', '$UserNm', '$date', '', '1')";
    <?php
        include "../../config/config.php"; 

        $PEMANFAATAN = new RETRIEVE_PEMANFAATAN;
    ?>
<html>
    <?php
        include "$path/header.php";
    ?>
	<script type="text/javascript">
		function show_confirm()
		{
		var r=confirm("Data yang akan ditetapkan pemanfaatan sudah benar ?");
		if (r==true)
		  {
		  alert("Data akan masuk ke form validasi pemanfaatan");
		  document.location="<?php echo "$url_rewrite/module/pemanfaatan/"; ?>pemanfaatan_penetapan_filter.php";
		  }
		else
		  {
		  alert("You pressed Cancel!");
		  document.location="<?php echo "$url_rewrite/module/pemanfaatan/"; ?>pemanfaatan_penetapan_eksekusi_data.php";
		  }
		}
	</script>
                    <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()
                        {
<?php
    include "../../config/config.php";
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

$PEMANFAATAN = new RETRIEVE_PEMANFAATAN;
   

$data = $PEMANFAATAN->pemanfaatan_validasi_daftar_hapus($_GET);
if ($data){
	echo "<script>alert('Data Berhasil Dihapus'); document.location='pemanfaatan_validasi_daftar_valid.php?pid=1';</script>";
}
exit;
    $id=$_GET['id'];
    //echo "$id";

    $query="UPDATE Pemanfaatan SET Status=0 WHERE Pemanfaatan_ID='$id'";
    $exec=mysql_query($query) or die(mysql_error());
    
    $query2="UPDATE PemanfaatanAset SET Status=0 WHERE Pemanfaatan_ID='$id' AND StatusPengembalian=0";
    $exec=mysql_query($query2) or die(mysql_error());
    
    echo "<script>alert('Data Berhasil Dihapus'); document.location='pemanfaatan_validasi_daftar_valid.php?pid=1';</script>";
?>
<?php
include "../../config/config.php";

$PEMANFAATAN = new RETRIEVE_PEMANFAATAN;
?>
<?php
	include"$path/meta.php";
	include"$path/header.php";
	include"$path/menu.php";
	
	// pr($_POST);
	$data = $PEMANFAATAN->retrieve_usulan_pemanfaatan_eksekusi($_POST);
	// pr($data);
			?>

<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 = "";
									document.getElementById(obj.id).value="Tutup Detail";}
									else {
									inner.style.display = "none";
									document.getElementById(obj.id).value="View Detail";}
									}
						
									function spoilsub(obj)
									{
									var inner = obj.parentNode.parentNode.parentNode.parentNode.parentNode.getElementsByTagName("div")[1];
<?php
include "../../config/config.php";

$PEMANFAATAN = new RETRIEVE_PEMANFAATAN;

        $no_penetapan=$_POST['peman_valid_filt_nopenet'];
        $tgl_penetapan=$_POST['peman_valid_filt_tglpenet'];
        $tgl_fix=format_tanggal_db2($tgl_penetapan);
        $tipe_pemanfaatan=$_POST['peman_valid_filt_tipe'];
        $alasan=$_POST['peman_valid_filt_alasan'];
        $submit=$_POST['tampil_valid_filter'];
        
        //open_connection();
        
        if ($no_penetapan!=""){
            $query_no_penetapan="NoSKKDH LIKE '%$no_penetapan%'";
            }
            if($tgl_penetapan!=""){
            $query_tgl_penetapan="TglSKKDH LIKE '%$tgl_fix%'";
            }
            if($tipe_pemanfaatan!=""){
            $query_tipe_pemanfaatan="TipePemanfaatan LIKE '%$tipe_pemanfaatan%'";
            }
            if($alasan!=""){
            $query_alasan="Keterangan LIKE '%$alasan%'";
            }

            $parameter_sql="";
            if($no_penetapan!=""){
            $parameter_sql=$query_no_penetapan;
            }
<?php
include "../../config/config.php";

$PEMANFAATAN = new RETRIEVE_PEMANFAATAN;

 $menu_id = 34;
        $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, $SessionUser);
        
        $tgl_awal=$_POST['peman_penet_filt_tglawal'];
        $tgl_akhir=$_POST['peman_penet_filt_tglakhir'];
        $tgl_awal_fix=format_tanggal_db2($tgl_awal);
        $tgl_akhir_fix=format_tanggal_db2($tgl_akhir);
        $no_penetapan=$_POST['peman_penet_filt_nopenet'];
        $alasan=$_POST['peman_penet_filt_alasan'];
        $submit=$_POST['tampil_filter'];

        //open_connection();
        
       
            if ($tgl_awal_fix!=""){
            $query_tgl_awal="TglSKKDH LIKE '%$tgl_awal_fix%'";
            }
            if($tgl_akhir_fix!=""){
            $query_tgl_akhir="TglSKKDH LIKE '%$tgl_akhir_fix%'";
            }
            if($no_penetapan!=""){
            $query_np="NoSKKDH LIKE '%$no_penetapan%'";
            }
            if($alasan!=""){
<?php
include "../../config/config.php"; 
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
 // pr($_POST);

$PEMANFAATAN = new RETRIEVE_PEMANFAATAN;

$id=$_POST['id'];
$no=$_POST['peman_penet_eks_nopenet'];
$tgl=$_POST['peman_penet_eks_tglpenet'];
$olah_tgl=  format_tanggal_db2($tgl);
$tipe=$_POST['peman_penet_eks_tipe'];
$ket=$_POST['peman_penet_eks_ket'];
$nama_partner=$_POST['peman_penet_eks_nmpartner'];
$alamat_partner=$_POST['peman_penet_eks_alamatpartner'];
$tgl_mulai=$_POST['peman_penet_eks_tglmulai'];
$olah_tgl_mulai=  format_tanggal_db2($tgl_mulai);
$tgl_selesai=$_POST['peman_penet_eks_tglselesai'];
$olah_tgl_selesai=  format_tanggal_db2($tgl_selesai);
$jangka_waktu=$_POST['peman_penet_eks_jangkawaktu'];
$submit=$_POST['submit'];
// exit;
/*
echo "$id";
echo "$no";
echo "$olah_tgl";
echo "$tipe";
echo "$ket";
<?php

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

$PEMANFAATAN = new RETRIEVE_PEMANFAATAN;

$menu_id = 33;
($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);
// pr($_POST);
$nmaset=$_POST['peman_usul_nama_aset'];
$asetID=implode(",",$nmaset);
$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'];
// exit;
$asset_id=Array();
$no_reg=Array();
$nm_barang=Array();

$panjang=count($nmaset);

// pr($_POST);
$data = $PEMANFAATAN->store_usulan_pemanfaatan($_POST);


echo "<script>
            alert('Data Berhasil Disimpan');
            document.location='$url_rewrite/module/pemanfaatan/pemanfaatan_usulan_eksekusi_data_proses.php?usulan_id=$usulan_id';
    <?php
        include "../../config/config.php"; 

        $PEMANFAATAN = new RETRIEVE_PEMANFAATAN;
    ?>
<html>
    <?php
        include "$path/header.php";
    ?>
	<script type="text/javascript">
		function show_confirm()
		{
		var r=confirm("Data yang akan ditetapkan pemanfaatan sudah benar ?");
		if (r==true)
		  {
		  alert("Data akan masuk ke form validasi pemanfaatan");
		  document.location="<?php echo "$url_rewrite/module/pemanfaatan/"; ?>pemanfaatan_penetapan_filter.php";
		  }
		else
		  {
		  alert("You pressed Cancel!");
		  document.location="<?php echo "$url_rewrite/module/pemanfaatan/"; ?>pemanfaatan_penetapan_eksekusi_data.php";
		  }
		}
	</script>
                    <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()
                        {
<?php
include "../../config/config.php";

$PEMANFAATAN = new RETRIEVE_PEMANFAATAN;

        $tgl_awal=$_POST['peman_penet_bmd_filt_tglawal'];
        $tgl_akhir=$_POST['peman_penet_bmd_filt_tglakhir'];
        $tgl_awal_fix=format_tanggal_db2($tgl_awal);
        $tgl_akhir_fix=format_tanggal_db2($tgl_akhir);
        $no_penetapan_idle=$_POST['peman_penet_bmd_filt_nopenet'];
        $alasan=$_POST['peman_penet_bmd_filt_alasan'];
        $submit=$_POST['tampil_idle'];
			
		
            
            //echo "$parameter_sql";
            
            
        if (isset($submit)){
                if ($tgl_awal=="" && $tgl_akhir=="" && $no_penetapan_idle=="" && $alasan==""){
    ?>
                <script>var r=confirm('Tidak ada isian filter');
                            if (r==false){
                                document.location="<?php echo "$url_rewrite/module/pemanfaatan/"; ?>pemanfaatan_penetapan_idle_filter.php";
                            }
                    </script>
        <?php
            }
        }
        ?>
<?php
<?php
include "../../config/config.php";

$PEMANFAATAN = new RETRIEVE_PEMANFAATAN;

		 $tgl_awal=$_POST['peman_pengem_filt_tglawal'];
        $tgl_akhir=$_POST['peman_pengem_filt_tglakhir'];
        $tgl_awal_fix=format_tanggal_db2($tgl_awal);
        $tgl_akhir_fix=format_tanggal_db2($tgl_akhir);
        $no_pemanfaatan_pengembalian=$_POST['peman_pengem_filt_nopenet'];
        $lokasibast=$_POST['peman_pengem_filt_lokasi'];
        $submit=$_POST['tampil_filter'];
        
        //open_connection();
        
       
            if ($tgl_awal_fix!=""){
            $query_tgl_awal="TglBAST LIKE '%$tgl_awal_fix%'";
            }
            if($tgl_akhir_fix!=""){
            $query_tgl_akhir="TglBAST LIKE '%$tgl_akhir_fix%'";
            }
            if($no_pemanfaatan_pengembalian!=""){
            $query_np="NoBAST LIKE '%$no_pemanfaatan_pengembalian%'";
            }
            if($lokasibast!=""){
            $query_lokasi="LokasiBAST LIKE '%$lokasibast%'";
            }
            

            $parameter_sql="";