61 lines
1.9 KiB
PHP
61 lines
1.9 KiB
PHP
<?php
|
|
include("../core/main.php");
|
|
include("inc/function.php");
|
|
|
|
if(!empty($_GET['idxbarang'])){
|
|
$idxbarang = $_GET['idxbarang'];
|
|
$nip = $_SESSION['NIP'];
|
|
if($_GET['opt']=="2"){
|
|
$db->query("UPDATE t_permintaan_barang SET statusacc = '2',
|
|
NIP_keluar = '".$nip."'
|
|
WHERE IDXBARANG = '$idxbarang'");
|
|
echo "Tidak disetujui";
|
|
}else if($_GET['opt']=="1"){
|
|
if(!empty($_GET['jml'])){
|
|
$jml = $_GET['jml'];
|
|
}else{
|
|
$sqlobatjml = "SELECT t_permintaan_barang.jumlahpesan
|
|
FROM
|
|
t_permintaan_barang
|
|
WHERE t_permintaan_barang.IDXBARANG = '$idxbarang'";
|
|
$getobatjml = $db->query($sqlobatjml);
|
|
$datajmlobat = $getobatjml->fetchAll()[0];
|
|
$jml = $datajmlobat['jumlahpesan'];
|
|
}
|
|
|
|
$tgl = date("Y-m-d");
|
|
$db->query("UPDATE t_permintaan_barang SET statusacc = '1',
|
|
jmlkeluar = $jml,
|
|
tglkeluar = '$tgl',
|
|
NIP_keluar = '".$nip."'
|
|
WHERE IDXBARANG = '$idxbarang'");
|
|
|
|
$sqlobatdetail = "SELECT t_permintaan_barang.kodebarang,
|
|
t_permintaan_barang.jmlkeluar,
|
|
t_permintaan_barang.tglkeluar
|
|
FROM
|
|
t_permintaan_barang
|
|
WHERE t_permintaan_barang.IDXBARANG = '$idxbarang'";
|
|
|
|
$getobatdetail = $db->query($sqlobatdetail);
|
|
$datadetailobat = $getobatdetail->fetchAll()[0];
|
|
$qty_obat = $datadetailobat['jmlkeluar'];
|
|
$tgl_obat = $datadetailobat['tglkeluar'];
|
|
$kode_obat = $datadetailobat['kodebarang'];
|
|
|
|
$sqlsaldo = "SELECT saldo FROM t_barang_stok
|
|
WHERE kode_barang = '$kode_obat'
|
|
ORDER BY tanggal DESC, kd_stok DESC LIMIT 1";
|
|
$get = $db->query($sqlsaldo);
|
|
$saldodata = $get->fetchAll()[0];
|
|
if($get->numRows() > 0){
|
|
$saldo = $saldodata['saldo'] - $qty_obat;
|
|
}else{
|
|
$saldo = 0 - $qty_obat;
|
|
}
|
|
$db->query("INSERT INTO t_barang_stok (kode_barang, tanggal, keluar, saldo)
|
|
VALUES ('$kode_obat', '$tgl_obat', '$qty_obat', '$saldo')");
|
|
echo "Sudah disetujui";
|
|
}
|
|
}
|
|
?>
|