PHP RETRIEVE_PENYUSUTAN Exemples

Exemple #1

Fichier : proses_penetapan_pynstn_aset.php Projet : TrinataBhayanaka/simbada-tangsel

<?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

Exemple #2

<?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');

Exemple #3

Fichier : proses_penetapan_pynstn_edit.php Projet : TrinataBhayanaka/simbada-tangsel

<?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');
?>

Exemple #4

Fichier : api_penetapan_pnyst.php Projet : TrinataBhayanaka/simbada-tangsel

// /* 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']) {

Exemple #5

Fichier : api_usulan_pnyst_daftar.php Projet : TrinataBhayanaka/simbada-tangsel

    }
}
// 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";

Exemple #6

Fichier : dftr_usulan_pnystn_filter.php Projet : TrinataBhayanaka/simbada-tangsel

$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');
			}

Exemple #7

Fichier : api_penetapan_pnyst_daftar.php Projet : TrinataBhayanaka/simbada-tangsel

$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";
        }

Exemple #8

Fichier : proses_usulan_pynstn_edit.php Projet : TrinataBhayanaka/simbada-tangsel

<?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');
?>

Exemple #9

Fichier : proses_usulan_pynstn.php Projet : TrinataBhayanaka/simbada-tangsel

<?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');
?>

Exemple #10

Fichier : buat_aset_penetapan_pnystn_edit.php Projet : TrinataBhayanaka/simbada-tangsel

<?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>&raquo;</b></span></li>
			  <li><a href="#">Penghapusan</a><span class="divider"><b>&raquo;</b></span></li>
			  <li class="active">Daftar Usulan Penyusutan</li>
			  <?php SignInOut();?>
			</ul>

Exemple #11

<?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');

Exemple #12

Fichier : filter_aset_usulan_pnystn.php Projet : TrinataBhayanaka/simbada-tangsel

<?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'){

Exemple #13

<?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();
	});
		

Exemple #14

Fichier : buat_aset_usulan_pnystn_edit.php Projet : TrinataBhayanaka/simbada-tangsel

<?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>&raquo;</b></span></li>
			  <li><a href="#">Penghapusan</a><span class="divider"><b>&raquo;</b></span></li>
			  <li class="active">Daftar Usulan Penyusutan</li>
			  <?php SignInOut();?>
			</ul>

Exemple #15

Fichier : proses_usulan_pynstn_aset_view.php Projet : TrinataBhayanaka/simbada-tangsel

<?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);

Exemple #16

Fichier : view_aset_penetapan_pnystn.php Projet : TrinataBhayanaka/simbada-tangsel

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>&raquo;</b></span></li>
			  <li><a href="#">Penghapusan</a><span class="divider"><b>&raquo;</b></span></li>
			  <li class="active">Daftar Usulan Penyusutan</li>
			  <?php SignInOut();?>
			</ul>
			<div class="breadcrumb">
				<div class="title">Usulan Penghapusan Penyusutan</div>

Exemple #17

Fichier : api_usulan_pnyst.php Projet : TrinataBhayanaka/simbada-tangsel

$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);