<?php include "../../config/config.php"; $menu_id = 64; ($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); // $PENYUSUTAN = new RETRIEVE_PENYUSUTAN; $PENYUSUTAN = new RETRIEVE_PENYUSUTAN; // pr($_POST); $noPenetapan = $_POST['Penyusutan_ID']; $kodeSatker = $_POST['Satker_ID']; //select Aset_ID dari tabel apl_userasetlist $data_post=$PENYUSUTAN->apl_userasetlistHPS("PNTPNUSULASETFIX"); $addExplode = explode(",",$data_post[0]['aset_list']); $cleanArray = array_filter($addExplode); $implodeAset_ID = implode(",",$cleanArray); if($implodeAset_ID != ''){ //update StatusKonfirmasi di usulanaset $QueryUsulanAset = "UPDATE usulanaset SET StatusKonfirmasi = '1' WHERE Penetapan_ID = '$noPenetapan' and Aset_ID in ($implodeAset_ID)"; $ExeQueryUsulanAset = $DBVAR->query($QueryUsulanAset); $QueryPenyusutan = "UPDATE penyusutan SET Status = '1' WHERE Penyusutan_ID = '$noPenetapan'"; $ExeQueryPenyusutan = $DBVAR->query($QueryPenyusutan); $tahun = date('Y'); $QueryPenyusutanPertahun = "INSERT INTO penyusutan_pertahun (Penyusutan_ID,Aset_ID,Tahun) VALUES ('{$noPenetapan}','{$implodeAset_ID}','{$tahun}')"; $ExeQueryPenyusutanPertahun = $DBVAR->query($QueryPenyusutanPertahun); //count Aset_ID
<?php include "../../config/config.php"; $data = $_GET['id']; $PENYUSUTAN = new RETRIEVE_PENYUSUTAN(); $InputUsulan = $PENYUSUTAN->DeletePenetapan($data); $InputUsulan_2 = $PENYUSUTAN->DeletePenetapanAset($data); echo "<script>\n\t\t\talert('Data Berhasil Dihapus');\n\t\t</script>"; redirect($url_rewrite . '/module/penyusutan/dftr_penetapan_pnystn.php?pid=1');
<?php include "../../config/config.php"; $data = $_POST; $PENYUSUTAN = new RETRIEVE_PENYUSUTAN; $InputUsulan=$PENYUSUTAN->UpdatePenetapan($data); echo "<script> alert('Data Berhasil Disimpan'); </script>"; redirect($url_rewrite.'/module/penyusutan/dftr_penetapan_pnystn.php?pid=1'); ?>
// /* Data set length after filtering */ $sQuery = "\n\t\tSELECT FOUND_ROWS()\n\t"; $rResultFilterTotal = $DBVAR->query($sQuery) or fatal_error('MySQL Error: ' . mysql_errno()); $aResultFilterTotal = $DBVAR->fetch_array($rResultFilterTotal); $iFilteredTotal = $aResultFilterTotal[0]; // echo $iFilteredTotal ; /* Total data set length */ $sQuery = "\n\t\tSELECT COUNT(`" . $sIndexColumn . "`)\n\t\tFROM {$sTable} {$sWhere}\n\t"; $rResultTotal = $DBVAR->query($sQuery) or fatal_error('MySQL Error: ' . mysql_errno()); $aResultTotal = $DBVAR->fetch_array($rResultTotal); $iTotal = $aResultTotal[0]; /* * Output */ $output = array("sEcho" => intval($_GET['sEcho']), "iTotalRecords" => $iTotal, "iTotalDisplayRecords" => $iFilteredTotal, "aaData" => array()); $PENYUSUTAN = new RETRIEVE_PENYUSUTAN(); $no = $_GET['iDisplayStart'] + 1; while ($value = $DBVAR->fetch_array($rResult)) { // pr($value); $NamaSatker = $PENYUSUTAN->getNamaSatker($value['SatkerUsul']); $jumlahAset = $PENYUSUTAN->getJmlAset($value['Penyusutan_ID']); if ($jumlahAset[0] == 0) { $FixjmlAset = 0; } else { $FixjmlAset = $jumlahAset[0]; } // pr($jumlahAset); $change = $value['TglPenyusutan']; $change2 = format_tanggal_db3($change); // echo "$change2"; if ($value['SatkerUsul']) {
} } // echo $sQuery; $rResultTotal = $DBVAR->query($sQuery) or fatal_error('MySQL Error: ' . mysql_errno()); $jmlData = ""; while ($aResultTotal = $DBVAR->fetch_array($rResultTotal)) { $jmlData = $jmlData + $aResultTotal['jml']; } $iTotal = $jmlData; /* * Output */ $output = array("sEcho" => intval($_GET['sEcho']), "iTotalRecords" => $iTotal, "iTotalDisplayRecords" => $iFilteredTotal, "aaData" => array()); $no = $_GET['iDisplayStart'] + 1; //ini buat apluserlist $PENYUSUTAN = new RETRIEVE_PENYUSUTAN(); $data_post = $PENYUSUTAN->apl_userasetlistHPS("USULASET"); $POST = $PENYUSUTAN->apl_userasetlistHPS_filter($data_post); // $POST['kirfilter']=$POST; // pr($POST); if ($POST) { /*if($rResultGetDataApluserlist){ $data[]=$POST; }else{*/ foreach ($rResultGetDataApluserlist as $key => $value) { if (!in_array($value['Aset_ID'], $POST)) { $data[] = $value; $data[$key]['checked'] = ""; } else { $data[] = $value; $data[$key]['checked'] = "checked";
$SessionUser = $SESSION->get_session_user(); $USERAUTH->FrontEnd_check_akses_menu($menu_id, $SessionUser); include"$path/meta.php"; include"$path/header.php"; include"$path/menu.php"; $kodeKelompok = $_POST['kodeKelompok']; $flagPnystn = $_POST['flagPnystn']; $Usulan_ID = $_POST['Usulan_ID']; $Satker_ID = $_POST['Satker_ID']; $par_data_table = "kodeKelompok={$kodeKelompok}&flagPnystn={$flagPnystn}&Usulan_ID={$Usulan_ID}&Satker_ID={$Satker_ID}"; // echo $par_data_table; // exit; $PENYUSUTAN = new RETRIEVE_PENYUSUTAN; $FlagUsulan=$PENYUSUTAN->getUsulanKet($Usulan_ID,$Satker_ID); ?> <script> jQuery(function($) { AreAnyCheckboxesChecked(); }); function AreAnyCheckboxesChecked () { setTimeout(function() { if ($("#Form2 input:checkbox:checked").length > 0) { $("#submit").removeAttr("disabled"); updDataCheckbox('USULASET'); }
$rResultFilterTotal = $DBVAR->query($sQuery) or fatal_error('MySQL Error: ' . mysql_errno()); $aResultFilterTotal = $DBVAR->fetch_array($rResultFilterTotal); $iFilteredTotal = $aResultFilterTotal[0]; // echo $iFilteredTotal ; /* Total data set length */ $sQuery = "\n\t\tSELECT COUNT(`" . $sIndexColumn . "`)\n\t\tFROM {$sTable} {$sWhere} {$QueryHandler}\n\t"; $rResultTotal = $DBVAR->query($sQuery) or fatal_error('MySQL Error: ' . mysql_errno()); $aResultTotal = $DBVAR->fetch_array($rResultTotal); $iTotal = $aResultTotal[0]; /* * Output */ $output = array("sEcho" => intval($_GET['sEcho']), "iTotalRecords" => $iTotal, "iTotalDisplayRecords" => $iFilteredTotal, "aaData" => array()); $no = $_GET['iDisplayStart'] + 1; //ini buat apluserlist $PENYUSUTAN = new RETRIEVE_PENYUSUTAN(); $data_post = $PENYUSUTAN->apl_userasetlistHPS("PNTPNUSULASET"); // pr($data_post); $POST = $PENYUSUTAN->apl_userasetlistHPS_filter($data_post); // pr($POST); // $POST['kirfilter']=$POST; // pr($POST); if ($POST) { foreach ($rResultGetDataApluserlist as $key => $value) { if (!in_array($value['Usulan_ID'], $POST)) { $data[] = $value; $data[$key]['checked'] = ""; } else { $data[] = $value; $data[$key]['checked'] = "checked"; }
<?php include "../../config/config.php"; $data = $_POST; $PENYUSUTAN = new RETRIEVE_PENYUSUTAN; $InputUsulan=$PENYUSUTAN->UpdateUsulan($data); echo "<script> alert('Data Berhasil Disimpan'); </script>"; redirect($url_rewrite.'/module/penyusutan/dftr_usulan_pnystn.php?pid=1'); ?>
<?php include "../../config/config.php"; $data = $_POST; $PENYUSUTAN = new RETRIEVE_PENYUSUTAN; $InputUsulan=$PENYUSUTAN->InputUsulan($data); echo "<script> alert('Data Berhasil Disimpan'); </script>"; redirect($url_rewrite.'/module/penyusutan/dftr_usulan_pnystn.php?pid=1'); ?>
<?php include "../../config/config.php"; $menu_id = 64; $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); include"$path/meta.php"; include"$path/header.php"; include"$path/menu.php"; $id = $_GET['id']; $PENYUSUTAN = new RETRIEVE_PENYUSUTAN; $data = $PENYUSUTAN->editDataPenetapan($id); ?> <script> jQuery(function($){ $("select").select2(); $("#TglPenyusutan").mask('9999-99-99'); $("#TglPenyusutan").datepicker({ dateFormat: 'yy-mm-dd' }); }); </script> <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 Penyusutan</li> <?php SignInOut();?> </ul>
<?php include "../../config/config.php"; $data = $_POST; $PENYUSUTAN = new RETRIEVE_PENYUSUTAN(); $InputUsulan = $PENYUSUTAN->InputPenetapan($data); echo "<script>\n\t\t\talert('Data Berhasil Disimpan');\n\t\t</script>"; redirect($url_rewrite . '/module/penyusutan/dftr_penetapan_pnystn.php?pid=1');
<?php include "../../config/config.php"; $menu_id = 64; $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); include"$path/meta.php"; include"$path/header.php"; include"$path/menu.php"; $Usulan_ID =$_GET['idUsulan']; $Satker_ID =$_GET['satker']; $PENYUSUTAN = new RETRIEVE_PENYUSUTAN; $data_delete=$PENYUSUTAN->apl_userasetlistHPS_del("USULASET"); ?> <script> jQuery(function($){ $("select").select2(); }); function check (){ var kodeKelompok = document.getElementById("kodeKelompok").value; var split_str = kodeKelompok.split("."); var kodeKelompokSplit = split_str[0]; // alert(kodeKelompok); if(kodeKelompok == ''){ alert('Pilih Jenis Aset'); return false; }else if(kodeKelompokSplit == '01' || kodeKelompokSplit == '05' || kodeKelompokSplit == '06' || kodeKelompokSplit == '07' || kodeKelompokSplit == '08'){
<?php include "../../config/config.php"; $menu_id = 64; $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); include "{$path}/meta.php"; include "{$path}/header.php"; include "{$path}/menu.php"; $PENYUSUTAN = new RETRIEVE_PENYUSUTAN(); $id_usulanPenetapan = $_POST['id_usulanPenetapan']; $implodeUsulan = implode(',', $id_usulanPenetapan); $Penyusutan_ID = $_POST['Penyusutan_ID']; $Satker_ID = $_POST['Satker_ID']; $deleteapluserlist = $PENYUSUTAN->apl_userasetlistHPS_del("PNTPNUSULASET"); //update Penetapan_ID dan StatusPenetapan di tabel usulan $Update_Penetapan_ID_StatusPenetapan = $PENYUSUTAN->Update_Penetapan_ID_StatusPenetapan($id_usulanPenetapan, $Penyusutan_ID); //update Usulan_ID di tabel penyusutan $Update_Usulan_ID = $PENYUSUTAN->Update_Usulan_ID($implodeUsulan, $Penyusutan_ID); // select ket Penetapan penyusutan $FlagPenetapan = $PENYUSUTAN->getPenetapanKet($Penyusutan_ID, $Satker_ID); $par_data_table = "id_usulanPenetapan={$implodeUsulan}&Penyusutan_ID={$Penyusutan_ID}&Satker_ID={$Satker_ID}"; // echo $par_data_table; // exit; ?> <script> jQuery(function($) { AreAnyCheckboxesChecked(); });
<?php include "../../config/config.php"; $menu_id = 64; $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); include"$path/meta.php"; include"$path/header.php"; include"$path/menu.php"; $id = $_GET['id']; $PENYUSUTAN = new RETRIEVE_PENYUSUTAN; $data = $PENYUSUTAN->editData($id); ?> <script> jQuery(function($){ $("select").select2(); $("#TglUpdate").mask('9999-99-99'); $("#TglUpdate" ).datepicker({ dateFormat: 'yy-mm-dd' }); }); </script> <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 Penyusutan</li> <?php SignInOut();?> </ul>
<?php include "../../config/config.php"; $menu_id = 64; ($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); // $PENYUSUTAN = new RETRIEVE_PENYUSUTAN; $PENYUSUTAN = new RETRIEVE_PENYUSUTAN; // pr($_POST); $noUsulan = $_POST['noUsulan']; //select Aset_ID dari tabel apl_userasetlist $data_post=$PENYUSUTAN->apl_userasetlistHPS("VIEWUSULASET"); // pr($data_post); $addExplode = explode(",",$data_post[0]['aset_list']); $cleanArray = array_filter($addExplode); $implodeAset_ID = implode(",",$cleanArray); // exit; if($implodeAset_ID != ''){ //sql sementara $QueryDelUsulanAset = "DELETE from usulanaset WHERE Usulan_ID = '$noUsulan' and Aset_ID in ($implodeAset_ID)"; $ExeDelUsulanAset = $DBVAR->query($QueryDelUsulanAset); //cek field Aset_ID $QueryAsetCek = "select Aset_ID from usulan WHERE Usulan_ID = '$noUsulan'"; $ExeQueryAcek = $DBVAR->query($QueryAsetCek); $ResultCek = $DBVAR->fetch_object($ExeQueryAcek); $arrResultCek = explode(',',$ResultCek->Aset_ID);
include "../../config/config.php"; $menu_id = 64; ($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); include"$path/meta.php"; include"$path/header.php"; include"$path/menu.php"; $Penetapan_ID = $_GET['id']; $Satker_ID = $_GET['satker']; $par_data_table = "Penetapan_ID={$Penetapan_ID}"; $PENYUSUTAN = new RETRIEVE_PENYUSUTAN; $FlagPenetapan=$PENYUSUTAN->getPenetapanKet($Penetapan_ID,$Satker_ID); $Tgl=$FlagPenetapan['TglPenyusutan']; $TglFix= format_tanggal_db3($Tgl); ?> <!-- End Sql --> <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 Penyusutan</li> <?php SignInOut();?> </ul> <div class="breadcrumb"> <div class="title">Usulan Penghapusan Penyusutan</div>
$sQuery = "\n\t\tSELECT FOUND_ROWS()\n\t"; $rResultFilterTotal = $DBVAR->query($sQuery) or fatal_error('MySQL Error: ' . mysql_errno()); $aResultFilterTotal = $DBVAR->fetch_array($rResultFilterTotal); $iFilteredTotal = $aResultFilterTotal[0]; // echo $iFilteredTotal ; /* Total data set length */ $sQuery = "\n\t\tSELECT COUNT(`" . $sIndexColumn . "`)\n\t\tFROM {$sTable} {$sWhere}\n\t"; // echo $sQuery; $rResultTotal = $DBVAR->query($sQuery) or fatal_error('MySQL Error: ' . mysql_errno()); $aResultTotal = $DBVAR->fetch_array($rResultTotal); $iTotal = $aResultTotal[0]; /* * Output */ $output = array("sEcho" => intval($_GET['sEcho']), "iTotalRecords" => $iTotal, "iTotalDisplayRecords" => $iFilteredTotal, "aaData" => array()); $PENYUSUTAN = new RETRIEVE_PENYUSUTAN(); $no = $_GET['iDisplayStart'] + 1; while ($value = $DBVAR->fetch_array($rResult)) { // pr($value); $NamaSatker = $PENYUSUTAN->getNamaSatker($value[SatkerUsul]); // pr($NamaSatker); $totalNilaiPerolehan = $PENYUSUTAN->TotalNilaiPerolehan($value[Aset_ID]); // pr($totalNilaiPerolehan); if (!empty($value[Aset_ID])) { $jmlh = explode(",", $value[Aset_ID]); $jumlahAset = count($jmlh); } else { $jumlahAset = 0; } $change = $value[TglUpdate]; $change2 = format_tanggal_db3($change);