<?php
include 'config.php';

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $product_id = $_POST['product_id'];
    $quantity = $_POST['quantity'];

    // Fetch product details
    $productQuery = $conn->query("SELECT * FROM finished_goods WHERE id = $product_id");
    $product = $productQuery->fetch_assoc();

    if ($product['quantity'] < $quantity) {
        echo "Insufficient stock!";
        exit;
    }

    // Deduct from Finished Goods
    $conn->query("UPDATE finished_goods SET quantity = quantity - $quantity WHERE id = $product_id");

    // Deduct Packaging Materials (Example: Sack or Carton)
    if ($product['bulk_packaging'] == 'Sack') {
        $conn->query("UPDATE packaging_materials SET quantity = quantity - 1 WHERE type = 'Sack'");
    } else {
        $conn->query("UPDATE packaging_materials SET quantity = quantity - 1 WHERE type = 'Carton'");
    }

    // Record Sale
    $conn->query("INSERT INTO sales (product_id, quantity, sale_date) VALUES ($product_id, $quantity, NOW())");

    echo "Sale recorded successfully!";
}
?>