$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 = 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'";
<?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"); // $
<?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());
<?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 = "";
<?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);
<?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());
<?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);
* 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"; /* * 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"); /*
$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])] . "' " .
<?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{
<?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'";
$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>";
<?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>»</b></span></li> <li><a href="#">Penghapusan</a><span class="divider"><b>»</b></span></li> <li class="active">Daftar Usulan Penghapusan Pemindahtanganan</li> <?php SignInOut();?> </ul> <div class="breadcrumb">