49 lines
1.7 KiB
PHP
49 lines
1.7 KiB
PHP
<?php
|
|
|
|
/*******************************************************************
|
|
|
|
App. Name : Inventory Advanced Systems
|
|
Module : /apps/php/func/biaya.php
|
|
Desc. : PHP - Fungsi - Fungsi Biaya
|
|
Created By : Siau Pheng ([email protected]).
|
|
Created Date : May 1st, 2012.
|
|
Last Modified : January 6th, 2025.
|
|
|
|
(c) 2012 - 2025, 3FONIA Software; WWW.3FONIA.COM.
|
|
|
|
*******************************************************************/
|
|
|
|
require_once(__DIR__."/../../../../../vendor/autoload.php");
|
|
|
|
use siaupheng\fonia3\DB\MySQL;
|
|
use siaupheng\fonia3\DB\SQL;
|
|
|
|
$fdb = (is_resource($fdb)) ? $fdb : new MySQL();
|
|
|
|
function Biaya_Copy($no_bia = "") {
|
|
global $fdb;
|
|
if ($no_bia == "") return;
|
|
Biaya_Cancel($no_bia);
|
|
$fdb->Query("INSERT INTO tmp_biaya_detail (No_Biaya,ID,Uraian_Biaya,Qty,Harga_Jual,PPN,UserID) SELECT No_Biaya,ID,Uraian_Biaya,Qty,Harga_Jual,PPN,UserID FROM biaya_pajak_detail WHERE No_Biaya='".$no_bia."'");
|
|
}
|
|
|
|
function Biaya_Save($no_bia = "", $is_baru = false, $no_lama = "", $ppn = 0) {
|
|
global $fdb;
|
|
if ($no_bia == "") return;
|
|
$fdb->Query("DELETE FROM biaya_pajak_detail WHERE No_Biaya='".$no_bia."'");
|
|
if ($is_baru) {
|
|
Biaya_Cancel($no_bia);
|
|
$fdb->Query("UPDATE tmp_biaya_detail SET No_Biaya='".$no_bia."' WHERE No_Biaya='".$no_lama."'");
|
|
}
|
|
$fdb->Query("INSERT INTO biaya_pajak_detail (No_Biaya,ID,Uraian_Biaya,Qty,Harga_Jual,PPN,UserID) SELECT No_Biaya,ID,Uraian_Biaya,Qty,Harga_Jual,'".$ppn."',UserID FROM tmp_biaya_detail WHERE No_Biaya='".$no_bia."'");
|
|
Biaya_Cancel($no_bia);
|
|
}
|
|
|
|
function Biaya_Cancel($no_bia = "") {
|
|
global $fdb;
|
|
if ($no_bia == "") return;
|
|
$fdb->Query("DELETE FROM tmp_biaya_detail WHERE No_Biaya='".$no_bia."'");
|
|
}
|
|
|
|
?>
|