$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);
<?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";
$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");
/*
$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">