<?php
include 'config.php'; // Include your database connection file

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $name = trim($_POST['name'] ?? '');
    $form = trim($_POST['form'] ?? '');
    $size = trim($_POST['size'] ?? '');
    $bulk_packaging = trim($_POST['bulk_packaging'] ?? '');
    $quantity = isset($_POST['quantity']) ? (int)$_POST['quantity'] : 0;

    // Validate input
    $errors = [];
    if (empty($name)) $errors[] = "Chemical Name is required.";
    if (empty($form)) $errors[] = "Form is required.";
    if (empty($size)) $errors[] = "Size is required.";
    if (empty($bulk_packaging)) $errors[] = "Bulk Packaging is required.";
    if ($quantity <= 0) $errors[] = "Quantity must be greater than zero.";

    if (!empty($errors)) {
        echo "<script>alert('" . implode("\n", $errors) . "'); window.history.back();</script>";
        exit;
    }

    // Insert data into database
    $sql = "INSERT INTO finished_goods (name, form, size, bulk_packaging, quantity) VALUES (?, ?, ?, ?, ?)";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("ssssi", $name, $form, $size, $bulk_packaging, $quantity);

    if ($stmt->execute()) {
        echo "<script>alert('Finished goods added successfully!'); window.location.href='finished_goods.php';</script>";
    } else {
        echo "<script>alert('Error adding finished goods. Please try again.'); window.history.back();</script>";
    }

    $stmt->close();
    $conn->close();
} else {
    echo "<script>alert('Invalid request.'); window.location.href='finished_goods.php';</script>";
}