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 "

"; echo "

Informasi

"; echo "Simpan Data Penerimaan Barang Berhasil."; echo ""; ?>