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;
$POST_data=$PENGHAPUSAN->apl_userasetlistHPS_filter($data_post);
// if(isset($_POST['reviewAsetUsulan']) && $_POST['reviewAsetUsulan']==1){
// $_SESSION['reviewAsetUsulan']=$_POST;
// $POST=$_SESSION['reviewAsetUsulan'];
// pr($POST);
// pr("!");
// }else{
// pr($_POST);
// ////////pr($_SESSION['reviewAsetUsulan']);
// foreach ($_POST['penghapusanfilter'] as $key => $value) {
// $_SESSION['reviewAsetUsulan']['penghapusanfilter'][]=$value;
// }
// $POST=$_SESSION['reviewAsetUsulan'];
// pr($POST);
// pr("?");
// }
$data_post=$PENGHAPUSAN->apl_userasetlistHPS("RVWUSPMD");
$POST=$PENGHAPUSAN->apl_userasetlistHPS_filter($data_post);
$POST['penghapusanfilter']=$POST;
// exit;
$data = $PENGHAPUSAN->retrieve_usulan_penghapusan_eksekusi_pmd($POST);
////pr($data);
$sql = mysql_query("SELECT * FROM kontrak ORDER BY id ");
while ($dataKontrak = mysql_fetch_assoc($sql)){
$kontrak[] = $dataKontrak;
}
?>
<!-- End Sql -->
<script>
$(function()
$iFilteredTotal = $aResultFilterTotal[0];
//echo $iFilteredTotal ;
/* Total data set length */
$sQuery = "\n\t\tSELECT COUNT(`" . $sIndexColumn . "`)\n\t\tFROM {$sTable}\n\t";
//echo "$sQuery";
$rResultTotal = $DBVAR->query($sQuery);
$aResultTotal = $DBVAR->fetch_array($rResultTotal);
////pr($aResultTotal );
$iTotal = $aResultTotal[0];
/*
* Output
*/
$output = array("sEcho" => intval($_GET['sEcho']), "iTotalRecords" => $iTotal, "iTotalDisplayRecords" => $iFilteredTotal, "aaData" => array());
/////pr($output);
//exit;
$data_post = $PENGHAPUSAN->apl_userasetlistHPS("XLSIMPB");
$POST = $PENGHAPUSAN->apl_userasetlistHPS_filter($data_post);
if ($POST) {
foreach ($POST as $key => $value) {
$tmp = explode("|", $value);
$newlist[$key] = $tmp[0];
}
} else {
$newlist = array();
}
// //////pr($_SESSION['reviewAsetUsulan']['penghapusanfilter']);
foreach ($dataSESSION as $keySESSION => $valueSESSION) {
// //////pr($valueSESSION['Aset_ID']);
if (!in_array($valueSESSION['tmp_Mesin_ID'], $newlist)) {
// echo "stringnot";
$data[] = $valueSESSION;
$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("USPSB");
$POST=$_POST;
// //pr($POST);
$POST_data=$PENGHAPUSAN->apl_userasetlistHPS_filter($data_post);
$POST['penghapusan_nama_aset']=$POST_data;
// //pr($POST);
// exit;
$data = $PENGHAPUSAN->store_usulan_penghapusan_psb($POST);
$DBVAR->log(7, $_POST);
$data_postRVW=$PENGHAPUSAN->apl_userasetlistHPS("RVWUSPSB");
if($data_postRVW){
$data_delete=$PENGHAPUSAN->apl_userasetlistHPS_del("RVWUSPSB");
}
if($data_post){
$data_delete=$PENGHAPUSAN->apl_userasetlistHPS_del("USPSB");
<?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_post=$PENGHAPUSAN->apl_userasetlistHPS("DELUSPMS");
$POST=$_POST;
$POST_data=$PENGHAPUSAN->apl_userasetlistHPS_filter($data_post);
$POST['penghapusan_nama_aset']=$POST_data;
// $data=$DELETE->delete_update_daftar_validasi_penghapusan($id);
// //pr($_POST);
// exit;
$data = $PENGHAPUSAN->delete_usulan_penghapusan_asetid_pms($POST);
$id=$POST['usulanID'];
$data_delete=$PENGHAPUSAN->apl_userasetlistHPS_del("DELUSPMS");
/*
echo "$id";
include "../../config/config.php";
$PENGHAPUSAN = new RETRIEVE_PENGHAPUSAN;
$menu_id = 40;
$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);
$submit=$_POST['submit'];
$ses_uid=$_SESSION['ses_uid'];
$parameter=array('submit'=>$submit, 'ses_uid'=>$ses_uid);
// $data=$UPDATE->update_validasi_penghapusan($parameter);
$data_post=$PENGHAPUSAN->apl_userasetlistHPS("VLDUSPSB");
// pr($data_post);
$POST=$_POST;
// //pr($POST);
$POST_data=$PENGHAPUSAN->apl_userasetlistHPS_filter($data_post);
$POST['ValidasiPenghapusan']=$POST_data;
// pr($_POST);
// exit;
$data = $PENGHAPUSAN->update_validasi_penghapusan_psb($_POST);
if($data_post){
$data_delete=$PENGHAPUSAN->apl_userasetlistHPS_del("VLDUSPSB");
}
/*
$query = "SELECT aset_list FROM apl_userasetlist WHERE aset_action = 'ValidasiPenghapusan' AND UserSes = '$_SESSION[ses_uid]'";
