52 lines
1.7 KiB
PHP
52 lines
1.7 KiB
PHP
<?php
|
|
include("../core/main.php");
|
|
include("inc/function.php");
|
|
|
|
$ip = getRealIpAddr();
|
|
$sql = "SELECT NO, NIP, kodebarang,
|
|
pengirim, tglterima,
|
|
jmlterima, terimadari,
|
|
KATEGORY
|
|
FROM
|
|
temp_cartbarang_penerimaan
|
|
WHERE IP = '$ip' AND KATEGORY='L'";
|
|
|
|
$row = $db->query($sql);
|
|
if(count($row) > 0){
|
|
foreach($row->fetchAll() as $data){
|
|
$no = $data['NO'];
|
|
$nip = $data['NIP'];
|
|
$kd_barang = $data['kodebarang'];
|
|
$pengirim = $data['pengirim'];
|
|
$tgl_terima = $data['tglterima'];
|
|
$jml_terima = $data['jmlterima'];
|
|
$jns = $data['terimadari'];
|
|
$kategori = $data['KATEGORY'];
|
|
$db->query("INSERT INTO t_penerimaan_barang (NO, NIP, kodebarang, pengirim, tglterima,
|
|
jmlterima, jnsterima, KATEGORY)
|
|
VALUES('$no', '$nip', '$kd_barang', '$pengirim', '$tgl_terima',
|
|
$jml_terima, '$jns', '$kategori')");
|
|
|
|
$sqlsaldo = "SELECT saldo FROM t_barang_stok WHERE kode_barang = '$kd_barang'
|
|
ORDER BY tanggal DESC, kd_stok DESC LIMIT 1";
|
|
$get = $db->query($sqlsaldo);
|
|
$saldodata = $get->fetchAll()[0];
|
|
|
|
if($get->numRows() > 0){
|
|
$saldo = $saldodata['saldo'] + $jml_terima;
|
|
}else{
|
|
$saldo = $jml_terima;
|
|
}
|
|
|
|
$db->query("INSERT INTO t_barang_stok (kode_barang, tanggal, masuk, saldo)
|
|
VALUES ('$kd_barang', '$tgl_terima', '$jml_terima', '$saldo')");
|
|
}
|
|
}
|
|
|
|
|
|
$db->query("DELETE FROM temp_cartbarang_penerimaan WHERE IP = '$ip'");
|
|
echo "<fieldset class='fieldset'>";
|
|
echo "<legend>Informasi</legend>";
|
|
echo "Simpan Data Penerimaan Barang Berhasil.";
|
|
echo "</legend>";
|
|
?>
|