// InventoryController.ts

import { db } from "@/lib/db"

export async function updateStock(productName: string, quantitySold: number) {
  const product = await db.products.findFirst({
    where: { name: productName },
  })

  if (!product) {
    throw new Error(`Product "${productName}" not found.`)
  }

  const newStock = product.stock - quantitySold

  await db.products.update({
    where: { id: product.id },
    data: { stock: newStock },
  })

  return `✅ ${quantitySold} units of ${product.name} deducted. ${newStock} left in stock.`
}