';
}
while ($row1 = mysqli_fetch_row ($res1)) {
}
$sql = "select *
from goods_stock
where goods_code = '$goods_code' and
buy_seq_no = '$buy_seq_no'
";
if (!$res=mysqli_query($dbh, $sql)) {
echo '
';
}
if ($row = mysqli_fetch_row ($res)) {
$sql = "update goods_stock set
unit_buy_price = '$unit_buy_price_max',
total_quantity_buy = '$total_quantity_buy',
last_update_by = '$last_update_by',
last_update_date = '$last_update_date',
last_ip_address =$last_ip_address'
";
if (!$res=mysqli_query($dbh, $sql)) {
echo '
';
}
} else {
$sql = "Insert into goods_stock
(
goods_code,
buy_seq_no,
unit_buy_price,
total_quantity_buy,
last_update_by,
last_update_date,
last_ip_address
)
values
(
'$goods_code',
'$buy_seq_no',
'$unit_buy_price_max',
'$total_quantity_buy',
'$last_update_by',
'$last_update_date',
'$last_ip_address'
)
";
if (!$res=mysqli_query($dbh, $sql)) {
echo '
';
}
}
// ----------------------------------------------------
// Perbaikan Stok Penjualan
// ----------------------------------------------------
mysql_close($dbh);
echo '
';